public void ShowMyData() { try { conn.Open(); cmd = new SqlCommand(sqlsel, conn); rdr = cmd.ExecuteReader(); GridViewNorthwind.DataSource = rdr; GridViewNorthwind.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message; } finally { conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { GridViewNorthwind.DataBind(); LabelMessage.Text = "No error message"; }