private void save_Click(object sender, EventArgs e) { try { Member member = new Member(); User u = new User(); String cncid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text + "C" + cncbox.Text + ""; String khanaid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text + "C" + cncbox.Text + "K" + khanabox.Text + ""; //MessageBox.Show(khanaid); Khana k = new Khana(); k.Insert( Convert.ToInt32(khanabox.Text), cncid, userid, Convert.ToInt32(chalabox.Text), Convert.ToInt32(wallbox.Text), Convert.ToInt32(floorbox.Text), Convert.ToInt32(watersourcebox.Text), Convert.ToInt32(evaluationbox.Text), Convert.ToInt32(housevaluebox.Text), Convert.ToInt32(totallandbox.Text), Convert.ToInt32(landvaluebox.Text), Convert.ToInt32(cowbox.Text), Convert.ToInt32(goatbox.Text), Convert.ToInt32(henbox.Text), Convert.ToInt32(treebox.Text), Convert.ToInt32(vegitablebox.Text), Convert.ToInt32(monthscoveredbox.Text), Convert.ToInt32(bedbox.Text), Convert.ToInt32(chairbox.Text), Convert.ToInt32(radiobox.Text), Convert.ToInt32(tvbox.Text), Convert.ToInt32(tubewellbox.Text), Convert.ToInt32(gavibox.Text), Convert.ToInt32(sagolbox.Text), Convert.ToInt32(daylabourerbox.Text), Convert.ToInt32(dayslabourbox.Text), Convert.ToInt32(latrinebox.Text), Convert.ToString(datacollectorbox.Text), Convert.ToString(cnocnpbox.Text), Convert.ToString(datebox.Text), khanaid); u.increaseKhanaCount(userid); khanacountbox.Text = u.getKhanaCount(userid).ToString(); for (int j = 0; j < i; j++) { String memberid = "D" + district_no.Text + "T" + thana_no.Text + "U" + union_no.Text + "C" + cncbox.Text + "K" + khanabox.Text + "M" + Convert.ToInt32(dataGridView1[0, j].Value) + ""; member.Insert( memberid, Convert.ToInt32(dataGridView1[0, j].Value), Convert.ToInt32(dataGridView1[1, j].Value), Convert.ToString(dataGridView1[2, j].Value), Convert.ToInt32(dataGridView1[3, j].Value), Convert.ToInt32(dataGridView1[4, j].Value), Convert.ToString(dataGridView1[5, j].Value), Convert.ToInt32(dataGridView1[6, j].Value), Convert.ToInt32(dataGridView1[7, j].Value), Convert.ToInt32(dataGridView1[8, j].Value), Convert.ToInt32(dataGridView1[9, j].Value), float.Parse(dataGridView1[11, j].Value.ToString()), Convert.ToInt32(dataGridView1[12, j].Value), Convert.ToInt32(dataGridView1[13, j].Value), Convert.ToInt32(dataGridView1[10, j].Value), khanaid); u.increaseMemberCount(userid); membercountbox.Text = u.getMemberCount(userid).ToString(); } khanabox.Clear(); chalabox.Clear(); wallbox.Clear(); floorbox.Clear(); watersourcebox.Clear(); evaluationbox.Clear(); housevaluebox.Clear(); totallandbox.Clear(); landvaluebox.Clear(); cowbox.Clear(); goatbox.Clear(); henbox.Clear(); treebox.Clear(); vegitablebox.Clear(); monthscoveredbox.Clear(); bedbox.Clear(); chairbox.Clear(); radiobox.Clear(); tvbox.Clear(); tubewellbox.Clear(); gavibox.Clear(); sagolbox.Clear(); daylabourerbox.Clear(); dayslabourbox.Clear(); latrinebox.Clear(); datacollectorbox.Clear(); cnocnpbox.Clear(); datebox.Clear(); dataGridView1.Rows.Clear(); i = 0; } catch (Exception ex) { } }