如何在datagrideview中将insert value复选框设置为数据库sql server [英] how to make insert value checkbox in datagrideview to database sql server
本文介绍了如何在datagrideview中将insert value复选框设置为数据库sql server的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
i有问题在datagridview中添加值复选框到数据库sql server和数据库中的数据类型(位)数据库
for ( int i = 0 ; i < dataGridView1.Rows.Count - 1 ; i ++)
{
cmd.CommandText = 插入到帐户中(已完成, partial(donot)values(Boolean.Parse(dataGridView1.Rows [i] .Cells [11] .Value.ToString())+ ' < span class =code-string>,' + Boolean.Parse(dataGridView1.Rows [i ] .Cells [12] .Value.ToString())+ ' ,' + Boolean.Parse(dataGr idView1.Rows [i] .Cells [13] .Value.ToString())+ ' ) ;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
解决方案
参考:
1. < a href =http://www.codeproject.com/Questions/560439/datagridviewpluscheckplusboxpluscolumn> datagridview复选框列 [ ^ ]
2. http://stackoverflow.com/questions/22155483/how-to-insert-1 -or-0-in-sql-server-for-bit-type-field-if-checkbox-is-checked [ ^ ]
hi
i have problem to add value checkbox in datagridview to database sql server and type of data filed (bit) in database
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
cmd.CommandText = "insert into acountment (done,partial,donot)values (Boolean.Parse(dataGridView1.Rows[i].Cells[11].Value.ToString()) + "', '" + Boolean.Parse(dataGridView1.Rows[i].Cells[12].Value.ToString()) + "', '" + Boolean.Parse(dataGridView1.Rows[i].Cells[13].Value.ToString()) + "')";
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
解决方案
Refer:
1. datagridview check box column[^]
2. http://stackoverflow.com/questions/22155483/how-to-insert-1-or-0-in-sql-server-for-bit-type-field-if-checkbox-is-checked[^]
这篇关于如何在datagrideview中将insert value复选框设置为数据库sql server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文