SqlCommand executing query statements

Because the division is not very clear, so a summary of the basic knowledge of SQL query statements.

• Command common list of attributes

Property	Function description
Connection	Set the link used by the Command object
CommandText	The content of the command being executed (such as an SQL statement)
CommandType	Indicates the type of the CommandText property, which can be an SQL statement
Parameters	Set of parameters for command formation

1.0 Basic Statements:

2.0 The above is simply written as:

2.1 If the above SQL statement is too long, you can declare it individually:

SqlCommand executing query statements