Community discussion forum

plz help me out...urgent

• • Reply

  0 month

  by geeth

  geeth

  , India

  Joined 1 year ago
  hi.. i have doubt regarding joins....here is my question... how to join two tables from the database and bind them to the gridview using joins in vb.net depending on userid please help me out...its urgent..
  Report abuse
• • Reply

  11 months ago

  by gangireddysaritha

  gangireddysaritha

  hyderabad, India

  Joined 1 year ago
  hi.....i hope this helps dim str as string="select * from table1 inner join table2 on table1.col1=table2.col1" dim da as sqldataadapter dim ds as dataset dim cmd as SqlCommand dim con as new sqlconnection(connectionstring) con .open() cmd = new SqlCommand(str, con) da =new sqldataadapter(cmd) ds =new dataset da.fill(ds) datagridview1.datasource=ds.tables(0)
  Report abuse
• • Reply

  11 months ago

  by gangireddysaritha

  gangireddysaritha

  hyderabad, India

  Joined 1 year ago
  dim str as string="select * from table1 inner join table2 on table1.col1=table2.col1" dim da as sqldataadapter dim ds as dataset dim cmd as SqlCommand dim con as new sqlconnection(connectionstring) con .open() cmd = new SqlCommand(str, con) da =new sqldataadapter(cmd) ds =new dataset da.fill(ds) datagridview1.datasource=ds.tables(0)
  Report abuse