使用sqlite保存数据返回主键
时间:2022-03-10 17:09
注意:要在同一个连接下可以
string sql = "insert into ims_tbl_HotelInfo(HotelId,HotelName,HotelTelephone,HotelAddress,Remark,KId,Vip,XId,YId,BId,CId,DId,EId,FId,HId) values(‘" + hotelId + "‘,‘" + hotelName + "‘,‘" + hotalTelephone + "‘,‘" + hotalAddress + "‘,‘" + hremark + "‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘,‘ ‘)"; int result = SQLiteDBHelper.ExecuteSql(sql + ";select last_insert_rowid();", null);//返回主键
使用sqlite保存数据返回主键,布布扣,bubuko.com