. 安装ODBC .NET data provider http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/668/msdncompositedoc.xml 首先建立一个DSN指向DBF文件所在的目录,比如说叫MYDBF,然后在你的VS.NET Project里面引用 using Microsoft.Data.Odbc再用以下代码建立OdbcConnection, OdbcDataAdapter, DataSet.OdbcConnection oCn = New OdbcConnection("DSN=MYDBF") OdbcDataAdapter oDa = new OdbcDataAdapter("SELECT * FROM c:\myTable.dbf", oCn)DataSet oDs = New DataSet() oDa.Fill(oDs, "myTable")
有没有不用连接数据库的方法啊?就像读写txt文件那样的?
>>有没有不用连接数据库的方法啊?就像读写txt文件那样的It's hard to say no or yes, if you are powerful enough , you can do anything for any files. As far as I know, ODBC .NET is the easy way.
renzhongkao"163.com
也可以给我发信
oWord.Documents.Open("MyDocument")
oWord.ActiveDocument.MailMerge.OpenDataSource("MyTable.dbf")
oWord.ActiveDocument.MailMerge.Execute()
首先建立一个DSN指向DBF文件所在的目录,比如说叫MYDBF,然后在你的VS.NET Project里面引用
using Microsoft.Data.Odbc再用以下代码建立OdbcConnection, OdbcDataAdapter, DataSet.OdbcConnection oCn = New OdbcConnection("DSN=MYDBF")
OdbcDataAdapter oDa = new OdbcDataAdapter("SELECT * FROM c:\myTable.dbf", oCn)DataSet oDs = New DataSet()
oDa.Fill(oDs, "myTable")
As far as I know, ODBC .NET is the easy way.
sSourceFileName : 文件名
strConn: 连接串
这只适用于: dBASE IV 如果想用别的可自己看着改把。
string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+sSourcePathName+@";Extended Properties=""dBASE IV;HDR=Yes;"";" ;
OleDbDataAdapter adpt=new OleDbDataAdapter ("Select * From ["+ sSourceFileName +"]",strConn);
DataSet mySet=new DataSet ();
adpt.Fill (mySet);
DataTable DTtxt //我假设你已经把txt中的数据,搞进着个dtTxt中了 string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+sSourcePathName+@";Extended Properties=""dBASE IV;HDR=Yes;"";" ;
OleDbDataAdapter adpt=new OleDbDataAdapter ("Select * From ["+ sSourceFileName +"]",strConn);
OleDbCommandBuilder bd =new OleDbCommandBuilder (tAdpt);
DataSet mySet=new DataSet ();
adpt.Fill (mySet);
DataRow drDbf = mySet.Tables[0].NewRow();
foreach(DataRow drTxt in DTtxt.Rows)
{
如果drDbf 和 drTxt; 格式一样可drDbf = drTxt;
如果不对应的话;只能一列一列的付值了
}
mySet.Tables[0].Rows.Add(drDfb); adpt.Update();
可能代码中有小问题。自己调把。我不能在帮你了。