ASP.NET中如何编程绑定GridView指定两列至数据库数据

Hey there! Let's work through your GridView issue together—you're trying to bind 2 columns from a database, leave 3 open for manual input, then save all the GridView data to another table, right? Let's start with fixing the partial binding problem first, then cover the rest step by step.

1. 先给GridView做正确的列配置 #

The core issue here is probably mixing auto-generated columns with your custom setup. You need to explicitly define which columns are bound to the database and which are for user input.

前端ASPX代码示例 #

<asp:GridView ID="StudentGridView" runat="server" AutoGenerateColumns="False" 
    OnRowDataBound="StudentGridView_RowDataBound" OnRowUpdating="StudentGridView_RowUpdating">
    <%-- 数据库绑定列：只读，从查询结果取数 --%>
    <asp:BoundField DataField="StudentID" HeaderText="学生ID" ReadOnly="True" />
    <asp:BoundField DataField="StudentName" HeaderText="学生姓名" ReadOnly="True" />
    
    <%-- 手动输入列：用TemplateField添加输入控件 --%>
    <asp:TemplateField HeaderText="科目1成绩">
        <ItemTemplate>
            <asp:TextBox ID="txtScore1" runat="server"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="科目2成绩">
        <ItemTemplate>
            <asp:TextBox ID="txtScore2" runat="server"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="备注">
        <ItemTemplate>
            <asp:TextBox ID="txtRemark" runat="server" TextMode="MultiLine"></asp:TextBox>
        </ItemTemplate>
    </asp:TemplateField>
    
    <%-- 可选：添加保存按钮列，触发单行保存 --%>
    <asp:CommandField ShowEditButton="True" EditText="保存该行" />
</asp:GridView>

关键细节：

• 一定要设AutoGenerateColumns="False"，不然GridView会自动生成所有查询字段的列，覆盖你的自定义设置
• 绑定列用BoundField，指定DataField对应数据库字段，加ReadOnly="True"防止用户修改
• 手动输入列用TemplateField，在ItemTemplate里放TextBox这类输入控件

2. 后端绑定数据库数据到指定列 #

Your existing LINQ query can stay—you just need to bind only the fields you want to display, and the GridView will ignore the rest since we've defined columns manually.

后端绑定代码示例 #

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        BindStudentData();
    }
}

private void BindStudentData()
{
    string classid = query.Class + query.Class_division;
    // 只查询需要绑定的2个字段即可
    var studentQuery = (from cl in db.StudentTbs 
                        where cl.Admission_class == classid
                        select new 
                        {
                            StudentID = cl.StudentID,
                            StudentName = cl.StudentName
                        }).ToList();
    
    StudentGridView.DataSource = studentQuery;
    StudentGridView.DataBind();
}

Pro tips:

• 只选择需要绑定的字段，不用管手动输入的列（它们不依赖数据库数据）
• 一定要在!IsPostBack里绑定数据，不然回发的时候会重新绑定，覆盖用户输入的内容

3. 读取输入数据并保存到另一数据表 #

Once users fill in the manual columns, you'll need to pull the data from each GridView row and insert it into your target table.

单行保存示例（用CommandField触发） #

protected void StudentGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    // 获取当前操作的行
    GridViewRow row = StudentGridView.Rows[e.RowIndex];
    
    // 读取绑定列的值（BoundField会渲染成Label控件）
    string studentId = ((Label)row.Cells[0].Controls[1]).Text;
    string studentName = ((Label)row.Cells[1].Controls[1]).Text;
    
    // 读取手动输入控件的值
    string score1 = ((TextBox)row.FindControl("txtScore1")).Text;
    string score2 = ((TextBox)row.FindControl("txtScore2")).Text;
    string remark = ((TextBox)row.FindControl("txtRemark")).Text;
    
    // 插入到目标数据表（假设目标表是ScoreRecords）
    ScoreRecord newRecord = new ScoreRecord()
    {
        StudentID = studentId,
        StudentName = studentName,
        Subject1Score = Convert.ToInt32(score1),
        Subject2Score = Convert.ToInt32(score2),
        Remark = remark,
        ClassID = classid
    };
    
    db.ScoreRecords.Add(newRecord);
    db.SaveChanges();
    
    // 保存后退出编辑状态，刷新GridView
    StudentGridView.EditIndex = -1;
    BindStudentData();
}

批量保存所有行示例（加一个按钮触发） #

protected void btnBatchSave_Click(object sender, EventArgs e)
{
    foreach (GridViewRow row in StudentGridView.Rows)
    {
        if (row.RowType == DataControlRowType.DataRow)
        {
            string studentId = ((Label)row.Cells[0].Controls[1]).Text;
            string score1 = ((TextBox)row.FindControl("txtScore1")).Text;
            string score2 = ((TextBox)row.FindControl("txtScore2")).Text;
            string remark = ((TextBox)row.FindControl("txtRemark")).Text;
            
            // 创建目标表实体并插入
            ScoreRecord newRecord = new ScoreRecord()
            {
                StudentID = studentId,
                Subject1Score = Convert.ToInt32(score1),
                // 其他字段赋值...
            };
            db.ScoreRecords.Add(newRecord);
        }
    }
    db.SaveChanges();
    // 可以加个提示，比如Label显示"保存成功"
}

常见坑点排查 #

If your initial binding wasn't working, check these:

• Did you forget AutoGenerateColumns="False"? That's the most common mistake—auto-generated columns will override your custom ones
• Are the DataField names in BoundField exactly matching the property names in your LINQ query result? Case matters!
• Are you binding data on every postback? Make sure it's only done in !IsPostBack to avoid overwriting user input

内容的提问来源于stack exchange，提问作者Odumith