Hi,
Try this:
SqlConnection con = new SqlConnection(GetConnectionString());
con.Open();
SqlCommand cmd = new SqlCommand("sp_selectvalidateusr", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", TxtUserName.Text);
SqlDataReader dr = cmd.ExecuteReader();
Hope this helps.