Fetch and Present Data with SqlDataSource

Certify and Increase Opportunity.
Govt. Certified ASP.NET Programmer

Fetch and Present Data with SqlDataSource

Fetching and presenting data with SqlDataSource involves:


  • Connecting to SQL Server Express
  • Finding a copy of the Northwind database
  • Adding the Northwind database to your application
  • Connecting to the database
  • Using the SqlDataSource Control
  • The Command attributes in the markup
  • Consuming Data with the DetailsView Control
  • Using Parameters in Queries
  • Getting a parameter value from a TextBox control
  • Returning the country names with no repeats
  • Filling a drop-down list with data from a SqlDataSource
  • Changing the parameter source
  • Obtaining a parameter from a Session variable
  • Passing a parameter on a query string
  • Creating a Master-Detail Page
  • Designing the page layout
  • Fetching data for the master
  • Fetching data for the details
  • Configuring the GridView and DetailsView controls

Get industry recognized certification – Contact us