如何使用c#.net将数据从datagridview发送到带有进度条的数据库 [英] how to send data from datagridview to database with progress bar using c#.net
本文介绍了如何使用c#.net将数据从datagridview发送到带有进度条的数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何使用进度条将数据从datagridview发送到数据库使用c#.net
解决方案
这里我只是给出了将数据发送到数据库的链接。 />
void 保存()
{
< span class =code-keyword> try
{
if (dataGridView1.Rows.Count > 1 )
{
for ( int i = 0 ; i < = dataGridView1.Rows.Count - 1 ; i ++)
{
string col1 = dataGridView1.Rows [i] .Cells [ 0 ]。Value.ToString();
string col2 = dataGridView1.Rows [i] .Cells [ 1 ]。Value.ToString ();
string col3 = dataGridView1.Rows [i] .Cells [ 2 ]。Value.ToString ();
string col4 = dataGridView1.Rows [i] .Cells [ 3 ]。Value.ToString ();
string col5 = dataGridView1.Rows [i] .Cells [ 4 ]。Value.ToString ();
使用(SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings [ constr]。ConnectionString))
{
string insert = INSERT INTO InvoiceItems(SNo,Quantity,Rate,Description,Total)VALUES(@SNo, @数量,@率,@说明,@总计)跨度>;
con.Open();
SqlCommand cmd = new SqlCommand(insert,con);
cmd.Parameters.AddWithValue( @ SNo,col1.ToString());
cmd.Parameters.AddWithValue( Description,col2.ToString());
cmd.Parameters.AddWithValue( @ Quantity,col3.ToString());
cmd.Parameters.AddWithValue( @ Rate,col4.ToString());
cmd.Parameters.AddWithValue( Total,col5.ToString());
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
catch (例外情况)
{
ex.Message.ToString();
}
}
我没有附上进度条。
谢谢希望我帮助你。
how to send data from datagridview to database with progress bar using c#.net
解决方案
Here i am simply giving the link for sending data to database.
void Save() { try { if (dataGridView1.Rows.Count > 1) { for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++) { string col1 = dataGridView1.Rows[i].Cells[0].Value.ToString(); string col2 = dataGridView1.Rows[i].Cells[1].Value.ToString(); string col3 = dataGridView1.Rows[i].Cells[2].Value.ToString(); string col4 = dataGridView1.Rows[i].Cells[3].Value.ToString(); string col5 = dataGridView1.Rows[i].Cells[4].Value.ToString(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString)) { string insert = "INSERT INTO InvoiceItems(SNo,Quantity,Rate,Description,Total) VALUES (@SNo,@Quantity,@Rate,@Description,@Total)"; con.Open(); SqlCommand cmd = new SqlCommand(insert, con); cmd.Parameters.AddWithValue("@SNo", col1.ToString()); cmd.Parameters.AddWithValue("Description", col2.ToString()); cmd.Parameters.AddWithValue("@Quantity", col3.ToString()); cmd.Parameters.AddWithValue("@Rate", col4.ToString()); cmd.Parameters.AddWithValue("Total", col5.ToString()); cmd.ExecuteNonQuery(); con.Close(); } } } } catch (Exception ex) { ex.Message.ToString(); } }
I have not attached the progress bar in it.
Thanks Hope i helped you.
这篇关于如何使用c#.net将数据从datagridview发送到带有进度条的数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文