Hi,
Please Try the code below it works for me
public static void InsertUserWithProcedure(string UserName, string Password)
{
SqlConnection con = new SqlConnection(DataAccess.str);
con.Open();
SqlCommand com = new SqlCommand("insert_user", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@UserName", UserName);
com.Parameters.AddWithValue("@Password", Password);
com.ExecuteNonQuery();
con.Close();
}
your code seems also to work for me and i have tested it
so if you have a problem with select code with this code please attach your code to try to solve the issue you are facing
Regards,
Ahmed Mandour