110,538
社区成员
发帖
与我相关
我的任务
分享
//插入之后取新ID,中间用分号断句
var sql = "INSERT INTO TableName ...;"
+ "SELECT LAST_INSERT_ROWID() FROM TableName";
cmd.CommandText = "select max(id) from " + tableName;
private void button1_Click(object sender, EventArgs e)
{
try
{
SQLiteConnection conn = new SQLiteConnection("data Source="+@(c:\test.db));
conn.SetPassword("1234567890");
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
string tabneName="table";
cmd.CommandText = "select * max(id) from " + tableName;
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
this.label1.Text = "id:" + reader.GetValue(0).ToString();;
reader.Close();
}
}
catch(exception e)
{
}
finally
{
conn.Close();
}
}