For Loop In C# Not Looping

Feb 23, 2011

I have an issue with a Loop that doesn't actually loop. I've posted a simplified version of my code below. Basically, using the NPOI excel library, I have an excel file with data on the first and second sheet, so I need to do a loop to get through both sheets. Below is what I have done so far, however this only works through the first sheet and then exits. It fails to increment the variable w. As you can see, there are other loops implemented in this code which function fine so I don't get it.It's been a very long day and perhaps I'm missing something very simple. I could have it placed wrong or something. If anyone else can spot what I might be doing wrong I'd be very grateful :)

public class SalesFileProcessor : ISalesProcessor
{
public List<FTPSalesRow> ProcessSalesFile(string filename)

[code]...

View 4 Replies


Similar Messages:

Delaring A String Thats Within A Loop Within Another Loop

Jan 14, 2010

Im stuck with declaring a string which is in a loop within another loop.

Dim CompanyDetails As String = ""
Dim CompanyRow As DataRow
For Each CompanyRow In newdt.Rows
CompanyDetails += CompanyRow(1) & " " & CompanyRow(0) & "<br/>"...

How can I get this to see the GetInfo as declared..... since its in a loop within a loop?

View 9 Replies

Looping Through Each CheckBoxList?

Mar 18, 2011

For the code below how do I loop though each check box - I need to add a string to a variable whereever the box is checked.

[Code]....

View 5 Replies

Looping Through A New Record?

Apr 13, 2010

I've worked with .Net before and now I'm back again and ran into an issues hoping soem one can assist. Here's my scenario, I have a form in which wirtes a new records to theDB jsut fine but I would like to email or loop thru the records to create an email with new record. The email par works fine to but just need to loop thru the records. Here's my code and hoping someone can email me out!

Dim AddRec As SqlDataSource =
New SqlDataSource()
AddRec.ConnectionString = ConfigurationManager.ConnectionStrings

[code]...

View 2 Replies

ADO.NET :: Looping Through DataSet In C#?

Aug 11, 2010

I have the following line of C# code that successfully returns the results of a stored procudure via a DAL:
spParamGetGamesTableAdapter spGG10 = new spParamGetGamesTableAdapter();I can bind spGG10 to a DataGrid and see the stored procedure query results, so I know everything is good so far.I want to loop through the spGG10 (DataSet table?) and output each row on a row-by-row basis using a Literal Control. I think I know how do the output part,How do I access the data in spGG10 and loop through its records? (Also, I am not exactly sure what kind of object spGG10 really is. Is it a table?)

View 7 Replies

Looping In SQL Server Query

Aug 4, 2010

consider the follwing table, this table actually shows which id was given a new id

i.e 11 was assigned 13

again 13 was assigned 15

15 was reassigned 17....and so on actually 11,13,15,17,19 represent the same user (hope u understood)

customerId rejoiningId

11 13

13 15

15 17

20 21

17 19

48 50

21 25
i need to loop through all the rows and find the relation that which all ids are interlinked

say the user enters the rejoining id -13,hence the result should come out to be as 11,13,15,17,19


if user enters 21result should be 20,21,25

it takes a bit of looping statements in query that i couldnt figure out

View 7 Replies

How To Get All The Values In A Listbox When Looping Through Them

Jan 11, 2010

I'm currently trying to move through all the values added to a listbox by the user, however, I want to retrieve the actual value of each item in the listbox and not the text.

I've gotten so far with the code below, but that only gets the text and not the value.

[code]....

How would I go about getting the value for each item in the collection?

View 3 Replies

Looping Through Nested Recordsets?

Apr 20, 2010

I'm still new to ASP.NET, and I'm trying to rewrite a simple booking/reservation system I did in ASP, but I'm struggling to find an equivalent technique in ASP.NET.

Basically, it a nested recordset. The first recordset returns weeks from a calendar. for each record returned, a basic table row is created, showing the dates & prices then the start of the week is used to query a bookings table to see if there are any bookings for that week. If there are bookings, the <tr> & <td> tags are modified to change to colour & wording to reflect the bookings.

an extract of the code is as follows:

[Code].....

View 1 Replies

Looping Through Gridview Using Jquery?

Jan 23, 2011

i am trying to loop through a gridview using jquery, the code i am using is

$('#<%=gridview1.clientid%> tbody tr').not(':first,:last')
.each(function(){
gridrows ++;
});

i would like to eliminate the first and last rows which are obviously the header and footer , i tried this code but seems that it is not working, it is returning the count of gridview rows.

View 2 Replies

Web Forms :: Looping A Value From A Text Box?

Sep 24, 2010

I have several controls on a web form Dropdown list, text boxes etc. Which are going to be used as part of a stored procedure to enter data in several SQL Tables. One of the boxes is called the number of items now depending on the number inputted here is how many items to be inserted therefore I need to loop so my stored procedure to run again

Not sure if this is relevant or just me confusing myself and making this more complex than it really is but I have several data readers running before I run my stored procedure to help get the data I need for it.

Here is the SQL for it and the answer goes in label1 so then further down when the insert stored procedure runs it checks the value on label1 to run an if statement so I will need this procedure to run as well in the loop.

[Code]....

View 1 Replies

Looping Through File Directory?

Nov 16, 2010

I have the following values: customerNumber, ProductNumber, PartNumber.There exists a directory structure on a server like follows (the bold italic text is the actual value)://myServerName/Parts/Images/CustomerNumber/ProductNumber/PartNumberSo the part of the file directory that is constant is://myServerName/Parts/Images/but the file structure CustomerNumber/ProductNumber/PartNumber will vary, displaying the actual number valuesEX: //myServerName/Parts/Images/11111/22334/007so I need some code that will loop through the file Directory structure under "Images" and will get the string values of each subdirectory. This will be used to find the image to be used for the specific CustomerNumber, ProductNumber and PartNumber.Does anyone have any good sample code where you have done this before?

View 3 Replies

Looping Performance With Conditional C#?

Jan 6, 2011

Which of these will perform better if we assume that the IF block in #1 will be executed more and less in #2

foreach()
{
if
{
block here
}
}
or
foreach()
{
if !( )
continue
}

I've structured #2 to take the if conditional less often.

View 4 Replies

C# - Change The Value Of Dictionary During Looping?

Dec 8, 2010

How do I modify a value in Dictionary? I want to reassign a value to a value in my dictionary while looping on my dictionary like this:

for (int i = 0; i < dtParams.Count; i++)
{
dtParams.Values.ElementAt(i).Replace("'", "''");
}

where dtParams is my Dictionary

I want to do some thing like this:

string a = "car";
a = a.Replace("r","t");

View 4 Replies

DataSource Controls :: Looping Through The Sql Table?

Jul 7, 2010

How to loop through the table get only paticular records based on the particular value and store it in a datatable.

for example, i've a table with two columns, Store name and Store number. For a single store name it can have mulitple store number like
[store name ] [store number]
a1 10
b1 12
a1 15
a1 21
b1 11
b1 22
a1 25
etc....
How to loop through the table and get all the records/ rows of a paticular store name and store it in a datatable.

View 7 Replies

Radiobuttonlist - Looping Through Controls In A Table

Mar 21, 2010

i have a table which contains a bunch of dynamically created radio button lists, im trying to write code which will loop through each one of the radio button list and get the text value of the selected item. i have the following code

foreach ( Control ctrl in Table1.Controls)
{
if (ctrl is RadioButtonList)
{
//get the text value of the selected radio button
}
}
but i am stuck on how i can get the value of the selected item for that given control.

View 1 Replies

SQL Server :: SQL - Looping Through Fields In Each Record.?

Jan 14, 2011

to loop through each field in a record to test for a value and then set a flag at the end of each record if an instance of this value occurs in any fields?I have a table where some fields values are have a *c* at the beginning of the text eg "*c* value" . What I would like to do is run a select query off the table and at the end of each record have a field called "Change Flag" and a value of "Changed" or "No Change" depending if a *c* has been encountered.

There are a number of tables to run this against all with differening numbers of fields/

View 7 Replies

ADO.NET :: How To Copy A Datatable Across Servers Without Looping

Dec 27, 2010

i have searched quite a bit on this one and can't seem to find exactly what I am looking for.

I think my first problem is this: How would I bring back a DataTable FOR copying? I know I would need:

Dim dt as Datatable

But then how do I get the Original Datatable in there? I think that once I have that part, I can just make a connection to my new DB inside a copy subroutine (using the .Copy method) and be done with it. That part I have the code pretty much done for, I think.

View 7 Replies

Web Forms :: Looping Through Values Of DataRow?

Mar 19, 2010

im trying to retrive all the values in the datatable

but i keep getting only the first value

since i just finished learning C# i have no idea how to solve that

here the code i use let me know what am i missing

[Code]....

View 17 Replies

Looping Through Parent Child Combination Xml Using C#?

Dec 7, 2010

I am new to xml, i want to looping through the below xml and save the records in the database. the below xml is parent child combination, parts as to be saved under respective parents. if the source field is M then there will be child item for that.

<PARENT>
<COMPONENT>
<part>test1</part><source>M</source><ParentPart>parent</ParentPart>

[code]...

View 1 Replies

SQL Server :: Looping Through The Cursor Parameters?

Mar 25, 2011

I'm using cursor to select a list of records in sql server 2005

There are 80+ columns in the result, the cursor parameters named as @pn1,@pn2,@pn3... @pn12. @pid1,@pid2,@pid3.... @pid12

[Code]....

The above code rotates the parameter ('@pn' + loop id) to get the cursor parameter value.

View 1 Replies

Web Forms :: Looping Through Calendar Cells?

Jun 15, 2010

I've a asp:Calendar control and to each date, dynamically when the calendar renders i'm adding a checkbox next to it.

The user can check and uncheck the checkbox , based on that i need to send the checked dates to my database.

Now, my problem is that i have no idea what to use to collect the dates list to send it to database.

i am giving the code which i have used in the Calendar Dayrender Event

protected void LunchCalendar_DayRender(object sender, DayRenderEventArgs e)
{
e.Cell.Text = "";
CheckBox c = new CheckBox();
e.Cell.Controls.Add(c);
c.Text = e.Day.DayNumberText;
if (e.Day.IsOtherMonth)
{
e.Cell.Text = null;
}
if (e.Day.IsWeekend)
{
c.Checked = true;
c.Enabled = false;
}
}

View 2 Replies

Getting Strings From Resx Into An Array Without Looping - C#.net?

Jul 20, 2010

I want to read all the strings from a resx file and load it into an array without looping. I'm working in an asp.net web application and i'm using C#. How can i get the strings?

View 1 Replies

JQuery :: Looping Through A Datagrid Coloum?

Mar 17, 2011

I have a datagrid with 5 columns, the fourth column consists of dropdownlists in each row.


1.) On the click of a button outside the datagrid, i have to loop inthe column and hide all the dropdownlists

2.) On the click of a button outside the datagrid, i have to select particular value in the dropdownlist for all the rows.(same value for all)

View 4 Replies

VS 2010 - Looping Through Databind Controls?

Oct 12, 2012

I'm re-writing a VS 2003 application in VS 2010. One of the pages loads really slow due to a section containing a datalist with multiple checkbox list and dropdown list. Most of the time used on nested for loops to check if a datalist checkbox should be checked, if the checkbox is checked, then select the appropriate dropdown list option in the datalist. Is there a quicker way of doing this sort of thing in VS 2010? Better controls for this? Would Ajax work?

I have another loop that loops thru each checkbox and dropdown inside of the datalist to determine if the checkbox/dropdown list should be enabled/disabled. There are about 4 of these datalist sections on the page.

Code:

<asp:datalist id="dlCourses" runat="server" RepeatColumns="3" RepeatDirection="Horizontal">
<ItemTemplate>
<td>
<asp:checkbox ID="cbClassStatus" Enabled=True Runat="server" Text='<%#DataBinder.Eval(Container, "DataItem.Class_Description")%>'>
</asp:checkbox>

[code]....

View 1 Replies

Looping Through A Returned Rows In DataTable

Jul 31, 2012

I have as script that runs a stored procedure to fetch a comment along with it's id. There are multiple comments and I want to display them but I am having problem with display all the records. Here is my code:

Using con
Using sda As New SqlDataAdapter()
Try
cmd.Connection = con
Catch ex As Exception
Response.Write("Error" & ex.Message)

[code]...

How do I make it so that the returned results will be like this:

                 6 First Comment

                 7 Second Comment

View 1 Replies







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