C#

protected void gvKeyPersonnel_RowUpdating(object sender, GridViewUpdateEventArgs e)

protected void gvKeyPersonnel_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            using (SqlCommand cmd = new SqlCommand())
            {

                cmd.Connection = conn;
                conn.Open();
              

                GridViewRow row =  gvKeyPersonnel.Rows[e.RowIndex];
                // foreach (GridViewRow row in gvKeyPersonnel.Rows)


                cmd.CommandText = "UPDATE SP2010_EDCStaffing_AppDB.dbo.CMS_Key_Personnel  SET  Name = @Name, VDCIDIQ = @VDCIDIQ, VDCFFS = @VDCFFS, VDCHIM = @VDCHIM, VDCWEBHOSTING = @VDCWEBHOSTING, VDCCWF = @VDCCWF WHERE ID = @id";

                cmd.Parameters.AddWithValue("@id", Convert.ToInt32(gvKeyPersonnel.DataKeys[row.RowIndex].Values[0]));
                cmd.Parameters.AddWithValue("@Name", row.Cells[1].Text);
                cmd.Parameters.AddWithValue("@VDCIDIQ", row.Cells[2].Text);
                cmd.Parameters.AddWithValue("@VDCFFS", row.Cells[3].Text);
                cmd.Parameters.AddWithValue("@VDCHIM", row.Cells[4].Text);
                cmd.Parameters.AddWithValue("@VDCWEBHOSTING", row.Cells[5].Text);
                cmd.Parameters.AddWithValue("@VDCCWF", row.Cells[6].Text);
                //cmd.Parameters.AddWithValue("@id", Convert.ToInt32(gvKeyPersonnel.DataKeys[row.RowIndex].Values[0]));
                //cmd.Parameters.AddWithValue("@Name", Name.Text);
                //cmd.Parameters.AddWithValue("@VDCIDIQ", VDCIDIQ.Text);
                //cmd.Parameters.AddWithValue("@VDCFFS", VDCFFS.Text);
                //cmd.Parameters.AddWithValue("@VDCHIM", VDCHIM.Text);
                //cmd.Parameters.AddWithValue("@VDCWEBHOSTING", VDCWEBHOSTING.Text);
                //cmd.Parameters.AddWithValue("@VDCCWF", VDCCWF.Text);

                cmd.ExecuteNonQuery();
                //   cmd.Parameters.Clear();
            }

            conn.Close();
        }

<asp:GridView runat="server" ID="gvKeyPersonnel" 
    AutoGenerateColumns="False" BackColor="White" BorderColor="#DEDFDE" DataKeyNames="ID" 
    BorderStyle="None" BorderWidth="1px" CellPadding="4" OnRowUpdating="gvKeyPersonnel_RowUpdating"
    EnableModelValidation="True" ForeColor="Black" GridLines="Vertical">
    <AlternatingRowStyle BackColor="White"  />
    <Columns>
       <asp:TemplateField HeaderText="ID">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("ID") %>' ID="txtID"  />
            </ItemTemplate>
        </asp:TemplateField>
       <asp:TemplateField HeaderText="Name">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("Name") %>' ID="txtName"   />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="VDCIDIQ">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("VDCIDIQ") %>' ID="txtVDCIDIQ" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="VDCFFS">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("VDCFFS") %>' ID="txtVDCFFS" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="VDCHIM">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("VDCHIM") %>' ID="txtVDCHIM" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="VDCWEBHOSTING">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("VDCWEBHOSTING") %>' ID="txtVDCWEBHOSTING" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="VDCCWF">
            <ItemTemplate>
                <asp:TextBox runat="server" text='<%#Eval("VDCCWF") %>' ID="txtVDCCWF" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    <FooterStyle BackColor="#CCCC99" />
    <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
    <RowStyle BackColor="#F7F7DE" />
    <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<br />
<asp:Button ID="Update" runat="server" onclick="gvKeyPersonnel_RowUpdating" Text="Update" />

using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls.WebParts;

namespace StaffingWebParts.keypernew
{
    public partial class keypernewUserControl : UserControl
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLStaffingConn"].ConnectionString);
        SqlCommand cmd = new SqlCommand();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                KeyPersonnel();
            }
        }
        protected void KeyPersonnel()
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("Select id, Name from CMS_Key_Personnel", conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            int count = ds.Tables[0].Rows.Count;
            conn.Close();
            if (ds.Tables[0].Rows.Count > 0)
            {
                gvKeyPersonnel.DataSource = ds;
                gvKeyPersonnel.DataBind();
            }
            else
            {
                ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
                gvKeyPersonnel.DataSource = ds;
                gvKeyPersonnel.DataBind();
                int columncount = gvKeyPersonnel.Rows[0].Cells.Count;
                lblmsg.Text = " No data found !!!";
            }
        }
        protected void gvKeyPersonnel_RowEditing(object sender, GridViewEditEventArgs e)
        {
            gvKeyPersonnel.EditIndex = e.NewEditIndex;
            KeyPersonnel();
        }
        protected void gvKeyPersonnel_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            

           // string id = gvKeyPersonnel.DataKeys[e.RowIndex].Values["id"].ToString();
            int id = Convert.ToInt32(gvKeyPersonnel.DataKeys[e.RowIndex].Value);

            TextBox Name = (TextBox)gvKeyPersonnel.Rows[e.RowIndex].FindControl("txtName");
            //    TextBox stor_address = (TextBox)gvKeyPersonnel.Rows[e.RowIndex].FindControl("txtaddress");
            //    TextBox city = (TextBox)gvKeyPersonnel.Rows[e.RowIndex].FindControl("txtcity");
            //    TextBox state = (TextBox)gvKeyPersonnel.Rows[e.RowIndex].FindControl("txtstate");
            //     TextBox zip = (TextBox)gvKeyPersonnel.Rows[e.RowIndex].FindControl("txtzip");
            conn.Open();
            SqlCommand cmd = new SqlCommand("update CMS_Key_Personnel set Name='" + Name.Text + "' where id=" + id, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            //lblmsg.BackColor = Color.Blue;
            //lblmsg.ForeColor = Color.White;
            lblmsg.Text = id + "        Updated successfully........    ";
            gvKeyPersonnel.EditIndex = -1;
            KeyPersonnel();
        }
        protected void gvKeyPersonnel_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gvKeyPersonnel.EditIndex = -1;
            KeyPersonnel();
        }
        protected void gvKeyPersonnel_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string id = gvKeyPersonnel.DataKeys[e.RowIndex].Values["id"].ToString();
            conn.Open();
            SqlCommand cmd = new SqlCommand("delete from CMS_Key_Personnel where id=" + id, conn);
            int result = cmd.ExecuteNonQuery();
            conn.Close();
            if (result == 1)
            {
                KeyPersonnel();
                //lblmsg.BackColor = Color.Red;
                //lblmsg.ForeColor = Color.White;
                lblmsg.Text = id + "      Deleted successfully.......    ";
            }
        }
        protected void gvKeyPersonnel_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                string id = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "id"));
                Button lnkbtnresult = (Button)e.Row.FindControl("ButtonDelete");
                if (lnkbtnresult != null)
                {
                    lnkbtnresult.Attributes.Add("onclick", "javascript:return deleteConfirm('" + id + "')");
                }
            }
        }
        protected void gvKeyPersonnel_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName.Equals("AddNew"))
            {
                TextBox inid = (TextBox)gvKeyPersonnel.FooterRow.FindControl("inid");
                TextBox inname = (TextBox)gvKeyPersonnel.FooterRow.FindControl("inname");
                //   TextBox inaddress = (TextBox)gvKeyPersonnel.FooterRow.FindControl("inaddress");
                //   TextBox incity = (TextBox)gvKeyPersonnel.FooterRow.FindControl("incity");
                //   TextBox instate = (TextBox)gvKeyPersonnel.FooterRow.FindControl("instate");
                //   TextBox inzip = (TextBox)gvKeyPersonnel.FooterRow.FindControl("inzip");
                conn.Open();
                SqlCommand cmd =
                    new SqlCommand(
                        "insert into CMS_Key_Personnel(id, name,) values('" + inid.Text + "', '" + inname.Text + "')", conn);
                int result = cmd.ExecuteNonQuery();
                conn.Close();
                if (result == 1)
                {
                    KeyPersonnel();
                    //lblmsg.BackColor = Color.Green;
                    //lblmsg.ForeColor = Color.White;
                    lblmsg.Text = inid.Text + "      Added successfully......    ";
                }
                else
                {
                    //lblmsg.BackColor = Color.Red;
                    //lblmsg.ForeColor = Color.White;
                    lblmsg.Text = inid.Text + " Error while adding row.....";
                }
            }
        }
    }

}

static int Add3Numbers(int One, int Two, int Three)
    {
        int Return = One + Two + Three;
        return Return;
    }

int Sum = Add3Numbers(Input1, Input2, Input3);

Add3Numbers();

if ((ThirdInput / 42 == 1) || (ThirdInput / 42 == 2))
    {
        return ThirdInput;
        Add3Numbers();
    }

while (ThirdRepeat) // Start of loop
    {
        if ((ThirdInput / 42 == 1) || (ThirdInput / 42 == 2))
            {
                return ThirdInput;
                Add3Numbers();
            }
            else
                {
                    ThirdRepeat = false;
                    Console.WriteLine("That number is not evenly divisble by 42. Please try again");
                    GetThirdInputFromUser();
    } while (ThirdRepeat); // End loop

while (ThirdRepeat)
    {
        if ((ThirdInput / 42 == 1) || (ThirdInput / 42 == 2))
            {
                return ThirdInput;
                Add3Numbers();
            }
            else
                {
                    ThirdRepeat = false;
                    Console.WriteLine("That number is not evenly divisble by 42. Please try again");
                    GetThirdInputFromUser();
    }

static void Main(string[] args)
   {
   int even = GetEvenNumber();
   int odd = GetOddNumber();
   int divisibleBy42 = GetDivisibleNumber(42);
   Console.WriteLine("Even      : {0}\nOdd       : {1}\nDivisible : {2}", even, odd, divisibleBy42);
   }
private static int GetEvenNumber()
   {
   return -1;
   }
private static int GetOddNumber()
   {
   return -1;
   }
private static int GetDivisibleNumber(int divisor)
   {
   return -1;
   }

int dogAge;
if (!int.TryParse(Console.Read(), out dogAge)) return;