SQL Server Articles

: SQL Server

Using Parameterized queries to prevent SQL Injection Attacks in SQL Server

Author: Mudassar Khan
Filed Under: C#.Net | VB.Net | SQL Server

Published Date: Feb 19, 2008
Views: 29171

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to use parameterized queries to query SQL Server database in order to avoid SQL Injection attacks

Parameterized Queries ADO.Net

Author: Mudassar Khan
Filed Under: ADO.Net | SQL Server

Published Date: Feb 09, 2009
Views: 5120

Demo: View Demo

Abstract: here Mudassar Ahmed Khan explain Parameterized Queries ADO.Net

Send SMTP Email using SQL Server

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: Feb 12, 2009
Views: 18886

Demo: View Demo

Abstract: Send SMTP Email using SQL Server

Save and Retrieve Files from SQL Server Database using ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | C#.Net | VB.Net | SQL Server

Published Date: Feb 19, 2009
Views: 113178

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to save file as binary data inside SQL Server database and also how to retreive them and reconvert to their respective formats using VB.net amd C#.

Display Images from SQL Server Database using ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | C#.Net | VB.Net | SQL Server

Published Date: Feb 21, 2009
Views: 100890

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to retrieve and display images that are stored in SQL Server Database in ASP.Net Web application

Automated Email Notifications using SQL Server Job Schedular

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: Mar 08, 2009
Views: 38208

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has described how to easily send automated email notifications from the SQL Server database using job schedular

Save Files to SQL Server Database using FileUpload Control

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server

Published Date: Apr 08, 2009
Views: 71631

Demo: View Demo

Abstract: Mudassar Ahmed Khan has explained how to save file to database directly using File Upload Control in ASP.Net

Display Images in GridView Control using the path stored in SQL Server database

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | GridView

Published Date: Apr 20, 2009
Views: 35912

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has described how to store images on disk and their path in images and then display them in GridView control in ASP.Net. Thus making your own Image or Picture Gallery

Display images from SQL Server Database in ASP.Net GridView control

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | GridView

Published Date: Apr 20, 2009
Views: 89737

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to build an Image Gallery to display images from SQL Server Database using the GridView control in ASP.Net

Export GridView with Images to Word Excel and PDF Formats in ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | GridView

Published Date: Apr 23, 2009
Views: 37381

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to Export a GridView with Images or Pictures to Word Excel or PDF Formats in ASP.Net. In this article the GridView is displaying images stored on disk and th

Using Stored Procedures in SQL Server Database

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: May 07, 2009
Views: 7088

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to create modify and delete Stored Procedures in Microsoft SQL Server Database

Exception - A network-related or instance-specific error occurred.. in SQL Server

Author: Mudassar Khan
Filed Under: SQL Server | Issues and Exceptions

Published Date: May 08, 2009
Views: 35100

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to resolve the exception A network-related or instance-specific error occurred while connecting to SQL Server Database

Exception - error 26 - Error Locating Server Instance Specified

Author: Mudassar Khan
Filed Under: SQL Server | Issues and Exceptions

Published Date: May 09, 2009
Views: 14450

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to resolve the exception SQL Network Interfaces error: 26 - Error Locating ServerInstance Specified while connecting to SQL Server Database.

Tip Query to get all column names from database table in SQL Server

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: May 09, 2009
Views: 8903

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained How to retrieve column names from a database table using SQL Query in SQL Server Database

Tip Pass table name dynamically to SQL Server query or stored procedure

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: May 13, 2009
Views: 8145

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to dynamically pass table name to SQL Query or Stored Procedure in SQL Server 2000 2005 2008

Transfer SQL Server Database from Local to Server using Database Backup

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: May 24, 2009
Views: 4186

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to transfer or publish your ASP.Net website database from your local machine onto the server by creating a database backup in SQL Server

Calling Insert SQL Server Stored Procedures using ADO.Net

Author: Mudassar Khan
Filed Under: ADO.Net | SQL Server

Published Date: May 26, 2009
Views: 16068

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to call Insert SQL Server Stored Procedures using ADO.Net in as ASP.Net Web Application

Calling Select SQL Server Stored Procedures using ADO.Net

Author: Mudassar Khan
Filed Under: ADO.Net | SQL Server

Published Date: May 26, 2009
Views: 12259

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to call Select SQL Server Stored Procedures using ADO.Net in as ASP.Net Web Application and also how to bind the data returned by the stored procedures to AS

Getting ID of the newly inserted record in SQL Server Database using ADO.Net

Author: Mudassar Khan
Filed Under: ADO.Net | SQL Server

Published Date: May 27, 2009
Views: 18965

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to get ID of newly inserted record in ASP.Net Web application using ADO.Net

Calling Update SQL Server Stored Procedures using ADO.Net

Author: Mudassar Khan
Filed Under: ADO.Net | SQL Server

Published Date: May 29, 2009
Views: 13409

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to call stored procedures that update the data in SQL Server Database using ADO.Net

Read and Import Excel Sheet into SQL Server Database in ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | Excel | SQL Server

Published Date: Jun 06, 2009
Views: 66354

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to import Excel Sheet Data into SQL Server Database table using ADO.Net in an ASP.Net Web application

The OLE DB provider Microsoft.Ace.OLEDB.12.0 for linked server (null)

Author: Mudassar Khan
Filed Under: SQL Server | Issues and Exceptions

Published Date: Jun 06, 2009
Views: 32748

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has provided solutions to the issue The OLE DB provider ampquotMicrosoft.Ace.OLEDB.12.0ampquot for linked server ampquot(null)ampquot reported an error. Access denied. while

Save and Retrieve Dynamic TextBox values in GridView to SQL Server Database

Author: Vinz
Filed Under: ASP.Net | SQL Server | GridView

Published Date: Aug 16, 2009
Views: 29053

Demo: View Demo

Abstract: Here Vinz has explained how to Save and Retrieve Dynamic TextBox values in GridView to SQL Server Database in ASP.Net Web Application

Select SQL Server Stored Procedures using ASP.Net Example

Author: Mudassar Khan
Filed Under: ASP.Net | ADO.Net | SQL Server

Published Date: Sep 22, 2012
Views: 7036

Demo: View Demo

Bind data to ASP.Net GridView using Stored Procedure

Author: Mudassar Khan
Filed Under: ASP.Net | ADO.Net | SQL Server

Published Date: Sep 23, 2012
Views: 8448

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to bind data to GridView using Stored Procedure in ASP.Net

Using SQLCommand ExecuteReader Example in ASP.Net with C# and VB.Net

Author: Mudassar Khan
Filed Under: ASP.Net | ADO.Net | SQL Server

Published Date: Sep 23, 2012
Views: 2875

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example with attached sample source code, how to use SQLCommand ExecuteReader function to fetch data from SQL Server database in ASP.Net using C# and VB.Net and ADO.Net

How to bind GridView with DataReader in ASP.Net using C# and VB.Net

Author: Mudassar Khan
Filed Under: ASP.Net | ADO.Net | SQL Server

Published Date: Sep 26, 2012
Views: 6017

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example with attached sample source code, how to bind GridView with data using SQLCommand DataReader in ASP.Net with C# and VB.Net.

Save MP3 Audio Files to database and display in ASP.Net GridView with Play and Download option

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server

Published Date: Sep 28, 2012
Views: 9477

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained how to upload and store MP3 Audio Files to database and then retrieve it and display in ASP.Net GridView with Play and Download option using C# and VB.Net.
For playing the MP3 Audio files he has used Flash Music player

Bind GridView using SqlDataSource Programmatically from code in ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | GridView

Published Date: Oct 05, 2012
Views: 9162

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to bind and populate ASP.Net GridView from SQL Server DataBase using SqlDataSource programmatically from code behind class using C# and VB.Net.

Here he has created the SQLDataSource in code behind dynamically and also setting the properties of SQLDataSource such as ID, ConnectionString and SelectCommand.

How to Import Excel Sheet data into SQL Server using ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | Excel | SQL Server

Published Date: Dec 20, 2012
Views: 3037

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to Import Excel Sheet data and records into SQL Server 2005, 2008, 2012 using ASP.Net

How to upload data from Excel to SQL Server in ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | Excel | SQL Server

Published Date: Dec 20, 2012
Views: 1551

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to upload data or records from Excel File after reading sheet contents to SQL Server in ASP.Net.

Insert Word Document Files into SQL Server Database Table using C# and VB.Net

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server

Published Date: Jan 14, 2013
Views: 5219

Demo: View Demo

Abstract: Mudassar Ahmed Khan has explained with an example and attached sample code,
how to insert Word (.DOC and .DOCX) and excel document files into SQL Server Database directly using File Upload Control in ASP.Net

How to import data from Excel to SQL Server 2008 using ASP.Net

Author: Mudassar Khan
Filed Under: ASP.Net | Excel | SQL Server

Published Date: Jan 14, 2013
Views: 2848

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to Import or insert Excel Sheet data and records into SQL Server 2005, 2008, 2012 using ASP.Net

Install Microsoft Northwind and Pubs Sample databases in SQL Server Management Studio

Author: Mudassar Khan
Filed Under: SQL Server

Published Date: Feb 09, 2013
Views: 1395

Demo: View Demo

Abstract: 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 database server using the SQL Server Management Studio.

ASP.Net: Populate Google Maps V3 with Multiple Markers using Address Latitude and Longitude values stored in database

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | Google

Published Date: Mar 04, 2013
Views: 1803

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to populate Google Maps V3 with Multiple Markers using Address Latitude and Longitude values stored in SQL Server database in ASP.Net Website.

ASP.Net : Google Maps V3 with Multiple Markers Database Example

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | Google

Published Date: Mar 07, 2013
Views: 2855

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to populate Google Maps V3 with Multiple Markers using SQL Server database in ASP.Net Website.

Upload Save Retrieve and Play MP4 Video files with live streaming from Database in ASP.Net using C# and VB.Net

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | DataList

Published Date: Mar 31, 2013
Views: 2485

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code:-
1. How to upload and save videos to database in binary data format in ASP.Net using C# and VB.Net
2. How to retrieve videos from database and play with live streaming using Flash Video Player.

Return Identity ( Auto Increment ) Column value after record insert in SQL Server Database using ADO.Net with C# and VB.Net

Author: Mudassar Khan
Filed Under: ADO.Net | SQL Server

Published Date: Mar 31, 2013
Views: 1384

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to return the value of Identity (Auto Increment) Column value after record is inserted in SQL Server database using ADO.Net with C# and VB.Net.

How to save ( insert ) Image in Database in ASP.Net using C# and VB.Net

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server

Published Date: Mar 31, 2013
Views: 3431

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to upload and save (insert) images to SQL Server Database in ASP.Net using C# and VB.Net.

Display Files saved in Database Table in ASP.Net GridView with Download button

Author: Mudassar Khan
Filed Under: ASP.Net | SQL Server | GridView

Published Date: Apr 14, 2013
Views: 1316

Demo: View Demo

Abstract: Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to upload and save files to SQL Server Database table using File Upload control and then display the saved files in ASP.Net GridView with Download button, to download the saved file from database

ASP.Net	C#.Net	JavaScript	ADO.Net
Excel	AJAX	VB.Net	SQL Server
GridView	Issues and Exceptions	Silverlight	Rich Text Editor
JQuery	DataList	Snippets	XML
New Features	.Net 4.0	TreeView	AJAX Control Toolkit
jQuery Plugins	Third Party Controls	ASP.Net Validators	WCF
Repeater	Regular Expressions	Yahoo API	iTextSharp
FaceBook	Charts	ListView	Tweeter
Window Forms	Google	CSS	SMS
DotNetZip	Crystal Reports	Entity Framework