Advertisement
Guest User

Untitled

a guest
Oct 1st, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. foreach (GridViewRow row in USER_GROUP_FROMS.Rows)
  2. {
  3.  
  4. var chkboxuser = (CheckBox)row.FindControl("mainsupp");
  5.  
  6.  
  7. abc = "";
  8. if (chkboxuser.Checked == true)
  9. {
  10. string xe = "DATA SOURCE=technovalms;USER ID=AMC; password=amc;";
  11. OracleConnection conn = new OracleConnection();
  12. conn.ConnectionString = xe;
  13.  
  14. OracleCommand cmd = new OracleCommand();
  15. cmd.Connection = conn;
  16.  
  17.  
  18. conn.Open();
  19.  
  20. cmd.CommandText = "insert into TECHNOVA_SMS_USER_PRIVILEAGE(ID,SMS_USER_ID,SMS_PAGE_ID) values(SEQUENCEMODEL.nextval,'" + user_type.SelectedValue.ToString() + "','" + chkboxuser + "') ";
  21.  
  22.  
  23. cmd.ExecuteNonQuery();
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement