sqlite connection c#
C#
//Download "System.Data.Sqlite" from "Manage Nuget Packages" Section
using System.Data.SQLite;
SQLiteConnection.CreateFile("TestDB.db3") //Create a Database
SQLiteConnection conn = new SQLiteConnection(@"data source = TestDB.db3"); //Establish a connection with our created DB
conn.Open();
SQLiteCommand cmd = new SQLiteCommand("create table table1 (username TEXT, password TEXT)", conn);
cmd.ExecuteNonQuery();
Console.WriteLine("Enter the username");
string UserName = Console.ReadLine();
Console.WriteLine("Enter Password");
string PassWord = Console.ReadLine();
SQLiteCommand cmd2 = new SQLiteCommand("insert into table1 (username, password) values ('"+Username+"', '"+PassWord+"')", conn);
cmd2.ExecuteNonQuery();
Also in C#:
- Title
- c# create dynamic object
- Category
- C#
- Title
- unity c# public all codes
- Category
- C#
- Title
- how to parse a string to an integer c#
- Category
- C#
- Title
- unity clamp rotation
- Category
- C#
- Title
- while loop c#
- Category
- C#
- Title
- How to get number of months between 2 dates c#
- Category
- C#
- Title
- viewBag as a list
- Category
- C#
- Title
- ping with c#
- Category
- C#
- Title
- navigate to another page with an object uwp c#
- Category
- C#
- Title
- c# resize bitmap
- Category
- C#
- Title
- c# char array to string
- Category
- C#
- Title
- c# read all lines from filestream
- Category
- C#
- Title
- unity image
- Category
- C#
- Title
- .net core executenonqueryasync transaction
- Category
- C#
- Title
- public enum c#
- Category
- C#
- Title
- c sharp split string
- Category
- C#
- Title
- usermanager change password without current password
- Category
- C#
- Title
- c# webrequest cookies
- Category
- C#
- Title
- reference to gameobject in different scene unity
- Category
- C#
- Title
- declare string array c# without size
- Category
- C#
- Title
- c# print
- Category
- C#
- Title
- c# remove spaces from string
- Category
- C#
- Title
- how to clear console in c#
- Category
- C#
- Title
- unity list
- Category
- C#
- Title
- collision detector unity c# 2d
- Category
- C#
- Title
- how to reload app.config file at runtime in c#
- Category
- C#
- Title
- unity how to change text in script
- Category
- C#
- Title
- c# creating a data recovery software
- Category
- C#
- Title
- c# resize image keep aspect ratio
- Category
- C#
- Title
- unity detect any key
- Category
- C#
- Title
- eager loading c#
- Category
- C#
- Title
- c# zip a file
- Category
- C#
- Title
- how to make a pause feautre in unity
- Category
- C#
- Title
- how to add a gameobject
- Category
- C#
- Title
- unity 2d Drag object
- Category
- C#
- Title
- unity string format time
- Category
- C#
- Title
- what type of variable is true or false in c#
- Category
- C#
- Title
- c# authorize attribute
- Category
- C#
- Title
- get enum by index c#
- Category
- C#
- Title
- how to get the askii code of a char in c#
- Category
- C#
- Title
- c# array Reverse method
- Category
- C#
- Title
- c# if statement
- Category
- C#
- Title
- unity input get axis
- Category
- C#
- Title
- how to add movement in unity
- Category
- C#
- Title
- automapper c# initialize error
- Category
- C#
- Title
- razor preview
- Category
- C#
- Title
- C# array index tostring
- Category
- C#
- Title
- c# generic abstract method
- Category
- C#
- Title
- array to list C
- Category
- C#
- Title
- snake game
- Category
- C#
- Title
- c sharp if string equals
- Category
- C#
- Title
- unity button interactable
- Category
- C#
- Title
- how to change the title of the console in c#
- Category
- C#
- Title
- c# request run as administrator
- Category
- C#
- Title
- how to check if an integer is in array c#
- Category
- C#
- Title
- c# string to memorystream
- Category
- C#
- Title
- dynamically add rows to datagridview c#
- Category
- C#
- Title
- iterate through dictionary c#
- Category
- C#
- Title
- .sh script: check if file exist
- Category
- C#
- Title
- percentage in c#
- Category
- C#
- Title
- c# string remove special characters
- Category
- C#
- Title
- C# colours
- Category
- C#
- Title
- ecs get specific entities with component
- Category
- C#
- Title
- appsettings in console application c#
- Category
- C#
- Title
- c# switch statement
- Category
- C#
- Title
- c# creating exceptions
- Category
- C#
- Title
- c# form set auto scale
- Category
- C#
- Title
- c# making a folder
- Category
- C#
- Title
- unity rigidbody constraints
- Category
- C#
- Title
- xarray: create 2d dataset
- Category
- C#
- Title
- convert array object to int[] c#
- Category
- C#
- Title
- C# downloadstirng download old
- Category
- C#
- Title
- resize image c#
- Category
- C#
- Title
- xamarin forms alarm
- Category
- C#
- Title
- mouseposition unity
- Category
- C#
- Title
- interpolate rotation unity3d
- Category
- C#
- Title
- c# string to float
- Category
- C#
- Title
- find gameobject with tag
- Category
- C#
- Title
- get number of sundays in a month c#
- Category
- C#
- Title
- The type or namespace name 'Scrollbar' could not be found
- Category
- C#
- Title
- datagridview select row column cell c#
- Category
- C#
- Title
- itext7 pdfwriter outputstream c#
- Category
- C#
- Title
- how to get array of children transform
- Category
- C#
- Title
- unity vector3 smoothdamp not reaching target
- Category
- C#
- Title
- Net.ServicePointManager.SecurityProtocol .net framework 4
- Category
- C#
- Title
- c# combobox datasource enum
- Category
- C#
- Title
- c# ref
- Category
- C#
- Title
- use newtonsoft json to clone object
- Category
- C#
- Title
- how to convert from hexadecimal to binary in c#
- Category
- C#
- Title
- can send but cannot receive email dreamhost email
- Category
- C#
- Title
- c# reflection create generic type
- Category
- C#
- Title
- c# cheat sheet
- Category
- C#
- Title
- c# list to string
- Category
- C#
- Title
- how to say or in c#
- Category
- C#
- Title
- c# thread sleep
- Category
- C#
- Title
- unity custom editor save changes
- Category
- C#
- Title
- mvc write to console
- Category
- C#
- Title
- no overload for 'useItemOnSceneLoad' matches delegate 'UnityAction<Scene, LoadSceneMode>'
- Category
- C#
- Title
- get day month year from date c#
- Category
- C#
- Title
- how to make % posibility to spawn an object C# in unity
- Category
- C#