本文介绍了我如何填写Datagridview并在按钮上发送其数据点击的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 我需要将数据从datagridview保存到表,因为表包含更多列,但我在datagridview中只显示了几列。通过sendkeys事件从另一个设备发送文本来填充dgv。我只想要当我点击发送数据按钮时,它将获得dgv的所有textfileds值并存储到数据库表,并且dgv需要清除(因为我将数据从此表移动到另一个表后删除它包含)。目前我从单元格获取文本,但在调用RowLeave事件后,我想在发送数据按钮上获取文本。 如何实现这一目标?请帮忙。I need to save data from datagridview to table , as table contains more columns but i showed only few columns in datagridview. The dgv fill by sending text from another device with sendkeys event . I just want that when i click "send data" button , it will get all textfileds values of dgv and store to database table and dgv needs to be clear(as i delete its contains after moving data from this table to another table). currently i get text from cells but after calling RowLeave event , i want to get text on "send data" button .how to achive this? please help.private void dataGridView1_RowLeave(object sender, DataGridViewCellEventArgs e)// { var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewTextBoxColumn && e.RowIndex >= 0) { for (int i = 0; i <= dataGridView1.RowCount - 1; i++) { if (e.RowIndex >= 0) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; string item = row.Cells["item_code"].Value.ToString(); string batch = row.Cells["batchno"].Value.ToString(); string expiry = row.Cells["expiry_date"].Value.ToString(); string reqq = row.Cells["Req_quantity"].Value.ToString(); string trsq = row.Cells["Trs_quantity"].Value.ToString(); cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Proc_insertTransferedProduct"; cmd.Parameters.Add(new SqlParameter("itemcode", item)); cmd.Parameters.Add(new SqlParameter("batch", batch)); cmd.Parameters.Add(new SqlParameter("expiry", Convert.ToDateTime(expiry))); cmd.Parameters.Add(new SqlParameter("req_quantity", reqq)); cmd.Parameters.Add(new SqlParameter("trs_quantity", trsq)); cmd.Connection = con; table = new DataTable(); adapter = new SqlDataAdapter(cmd); adapter.Fill(table); MessageBox.Show("data transfered to table"); } } } } private void button3_Click(object sender, EventArgs e) { //need to do above task here // }推荐答案 这篇关于我如何填写Datagridview并在按钮上发送其数据点击的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
05-28 23:41
查看更多