Binding SqlDataReader to webcomponents

Why is SqlDataReader not present in visual studios Toolbox->Data where
I find components like DataSet? Most examples in books and in vs.net
are based on datasets but using disconnected tables seems a bit
heavyweight for most purposes. I there some particular reason to stay
away from sqldatareader??
I have managed to bind components using sqldatareader but digging up
the
information was quite hard.

Nov 18 '05 #1

Subscribe Post Reply

1413

Mark Jen [MSFT]

There is no particular reason to stay away from SqlDataReader. IMHO, I
always use SqlDataReader if I have controls that cause autopostback because
using DataSet causes my ViewState to become extremely large. If you are
simply querying a database and spitting the results straight into a control
without doing any processing, then I would recommend SqlDataReader. If you
want to manipulate the data post-query (sort, filter, etc.), then DataSet
would be the way to go.

HTH,
Mark Jen [MSFT]
--
Please reply in newsgroup.
This posting is provided "AS IS" with no warranties, and confers no rights.
"me" <wt*****@forum.dk> wrote in message
news:6f**************************@posting.google.c om...

Why is SqlDataReader not present in visual studios Toolbox->Data where
I find components like DataSet? Most examples in books and in vs.net
are based on datasets but using disconnected tables seems a bit
heavyweight for most purposes. I there some particular reason to stay
away from sqldatareader??
I have managed to bind components using sqldatareader but digging up
the
information was quite hard.

Nov 18 '05 #2

Similar topics

visible properties of all webcomponents

by: Murali | last post by:

We r using a single aspx page for insertion ,updation and deletion of data.In each cases we want to hide a lot of web components in a single form.Now we r hiding each component using the visibility...

ASP / Active Server Pages

Binding a DropDownList to a cell in a grid...

by: rmorvay | last post by:

I am trying to dynamically build a dropdownlist and bind it to a cell in a grid. I tried to utilize the following code but I am stuck at the point where I bind the dropdownlist to the grid cell. ...

C# / C Sharp

binding data to a radiobuttonlist within an ItemTemplate

by: ani | last post by:

Hi, I have a datalist control and within the Itemplate I have a radiobuttonlist control . I am binding data to the datalist control in Page_load . Also I have sqldatareader object that needs...

ASP.NET

binding to datagrid from code behind page.

by: mike | last post by:

I'm having a problem with binding my sqldatareader to my datagrid in my asp .net page. Below is my code in the page_load section of the code behind page: Dim oCon2 As SqlClient.SqlConnection...

ASP.NET

DropDownList Data Binding

by: Joe Delphi | last post by:

Hi, I am attempting to bind a dropdown list to a SQLDataReader My code looks like this: Dim DBComm As New SqlCommand Dim DBReader As SqlDataReader DBComm.Connection = DBConn...

ASP.NET

Data not binding to datalist

by: Laura K | last post by:

I am having difficulty binding data to my datalist. The data list does not show. I have gone round and round for two days. I could really use some help looking through this code and seeing where...

ASP.NET

Binding object method to Dataview.. Not understanding List<GENERIC> ..

by: webmaster | last post by:

Pardon my being a total C# noob. I'm trying to take apart the dotNet Time Tracker dotNet C# starterkit sample application and replicate a part of the code. At a high level, I have a very...

C# / C Sharp

binding multi-table datareader

by: js | last post by:

I am using executeReader to get a SqlDataReader as in my code below. The SqlDataReader contains two tables. I am trying to bind each table to its respective dropdown list control. Thanks. ...

ASP.NET

ddl binding

by: brettokumar | last post by:

hi i am binding values from database to ddl through sqldatareader records are binding in my dripdownlist but my first record is dosen't bind i.e if i have 4 records in my table. ddl is binding...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General