bind table datafield using array list

Question

0.00/5 (No votes)

See more:

C#

al = new ArrayList();
        al.Add(test);
        al.Add(test1);
        GridView1.DataSource = al;
        GridView1.DataBind();

what i want is in place of test and test1 in al.Add(); i want to bind the dataField of table from a database.?

Posted 30-May-12 3:02am

saurabh kumar mahto

Updated 30-May-12 3:05am

Mohamed Mitwalli

v2

Add a Solution

2 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)

Sandeep Mewara · Accepted Answer · 2012-05-30T03:14:00

Solution 2

want to bind the dataField of table from a database.
Based on what you are doing you have two options:
1. Directly bind the datatable that is retrieved from DB to grid.
2. Find the specific values and then add that to the arraylist, something like:

C#

// Find the row and column and use it
// Assuming 1st row - 2 columns
al.Add(MyDataTable.Row[0]["Column1"].ToString());
al.Add(MyDataTable.Row[0]["Column2"].ToString());

Posted 30-May-12 3:14am

Sandeep Mewara

Comments

VJ Reddy 30-May-12 9:29am

Good answer. 5!

Sandeep Mewara 30-May-12 14:34pm

Thanks VJ.

Maciej Los 30-May-12 16:12pm

Good answer, my 5!

Sandeep Mewara 30-May-12 16:21pm

Thanks.

VJ Reddy · Accepted Answer · 2012-05-30T03:28:00

Answer 2 is good.

I have a small suggestion.

ArrayList is non generic type. Which means there is no type safety, i.e. in the above example

C#

a1.Add("Test");
a1.Add(5);

will both work but it will throw error at run time if the required type is say either string or int only.

Secondly, when used with value types in case of non generic types there is an overhead of boxing and unboxing.

So, it is better to use the Generic counter part of ArrayList i.e. List<T> explained here http://msdn.microsoft.com/en-us/library/6sh2ey19.aspx[^], by populating it with the values from the DB as already shown in Solution 2.

For the case shown in the question only one column is being used in the GridViewin which case I think a ListBox can be lightweight control unless there is a specific requirement to use a GridView.

In case GridView is required to be used, in particular with more than one column, I think it is better to use a DataTable.