Using DataReader

Posted Date: 04 Aug 2009	Resource Type: Code Snippets	Category: ADO.NET
Author: Veerabagu	Member Level: Gold
Rating:	Points: 5

Without Using DataAdapter Fill the DataTable or DataSet using DataReader :

There is facility in .Net Framework that is using DataReader we can fill the data in Datatable and Dataset without using DataAdapter

In this following Example simply I load the data in datagridview using datatable:

Sample Code:


SqlConnection sqlcon = new SqlConnection(“Server=localhost;Database=Miruthula;Integrated Security=SSPI”); sqlcon.Open();

SqlCommand sqlcomm = new SqlCommand(“select * from Riya”, sqlcon);
SqlDataReader sqlread = sqlcomm.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sqlread);
dataGridView1.DataSource = dt;

Note:

If already data is there in Datatable or Dataset Load() method merge the new data with old data without any loss of data.

Happy coding

Responses

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

Feedbacks

Popular Tags

What are tags ?

Search Tags

Without Using DataAdapter Fill the DataTable or DataSet using DataReader .

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: OledbDatareader
	Previous Resource: Relationship in DATAgrid.
	Return to Discussion Resource Index
	Post New Resource
	Category: ADO.NET

Post resources and earn money!

More Resources