???????????C#?????????????sql server ???????Щ?????????????????????????????
????????????????FOXPRO?????DBF??????????в?????
????????CSDN?????????????????????????????Щ???????????
?????????????飬??ODBC???????????????
??????????????????
???????????????????????????????????к?????
protected void Page_Load(object sender?? EventArgs e)
{
System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection();
string table = @"D:aaacode.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 = "update " + table + " set other='2'??rate=1.014 ";
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
sql = @"select * from " + table;
OdbcDataAdapter da = new OdbcDataAdapter(sql??conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.GridView1.DataSource = dt.DefaultView;
this.GridView1.DataBind();
}
????????1 ???????????2 ?????????????????·????