---
title: "SqlDataSource in ASP.Net"
description: "SqlDataSource is intended to replace the ADO.NET code you would normally write in a page to create a connection and command to query a database. Becau"
author: "Pushpendra Singh"
published: 2010-11-02
updated: 2020-03-04
canonical: https://www.mindstick.com/articles/189/sqldatasource-in-asp-dot-net
category: "ado.net"
tags: ["ado.net"]
reading_time: 4 minutes
---
# SqlDataSource in ASP.Net
SqlDataSource is intended to replace the ADO.NET code you would normally write in a page to create a [connection](https://yourviews.mindstick.com/view/83497/a-40-year-old-man-has-been-arrested-in-connection-with-the-abe-shooting) and command to query a database. Because the data queries are specified directly as [properties](https://yourviews.mindstick.com/view/81845/now-it-s-possible-to-predict-properties-of-any-molecule) of the [data source](https://www.mindstick.com/forum/160659/how-do-you-create-a-custom-filter-to-filter-any-text-in-the-data-source-in-angularjs) control, this is sometimes called a two-tier model, because the data queries are still maintained in page code.\
```
```
**BindData in [GridView](https://www.mindstick.com/articles/873/update-delete-edit-gridview-in-asp-dot-net) using SqlDataSource:**
## .aspx page
```
```
Insert_reg is a StoredProcedure created in backend.which described below.In ConnectionString mycon is an object created in [Web.config](https://www.mindstick.com/forum/183/web-config-file).
**mycon is connection object created in web.config which is described below.**
## .aspx code
```
DELETE edit '> '> '> cancel update
Add
```
**RowEditing event is used to enable editing in GridView**
```
protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e){ GridView2.EditIndex = e.NewEditIndex;}
```
**RowCancelingEdit event is used to cancel edit mode.**
```
protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){ GridView2.EditIndex = -1; Response.Redirect("Default3.aspx");}
```
The zero-based index of the row to edit. EditIndex = -1, which indicates that no row is being edited.
**Add , updateand [Delete data](https://www.mindstick.com/forum/34184/how-to-insert-update-delete-data-from-database-using-c-sharp) in GridView using SqlDataSource**
The RowCommand event is raised whenever any button associated with a row in the GridView is clicked. This provides for programmatically determining which specific command [button is clicked](https://answers.mindstick.com/qa/94813/why-does-my-app-terminate-when-the-button-is-clicked-on-android-studio) and take appropriate action.
**Here this event is used for Inserting data**
```
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgse){ string strid = (TextBox) GridView2.FooterRow.FindControl("TextBox3")).Text; string strpd = ((TextBox)GridView2.FooterRow.FindControl ("TextBox4")).Text; string strname = ((TextBox)GridView2.FooterRow.FindControl ("TextBox5")).Text; SqlDataSource2.InsertParameters["id"].DefaultValue = strid; SqlDataSource2.InsertParameters["pass"].DefaultValue = strpd; SqlDataSource2.InsertParameters["name"].DefaultValue = strname; SqlDataSource2.Insert(); }
```
**Row updating event is used for updating data**
```
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e){ string strFirstName = ((TextBox) GridView2.Rows[e.RowIndex].FindControl("TextBox6")).Text; string strLastName = ((TextBox) GridView2.Rows[e.RowIndex].FindControl("txtbx1")).Text; string strDepartment = ((TextBox) GridView2.Rows[e.RowIndex].FindControl("TextBox2")).Text; SqlDataSource2.UpdateParameters["id"].DefaultValue = strFirstName; SqlDataSource2.UpdateParameters["pass"].DefaultValue = strLastName; SqlDataSource2.UpdateParameters["name"].DefaultValue = strDepartment; SqlDataSource2.Update();}
```
**Row Deleting event is used to [delete the data](https://www.mindstick.com/forum/371/how-to-insert-update-delete-the-data-from-grid-view-data-to-database)**
```
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e){ SqlDataSource2.Delete();}
```
Insert User Id, [Password](https://www.mindstick.com/blog/118/retriving-user-password-by-using-stored-procedure-in-asp-dot-net) and [User Name](https://answers.mindstick.com/qa/30717/how-to-retrieve-user-name-in-case-of-window-authentication) and then click Add when you click Add button, inserted data will add to the database.
**web.config:**
```
```
## Stored procedure:\
This procedure is used to select data
```
Create procedure insert_reg asbeginselect * from regformend
```
## \
## This procedure is used to Delete data
```
create procedure del_reg@id varchar(50)asbegindelete from regform where id=@idend
```
## \
## This procedure is used to Update data
```
create procedure [dbo].[update_reg]@id varchar(50),@pass varchar(50),@name varchar(50)asbeginupdate regform set pass=@pass,name=@name where id=@idend
```
---
Original Source: https://www.mindstick.com/articles/189/sqldatasource-in-asp-dot-net
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.