I have a stored procedure that populates to a data table. I was wondering if I can get this to populate to a label instead? I have never done this before and I have tried the databind feature but cant get it to work. Below is my code.
SqlConnection con = new SqlConnection(Settings.GetConfigValue("PARK_IRB_V1_11_19_2010", "IRB2010ConnectionString"));
SqlCommand cmd = new SqlCommand("P_sp_GetPendingIRBApplications", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader sdr = cmd.ExecuteReader();
DataTable dt = new DataTable();
GridView1.DataSource = dt;
// As you can see I was trying below but to no avail