导入DBF库

导入DBF库数据需要在服务器端安装DBF库的驱动程序。

 private void InsertMemberInfo()
    {
        CMS.BLL.MemberManage mm = new CMS.BLL.MemberManage();
        string sql =" insert into CMS_MemberT from OPENROWSET('MSDASQL','Driver={Microsoft Visual FoxPro Driver}; SourceDB=d://website//XZSEC//admin//memberDBF;SourceType=dbf','select *  from member.dbf') ";
        mm.GetExeCmdResult(sql);
        mm.Dispose();
    }