using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySQLDriverCS;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
//MySQLConnection sc = null;
MySQLConnection sc = new MySQLConnection(new MySQLConnectionString( "b", "root", "sa").AsString);
try
{
sc.Open();
//MySQLCommand cmd = new MySQLCommand("insert into students values('aaaaa1',10,'bbbb',100)",sc);
//MySQLCommand cmd = new MySQLCommand("delete from students where name='aaaaa1'", sc);
MySQLCommand cmd = new MySQLCommand("update students set age=200 where name='adsf'",sc);
int i = cmd.ExecuteNonQuery();
if(i>0)
Console.WriteLine("添加数据成功");
}
catch (System.Exception ex)
{
Console.WriteLine("打开数据库错误：{0}", ex.Message);
}
finally
{
sc.Close();
Console.WriteLine("关闭数据库成功");
}
System.Console.ReadLine();
}
}
}
