populate datagridview by selecting any table from combo box

Question

0.00/5 (No votes)

See more:

VS2010

i have used the following code for displaying names of my sql db tables in combobox...now i want dat when i click on any of these table names from combo box..my dgv populates with that table's contents

private void Form1_Load(object sender, EventArgs e)
        {
            String strConnection = "Data Source=HP\\SQLEXPRESS;database=MK;Integrated Security=true";

            SqlConnection con = new SqlConnection(strConnection);
            try
            {

                con.Open();

                SqlCommand sqlCmd = new SqlCommand();

                sqlCmd.Connection = con;
                sqlCmd.CommandType = CommandType.Text;
                sqlCmd.CommandText = "Select table_name from information_schema.tables";

                SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);

                DataTable dtRecord = new DataTable();
                sqlDataAdap.Fill(dtRecord);
                comboBox1.DataSource = dtRecord;
                comboBox1.DisplayMember = "TABLE_NAME";
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

Posted 11-Mar-13 0:25am

mayuri koul

Updated 12-Mar-13 3:02am

Shubh Agrahari

v2

Add a Solution

Comments

Shanu2rick 11-Mar-13 6:35am

What have you tried yet?

mayuri koul 11-Mar-13 6:39am

private void PopulateGridView(string tablename)
{
String strConnection = "Data Source=HP\\SQLEXPRESS;database=MK;Integrated Security=true";

SqlConnection con = new SqlConnection(strConnection);
con.Open();

string tableName = comboBox1.SelectedText;

SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "Select * from " + tableName;

SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd);

DataTable dtRecord = new DataTable();
sqlDataAdap.Fill(dtRecord);
dataGridView1.DataSource = dtRecord;
con.Close();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedValue != null)
{
PopulateGridView(comboBox1.SelectedValue.ToString());
}
}
but it's not working :(

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)

vishal.shimpi · Answer 1 · 2013-03-11T02:19:00

Make sure that your gridview property "AutoGeneratedColumns=true", becouse you dynamically bind records to the gridview...

C#

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (comboBox1.SelectedValue != null)
            {
                PopulateGridView(comboBox1.SelectedValue.ToString());
            }
        }

and make sure that in above code "comboBox1.SelectedValue" is your table name..

Shubh Agrahari · Answer 2 · 2013-03-11T00:49:00

Solution 1

hello mayuri

i think it will help you

C#

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
 {

      string table_name=combobox1.selecteditem.tostring(); //or can use string table_name= combox1.text      
      con.Open();
      SqlDataAdapter da = new SqlDataAdapter("select * from " + table_name + " ",con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        dgv.DataSource = ds.Tables[0];
        dgv.DataBind();
    
        con.Close();
 }

happy to help

Posted 11-Mar-13 0:49am

Shubh Agrahari

Comments

mayuri koul 11-Mar-13 6:55am

thnks but...it is showing error in con.open() and close...stating does not exist in current context :(
plz help

Shubh Agrahari 11-Mar-13 8:12am

try your own connection string that successfully runs in previous problem...

vishal.shimpi 11-Mar-13 8:22am

define
SqlConnection Con = new SqlConnection("Your Connectionstring");
before
con.open();