command builder problem IN delete- please help!!

Question

User-58406577 posted

Hi all

I have a small project in c# and ms-access I use query builder to manage my tables in ms-access.

 the problem is, select qeury works great, update query works great, delete doesn't work , and there is no error msg!!!!!!

 please help!!

Answer 1

User-126244515 posted

Can you show us the code, please? 

Answer 2

User-58406577 posted

using (cn)

{

OleDbDataAdapter adapter = new OleDbDataAdapter();

string queryString = "SELECT [a],[b] FROM [table]";

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _conStrName + ";User Id=admin;Password=;";

OleDbConnection connection = new OleDbConnection(cn.ConnectionString);

adapter.SelectCommand = new OleDbCommand(queryString, connection);

OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);

 

adapter.SelectCommand.CommandText = queryString;

adapter.DeleteCommand = builder.GetDeleteCommand();

adapter.Update(DATATABLE);

return ds;

Answer 3

User-126244515 posted

Right, I don't see how and where you try to delete a row? The code looks somewhat incomplete, did you mix two blocks of code, or...?

Answer 4

User-58406577 posted

 

in query builder, I don't need to write the sql code . update works nd so as insert. any idea how to help me?

Answer 5

User-1199946673 posted

 

in query builder, I don't need to write the sql code . update works nd so as insert. any idea how to help me?

 

Read this