public void MySqlStore() { MySqlConnection connection = new MySqlConnection( "Server=localhost;" + "User ID=root;" + "Password=;"); connection.Open(); MySqlCommand cmd = connection.CreateCommand(); string sql = "DROP DATABASE openid_test;"; cmd.CommandText = sql; try { cmd.ExecuteNonQuery(); } catch (MySqlException e) { } cmd.Dispose(); cmd = connection.CreateCommand(); cmd.CommandText = "CREATE DATABASE openid_test;"; cmd.ExecuteNonQuery(); cmd.Dispose(); cmd = connection.CreateCommand(); cmd.CommandText = "USE openid_test;"; cmd.ExecuteNonQuery(); cmd.Dispose(); MySqlStore store = new MySqlStore(connection); store.CreateTables(); StoreTester tester = new StoreTester(store); tester.Test(); }
/// <summary>l um valor</summary> internal static int executeNonQuery( string query ) { string connectionString = OrionGlobals.getConnectionString("connectiostring-mysql"); MySqlConnection conn = new MySqlConnection(connectionString); try { conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query; cmd.CommandType = CommandType.Text; object obj = cmd.ExecuteScalar(); if( obj == null ) { return 0; } return int.Parse(obj.ToString()); } catch( Exception e ) { Chronos.Utils.Log.log("Connection String: {0}", connectionString); Chronos.Utils.Log.log("Error: " + e.Message); throw; } finally { conn.Close(); } }
public CatLists(MySqlConnection conn) { _conn = conn; conn.Open(); ArrayList listNames = new ArrayList(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText ="SELECT DISTINCT ListName FROM " + _table; MySqlDataReader dr = cmd.ExecuteReader(); while(dr.Read()) { listNames.Add(Convert.ToString(dr["ListName"])); } dr.Close(); conn.Close(); foreach(string listName in listNames){ List.Add(new CatList(listName, false, conn)); } }