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?
[code]...
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);
userlist.Add(user);
}
}
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 |
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.
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
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.
[code]...
In else part, what code i have to write to get desired output?
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
[Code]....
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 RepliesUsing 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
[Code]....
MyReport.aspx.vb:
[Code]....
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
etc
I want to be able to display as follows:
Customer----Jan-------Feb-------Mar
Name-1______count1____count2____count3
Name-2______count4
etc.
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.
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
[code]...
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.
[Code]....
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:
http://kidsunlimited.co.uk/vacancies_test_two.aspx
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:
[Code]....
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.
[Code]....
In above query I want to have top 10 rows as well as count of all rows.
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 RepliesI 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.
[Code]....
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.
InvoicesDataSource.InsertParameters("CostPrice").DefaultValue
= Amount
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 Repliesis 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.
What would it be the simplest way to merge a result like this from a sql query to be displayed in an asp.net 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
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 Repliesi 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.
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?
ObjectDataSource1.SelectParameters.Add(odsParameter);
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?
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:
[Code]....
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?
(ie.)C-Chennai
B-Bombay
-Hydrabad
A-Andhra
K-Karnataka
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