problem in datagridview

Question

basma.lm 0 Junior Poster in Training

14 Years Ago

hi,
i work on a csharp application with sql server ce database and i have this code:

private void recherchebtn_Click(object sender, EventArgs e)
        {

            SqlCeConnection con = new SqlCeConnection();
            con.ConnectionString = @" Data source= `|DataDirectory|\Database1.sdf";
            try
            {
                con.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("connection failed");
            }
            finally
            {

                SqlCeDataReader rs;
                SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM          Condamne where Nom='" + nomTextBox.Text + "'and Prenom='" + prenomTextBox.Text + "'", con);
                rs = cmd.ExecuteReader();
                SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
                da.Fill(database1DataSet);
                con.Close();
                dataGridView1.DataSource = database1DataSet.Condamne;
            }
}

but this code doesn't work and nothing displayed in the datagridview.
i hope you help me and thanks..

2 Contributors
3 Replies
94 Views
1 Day Discussion Span
Latest Post 14 Years Ago Latest Post by basma.lm

krishnisilva 0 Junior Poster

14 Years Ago

I am also in trouble with the datagrid view , see whether if i can help u, nothing wrong in the coe as i can see . Did you add the data source from the interface??
hey check this link
http://www.eggheadcafe.com/community/aspnet/2/10100422/having-problem-edit-updat.aspx

seee whether this is useful for u??

Edited 14 Years Ago by krishnisilva because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

basma.lm 0 Junior Poster in Training · Answer 1 · 2010-04-24T14:37:05+00:00

hi,
thanks for replay. yes,i use the data source that i have created before ( database1Dataset).

basma.lm 0 Junior Poster in Training · Answer 2 · 2010-04-24T19:10:52+00:00

hi,
i find the solution. i made a mistake and forgot to use datatable, so the correct code is:

private void recherchebtn_Click(object sender, EventArgs e)
        {

            SqlCeConnection con = new SqlCeConnection();
            con.ConnectionString = @" Data source= D:\messaouda\logicielcasier22\logicielcasier\Database1.sdf";
            try
            {
                con.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("connection failed");
            }
            finally
            {
                 SqlCeDataReader rs;
                SqlCeCommand cmd = new SqlCeCommand("SELECT [Nom],[Prenom],[DateNaissance],[AnneeJugee],[NomPere],[NomPrenomMere],[SituationFamiliale] FROM Condamne where Nom='" + nomTextBox.Text + "'and Prenom='" + prenomTextBox.Text + "'", con);
                    SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
                    DataTable dtresullt = new DataTable();
                    da.Fill(dtresullt);
                    dataGridView1.DataSource = dtresullt;
            }
}