.net 如何把datatable導入到mysql中,希望能貼出壹些代碼。

/// 導入

/// </summary>

private void IPortExcel(string filepath)

{

List<Room> list = new List<Room>();

string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";

string str = string.Format(@"select * from [房間信息表$]");

DataTable dt = new DataTable();

using (OleDbConnection conn = new OleDbConnection(constr))

{

conn.Open();

OleDbDataAdapter da = new OleDbDataAdapter(str,conn);

da.Fill(dt);

}

foreach (DataRow dr in dt.Rows)

{

Room r = new Room();

r.BedNum = Convert.ToInt32(dr["床位數"]);

r.RoomStateID = Convert.ToInt32(dr["房間狀態"]);

r.Description = dr["房間描述"].ToString();

r.RoomTypeID=Convert.ToInt32(dr["房間類型"]);

list.Add(r);

}

this.dgvShow.DataSource = list;

}

希望有幫助