Hi all,
I'm try to write the code for gridview to delete, edit (only one or two
columns), page, sort using stored procedure to get dataTable to bind data
(avoid using SQLDataSource to bind data). All the samples I see always use
SQLDataSource which in the real business is not the good ideas.

Any ideas or samples would be appreciated.

Thank you.

Hi Walter,

Thank you for your reply. I will try your coding and let you know how is
going.

Madison

Hi Walter,

Thanks, the codes work very good.

I'm interest in using SqlDataSource with stored procedure can you refer to
web site that give more information? Do you have any pro and con on it?

Madison.

Hi Madison,

When you use the wizard to configure SqlDataSource, in the step "How would
you like to retrieve data from your database", you can select "Specify a
custom SQL statement or stored procedure"; when you click next, you can
choose a stored procedure for the SELECT/UPDATE/INSERT/DELETE.

Hope this helps.


Regards,
Walter Wang (wawang (AT) online (DOT) microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

For a DropDownList, all you need to change in the demo code is to cast the
control returned from FindControl to a DropDownList and you should be able
to get the correct value selected the user currently.


Regards,
Walter Wang (wawang (AT) online (DOT) microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

On Jun 18, 4:03 am, waw... (AT) online (DOT) microsoft.com (Walter Wang [MSFT])
wrote:
Or, if you are using a SqlDataSource, as long as the parameter in the
Update command is the same as the field name (ie State = @State), it
should work without any hassle. also make sure you have the
DataKeyName set in your grid (it should be the primary key).

Hi Madison,

Since I haven't seen your reply yet, I'm writing to check the status of
this post. Thanks.


Regards,
Walter Wang (wawang (AT) online (DOT) microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.