C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Code Snippets » Databinding »

Data binding using DataAdapter and Datareader


Posted Date: 06 Aug 2009    Resource Type: Code Snippets    Category: Databinding
Author: Prakash AlamandaMember Level: Gold    
Rating: 1 out of 5Points: 5



Description :


This code shows how to use DataAdapter and Datareader for databinding

Here is the code :

using System.Data.SqlClient // namespace

SqlConnection con = new SqlConnection("Your Database Path") //sql connection
NOTE: You can write this in Web.config or app.config and call to your code behind
SqlCommand command = new SqlCommand("SELECT QUERY", con); //sql command

// Using Data Adapter to bind values from Database
SqlAdapter da = new SqlAdapter(command)
Dataset ds = new Dataset();
da.fill(ds);
combobox1.DataSource = ds;

// Using Data Reader to bind the values from Database
SqlReader rd = command.ExecuteReader();
while(rd.Read() == true)
{
combobox1.items.add(rd["Column Name"].ToString());
}



Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Sign In to add tags.
DataReader  .  DataAdapter  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: How to bind a dropdown list using Sql query
Previous Resource: Read from excel file and display in grid
Return to Discussion Resource Index
Post New Resource
Category: Databinding


Post resources and earn money!
 
More Resources



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use