0
thanks for mentioning connection string. i did close the connection in the connection method. infact i mustn't do that.. thanks alot...
0
int intParamCount = 0;
SqlParameter[] sqlParam=new SqlParameter[2];
SqlCommand objInsertCommand=new SqlCommand("sp_InsertReserve",objConn); //specify the connection
objInsertCommand.CommandType =CommandType.StoredProcedure;
//Associate Parameters
sqlParam[0]=new SqlParameter("@reservationUserID",SqlDbType.VarChar );
sqlParam[0].Direction =ParameterDirection.Input ;
sqlParam[0].Value =UID;
sqlParam[1]=new SqlParameter("@reservationBookID",SqlDbType.VarChar );
sqlParam[1].Direction =ParameterDirection.Input ;
sqlParam[1].Value =BID;
while(intParamCount
0
In your code where are you setting the connection object?