tnt2pro吧 关注:5贴子:562
  • 0回复贴,共1

c#戒指oledb读取dbf文件

只看楼主收藏回复

OleDbConnection conn = new OleDbConnection();
string strTable = @"D:\VS2012_Work_Space\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\bou2_4l.dbf";
conn.ConnectionString = @"Provider=VFPOLEDB.1;DATA Source=" + strTable;
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
string SQLSE1 = "select * from "+ strTable;
OleDbDataAdapter da = new OleDbDataAdapter(SQLSE1, conn);
DataTable data_point = new DataTable();
da.Fill(data_point);
int num = data_point.Columns.Count;
string type1 = data_point.Columns[0].DataType.ToString();
string type2 = data_point.Columns[1].DataType.ToString();
string type3 = data_point.Columns[2].DataType.ToString();
string type4 = data_point.Columns[3].DataType.ToString();
string type5 = data_point.Columns[4].DataType.ToString();
string type6 = data_point.Columns[5].DataType.ToString();
string type7 = data_point.Columns[6].DataType.ToString();
string type8 = data_point.Columns[7].DataType.ToString();
string name = data_point.Rows[0][data_point.Columns[4].ColumnName].ToString();
int a = 1;


1楼2014-08-10 20:24回复