ASP.NET

SqlCommand cmdsave = new SqlCommand("AddBranchProc11", con);
            cmdsave.CommandType = CommandType.StoredProcedure;
            con.Open();

            cmdsave.Parameters.AddWithValue("@BranchId", txtbranchid.Text);
            cmdsave.Parameters.AddWithValue("@BranchName", txtBranchname.Text);

            cmdsave.Parameters.AddWithValue("@CompanyId", ddlcompanyid1.SelectedItem.Value);
            
            cmdsave.Parameters.AddWithValue("@ContractNo", txtcontractno.Text);
            cmdsave.Parameters.AddWithValue("@Region", ddlRegions.SelectedItem.Value);

            cmdsave.Parameters.AddWithValue("@City", txtcity.Text);
            cmdsave.Parameters.AddWithValue("@Area", txtarea.Text);

            cmdsave.Parameters.AddWithValue("@Address", txtaddress.Text);

            cmdsave.Parameters.AddWithValue("@StartDate", txtstartdate1.Text);
            cmdsave.Parameters.AddWithValue("@EndDate", txtEnd.Text);
            cmdsave.Parameters.AddWithValue("@ContractReminder", ddlcontractreminder.SelectedItem.Value); FileInfo branchinfo = new FileInfo(FileUpload1.PostedFile.FileName.Trim());
            byte[]branchcontent=new byte[branchinfo.Length];
            FileStream branchstream = branchinfo.OpenRead();
            branchstream.Read(branchcontent,0,branchcontent.Length);
            branchstream.Close();
            cmdsave.Parameters.AddWithValue("@ReminderType", ddlremindertype.SelectedItem.Value);
            cmdsave.Parameters.AddWithValue("@BranchPicture",branchcontent);

 if (cmdsave.ExecuteNonQuery()!= 0)
            {

                Functions.ShowAlertMessage("saved");
}

e.Row.Attributes["onmouseover"] = "this.style.cursor='hand';";
e.Row.Attributes["onmouseout"] = "this.style.textDecoration='none';";
e.Row.Attributes["onclick"] = Page.ClientScript.GetPostBackClientHyperlink(this.MyGridView, "Select$" + e.Row.RowIndex);

((CheckBox)e.Row.FindControl("MyCheckBox")).Attributes.Add("onclick", "return false;");