DataSource Controls ::collection Which Contains The Rows Shown Below In "Expected Result List"?

Mar 2, 2010

I have following two collections,1. CategoryList, 2. ItemList. I need to get the collection which contains the rows shown in below in "Expected Result List".could you please provide me the LINQ query on collections to get this resulted List?


View 2 Replies

Similar Messages:

Iterating System.Collection.Generic.List.Add Does Not Work As Expected?

Mar 7, 2010

I was building an application for a project with .NET 3.5 and I noticed a weird behaviour of the List.Add method:

I have built my own class to organize data pulled from a database, and I use a while cycle to iterate through it.

However, when I List.Add(item), the whole content of the list is substituted with the last content pulled.

An example:

Suppose you have 3 users in a DB, each one identified with an ID and a username:

| ID | username |
| 1 | John |
| 2 | Fred |
| 3 | Paul |

and you have a "Users" class defined as

public class Users
private Int32 iD;
private String username;
public Int32 ID
get { return iD; }
set { iD = value; }
public String Username
get { return username; }
set { username = value; }

So you write this function:

[... SQL definitions - sdr is a SqlDataReader ...]
List<Users> userlist = new List<Users>();
if (sdr.HasRows) //There are users
Users user = new Users();
while (sdr.Read())
user.ID = sdr.GetInt32(0);
user.username = sdr.GetString(1);

What you expect (I expect) is userlist containing:

| ID | username |
| 1 | John |
| 2 | Fred |
| 3 | Paul |

What I actually get is, instead

| ID | username |
| 3 | Paul |
| 3 | Paul |
| 3 | Paul |

View 3 Replies

DataSource Controls :: Adding List Item Collection To Datatable?

Jul 7, 2010

I have a list item collection. How to add this list item collection to a datatable.

The list item collection has the following fields:

Student Name, Maths Mark
John 20
Mac 30
John 35

I want to create a html table from the data table, which is grouped on the Student Name field.

View 2 Replies

Data Controls :: Result In Pivot Table Shown To Gridview

Aug 21, 2012

I have a doubt and i am sending you the details  below, what i want to display in Gridview.

below i am describing the sql Table Structure.

Original Table Structure.

ID                Date             TimeLogged(Hrs)        UserName

1             10/8/2012               5.50                          Bubai
2             11/8/2012               2.30                          Bubai
3             10/8/2012               3.30                          Bhanu
4             11/8/2012               7.30                          Bhanu

I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table.

i want to show details in Gridview(Front End).

Date                    Bubai               Bhanu                    Total

10/8/2012              5.30                   3                         8. 30
11/8/2012              2.30                  7.30                       10

  Total                   8                    10.30                  18.30
I have a doubt and i am sending you the details below, what i want to display in Gridview. below i am describing the sql Table Structure.Original Table Structure.

ID Date TimeLogged(Hrs) UserName
1 10/8/2012 5.50 Bubai
2 11/8/2012 2.30 Bubai
3 10/8/2012 3.30 Bhanu
4 11/8/2012 7.30 Bhanu

I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table. i want to show details in Gridview(Front End).

Date Bubai Bhanu Total
10/8/2012 5.30 3 8. 30
11/8/2012 2.30 7.30 10

Total 8 10.30 18.30

View 1 Replies

How To Show No Record Found In GridView If Binded Datasource Is List Collection

Mar 11, 2011

I have a gridview in which dtasource binded is a List which returns class type. If no records in list, I want to display 'No records found' in GridView.


In else part, what code i have to write to get desired output?

View 3 Replies

Forms Data Controls :: List View Not Shown All String?

Nov 17, 2010

I am having an issue with Listview controll ,It does not show all string ( string could be 50 words), is there a way around this ,I also have ,one item of listview want to be displayed as hyperlinks .

simple code

this is a part of function that call the listview function


View 5 Replies

List Collection That Contain A List Of Dictionary Collection - How To Use It

Feb 1, 2011

List<Dictionary <string,object>> I am reading about the list and collection, If possible, what are the different ways that I can utilize the list of dictionary collections..... gives me different examples or areas where I can use it.

View 3 Replies

Custom Server Controls :: Extended GridView.Rows Collection Always = PageSize Even On Last Page?

Mar 22, 2010

Using VS2005, VB code behind,

I am extending the GridView control to include a custom pager for a custom paging scheme (only one page returned from the database at a time rather than all records). In my testing a discovered an issue - on my last page of data, the GridView's rows property always returns a collection of PageSize page, rather than the actual number of records on the page, with non-data fill records being empty rows.

For example, suppose I have 23 records in my database. Assuming a PageSize of 10, when I page to the last page of data the gridview it properly displays the last 3 recrods - but when I handle the GridView's CommandName="Select" event the GridView's Rows collection contains 10 records, the last seven of which are empty.

I set a break point in just before I call GridView.DataBind and verified that the DataTable used as the DataSource for the last page of data does in fact only contain the 3 expected records. But when I set a breakpoint on the Sub that handles the "Select" GridView command, the GridView.rows collection contains 10 records, the last 7 of which are empty.

This post[URL] and comments make note of the issue but the solution prescribed by the author does not seem to work.

Attached are some snippets of my extended GridView and the two methods from my page where I mentioned setting breakpoints above.

Snippets from my extended GrdiView




View 1 Replies

Should A Datalist Or Gridview Be Used For Multiple Rows With The Data As Shown

Nov 15, 2010

Sql select statement returns: customer_name, month, and count. There is one row per month as follows:

name-1, 01, count1

name-1, 02, count2

name-1, 03, count3

name-2, 01, count4


I want to be able to display as follows:





There will be some customer that don't have a month record. The display can show all 12 months.

My questions are: 1) Is datalist or gridview the best? 2) Where can I find examples of how to do this? 3) Also, an example of "no data" for a month. I'm a beginner, have been trying to research, but can't seem to get headed in the right direction.

View 2 Replies

DataSource Controls :: External Table Is Not In The Expected Format?

Jan 24, 2011

I'm developing an Web Application (C#) on a Windows 7 Enterprise (x64), with Office 2007 using Visual Web Developper 2010 Express. On that project that reads information from Excel files like so:

protected void Page_Load(object sender, EventArgs e)
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:1.xlsx;Extended Properties="Excel


View 2 Replies

DataSource Controls :: Update Query Via LINQ Not Working As Expected?

Jan 6, 2010

I have a form that gets populated by LINQ and I want to be able to update the database using that same form. The form is populated by grabbing a querystring (for example, "edit=10") and searching the primary key for that record. So far so good. I have a button attached to the function below which is supposed to use LINQ to update the database with data from the form. I get no errors, but for some reason, it is only updating one field (Last_Updated) instead of all of them.


View 7 Replies

Forms Data Controls :: DataSet And Looping Through Rows / Display Job Vacancies By The Result Of A DropDownList Value?

Jul 14, 2010

I am having a problem with this code, i had a post on this however this code is slightly different to that so i thought i would post a spearate thread.

Anyway, what i am trying to do is display job vacancies by the result of a DropDownList value. Now each job name has a description. The problem i am having is i need to display the results in this logic:

Job nameJob descriptionJob location. But what is happening is the job description (body) is repeating the more vacancies there are. This is the page:

If you select Deputy Nursery Manager from the DropDown and hit the Search button you will see the results. After listing the first two locations the description is repeated and then the 3rd location is shown after this. This is my code:


View 7 Replies

DataSource Controls :: How To Select Rows From A DataTable And Create A New ViewList With The Selected Rows Only, While ...

May 31, 2010

I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).

What is the best and fast way to do it?

I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?

I'm also looking for example in code how to select/delete rows from DataTable.

View 1 Replies

DataSource Controls :: Top 10 Rows As Well As Count Of All Rows From Linq To Sql Query

Jun 17, 2010


In above query I want to have top 10 rows as well as count of all rows.

View 3 Replies

Forms Data Controls :: GridView And ObjectDataSource - Column Is Not Shown In The GridView's List ?

Feb 9, 2011

I'm facing a wierd problem with GridView and ObjectDataSource. I bind GridView to my business objects via ObjectDataSource. Everything was working fine until I decided to add a new field in my buisness object and wanted to add a column to GridView to show it. Somehow that column is NOT shown in the GridView's list of available columns. I have tried refreshing schema, rebinding, etc. I'm using GridView inside a user control which is used as a web part. Does that make a difference ?

View 3 Replies

Web Forms :: Unable To Get The Expected Value From Drop Down List?

Mar 13, 2010

I have a drop down list that is populated with customer IDs. When I write to the db a value of 11 is written for the customer ID 13 when it is chosen from the drop down . I thought this was because I was using the SelectedIndex and how it is 0 based like an array. In the drop down list I choose 13. Id 2 is missing from the drop down list because that record was deleted. I thought these two things together explained the two digit discrepancy with the what i got when I used the Selected Index property. I then decided to use the SelectedValue property which should give me 13 when I choose 13 in the drop down list.

The same thing happens when I use the SelectedValue property. I used the SelectedValue property and chose 13 in the drop down list. This also gave me 11 as the value that was written to the db. This makes no sense to me. If I chose 13 in the drop down then 13 should have been written to the db when using the SelectedValue.

I'm using a Sql Data Source temporarily to populate this with the CustID.


View 2 Replies

DataSource Controls :: How To Get A Value From The InsertParameters Collection

Jan 21, 2010

I require to get the "CostPrice" value out of the sqldatasource parameter

so i may use later in my code?

i cant use the Amount value inserted because i have 4 statements in a conditional If Block and i want to get the selected statement.


= Amount

View 3 Replies

Way To Change The Interface Of The DropDownList's List To Shown As GridView

Mar 13, 2011

way to change the interface of the DropDownList's list to shown as GridView or for more I want to show 2 fields in the list with columns to be obvious in reading than concatenating together.Example: If I have 'Abd sadfs sd' + '123231434' 'sdfkd' + '234234'this what appear in the list but I want 2 columns like the GridView to

View 1 Replies

ADO.NET :: Update A Column For All Rows In A Collection Using Linq?

Jul 28, 2010

is there a way to update a column for all rows in a collection using linq like sql does it

eg. UPDATE myTable SET myColumn='newValue'

Also weighing options as to whether there is better performance using linq to sql for this or straight sql to DB via table adapters etc.

View 2 Replies

Merging Rows From Sql Query Result?

Sep 15, 2010

What would it be the simplest way to merge a result like this from a sql query to be displayed in an gridview?

NULL Tarde Fer W. Lunes
Mañana NULL Fer W. Lunes

I need the result to look like this

Mañana Tarde Fer W. Lunes

View 2 Replies

DataSource Controls :: Fetch Set Of Records From Table (Db) Into Collection?

Jul 12, 2010

Equivalent of recordset.Edit, Movefirst,NoMatch of vb6 in vb.Net? I want to fetch records from single table of database(Sql server 2005) and collect in collections. How can we do that by dataset and dataadapter ? We want to fetch not to display.

View 1 Replies

DataSource Controls :: Pass Collection To A Sql Stored Procedure?

Mar 9, 2010

i have a listview control with two textboxes in each row. i am to fill those and save their values in one/more than one database tables using a stored procedure.

i currently create a comma-separated string (using a string builder) of all the values, and then pass it as a parameter to the SP.

in the SP i extract the values, and put them into my tables.

View 4 Replies

DataSource Controls :: Passing Object To ObjectDataSource.SelectParameters Collection

Mar 30, 2010

I'm trying to use an ObjectDataSource's SelectMethod() to retrieve a result set from a sql server database to populate a data table with various stored procs that have any given number of parameters. My approach is to pass an object which contains the stored proc name and information about its parameters into the SelectMethod(). My issue is that I don't know how to actually set the default value. Here is the code I have so far:

ObjectDataSource1.DataObjectTypeName = "WebApplication1.Children";
ObjectDataSource1.TypeName = "WebApplication1.Children";
ObjectDataSource1.SelectMethod = "Select";

Parameter odsParameter = new Parameter() { Name = "storedProc", Type = TypeCode.Object };

// How do you set the default value to reference an object?


namespace WebApplication1
public class Children
public DataTable Select(object storedProc)
// do stuff here and get db values.

The default value of a Parameter object is a string type. Does anyone know how to set the default value with an object or how I can pass an object into the SelectMethod?

View 2 Replies

DataSource Controls :: LINQ Load Collection To Populate Dropdownlist?

Apr 5, 2010

I have a partial class extending my Entity Model. I'd like to write a method that returns a collection of types from my entity framework model. For example, I'd like to get all the states to populate a drop down list. So I've written a method called getallstates(), similar to the example below:


I tried returning a list of Objects, and a list of states to my calling method to be used to bind to a drop down list. However I get an error that:

Server Error in Application. Unable to cast object of type 'System.Data.Objects.ObjectQuery to type 'System.Collections.Generic.List`1[System.Object]'.

What should my return type be for this function?

View 2 Replies

DataSource Controls :: How To Bring The Particular Result Through Queries

Feb 11, 2010


It may comes any order but (cbhak) is constant. i need to bring this in query, i dont want to use any funtionHow can i acheive this result

View 2 Replies

Copyrights 2005-15, All rights reserved