public static void insert() { MyDb dbc = new MyDb(); Student s = new Student() { Jmeno = "Radek", Prijmeni = "Novak", Vek = 30 }; //dbc.dbStudenti.InsertOnSubmit(s); dbc.Studenti.Add(s); // Submit the change to the database. try { dbc.SaveChanges(); //dbc.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Make some adjustments. // ... // Try again. //dbc.SubmitChanges(); } }
public static void mytest() { //SQLiteConnection dbCon = new SQLiteConnection("Data Source=mydatabase.sqlite;Version=3;"); //dbCon.Open(); MyDb dbc = new MyDb(); var s = from a in dbc.Studenti orderby a.Vek select a; foreach (var x in s) { MessageBox.Show(string.Format("{0} {1}", x.Jmeno,x.Prijmeni)); } }
private void RefreshStudentGrid() { MyDb dbc = new MyDb(); //var res = from s in dbc.Studenti // select s; //var res2 = res.ToList(); //dataGridView_Student.DataSource = res2; var x = dbc.Studenti.Count(); //SQLiteDataAdapter a = new SQLiteDataAdapter(); //DataTable t = new DataTable(); //dbc.Studenti.ToList().fill //dataGridView_Student.DataSource = dbc.Studenti; dataGridView_Student.DataSource = dbc.Studenti.ToList(); dataGridView_Student.Refresh(); }