dynamically Add Linkbutton To Delete row in Gridview

DataTable dt = new DataTable();
string g5 = "0", g12 = "0", g18 = "0", g28 = "0", cgamt, sgamt, tot;
protected void Page_Load(object sender, EventArgs e)
{
txtBdate.Text = DateTime.Now.ToString("dd-MM-yyyy hh:mm tt");
txtFdis.Visible = false;
lbldis.Visible = false;
lbltax.Visible = false;
txttax.Visible = false;
//---------- Bill Number Generation
int a;
string query = "select max(Billno) from Bill";
con.Open();
cmd = new SqlCommand(query, con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
string val = dr[0].ToString();
if (val == "")
{
Bno = 1;
HfBno.Value = Bno.ToString();
}
else
{
a = Convert.ToInt32(dr[0].ToString());
a = a + 1;
Bno = a;
HfBno.Value = Bno.ToString();
}
con.Close();
}
if (!Page.IsPostBack)
{
if (ViewState["Records"] == null)
{
dt.Columns.Add("ID");
dt.Columns.Add("Qno");
dt.Columns.Add("Name");
dt.Columns.Add("Mobile");
dt.Columns.Add("Mail");
dt.Columns.Add("Gst");
dt.Columns.Add("City");
dt.Columns.Add("Address");
dt.Columns.Add("Btype");
dt.Columns.Add("Bdate");
dt.Columns.Add("Item Description");
dt.Columns.Add("Code"); //----H * W
dt.Columns.Add("HSN");
dt.Columns.Add("Quantity");
dt.Columns.Add("Price");
dt.Columns.Add("TAX %");
dt.Columns.Add("Tax Amount");
dt.Columns.Add("Discount");
dt.Columns.Add("Dis Amount");
dt.Columns.Add("GST 5");
dt.Columns.Add("GST 12");
dt.Columns.Add("GST 18");
dt.Columns.Add("GST 28");
dt.Columns.Add("CGST Amt");
dt.Columns.Add("SGST Amt");
dt.Columns.Add("Amount");
dt.Columns.Add("Paid");
dt.Columns.Add("Bal");
dt.Columns.Add("Notes");
dt.Columns.Add("Action");
ViewState["Records"] = dt;
}
}
}
protected void ShowMob(object sender, EventArgs e)
{
//string title = "Greetings";
//string body = "Welcome to ASPSnippets.com";
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowMob();", true);
}
protected void txtpcode_TextChanged(object sender, EventArgs e)
{
try
{
con.Open();
string query = "SELECT * FROM offset WHERE subhead = '" + txtpcode.Text + "'";
cmd = new SqlCommand(query, con);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
txtpname.Text = sdr[1].ToString();
txtamt.Text = sdr[7].ToString();
txthsn.Text = sdr[9].ToString();
txttax.Text = sdr[10].ToString();
sdr.Close();
}
con.Close();
}
catch
{
Response.Write(" alert('Error....') ");
}
code = txtpcode.Text;
type = code.Substring(0, 1);
if (type == "G")
{
lbltax.Visible = true;
txttax.Visible = true;
}
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowMob();", true);
}
protected void btnFSave_Click(object sender, EventArgs e)
{
decimal tax, price, disamt, cal, tcal, qty;
tax = Convert.ToDecimal(txttax.Text);
price = Convert.ToDecimal(txtamt.Text);
qty = Convert.ToDecimal(txtqty.Text); //-------Quantity
code = txtpcode.Text;
type = code.Substring(0, 1);
if (txtName.Text != "" && txtmobile.Text != "")
{
if (type == "G")
{
//-------- Tax Amount Calculation
if (tax == 5)
{
cal = (tax / 100);
tcal = price * cal;
g5 = tcal.ToString();
}
else if (tax == 12)
{
cal = (tax / 100);
tcal = price * cal;
g12 = tcal.ToString();
}
else if (tax == 18)
{
cal = (tax / 100);
tcal = price * cal;
g18 = tcal.ToString();
}
else if (tax == 28)
{
cal = (tax / 100);
tcal = price * cal;
g28 = tcal.ToString();
}
disamt = DiscAmt(); //-----Discount Amount
//----CGST And SGST Calculation-----
cal = (tax / 100);
tcal = (price * cal) / 2;
cgamt = tcal.ToString();
sgamt = cgamt;
//---------Total Calculation--------
cal = (qty * price);
tcal = (cal + (Convert.ToDecimal(cgamt) + Convert.ToDecimal(sgamt))) - disamt;
tot = tcal.ToString();
dt = (DataTable)ViewState["Records"];
dt.Rows.Add("1", HfBno.Value, txtName.Text, txtmobile.Text, "-", "0", txtcity.Text, "-", "0", txtBdate.Text, txtpname.Text, txtpcode.Text, txthsn.Text, qty, price, tax, Famtcal(), Convert.ToString(string.IsNullOrEmpty(txtFdis.Text) ? "0" : txtFdis.Text), disamt, g5, g12, g18, g28, cgamt, sgamt, tot, "0", tot, Convert.ToString(string.IsNullOrEmpty(txtFnote.Text) ? "-" : txtFnote.Text));
GVShowdata.DataSource = dt;
GVShowdata.DataBind();
Flex_clear();
}
else if (type == "N")
{
disamt = DiscAmt();
tot = (Famtcal() - disamt).ToString();
dt = (DataTable)ViewState["Records"];
dt.Rows.Add("1", HfBno.Value, txtName.Text, txtmobile.Text, "-", "0", txtcity.Text, "-", "0", txtBdate.Text, txtpname.Text, txtpcode.Text, txthsn.Text, qty, price, "0", Famtcal(), Convert.ToString(string.IsNullOrEmpty(txtFdis.Text) ? "0" : txtFdis.Text), disamt, "0", "0", "0", "0", "0", "0", tot, "0", tot, Convert.ToString(string.IsNullOrEmpty(txtFnote.Text) ? "-" : txtFnote.Text));
GVShowdata.DataSource = dt;
GVShowdata.DataBind();
Flex_clear();
}
else
{
Response.Write(" alert('Please Enter Valid Details.....') ");
Flex_clear();
}
}
else
{
Response.Write(" alert('Please Enter Name & Mobile No.....') ");
}
}
private decimal Famtcal()
{
decimal qty, price, tcal;
qty = Convert.ToDecimal(txtqty.Text);
price = Convert.ToDecimal(txtamt.Text);
tcal = price * qty;
return tcal;
}
private decimal DiscAmt()
{
decimal dis, price, Disamt = 0;
if (txtFdis.Text != "")
{
dis = Convert.ToDecimal(txtFdis.Text);
price = Convert.ToDecimal(txtamt.Text);
Disamt = (price * (dis / 100));
return Disamt;
}
else
{
return Disamt;
}
}
private void Flex_clear()
{
txtpname.Text = "";
txthsn.Text = "";
txtFnote.Text = "";
txtpcode.Text = "";
txtFdis.Text = "";
txtamt.Text = "";
txtqty.Text = "";
txttax.Text = "";
}
protected void GVShowdata_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
e.Row.Cells[0].Visible = false;
e.Row.Cells[1].Visible = false;
e.Row.Cells[2].Visible = false;
e.Row.Cells[3].Visible = false;
e.Row.Cells[4].Visible = false;
e.Row.Cells[5].Visible = false;
e.Row.Cells[6].Visible = false;
e.Row.Cells[7].Visible = false;
e.Row.Cells[8].Visible = false;
e.Row.Cells[9].Visible = false;
e.Row.Cells[16].Visible = false;
e.Row.Cells[17].Visible = false;
e.Row.Cells[18].Visible = false;
e.Row.Cells[19].Visible = false;
e.Row.Cells[20].Visible = false;
e.Row.Cells[21].Visible = false;
e.Row.Cells[22].Visible = false;
e.Row.Cells[26].Visible = false;
e.Row.Cells[27].Visible = false;
e.Row.Cells[10].Attributes["width"] = "150px";
e.Row.Cells[11].Attributes["width"] = "75px";
e.Row.Cells[12].Attributes["width"] = "75px";
e.Row.Cells[13].Attributes["width"] = "75px";
e.Row.Cells[14].Attributes["width"] = "50px";
e.Row.Cells[15].Attributes["width"] = "50px";
e.Row.Cells[23].Attributes["width"] = "75px";
e.Row.Cells[24].Attributes["width"] = "75px";
e.Row.Cells[25].Attributes["width"] = "75px";
e.Row.Cells[28].Attributes["width"] = "150px";
if (e.Row.DataItem != null)
{
LinkButton lb = new LinkButton();
lb.CommandArgument = e.Row.Cells[29].Text;
lb.CommandName = "Delete";
lb.Text = "Delete";
e.Row.Cells[29].Controls.Add((Control)lb);
}
}
protected void GVShowdata_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int RemoveAt = gvr.RowIndex;
DataTable dt = new DataTable();
dt = (DataTable)ViewState["Records"];
dt.Rows.RemoveAt(RemoveAt);
dt.AcceptChanges();
GVShowdata.DataSource = dt;
GVShowdata.DataBind();
}
}
protected void GVShowdata_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = Convert.ToInt32(e.RowIndex);
DataTable dt = ViewState["dt"] as DataTable;
dt.Rows[index].Delete();
ViewState["dt"] = dt;
GVShowdata.DataBind();
}
protected void btnBill_Click(object sender, EventArgs e)
{
try
{
foreach(GridViewRow gr in GVShowdata.Rows)
{
SqlCommand cmd1 = new SqlCommand("Insert into Bill(Cusid,Billno,Name,Mobile,Mail,City,Address,Gst,Btype,Bdate,Pname,H_W,Hsn,Qty,Price,Tax,TaxAmt,Dis,Disamt,Gst_5,Gst_12,Gst_18,Gst_28,CGAmt,SGAmt,Total,Paid,Bal,Notes) Values(@Cusid,@Billno,@Name,@Mobile,@Mail,@City,@Address,@Gst,@Btype,@Bdate,@Pname,@H_W,@Hsn,@Qty,@Price,@Tax,@TaxAmt,@Dis,@Disamt,@Gst_5,@Gst_12,@Gst_18,@Gst_28,@CGAmt,@SGAmt,@Total,@Paid,@Bal,@Notes)", con);
con.Open();
cmd1.Parameters.AddWithValue("Cusid",gr.Cells[0].Text);
cmd1.Parameters.AddWithValue("Billno", gr.Cells[1].Text);
cmd1.Parameters.AddWithValue("Name", gr.Cells[2].Text);
cmd1.Parameters.AddWithValue("Mobile", gr.Cells[3].Text);
cmd1.Parameters.AddWithValue("Mail", gr.Cells[4].Text);
cmd1.Parameters.AddWithValue("Gst", gr.Cells[5].Text);
cmd1.Parameters.AddWithValue("City", gr.Cells[6].Text);
cmd1.Parameters.AddWithValue("Address", gr.Cells[7].Text);
cmd1.Parameters.AddWithValue("Btype", gr.Cells[8].Text);
cmd1.Parameters.AddWithValue("Bdate", DateTime.Parse(gr.Cells[9].Text));
cmd1.Parameters.AddWithValue("Pname", gr.Cells[10].Text);
cmd1.Parameters.AddWithValue("H_W", gr.Cells[11].Text);
cmd1.Parameters.AddWithValue("Hsn", gr.Cells[12].Text);
cmd1.Parameters.AddWithValue("Qty", gr.Cells[13].Text);
cmd1.Parameters.AddWithValue("Price", gr.Cells[14].Text);
cmd1.Parameters.AddWithValue("Tax", gr.Cells[15].Text);
cmd1.Parameters.AddWithValue("TaxAmt", gr.Cells[16].Text);
cmd1.Parameters.AddWithValue("Dis", gr.Cells[17].Text);
cmd1.Parameters.AddWithValue("Disamt", gr.Cells[18].Text);
cmd1.Parameters.AddWithValue("Gst_5", gr.Cells[19].Text);
cmd1.Parameters.AddWithValue("Gst_12", gr.Cells[20].Text);
cmd1.Parameters.AddWithValue("Gst_18", gr.Cells[21].Text);
cmd1.Parameters.AddWithValue("Gst_28", gr.Cells[22].Text);
cmd1.Parameters.AddWithValue("CGAmt", gr.Cells[23].Text);
cmd1.Parameters.AddWithValue("SGAmt", gr.Cells[24].Text);
cmd1.Parameters.AddWithValue("Total", gr.Cells[25].Text);
cmd1.Parameters.AddWithValue("Paid", gr.Cells[26].Text);
cmd1.Parameters.AddWithValue("Bal", gr.Cells[27].Text);
cmd1.Parameters.AddWithValue("Notes", gr.Cells[28].Text);
int x = cmd1.ExecuteNonQuery();
cmd1.Parameters.Clear();
con.Close();
}
}
catch
{
Response.Write(" alert('invalid input....') ");
}
Response.Redirect("frmGbill.aspx?Id=" + HfBno.Value);
}
protected void btnExit_Click(object sender, EventArgs e)
{
Response.Redirect("frmBlank.aspx");
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Accepted answer
Hello,

You need to bind your gridview and need to assign datatable to gridview.datasource after dt.acceptchange();
if (e.CommandName == "Delete")
       {
           GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
           int RemoveAt = gvr.RowIndex;
           DataTable dt = new DataTable();
           dt = (DataTable)ViewState["Records"];
           dt.Rows.RemoveAt(RemoveAt);
           dt.AcceptChanges();
           GVShowdata.DataSource = dt;
           GVShowdata.DataBind();

       }
+2
dhoni kholi6y ago
1. DataTable dt = new DataTable();
3. string g5 = "0", g12 = "0", g18 = "0", g28 = "0", cgamt, sgamt, tot;
5. protected void Page_Load(object sender, EventArgs e)
6. {
7. txtBdate.Text = DateTime.Now.ToString("dd-MM-yyyy hh:mm tt");
8. txtFdis.Visible = false;
9. lbldis.Visible = false;
10. lbltax.Visible = false;
11. txttax.Visible = false;
13. //---------- Bill Number Generation
14. int a;
15. string query = "select max(Billno) from Bill";
16. con.Open();
17. cmd = new SqlCommand(query, con);
18. SqlDataReader dr;
19. dr = cmd.ExecuteReader();
21. if (dr.Read())
22. {
23. string val = dr[0].ToString();
24. if (val == "")
25. {
26. Bno = 1;
27. HfBno.Value = Bno.ToString();
28. }
29. else
30. {
31. a = Convert.ToInt32(dr[0].ToString());
32. a = a + 1;
33. Bno = a;
34. HfBno.Value = Bno.ToString();
35. }
36. con.Close();
37. }
39. if (!Page.IsPostBack)
40. {
41. if (ViewState["Records"] == null)
42. {
43. dt.Columns.Add("ID");
44. dt.Columns.Add("Qno");
45. dt.Columns.Add("Name");
46. dt.Columns.Add("Mobile");
47. dt.Columns.Add("Mail");
48. dt.Columns.Add("Gst");
49. dt.Columns.Add("City");
50. dt.Columns.Add("Address");
51. dt.Columns.Add("Btype");
52. dt.Columns.Add("Bdate");
53. dt.Columns.Add("Item Description");
54. dt.Columns.Add("Code"); //----H * W
55. dt.Columns.Add("HSN");
56. dt.Columns.Add("Quantity");
57. dt.Columns.Add("Price");
58. dt.Columns.Add("TAX %");
59. dt.Columns.Add("Tax Amount");
60. dt.Columns.Add("Discount");
61. dt.Columns.Add("Dis Amount");
62. dt.Columns.Add("GST 5");
63. dt.Columns.Add("GST 12");
64. dt.Columns.Add("GST 18");
65. dt.Columns.Add("GST 28");
66. dt.Columns.Add("CGST Amt");
67. dt.Columns.Add("SGST Amt");
68. dt.Columns.Add("Amount");
69. dt.Columns.Add("Paid");
70. dt.Columns.Add("Bal");
71. dt.Columns.Add("Notes");
72. dt.Columns.Add("Action");
73. ViewState["Records"] = dt;
74. }
75. }
76. }
78. protected void ShowMob(object sender, EventArgs e)
79. {
80. //string title = "Greetings";
81. //string body = "Welcome to ASPSnippets.com";
82. ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowMob();", true);
83. }
85. protected void txtpcode_TextChanged(object sender, EventArgs e)
86. {
87. try
88. {
89. con.Open();
90. string query = "SELECT * FROM offset WHERE subhead = '" + txtpcode.Text + "'";
91. cmd = new SqlCommand(query, con);
92. SqlDataReader sdr = cmd.ExecuteReader();
93. if (sdr.Read())
94. {
95. txtpname.Text = sdr[1].ToString();
96. txtamt.Text = sdr[7].ToString();
97. txthsn.Text = sdr[9].ToString();
98. txttax.Text = sdr[10].ToString();
100. sdr.Close();
101. }
102. con.Close();
103. }
104. catch
105. {
106. Response.Write(" alert('Error....') ");
107. }
109. code = txtpcode.Text;
110. type = code.Substring(0, 1);
111. if (type == "G")
112. {
113. lbltax.Visible = true;
114. txttax.Visible = true;
115. }
116. ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowMob();", true);
117. }
119. protected void btnFSave_Click(object sender, EventArgs e)
120. {
121. decimal tax, price, disamt, cal, tcal, qty;
122. tax = Convert.ToDecimal(txttax.Text);
123. price = Convert.ToDecimal(txtamt.Text);
124. qty = Convert.ToDecimal(txtqty.Text); //-------Quantity
126. code = txtpcode.Text;
127. type = code.Substring(0, 1);
128. if (txtName.Text != "" && txtmobile.Text != "")
129. {
130. if (type == "G")
131. {
132. //-------- Tax Amount Calculation
133. if (tax == 5)
134. {
135. cal = (tax / 100);
136. tcal = price * cal;
137. g5 = tcal.ToString();
138. }
139. else if (tax == 12)
140. {
141. cal = (tax / 100);
142. tcal = price * cal;
143. g12 = tcal.ToString();
144. }
145. else if (tax == 18)
146. {
147. cal = (tax / 100);
148. tcal = price * cal;
149. g18 = tcal.ToString();
150. }
151. else if (tax == 28)
152. {
153. cal = (tax / 100);
154. tcal = price * cal;
155. g28 = tcal.ToString();
156. }
158. disamt = DiscAmt(); //-----Discount Amount
160. //----CGST And SGST Calculation-----
161. cal = (tax / 100);
162. tcal = (price * cal) / 2;
163. cgamt = tcal.ToString();
164. sgamt = cgamt;
165. //---------Total Calculation--------
166. cal = (qty * price);
167. tcal = (cal + (Convert.ToDecimal(cgamt) + Convert.ToDecimal(sgamt))) - disamt;
168. tot = tcal.ToString();
170. dt = (DataTable)ViewState["Records"];
171. dt.Rows.Add("1", HfBno.Value, txtName.Text, txtmobile.Text, "-", "0", txtcity.Text, "-", "0", txtBdate.Text, txtpname.Text, txtpcode.Text, txthsn.Text, qty, price, tax, Famtcal(), Convert.ToString(string.IsNullOrEmpty(txtFdis.Text) ? "0" : txtFdis.Text), disamt, g5, g12, g18, g28, cgamt, sgamt, tot, "0", tot, Convert.ToString(string.IsNullOrEmpty(txtFnote.Text) ? "-" : txtFnote.Text));
173. GVShowdata.DataSource = dt;
174. GVShowdata.DataBind();
175. Flex_clear();
177. }
178. else if (type == "N")
179. {
180. disamt = DiscAmt();
181. tot = (Famtcal() - disamt).ToString();
183. dt = (DataTable)ViewState["Records"];
184. dt.Rows.Add("1", HfBno.Value, txtName.Text, txtmobile.Text, "-", "0", txtcity.Text, "-", "0", txtBdate.Text, txtpname.Text, txtpcode.Text, txthsn.Text, qty, price, "0", Famtcal(), Convert.ToString(string.IsNullOrEmpty(txtFdis.Text) ? "0" : txtFdis.Text), disamt, "0", "0", "0", "0", "0", "0", tot, "0", tot, Convert.ToString(string.IsNullOrEmpty(txtFnote.Text) ? "-" : txtFnote.Text));
186. GVShowdata.DataSource = dt;
187. GVShowdata.DataBind();
188. Flex_clear();
189. }
190. else
191. {
192. Response.Write(" alert('Please Enter Valid Details.....') ");
193. Flex_clear();
194. }
195. }
196. else
197. {
198. Response.Write(" alert('Please Enter Name & Mobile No.....') ");
199. }
200. }
202. private decimal Famtcal()
203. {
204. decimal qty, price, tcal;
205. qty = Convert.ToDecimal(txtqty.Text);
206. price = Convert.ToDecimal(txtamt.Text);
207. tcal = price * qty;
208. return tcal;
209. }
210. private decimal DiscAmt()
211. {
212. decimal dis, price, Disamt = 0;
213. if (txtFdis.Text != "")
214. {
215. dis = Convert.ToDecimal(txtFdis.Text);
216. price = Convert.ToDecimal(txtamt.Text);
217. Disamt = (price * (dis / 100));
218. return Disamt;
219. }
220. else
221. {
222. return Disamt;
223. }
224. }
225. private void Flex_clear()
226. {
227. txtpname.Text = "";
228. txthsn.Text = "";
229. txtFnote.Text = "";
230. txtpcode.Text = "";
231. txtFdis.Text = "";
232. txtamt.Text = "";
233. txtqty.Text = "";
234. txttax.Text = "";
235. }
237. protected void GVShowdata_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
238. {
239. e.Row.Cells[0].Visible = false;
240. e.Row.Cells[1].Visible = false;
241. e.Row.Cells[2].Visible = false;
242. e.Row.Cells[3].Visible = false;
243. e.Row.Cells[4].Visible = false;
244. e.Row.Cells[5].Visible = false;
245. e.Row.Cells[6].Visible = false;
246. e.Row.Cells[7].Visible = false;
247. e.Row.Cells[8].Visible = false;
248. e.Row.Cells[9].Visible = false;
249. e.Row.Cells[16].Visible = false;
250. e.Row.Cells[17].Visible = false;
251. e.Row.Cells[18].Visible = false;
252. e.Row.Cells[19].Visible = false;
253. e.Row.Cells[20].Visible = false;
254. e.Row.Cells[21].Visible = false;
255. e.Row.Cells[22].Visible = false;
256. e.Row.Cells[26].Visible = false;
257. e.Row.Cells[27].Visible = false;
259. e.Row.Cells[10].Attributes["width"] = "150px";
260. e.Row.Cells[11].Attributes["width"] = "75px";
261. e.Row.Cells[12].Attributes["width"] = "75px";
262. e.Row.Cells[13].Attributes["width"] = "75px";
263. e.Row.Cells[14].Attributes["width"] = "50px";
264. e.Row.Cells[15].Attributes["width"] = "50px";
265. e.Row.Cells[23].Attributes["width"] = "75px";
266. e.Row.Cells[24].Attributes["width"] = "75px";
267. e.Row.Cells[25].Attributes["width"] = "75px";
268. e.Row.Cells[28].Attributes["width"] = "150px";
272. if (e.Row.DataItem != null)
273. {
274. LinkButton lb = new LinkButton();
275. lb.CommandArgument = e.Row.Cells[29].Text;
276. lb.CommandName = "Delete";
277. lb.Text = "Delete";
278. e.Row.Cells[29].Controls.Add((Control)lb);
279. }
281. }
283. protected void GVShowdata_RowCommand(object sender, GridViewCommandEventArgs e)
284. {
286. if (e.CommandName == "Delete")
287. {
288. GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
289. int RemoveAt = gvr.RowIndex;
290. DataTable dt = new DataTable();
291. dt = (DataTable)ViewState["Records"];
292. dt.Rows.RemoveAt(RemoveAt);
293. dt.AcceptChanges();
294. GVShowdata.DataSource = dt;
295. GVShowdata.DataBind();
296. }
297. }
299. protected void GVShowdata_RowDeleting(object sender, GridViewDeleteEventArgs e)
300. {
301. int index = Convert.ToInt32(e.RowIndex);
302. DataTable dt = ViewState["dt"] as DataTable;
303. dt.Rows[index].Delete();
304. ViewState["dt"] = dt;
305. GVShowdata.DataBind();
306. }
308. protected void btnBill_Click(object sender, EventArgs e)
309. {
310. try
311. {
312. foreach(GridViewRow gr in GVShowdata.Rows)
313. {
314. SqlCommand cmd1 = new SqlCommand("Insert into Bill(Cusid,Billno,Name,Mobile,Mail,City,Address,Gst,Btype,Bdate,Pname,H_W,Hsn,Qty,Price,Tax,TaxAmt,Dis,Disamt,Gst_5,Gst_12,Gst_18,Gst_28,CGAmt,SGAmt,Total,Paid,Bal,Notes) Values(@Cusid,@Billno,@Name,@Mobile,@Mail,@City,@Address,@Gst,@Btype,@Bdate,@Pname,@H_W,@Hsn,@Qty,@Price,@Tax,@TaxAmt,@Dis,@Disamt,@Gst_5,@Gst_12,@Gst_18,@Gst_28,@CGAmt,@SGAmt,@Total,@Paid,@Bal,@Notes)", con);
315. con.Open();
316. cmd1.Parameters.AddWithValue("Cusid",gr.Cells[0].Text);
317. cmd1.Parameters.AddWithValue("Billno", gr.Cells[1].Text);
318. cmd1.Parameters.AddWithValue("Name", gr.Cells[2].Text);
319. cmd1.Parameters.AddWithValue("Mobile", gr.Cells[3].Text);
320. cmd1.Parameters.AddWithValue("Mail", gr.Cells[4].Text);
321. cmd1.Parameters.AddWithValue("Gst", gr.Cells[5].Text);
322. cmd1.Parameters.AddWithValue("City", gr.Cells[6].Text);
323. cmd1.Parameters.AddWithValue("Address", gr.Cells[7].Text);
324. cmd1.Parameters.AddWithValue("Btype", gr.Cells[8].Text);
325. cmd1.Parameters.AddWithValue("Bdate", DateTime.Parse(gr.Cells[9].Text));
326. cmd1.Parameters.AddWithValue("Pname", gr.Cells[10].Text);
327. cmd1.Parameters.AddWithValue("H_W", gr.Cells[11].Text);
328. cmd1.Parameters.AddWithValue("Hsn", gr.Cells[12].Text);
329. cmd1.Parameters.AddWithValue("Qty", gr.Cells[13].Text);
330. cmd1.Parameters.AddWithValue("Price", gr.Cells[14].Text);
331. cmd1.Parameters.AddWithValue("Tax", gr.Cells[15].Text);
332. cmd1.Parameters.AddWithValue("TaxAmt", gr.Cells[16].Text);
333. cmd1.Parameters.AddWithValue("Dis", gr.Cells[17].Text);
334. cmd1.Parameters.AddWithValue("Disamt", gr.Cells[18].Text);
335. cmd1.Parameters.AddWithValue("Gst_5", gr.Cells[19].Text);
336. cmd1.Parameters.AddWithValue("Gst_12", gr.Cells[20].Text);
337. cmd1.Parameters.AddWithValue("Gst_18", gr.Cells[21].Text);
338. cmd1.Parameters.AddWithValue("Gst_28", gr.Cells[22].Text);
339. cmd1.Parameters.AddWithValue("CGAmt", gr.Cells[23].Text);
340. cmd1.Parameters.AddWithValue("SGAmt", gr.Cells[24].Text);
341. cmd1.Parameters.AddWithValue("Total", gr.Cells[25].Text);
342. cmd1.Parameters.AddWithValue("Paid", gr.Cells[26].Text);
343. cmd1.Parameters.AddWithValue("Bal", gr.Cells[27].Text);
344. cmd1.Parameters.AddWithValue("Notes", gr.Cells[28].Text);
346. int x = cmd1.ExecuteNonQuery();
347. cmd1.Parameters.Clear();
348. con.Close();
349. }
350. }
351. catch
352. {
353. Response.Write(" alert('invalid input....') ");
354. }
356. Response.Redirect("frmGbill.aspx?Id=" + HfBno.Value);
357. }
359. protected void btnExit_Click(object sender, EventArgs e)
360. {
361. Response.Redirect("frmBlank.aspx");
362. }
This is My Entire coding Page
0