如何在Datagridview中通过文本添加数据
本文关键字:文本 添加 数据 Datagridview | 更新日期: 2023-09-27 18:25:30
我有一个包含3列的数据表,并在sql数据库中进行了连接。我通过点击按钮在数据网格视图中创建了一个空白行。我如何在这一行添加文本并保存在数据库中,我接下来要做什么?。这是添加行代码:
private void Btn_newf2_Click(object sender, EventArgs e)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from MSTBackupCtr_Folder";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
DataRow Newrow = dt.NewRow();
dt.Rows.Add(Newrow);
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Name = ("No");
dataGridView1.Columns[1].Name = ("Active_Flag");
dataGridView1.Columns[2].Name = ("Folder");
}
试试这个
foreach (GridViewRow r in grdtemp.Rows)
{
TextBox No = (TextBox)r.FindControl("txtNo");
TextBox ActiveFlag = (TextBox)r.FindControl("txtActvFlag");
TextBox Folder = (TextBox)r.FindControl("txtFolder");
int j = Bll.DbClass("insert into MSTBackupCtr_Folder
values(no,flag,folder) values ('"+No.Text+"','"+ActiveFlag.Text+"','"+Folder.Text+"')");
//BLL.DbClass is my custom class for Data insertion
}