Hi
I've design a datagridview with 6 columns. But i got a code somewhere in internet,the code make my datagridview added with 8 more columns from database. i dont know how to put the data from database into specific columns in the designed datagridview. on database, i have 8 columns, but i want to retrieve data from 3rd until the last row. database column name =id, agentname, customername, icnum, address, phonenum, dateform, emailcust.
can someone help me??
this is the code
Try
mycn.Open()
da = New OleDbDataAdapter("select*from custlist where agentnamecust= '" & Me.agentlist.Text & "' ", mycn)
'create command builder
Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(da)
'fill dataset
da.Fill(ds, "custlist")
KryptonDataGridView1.DataSource = ds
KryptonDataGridView1.DataMember = "custlist"
Catch ex As OleDbException
MsgBox(ex.ToString)
Finally
' Close connection
mycn.Close()
End Try