CODEWITHSUNDEEP
asp.netsqlvb.net
ammukarthi
ammukarthi

Reputation: 45

getting error when trying to execute an Sql command

DataReader throwing an error message when trying to execute an command in my vb.net page And the code throwing error is:

Dim connectionString As String
Dim connection As SqlConnection
Dim sql As String

connectionString = \\\connection string\\\
connection = New SqlConnection(connectionString)

sql = "select * from jb_jobs where city='Los Angeles' "
connection.Open()
Dim reader As SqlDataReader = sql.ExecuteReader()

And the error is: 'ExecuteReader' is not a member of 'string' How to resolve this???

Upvotes: 0

Views: 668

Answers (3)

Kavipriya
Kavipriya

Reputation: 54

Dim cmd As SqlCommand = new SqlCommand ();

cmd=(sql,connection);

cmd.CommandType=CommandType.Text;

Dim reader As SqlDataReader = cmd.ExecuteReader()

Upvotes: 0

Conrad Lotz
Conrad Lotz

Reputation: 8838

Try adding this:

sql = "select * from jb_jobs where city='Los Angeles' ";
    var sqlCommand = new SqlCommand(sql, connection);
    sqlCommand.Connection.Open();
    var reader = sqlCommand.ExecuteReader();

Upvotes: 2

kostas ch.
kostas ch.

Reputation: 2035

Add this

connection.Open()
Dim cmd as new SqlCommand(sql,connection )      
Dim reader As SqlDataReader = cmd.ExecuteReader()

Upvotes: 1

Related Questions