I am just trying to convert some code from a vb6 program to .net and am going further crazy. Please consider the 4 lines of code.
The first line is obviously commented out but it works. When I call the numeric field, the Select will work and the data returns.
NOW my problem: The second line passes in a string. I have resorted, for testing purposes, to hard coding a search term but ordinarily it comes out of a list box as a variable and then populates the following 2 fields. This does NOT work and I don't know why. I've tried many permeations to no avail. I would love to hear what is wrong with the string.
Background: I know it fails because I get a debug that says it returned a null value and stops executing. The first code completes and no error is returned.
Thank you in advance for your help.
' Dim mSearchString = "SELECT * FROM vw_domains WHERE ((vw_domains.idnumber)=2);
Dim mSearchString = "SELECT * FROM vw_domains WHERE ((vw_domains.domain)='www.allstatefund.com'
Dim DomainListdt As DataTable = gConn.GetDataTable(mSearch
TextBox1.Text = DomainListdt.Rows(0).Item(
TextBox2.Text = DomainListdt.Rows(0).Item(