List<string> temp = new List<string>();
SqlConnection connectToDb = new SqlConnection(mycon);
SqlCommand cmd = new SqlCommand(getsp, connectToDb);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach(DataRow dr in dt.Rows)
{
temp.Add(dr["Name"].ToString());
}
return temp;
-KR