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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

how to create list order and unorder list using data table(asp.net,or jquery)

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :ASP.Net

1 My DataTable Return following Data

Acct    Books    Annual
Acct    Books    Monthly
Acct    Tax    Income Tax
Admin    GH    Eqpt
Admin    Offc    Eqpt
Admin    Offc    Misc
Admin    Offc    Eqpt
BPO    DE    DE.US
Corp    Comp    Insurance
Corp    Legal    Court
Corp    Legal    Court

but i require in this format

  Income Tax
<ul>   GH 
<li>   Eqpt

<ul> Offc 

View Complete Post

More Related Resource Links

how to create a list order and unorder using database

how to create a list order and unorder using database

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

how to create a List order and unourder a simple Sql Query

A Simple Query Pass to connection String 1 My Query is SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.COFROM V_HIERARCHY1 a   2,My Data is HD    HEAD    SH    SUBHEAD    TRK    TRACK    TGT    TARGET    PDC    DT_RELEASE    STATUS    COHR    HR    Rec    Records    Leave    Leave Records    HRL.0002    Quarterly Review    01.07.2010    04.07.2010    Planned    EdlinkHR    HR1    DB    Database    SAL    Salary    DDS.0001    Calculation of Monthly salary    08.08.2010    09.08.2010    WIP    EdlinkHR    HR    Rec    Records    Ind    Induction Records    HRI.0001    Completion of dossiers.    08.07.2010    10.07.2010    WIP    EdlinkHR    HR  

Create dynamic dropdown list when we export data to excel using SSRS.


Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?



Create Data List at Run Time


hi friends,

I need ur little help, i have a dataset filled from the DB,

let assume the data in the dataset is: -

Inderjeet          Name          Jagjeet          Father's Name          BE.           Qualification.          and so on at infinite level. set by the user.

now i wana bind my data in the Data list:-

bind like as:-

header template would be bind with the data comming at 1 3 5.... and so on position.

I tem template would be bind with data at 0 2 4..... and so on position, Here a point need to conern is that, i dont know the no of coulmns in the data set, so i cant put the label in the header template and item template, all would be set at the run time according the data into the dataset.

the data list structure should be lke above:-




<th>Father's Name</th>




Search data from sharepoint list and populate repeating table (Seach text should be entre in first f


Hi All,

I am newbie to infopath.

I have assignment to search data from sharepoint list and display it to repeating table. Below is the case in detail.

i. User enter search text in first textbox of repeating table.

ii. After text enter you will Enter or click tab button.

iii. As user press Tab /Enter, the other textboxes of repeating table will populate with data automatically.

iv. If searched data rows are more then one, then dynamically add new row's in repeating table and  show searched data.

I am working at offical assignment and it's deadline is very tough. i had made extensive search at google and msdn forum but unable to accomplish. I would appreciate and thanks is some provide me solution in form to a small infopath application and code snippet.




How to create custom control in .net which can retrive data from sharepoint list and redirect to sit


Hi help me!

I am strugling this problem!

My requirement is I need to create a custom control which need to retrive data from sharepoint list, The list contain some sites information like Title, url, Scope my requirement is i need to display sites Title in my custom control and when i click on title (site name) in custom control it need to be redirect to that site and whenever list data updated automaticaly custom control data also need to be apdated automatically .

problem with data list when data is retrieved from table???



I have a datalist binded to an object data source which has a method



In the  data list Item template, I have put  a div with a heading that will not show if there is no language by that personId  in the database table.

If there  is data them problem is the datalist repeates the heading for each language instead of showing  just the heading above and the row of languages below. I have included all my code below if somebody could advise what is wrong. thank you.


Method in DAL

SELECT        PersonId, LanguageId,
 (SELECT LanguageName FROM Language WHERE (LanguageId = PersonLanguage.LanguageId)) AS LanguageName
FROM            PersonLanguage
WHERE        (PersonId = @PersonId)



 <asp:DataList ID="DataList3" runat="server" DataKeyField="ModelId"
        DataSourceID="ObjectDataSource4" RepeatDirection="Horizontal" >
        <div id="Div03"&n

How to use Designer to create a WF to collect data and update item in the list



I’m trying to create a workflow in SharePoint Designer 2007 to finish the item in the list. In the list, I setup 10 fields (Name, Address, Phone#....), and in the workflow, I set it to start automatically when a new item added in the list (I can add a new Name in the list to start the workflow).


In the step1:

The Conditions is: “If Address is empty”.

The Actions is: “Collect all data from lw1990 (Output to Variable: collect1)


At this point, I don’t know how to update the current item in the list with the data that just collected from user in Variable:

.How to Create Views Displaying Cross-Web and Joined List Data



This is said to be available option, and was planned for the series. We unfortunately didn't see anything after part 3, and I am asking part 9 topic!

Any help will be appreciated. I want to show a list frmo root site in sub-web.


Getting all data from a repeater table in Infopath Form to the List Published.


I have a infopath form and inside it there is a Repeater Table.

When i publish then it asks for the First Row of the repeated table only. Is there a way we can have all the Row Datas availabe to the list.

I want my users to get that all data in the list not by opening the Form. But the List shows data from the First Row Only.

I am trying to send those data through a workflow in SPD.

Thanks in Advance for any kind of solution.


Accessing Oracle Table data and updating using SharePoint 2010 List



We are trying to access Oracle database table through SharePoint 2010 List. The functionality required is, the user should be able to read the data from the Oracle table in to the SharePoint 2010 List and should also be allowed to update the list and in turn the data should be updated back in to the oracle table.

Over and above any changes made to the oracle table by users, should be updated in the sharepoint 2010 list. Which means the users require a two synchronisation from SharePoint 2010 List to Oracle table and vice versa.

let us know if anyone has worked on this before.


please help create report using sharpeoint list as data source


the dilema is I can use standalone report builder 3.0 to create report from sharepoint list data source. But I cannot upload any report(not just sharepoint source) from report builder 3.0(standalone) to report server

I can create report model in sql BIDS for report server and using builting report builder 1.0 to create a report, but the data provider in BIDS only shows SQLclient and Oracleclient

any idea?

Only first row of a repeating table is being populated from a sharepoint list secondary data source


I have a reapeating table in maind atat source and I am trying to  populate it from values in a secondary data source, but when I am trying to do that it is only populating first row, leaving all other rows blank.


How to get this working..

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?

Disable filtering on a Dynamic Data list view.


I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.

This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view

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