2008-02-04

how to learn wisdom.

By Three Methods...
We may learn wisdom:
1st: by reflection, which is noblest;
2nd: by imitation, which is easiest;
3rd: by experience, which is the bitterest.
Confucius.

2008-02-03

asp.net query builder parameter

Found by: asp.net query builder parameter
IDE: Visual Studio 2005
Found URL: http://forums.asp.net/t/1199996.aspx


Quetion/Problem:
Hi there, I have an urgent problem Some background: I'm using vs2005, MySql and Vb.net. Now, I watched the video from asp.net on hilo_data_final which shows you how to create a typed dataset, and using the wizard create adapters, datatables together with the query builder and then filter a given select statement by using an @something parameter. Now, when using MS Sql, it works and after finishing the query builder, the parameter is placed inside the table adapter, but when using MySql, the moment I change the query syntax, the parameter is the "recognized" by vs2005. Hope someone can help...



Solved by:
Hi,
in your query builder, change the @ to ? (question mark).
hope it helps..

Cheers,
CLIPER
There’s nothing constant in this world, except change.
------------------------------------------------
Believe nothing, no matter where you read it, or who said it, no matter if I have said it, unless it agrees with your own reason and your own commonsense.
---Buddha (563BC-483BC)