Using Database Commands in ASP.NET

The SqlDataSource control can be used to represent four different types of SQL commands that use for executing inline SQL statements. The control supports the following four properties:

selectCommand, insertCommand, updateCommand, and deleteCommand
Example

asp:SqlDataSource

id="srcStudent"

SelectCommand="SELECT * FROM student"

ConnectionString="<%$ ConnectionStrings:Student %>"

Runat="server"