Loading data once for dropdownlist in Gridview

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have Gridview with data and placed a dropdownlist box in the Gridview.
This dropdownlist box value is loaded from DB.
Eg - Values are :
ABC
XYZ
123

But if my Gridview is having a 100 rows then each time its loading the DB for each dropdownlist box.
Values has to be loaded only once at the time of page load.
I am planing to store the values in Temp table and array, then use the variable for the filling the dropdownlist box.

Can you people guide me on this or give me a better solution.

Posted 11-Dec-13 20:50pm

Arunprasath Natarajan

Add a Solution

Comments

TrushnaK 12-Dec-13 3:07am

I hope you have write your code in page_load() event
and check is postback
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack) {
//Bind your grid view and ddl
}
}

Arunprasath Natarajan 12-Dec-13 8:35am

You didnt got my question. Sorry if i am not clear.

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)

♥…ЯҠ…♥ · Answer 1 · 2013-12-11T21:32:00

Solution 1

Hi Arun,

What I would like to suggest here is, Yes you can.
You can try another way to bind list to drop down like this

1) Get values from DB for dropdownlist and assign it to a list
2) Now get values for gridview and bind it.
3) Once all dropdown list is loaded assign a class to it.
4) Now by class assign list value to each and every dropdownlist in the gridview.

Hope this helps you a bit.

Regards,
RK

Posted 11-Dec-13 21:32pm

♥…ЯҠ…♥

Comments

Arunprasath Natarajan 12-Dec-13 8:34am

Looks cool. Can you give me a sample example.

♥…ЯҠ…♥ 12-Dec-13 8:37am

You should try with your code,since I dont have any schema or anything.Here I can give idea you must implement it.

Arunprasath Natarajan 12-Dec-13 9:13am

Ok will try and get back to you.

farhad Najib · Answer 2 · 2013-12-11T21:47:00

Solution 2

Hi Try it:

C#

if (!IsPostBack) {
                    //Bind your grid view and ddl
    }

Yours Farhad.

Posted 11-Dec-13 21:47pm

farhad Najib

Comments

Arunprasath Natarajan 12-Dec-13 8:35am

You didnt got my question. Sorry if i am not clear.

Gaurav Makwana · Answer 3 · 2013-12-16T19:47:00

Solution 3

use array to fetch the value from database and then this arrray assign to gridview

Posted 16-Dec-13 19:47pm

Gaurav Makwana