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();
}
