posted on Wednesday, September 22, 2004 11:44 AM
by
warstar
Stupid OleDbCommand.Parameters
Hi all,
Men i have been f*cking up today i had some nice OleDbCommand lbut one way or the other the paramaters didn't work right it looked like this:
OleDbCommand SelectCommand = new OleDbCommand("SELECT DesignID, Name, TextColor, BackGroundAlign, BackGroundColor, BackGroundImage, BackGroundRepeat FROM DesignFrames WHERE (DesignID = ?) AND (Name = ?)",this.oleDbConnection1);
SelectCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.Integer));
SelectCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("DesignID", System.Data.OleDb.OleDbType.Integer));
After spending about 1 hour i find out that with OleDbCommand the order of the Parameters mather so great yet another hour wasted on notting. My code now looks like this:
OleDbCommand SelectCommand = new OleDbCommand("SELECT DesignID, Name, TextColor, BackGroundAlign, BackGroundColor, BackGroundImage, BackGroundRepeat FROM DesignFrames WHERE (DesignID = ?) AND (Name = ?)",this.oleDbConnection1);
SelectCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("DesignID", System.Data.OleDb.OleDbType.Integer));
SelectCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.Integer));
Happy Netting,
Warnar Boekkooi