<div>
Try this , 
<a href="http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx" rel="ugc">http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx</a>
</div>

<div>
Kindly go through the below 
 
1. First you need to create a table in Database like below 
 
 Column Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Data Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Allow Nulls 
productid &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Int(IDENTITY=TRUE) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes 
productname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; varchar(50) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yes 
price &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; varchar(50) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes 
 
2. Now create one new stored procedure “Crudoperations” 

<pre><code class="code-10 nolinks" id="code-20-41757434-1"> CREATE PROCEDURE CrudOperations 
@productid int = 0, 
@productname varchar(50)=null, 
@price int=0, 
@status varchar(50) 
AS 
BEGIN 
SET NOCOUNT ON; 
--- Insert New Records 
IF @status='INSERT' 
BEGIN 
INSERT INTO productinfo1(productname,price) VALUES(@productname,@price) 
END 
--- Select Records in Table 
IF @status='SELECT' 
BEGIN 
SELECT productid,productname,price FROM productinfo1 
END 
--- Update Records in Table 
IF @status='UPDATE' 
BEGIN 
UPDATE productinfo1 SET productname=@productname,price=@price WHERE productid=@productid 
END 
--- Delete Records from Table 
IF @status='DELETE' 
BEGIN 
DELETE FROM productinfo1 where productid=@productid 
END 
SET NOCOUNT OFF 
END
</code></pre>
 
 
3. &nbsp;Now open your .aspx Page and write a code like below 

<pre><code class="code-10 nolinks" id="code-20-41757434-2"> &lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;head id=&quot;Head1&quot; runat=&quot;server&quot;&gt;
&lt;title&gt;GridView Crud (Select Insert Edit Update Delete) Operations using Single Stored Procedure in ASP.Net&lt;/title&gt;
&lt;style type=&quot;text/css&quot;&gt;
.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
.headerstyle
{
color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;background-color: #df5015;padding:0.5em 0.5em 0.5em 0.5em;text-align:center;
}
&lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;form id=&quot;form1&quot; runat=&quot;server&quot;&gt;
&lt;div class=&quot;GridviewDiv&quot;&gt;
&lt;asp:GridView runat=&quot;server&quot; ID=&quot;gvDetails&quot; ShowFooter=&quot;true&quot; AllowPaging=&quot;true&quot; PageSize=&quot;10&quot; AutoGenerateColumns=&quot;false&quot; DataKeyNames=&quot;productid,productname&quot; OnPageIndexChanging=&quot;gvDetails_PageIndexChanging&quot; OnRowCancelingEdit=&quot;gvDetails_RowCancelingEdit&quot;
OnRowEditing=&quot;gvDetails_RowEditing&quot; OnRowUpdating=&quot;gvDetails_RowUpdating&quot; OnRowDeleting=&quot;gvDetails_RowDeleting&quot; OnRowCommand =&quot;gvDetails_RowCommand&quot; &gt;
&lt;HeaderStyle CssClass=&quot;headerstyle&quot; /&gt;
&lt;Columns&gt;
&lt;asp:BoundField DataField=&quot;productid&quot; HeaderText=&quot;Product Id&quot; ReadOnly=&quot;true&quot; /&gt;
&lt;asp:TemplateField HeaderText=&quot;Product Name&quot;&gt;
&lt;ItemTemplate&gt;
&lt;asp:Label ID=&quot;lblProductname&quot; runat=&quot;server&quot; Text='&lt;%# Eval(&quot;productname&quot;)%&gt;'/&gt;
&lt;/ItemTemplate&gt;
&lt;EditItemTemplate&gt;
&lt;asp:TextBox ID=&quot;txtProductname&quot; runat=&quot;server&quot; Text='&lt;%# Eval(&quot;productname&quot;)%&gt;'/&gt;
&lt;/EditItemTemplate&gt;
&lt;FooterTemplate&gt;
&lt;asp:TextBox ID=&quot;txtpname&quot; runat=&quot;server&quot; /&gt;
&lt;/FooterTemplate&gt;
&lt;/asp:TemplateField&gt;
&lt;asp:TemplateField HeaderText = &quot;Price&quot;&gt;
&lt;ItemTemplate&gt;
&lt;asp:Label ID=&quot;lblPrice&quot; runat=&quot;server&quot; Text='&lt;%# Eval(&quot;price&quot;)%&gt;'&gt;&lt;/asp:Label&gt;
&lt;/ItemTemplate&gt;
&lt;EditItemTemplate&gt;
&lt;asp:TextBox ID=&quot;txtProductprice&quot; runat=&quot;server&quot; Text='&lt;%# Eval(&quot;price&quot;)%&gt;'/&gt;
&lt;/EditItemTemplate&gt;
&lt;FooterTemplate&gt;
&lt;asp:TextBox ID=&quot;txtprice&quot; runat=&quot;server&quot; /&gt;
&lt;asp:Button ID=&quot;btnAdd&quot; CommandName=&quot;AddNew&quot; runat=&quot;server&quot; Text=&quot;Add&quot; /&gt;
&lt;/FooterTemplate&gt;
&lt;/asp:TemplateField&gt;
&lt;asp:CommandField ShowEditButton=&quot;True&quot; ShowDeleteButton=&quot;true&quot; /&gt;
&lt;/Columns&gt;
&lt;/asp:GridView&gt;
&lt;asp:Label ID=&quot;lblresult&quot; runat=&quot;server&quot;&gt;&lt;/asp:Label&gt;
&lt;/div&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>
 
4. After completion of aspx page add following namespaces in codebehind 

<pre><code class="code-1 nolinks" id="code-20-41757434-3">using System;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Drawing;
</code></pre>
 
5. After completion of adding namespaces you need to write the code like as shown below 
 

<pre><code class="code-100 nolinks" id="code-20-41757434-4"> protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridview();
}
}
protected void BindGridview()
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(&quot;Data Source=Suresh;Integrated Security=true;Initial Catalog=MySampleDB&quot;))
{
con.Open();
SqlCommand cmd = new SqlCommand(&quot;crudoperations&quot;, con);
cmd.CommandType= CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(&quot;@status&quot;,&quot;SELECT&quot;);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count &gt; 0)
{
gvDetails.DataSource = ds;
gvDetails.DataBind();
}
else {
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvDetails.DataSource = ds;
gvDetails.DataBind();
int columncount = gvDetails.Rows[0].Cells.Count;
gvDetails.Rows[0].Cells.Clear();
gvDetails.Rows[0].Cells.Add(new TableCell());
gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;
gvDetails.Rows[0].Cells[0].Text = &quot;No Records Found&quot;;
}
}
}
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals(&quot;AddNew&quot;))
{
TextBox txtname = (TextBox)gvDetails.FooterRow.FindControl(&quot;txtpname&quot;);
TextBox txtprice = (TextBox)gvDetails.FooterRow.FindControl(&quot;txtprice&quot;);
crudoperations(&quot;INSERT&quot;, txtname.Text, txtprice.Text, 0);
}
}
protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e)
{
gvDetails.EditIndex = e.NewEditIndex;
BindGridview();
}
protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvDetails.EditIndex = -1;
BindGridview();
}
protected void gvDetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvDetails.PageIndex = e.NewPageIndex;
BindGridview();
}
protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int productid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values[&quot;productid&quot;].ToString());
TextBox txtname = (TextBox)gvDetails.Rows[e.RowIndex].FindControl(&quot;txtProductname&quot;);
TextBox txtprice = (TextBox)gvDetails.Rows[e.RowIndex].FindControl(&quot;txtProductprice&quot;);
crudoperations(&quot;UPDATE&quot;,txtname.Text,txtprice.Text,productid);
}
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int productid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values[&quot;productid&quot;].ToString());
string productname = gvDetails.DataKeys[e.RowIndex].Values[&quot;productname&quot;].ToString();
crudoperations(&quot;DELETE&quot;,productname,&quot;&quot;,productid);
}
protected void crudoperations(string status, string productname, string price, int productid)
{
using (SqlConnection con = new SqlConnection(&quot;Data Source=Suresh;Integrated Security=true;Initial Catalog=MySampleDB&quot;))
{
con.Open();
SqlCommand cmd = new SqlCommand(&quot;crudoperations&quot;, con);
cmd.CommandType= CommandType.StoredProcedure;
if(status==&quot;INSERT&quot;)
{
cmd.Parameters.AddWithValue(&quot;@status&quot;,status);
cmd.Parameters.AddWithValue(&quot;@productname&quot;,productname);
cmd.Parameters.AddWithValue(&quot;@price&quot;,price);
}
else if(status==&quot;UPDATE&quot;)
{
cmd.Parameters.AddWithValue(&quot;@status&quot;,status);
cmd.Parameters.AddWithValue(&quot;@productname&quot;,productname);
cmd.Parameters.AddWithValue(&quot;@price&quot;,price);
cmd.Parameters.AddWithValue(&quot;@productid&quot;,productid);
}
else if(status==&quot;DELETE&quot;)
{
cmd.Parameters.AddWithValue(&quot;@status&quot;,status);
cmd.Parameters.AddWithValue(&quot;@productid&quot;,productid);
}
cmd.ExecuteNonQuery();
lblresult.ForeColor = Color.Green;
lblresult.Text = productname+&quot; details &quot;+status.ToLower()+&quot;d successfully&quot;;
gvDetails.EditIndex = -1;
BindGridview();
}
}
</code></pre>
</div>

<div>
where we add the add &nbsp;namespaces, just after loading default page?
</div>

1.PNG

<div>
please see my screenshot. where I'm I start with. Sorry, I'm a beginner for this. 
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w34/1111878/2.PNG" target="_blank" class="file-inline" title="2.PNG (9 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>2.PNG</a>
</div>

2.PNG

CRUD.zip

<div>
How to run this application, can you please provide me the step by step guide?
</div>

<div>
Hit F5 to build and run the project in debug mode.
</div>

<div>
Here what I'm getting after Hit F5. 
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w37/1115743/Doc1.docx" target="_blank" class="file-inline" title="Doc1.docx (514 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Doc1.docx</a>
</div>

Doc1.docx

<div>
Hey, it is the Default.aspx page which is running by default. 
You can change it in Solution Explorer &nbsp;by simply right click on the page which you wanted to Run &nbsp;and select option Set As Start Page &nbsp; and just run it
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
Has some one give me some guidance to build a simple WEbform to connect to the a single table and insert and update data
</div>
</div>

Hi,

Has some one give me some guidance to build a simple WEbform to connect to the a single table and insert and update data

Build a Webform using ASP.NET Insert/update data into a  MS SQL table

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications