[Mono-list] help with MySqlParameter

Peter petervyvey@village.uunet.be
Mon, 15 Nov 2004 18:53:27 +0100


Sergio,

Try using '?user' for you parametername.

You could try the following:

string connstr = "... valid connection string here ...";
MySqlParameter name = new MySqlParameter("?user",MySqlDbType.VarChar);
name.Value="admin";
DataRow usr = MySqlHelper.ExecuteDataRow(connstr, "SELECT * FROM usr WHERE 
username=?user", name);

Peter