如何在将新列与数据库绑定后将其添加到datagridview
本文关键字:添加 绑定 datagridview 数据库 新列 | 更新日期: 2023-09-27 18:24:43
我的winForm(C#)应用程序中有一个dataGridView
,用于显示玩家列表。
我已经成功地将其与数据库绑定,并正确显示所有列,即PlayerName、Age、Runs等。
现在我想在不添加到数据库的情况下,在run time
向dataGridView
再添加一列,即"CurrentScore"。
请告诉我如何品尝。是否可以通过编程方式添加新列??
private void playerList(int teamID)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "SELECT PlayerName AS [Player Name] ,Age , Runs FROM Players WHERE Team_id= " + teamID;
SqlCommand cmd = new SqlCommand(query, con);
adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds, "Players");
dGridPlayers.DataSource = ds.Tables["Players"];
}
该代码运行良好,但无法添加新的临时列"CurrentScore"
您只需编辑查询并添加一个伪列:
string query = "SELECT player_name AS [Player Name] ,
skill As [Skill], '' AS [CurrentScore]
FROM Players WHERE Team_id= " + teamID;