hi
hello i am creating asp.net with c# app in which we retive data from or
select data from foxpro2.6 dbf and update the data using ms access query
in c# but update not work error generate like "operation updation use"
sir please help me

using System.Data.Odbc;


string str1="abc";
string str=@"Driver={Microsoft dBASE
Driver(*.dbf)};DriverID=277;Dbq=e:\medicell\comp00 09;";
OdbcConnection con=newOdbcConnection(str);
con.Open();
OdbcCommand cmd=new OdbcCommand("update acbal set name2=@name2",con);

cmd.Parameters.Add("@name2",str1);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
Response.Write("Update");

*** Sent via Developersdex http://www.developersdex.com ***

Hi Mayank,

Download and install the FoxPro and Visual FoxPro OLE DB data provider from
msdn.microsoft.com/vfoxpro/downloads/updates. It's backward compatible to
all versions of FoxPro DBFs.

The following code worked for me:

OleDbParameter parm1 = new OleDbParameter("parm1", OleDbType.Char);
parm1.Value = "abc";

string str = @"Provider=VFPOLEDB.1;Data Source=C:\Temp;";
OleDbConnection con = new OleDbConnection(str);
con.Open();

OleDbCommand cmd = new OleDbCommand("update acbal set name2=?", con);

cmd.Parameters.Add(parm1);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy (AT) cindywinegarden (DOT) com


"mayank mishra" <lucky13980 (AT) yahoo (DOT) co.in> wrote