Guest User

Untitled

a guest
Nov 13th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. using (SqlConnection objCS = DB.LMSAdminConn())
  2. {
  3. objCS.Open();
  4. SqlCommand objCommand = new SqlCommand("SELECT TOP 1 * FROM users WHERE userid = @userid", objCS);
  5. objCommand.Parameters.Add("@revisionid", SqlDbType.Int).Value = userid;
  6. SqlDataReader reader = objCommand.ExecuteReader();
  7. while (reader.Read())
  8. {
  9. //do something
  10. }
  11. reader.Close();
  12. }
  13.  
  14. public static SqlConnection LMSAdminConn()
  15. {
  16. return new SqlConnection(ConfigurationManager.ConnectionStrings["lmsadmin"].ToString());
  17. }
Add Comment
Please, Sign In to add comment