I want to fill gridview

Question

1.00/5 (1 vote)

See more:

what error here?

C#

private void fillgrid()
        {
            try
            {
                DataSet ds = new DataSet();
                ds.Clear();
                SqlConnection con = new SqlConnection(@" kkkk");
                SqlCommand comm = new SqlCommand("select * from client", con);
                SqlDataAdapter adapt = new SqlDataAdapter();
                con.Open();
                adapt.SelectCommand = comm;
                adapt.Fill(ds);
                dataGridView1.DataSource = ds;
                dataGridView1.DataMember = "client";
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

Posted 31-Jan-13 10:39am

Member 9702410

Updated 31-Jan-13 10:43am

DinoRondelly

v2

Add a Solution

Comments

Adam R Harris 31-Jan-13 16:45pm

Shouldn't you be telling us what the error is?

Jibesh 31-Jan-13 16:50pm

what is this ' SqlConnection con = new SqlConnection(@" kkkk");' is that a valid sqlconnection ?

Member 9702410 31-Jan-13 16:58pm

the connection is righ i put this "kkk"

Member 9702410 31-Jan-13 16:50pm

thanks for your advice!! i only want to know the error?

Adam R Harris 31-Jan-13 16:53pm

what is the error message you are getting?

Member 9702410 31-Jan-13 16:59pm

no message error ,when clickin on button the gridview doesn't be filled

Adam R Harris 31-Jan-13 17:01pm

Comment out this line:
dataGridView1.DataMember = "client";

and try to run your app.

Member 9702410 31-Jan-13 17:08pm

i already comment it but also there is no filling

DinoRondelly 31-Jan-13 17:13pm

Try what i added as a solution, just copy and paste it and change the connection string, should work.

Adam R Harris 31-Jan-13 17:16pm

Dino is right, the code he has posted is what you should be using.

Member 9702410 31-Jan-13 16:51pm

yes the connection is righ i put kkk

Jibesh 31-Jan-13 16:54pm

so what's your problem here? by looking at the code If i say I dont see any error. will it be ok??

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DinoRondelly · Accepted Answer · 2013-01-31T10:54:00

Solution 2

try this,

C#

try
{
 using (SqlConnection con = new SqlConnection(YOUR CONNECTION STRING))
 {
  con.Open();

  // Create new DataAdapter
   using (SqlDataAdapter adapt = new SqlDataAdapter("select * from client", con))
   {
      // Use DataAdapter to fill DataTable
      DataTable ds = new DataTable();
      adapt.Fill(ds);

      // fill your grid
      dataGridView1.DataSource = ds;
   }
  }
}
catch(Exception ex)
{
     MessageBox.Show(ex.Message);
}

Posted 31-Jan-13 10:54am

DinoRondelly

Updated 31-Jan-13 10:59am

v3

Comments

Adam R Harris 31-Jan-13 16:57pm

pft, no try catch?!?!?!
what kind of rinky dink operation are you running over there Dino?

DinoRondelly 31-Jan-13 16:59pm

Touche .. updated solution

I want to fill gridview

1 solution

Solution 2

Add your solution here

Preview 0

I want to fill gridview

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us