Member Avatar for zarifin99ska

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
Edited by zarifin99ska because: n/a
  • 2 Contributors
  • 5 Replies
  • 102 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by zarifin99ska

Recommended Answers

All 5 Replies

Member Avatar for prvnkmr194

No need to create column at run time.
change line number 3 to

da = New OleDbDataAdapter("select customername, icnum, address, phonenum, dateform, emailcust from custlist where agentnamecust= '" & Me.agentlist.Text & "' ", mycn)
Member Avatar for zarifin99ska

I understand, if i use that,it will only call which column i want, but on the datagridview, the headertext will be the same on database. I forgot to mentioned, i have design the datagridview with HeaderText value i added manually. i just want to insert the data on existing columns.

please help.

Edited by zarifin99ska because: n/a
Member Avatar for prvnkmr194 
KryptonDataGridView1.AutoGenerateColumns = False

add this line at line number 10 which is blank in your code.
It will help you

Member Avatar for zarifin99ska

got it, i clear existing column, and put

KryptonDataGridView1.Columns(0).HeaderText = "Customer Name"
KryptonDataGridView1.Columns(1).HeaderText = ....
Edited by zarifin99ska because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.