Category - SQL Server
Results 1 - 5 of 118
29 Jun 2015
0 Comments   422 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert (save) multiple rows (records) from DataGridView to database in Windows Forms (WinForms) Application using C# and VB.Net.
25 Jun 2015
0 Comments   475 Views
Here Mudassar Ahmed Khan has explained how to return Identity value from Stored Procedure in SQL Server.
The Identity value (ID value) of the newly (last) inserted record can be determined using @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT functions.
This article is applicable to SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014 versions.
25 Jun 2015
0 Comments   382 Views
Here Mudassar Ahmed Khan has explained the difference between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT in SQL Server.
The @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT functions return the Identity value (ID value) of the newly (last) inserted record but still there exists a difference.
This article is applicable to SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014 versions.
24 Jun 2015
0 Comments   425 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Paging DataGridView in Windows Forms (WinForms) Application using C# and VB.Net.
DataGridView control in Windows Forms (WinForms) Application does not have paging capabilities and hence Custom Paging using Stored Procedure needs to be implemented.
12 Jun 2015
0 Comments   689 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table as parameter i.e. Table Valued Parameters to Stored Procedure in SQL Server.
The User Defined Table Type has to be created in SQL Server and it must have the same schema as that of the Table Valued parameter that we need to pass to the Stored Procedure.
Results 1 - 5 of 118