The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
31 views

Create a SharePoint List from Datatable

How we can create a SharePoint List from Data-table.
0
votes
0answers
37 views

Get Lookup field ID from DataTable

I have this code : SPListItemCollection CatList = LinkList.GetItems(query); SPListItem test = CatList .GetItemById(1); SPFieldLookupValue tmp = new SPFieldLookupValue(test["Category"].ToString()); ...
0
votes
1answer
28 views

Data Table distinct value

dtnew1.DefaultView.Sort = "Modified DESC"; DataTable unique = dtnew1.DefaultView.ToTable(); In this code's "unique" table I'm getting all values but post title value is getting repeated. I need a ...
1
vote
0answers
56 views

How can I display user picture from sharepoint in datatables

Sorry if this is stupid easy but I'm trying to display user pictures from sharepoint in datatables. I can see the link in JSON data coming back from the ajax query in the "Picture" field so I added: ...
0
votes
2answers
34 views

How retrieve custom fields only when using SPListItemCollection?

Hi with following code I am retrieving a DataTable from a List: using (SPSite site = new SPSite("http:...")) { using(SPWeb web = site.OpenWeb()) { ...
0
votes
0answers
46 views

Failed Timer Job : A column named '[column name]' already belongs to this DataTable

I have a timer job, that runs Hourly and starting every hour between 0 minutes past the hour and no later than 0 minutes past the hour. So that means, it will run every hour and exactly on minute of 0 ...
0
votes
2answers
341 views

SharePoint list as data source for jQuery DataTables plugin

I trying to create a table using a SharePoint list as source. I followed this tutorial and it worked perfectly. But this method would not work if you need to reload the data using, let's say a drop ...
0
votes
1answer
43 views

What's wrong with my Datatable with SharePoint 2010

I would like to display the first line in the custom list as an image below to textbox and gridview. However, the textbox got the last value, while the gridview got the first one. Summary: The frist ...
0
votes
2answers
135 views

Use Google Visualization with Datatables plugin and which get data from REST

I have this code that get the data from SharePoint using ajax, and the datatable plugin creates the table. function LoadAIP(state){ var call = $.ajax({ ...
2
votes
2answers
363 views

Convert DataTable to SPListItemCollection

Consider the following code:- SPListItemCollection collListItems = emp_info.GetItems(query); dt = collListItems.GetDataTable(); Now i want to convert the dt object back to SPListItemCollection ...
0
votes
0answers
36 views

Edit row information using BDC

I want to make simple database table insert/edit/delete using BDC. What I have tried: I have created External Content type mapped to database table and using external content type created list. But ...
0
votes
1answer
331 views

How to add link to Title field when list data is fetched using REST API and rendered through Datatable.js

<table width="100%" cellpadding="0" cellspacing="0" border="0" class="display" id="example"> <thead> <tr> <th>Title</th> <th>Id</th> </tr> ...
0
votes
1answer
492 views

SPGridView Filtering & Sorting With DataTable

I need a help filtering and sorting SPGridView based on DataTable, from the articles I've seen online, they use ObjectDataSource and so on, but I have the Grid binded directly to DataTable, is there ...
0
votes
1answer
42 views

Datatables not working when placed in one single webpart?

We have added two datatables in one single webpart. And when one of the datatable is empty the search function does not work for the other one which has data. Why does that happen? Or how can we ...
2
votes
1answer
280 views

How to query Oracle db to display table/view?

Using SharePoint 2010, how can you connect to Oracle db to query a view and display the table in SharePoint?
0
votes
1answer
75 views

Recommendations, display fields from list in fluid free form

I have a table to store a question/answer checklist. There are thirty five questions, each with a "Yes/No" and then a "Please Elaborate" for each field for when the answer is no that is a multiline ...
1
vote
1answer
101 views

Duplicated datatable showed to all users

I'm trying to code a visual Webpart in sharepoint2010 where users can fill out a form to order meals, you can order meals for several persons at once. The form fills a static datatable which in turn ...
1
vote
2answers
1k views

GetDataTable from SPListItemCollection

My question is regarding the use of DataTable vs ListItemCollection. Basically I have a small solution, where I have to loop through the items in the list to verify if the items already exists or not. ...
1
vote
0answers
58 views

Display and update data column of type time in sharepoint

I have an sql server data table with a column of type time(0). I need to display columns of this table on a sharepoint page, including the time-column. Users must be able to read and update rows. What ...
2
votes
2answers
287 views

Unwanted characters appearing before author in search results

When running my SPSiteDataQuery (code below), I appear to be getting 1;# before the actual Author Name. Can anyone point me in the right direction towards an explanation to this please? ...
3
votes
1answer
743 views

Using GetDataTable() hoses my SPFieldLookValueCollection!

I am trying to use GetDataTable on an SPListItemCollection. I have run into a situation where my SPFieldLookupValueCollections in this list are being converted to a string when they are stored in the ...