Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. Dim cd As SqlCommandBuilder = New SqlCommandBuilder(adapter)
  2. adapter = New SqlDataAdapter("select c.cid,c.CompanyName,d.dtId,d.dtName as Department,d.dtPhone as Phone,d.dtEmail as Email,d.empimage as Image from CompanyMaster_tbl c join DepartmentMaster_tbl d on c.Cid=d.cId order by cid", con.connect)
  3. dt1 = New DataTable
  4. bSource = New BindingSource
  5. adapter.Fill(dt1) 'Filling dt with the information from the DB
  6. bSource.DataSource = dt1
  7. gv.DataSource = bSource
  8. gv.Columns("cid").Visible = False
  9. gv.Columns("dtId").Visible = False
  10.  
  11. Dim btn As New DataGridViewButtonColumn
  12. gv.Columns.Insert(6, btn).
  13.  
  14. Dim btn As New DataGridViewButtonColumn
  15. btn.HeaderText = "Click Data"
  16. btn.Text = "Click Here"
  17. btn.Name = "btn"
  18. btn.UseColumnTextForButtonValue = True
  19. gv.Columns.Insert(6, btn)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement