.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to populate forms with data from external websites?

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#
 

I have many lists containing columns for customer account data, which must be filled in manually each time because the customer data is not in Sharepoint or any database accessible by Sharepoint (I have found articles that discuss pulling data from MySQL and Oracle SQL databases).  The customer data is accessed through a website hosted on a different domain.  (I'm not sure how that website works.  I assume the html pages are just a frontend for a database of some kind.  Maybe it's possible to cut out the middle man and get Sharepoint to access that database.  But, it's not a website I control, so I don't know how much I could learn about it.)  I had been using Greasemonkey scripts to query that website and populate the fields in Sharepoint.  This works for me, but not for everyone else--not everyone uses Firefox or knows how to use Greasemonkey, and there's no central management of Greasemonkey scripts.  I'd like to do it all in Sharepoint.

I know how to use javascript within Sharepoint content editor, but my scripts for pulling data from a website don't work.  Someone more knowledgeable than me thinks it's because of Sharepoint security features preventing the script from accessing another domain, and that he can make it work by hosting a proxy within Sharepoint and querying through that proxy.  I'd like


View Complete Post


More Related Resource Links

External Lists and Infopath forms issue with Secondary Data Sources

  
I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

Using Session to pass data between forms

  

In my app, I am displaying an Rss Feed, I have a button that takes the user to another form where they can select a them.  Upon selecting the theme, they are taken back to the original form. 


If the user has selected which theme they want to view then they click on the button to change theme, I need to pass the information about what rss feed they were viewing through session so that once they select the theme they want they are redirected back to the main page and the rss feed they were viewing should still be displayed.


Since I've already bound the data to the xmlDataSource and DataList I am trying the following:


Session.Add("CurrentRssFeed", XmlDataSource1.DataFile);

Session.Add("CurrentDataList", DataList1);


I'm not sure I am passing the data over correctly and I'm not sure how to specify it in the page_preinit.


Any ideas???




problem...i want a list item to populate all data in gridview!!!

  

i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?


Writing Data to database with jQuery Forms, ASMX Webservice, & JSON - help!

  

Hi, 

Can someone point me in the right direction on how to submit data from a jQuery form to a ASMX webservice? I have gotten everything on the form ready to be submitted to the database and now I am stuck on how to send it over using $.ajax(). Everything I have read tells me how to get data from a webservice and display it with jQuery, but not the other direction nor how to access the json data within the within the webservice service(similar to a Request.Form approach with ASP.NET forms).

In other words: 

1. What do I need to do to my webservice to make sure it can receive data from the jQuery form. 

2. What do I need to do in jQuery to receive an acknowledgement the save on the server side was successful. 

I can explain more if need be, but if there is a comprehensive tutorial on not only reading, but also WRITING data with jQuery, JSON, etc. I would love to get pointed in that direction. 


Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Creating .NET Assemblies That Aggregate Data from Multiple External Systems for Business Connectivit

  
This article describes a quick, four-step process for creating a .NET assembly that BCS can use to retrieve external data for SharePoint Server 2010 by using Visual Studio 2010.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

  
Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

  
Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Integrating External Data and Microsoft SharePoint 2010 Platform Services in Microsoft Office 2010 S

  
Microsoft Office 2010 integrates with SharePoint more closely than in previous versions. The resources here show you how to take advantage of the powerful collaboration infrastructure.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

  
SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Writing the windows forms data to an HTML file

  
I have a windows forms application ready now i need to transfer data from the windows forms to the web and to do this i need to write an HTML file that contains the form data, i mean the data contained in the form should be written to an HTML file to be submitted and this HTML file should be generated on the local PC. I have the code for the HTML file but how can i write this HTML file with the data values contained in my windows forms. Please give your suggestions. Best Regards, Syed

entering data through forms and retriving data from sql

  
Hello,       This is varghese, i need to make a web form in asp.net and i need to collect the filled data in a table created in sql. Given below is the format  when the save button clicks i need to save the entered data in to the corresponding table which is created in sql.      name       (text box) gender        female male mixed (radio button list)country       (test box)  state           "district        " e-mail          "phone       " photo        (upload)   Save (button)   after saving the data ,when clicking another  button for example view i need to show the complete record in one line including photo(size of the photo 120X120) please help me to build a sample code which is working perfectly

Connecting a Sharepoint Custom list with an external Data-source

  
Hi I am planning to connect a Sharepoint Custom list with an external Data-source. External DB will be in Access 2007 format. More Information: I need a solution that we can connect our sharepoint list (one-way) to online db in a way that new  information is directly updated in the sharepoint list, whilst other info changed in sharepoint list  is not synced back to original value. Is there a way to solve this? -saumil

populate specific data from table

  
I am trying to build an application.I have table in my database named tbl_customer.I am able to display all the customers information using MVC i.e Name,Designation, Address, PhoneNumber, Sex etc.Now I Want To Display Customer only Having Sex "Female" (Sort Out Data From tbl_customer)How I Can Do This???I Am New To Asp.net.. I Am Using VS 2010, SQL Server 2005Help In This Context, Appreciated In Advance..Regards
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend