Hi Benj
usualy I agree
can you help me anyway?
public DataSet UpdateResourcesToTasks(DataSet ds)
{
using (cn)
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
string queryString = "SELECT [Id],[Name] FROM
[students]";
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);
adapter.SelectCommand.CommandText = queryString;
OleDbCommandBuilder builder = new
OleDbCommandBuilder(adapter);
adapter.Update(ds.Tables["students"]);
return ds;
}
}
the ds I get is after the changes
On 1 דצמבר, 08:43, Benj Nunez <[email protected]> wrote:
> Hi!
>
> "query builder"? If I'm not mistaken, you're referring to the Command
> Builder.
>
> See:http://www.c-sharpcorner.com/UploadFile/puranindia/CommandObjectComma...
>
> You need to pass the correct sql delete command/statement to the
> DataAdapter.DeleteCommand.
>
> Oftentimes, the best way is to code it by hand rather than relying on
> what the wizard does for you.
>
> On Dec 1, 12:29 am, "Montezuma's Daughter" <[email protected]>
> wrote:
>
>
>
> > 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!!!!!!1 please help!!-הסתר
> > טקסט מצוטט-
>
> -הראה טקסט מצוטט-
