學習筆記

OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = "連線"; 
DataSet ds = new DataSet();

cn.Open();
string sql = "SELECT verify_date, result  FROM aaa";
OleDbDataAdapter da = new OleDbDataAdapter(sql, cn);
da.Fill(ds, "aaa");
DataTable dt = ds.Tables[0];
cn.Close();

 //直
dataGridView1.DataSource = dt;

 //橫
DataTable dtNew = new DataTable();
for (int i = 0; i < dt.Rows.Count; i++) 
{
    dtNew.Columns.Add("Columns" + i.ToString());
} 

for (int i = 0; i < dt.Columns.Count; i++) 
{ 
    DataRow dr = dtNew.NewRow();
    dtNew.Rows.Add(dr); 
}
           
for (int i = 0; i < ds.Tables["aaa"].Rows.Count; i++) 
{
    for (int j = 0; j < ds.Tables["aaa"].Columns.Count; j++)
    {
        dtNew.Rows[j][i] = dt.Rows[i][j].ToString();
     }
}
dataGridView2.DataSource = dtNew;