data adapter

[shamaila]

i m creating a data adapter but is not working..is it the correct way??

 OleDbDataAdapter da = new OleDbDataAdapter(strQuery, conn);
da.Fill(ds, "table name");

[radcaesar]

i m creating a data adapter but is not working..is it the correct way??

OleDbDataAdapter da = new OleDbDataAdapter(strQuery, conn);
da.Fill(ds, "table name");

Not working means ? Whats the result or error u got ?

[radcaesar]

When u post problem, ensure that it has enough details for us to give the solution.

[shamaila]

When u post problem, ensure that it has enough details for us to give the solution.

Error 1 The best overloaded method match for 'System.Data.OleDb.OleDbDataAdapter.OleDbDataAdapt er(string, string)' has some invalid arguments


Error 2 Argument '2': cannot convert from 'System.Data.SqlClient.SqlConnection' to 'string'

[r035198x]

Error 1 The best overloaded method match for 'System.Data.OleDb.OleDbDataAdapter.OleDbDataAdapt er(string, string)' has some invalid arguments


Error 2 Argument '2': cannot convert from 'System.Data.SqlClient.SqlConnection' to 'string'

Do you have the ref manual close to you when you're coding (hint: Always refuse to write any code without the docs/refmanual ).
There are four constructors for OleDbDataAdapter and none of them have arguments which match those that you have provided.