Category - SQL Server
Results 1 - 10 of 69
22 Aug 2014
0 Comments   54 Views
Here Mudassar Ahmed Khan has explained how to pass XML file as parameter to Stored Procedure in C# and VB.Net.
11 Aug 2014
0 Comments   646 Views
Here Mudassar Ahmed Khan has explained how to save image as binary data into SQL Server database and also how to retrieve and convert the image back to their respective formats using C# and VB.Net.
11 Aug 2014
0 Comments   500 Views
Here Mudassar Ahmed Khan has explained how to save file as binary data inside SQL Server database and also how to retrieve them and convert them back to their respective formats using C# and VB.Net.
10 Aug 2014
0 Comments   758 Views
Here Mudassar Ahmed Khan has explained how to upload and insert XML file data using Stored Procedure in ASP.Net using C# and VB.Net.

SQL Server 2005 onwards we can pass a parameter of XML data type to the Stored Procedure and also we can easily parse the XML and extract its attribute and Inner Text of tags.
05 Aug 2014
0 Comments   647 Views
Here Mudassar Ahmed Khan has explained how to pass multiple records (rows) to a Stored Procedure in SQL Server using C# and VB.Net.
We can pass a Table containing multiple records (rows) to a Stored Procedure by making use of Table Valued parameters in SQL Server.
29 Jul 2014
0 Comments   1305 Views
Here Mudassar Ahmed Khan has explained how to populate (bind) TreeView control with Nodes having Parent Child relationship from database in ASP.Net using C# and VB.Net.

The TreeView will be populated using recursion.
16 Jul 2014
0 Comments   875 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Valued Parameters to SQL Server Stored Procedure from .Net Code Behind using ADO.Net, C# and VB.Net.
03 Jul 2014
0 Comments   1324 Views
Here Mudassar Ahmed Khan has explained how to read and write BLOBs (Binary Large Objects) data to SQL Server database using C# and VB.Net.

BLOBs include files such as Images, PDF, Word or Excel Documents, Audio, Video files. Such files are read converted to an array of bytes and inserted into SQL Server VARBINARY or IMAGE fields.
25 Jun 2014
0 Comments   748 Views
Here Mudassar Ahmed Khan has explained how to download and install the Microsoft's Northwind and Pubs databases and then attach them to the SQL Server or SQL Server Express editions.

The Northwind and Pubs databases are available for free by Microsoft and can be downloaded and used in any SQL Server or SQL Server Express version namely 2005, 2008, 2008R2 or 2012.
12 Jun 2014
2 Comments   2091 Views
Here Mudassar Ahmed Khan has explained how to send or pass DataTable as parameter to Stored Procedure in C# and VB.Net using the SQL Server User Defined Table Type.

The User Defined Table Type has to be created in SQL Server and it must have the same schema as that of the DataTable that we need to pass to the Stored Procedure as parameter.