Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static Boolean Login(string number, string name)
- {
- string connString = ConfigurationManager.ConnectionStrings["sqlconnectionstring"].ConnectionString;
- using (SqlConnection conn = new SqlConnection(connString))
- {
- SqlCommand cmd = new SqlCommand("SELECT Holders.number, Holders.name from Holders where (Holders.number = @number AND Holders.name = @name)", conn);
- cmd.Parameters.Add("number", SqlDbType.Char).Value = number;
- cmd.Parameters.Add("name", SqlDbType.Char).Value = name;
- conn.Open();
- using (SqlDataReader reader = cmd.ExecuteReader())
- {
- while (reader.Read())
- {
- return true;
- }
- } // Dispose Reader
- } // Dispose connection
- return false;
- }
- }
Add Comment
Please, Sign In to add comment