Advertisement
Guest User

Untitled

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