增加数据 try{stringsql ="insert into"+ textBox2.Text +"(name, score) values ('"+ textBox3.Text +"',"+ Convert.ToInt32(textBox4.Text) +")"; SQLiteCommand command=newSQLiteCommand(sql, Conn); command.ExecuteNonQuery(); }catch(Exception ex) {thrownewException("插入数据:"+ textBox3....
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有...
{newSQLiteParameter("@userid",newRandom().Next(10)),newSQLiteParameter("@username",name),newSQLiteParameter("@passwod",password) };objectobj = SQLite.ExecuteNonQuery(sql, parameters);inti = Convert.ToInt32(obj);if(i >0) {this.label4.Text ="注册成功!";this.label4.Show(); }else{this....
//使用select last_insert_rowid()返回自增字段的值 int addid = Convert.ToInt32(SqliteHelper.ExecuteScalar(System.Data.CommandType.Text, "insert into customer values(null,@companyname,@addtime);select last_insert_rowid()", paras)); } 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13....
try{stringsql ="insert into"+ textBox2.Text +"(name, score) values ('"+ textBox3.Text +"',"+ Convert.ToInt32(textBox4.Text) +")"; SQLiteCommand command=newSQLiteCommand(sql, Conn); command.ExecuteNonQuery(); }catch(Exception ex) ...
int r = cmd.ExecuteNonQuery(); if (r == 1) { return true; } else { return false; } } } } private void btnUpdateData_Click(object sender, RoutedEventArgs e) { if (UpdateDataById(myDb, Convert.ToInt32(txtMeterID.Text), txtFullSN.Text, txtOrderNr.Text)) ...
{ connection.Open();stringsql ="SELECT * FROM users WHERE id = @id";using(varcommand =newSQLiteCommand(sql, connection)) {command.Parameters.AddWithValue("@id", id);using(SQLiteDataReader reader = command.ExecuteReader()) {if(reader.Read()) {returnnewUser {Id = Convert.ToInt32(reader[...
// 获取最后插入的id SQLiteCommand getIdCommand = new SQLiteCommand("SELECT LAST_INSERT_ROWID()", connection); int lastInsertedId = Convert.ToInt32(getIdCommand.ExecuteScalar()); 关闭数据库连接。 代码语言:txt 复制 // 关闭数据库连接 connection.Close(); ...
int waybillId = Convert.ToInt16(reader["waybillId"].ToString()); var temp = reader["createdOn"].ToString(); DateTime createdOn = DateTime.Parse(temp); waybill.WaybillId = waybillId; waybill.CreatedOn = createdOn; } Temp仅返回2018,而不是2018-04-09T00:00:00.0000000-03:00。我尝试将DB列设...
int r = cmd.ExecuteNonQuery(); if (r == 1) { return true; } else { return false; } } } } private void btnUpdateData_Click(object sender, RoutedEventArgs e) { if (UpdateDataById(myDb, Convert.ToInt32(txtMeterID.Text), txtFullSN.Text, txtOrderNr.Text)) ...