getting error when trying to execute an Sql command

Question

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???

sql is not SqlCommand. You need to create sqlcommand.

kostas ch.
– kostas ch.

2013-08-02 12:13:33 +00:00
Commented Aug 2, 2013 at 12:13 — kostas ch.
– kostas ch., Commented Aug 2, 2013 at 12:13
You probably want to look at SqlCommand objects.

Chris
– Chris

2013-08-02 12:14:03 +00:00
Commented Aug 2, 2013 at 12:14 — Chris
– Chris, Commented Aug 2, 2013 at 12:14

Conrad Lotz · Accepted Answer · 2013-08-02 12:14:58Z

2

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();

answered Aug 2, 2013 at 12:14

Conrad Lotz

8,9533 gold badges25 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

senthilkumar2185 Over a year ago

this vb.net you using c#

kostas ch. · Accepted Answer · 2013-08-02 12:14:49Z

1

Add this

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

answered Aug 2, 2013 at 12:14

kostas ch.

2,0451 gold badge18 silver badges32 bronze badges

1 Comment

Damien_The_Unbeliever Over a year ago

Single argument constructor expects the text, not the connection.

Malkus · Accepted Answer · 2013-08-02 12:19:22Z

0

Dim cmd As SqlCommand = new SqlCommand ();

cmd=(sql,connection);

cmd.CommandType=CommandType.Text;

Dim reader As SqlDataReader = cmd.ExecuteReader()

edited Aug 2, 2013 at 12:19

Malkus

3,7262 gold badges27 silver badges39 bronze badges

answered Aug 2, 2013 at 12:15

Kavipriya

544 bronze badges

Collectives™ on Stack Overflow

getting error when trying to execute an Sql command

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related