Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- foreach (GridViewRow row in USER_GROUP_FROMS.Rows)
- {
- var chkboxuser = (CheckBox)row.FindControl("mainsupp");
- abc = "";
- if (chkboxuser.Checked == true)
- {
- string xe = "DATA SOURCE=technovalms;USER ID=AMC; password=amc;";
- OracleConnection conn = new OracleConnection();
- conn.ConnectionString = xe;
- OracleCommand cmd = new OracleCommand();
- cmd.Connection = conn;
- conn.Open();
- cmd.CommandText = "insert into TECHNOVA_SMS_USER_PRIVILEAGE(ID,SMS_USER_ID,SMS_PAGE_ID) values(SEQUENCEMODEL.nextval,'" + user_type.SelectedValue.ToString() + "','" + chkboxuser + "') ";
- cmd.ExecuteNonQuery();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement