using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
using System.Data.SqlClient;
namespace DbfExample
{
public partial class Form1 : Form
{
System.Data.Odbc.OdbcConnection conn;
public Form1()
{
InitializeComponent();
}
//导出数据
private void btnOut_Click(object sender, EventArgs e)
{
string connect = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\\; ";
OdbcConnection myconn = new OdbcConnection(connect);
string sqlt ="CREATE TABLE aa.DBF (cc int(10))";
myconn.Open();
OdbcCommand olec = new OdbcCommand(sqlt, myconn);
try
{
int i = olec.ExecuteNonQuery();
MessageBox.Show("'" + i + "'success");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
olec.Dispose();
myconn.Close();
}
//string ole_connstring = @"Provider=microsoft.jet.oledb.5.0;Data Source=D:\;";
//System.Data.OleDb.OleDbConnection ole_conn = new System.Data.OleDb.OleDbConnection(ole_connstring);
//try
//{
// ole_conn.Open();
// System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand
// ("Create Table TestTable (Field1 int, Field2 char(10),Field float(10,2))",
// ole_conn);
// System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand
// ("Insert Into TestTable values (1,'Hello3',520.20)", ole_conn);
// System.Data.OleDb.OleDbCommand cmd3 = new System.Data.OleDb.OleDbCommand
// ("Insert Into TestTable values (2,'Hello4',18076.60)", ole_conn);
// cmd1.ExecuteNonQuery();
// cmd2.ExecuteNonQuery();
// cmd3.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
//finally
//{
// ole_conn.Close();
//}
}
//导入数据
private void btnIn_Click(object sender, EventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
Bind();
}
private void Bind()
{
try
{
conn = new System.Data.Odbc.OdbcConnection();
string table = @"C:\测试例子\Dbf\prepur.dbf";
string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
conn.ConnectionString = connStr;
conn.Open();
string sql = @"select * from " + table;
OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.dataGridView1.DataSource = dt.DefaultView;
//MessageBox.Show(dt.Rows[0][0].ToString());
}
catch
{ }
finally
{
conn.Close();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
conn = new System.Data.Odbc.OdbcConnection();
string table = @"C:\测试例子\Dbf\table1.dbf";
string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
conn.ConnectionString = connStr;
conn.Open();
string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
string sql = @"select * from " + table + " where id='" + id + "'";
OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
txtId.Text = id;
txtName.Text = dt.Rows[0]["name"].ToString();
txtAddress.Text = dt.Rows[0]["address"].ToString();
}
catch { }
finally
{
conn.Close();
}
}
private void Add()
{
conn = new System.Data.Odbc.OdbcConnection();
string table = @"C:\temp\Dbf\table1.dbf";
string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
conn.ConnectionString = connStr;
conn.Open();
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = conn;
string sql = "insert into " + table + " values('" + txtId.Text + "','" + txtName.Text + "','" + txtAddress.Text + "')";
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
Bind();
}
private void btnTOSQL_Click(object sender, EventArgs e)
{
try
{
string sql = "Insert Into dbftosql select * From openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=C:\\temp\\Dbf','select * from table1.dbf')";
SqlConnection con = new SqlConnection("server=.;database=labelprint;uid=sa;pwd=sa");
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}