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


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

Insert SQL Dataset into SP list

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :SharePoint
 
Hi.  I would like to know the best way to get data from a SQL view into a temporary SP list from within SharePoint.  Thank you for your help.


View Complete Post


More Related Resource Links

Crystal report with dataset and list - please help

  

Hi Guys;

i'm new in reporting so thanks to be patient with me,

here is my problem, i have created a report then a report viewer,, i passed some parameters to the report it goes well.

i'm working with local data stored in List<object>, i tried to fill my dataset (data) with those local data stored in the list, i filed Cry

looking for yor help

thanks!


SharePoint Designer: insert custom list not working anymore

  

Hello,

Suddenly sharepoint designer decided today that it doesn't want to insert a custom list form anymore...
To be more specific, it doesn't work anymore in a site that uses the Microsoft budgeting and tracking template. In a website that uses an out of the box template, it still works.

It did work before, because I did it in other websites using the same template (it's broken there as well now).

Why oh why does SharePoint refuse to do this now?
I searched google and here on the forums, but all I could find was some issues after installing SP1, but we did that already long time ago and it was still working after that. I checked with our infrastructure guys and they didn't install new updates they say.

I also tried the solutions listed here: http://blogs.msdn.com/spdsupport/archive/2008/07/03/how-to-fix-custom-list-forms-will-not-insert-or-show-up-on-the-design-surface-of-sharepoint-designer.aspx
But they don't fix the problem.

So my problem is, I can go to Insert > SharePoint Controls > Custom List Form
I pick my list, content type and form type, I hit OK and... nothing happens.

insert new records in tables from dataset to database

  

I have 2 tables in SqlServer 2008.

Table1: T1id, SomeData

Table2: T2id, T1id, SomeData


I am using DataAdapter.FillSchema to create shema of tables in DataSet. I created DataRelation on columns T1id in both tables.

Now when i try to Update Sql Database T1id in Table2 remains 0 and not the value of T1id in Table1.


I can successfully update Sql Database if i fill DataSet with records first (Using DataAdapter.Fill), but that's not what i want to do. I don't need "old" records in my dataset. I want to use dataset just to store all imputs from user until the proccess is done and then insert all those records "at the same time".


I think i'm getting it wrong with ForeignKeyConstraints, maybe UpdateRule is not set to cascade, i just don't know.

I have been trying to work this out for 6 days now and i'm about to break something on half.

Can someone please guide me to right direction, maybe post some sample, anything.... please!


My old post regarding this:

How to update Sql Server related tables from Dataset(SchemaFill)

SqlDataAdapter.Update related tables


how to in Insert database NULL if drop down list item is not selected ?

  
hi,   on my aspx I have the below DDL   <asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"                                                 DataTextField="Size" DataValueField="BustId" Width="150px"                                                 AppendDataBoundItems="True">                                                    <asp:ListItem Value="-1">(Optional)</asp:ListItem>                             &n

Insert a "Select User" row in Linq for a dropdown list

  
I'm new to Linq. I have searched and searched the web for a soluion, and can't find anything. I have a Linq query and I want to insert a row ("Select User") to the top before I pass it to the drop down list. I've been trying to use the Union but to now avail (it keeps telling me that my object doesn't support the Union method). My code, prior to attempting to inser a row, is very simple.public SelectList DropDown_Users()        {            var context = new VivarianDataContext();            var query = from t in context.AspnetUsers                        select new { t.UserId, t.LastName };            list = new SelectList(query.AsEnumerable(), "UserId", "LastName");            return list;        }Now I try to insert a row and I found this on the internet and it seems to say that his solution will work. But it is filled with syntax errors. http://magicode.wordpress.com/2009/08/20/inserting-an-item-in-iqueryable-object-using-union-met

Custom Contact List: has to be auto-populated with users and manually insert others contact

  
Hi All, is it possible to create a custom contact list that automatically insert user as contact? I have to use it to send auto-email to the people in the contact list... (ant they can be user or not) Thanks All Vit

How to insert data into sharepoint list using silverlight application?

  
Hi all, I am developing an Silverlight application. And i want to insert data into sharepoint list through that silverlight application. I am able to retrieve data from sharepoint list and bind it to combo box. But how to insert data? I am retrieving data using service reference. Can anyone help me? Thanks in advance. Waiting for your valuable response.-Kaustubh

Insert an item in a Lookup column's source List from the NewForm

  

When Lookup Column of a List does not contain a value in the DropDown menu can it be added/inserted into the source Lookup List from the NewForm without leaving the NewForm? 

Is there code or example how to insert the Item in the source List, then refresh/repopulate the Lookup Column's DropDown menu (in the NewForm)?

 


Insert data to ms access from datagridview using dataset

  
 

please give me sample code for insert data to MS ACCESS  from grid view using dataset


Refreshing list after insert item

  
Hi, im having problems in a custom list, i develop a custom form with sl and configure a content type to use this form as a newform item, when i clic on new item all its fina my custom form is opened and i can insert the item the thing is when i close this form the custom list behind dont show the new item i mean this list don refresh by itself i have to press F5 to reload the page and see my new item in the list is there a way to make this automatically ? thanks in advance.

list refresh after insert item

  
Hi, im having problems in a custom list, i develop a custom form with sl and configure a content type to use this form as a newform item, when i clic on new item all its fina my custom form is opened and i can insert the item the thing is when i close this form the custom list behind dont show the new item i mean this list don refresh by itself i have to press F5 to reload the page and see my new item in the list is there a way to make this automatically ? thanks in advance.

Dataset field list will not refresh

  
Using VS 2003, my dataset field list will NOT refresh when I hit the refresh button, and the field list shows NO fields!  If I switch the dataset type to TEXT and enter EXEC <storedprocname>, I get fields in the list, but when I switch the type to Stored Procedure (so it can accept parameters), the field list goes blank, and WILL NOT refresh, even though I can RUN the dataset and see the data returned by the stored proc.  How do I get my field list back, so that my report will compile and run correctly?  Or do I have to wait for SQL Server and Reporting Services 2008 SP3??

Getting SSRS Report DataSet Field list from C#

  

Hi All,

Scenario:

1. We have requirement where users can build there own SSRS Reports and integrate it with the existing system dynamically.

2. We have an Existing Application (Called APP1), our approach is user will build the report as per there requirement and from APP1 we have report configuration screen when user will select the report file to import to our system.

3. While doing importing, we have special requirement like

3.1 Retrieve the all fields from the Report DataSource and display to the user

3.2 User configures that what values they want to filter when the report is shown from the application. ex: employee information is      displayed in the report, DataSet query is "select empid,empname,..... * from employee" 

        3.3 from APP1 when user gives the report we have to dynamically load the report and get the fields from the dataset, so user can                configure like this, when the report is shown report must ask for parameter value for empid .

     &n

Refreshing list after insert item

  
Hi, im having problems in a custom list, i develop a custom form with sl and configure a content type to use this form as a newform item, when i clic on new item all its fina my custom form is opened and i can insert the item the thing is when i close this form the custom list behind dont show the new item i mean this list don refresh by itself i have to press F5 to reload the page and see my new item in the list is there a way to make this automatically ? thanks in advance.

Insert data from Sharepoint list to SQL

  

Hello experts,

I m using WSS3.0 and one of my requirements is to insert data into SQL from Sharepoint list (automated process) .

Can I use webservice / workflow / other tools.

Need suggestions or way to do this and if its possible.

Regards


Error "List does not exist" trying to insert pictures or links from Content Editor WebPart

  

I have put a Content Editor WebPart on a page and I'm trying to insert a picture from the Rich text editor, but whenever I try this I get this error:

List does not exist.

The page you selected contains a list that does not exist. It may have been deleted by another user.

This also happens when inserting links. When I use Fiddler I can see that the error occurs somewhere in AssetPortalBrowser.aspx and It's likely that the last location used to insert pictures and links no longer exist. So the question is how do I reset the location to point to a list on the current site, or any other list for that matter? I tried deleting and adding the WebPart on the page without any luck. Typing in a valid link in the link text box or setting the attribute "DefaultToLastUsedLocation" to "false" in the call to AssetPortalBrowser.aspx did not work either. I read the solution at http://mossipqueen.wordpress.com/2008/08/08/assetportalbrowser-error-list-does-not-exist/ (de- and re-activate Office SharePoint Server Publishing feature) but the feature is not activated on my web. Does anyone have a tip on what to do? This happens on a live SharePoint environment so there may be some restrictions as to what I can

Dropdown list value to insert into database

  

I have a dripdownlist

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="NameSource"
           DataTextField="Choice" DataValueField="Appliers" AutoPostBack="True">
    </asp:DropDownList>

I want to insert into database with the following code. I want the  Appliers instead of Choice to be inserted. Now this code insert the Choice field only. How should I modify this code ? Thanks

e.Command.Parameters("Name").Value = DropDownList1.SelectedValue

I tried SelectedItem it becomes error too... help...


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