这段代码实现的是listview控件中数据入库,但是需要添加一些代码以实现如何在每次数据入库之前先清空表里数据呢?或者说覆盖上次表中数据呢?
private void button4_Click(object sender, EventArgs e)
{
string cons = "Persist Security Info=false;Data Source=.;Initial Catalog=yang;User ID=sa;Password=sql";
SqlConnection sc = new SqlConnection(cons);
sc.Open();
long c = 0;
foreach (ListViewItem l in this.listView1.Items)
{
c++;//先得到LISTVIEW有多少条记录
}
foreach (ListViewItem l in this.listView1.Items)
{
//把LISTVIEW中的每行读到一个字符串数组中
string[] b = new string[6];
//b[o]为井深,或者别的X轴数据,其他为相应变化的Y轴数据 for (int a = 0; a < l.SubItems.Count; a++)
{ //MessageBox.Show("SUBITEM:" + l.SubItems[a].Text.ToString());
b[a] = l.SubItems[a].Text.ToString();
}
//建立插入数据库的SQL语句
string que = "insert into jisuanjieguo values('" + b[0].ToString() + "'" + ",'" + b[1].ToString() + "'" + ",'" + b[2].ToString() + "','" + b[3].ToString() + "','" + b[4].ToString() + "','" + b[5].ToString() + "')";
SqlCommand ss = sc.CreateCommand();
ss.CommandText = que;
ss.ExecuteNonQuery();
ss = null;
}
sc.Close();
sc = null;
MessageBox.Show(" saved!");
}
private void button4_Click(object sender, EventArgs e)
{
string cons = "Persist Security Info=false;Data Source=.;Initial Catalog=yang;User ID=sa;Password=sql";
SqlConnection sc = new SqlConnection(cons);
sc.Open();
long c = 0;
foreach (ListViewItem l in this.listView1.Items)
{
c++;//先得到LISTVIEW有多少条记录
}
foreach (ListViewItem l in this.listView1.Items)
{
//把LISTVIEW中的每行读到一个字符串数组中
string[] b = new string[6];
//b[o]为井深,或者别的X轴数据,其他为相应变化的Y轴数据 for (int a = 0; a < l.SubItems.Count; a++)
{ //MessageBox.Show("SUBITEM:" + l.SubItems[a].Text.ToString());
b[a] = l.SubItems[a].Text.ToString();
}
//建立插入数据库的SQL语句
string que = "insert into jisuanjieguo values('" + b[0].ToString() + "'" + ",'" + b[1].ToString() + "'" + ",'" + b[2].ToString() + "','" + b[3].ToString() + "','" + b[4].ToString() + "','" + b[5].ToString() + "')";
SqlCommand ss = sc.CreateCommand();
ss.CommandText = que;
ss.ExecuteNonQuery();
ss = null;
}
sc.Close();
sc = null;
MessageBox.Show(" saved!");
}
???????
直接在此加如一条执行命令 delete from 表名 不就可以把表里的数据清空了吗???
另外,也可以使用存儲過程,效率會高一些
就可以清除表数据