Not able to show two different row in gridview from database. I spent more time. not able to fix....

Question

0.00/5 (No votes)

See more:

hi, i am binding in gridview from database.

here i need to use attributes and arraylist. to get like dictionary.

i will give my coding with explain:

C#

SqlCommand cmd = new SqlCommand("select * from mylist where lsname is not null", con);

SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable dtmylist = new DataTable();

Note : //the result of select query : 2 rows :

lsname qty
arun 5
bala 6

SqlDataReader dr = cmd.ExecuteReader();
string lsname = string.Empty; int qty = 0;
while(dr.Read())

{

lsname = dr["db_lname"].ToString();
qty = dr["db_qty"].ToString();
arr.at_lname = lsname; // can you see i used attributes to get two(lsname,qty) record in one attributes : 
arr.at_qty = qty; 
order.al.Add(arr); //so now order is class name and al is object of arraylist. so, now order.al[position is 0 and count is 1) is having arr's(attributes values)

}
C1GridView1.DataSource = order.al;
C1GridViewlist.DataBind();<pre>
but the output in gridview is showing
<pre lang="text">lsname qty
bala 6

so, how to show all rows which comes from database in gridview.
Note: i want to use attributes and arraylist as i used above to get 2 records(lsname,qty) in one.
i mean : a[0]={lsname(arun),qty(5)}
and a[1]={lsname{bala),qty(6)}.

help needed.

Posted 14-Dec-13 3:56am

christhuxavier

Updated 14-Dec-13 4:01am

CHill60

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-12-14T04:10:00

Well, look at what you are doing, and it's pretty obvious if you stop and think about it: how many different objects are you adding to order.al?

Surprisingly, it's not two. It's only one, just you try and add it with different values each time.
Think of it this way: if you look at your wallet, it's the same wallet even if you take some money out or put some more in - the value of the wallet changes, but the physical wallet doesn't.

The same thing happens here: you change the values in the "wallet":

C#

arr.at_lname = lsname;
arr.at_qty = qty;

But you always add the same "wallet" to the list:

C#

order.al.Add(arr);

What you need to do is create a new "wallet" each time round the loop. I can't tell you how exactly, because I don't have the part of your code where you create this one, but it's probably along the lines of

C#

arr = new MyClassForArr();

Use your class name, and add that to the top of your while loop.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-12-14T04:36:00

First of all doing all this is unnecessary. As you have used SqlDataAdapter, so you can directly Fill the DataTable and assign that to DataSource like below.

C#

adap.Fill(dtmylist);
C1GridView1.DataSource = dtmylist;

The code you have used is updating the same object, so always last row will be added to object.
Refer OriginalGriff's answer for more information.

christhuxavier · Answer 3 · 2013-12-17T01:04:00

Solution 3

hi thanks a lot for all. i fixed the above issue.

i made mistake that i declared attributes globally (outside of while loop). i declared attributes locally inside of while loop. now it works correctly.

Posted 17-Dec-13 1:04am

christhuxavier

Not able to show two different row in gridview from database. I spent more time. not able to fix....

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0