By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,786 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,786 IT Pros & Developers. It's quick & easy.

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

P: n/a
ken
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

Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.