SqlDataSource control is a data source control that is used to connect to a relational database. You can even connect to Oracle or any other data source that can be accessible through OLEDB and ODBC.
ConnectionString and ProviderName are the two properties that is used to connect the database. The first one specify the connection string and second specify the provider name. By default the provider is System.Data.SqlClient, it means connect to Sql Server database.
Following are some important properties that are very useful.
|
Properties for Configuring Data Source
|
| InsertCommand, InsertParameters, InsertCommandType |
Gets or sets the SQL Statement, parameter and type of command (text or stored procedure) to insert a record.
|
| DeleteCommand, DeleteParameters, DeleteCommandType |
Gets or sets the SQL Statement, parameters and type of the command (text or stored procedure) to delete a record.
|
| UpdateCommand, UpdateParameters, UpdateCommandType |
Gets or sets the SQL Statement, parameters and type of the command (text or stored procedure) to update a record.
|
| SelectCommand, SelectParameters, SelectCommandType |
Gets or sets the SQL Statement, parameters and type of the command (text or stored procedure) to select record(s).
|
|
Parameter Types of DataSource Controls
|
| ControlParameter |
Gets the value from any public property of the server control.
|
| FormParameter |
Gets the value of any input field from the form.
|
| QueryStringParameter |
Gets the value from specified querystring.
|
| Parameter |
Gets the parameter value assigned in the code.
|
|
Other Properties of SqlDataSource Control
|
| ProviderName |
Gets or sets the .NET ProviderName name.
|
| DataSourceMode |
DataSet/DataReader. Used to specify the data source mode.
In case of DataReader paging is not supported in the target control (GridView etc.).
|
| ConnectionString |
Gets or sets the connection string to connect to the database.
|
| ConflictDetection |
CompareAllValues/OverWriteChanges. Used to determine how conflict will be handled in case of updation or deletion of the records.
|
|
Caching Properties of SqlDataSource Control
|
| EnableCaching |
true/false. Used to indicate whether enable caching or not.
|
| CacheDuration |
Used to indicate number of seconds the data shoud be maintained in the cache.
|
| CacheExpirationPolicy |
Absolute/Sliding. Used to indicate if the cache policy is absolute or sliding.
Absolute: The data is removed after specified duration. Sliding: The data is removed if it is not used for specified duration.
|
| EnableCaching |
true/false. Used to indicate whether enable caching or not.
|
|
DEMO : SqlDataSource
|
Show Source Code
|
| AutoID | 13360 |
| Name | |
| Address | |
| Phone | |
| City | |
|
|
|
// DetailsView Control ///////////////////////////////
<asp:DetailsView ID="DetailsView1" runat="Server" CellPadding="4" ForeColor="#333333" GridLines="None"
Width="100%" DataSourceID="SqlDataSource1" AllowPaging="True" AutoGenerateRows="True" DataKeyNames="AutoID">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
<EditRowStyle BackColor="#999999" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:DetailsView>
// SqlDataSource Control ///////////////////////////////
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStrings:ConnStr %>'
SelectCommand="Select * FROM SampleForTutorials ORDER BY [Name]" DataSourceMode="DataSet">
</asp:SqlDataSource>
|