I want to retrieve data frm my DB in a datacombo what event nd property shud i use plz help me with the single line code to retrieve data
asmit1987
0
Newbie Poster
Recommended Answers
Jump to PostPrivate Sub ReadData() Dim i As Integer con.ConnectionString = ("Provider = Microsoft.JET.OLEDB.4.0;Data Source= D:\Only Me\Authors.mdb") Try cmdOle = con.CreateCommand cmdOle.CommandText = "SELECT * FROM Authors " da.SelectCommand = cmdOle da.Fill(dsOle, "Authors") dtOle = dsOle.Tables("Authors") For i = 0 To dtOle.Rows.Count - 1 cmbAuthor.Items.Add(dtOle.Rows(i).Item(1)) Next Catch ex As …
All 3 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
asmit1987
0
Newbie Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
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.