private void btnAdd_Click(object sender, EventArgs e)
{
string dbPath = @"D:\历年高考分数.db";
if (btnName == "添加")
{
if (File.Exists(dbPath))
{
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
string sql = "select * from sqlite_master where type='table' and name ='特性'";
SQLiteCommand command = new SQLiteCommand(sql, m);//
//m.Close();
//AddcailiaoPara1(dbPath, "特性");
if (command.ExecuteScalar() == null)
{
m.Close();
NewTable1(dbPath, "特性");
AddcailiaoPara1(dbPath, "特性");
}
else
{
m.Close();
AddcailiaoPara1(dbPath, "特性");
}
}
else
{
NewDbFile(dbPath);
NewTable1(dbPath, "特性");
AddcailiaoPara1(dbPath, "特性");
}
Guanlicailiaoquxian.form1.LoadcailiaoPara();
DialogResult result = MessageBox.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void AddcailiaoPara1(string dbPath, string tableName)
{
string yinsu = "";
if (radioButton2.Checked == true) { yinsu = "紫外线"; }
else if (radioButton1.Checked == true) { yinsu = "温度、振动"; }
string id = ？
//string tabText = txtName.Text + yinsu;
//string str = "'" + txtName.Text + "'," + "'" + txtyunxinglicheng.Text + "'," + "'" + txtyingdu.Text + "'," + "'" + txtlashenqiangdu + "'," + "'" + txtladuanshenchanglv + "'," + "'" + yinsu + "'," + "'" + id + "'";
string str = "'" + txtName.Text + "'," + "'" + txtyunxinglicheng.Text + "'," + "'" + txtyingdu.Text + "'," + "'" + txtlashenqiangdu.Text + "'," + "'" + txtladuanshenchanglv.Text + "'," + "'" + yinsu + "'," + "'" + id + "'";
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
string sql = "insert into " + tableName + " (传感器型号,运行里程,硬度,拉伸强度,拉断伸长率,因素,材料特性ID) values (" + str + ")";
SQLiteCommand command = new SQLiteCommand(sql, m);
command.ExecuteNonQuery();
m.Close();
}
怎么让添加一些参数后，这行数据的ID自动加一，以便于以后根据id删除数据
string id那应该怎么写
