Answers for "SQLite Parameters"

C#
0

SQLite Parameters

cmd.Parameters.AddWithValue("@name", "BMW");
cmd.Parameters.AddWithValue("@price", 36600);
cmd.Prepare();
Posted by: Guest on October-13-2021
0

SQLite Parameters

using System;
using System.Data.SQLite;

string cs = @"URI=file:C:\Users\Jano\Documents\test.db";

using var con = new SQLiteConnection(cs);
con.Open();

using var cmd = new SQLiteCommand(con);
cmd.CommandText = "INSERT INTO cars(name, price) VALUES(@name, @price)";

cmd.Parameters.AddWithValue("@name", "BMW");
cmd.Parameters.AddWithValue("@price", 36600);
cmd.Prepare();

cmd.ExecuteNonQuery();

Console.WriteLine("row inserted");
Posted by: Guest on October-13-2021

C# Answers by Framework

Browse Popular Code Answers by Language