static void Main(string[] args)
{
MySqlite db = new MySqlite("mydb.db3");
db.connect();
try
{
db.executeQuery("create table users(" +
"id integer primary key autoincrement," +
"username varchar(32)," +
"password varchar(128))");
} catch (SQLiteException e) {
Console.WriteLine("{0}", e.Message);
}
string[,] users = new string[50, 2];
for (int n = 0; n < 50; n++)
{
users[n, 0] = "user_" + n.ToString();
users[n, 1] = "pass_" + n.ToString();
}
db.fastInserts("users", "NULL, ?,?", users);
DataSet dataSet = db.select("select * from users;");
foreach (DataTable t in dataSet.Tables)
{
Console.WriteLine("Tabela {0} zawiera {1} wiersze", t.TableName, t.Rows.Count);
foreach (DataRow r in t.Rows)
{
Console.Write("-> ");
foreach (DataColumn c in t.Columns)
{
Console.Write("{0}={1}, ", c.ColumnName, r[c.ColumnName]);
}
Console.WriteLine();
}
}
dataSet.Dispose();
SQLiteDataAdapter da = db.getAdapter("select * from users;", true);
DataSet ds = db.getData(da);
DataRow[] drows = ds.Tables[0].Select("username = '******'");
for (int i = 0; i < drows.Length; i++)
{
drows[i].BeginEdit();
drows[i]["password"] = "******";
drows[i].EndEdit();
}
Console.WriteLine("zmodyfikowano: {0} wierszy", da.Update(ds));
ds.Dispose();
da.Dispose();
dataSet = db.select("select * from users;");
foreach (DataTable t in dataSet.Tables)
{
Console.WriteLine("Tabela {0} zawiera {1} wiersze", t.TableName, t.Rows.Count);
foreach (DataRow r in t.Rows)
{
Console.Write("-> ");
foreach (DataColumn c in t.Columns)
{
Console.Write("{0}={1}, ", c.ColumnName, r[c.ColumnName]);
}
Console.WriteLine();
}
}
db.close();
Console.ReadLine();
}
static void Main(string[] args)
{
MySqlite db = new MySqlite("mydb.db3");
db.connect();
try
{
db.executeQuery("create table users(" +
"id integer primary key autoincrement," +
"username varchar(32)," +
"password varchar(128))");
} catch (SQLiteException e) {
Console.WriteLine("{0}", e.Message);
}
string[,] users = new string[50, 2];
for (int n = 0; n < 50; n++) {
users[n, 0] = "user_" + n.ToString();
users[n, 1] = "pass_" + n.ToString();
}
db.fastInserts("users", "NULL, ?,?", users);
DataSet dataSet = db.select("select * from users;");
foreach (DataTable t in dataSet.Tables)
{
Console.WriteLine("Tabela {0} zawiera {1} wiersze", t.TableName, t.Rows.Count);
foreach (DataRow r in t.Rows)
{
Console.Write("-> ");
foreach (DataColumn c in t.Columns)
Console.Write("{0}={1}, ", c.ColumnName, r[c.ColumnName]);
Console.WriteLine();
}
}
dataSet.Dispose();
SQLiteDataAdapter da = db.getAdapter("select * from users;", true);
DataSet ds = db.getData(da);
DataRow[] drows = ds.Tables[0].Select("username = '******'");
for (int i = 0; i < drows.Length; i++)
{
drows[i].BeginEdit();
drows[i]["password"] = "******";
drows[i].EndEdit();
}
Console.WriteLine("zmodyfikowano: {0} wierszy", da.Update(ds));
ds.Dispose();
da.Dispose();
dataSet = db.select("select * from users;");
foreach (DataTable t in dataSet.Tables)
{
Console.WriteLine("Tabela {0} zawiera {1} wiersze", t.TableName, t.Rows.Count);
foreach (DataRow r in t.Rows)
{
Console.Write("-> ");
foreach (DataColumn c in t.Columns)
Console.Write("{0}={1}, ", c.ColumnName, r[c.ColumnName]);
Console.WriteLine();
}
}
db.close();
Console.ReadLine();
}
