I am newbie ,pls help don't know why it shows double value in datagridview. thanks alot
VB.NET:
da.Fill(ds, "New")
bsource.DataSource = ds.Tables("New")
'Set default value
dt = ds.Tables("New")
Me.dt.Columns("section").DefaultValue = sect
Me.dt.Columns("department").DefaultValue = dept
'To filter base on selected section and department
bsource.Filter = "section='" & sect & "' And department='" & dept & "'"
Me.DataGridView1.DataSource = bsource
Me.DataGridView1.Columns(0).Visible = False
Me.DataGridView1.Columns(1).Visible = False
Me.DataGridView1.Columns(2).Visible = False
sqlconn.Close()