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.