static void Main(string[] args)
{
string sqlstr = "select * from manavatar";
MySQL（MySQL認證 MySQL培訓 ）Connection DBConn = new MySQLConnection(new MySQLConnectionString("192.168.0.13", "Flashdata", "root", "root", 3306).AsString);
DBConn.Open();
//MySQLDataAdapter myadap = new MySQLDataAdapter(sqlstr, conn);
MySQLCommand DBComm = new MySQLCommand(sqlstr,DBConn);
MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); //DBComm.ExecuteReaderEx();
MySQLDataAdapter DTAdapter = new MySQLDataAdapter(sqlstr,DBConn);
DataSet myDataSet = new DataSet();
DTAdapter.Fill(myDataSet,"manavatar");
try
{
while (DBReader.Read())
{
//Console.WriteLine("11");
Console.WriteLine("DBReader:{0},\t\t\tddddd:{1},\t\t {2}",DBReader.GetString(0), DBReader.GetString(1),DBReader.GetString(3));
}
Console.WriteLine("0000");
}
catch (Exception e)
{
Console.WriteLine("讀入失敗！" e.ToString());
}
finally
{
Console.WriteLine("DBReader關閉");
Console.WriteLine("DBConn關閉");
DBReader.Close();
//DBConn.Close();
}
for (int i = 0; i < myDataSet.Tables["manavatar"].Rows.Count; i )
{
Console.WriteLine("{0}",myDataSet.Tables["manavatar"].Rows["user"]);
}
}
這是一個簡單的例子。
在這裡有個問題：dataset如果沒設主鍵的話，可能會引起一些對數庫操作的問題，比如會造成updata出現錯誤。
