ExecuteReader Error Msg

Tom Tom · 07-06-2006

I keep getting 'ExecuteReader: CommandText property has not been initialized' error message. Why!!!

AddCoderPro · 07-07-2006

As far as I know, the Page_Load event fires BEFORE any control event, so the
SQL string has not been initialized when Page_Load calls the data binding method or procedure.

Whether or not that clue solves the problem, you might want to pass a
SqlCommand/OleDbCommand object to the SqlDataAdapter/OleDbDataAdapter instead of passing a query string.
Before passing the SqlCommand/OleDbCommand object, set both its CommandText and CommandType (i.e., "Text") properties.

agaba175 · 07-08-2006

Hi,

You are getting this message because you havn't set your command text property for the command object. This property is used to set the SQL query for the command object. Which in turn gives you the result. For setting the command text property use this sample code.

CmdObject.CommandText="SQL Query"

07-06-2006	#1 (permalink)
Tom Tom Junior Member Join Date: Jul 2006 Age: 48 Posts: 25	ExecuteReader Error Msg I keep getting 'ExecuteReader: CommandText property has not been initialized' error message. Why!!!

07-08-2006	#3 (permalink)
agaba175 Banned User Join Date: Jul 2006 Location: India Age: 30 Posts: 105	Command Text Error Message Hi, You are getting this message because you havn't set your command text property for the command object. This property is used to set the SQL query for the command object. Which in turn gives you the result. For setting the command text property use this sample code. CmdObject.CommandText="SQL Query"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What HTTP error is generated when there is an error in an ASP page?	agaba175	ASP	0	08-05-2006 08:25 PM

07-07-2006	#2 (permalink)
AddCoderPro Junior Member Join Date: Jul 2006 Age: 28 Posts: 15	As far as I know, the Page_Load event fires BEFORE any control event, so the SQL string has not been initialized when Page_Load calls the data binding method or procedure. Whether or not that clue solves the problem, you might want to pass a SqlCommand/OleDbCommand object to the SqlDataAdapter/OleDbDataAdapter instead of passing a query string. Before passing the SqlCommand/OleDbCommand object, set both its CommandText and CommandType (i.e., "Text") properties.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

	All times are GMT. The time now is 06:54 PM.
	Contact Us - preCharge.Net - Archive - Privacy Statement - Top