Sql命令不显示表

本文关键字:显示 命令 Sql | 更新日期: 2023-09-27 18:03:55

我有这个代码后面的按钮,在SQL中显示表时按下按钮。我似乎不知道这个问题,为什么它不显示任何表?

我添加了这行代码来检查BatchID是否超出sql表

的范围
   if (read.Read())
    {
        GridView1.DataSource = read;
        GridView1.DataBind();
    }
    else
    {
        lbl_NoBatchID.Text = "BatchID out of range";
    }

   protected void Button1_Click(object sender, EventArgs e)
    {
       if (DropDownList1.SelectedItem.ToString() =="ER00 - File Header")
        {
            using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["DBcon"]))
            {
                if (String.IsNullOrEmpty(TextBox_ID.Text.ToString()))
                {
                    lbl_NoBatchID.Text = "Please enter BatchID!";
                }
                else
                {
                    try
                    {
                        lbl_NoBatchID.Text = "";
                        SqlCommand sqlCommand = new SqlCommand("Select * from tbl_WinApps_FileHeader Where BatchID =" + TextBox_ID.Text.ToString());
                        sqlCommand.Connection = con;
                        con.Open();
                        SqlDataReader read = sqlCommand.ExecuteReader();
                        if (read.Read())
                        {
                            GridView1.DataSource = read;
                            GridView1.DataBind();
                        }
                        else
                        {
                            lbl_NoBatchID.Text = "BatchID out of range";
                        }
                    }
                    catch (Exception)
                    {                           
                    }
                }
            }
        }

Sql命令不显示表

请务必做两件事。

1)。关闭Databind()后的DataReader

2)。GridView对应AutoGenerateColumns="True"