SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have displayed some SQL data in MOSS 2007 with the help of Data View web part. However I wish to create a template sort of from this web part so that going forward I can just go ahead and change the connection string of sql server and the sql query to fetch data and I am done. Any ideas for doing this. If not possible, is there any out-of-box web part to get this functionality? Thanks in advance.

share|improve this question
up vote 0 down vote accepted
  • Configure the webpart
  • Export it to a .webpart file:

enter image description here

  • Navigate to Site settings, and select "Webparts gallery" under Galleries category
  • Upload previously saved file to the gallery:

enter image description here

  • Specify it's name and other settings, if needed
  • Navigate to a site page, switch to page edit mode, and there you will be able to add your webpart (by default, it will be under Miscellaneous category)
share|improve this answer
Did the same steps. But where can I configure the SQL connection and SQL query? – Ashish Oct 17 '11 at 6:29
In SPD, by connecting appropriate DataSource to the webpart. If you want to do this from GUI by setting connection string and query through webpart properties, you will have to implement your own webpart, probably derived from DVWP, with additional property and it will have to create it's DataSource automatically. But I'm afraid that will cost much more labour hours, and actually I can't realize, why you would prefer this hard way, while SPD already has almost what you need (just create the datasource through SPD GUI and you're done) – Andrey Markeev Oct 17 '11 at 7:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.