Sharepoint data view web part

I'm looking for a good data view web part that will allow me to specify;

• The connection string in web.config
  • Alternatively, t开发者_StackOverflow社区ake the connection string from a web part connection
• The SQL to execute, taking parameters from a web part connection

And feature

• Paging and sorting
• Filtering

Any suggestions?

Cheers Tony

YOu can you the DataFormWebPart. design it in SharePoint Designer. YOu can speciy datasources there too.

You could write custom webpart and get exactly the functionality you want. For a quick solution you could write regular ASP.NET user control and use SmartPart to deploy it as a WebPart.