setting datasource of Grid View Problem

[shaina2231]

i m using following code to set Datasource of gridview but its not working plz help

string path = Directory.GetCurrentDirectory();
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\cricketdb.mdb";

        OleDbConnection con = new OleDbConnection(conn);

        OleDbCommand cmd = con.CreateCommand();
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "SELECT \* FROM countryinfo";
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        DataSet ds = new DataSet("countryinfo");
        OleDbCommandBuilder oldbcbr = new OleDbCommandBuilder(da);
        da.Fill(ds, "countryinfo");

        dataGridView1.DataSource = ds;

        

        comboBox2.DataSource = ds.Tables\["Country\_Name"\];
        listBox1.DataSource = ds.DefaultViewManager;
        listBox1.DisplayMember = "Country\_Name";
        dataGridView1.DataSource = ds;
        DataTable dt = new DataTable();
        da.Fill(dt);
        dataGridView1.DataSource = dt;
        comboBox2.DataSource = dt;

Its also not setting datasource of anycontrol like combo or list plz help

[Khaniya]

Is it shows any error ?

Life's Like a mirror. Smile at it & it smiles back at you.- P Pilgrim So Smile Please

[shaina2231]

No it does not compiles any error but display nothing in gridview

[Khaniya]

shaina2231 wrote:

comboBox2.DataSource = ds.Tables["Country_Name"];

what is Country_Name ? I think you have to use instead

comboBox2.DataSource = ds.Tables[0];

:)

Life's Like a mirror. Smile at it & it smiles back at you.- P Pilgrim So Smile Please