ExecuteScalar: Connection property has not been initialized.

Question

User1469062072 posted

hi

i have this erroer

ExecuteScalar: Connection property has not been initialized.

when i excute this qury:

 cmd.CommandText = "select PID from Reservation where username='" + Session["username"].ToString() + "' ";

        string str = cmd.ExecuteScalar().ToString();

         string cmd1  = " select  Pname, Gender , Status , Medicin, Comment , Bill from Report where PID = '"+Convert.ToInt32( str)+ "'";

 cmd.CommandText = "select PID from Reservation where username='" + Session["username"].ToString() + "' ";

        string str = cmd.ExecuteScalar().ToString();

         string cmd1  = " select  Pname, Gender , Status , Medicin, Comment , Bill from Report where PID = '"+Convert.ToInt32( str)+ "'";

Answer 1

User-1360095595 posted

It sounds like you haven't associated a Connection with the command.  You need to associate it via the constructor, or via the Connection property. 

Answer 2

User1469062072 posted

hi

can you explain more i don't understand you ????!!!!

Answer 3

User1716267170 posted

Hi bian,

I think MetalAsp.Net is right. You missed the information for connection object. Please check this sample for details:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx

Thanks.