Answers for "SQLite Columns"

C#
0

SQLite Columns

using System;
using System.Data.SQLite;

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

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

string stm = "SELECT * FROM cars LIMIT 5";

using var cmd = new SQLiteCommand(stm, con);

using SQLiteDataReader rdr = cmd.ExecuteReader();
Console.WriteLine($"{rdr.GetName(0), -3} {rdr.GetName(1), -8} {rdr.GetName(2), 8}");

while (rdr.Read())
{
    Console.WriteLine($@"{rdr.GetInt32(0), -3} {rdr.GetString(1), -8} {rdr.GetInt32(2), 8}");
}
Posted by: Guest on October-13-2021

C# Answers by Framework

Browse Popular Code Answers by Language