command = new SqlCommand("SELECT * FROM Member",sqlConnection );
command.CommandType = CommandType.StoredProcedure;
try
{
     sqlConnection.Open();
     reader=command.ExecuteReader();
     while (reader.Read())
{
//if it is a text box 
txtbox_user.Text=reader.IsDBNull(reader.GetOrdinal("MemberUserName"))? null: reader["MemberUserName"].ToString();
//if it is a dropdown put defalut value 0 or 1, what ever value you use.
DropDown_Children.SelectedValue=Convert.ToString(reader.IsDBNull(reader.GetOrdinal("NumofChildren")) ? (int)0 : (int)reader["NumofChildren"]);						
					
}
}
catch(Exception ex)
{
   throw new Exception(ex.Message);
}
finally
{
   reader.Close();
   sqlConnection.Close();
}