本文整理汇总了C#中MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar方法的典型用法代码示例。如果您正苦于以下问题:C# MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar方法的具体用法?C# MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar怎么用?C# MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySql.Data.MySqlClient.MySqlCommand
的用法示例。
在下文中一共展示了MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SqlScalar
/// <summary>
/// Для выполнения запросов к MySQL с возвращением 1 параметра.
/// </summary>
/// <param name="sql">Текст запроса к базе данных</param>
/// <param name="connection">Строка подключения к базе данных</param>
/// <returns>Возвращает значение при успешном выполнении запроса, текст ошибки - при ошибке.</returns>
public static MyResult SqlScalar(string sql, string connection)
{
MyResult result = new MyResult();
try
{
MySql.Data.MySqlClient.MySqlConnection connRC = new MySql.Data.MySqlClient.MySqlConnection(connection);
MySql.Data.MySqlClient.MySqlCommand commRC = new MySql.Data.MySqlClient.MySqlCommand(sql, connRC);
connRC.Open();
try
{
result.ResultText = commRC.ExecuteScalar().ToString();
result.HasError = false;
}
catch (Exception ex)
{
result.ErrorText = ex.Message;
result.HasError = true;
}
connRC.Close();
}
catch (Exception ex)//Этот эксепшн на случай отсутствия соединения с сервером.
{
result.ErrorText = ex.Message;
result.HasError = true;
}
return result;
}
示例2: button3_Click
private void button3_Click(object sender, EventArgs e)
{
WriteLog("Count Players Online", Color.Gray);
string connectionString;
connectionString = "Data Source=" + databaseHost + ";User Id=" + databaseUser + ";Password=" + databasePass +";Database="+realmDatabase;
MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(connectionString);
conn.Open();
string query = "SELECT COUNT(*)FROM account WHERE online=\"1\"";
MySql.Data.MySqlClient.MySqlCommand resQuery = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
oCount = Convert.ToInt16(resQuery.ExecuteScalar());
label1.Text = "Players Online: " + oCount;
conn.Close();
}