01.void myGridView_RowCommand(Object source , GridViewCommandEventArgs e)
02.{
03. if (e.CommandName == "Add")
04. {
05.
06. TextBox txtCustomerID = (TextBox)myGridView.FooterRow.FindControl("txtAddCustomerID");
07.
08. TextBox txtName = (TextBox)myGridView.FooterRow.FindControl("txtAddName");
09.
10. TextBox txtEmail = (TextBox)myGridView.FooterRow.FindControl("txtAddEmail");
11.
12. TextBox txtCountryCode = (TextBox)myGridView.FooterRow.FindControl("txtAddCountryCode");
13.
14. TextBox txtBudget = (TextBox)myGridView.FooterRow.FindControl("txtAddBudget");
15.
16. TextBox txtUsed = (TextBox)myGridView.FooterRow.FindControl("txtAddUsed");
17.
18. strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " +
19. " VALUES ('" + txtCustomerID.Text + "','" + txtName.Text + "','" + txtEmail.Text + "' " +
20. " ,'" + txtCountryCode.Text + "','" + txtBudget.Text + "','" + txtUsed.Text + "') ";
21. objCmd = new OleDbCommand(strSQL, objConn);
22. objCmd.ExecuteNonQuery();
23.
24. BindData();
25. }
26.}
