Question/bugs about ASp.NET2.0 SqlDataSource and GridView

Hi All,

I try to using the dotnet control instead of code behind to create a quick
solution
(ASP.NET with VB.NET) by using the SqlDataSource and GridView control
(with
SelectCommand, DeleteCommand, UpdateCommand, InsertCommand)
It works fine when drag and drop in the first time. but after I have modify
something
(said, add parmeters for searching...etc), the UpdateCommand and
DeleteCommand
failed! (that means can not update feilds or delete records. the dataset is
simple one
table with primary key), only the InsertCommand works!

I need to clear both SqlDataSource and GridView, redo again to solve it!
whats the problem, is there bugs in DotNet Control ??

thx all

RE: Question/bugs about ASp.NET2.0 SqlDataSource and GridView

Hi Ken,

I do not see any issues with the SQLDatasource, I would recommend you to
reconfigure your SQLDatasource. When you select the fields from the table
then you select the option advanced and then check both the options for
creating the insert, update and delete statements and then check for use the
Optimistic concurrency. Rebind the Grid control with the SQLDatasource.

Please let me know your observation.

Regards,
Manish
www.ComponentOne.com


"ken" wrote:

> Hi All,
>
> I try to using the dotnet control instead of code behind to create a quick
> solution
> (ASP.NET with VB.NET) by using the SqlDataSource and GridView control
> (with
> SelectCommand, DeleteCommand, UpdateCommand, InsertCommand)
> It works fine when drag and drop in the first time. but after I have modify
> something
> (said, add parmeters for searching...etc), the UpdateCommand and
> DeleteCommand
> failed! (that means can not update feilds or delete records. the dataset is
> simple one
> table with primary key), only the InsertCommand works!
>
> I need to clear both SqlDataSource and GridView, redo again to solve it!
> whats the problem, is there bugs in DotNet Control ??
>
> thx all
>
>
>
>