private static void updateDatabase(MysqlConnection mysqlConnection) { MySqlCommand mysqlCommand = mysqlConnection.CreateCommand(); mysqlCommand.CommandText = "update articulo set categoria=null where id=4"; mysqlCommand.ExecuteNonQuery(); }
private void RankerList_Load(object sender, EventArgs e) { MysqlConnection mysqlConnection = new MysqlConnection(); mysqlConnection.Connection(); //mysqlConnection.SelectOne(); mysqlConnection.ShowRank(); }
public int InserirCategoria(Categoria categoria) { string comandoSQL = "Insert into Categoria (Nome, FaixaEtaria, ApareceNoMenu, Descricao) values (@Nome , @FaixaEtaria , @ApareceNoMenu , @Descricao);"; MysqlConnection conexao = new MysqlConnection("Server=localhost;Database=MovieMais;Uid=root;Pwd=;"); MySqlCommand comando = new MySqlCommand(comandoSQL, conexao); conexao.Opne(); }
static void Main(string[] args) { //初始话服务器资源配置 ConfigXmlFileRead.ReadGameFilePath(currentGameToLoadFilePath, allGameResourse); ServerStart serverStart = new ServerStart(60); serverStart.center = new HandlerCenter(); serverStart.Start(3389); Console.WriteLine("服务器已启动"); MysqlConnection mysqlConnection = new MysqlConnection(); Console.WriteLine(mysqlConnection.MysqlInfo()); DataView dataView = mysqlConnection.MysqlDataAdapter("User"); //Console.WriteLine( dataView.Table.; while (true) { Console.ReadLine(); } }
private static void updateDatabase(MysqlConnection mysqlConnection) { MySqlCommand mysqlCommand = mysqlConnection.CreateCommand(); mysqlCommand.CommandText = "update articulo set categoria=null where id=4"; mysqlCommand.ExecuteNonQuery (); }
//// private bool InitConnect() { m_conn = new MysqlConnection("127.0.0.1", "root", "x5", "takeout"); string strInfo = m_conn.MysqlInfo(); return strInfo != null; }