When I add data to my SQLite database table using the below code, it adds 2 identical rows to the table for some reason instead of one. using(SQLiteConnection conn= new SQLiteConnection(@"Data Source="+Path.GetFullPath("./TestDB.db")+";")) { conn.Open(); SQLiteCommand command = new SQLiteCommand("INSERT INTO Test(FirstName, LastName, Age) VALUES(‘Chris’,’Pine’,42)", conn); command.ExecuteNonQuery(); SQLiteDataAdapter adap = new SQLiteDataAdapter(command); DataTable dt = new… Read More Why two rows getting added to my SQLite database table?

Is there a way to format an integer to be at least X digits by adding trailing zeroes? Such that with X being 4 I would get: 4 -> 4000 58 -> 5800 372 -> 3720 5432 -> 5432 12345678 -> 12345678 I know how to write a helper function to achieve this, just wondering… Read More Format integer to be at least X digits by adding trailing zeroes