连接了access数据库,读到了其中的列名,之后怎样读到access数据库数据
- private void button1_Click(object sender,EventArgs e)
- string strConnection = "Provider=Microsoft.Jet.0leDb.4.0;";
- strConnection += string.Format("Data Source= {0}", textBox2.Text);
- 0leDbConnection conn = new OleDbConnection(strConnection); //Jet OLEDB:D0leDbCommand cmd = conn.CreateCommand () ;
- cmd.CommandText = "select * from CPON_DATA ";conn.Open() ;
- 0leDbDataReader dr = cmd.ExecuteReader() ;DataTable dt = new DataTable () ;
- if (dr.HasRows)
- {
- for (int i = 0; i < dr.FieldCount; i++){
- dt.Columns.Add(dr.GetName(i)) ;
- dt.Rows.Clear () ;
复制代码
|