110,534
社区成员
发帖
与我相关
我的任务
分享
#region 自定义变量属性
private string filePath = null;
private string connStr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=dBASE IV;User ID=Admin;Password=;";
private OleDbConnection conn = null;
private OleDbCommand cmd = null;
#endregion
#region 实例化入口
/// <summary>
/// 控制DBase文件类
/// </summary>
/// <param name="filePath">需要操作的Dbase文件的文件夹路径</param>
public DBaseConnection(string directory)
{
filePath = directory;
connStr = string.Format(connStr,filePath);
conn = new OleDbConnection(connStr);
cmd = new OleDbCommand();
cmd.Connection = conn;
}
#endregion
if (saveFileDialog1.FileName.EndsWith(".dbf"))
{
string alldir = saveFileDialog1.FileName;
string tableName = alldir.Split(new char[]{'\\'})[alldir.Split(new char[]{'\\'}).Length-1];
string dir = alldir.Replace("\\"+tableName,"");
DataTable dt = ((DataSet)this.uGridInvTransline.DataSource).Tables[0];
dt.TableName = tableName;
DBaseConnection dBase = new DBaseConnection(dir);
rtn = dBase.ExpToFile(dt,out errCode,out errMsg);
if (rtn != 0)
{
this.SetErrorInfo(errMsg);
return;
}
}