Dynamically generate SqlDataSource

Hi, how I do create SqlDataSource in thecode-behind,setting Select SQL along with its parameters and, finallyautomically generating Del, Update, Insert SQL.

Is there a way to achieve this goal as it would in VS designer?

Thanks,

Ricky.

It is possible to create the TSQL code and wrapper code automatically by a variety of means. I use TSQL scripts to do the generation from within Query Analyser.

Which version of SQL Server are you targetting?

|||

Hi, I use SQL SERVER 2005

Thanks,

Ricky.