I need some little help with a stupid problem I'm having with VB.NET in VS2005:
I'm using a bunch of TableAdapters, all with extra queries attached to them.
One of my goals is to be able to query all the fields in TableAdapter; this TableAdapter is filling a Dataset, which is linked to a DataGridView.
There are several options here, but I'm really looking for the shortest code-path, ofcourse.
Now, I would like to make a query like this: "SELECT * FROM tablename WHERE @id1 = @val1"
But, when using this in the tableadapter, ofcourse, everything gets sql-ized.
in other words, after doing:
me.ta.FillByColnameVal(me.ds.dt, "fieldname", "fieldvalue")
I don't get any results (most likely because the query now becomes SELECT * FROM tablename WHERE "fieldname" = "fieldvalue", which ofcourse doesn't work)
Is there a way around this or shall i just use the dt.select("fieldname like fieldvalue") method ? (I rather use the TableAdapter tbh)
thx in advance guys,