C#WebForm实现增删改查

 <div>
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
        </div>
        
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  Width="487px">
            <Columns>
                <asp:BoundField DataField="a" HeaderText="姓名" SortExpression="a" />
                <asp:BoundField DataField="b" HeaderText="班级" SortExpression="b" />
                <asp:BoundField DataField="c" HeaderText="分数" SortExpression="c" />
            </Columns>
        </asp:GridView>

protected void Page_Load(object sender, EventArgs e)
{
 DataTable dt = new DataTable();
            dt = SelectTable(" SELECT a,b,c FROM BBB ");
            GridView1.DataSource = dt;
            GridView1.DataBind();
            }
            public void HELP(string aaa)
        { SqlConnection conn = new SqlConnection("server=DESKTOP-FGF3P37;database=AAAAA;uid=sa;pwd=123");
            conn.Open();
            //SqlCommand cmd = new SqlCommand(); //构造命令对象
            //cmd.Connection = conn;
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = aaa;
            cmd.ExecuteNonQuery();
            conn.Close();
            }
public DataTable SelectTable(string sql)
        {
            string sqlconn = "server=DESKTOP-FGF3P37;database=AAAAA;uid=sa;pwd=123";
            using (SqlConnection conn = new SqlConnection(sqlconn))
            {
                using (SqlDataAdapter da = new SqlDataAdapter(sql, conn))
                {
                    da.SelectCommand.CommandTimeout = 120;
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    return dt;
                }
            }
        }
protected void Button1_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            string sql = "SELECT a,b,c FROM BBB";
            if (TextBox1.Text!="")
            {
                sql = "SELECT a,b,c FROM BBB where a='" + TextBox1.Text + "'";
            }
            dt = SelectTable(sql);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }