Last post Nov 26, 2013 01:07 AM by Angie xu - MSFT
Nov 12, 2013 09:28 AM|renatois|LINK
Hi, the control "SqlDataSource" is not showing in my Visual Studio toolbox. Do I have to install anything to make it available? thanks
Nov 12, 2013 09:35 AM|oned_gk|LINK
Nov 12, 2013 09:49 AM|renatois|LINK
Hi oned_gk, I did this and also selected to "choose items" in the Data tab.
I use Visual Studio 2010 Premium, .Net Framework 3.5 and the solution is a Empty Sharepoint Project which I simply added a Visual Webpart. Inside that webpart I added a gridview and tried to bind that to the SqlDataSource.
Nov 12, 2013 09:54 AM|renatois|LINK
well, when I clicked "choose items" I noticed the SqlDataSource already selected. If I right click the Data tab and select "Show All" I see the SqlDataSource but it is gray like disabled. Any ideas?
Nov 12, 2013 10:18 AM|oned_gk|LINK
Nov 26, 2013 01:07 AM|Angie xu - MSFT|LINK
Net Framework 3.5 and the solution is a Empty Sharepoint Project which I simply added a Visual Webpart.
In sharepoint projects, you cann't drag SqlDataSource from the toolbox to the visual web part, and you have to write codes in it.
if you want to querying data with the SqlDataSource Control (VB), you can also take a look at this article,
# Querying Data with the SqlDataSource Control (VB) -