INSERT INTO stuinfo( first_name, last_name, Birthdate )  
VALUES ( 
'John', 'Smith', '1990-2-3' 
)  

static void Main(string[] args) 
    { 
      string url = "server=127.0.0.1;user=root;database=student;port=3306;password=root;";//指明要連接的數(shù)據(jù)庫地址，用戶名，數(shù)據(jù)庫名，端口，密碼 
      MySqlConnection conn = new MySqlConnection(url);//實(shí)例化連接 
      conn.Open();//打開連接 
 
      string sta = "select * from stuinfo";//執(zhí)行一個(gè)簡單的語句 
      MySqlCommand comm = new MySqlCommand(sta, conn); 
      MySqlDataReader reader = comm.ExecuteReader();//用MySqlDataReader接收執(zhí)行結(jié)果 
      while (reader.Read()) 
      { 
        Console.WriteLine(reader.GetString(0) + " " + reader.GetString(1) + " " + reader.GetString(2) +" " + reader.GetString(3));//讀出查詢的結(jié)果 
      } 
      Console.ReadKey(); 
      reader.Close(); 
      conn.Close();//關(guān)閉連接 
    } 

static void Main(string[] args) 
    { 
      MySQLConnection conn = new MySQLConnection(new MySQLConnectionString("127.0.0.1","student", "root", "root",3306).AsString); 
      conn.Open(); 
 
      MySQLCommand cmd = new MySQLCommand("select * from stuinfo", conn); 
      DbDataReader reader = cmd.ExecuteReader(); 
      while (reader.Read()) 
      { 
        Console.WriteLine(reader.GetString(0) + " " + reader.GetString(1) + " " + reader.GetString(2) + " " + reader.GetString(3));//讀出查詢的結(jié)果   
      } 
      Console.ReadKey(); 
      reader.Close(); 
      conn.Close();//關(guān)閉連接   
    }