C# - How To Convert Query To List Without Loop Foreach

Feb 14, 2011

List<string> IDs = new List<string>();
XDocument doc = XDocument.Parse(xmlFile);
var query = from c in doc.Root.Elements("a").Elements("b")
select new { ID = c.Element("val").Value};

How can I convert query to List without loop foreach ?

View 2 Replies


Similar Messages:

C# - Convert Foreach Loop To Linq (in Datagridview)

Jul 21, 2010

foreach (GridViewRow row in gridView.Rows)
{ // Access the CheckBox
CheckBox cb = (CheckBox)row.FindControl("SuburbSelector");[code]....

I tried the following and got error

Linq:

var Str = SuburbGridView.Rows.Cast<GridViewRow>().Where(r=>(CheckBox)r.FindControl("SuburbSelector")==checked);

Error:

Delegate 'System.Func < System.Web.UI.WebControls.GridViewRow,int,bool>' does not take 1 arguments

View 3 Replies

C# - Using A Variable From A Foreach Loop?

Dec 6, 2010

i'd like to be able to check to see if an item with the same id has already been placed in the database, if so to then update the quantity for that item, however due to the fact I have this in a foreach loop it will update the quantity for each item.

When I placed the Command outside of the loop I am unable to use 'ItemID' as it's not in context, is there anyway I can get around this?

foreach (UserItem ItemID in (List<UserItem>)Session["UserSession"])
{
ConclusionPage.InsertCommand = "IF EXISTS (SELECT ItemID FROM tblUserItems WHERE UserID='@CurrentUser' AND ItemID='@ItemID') UPDATE tblUserItems SET Quantity = Quantity+1 WHERE (UserID = '@CurrentUser') AND (ItemID = '@ItemID')";
ConclusionPage.Insert();
}

View 4 Replies

C# - Foreach Not Initialing The Loop Variable?

Mar 9, 2010

I'm using a foreach to loop through an IList of objects in a Partial View in ASP.NET MVC.

Here's the entire code (Message is one of my classes from the Model).

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<IList<Message>>" %>
<%
if (ViewData.Model.Count > 0)
{
foreach (MvcTest.Models.Message m in ViewData.Model)
{
Response.Write(m.RenderHtml());
}
}

ie explicitly declaring a variable for the IList rather than just using the (strongly-typed) Model, and it works fine.

View 1 Replies

C# - Passing In A Value To A Usercontrol Through A Foreach Loop?

Dec 21, 2010

in my asp.net mark up I have a foreach loop that iterates through a simple list. In this foreach loop I am adding a new user control and attempting to pass in the value from the loop. However, this value just wont budge and get inside that damn control!

<%foreach (userInfo i in this.items)
{ %>
<uc1:ItemControl ID="ItemControl" runat="server" UserID='<%#Eval("userID") %>'/>
<%} %>

userID is a public property in the control, when it goes to set, the value is just literally :

<%#Eval("userID") %>. I've tried #Bind and =Value but nothing seems to work.

View 2 Replies

MVC :: Update Data From Foreach Loop?

Feb 21, 2011

I am trying to do some basic. Display customer testimonials in a table using foreach loop and have a checkbox on each row. Once checked, update the table.

I have a stored procedure of complex type in my entity framework. Here is my View.

[Code]....

Here is my model

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

View 5 Replies

Threads Inside A Foreach Loop In C#?

Jan 5, 2010

I had the following code to send different mails to differnt users in my asp.net web application

foreach (DataRow dataRow in dataTable.Rows)
{
sendMails();

[code]...

View 8 Replies

C# - Optimize Code - Linq And Foreach Loop 15k Records?

Sep 6, 2010

this is my code

[code]....

basically, the InstellingGegevens table gest filled in by some procedure from another server.
the thing i then need to do is check if there are new records in this table, and fill in the new ones in Instellingens.

this code runs for like 4 minutes on 15k records. how do I optimize it? or is the only way a Stored Procedure?

this code runs in a timer, running every 6h. IF a stored procedure is best, how to I use that in a timer?

[code]....

View 3 Replies

Web Forms :: Setting ImageButton CommandArgument From Foreach Loop?

Mar 10, 2010

I have a ImageButton in a for loop

[Code]....

How do I set the CommandArgument? The above code does not work and how to do this.

View 1 Replies

State Management :: Can Run A Loop Like Foreach On All Of Users Sessions

Apr 23, 2010

I am saving for each user a session with information about his current page viewing.

Each time the user is moving to a new page, I am updating the session with the new page he is right now.

Now, my question is if I can make any loop over all of my users session and answer a question like: How many users are now on page "2.aspx" for example?

View 2 Replies

DataSource Controls :: DataTable Foreach Loop - Continue To Next Row?

Mar 11, 2011

How can I continue to the next row in the foreach loop below.

[code]....

View 9 Replies

Web Forms :: How To Get Array Elements By ForEach Loop With Counter

Apr 27, 2016

I want to get Array Elements by ForEach loop with Counter .. 

whislist = dsddsds.Tables[0].Rows[0]["wishtlist_clg"].ToString().Split(',');
int i = 0;
foreach (string id in whislist) {
if (i != 0) {
tarsk.Value="1";
} else {
tarsk.Value="0";
}
whislist =525,1315,1331;

TARSK is an hidden field....

I want if whitelist is not in blank then 1 not equal to 0 is True other false but yet false condition is fire....

View 1 Replies

Configuration :: Adding Values To A Config File With Foreach Loop From Sql Database?

Sep 2, 2010

I have added the below tag in my web.config file;

<RewriterConfig configSource="configuration
ewriter.config"/>

It gets the rewrite vlues from another config file. I need to update this rewriter.config file dynamically.

I need to gets values inside it from sql databse. here is the look of the file

<?xml version="1.0"?>

View 3 Replies

MVC :: SQL Lookup In The Controller Put That Data In A DataTable Then Run A Foreach Loop On The Table To Display This On The View?

May 5, 2010

as a php developer ive been told to go the MVC route which ive been trying since yesterday. Im using visual web delveloper 2010 express and im using the MVC template project.Ive basically got a news table in MSSQL Express, in there are these fields ID,(Title,Body,PostedOn,PostedBy) all i wanna do is loop through them to put them on the view.Im after a nudge in the right direction, I want to be able to do a SQL lookup in the controller put that data in a DataTable then run a foreach loop on the table to display this on the view. The problem im getting is I know youre not suppsed to put any HTML in the controller and I cant pass the datatable to the view to do the loop in the view.. so where/how do I do the loop.

View 2 Replies

ADO.NET :: How To Convert DataTable Objects To IList Without Using For Each Loop

Oct 4, 2010

[Code]....

Can we implement through LINQ ?

View 2 Replies

DataSource Controls :: How To Convert Sql Query Into Linq Query

Mar 10, 2010

select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid

View 5 Replies

Databases :: Oracle Query Convert To Sql Server Query

Sep 3, 2010

I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query

SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2

View 1 Replies

Way To Get All User Result From SQL Query Using For Loop?

Nov 5, 2011

I would like to get the list of users (from db) who meets my SQL select statement, and send email for each of them.my current looks like this

Code:

Dim constguser As New SqlConnection
constguser.ConnectionString = ConfigurationManager.ConnectionStrings("xxxxxxxx").ToString
Dim email1D, email2D, userNickName, userName, rc As String
constguser.Open()

[code]....

If i run this code its only going to get the name and email of the first result found. I was wondering if there is a faster way to get all user result from the sql query, myb using a for loop?

View 7 Replies

.net Mvc Converting List<> So To Loop?

Dec 9, 2010

I am using this

List<JobsMeta> JobsMeta= _db.JobsMetas.Where(m => m.int_OrganizationId == null || m.int_OrganizationId == OrganizationInfo.OrganizationId).OrderBy(m => m.int_SortId).ToList();
ViewData["JobMeta"] = JobsMeta;

now using the view i want to loop through ViewData["JobMeta"]

<% foreach (var JobsMeta in ViewData["JobMeta"]))

View 1 Replies

Loop Through A Checkbox List?

Jul 15, 2010

I am building a checkbox lists:

<asp:CheckBoxList ID="CheckBoxes" DataTextField="Value" DataValueField="Key" runat="server"></asp:CheckBoxList>

And trying to get the value's of the selected items:

List<Guid> things = new List<Guid>();
foreach (ListItem item in this.CheckBoxes.Items)
{
if (item.Selected)
things.Add(item.Value);
}
}

I get the errror

"The best overloaded method match for 'System.Collections.Generic.List.Add(System.Guid)' has some invalid arguments "

View 3 Replies

Create Object For List In Or Out Of While Loop?

May 28, 2010

Create object for list in or out of while loop?

Code:

[code]....

My question is, is there any benefit to instantiating a new userDetails object in every loop, or can this be created outside the loop and title, forename and surname just written over with every pass of the loop?

View 3 Replies

C# - Fill Listbox From A List Without Any Loop?

Sep 30, 2010

I have one Listbox and a List of data

I want to bind the list to listbox.

View 2 Replies

Web Forms :: How To Loop Through Dropdown List Items

May 12, 2010

I want to loop thru dropdown list and check the individual list item text using C#, let me know what is the best way to do this?

View 4 Replies

C# - Populating List Within A For Each Loop After Pattern Matching

Jan 15, 2010

I am trying to assign values I've gathered from a JSON feed to my own type, a class in which I have defined certain fields (properties) to put the JSON elements into, plus elements that are derived from a RegEx pattern matching process. This will then allow me to access the object using LINQ, as I am using a List to hold my objects. There is a foreach loop in my code that loops for each match that my RegEx method finds. I am only interested in the parts of the JSON feed where there is a match. So my own defined class is as such:

//simple field definition class
public class TwitterCollection
{
public string origURL { get; set; }
public string txtDesc { get; set; }
public string imgURL { get; set; }
public string userName { get; set; }
public string createdAt { get; set; }
}

And then I want to populate List in the RegEx Matches loop:

foreach (Match match in matches)
{
GroupCollection groups = match.Groups;
var tc = new List<TwitterCollection>()
{
origURL = groups[0].Value.ToString(),
txtDesc = res.text,
imgUrl = res.profile_image_url,
userName = res.from_user_id,
createdAt = res.created_at,
};
}

The code will then go on to extract and sort the results via Linq to Objects. But compiler won't actually let me create my var tc = new List<TwitterCollection>() because: 'System.Collections.Generic.List' does not contain a definition for 'origURL' ... even though I have defined it. It does not flag an error if I simply write new TwitterCollection but then how do I refer to this in my Linq expression later on??

View 3 Replies

Web Forms :: Use Loop To Controll The Value In Dropdown List?

Sep 7, 2010

I have dropdown list I want to use the arror to click and control and select the value in the dropdown box , the first click select item1 .... How can I do that?

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved