public List<string> bc11()
{
List<string> bi = new List<string>();
try
{
Dob.open();
SqlCommand cmd6 = new SqlCommand("sp_bc1", Dob.con);
cmd6.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd6.ExecuteReader();
while (dr.Read())
{
bi.Add(dr["Schoolname"].ToString());
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
if (Dob.con != null)
{
Dob.close();
}
return bi;
}