|
ExecuteReader: CommandText property has not been initialized
This error occurs when sql query is not present.
Sql querys like "select * from tablename" has to be given to
CommandText property of the Open Connection.
Check the query . if CommandText Property is empty then
add a query to it.
MyConnection.Open()
Dim myCommand As New SqlCommand(mSqlString, MyConnection)
oSpReturnValue = myCommand.ExecuteNonQuery()
here mSqlString u put the query
if msqlstring is empty the error occurs.
Hope this solves the problem
|