protected void Button8_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = objb.getdiagnosis_byipdcode_ipd(Session["prn"].ToString()); IPDDataContext rt1 = new IPDDataContext(); palm_ipd_diagnosis_master pom = new palm_ipd_diagnosis_master(); if (ds.Tables[0].Rows.Count == 0) { pom.pateint_code = Session["pateint_code"].ToString(); pom.prn = Session["prn"].ToString(); pom.inserted_by = Session["emp_code"].ToString(); pom.inserted_on = DateTime.Now; rt1.palm_ipd_diagnosis_masters.InsertOnSubmit(pom); rt1.SubmitChanges(); palm_ipd_final_diagnosi pod = new palm_ipd_final_diagnosi(); pom = rt1.palm_ipd_diagnosis_masters.Single(palm_ipd_diagnosis_master => palm_ipd_diagnosis_master.pateint_code == Session["pateint_code"].ToString()); pod.master_id = pom.opd_diagnosis_master_id; pod.prn = pom.prn; pod.Final_diagnosis = TextBox6.Text; pod.final_remark = TextBox9.Text; rt1.palm_ipd_final_diagnosis.InsertOnSubmit(pod); rt1.SubmitChanges(); } else { palm_ipd_final_diagnosi pod = new palm_ipd_final_diagnosi(); pom = rt1.palm_ipd_diagnosis_masters.Single(palm_ipd_diagnosis_master => palm_ipd_diagnosis_master.pateint_code == Session["pateint_code"].ToString()); pod.master_id = pom.opd_diagnosis_master_id; pod.prn = pom.prn; pod.Final_diagnosis = TextBox6.Text; pod.final_remark = TextBox9.Text; rt1.palm_ipd_final_diagnosis.InsertOnSubmit(pod); rt1.SubmitChanges(); } // BindData1(); GridView2.DataBind(); }