What do you want to save?
Add Code snippet
New code examples
-
Javascript 2022-02-02 18:46:21
connection.escape
var mysql = require('mysql'); var connection = mysql.createConnection({ host: 'localhost', user: 'root', password: '', database: 'technicalkeeda', debug: false,});connection.connect(); var employeeId = '1';var sql = "SELECT *... Add solution -
C# 2022-02-01 01:51:05
C# insert into database
using(var connection = new SqlConnection("connectionString")) { connection.Open(); var sql = "INSERT INTO Main(FirstName, SecondName) VALUES(@FirstName, @SecondName)"; using(var cmd = new SqlCommand(sql, connection)) { ... Add solution -
Other 2022-01-23 06:20:30
entity fast insert recordset
// at some point in my calling code, I will call: var myDataTable = CreateMyDataTable(); myDataTable.Rows.Add(Guid.NewGuid,tableHeaderId,theName,theValue); // e.g. - need this call for each row to insert var efConnectionString = ConfigurationManager.Conn... Add solution -
C# 2021-11-16 23:45:11
.net core executenonqueryasync transaction
var sqlQuery = "delete from table"; using (var connection = new SqlConnection(ConnectionString)) { await connection.OpenAsync(); using (var tran = connection.BeginTransaction()) using (var command = new SqlCom... Add solution -
Javascript 2021-11-05 22:39:08
node js sqlite3
var sqlite3 = require('sqlite3').verbose(); var db = new sqlite3.Database(':memory:'); db.serialize(function() { db.run("CREATE TABLE lorem (info TEXT)"); var stmt = db.prepare("INSERT INTO lorem VALUES (?)"); for (var i = 0; i... Add solution -
Javascript 2021-10-17 10:31:10
sql expressjs update query
var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "yourusername", password: "yourpassword", database: "mydb" }); con.connect(function(err) { if (err) throw err; ... Add solution -
C# 2021-10-17 04:20:04
dapper query list of parameters
var sql = "SELECT * FROM Invoice WHERE Kind IN @Kind;"; using (var connection = My.ConnectionFactory()) { connection.Open(); var invoices = connection.Query<Invoice>(sql, new {Kind = new[] {InvoiceKind.StoreInvoice, InvoiceKind.WebInvo... Add solution -
C# 2021-10-14 19:54:07
how to update database using sql in c#
using (var sqlConnection = new SqlConnection(config.ConnectionString)) { foreach(var position in positions) { var sql = $"UPDATE BillOfMaterial SET Position = '{pos}' WHERE Creator = '{position.Creator}' AND Idx = '{position.Idx}' AND A... Add solution