How to run a loop within a loop?

Mayank Jani

Hii

I am working on a WinApp in C# using MS Access as database.

It is difficut for me to explain my problem but let me try... and please have some patience...

I want to fetch some rows from table A, the rows may be 2, 3, or 5 etc.

the data of the rows comes from a master table and I use serial number of the Items to save data in the table. I do this because to save memory and keep the table size as low as possible.

suppose, there are 3 rows with same serial number, I want to fetch all 3 records then accoding to the serial number, fetch the original items from the master table then to display the items in a DataGridView.

The problem is, the first row gets the item name and rest of all displays as serial number.

this is all I can explain... but I have try to explain it by screen shots.

Please see the screen shot...1.the query 2.the tables and output.

I think I have to run two loops but I dont know how to do that.

Please let me know if you want some other information.

Thanks

Mayank Jani

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jefferson S. Motta8y ago
Accepted answer
Put the for( int ... usingdgvBillingDetails.Rows.Count
see attach.

About the data type, you must see your grid type data.
0
Mayank Jani8y ago
Hii Jefferson,
It's done. I am sorry, it was my mistake that I did not understand properly what you were trying to say. Sorry.

There is just one loop is required to get data...

for (int a = 0; a <= dgvBillingDetails.Rows.Count - 1; a++)
{
OleDbDataAdapter FindBillItems = new OleDbDataAdapter("Select BillItemName From BillItem Where SrNo=" + dgvBillingDetails.Rows[a].Cells[0].Value, MyConnMas);

DataSet dsFindBillItems = new DataSet();
FindBillItems.Fill(dsFindBillItems);

dgvBillingDetails.Rows[a].Cells[0].Value = (dsFindBillItems.Tables[0].Rows[0].ItemArray[0].ToString());
}

Thank You So Much Once Again...

Mayank Jani.
0
Mayank Jani8y ago
Hii Jefferson,
Thank you for your reply...
sorry it does not working, after make changes as you suggested, the billing items duplicates of the first item and the last item remains same as before.
e.g. if there are 4 items in the bill, AAA, BBB, CCC, DDD then, it displayes.
AAA
AAA
AAA
4
0
Mayank Jani8y ago
Hii Vincent,
thank you for reply...

I have attached a screen shot of an excel sheet. I have described evertything in that screen shot as possible as I can.

the code is also attached in my previous (original) post. you can see that.
please let me know if you want anything else.

Thanks once again
0
Vincent Maverick Durano8y ago
But serial numbers are supposed to be unique.

Can you show us the code that you've tried? Also can you outline a sample data set and what is your expected result in plain text?
0