protected void Button1_Click(object sender, EventArgs e) { Label1.Text = "<br>Plant=" + DropDownList1.SelectedValue + "<br>"; for (int i = 0; i < Request.Form.Count; i++) { if (Request.Form.Keys[i].Contains("Check")) { Label1.Text = Label1.Text + "<br> added to Garden=" + Request.Form[i] + "<br>"; try { SqlDataSource objDS = new SqlDataSource(); objDS.ProviderName = System.Configuration.ConfigurationManager.ConnectionStrings["GardenConnectionString"].ProviderName; objDS.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["GardenConnectionString"].ConnectionString; objDS.InsertCommand = "insert into T_Garden_Plant (GardenID_FK, PlantID_FK) values (?,?)"; objDS.InsertParameters.Add("GardenID_FK", Request.Form[i].ToString()); objDS.InsertParameters.Add("PlantID_FK", DropDownList1.SelectedValue); objDS.Insert(); } catch (Exception) { ErrorLabel.Text = "Plant could not be added to Garden, possibly Plant is currrently in chosen Garden."; } } } CheckBoxList1.ClearSelection(); }
protected void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e) { PrepareThemeAndModifierOptions(DropDownList1.SelectedValue); RadioButtonList1.ClearSelection(); CheckBoxList1.ClearSelection(); CleanUp(GetMapObj()); }
protected void Button1_Click(object sender, EventArgs e) { eventsource.InsertParameters["event_title"].DefaultValue = TextBox7.Text.ToUpper().Trim(); eventsource.InsertParameters["event_start_date"].DefaultValue = TextBox10.Text.ToUpper().Trim(); eventsource.InsertParameters["event_end_date"].DefaultValue = TextBox12.Text.ToUpper().Trim(); eventsource.InsertParameters["event_end_time"].DefaultValue = TextBox24.Text.ToUpper().Trim(); eventsource.InsertParameters["event_start_time"].DefaultValue = TextBox11.Text.ToUpper().Trim(); eventsource.InsertParameters["event_place"].DefaultValue = CheckBoxList1.SelectedValue; eventsource.InsertParameters["event_capacity"].DefaultValue = TextBox15.Text.Trim(); eventsource.InsertParameters["multi_day_event"].DefaultValue = RadioButtonList1.SelectedValue; eventsource.InsertParameters["audio_visual"].DefaultValue = RadioButtonList2.SelectedValue; eventsource.InsertParameters["user_id"].DefaultValue = TextBox25.Text.Trim(); eventsource.Insert(); TextBox7.Text = string.Empty; TextBox10.Text = string.Empty; TextBox12.Text = string.Empty; TextBox24.Text = string.Empty; TextBox11.Text = string.Empty; TextBox5.Text = string.Empty; TextBox25.Text = string.Empty; TextBox2.Text = string.Empty; TextBox3.Text = string.Empty; TextBox6.Text = string.Empty; TextBox15.Text = string.Empty; TextBox8.Text = string.Empty; CheckBoxList1.ClearSelection(); RadioButtonList1.ClearSelection(); RadioButtonList2.ClearSelection(); }
// Reset filters protected void Button6_Click(object sender, EventArgs e) { CheckBoxList1.ClearSelection(); CheckBox1.Checked = false; CheckBoxList2.ClearSelection(); ExecuteSearchAndSorting(); }
protected void btnCad_Click(object sender, EventArgs e) { if (!DropDownList1.SelectedIndex.Equals(0)) { for (int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items[i].Selected == true) { if (!Roles.IsUserInRole(DropDownList1.SelectedItem.Value, CheckBoxList1.Items[i].Value)) { Roles.AddUserToRole(DropDownList1.SelectedItem.Value, CheckBoxList1.Items[i].Value); } } else { if (Roles.IsUserInRole(DropDownList1.SelectedItem.Value, CheckBoxList1.Items[i].Value)) { Roles.RemoveUserFromRole(DropDownList1.SelectedItem.Value, CheckBoxList1.Items[i].Value); } } } } Response.Write("<script language='javascript'>alert('Alterado o perfil com sucesso!');</script>"); DropDownList1.ClearSelection(); CheckBoxList1.ClearSelection(); }
protected void Button2_Click(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; Label1.Text = ""; CheckBoxList1.ClearSelection(); }
protected void Submit_Click(object sender, EventArgs e) { String s = Request.QueryString["boosh"]; String q = TextBox3.Text; int count = 0; for (int a = 0; a < 5; a++) { if (CheckBoxList1.Items[a].Selected) { count++; } } string txt2 = txtValues.Text; string[] newlist = txt2.Split(new Char[] { ';', '\\' }, StringSplitOptions.RemoveEmptyEntries); if (TextBox2.Text != "" && TextBox3.Text != "" && TextBox4.Text != "" && TextBox5.Text != "" && count != 0 && SympCheck(newlist) == true && AllCheck() == true) { DiseaseDataSource.UpdateParameters.Add("Name", TextBox2.Text); DiseaseDataSource.UpdateParameters.Add("Description", TextBox3.Text); DiseaseDataSource.UpdateParameters.Add("Prognosis", TextBox4.Text); DiseaseDataSource.UpdateParameters.Add("Phenotype_Id", DropDownList1.SelectedValue); // DiseaseDataSource.InsertParameters.Add("DiseaseId", TextBox2.Text); DiseaseDataSource.UpdateParameters.Add("DiseaseId", ""); q = TextBox2.Text; q = TextBox3.Text; q = TextBox4.Text; DiseaseDataSource.UpdateCommandType = SqlDataSourceCommandType.Text; DiseaseDataSource.UpdateCommand = "UPDATE [Diseases] SET [Name] = @Name, [Description] = @Description, [Prognosis] = @Prognosis, [Phenotype_Id] = @Phenotype_Id WHERE [Id] = " + s + ""; DiseaseDataSource.Update(); TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; CheckBoxList1.ClearSelection(); } else { if (SympCheck(newlist) == false) { string myStringVariable = "Symptoms not found in Database"; txtValues.Text = ""; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + myStringVariable + "');", true); } } Label1.Visible = true; System.Threading.Thread.Sleep(2000); Label1.Visible = false; Response.Redirect("Results.aspx"); }
private void refresh() { CheckBoxList1.ClearSelection(); TextBox1.Text = ""; TextBox2.Text = ""; TextBox2.Visible = false; Button2.Visible = false; CheckBoxList2.Visible = false; }
private void Reset() { Text_Name.Text = ""; ceil_new.Text = ""; ceil_old.Text = ""; //TextBox2.Text = ""; CheckBoxList1.ClearSelection(); CheckBoxList2.ClearSelection(); DropDownList1.ClearSelection(); resetSelect(); }
void fillcheckbox() { CheckBoxList1.ClearSelection(); dm.Id_admin = decimal.Parse(DropDownList1.SelectedValue); DataTable dt = ac.SelectSecurity(dm); for (int i = 0; i < dt.Rows.Count; i++) { CheckBoxList1.Items.FindByValue(dt.Rows[i]["security"].ToString().Trim()).Selected = true; } Label2.Visible = false; }
protected void Wizard1_CancelButtonClick1(object sender, EventArgs e) { TextBox4.Text = String.Empty; TextBox5.Text = String.Empty; TextBox6.Text = String.Empty; RadioButtonList1.ClearSelection(); CheckBoxList1.ClearSelection(); ListBox1.ClearSelection(); Calendar1.SelectedDate = DateTime.Now; Result_Wizard.Text = ""; }
protected void Button2_Click(object sender, EventArgs e) { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; RadioButtonList2.ClearSelection(); RadioButtonList3.ClearSelection(); CheckBoxList1.ClearSelection(); }
protected void submit_mech_btn_Click1(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString); con.Open(); DateTime date = DateTime.Now; string updatequery = "Update ServiceRecords set Technician = @tech, NextServiceDate = @nextdate, DateUpdated = @dateupdate, NextServiceMilleage = @nextmile, RepairSummary = @repsumm where JobCardNo = '" + jobno_searchbx.Text + "'"; SqlCommand com = new SqlCommand(updatequery, con); com.Parameters.AddWithValue("@tech", ddl_techs.SelectedItem.ToString()); com.Parameters.AddWithValue("@repsumm", repair_summtxtarea.Value); com.Parameters.AddWithValue("@nextmile", milleagetxtbx.Text); com.Parameters.AddWithValue("@nextdate", datetxtbx.Text); com.Parameters.AddWithValue("@dateupdate", date); /*List<String> CheckBoxListStr = new List<string>(); * foreach (ListItem item in CheckBoxList1.Items) * { * if (item.Selected && CheckBoxList1.SelectedItem != null) * { * com.Parameters.AddWithValue("@repsumm", CheckBoxList1.SelectedItem.Text); * } * }*/ com.ExecuteNonQuery(); ShowMessage("Job card sucessfully updated"); //Response.Redirect("MessageConfirnmationPage.aspx"); con.Close(); jobno_searchbx.Text = string.Empty; vmake_txtbbx.Text = string.Empty; vmodel_txtbx.Text = string.Empty; vcolo_txtbx.Text = string.Empty; regno_txtbx.Text = string.Empty; servreq_txtarea.Value = string.Empty; com_txtarea.Value = string.Empty; CheckBoxList1.ClearSelection(); ddl_techs.ClearSelection(); repair_summtxtarea.Value = string.Empty; recom_txtarea.Value = string.Empty; datetxtbx.Text = string.Empty; milleagetxtbx.Text = string.Empty; } catch (Exception ex) { Response.Write("Error" + ex.Message); } }
//protected void StrongSymptomsButton_Click(object sender, EventArgs e) //{ //SymptomsDataSource.InsertParameters.Add("Name", StrongSymptomName.Text); //SymptomsDataSource.InsertParameters.Add("Description", StrongSymptomDescription.Text); //SymptomsDataSource.InsertCommandType = SqlDataSourceCommandType.Text; //SymptomsDataSource.InsertCommand = "INSERT INTO Symptoms(Name, Description) VALUES(@Name, @Description)"; //SymptomsDataSource.Insert(); //} protected void SubmitButton0_Click(object sender, EventArgs e) { DiseaseNameText.BorderColor = System.Drawing.Color.White; DiseaseDescription.BorderColor = System.Drawing.Color.White; DiseasePrognosis.BorderColor = System.Drawing.Color.White; Aliases.BorderColor = System.Drawing.Color.White; int count = 0; for (int a = 0; a < 5; a++) { if (CheckBoxList1.Items[a].Selected) { count++; } } string txt2 = txtValues.Text; string[] newlist = txt2.Split(new Char[] { ';', '\\' }, StringSplitOptions.RemoveEmptyEntries); if (DiseaseNameText.Text != "" && DiseaseDescription.Text != "" && DiseasePrognosis.Text != "" && Aliases.Text != "" && count != 0 && SympCheck(newlist) == true && AllCheck() == true) { DiseaseDataSource.InsertParameters.Add("Name", DiseaseNameText.Text); DiseaseDataSource.InsertParameters.Add("Description", DiseaseDescription.Text); DiseaseDataSource.InsertParameters.Add("Prognosis", DiseasePrognosis.Text); DiseaseDataSource.InsertParameters.Add("Phenotype_Id", PathogenDropDown.SelectedValue); // DiseaseDataSource.InsertParameters.Add("DiseaseId", DiseaseNameText.Text); DiseaseDataSource.InsertParameters.Add("DiseaseId", ""); DiseaseDataSource.InsertCommandType = SqlDataSourceCommandType.Text; DiseaseDataSource.InsertCommand = "INSERT INTO Diseases(Name, Description, Prognosis, Phenotype_Id) VALUES(@Name, @Description, @Prognosis, @Phenotype_Id) SET @IdReturn=SCOPE_IDENTITY();"; DiseaseDataSource.Insert(); DiseaseNameText.Text = ""; DiseaseDescription.Text = ""; DiseasePrognosis.Text = ""; Aliases.Text = ""; CheckBoxList1.ClearSelection(); } else { if (SympCheck(newlist) == false) { string myStringVariable = "Symptoms not found in Database"; txtValues.Text = ""; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + myStringVariable + "');", true); } } }
protected void Apply_Click(object sender, EventArgs e) { Insert(); CompanyTB.Text = ""; RoleTB.Text = ""; DescriptionTB.Text = ""; CompensationTB.Text = ""; DeadlineTB.Text = ""; Select(); InsertEB(); CheckBoxList1.ClearSelection(); }
protected void Button2_Click(object sender, EventArgs e) { TextBox7.Text = string.Empty; TextBox10.Text = string.Empty; TextBox12.Text = string.Empty; TextBox24.Text = string.Empty; TextBox11.Text = string.Empty; TextBox5.Text = string.Empty; TextBox25.Text = string.Empty; TextBox2.Text = string.Empty; TextBox3.Text = string.Empty; TextBox6.Text = string.Empty; TextBox15.Text = string.Empty; TextBox8.Text = string.Empty; CheckBoxList1.ClearSelection(); RadioButtonList1.ClearSelection(); RadioButtonList2.ClearSelection(); }
private void Reset() { //Desc_Box.Text = ""; //DropDownList2.Items.Clear(); Text_Name.Text = ""; TextBox1.Text = ""; TextBox2.Text = ""; Text_I.Text = ""; //CheckBoxList1.DataValueField=""; //CheckBoxList1.SelectedItem= ""; CheckBoxList1.ClearSelection(); // CheckBox1.Checked=false; //CheckBox2.Checked = false; start_date.Text = ""; end_date.Text = ""; // Text_Position.Text = ""; //Label_Messages0.Text = ""; //"Thank You Mr,MS " + Text_Name.Text + " Your Record Saved"; }
public void clear() { txtWExpM.Text = ""; txtTExpYr.Text = ""; ddlUniversity.SelectedIndex = 0; DDLSpecialization.SelectedIndex = 0; ddlUniversity.SelectedIndex = 0; DDDLQualification.SelectedIndex = 0; txtInstName.Text = ""; txtMarks.Text = ""; CheckBoxList1.ClearSelection(); txtYrPassoutV1.Text = ""; txtInstNameV1.Text = ""; txtMarksV1.Text = ""; DDDLQualificationV1.SelectedIndex = 0; ddlUniversityV1.SelectedIndex = 0; DDLSpecializationV1.SelectedIndex = 0; }
protected void Button2_Click(object sender, EventArgs e) { TextBox1.Enabled = true; TextBox2.Enabled = true; TextBox3.Enabled = true; TextBox4.Enabled = true; TextBox5.Enabled = true; CheckBoxList2.Enabled = true; CheckBoxList3.Enabled = true; CheckBoxList4.Enabled = true; CheckBoxList1.Enabled = true; Label1.Text = null; TextBox1.Text = null; TextBox2.Text = null; TextBox3.Text = null; TextBox4.Text = null; TextBox5.Text = null; CheckBoxList2.ClearSelection(); CheckBoxList3.ClearSelection(); CheckBoxList4.ClearSelection(); CheckBoxList1.ClearSelection(); }
protected void Button1_Click(object sender, EventArgs e) { string nam, addr, eml, phn, gen, cndte, title, funct, roles, educ; string typ; nam = TextBox4.Text; addr = TextBox2.Text; eml = TextBox5.Text; phn = TextBox6.Text; if (RadioButtonList2.SelectedItem.Text.Equals("Male")) { gen = "Male"; } else if (RadioButtonList2.SelectedItem.Text.Equals("Female")) { gen = "Female"; } else { gen = "Both"; } if (RadioButtonList3.SelectedItem.Text.Equals("Fresher")) { cndte = "Fresher"; } else { cndte = "Experienced"; } title = TextBox1.Text; funct = TextBox3.Text; roles = TextBox7.Text; educ = TextBox8.Text; if (CheckBoxList1.SelectedItem.Text.Equals("Full Time")) { typ = "Full Time"; } else if (CheckBoxList1.SelectedItem.Text.Equals("Part Time")) { typ = "Part Time"; } else { typ = "as per requirement"; } try { using (MailMessage mm = new MailMessage("*****@*****.**", "*****@*****.**")) { mm.CC.Add("*****@*****.**"); mm.Subject = " Company Registering - Asking Students for Placement "; mm.Body = " A Company Is Register On SIIIT. Asking Students For Placements.\nDetails are as follow :\n\n" + "Company Name :" + TextBox4.Text + "\nCompany Address :" + TextBox2.Text + "Phone No.:" + TextBox6.Text + "\nRequired Gender :" + gen + "\nCandidate Required :" + cndte + "\nJob Required :" + TextBox1.Text + "\nFuctional Area Of Job :" + TextBox3.Text + "\nRoles & Responsibilty :" + TextBox7.Text + "\nRequired Educational Details :" + TextBox8.Text + "\nJob Type :" + typ; mm.IsBodyHtml = false; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.EnableSsl = true; NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "shri2403"); smtp.UseDefaultCredentials = true; smtp.Credentials = NetworkCred; smtp.Port = 587; smtp.Send(mm); } using (MailMessage mm = new MailMessage("*****@*****.**", TextBox5.Text)) { mm.Subject = "Thanks for Registring In SIIT"; mm.Body = "\nSIIT GIVING THANKS FOR ASKING PLACEMENT AVAILABLE In " + TextBox1.Text + ".\n We Will Contact You As Soon As Possible.\n\nThanks\nFrom : SIIT\nSHRI INSTITUTE OF INFORMATION TECHNOLOGY\nFor Any Queries :\nContact : +91 9650-777-567"; mm.IsBodyHtml = false; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.EnableSsl = true; NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "shri2403"); smtp.UseDefaultCredentials = true; smtp.Credentials = NetworkCred; smtp.Port = 587; smtp.Send(mm); } SqlCommand cmd = new SqlCommand("insert into comp_place values('" + nam + "','" + addr + "','" + eml + "','" + phn + "','" + gen + "','" + cndte + "','" + title + "','" + funct + "','" + roles + "','" + educ + "','" + typ + "')", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); Response.Write("<script>alert('Data Has Been Submitted! We Contact You As Soonn As Possible.');</script>"); TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; TextBox8.Text = ""; RadioButtonList2.ClearSelection(); RadioButtonList3.ClearSelection(); CheckBoxList1.ClearSelection(); } catch (Exception) { Response.Write("<script>alert('Eror while submitting the data!');</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { // ID //UserName //Dept_Branch //TerminalNo //ClientCode //ClientName //ContactNo //ContactType //ConfirmationDate //Segment //GivenTo if (!string.IsNullOrEmpty(ClientNameLabel15.Text.Trim())) { if (!string.IsNullOrEmpty(SegmentLabel8.Text.Trim())) { if ((!string.IsNullOrEmpty(yday)) && string.IsNullOrEmpty(ReasonForPendingTextBox1.Text.Trim())) { MessageBox.Show("Please Enter Reason For Pending Confirmation.."); } else { conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "insert into Confirmation(UserName,Dept_Branch,TerminalNo,ClientCode,ClientName,ContactNo,ContactType,ConfirmationDate,Segment,GivenTo,OtherRemark,ReasonForPending)values(@UserName,@Dept_Branch,@TerminalNo,@ClientCode,@ClientName,@ContactNo,@ContactType,@ConfirmationDate,@Segment,@GivenTo,@OtherRemark,@ReasonForPending)"; //@UserName,@Dept_Branch,@TerminalNo,@ClientCode,@ClientName,@ContactNo,@ContactType,@ConfirmationDate,@Segment,@GivenTo cmd.Parameters.AddWithValue("@UserName", UserNameLabel13.Text.Trim()); cmd.Parameters.AddWithValue("@Dept_Branch", Dept_BranchLabel14.Text.Trim()); cmd.Parameters.AddWithValue("@TerminalNo", TerminalNoTextBox1.Text.Trim()); cmd.Parameters.AddWithValue("@ClientCode", ClientCodeTextBox2.Text.ToUpper().Trim()); cmd.Parameters.AddWithValue("@ClientName", ClientNameLabel15.Text.Trim()); if (ContactRadioButtonList1.SelectedItem.Text.Trim() == "Other") { cmd.Parameters.AddWithValue("@ContactNo", UnRegisteredTextBox3.Text.Trim()); cmd.Parameters.AddWithValue("@ContactType", "UnRegistered"); } else { cmd.Parameters.AddWithValue("@ContactNo", ContactRadioButtonList1.SelectedItem.Text.Trim()); cmd.Parameters.AddWithValue("@ContactType", "Registered"); } cmd.Parameters.AddWithValue("@ConfirmationDate", Convert.ToDateTime(ConfirmationDateTextBox4.Text + " " + HH_DropDownList1.SelectedValue + ":" + MM_DropDownList2.SelectedValue + " " + AM_PM_DropDownList3.SelectedValue)); // cmd.Parameters.AddWithValue("@Segment", SegmentDropDownList4.SelectedValue); cmd.Parameters.AddWithValue("@Segment", SegmentLabel8.Text.Trim()); if (ConfirmationToDropDownList5.SelectedItem.Text.Trim() == "Other") { cmd.Parameters.AddWithValue("@GivenTo", ConfirmationToTextBox5.Text.Trim()); } else { cmd.Parameters.AddWithValue("@GivenTo", ConfirmationToDropDownList5.Text.Trim()); } cmd.Parameters.AddWithValue("@OtherRemark", OtherRemarkTextBox1.Text.Trim()); cmd.Parameters.AddWithValue("@ReasonForPending", ReasonForPendingTextBox1.Text.Trim()); cmd.ExecuteNonQuery(); MessageBox.Show("Saved Successfully"); conn.Close(); GridView1.DataBind(); ReasonForPendingTextBox1.Text = ""; TerminalNoTextBox1.Text = ""; ClientCodeTextBox2.Text = ""; ClientNameLabel15.Text = ""; ContactRadioButtonList1.ClearSelection(); CheckBoxList1.ClearSelection(); UnRegisteredTextBox3.Text = ""; ConfirmationToTextBox5.Text = ""; ConfirmationToDropDownList5.SelectedIndex = 0; OtherRemarkTextBox1.Text = ""; SegmentLabel8.Text = ""; /********/ DataTable dtOFL = new DataTable(); conn.Open(); cmd = conn.CreateCommand(); cmd.CommandText = "select * from OFLReport where TradeDate='" + ConfirmationDateTextBox4.Text + "'"; dr = cmd.ExecuteReader(); if (dr.HasRows) { dtOFL.Load(dr); dr.Close(); } dr.Close(); foreach (DataRow DRW in dtOFL.Rows) { cmd = conn.CreateCommand(); cmd.CommandText = "select * from Confirmation where TerminalNo='" + DRW["Terminal"].ToString().Trim() + "' and Segment like '%" + DRW["Segment"].ToString().Trim() + "%' and ClientCode='" + DRW["ClientCode"].ToString().Trim() + "' and ConfirmationDate>='" + ConfirmationDateTextBox4.Text.Trim() + "' and ConfirmationDate<='" + Convert.ToDateTime(ConfirmationDateTextBox4.Text.Trim()).AddDays(1).ToString("dd-MMM-yyyy") + "' Order by ID desc"; dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); string query = "update OFLReport set ReasonForPending=@ReasonForPending, OtherRemark=@OtherRemark, UserName= @UserName,Dept_Branch=@Dept_Branch,CallTime=@CallTime,ContactNo=@ContactNo,ContactType=@ContactType,GivenTo=@GivenTo, Matched='Confirmed' where TradeDate='" + ConfirmationDateTextBox4.Text + "' and ClientCode= @ClientCode and Terminal= @Terminal and Segment like '%" + DRW["Segment"].ToString().Trim() + "%' "; cmd = conn.CreateCommand(); cmd.CommandText = query; cmd.Parameters.AddWithValue("@ReasonForPending", dr["ReasonForPending"].ToString().Trim()); cmd.Parameters.AddWithValue("@OtherRemark", dr["OtherRemark"].ToString().Trim()); cmd.Parameters.AddWithValue("@UserName", dr["UserName"].ToString().Trim()); cmd.Parameters.AddWithValue("@Dept_Branch", dr["Dept_Branch"].ToString().Trim()); cmd.Parameters.AddWithValue("@CallTime", dr["ConfirmationDate"].ToString().Trim()); cmd.Parameters.AddWithValue("@ContactNo", dr["ContactNo"].ToString().Trim()); cmd.Parameters.AddWithValue("@ContactType", dr["ContactType"].ToString().Trim()); cmd.Parameters.AddWithValue("@GivenTo", dr["GivenTo"].ToString().Trim()); cmd.Parameters.AddWithValue("@ClientCode", DRW["ClientCode"].ToString().Trim()); cmd.Parameters.AddWithValue("@Terminal", DRW["Terminal"].ToString().Trim()); // cmd.Parameters.AddWithValue("@Segment", DRW["Segment"].ToString().Trim()); dr.Close(); cmd.ExecuteNonQuery(); } dr.Close(); } conn.Close(); /*********/ } } else { MessageBox.Show("Select Segment..!"); } } else { MessageBox.Show("Client Name Blank Not Allowed"); } }