title: retrieve data from sql to datagrid view
body: <p>this code wont run it supposed to fill the datagridview some data but all i got was the rows of how many data was retrieve but no values on each cells</p>
  
  <pre><code>    public void refDGV()
      {
  
          con.OpenConnections();
          SqlCommand cmd = new SqlCommand();
          SqlConnection cn = new SqlConnection();
          SqlDataAdapter da = new SqlDataAdapter();
          DataSet ds = new DataSet();
          cmd.Connection = cn;
          cmd.CommandType = CommandType.Text;
          cn.ConnectionString = con.connections1;
          cmd.CommandText = "Select  dtransdate, ntotal_pass, nincomeday, ndiesel_exp,  nstartkm, nendkm  from ROUTE2 where ccontrol_no = '" +txtCN.Text + "'";
          da = new SqlDataAdapter();
          da.SelectCommand = cmd;
          ds = new DataSet();
          da.Fill(ds, "Data");
          dgroute.DataSource = ds;
          dgroute.DataMember = "Data";
         dgroute.Columns[0].HeaderText = "Date";
         dgroute.Columns[1].HeaderText = "Total Passenger";
         dgroute.Columns[2].HeaderText = "Income Day";
         dgroute.Columns[3].HeaderText = "Diesel (w/ reciept)";
         dgroute.Columns[4].HeaderText = "Start";
         dgroute.Columns[5].HeaderText = "End";
  
  
  
  
      }
  </code></pre>