actually I'm getting the data and everything is all right when the data is
less than 150.000 but if more it doesn't show in the grid and I'm thinking
using the dataview is the problem!! here is the code
string SQLSearchText = "select here" ;
DataAdapter.SelectCommand = new sCommand(SQLSearchText, connection);
DataAdapter.Fill(dataset, "SearchResult");
myDataView.Table = dataset.Tables["SearchResult"];
myGrid.DataSource = myDataView;
[quoted text, click to view] "chanmm" wrote:
> Yes, I have received from SQL 2005 more than 300000 records fine just that
> it take a bit of time.
> Can you should me your code?
>
> chanmm
>
> "Badis" <Badis@discussions.microsoft.com> wrote in message
> news:7627AD84-AF2B-4AFA-AACC-76D56065C452@microsoft.com...
> > Do U mean 3000000 record!!?
> > So, what could be wrong in my code because I'm getting the data from
> > DataSet
> > into DataView then from dataview into my grid?
> >
> >
> >
> >
> > "chanmm" wrote:
> >
> >> Oops, I miss one zero but guess what I add another zero at the back it is
> >> still alive though ;-)
> >>
> >> chanmm
> >>
> >> "Marc Gravell" <marc.gravell@gmail.com> wrote in message
> >> news:OcESrad$GHA.4892@TK2MSFTNGP04.phx.gbl...
> >> > Well, 154161 is a bit bigger than 30000...
> >> >
> >> > However, for large sets like this, you (the OP) may wish to consider
> >> > looking into "virtual mode", and fetch the data as you need it. I'm not
> >> > aware of any physical limitation here, but being realistic there is a
> >> > limit to what it is sensible to push into any UI.
> >> >
> >> > Marc
> >> >
> >>
> >>
> >>
>
>