Connect to data in your Database using Data View
-
Please log in to view this article.
VN:R_U [1.9.6_1107]Connect to data in your Database using Data View, 5.0 out of 5 based on 2 ratingsRatingRating: 5.0/5 (2 votes cast)
Learn how to create columns and add data to the custom list
Video Transcript
var playerhost = (("https:" == document.locatio…
Use Data View web part to fetch data from various sources. Not just that, but also see how you can write back data to its original sour…
SharePoint Designer comes with a powerful web part called Data View. Use Data View to show list data from a SharePoint site. Also shown…
4 Comments
Please do not use this form
Leave a Comment
Members Login
Categories
- Access Services (13)
- Active Directory (1)
- Administration (10)
- Alerts (1)
- Audience Targeting (2)
- Backup and Restore (3)
- BCS (11)
- BDC (1)
- Branding (11)
- Business Intelligence (2)
- Content Types (1)
- Document Management (19)
- Featured (1)
- Features (1)
- Forms Server (2)
- General (200)
- Free (13)
- Free 2010 (22)
- SP Administration (6)
- SP Advanced (8)
- SP Content (13)
- SP Installation (3)
- SP Libraries (10)
- SP Lists (11)
- SP Overview (3)
- SP Security (3)
- SP Site Structure (8)
- SP10 Access (13)
- SP10 Advanced (5)
- SP10 BCS (11)
- SP10 Branding (11)
- SP10 Bus Intel (1)
- SP10 Doc Mgmt (10)
- SP10 Installation (1)
- SP10 List (15)
- SP10 Overview (1)
- SP10 Reporting Svcs (13)
- SP10 Security (7)
- SP10 Site Customization (7)
- SP10 Site Structure (13)
- SP10 Term Store (8)
- SP10 WCM (2)
- SP10 Workflow (1)
- Guest Videos (3)
- InfoPath (11)
- InfoPath 2010 Training (15)
- Inf10 Convert (2)
- Inf10 Data (2)
- Inf10 Overview (2)
- Inf10 Rules (3)
- Inf10 SPForm (3)
- Inf10 SPList (3)
- Installation (4)
- Libraries (12)
- Lists (30)
- Master Pages (1)
- Meeting Workspaces (1)
- Mini Videos (63)
- End User (63)
- My Sites (1)
- Navigation (3)
- Office 365 Overview (1)
- Overview (7)
- Recycle Bin (3)
- Reporting Services (13)
- RSS (1)
- Search (2)
- Security (9)
- SharePoint Blogs (1)
- SharePoint Designer (26)
- SPD Customizations (7)
- SPD Data View (7)
- SPD Integration with InfoPath (1)
- SPD List View (2)
- SPD Overview (1)
- SPD Workflow (8)
- SharePoint Designer 2010 (32)
- SPD10 Data View (3)
- SPD10 Integration (1)
- SPD10 List View (4)
- SPD10 MPPL (3)
- SPD10 Overview (2)
- SPD10 Security (2)
- SPD10 SPContent (8)
- SPD10 Workflow (9)
- Site Columns (1)
- Site Provisioning (7)
- Site Structure/Customizations (23)
- Surveys (1)
- Taxonomy (8)
- Vendor Solutions (1)
- Web Parts (16)
- Webinar (2)
- Webinar10 (15)
- Wikis (1)
- Workflows – Out of the Box (6)


November 12, 2010 am31 10:37 am
Hi Asif,
I’m a newbie and I’m fascinated with your videos, I signed up for a whole year and I think it’s worth every penny. I have a SQL database that I’m trying to edit using your video as a guide. I created the dataview and it all looks fine but when I go to the editing tab in Dataview Properties, the the checkboxes for show, edit and delete are grayed out. Can you please tell me what I’m doing wrong? It works fine if the source is a SharePoint list so I’m thinking it’s a permissions issue but I don’t know how to solve it. Can you please provide some advise?
November 12, 2010 am31 11:24 am
Appreciate the kind words!
The reason that usually happens is that your data connection does not have the proper update/delete statements configured to the data source to allow you to turn on those features. For this, I would recommend checking your code behind in SPD to see if the SQL statements for those commands are present. If not, I would suggest you create a new data connection and make sure you make it write enabled.
December 19, 2010 am31 2:53 pm
Dear Aisf,
I’m Kamaraj from India (Tamilnadu). Please check this video. It automatically stoped with 10.29 minu. But the full legth of video is 59.
Thanks and Regards
kamaraj.V
December 20, 2010 am31 11:41 am
Sounds like a buffering issue Kamaraj. Video plays fine for me.
Try another machine to compare the difference.