Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (SqlConnection objCS = DB.LMSAdminConn())
- {
- objCS.Open();
- SqlCommand objCommand = new SqlCommand("SELECT TOP 1 * FROM users WHERE userid = @userid", objCS);
- objCommand.Parameters.Add("@revisionid", SqlDbType.Int).Value = userid;
- SqlDataReader reader = objCommand.ExecuteReader();
- while (reader.Read())
- {
- //do something
- }
- reader.Close();
- }
- public static SqlConnection LMSAdminConn()
- {
- return new SqlConnection(ConfigurationManager.ConnectionStrings["lmsadmin"].ToString());
- }
Add Comment
Please, Sign In to add comment