private void toolStripLabel2_Click(object sender, EventArgs e)
{
try
{
this.backgroundWorker1.RunWorkerAsync();
JingDu form = new JingDu(this.backgroundWorker1, "提交中");// 显示进度条窗体
form.ShowDialog(this);
form.Close();
DataTable dt = dataGridView1.DataSource as DataTable;
if (dt == null)
{
dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (!dataGridView1.Columns[i].HeaderCell.Value.ToString().Equals("Id"))
{
dt.Columns.Add(dataGridView1.Columns[i].HeaderCell.Value.ToString(), typeof(String));
}
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells[1].Value != null)
{
dt.Rows.Add(dataGridView1.Rows[i].Cells[0].Value, dataGridView1.Rows[i].Cells[1].Value, dataGridView1.Rows[i].Cells[2].Value, dataGridView1.Rows[i].Cells[3].Value, dataGridView1.Rows[i].Cells[4].Value, dataGridView1.Rows[i].Cells[5].Value, dataGridView1.Rows[i].Cells[6].Value);
}
}
}
cal.insertKucun(dt);
MessageBox.Show("提交成功");
bindDatagridview();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
