\n
Private Sub UserForm_Activate()\r\nDim cnn As ADODB.Connection\r\nDim rs As ADODB.Recordset\r\nDim cnnstr As String\r\n\r\nSet cnn = New ADODB.Connection\r\nSet rs = New ADODB.Recordset\r\ncnnstr = \"Provider=SQLOLEDB;Data Source=........;Initial Catalog=.......;User ID=.......;Password=..........;\"\r\n\r\ncnn.Open cnnstr\r\nrs.Open \"select [Ad] from OdemeSeklis\", cnn\r\n\r\nDo While Not rs.EOF\r\nFor i = 0 To rs.Fields.Count - 1\r\nMe.ListBox1.AddItem rs.Fields(i).Value\r\nNext\r\nrs.MoveNext\r\nLoop\r\nrs.Close\r\n\r\ncnn.close\r\n\r\nEnd Sub<\/pre>\n<\/div>\nKolay gele…<\/p>\n","protected":false},"excerpt":{"rendered":"
Private Sub UserForm_Activate() Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim cnnstr As String Set cnn = New ADODB.Connection Set rs = New ADODB.Recordset cnnstr = “Provider=SQLOLEDB;Data Source=……..;Initial…<\/p>\n
Devam\u0131n\u0131 OkuVBA ADODB.Recordset Nesnesinden Listbox\u2019a Veri Doldurma<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[5],"tags":[19,18],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-adodb","tag-listbox","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":66,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/66"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}