找了很久,都没有解决办法。
只有导入的例子,如下:
using System.Data.OleDb;
private void ImportDBF_Load(object sender, EventArgs e)
{
if (ofdDBF.ShowDialog()==DialogResult.OK)
{
string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ofdDBF.FileName.Substring(0, ofdDBF.FileName.LastIndexOf("\\")) + ";Extended Properties=dBASE IV;"; OleDbConnection conn = new OleDbConnection(connStr);
conn.Open(); string cmd_string = "select * from " + ofdDBF.SafeFileName.Substring(0, ofdDBF.SafeFileName.IndexOf("."));
MessageBox.Show(cmd_string);
OleDbDataAdapter da = new OleDbDataAdapter(cmd_string, conn);
DataSet ds = new DataSet();
da.Fill(ds);
dgvImport.DataSource = ds.Tables[0];
} }
求高手指点,最好有代码,谢谢!
只有导入的例子,如下:
using System.Data.OleDb;
private void ImportDBF_Load(object sender, EventArgs e)
{
if (ofdDBF.ShowDialog()==DialogResult.OK)
{
string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ofdDBF.FileName.Substring(0, ofdDBF.FileName.LastIndexOf("\\")) + ";Extended Properties=dBASE IV;"; OleDbConnection conn = new OleDbConnection(connStr);
conn.Open(); string cmd_string = "select * from " + ofdDBF.SafeFileName.Substring(0, ofdDBF.SafeFileName.IndexOf("."));
MessageBox.Show(cmd_string);
OleDbDataAdapter da = new OleDbDataAdapter(cmd_string, conn);
DataSet ds = new DataSet();
da.Fill(ds);
dgvImport.DataSource = ds.Tables[0];
} }
求高手指点,最好有代码,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货