.ASPX PAGE
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowupdating="GridView1_RowUpdating" AllowPaging="True" BackColor="White" BorderColor="White"
BorderWidth="1px" CellPadding="0" ForeColor="Black" GridLines="Vertical"
Font-Bold="False" Font-Italic="False" Font-Names="Verdana"
Font-Size="Small" PageIndex="1" Width="20%"
BorderStyle="None" onselectedindexchanging="GridView1_SelectedIndexChanging"
SelectedIndex="10" onselectedindexchanged="GridView1_SelectedIndexChanged"
onpageindexchanged="GridView1_PageIndexChanged"
onpageindexchanging="GridView1_PageIndexChanging" Height="25%"
ShowHeaderWhenEmpty="True">
<AlternatingRowStyle BackColor="#CCCCCC" />
<Columns>
<asp:TemplateField HeaderText="Operations">
<ItemTemplate>
<asp:Button ID="btnEdit" runat="server" CommandName="Edit" Text="Edit"
Width="59px" />
<asp:Button ID="btnDelete" runat="server" CommandName="Delete" Text="Delete" Width="70px" />
</ItemTemplate>
<EditItemTemplate>
<asp:Button ID="btnUpdate" runat="server" CommandName="Update" Text="Update" />
<asp:Button ID="btnCancel" runat="server" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<FooterTemplate>
<asp:Button ID="btnInsertFooter" runat="server" CommandName="InsertFooter1"
Text="Insert" />
<asp:Button ID="btnClearFooter" runat="server" CommandName="ClearFooter"
Text="Clear" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ClientID">
<ItemTemplate>
<asp:Label ID="lblId" runat="server" Text='<%# Bind("Id") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblId1" runat="server" Text='<%# Bind("Id") %>'></asp:Label>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterId" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Client_Name">
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%# Bind("ClientName") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtName1" runat="server" Text='<%# Bind("ClientName") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFootername" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address1">
<ItemTemplate>
<asp:Label ID="lblAdd1" runat="server" Text='<%# Bind("Address1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtAdd11" runat="server" Text='<%# Bind("Address1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterAdd1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address2">
<ItemTemplate>
<asp:Label ID="lblAdd2" runat="server" Text='<%# Bind("Address2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtAdd22" runat="server" Text='<%# Bind("Address2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterAdd2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address3">
<ItemTemplate>
<asp:Label ID="lblAdd3" runat="server" Text='<%# Bind("Address3") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtAdd33" runat="server" Text='<%# Bind("Address3") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterAdd3" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<ItemTemplate>
<asp:Label ID="lblCity" runat="server" Text='<%# Bind("City") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCity1" runat="server" Text='<%# Bind("City") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCity" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Postal_Code">
<ItemTemplate>
<asp:Label ID="lblPostcode" runat="server" Text='<%# Bind("PostCode") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtPost1" runat="server" Text='<%# Bind("PostCode") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterPost" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="State">
<ItemTemplate>
<asp:Label ID="lblState" runat="server" Text='<%# Bind("State") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtState1" runat="server" Text='<%# Bind("State") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterState" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Country">
<ItemTemplate>
<asp:Label ID="lblCountry" runat="server" Text='<%# Bind("Country") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCountry1" runat="server" Text='<%# Bind("Country") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCountry" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Reference_No">
<ItemTemplate>
<asp:Label ID="lblRefno" runat="server" Text='<%# Bind("RefNo") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtRefno1" runat="server" Text='<%# Bind("RefNo") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterRefno" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person1 Name">
<ItemTemplate>
<asp:Label ID="lblCp1Name" runat="server" Text='<%# Bind("Cp1Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp1name1" runat="server" Text='<%# Bind("Cp1Name") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="TxtFooterCp1name" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person1 Phone1">
<ItemTemplate>
<asp:Label ID="lblCp1phone1" runat="server" Text='<%# Bind("Cp1Phone1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp1Phone11" runat="server" Text='<%# Bind("Cp1Phone1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp1phone1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person1 Phone2">
<ItemTemplate>
<asp:Label ID="lblCp1Phone2" runat="server" Text='<%# Bind("Cp1Phone2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp1Phone22" runat="server" Text='<%# Bind("Cp1Phone2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp1phone2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person1 Email1">
<ItemTemplate>
<asp:Label ID="lblCp1email1" runat="server" Text='<%# Bind("Cp1Email1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp1Email11" runat="server" Text='<%# Bind("Cp1Email1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp1mail1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person1 Email2">
<ItemTemplate>
<asp:Label ID="lblCp1email2" runat="server" Text='<%# Bind("Cp1Email2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp1Email22" runat="server" Text='<%# Bind("Cp1Email2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp1mail2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person2 Name">
<ItemTemplate>
<asp:Label ID="lblCp2Name" runat="server" Text='<%# Bind("Cp2Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp2Name1" runat="server" Text='<%# Bind("Cp2Name") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp2name" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person2 Phone1">
<ItemTemplate>
<asp:Label ID="lblCp2Phone1" runat="server" Text='<%# Bind("Cp2Phone1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp2Phone11" runat="server" Text='<%# Bind("Cp2Phone1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp2phone1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person2 Phone2">
<ItemTemplate>
<asp:Label ID="lblCp2Phone2" runat="server" Text='<%# Bind("Cp2Phone2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp2Phone22" runat="server" Text='<%# Bind("Cp2Phone2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp2phone2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person2 Email1">
<ItemTemplate>
<asp:Label ID="lblCp2email1" runat="server" Text='<%# Bind("Cp2Email1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp2Email11" runat="server" Text='<%# Bind("Cp2Email1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp2mail1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person2 Email2">
<ItemTemplate>
<asp:Label ID="lblCp2email2" runat="server" Text='<%# Bind("Cp2Email2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp2Email22" runat="server" Text='<%# Bind("Cp2Email2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp2mail2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person3 Name">
<ItemTemplate>
<asp:Label ID="lblCp3Name" runat="server" Text='<%# Bind("Cp3Name") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp3Name1" runat="server" Text='<%# Bind("Cp3Name") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp3name" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person3 Phone1">
<ItemTemplate>
<asp:Label ID="lblCp3Phone1" runat="server" Text='<%# Bind("Cp3Phone1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp3Phone11" runat="server" Text='<%# Bind("Cp3Phone1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp3phone1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person3 Phone2">
<ItemTemplate>
<asp:Label ID="lblCp3Phone2" runat="server" Text='<%# Bind("Cp3Phone2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp3Phone22" runat="server" Text='<%# Bind("Cp3Phone2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp3phone2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person3 Email1">
<ItemTemplate>
<asp:Label ID="lblCp3email1" runat="server" Text='<%# Bind("Cp3Email1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp3Email11" runat="server" Text='<%# Bind("Cp3Email1") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp3mail1" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact_Person3 Email2">
<ItemTemplate>
<asp:Label ID="lblCp3email2" runat="server" Text='<%# Bind("Cp3Email2") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCp3Email22" runat="server" Text='<%# Bind("Cp3Email2") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterCp3mail2" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="FaxNo">
<ItemTemplate>
<asp:Label ID="lblFaxno" runat="server" Text='<%# Bind("FaxNo") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtFaxno1" runat="server" Text='<%# Bind("FaxNo") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtFooterFaxno" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
There is No Records in Client, First Enter Records....!<br />
</EmptyDataTemplate>
<FooterStyle BackColor="#CCCCCC" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White"
Font-Italic="True" />
<PagerSettings PageButtonCount="3" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center"
BorderStyle="None" />
<RowStyle BackColor="White" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" BorderStyle="None" />
<SortedAscendingHeaderStyle BackColor="#808080" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#383838" />
</asp:GridView> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- .
ASPX.CS protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{Bind();}
}
private void Bind()
{
SqlConnection con = new SqlConnection(connection);
SqlDataAdapter da = new SqlDataAdapter("select * from Client", con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds);
con.Close();
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label lblId = (Label)GridView1.Rows[e.RowIndex].FindControl("lblId");
SqlConnection con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Delete from Client where Id=@1";
cmd.Parameters.Add("@1", SqlDbType.Int, 12).Value = lblId.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Bind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
Bind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
Bind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblId = (Label)GridView1.Rows[e.RowIndex].FindControl("lblId1");
TextBox txtname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName1");
TextBox txtAdd1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAdd11");
TextBox txtAdd2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAdd22");
TextBox txtAdd3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAdd33");
TextBox txtCity = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCity1");
TextBox txtPost = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtPost1");
TextBox txtState = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtState1");
TextBox txtCountry = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCountry1");
TextBox txtRefno = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtRefno1");
TextBox txtCp1Name = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp1name1");
TextBox txtCp1Phone1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp1Phone11");
TextBox txtCp1Phone2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp1Phone22");
TextBox txtCp1Email1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp1Email11");
TextBox txtCp1Email2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp1Email22");
TextBox txtCp2Name = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp2Name1");
TextBox txtCp2Phone1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp2Phone11");
TextBox txtCp2Phone2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp2Phone22");
TextBox txtCp2Email1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp2Email11");
TextBox txtCp2Email2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp2Email22");
TextBox txtCp3Name = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp3Name1");
TextBox txtCp3Phone1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp3Phone11");
TextBox txtCp3Phone2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp3Phone22");
TextBox txtCp3Email1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp3Email11");
TextBox txtCp3Email2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCp1Email22");
TextBox txtFaxno = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtFaxno1");
SqlConnection con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "update Client Set ClientName=@1, Address1=@2, Address2=@3, Address3=@4, City=@5, PostCode=@6, State=@7, Country=@8, RefNo=@9, Cp1Name=@10, Cp1Phone1=@11, Cp1Phone2=@12, Cp1Email1=@13, Cp1Email2=@14, Cp2Name=@15, Cp2Phone1=@16, Cp2Phone2=@17, Cp2Email1=@18, Cp2Email2=@19, Cp3Name=@20, Cp3Phone1=@21, Cp3Phone2=@22, Cp3Email1=@23, Cp3Email2=@24, FaxNo=@25 where Id=@26";
cmd.Parameters.Add("@1", SqlDbType.NVarChar, 34).Value = txtname.Text;
cmd.Parameters.Add("@2", SqlDbType.NVarChar, 34).Value = txtAdd1.Text;
cmd.Parameters.Add("@3", SqlDbType.NVarChar, 34).Value = txtAdd2.Text;
cmd.Parameters.Add("@4", SqlDbType.NVarChar, 34).Value = txtAdd3.Text;
cmd.Parameters.Add("@5", SqlDbType.NVarChar, 34).Value = txtCity.Text;
cmd.Parameters.Add("@6", SqlDbType.VarChar, 23).Value = txtPost.Text;
cmd.Parameters.Add("@7", SqlDbType.NVarChar, 34).Value = txtState.Text;
cmd.Parameters.Add("@8", SqlDbType.NVarChar, 34).Value = txtCountry.Text;
cmd.Parameters.Add("@9", SqlDbType.Decimal, 32).Value = txtRefno.Text;
cmd.Parameters.Add("@10", SqlDbType.NVarChar, 34).Value = txtCp1Name.Text;
cmd.Parameters.Add("@11", SqlDbType.NVarChar, 34).Value = txtCp1Phone1.Text;
cmd.Parameters.Add("@12", SqlDbType.NVarChar, 34).Value = txtCp1Phone2.Text;
cmd.Parameters.Add("@13", SqlDbType.NVarChar, 34).Value = txtCp1Email1.Text;
cmd.Parameters.Add("@14", SqlDbType.NVarChar, 34).Value = txtCp1Email2.Text;
cmd.Parameters.Add("@15", SqlDbType.NVarChar, 34).Value = txtCp2Name.Text;
cmd.Parameters.Add("@16", SqlDbType.NVarChar, 34).Value = txtCp2Phone1.Text;
cmd.Parameters.Add("@17", SqlDbType.NVarChar, 34).Value = txtCp2Phone2.Text;
cmd.Parameters.Add("@18", SqlDbType.NVarChar, 34).Value = txtCp2Email1.Text;
cmd.Parameters.Add("@19", SqlDbType.NVarChar, 34).Value = txtCp2Email2.Text;
cmd.Parameters.Add("@20", SqlDbType.NVarChar, 34).Value = txtCp3Name.Text;
cmd.Parameters.Add("@21", SqlDbType.NVarChar, 34).Value = txtCp3Phone1.Text;
cmd.Parameters.Add("@22", SqlDbType.NVarChar, 34).Value = txtCp3Phone2.Text;
cmd.Parameters.Add("@23", SqlDbType.NVarChar, 34).Value = txtCp3Email1.Text;
cmd.Parameters.Add("@24", SqlDbType.NVarChar, 34).Value = txtCp3Email2.Text;
cmd.Parameters.Add("@25", SqlDbType.Decimal, 32).Value = txtFaxno.Text;
cmd.Parameters.Add("@26", SqlDbType.Int, 12).Value = lblId.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
Bind();
}