You have initialized two objects System.Data.SqlClient.SqlConnection connection and System.Data.SqlClient.SqlCommand command. How do you exectute a database query?

189.

You have initialized two objects System.Data.SqlClient.SqlConnection connection and System.Data.SqlClient.SqlCommand command.

How do you exectute a database query?

command.CommandText = "sql text here";
command.Connection = connection;
SqlDataReader dr = command.ExecuteReader();

command.CommandText = "sql text here";
connection.Command = command;
SqlDataReader dr = connection.ExecuteReader();

command.CommandText = "sql text here";
SqlDataReader dr = connection.ExecuteReader(command);

No description found.