![]() Datalist is the first listbox and dataorders is the second. I think I am almost there but do not know the syntax for using that particular cell within the row. ![]() From that row, I would like to use the second column (custid) and query the orders table against that to get the relevant data for that customer id. Now I would like to take that list box and select a row within it. ![]() Sql = "SELECT * FROM cust WHERE postalcode = " + zipcodesearch.TextĭataList.AddRow(data.IdxField(6).StringValue, data.IdxField(1).StringValue, data.IdxField(2).StringValue, data.IdxField(3).StringValue, data.IdxField(11).StringValue) Got great help from /u/logicalvue and got my query to work on text input for zip code.ĭim zip As String = "'" + zipcodesearch.Text + "'"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |