I am populating a dataset from a webservice. One one page of my app I need
to get only the first 5 rows from the dataset to pupulate a datagrid and on
another page I then will display all the rows from that dataset in a grid. Is
it possible to select a specific amount of rows ...

I dont know where I am going wrong but the OleDB dataadapter returns data
when it is a simple select statement like "Select * from Customers".
but when i try to do a simple search query like "SELECT * FROM Customers
WHERE LastName LIKE '*something*'", it does not return anything, ...

I'm trying to pass a parameter to a SQL Statement with the LIKE operator but
I'm not having luck on the syntax that I should use here.
I want to retreive the records that match the search criteria input by the
user.

I need to use the ansi nulls in off to compare some register with null using
'=', this is my enviroment:
I call the SP from .net  1.0 object using sqlclient
the SP has in the header the,

Hey all,
   Anyone know when I can get copies of the large posters that MS was
having shipped with so many magazines in the past? I'm looking for any that
may have been created. i.e. the standard framework library, ado.net, web

I'm hoping that somebody can help me with the following:
I have two tables, each of which has its own field holding integers. I would
like to generate a list of the integers that the two fields have in common
(without duplicates). So, for example, if the first table had a list

I have to read bulk data from a non RDBMS to Sql Server
2k.  I tried using Ado.Net with dataAdapter.Fill, where
the app reads in 500,000 records to a dataTable in memory
and then applies dAdapt.Fill to fill a table in sql Server

I am trying to learn ASP.NET while writing a system in it and am
feeling a bit overwhelmed.
I have just read most of a book on ADO.NET. I will need to write a data
access layer for this system and it is more than likely that the data

I am trying to find the difference between two datasets.  I have tried
merging the two datasets and then writing an xml diffgram like so:
   dsA.AcceptChanges();
   dsA.Merge(dsB, true);

I've a large form containing 600 fields (mix of textbox, checkbox,
radiobuttons) i've broken the form in 10 parts (more or less with same
number of fields) using web control, so if you press a button a
particular part (1 of 10) will be loaded.

I'm using ADO.NET and have troubles reading excel formatted data.
leDbDataReader returns DBNull for all the values in the columns in xls
workbook which aren't formatted as "Text"!
I'm using this connection string:

Hi I am using the Visual Studio connection string.  See below
'
'OleDbConnection
'

When I use my Dll in which I defined my dataset the following error
occurs:
Object reference not set to an instance or (in French "Une exception
non gérée du type 'System.NullReferenceException' s'est

Can anybody know how to set alias after 'where'?
select 1 as A, 2 as B,A-B as C from tbl where [B]=1

I have an issue that I just can seem to get past today.  I continually get
the following error:
Invalid attempt to NextResult when reader is closed
This is happening when calling this code, which is our standard block around