Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim cd As SqlCommandBuilder = New SqlCommandBuilder(adapter)
- 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)
- dt1 = New DataTable
- bSource = New BindingSource
- adapter.Fill(dt1) 'Filling dt with the information from the DB
- bSource.DataSource = dt1
- gv.DataSource = bSource
- gv.Columns("cid").Visible = False
- gv.Columns("dtId").Visible = False
- Dim btn As New DataGridViewButtonColumn
- gv.Columns.Insert(6, btn).
- Dim btn As New DataGridViewButtonColumn
- btn.HeaderText = "Click Data"
- btn.Text = "Click Here"
- btn.Name = "btn"
- btn.UseColumnTextForButtonValue = True
- gv.Columns.Insert(6, btn)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement