本文整理汇总了C#中MySql.Data.MySqlClient.MySqlCommand.GetString方法的典型用法代码示例。如果您正苦于以下问题：C# MySqlCommand.GetString方法的具体用法？C# MySqlCommand.GetString怎么用？C# MySqlCommand.GetString使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySql.Data.MySqlClient.MySqlCommand的用法示例。
在下文中一共展示了MySqlCommand.GetString方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: buttonDbTest_Click
private void buttonDbTest_Click(object sender, EventArgs e)
{
reopenDatabase();
comboBoxSchema.Items.Clear();
MySqlDataReader dr = new MySqlCommand("SHOW DATABASES;", _conn).ExecuteReader();
while(dr.Read())
{
comboBoxSchema.Items.Add(dr.GetString(0));
}
dr.Close();
}示例2: GetTableNames
private static List<string> GetTableNames()
{
try
{
m_Connection.Open();
MySqlDataReader mysqlDR = new MySqlCommand(ConfigConst.MysqlCmd, m_Connection).ExecuteReader();
List<string> tables = new List<string>();
while (mysqlDR.Read())
{
string table = mysqlDR.GetString(0);
if (!tables.Contains(table) && table.Contains(ConfigConst.TableNameKeyWord))
{
tables.Add(table);
}
}
m_Connection.Close();
return tables;
}
catch (Exception e)
{
Debug.Log("Error : " + e.Message);
throw;
}
}示例3: getItem
public static Request getItem()
{
Request r = new Request();
try
{
MySqlDataReader rdr = new MySqlCommand("SELECT `id`,`steam_id`,`type`,`priority` FROM `queue` WHERE `id` IN (SELECT `queue_id` FROM `queue_status` WHERE `active`=1 AND `status`=" + (int)RequestStatus.Waiting + ") ORDER BY `priority` DESC, `id` ASC LIMIT 1", QueueConnection).ExecuteReader();
while (rdr.Read())
{
r.ID = rdr.GetInt32(0);
r.User = rdr.GetUInt64(1);
r.TradeType = (Bot.TradeTypes)rdr.GetInt32(2);
r.Priority = rdr.GetInt32(3);
}
rdr.Close();
r.Data = new string[Int32.Parse((new MySqlCommand("SELECT COUNT(`data`) FROM `queue_items` WHERE `queue_id`=" + r.ID, conn)).ExecuteScalar().ToString())];
rdr = (new MySqlCommand("SELECT `data` FROM `queue_items` WHERE `queue_id`=" + r.ID, conn)).ExecuteReader();
int i = 0;
while (rdr.Read())
r.Data[i++] = rdr.GetString(0);
rdr.Close();
}
catch (Exception e)
{
log.Error("Error getting new request: " + e.Message);
}
return r;
}示例4: GetTableNames
private List<string> GetTableNames()
{
try
{
this.m_Connection.Open();
MySqlDataReader mysqlDR = new MySqlCommand(MyConst.MysqlCmd, this.m_Connection).ExecuteReader();
List<string> tables = new List<string>();
while (mysqlDR.Read())
{
string table = mysqlDR.GetString(0);
if (!tables.Contains(table) && table.Contains(MyConst.TableNameKeyWord))
{
tables.Add(table);
}
}
this.m_Connection.Close();
return tables;
}
catch (Exception e)
{
Console.WriteLine("Error : " + e.Message);
throw;
}
}