本文整理汇总了C#中Mono.Data.Sqlite.SqliteConnection.Clone方法的典型用法代码示例。如果您正苦于以下问题:C# SqliteConnection.Clone方法的具体用法?C# SqliteConnection.Clone怎么用?C# SqliteConnection.Clone使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Mono.Data.Sqlite.SqliteConnection
的用法示例。
在下文中一共展示了SqliteConnection.Clone方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: AddItem
public void AddItem(string item, double cost)
{
string connectionstring = @"URI=file:Item.db";
SqliteConnection sqcon = new SqliteConnection (connectionstring);
sqcon.Open ();
SqliteCommand sqcmd = sqcon.CreateCommand ();
string sql = @"INSERT INTO items(item, cost) VALUES(@item, @cost);";
sqcmd.CommandText = sql;
sqcmd.Prepare ();
sqcmd.Parameters.AddWithValue ("@item", item);
sqcmd.Parameters.AddWithValue ("@cost", cost);
sqcmd.ExecuteNonQuery ();
sqcmd.Dispose ();
sqcon.Clone ();
Console.WriteLine ("item {0} successfully added!", item);
}
示例2: ExecuteNonQuery
private int ExecuteNonQuery(string sql)
{
SqliteConnection cnn = new SqliteConnection(dbConnection);
cnn.Open();
SqliteCommand cmd = new SqliteCommand(cnn) { CommandText = sql };
int rowUpdated = cmd.ExecuteNonQuery();
cnn.Clone();
return rowUpdated;
}
示例3: ShowItem
public void ShowItem()
{
List<MyItem> item_list = new List<MyItem> ();
double total_cost = 0;
string connectionstring = @"URI=file:Item.db";
SqliteConnection sqcon = new SqliteConnection (connectionstring);
sqcon.Open ();
SqliteCommand sqcmd = sqcon.CreateCommand ();
string sql = @"SELECT id, item, cost from items";
sqcmd.CommandText = sql;
IDataReader reader = sqcmd.ExecuteReader ();
while(reader.Read())
item_list.Add(new MyItem(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2)));
sqcmd.Dispose ();
sqcon.Clone ();
foreach (MyItem i in item_list) {
Console.WriteLine ("item No {0} {1} costs {2}", i.ID, i.DESCR, i.COST);
total_cost += i.COST;
Console.WriteLine ("TotalCost: {0}", total_cost);
}
}
示例4: RemoveItem
public void RemoveItem(int id)
{
string connectionstring = @"URI=file:Item.db";
SqliteConnection sqcon = new SqliteConnection (connectionstring);
sqcon.Open ();
SqliteCommand sqcmd = sqcon.CreateCommand ();
string sql = @"DELETE FROM items WHERE id = @idno;";
sqcmd.CommandText = sql;
sqcmd.Prepare ();
sqcmd.Parameters.AddWithValue ("@idno", id);
sqcmd.ExecuteNonQuery ();
sqcmd.Dispose ();
sqcon.Clone ();
Console.WriteLine ("item No {0} successfully removed!", id);
}