private void getir2()
{
con = new SQLiteConnection("Data Source=stock.sqlite;Version=3");
da = new SQLiteDataAdapter("Select * From ürünler1", con);
ds = new DataSet();
con.Open();
da.Fill(ds, "ürünler1");
guna2DataGridView2.DataSource = ds.Tables["Ürünler1"];
con.Close();
}
if (!File.Exists("Stock.sqlite"))
{
SQLiteConnection.CreateFile("stock.sqlite");
string sql = @"CREATE TABLE ürünler1(
TCNO INTEGER UK ,
Ad TEXT NOT NULL,
Soyad TEXT NOT NULL,
DogumTarihi TEXT NOT NULL,
TelefonNumara TEXT NOT NULL,
E-Posta TEXT NOT NULL,
Adres TEXT NOT NULL,
EklenmeTarihi TEXT NOT NULL);";
con = new SQLiteConnection("Data Source=stock.sqlite;Version=3");
con.Open();
cmd = new SQLiteCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
}
getir2();