本文整理汇总了C#中MySqlConnection.CreateCommand方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlConnection.CreateCommand方法的具体用法?C# MySqlConnection.CreateCommand怎么用?C# MySqlConnection.CreateCommand使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySqlConnection
的用法示例。
在下文中一共展示了MySqlConnection.CreateCommand方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: MainWindow
public MainWindow (): base (Gtk.WindowType.Toplevel)
{
Build ();
treeView.AppendColumn("id",new CellRendererText(),"text",0);
treeView.AppendColumn("nombre",new CellRendererText(),"text",1);
listStore = new ListStore (typeof(string),typeof(string));
treeView.Model=listStore;
mySqlConnection= new MySqlConnection(
"server = localhost; Database=bdproductos; user id = root; password=sistemas");
mySqlConnection.Open();
MySqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "select * from categoria";
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
while(mySqlDataReader.Read()){
object id = mySqlDataReader["id"].ToString();
object nombre = mySqlDataReader["nombre"];
listStore.AppendValues(id,nombre);
}
}
示例2: AddUser
public string AddUser(string ime, string ura, string minuta)
{
try
{
string myConnection = "SERVER=studsrv.uni-mb.si;" + "DATABASE=varnepoti;" + "UID=ronzyfonzy;" + "PASSWORD=snopy02;";
connect = new MySqlConnection(myConnection);
connect.Open();
/*maxInserts = connect.CreateCommand();
maxInserts.CommandText = "SELECT MAX(id) AS max FROM EXT_REMINDER;";
dataReader = maxInserts.ExecuteReader();
dataReader.Read();
int max = Convert.ToInt32(dataReader["max"].ToString());
dataReader.Close();*/
insertAlarm = connect.CreateCommand();
//INSERT INTO `EXT_REMINDER` (`ime`, `ura`, `minuta`) VALUES ('test1', '23', '12')
//insertAlarm.CommandText = "INSERT INTO EXT_REMINDER VALUES(" + 1 + ", '" + ime + "', '" + ura + "', '" + minuta + "');";
insertAlarm.CommandText = "INSERT INTO `EXT_REMINDER` (`ime`, `ura`, `minuta`) VALUES ('" + ime + "', '" + ura + "', '" + minuta + "');";
insertAlarm.ExecuteNonQuery();
connect.Close();
return "narejeno";
}
catch (Exception e)
{
return "ni_narejeno";
}
}
示例3: OnRefreshActionActivated
protected void OnRefreshActionActivated (object sender, System.EventArgs e)
{
listStore.Clear();
listStore = new ListStore (typeof(string),typeof(string));
treeView.Model=listStore;
mySqlConnection= new MySqlConnection(
"server = localhost; Database=bdproductos; user id = root; password=sistemas");
mySqlConnection.Open();
MySqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "select * from categoria";
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
while(mySqlDataReader.Read()){
object id = mySqlDataReader["id"].ToString();
object nombre = mySqlDataReader["nombre"];
listStore.AppendValues(id,nombre);
}
}
示例4: LockedTable
public void LockedTable()
{
string connStr = GetConnectionString(true);
connStr = String.Format(@"Use Affected Rows=true;allow user variables=yes;Server=localhost;Port={0};
Database={1};Uid=root;Connect Timeout=35;default command timeout=90;charset=utf8", this.port, database0);
execSQL(@"CREATE TABLE `t1` (
`Key` int(10) unsigned NOT NULL auto_increment,
`Val` varchar(100) NOT NULL,
`Val2` varchar(100) NOT NULL default '',
PRIMARY KEY (`Key`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1");
execSQL(@"CREATE TABLE `t2` (
`Key` int(10) unsigned NOT NULL auto_increment,
`Val` varchar(100) NOT NULL,
PRIMARY KEY (`Key`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1");
execSQL("lock tables t2 read");
using (TransactionScope scope = new TransactionScope())
{
using (MySqlConnection conn = new MySqlConnection(connStr))
using (MySqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = @"insert into t1 (Val,Val2) values (?value1, ?value2)"; ;
cmd.CommandTimeout = 5;
cmd.Parameters.AddWithValue("?value1", new Random().Next());
cmd.Parameters.AddWithValue("?value2", new Random().Next());
cmd.ExecuteNonQuery();
}
using (MySqlConnection conn = new MySqlConnection(connStr))
using (MySqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = @"insert into t2 (Val) values (?value)";
cmd.CommandTimeout = 5;
cmd.Parameters.AddWithValue("?value", new Random().Next());
try
{
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
Assert.IsTrue(ex.InnerException is TimeoutException);
}
}
scope.Complete();
}
MySqlPoolManager.ClearAllPools();
}