Hi
I am trying to get data from my database using a string value, but keep getting an error message "Value of type string cannot be converted to system.data.dat aset"
The code is:
strRetailTenant Type = Replace(dstReta ilTenantType.Ta bles(0).Rows(0) .Item(0), " ", "")
dstRentalIndex = ("Select " & strRetailTenant Type.Trim & "...
3 results in 0.0014 seconds.
-
String Value in a SQL statement
-
sql statement writing
Hi
I have following SQL Queries. Is there a way to to write a single query instead somehow instead?
-Get OrderID from this query
SELECT OrderID FROM Orders WHERE CustomerID='" + reader.Item("Cu stomerID")
-Using OrderID, get ProductID
"SELECT ProductID FROM OrderDetails WHERE OrderID=" + readerp.Item("O rderID")
-Using ProductID, get... -
How to eliminate selecting repeats in a statement
I need a sql statement that doesn't select any record that has already been selected with the same data in a field.
In other words, if I had these 3 records in the form of NAME, ID, and PHONE
MATT, 333, 000-000-0000
MATT, 333, 000-000-0000
STEVE, 555, 000-000-0000
RICK, 444, 000-000-0000
I want to eliminate selecting MATT more than once. So the total record count would be 3 and there...
