How to insert data to dynamic table?

Question

1.00/5 (1 vote)

See more:

I'l explain u my concept..
I have a dropdownlist and a dynamic table...
when i select in dropdownlist i want data to be changed in dynamic table according to the selected value in dropdown... and also how to link database to the table....

Posted 18-Feb-12 1:24am

Navya_21

Add a Solution

Comments

CRDave1988 18-Feb-12 7:47am

What u have try till now? where u get problem?

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)

Aniket Yadav · Answer 1 · 2012-02-18T01:31:00

Solution 1

On the SelectionIndexChanged(), Fire The Query For That particular item and fill your dynamic table.

This is the simple way to do that.

But i haven't understood your other question about linking database to table. What you exactly want here?

Posted 18-Feb-12 1:31am

Aniket Yadav

Comments

Navya_21 19-Feb-12 3:18am

Sorry i'm very new to c#....
in SelectionIndexChanged() i hve given the query bt hw wil it display in that dynamic table.... I'l tel u wht i'm trying is in dropdown i have 2 option of assign and not assign... when i select assign i should get only the people who r nt assigned in that table which is stored in database, likewise when i select not assign i should get only that list.... can u pls explain me how to do this since i'm very new to dis....

Aniket Yadav 19-Feb-12 5:07am

can you tell me the database fields of the table you are using?
And also the table that you have linked with your dropdown box.
So that i can figure it out for you

Navya_21 21-Feb-12 1:46am

The dropdownlist i have added static data, it contains assign and not assign two items.... In database table the fields are Shift_details_Id, Shift_ID,Emp_ID,From_time, To_time,Assigned_date,Status....
All these fields contains the related info and the status field contain info as Assign or Not Assign... When i select Not Assign in dropdownlist i Should get all fields mentioned above whose status in Not Assign, like wise when i select Assign i should get only dat.... can u pls tel me neatly how to do dis....

Aniket Yadav · Answer 2 · 2012-02-20T22:58:00

C#

private void cmbDropDownBox_SelectionIndexChanged()
{
    string myStr = "";
    if(cmbDropDownBox.SelectedIndex != -1)
    {
        if(cmbDropDownBox.Text == "Assigned")
        {
            //Fire The Query For Status = "Assigned"
            myStr = "SELECT * FROM YourTableName WHERE Status = '" + cmbDropDownBox.Text + "'";
            //Store The Data Into the Datatable
            //And From the Datatable, display it into your grid
        }
        else if(cmbDropDownBox.Text == "Not Assigned")
        {
            //Fire The Query For Status = "Not Assigned"
            myStr = "SELECT * FROM YourTableName WHERE Status = '" + cmbDropDownBox.Text + "'";
            //Store The Data Into the Datatable
            //And From the Datatable, display it into your grid
        }
    }
}

Hope You Will Get An Idea Through This...