Basic .NET data extraction question...

[lisbon]

Besides Databinding to Web Controls, how does .NET handle the basics like simply reading from a recordset & Response.Writing onto the page. -I need to place data in obscure areas of a page & cant use a Datagrid or any of the other fancing controls.<BR><BR>Thanks<BR>MarkYou can use a datareader, which is a forward only cursor. It's the fastest, but you can't move but in one direction. Once you have the datareader open you can use while datareader.read and end while to move through the records.ADO.NET does not use the Recordset Object, it uses a Dataset Object. However, if you just want to write data to the page, use an OleDbDataReader. It is faster that using a Dataset. Essentially, it is a streaming dataset, meaning it is read-only and forward-only. Example:<BR><BR>dim objConn as new OleDbConnection(ConfigurationSettings.AppSettings("strConn"))<BR><BR>dim objCmd as new oleDbCommand("SELECT userName FROM tblUsers", objConn)<BR><BR>dim objReader as OleDbDataReader<BR><BR>objConn.Open<BR>objReader = objCmd.ExecuteReader<BR><BR>while objReader.Read<BR> Response.Write(objReader.GetString(0) & "<br/>")<BR>end while<BR><BR>objConn.close<BR>Thanks, is the repeater an example of this?<BR><BR><asp:Repeater id="rptemployees" runat="server"><BR><ItemTemplate><BR> - <%# Container.DataItem("lastname") %> <BR><BR></ItemTemplate><BR></asp:Repeater>I haven't personally used the repeater much, but you should be able to just do a databind to the repeater instead of some sort of loop.<BR><BR>dim dr as sqldatareader<BR>dr = command.executereader<BR>rptemployees.datasource = dr<BR>rptemployees.databind<BR><BR><BR>I haven't personally used the repeater much, but you should be able to just do a databind to the repeater instead of some sort of loop.<BR><BR>dim dr as sqldatareader<BR>dr = command.executereader<BR>rptemployees.datasource = dr<BR>rptemployees.databind<BR><BR><BR><% @Import Namespace="System.Data.OLEDB" %> ?<BR><BR>Because I've tried your snippet with my conn string but get the error msg that the ConnectionString property has not been initializedYes, the OleDbDataReader is part of the System.Data.OleDb Namespace.