Retrieving Data from a SQL Server 2005 Database Using the SQL DataSource Control in ASP.NET 2.0
page 1 of 4
Published: 09 Jan 2007
Abstract
In this article Jayaram demonstrates how to retrieve data from a SQL Server 2005 Database using the SQL DataSource Control in a step-by-step manner.
by Jayaram Krishnaswamy
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 22961/ 24

Introduction

SQL Data source control together with other data controls hide most of the hardwiring needed for connecting to and retrieving data from the server by presenting simplified higher level features. Sql Data Source Control together with the GridView data aware control makes data access possible without writing a single line of code. Smart Tags, a new feature available for ASP.NET 2.0, makes this process all the more easier. This article describes the easy route that Microsoft has charted for its beloved users to connect and get the data from SQL Server 2005 to their applications.


View Entire Article

User Comments

Title: sem   
Name: semtjo
Date: 2012-07-23 1:38:28 PM
Comment:
hai test server
Title: sdds   
Name: asdas
Date: 2012-05-29 8:52:13 AM
Comment:
asdasdas
Title: Retirve Data on Lost Focus in ASP.NET   
Name: jaypal
Date: 2011-12-02 11:16:15 PM
Comment:
I need to retrive data from SQLServer on lost focus of textbox or on Selected index change of Dropdownlist box...plz help
Title: Retirve Data on Lost Focus in ASP.NET   
Name: Shekhar Shete
Date: 2011-03-28 1:53:58 AM
Comment:
I need to retrive data from SQLServer on lost focus of textbox or on Selected index change of Dropdownlist box...plz help
Title: retrive data from sql server 2005 in c#code   
Name: Shwetha
Date: 2011-03-14 12:51:38 AM
Comment:
public void AddBrand()
{
DataServiceProvider dataServiceProvider = DataServiceProvider.Instance;
dataServiceProvider.GetData(..............)
}

this is my code.what do i need to write in...........space.
Title: Very Informative   
Name: Vamsee
Date: 2010-05-07 1:16:59 PM
Comment:
This is an excellent,informative article for Novices.
Title: hi   
Name: vani
Date: 2010-04-09 4:15:16 PM
Comment:
How can i get user details from SQL database to C#.net pages and store the in session varibles
Title: hi iam new 2 .net   
Name: vivek
Date: 2009-11-11 6:47:28 AM
Comment:
can u give me the guidence that how learn .net from basic
Title: how can i make manual drop down list connect to the DB   
Name: waleed
Date: 2009-05-17 2:53:54 AM
Comment:
I have a problem that i want to make send data by the drop down list to the table in data base but i can't do that

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-28 3:01:42 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search