Category - SQL Server
Results 1 - 5 of 80
13 Dec 2014
1 Comments   604 Views
Here Mudassar Ahmed Khan has explained how to insert (save) Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil and Telugu languages Text characters in SQL Server database using ASP.Net, C# and VB.Net.

In SQL Server database we will need to use NVARCHAR data type to store the various languages text characters.
02 Dec 2014
1 Comments   764 Views
Here Mudassar Ahmed Khan explained how to pass comma separated (delimited) values as Parameter to Stored Procedure in SQL Server.

The comma separated (delimited) values will be split into Table rows and will be used for querying inside the SQL Server Stored Procedure.
14 Nov 2014
0 Comments   1491 Views
Here Mudassar Ahmed Khan has explained how to create an Excel file using the data (records) from SQL Server Table and then download it in ASP.Net using C# and VB.Net.
03 Oct 2014
0 Comments   7359 Views
Here Mudassar Ahmed Khan has explained how to import / upload CSV file data to SQL Server database in ASP.Net using C# and VB.Net.

The CSV file data will be inserted into SQL Server database table using the SqlBulkCopy class.
24 Sep 2014
0 Comments   2575 Views
Here Mudassar Ahmed Khan has explained how to export data (records) from SQL Server Table to Text (Notepad) file in ASP.Net using C# and VB.Net. This article will work for all SQL Server versions i.e. 2005, 2008, 2008R2, 2012, etc.

The data will be first fetched into a DataTable and then the DataTable will be exported to a Text file which can be viewed in Notepad.
Results 1 - 5 of 80