Foxpro2.6 的dbf文件,如何實現sql的检索结果(关鍵是能实现动态参数)?
private void selectDt()
{
string filename = @"C:\xxx.DBF";
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ filename.Substring(0, filename.LastIndexOf("\\") + 1) + @";Extended Properties=""dBASE IV;HDR=Yes;"";";
OleDbDataAdapter adpt = new OleDbDataAdapter("Select * From [" + filename.Substring(filename.LastIndexOf("\\") + 1, filename.Length - filename.LastIndexOf("\\") - 1) + "]", strConn);
DataSet mySet = new DataSet();
adpt.Fill(mySet);
DataTable dt= mySet.Tables[0];
}
可以实现从dbf中提取数据到tatatable,但我需要动态的效果:
设xxx.dbf中有字段a,b,c,d;提取如下(SQL server的效果)
select a,left(b,3) as b,(case when a='1' then a+d else b+d end) as comb,c,d from xxx.dbf
而且这个需求是动态的,如何实现?