You can Page with only a DataTable which views a LOT LESS than a Dataset.
Function DataTableMaker(strConn as string,strSQL as string) as datatable
Dim dt1 As New DataTable("temp")
Dim conn As New SqlConnection(strConn)
Dim adapter As New SqlDataAdapter(strSQL, conn)
adapter.Fill(dt1)
Return(dt1)
End Function
On 9/16/05, sas0riza <[EMAIL PROTECTED]> wrote:
> Thanks for the links. But I thought when you use paging in a
> datagid, you need to use a dataset?!
>
>
> --- In [email protected], Charles Carroll
>
> <[EMAIL PROTECTED]> wrote:
> > #1
> > A sample like
> > Function GetCardholderByFirst(ByVal firstName As String) As
> > System.Data.DataSet
> > ...
> > Dim dataAdapter As System.Data.IDbDataAdapter = New
> > System.Data.SqlClient.SqlDataAdapter
> > dataAdapter.SelectCommand = dbCommand
> > Dim dataSet As System.Data.DataSet = New
> > System.Data.DataSet
> > dataAdapter.Fill(dataSet)
> > Return dataSet
> > End Function
> >
> > is 25-60 x slower than the using a DataReader to return the data
> and bind
> > it. JUST SAY NO TO DATASETS TO FILL THINGS!
> >
> > http://learnasp.com/freebook/learn/dbopensqlserver.aspx
> > shows you model for code based on a DataReader
> >
> > Function GetCardholderByFirst(ByVal firstName As String) As
> > System.SQLClient.SQLDataReader
> > ...
> >
> > Dim Rdr as SQLDataReader
> > Rdr=dbCommand.ExecuteReader()
> >
> > Return Rdr
> > End Function
> >
> > #2
> > Dynamic Search building SQL Example is @
> > http://learnasp.com/freebook/learn/searchertypical.aspx
> >
> > #3
> > Close Connections and Readers in a FINALLY and use error trapping
> > http://learnasp.com/freebook/learn/dbopensqlserver.aspx
> > will show you how
> >
> >
> > On 9/16/05, Anna Leon <[EMAIL PROTECTED]> wrote:
> > >
> > > That is all of the code. I didn't set anything (values) before
> the search
> > > button is pushed. And I know I should have one set of control
> and one
> > > function, but I am not sure how to write code to dynamically
> build the SQL
> > > depending on the parameters provided. Can you provide some
> guidance?
> > >
> > > Thanks.
> > >
> > >
>
> > > Dean Fiala <[EMAIL PROTECTED]> wrote:
> > > You seem to have two sets of controls, lname, fname, and lname2,
> fname2.
> > >
> > > And 2 search buttons, and lots of duplicated code, this makes it
> confusing
> > >
> > > to read and debug.
> > >
> > > Have you tried setting a break point and stepping through the
> code and
> > > seeing what path is getting followed?
> > >
> > > There also appears to be code missing here, because from your
> description
> > > of
> > > the problem something is getting set before the search button is
> pushed.
> > > Are
> > > you setting the values for any of the controls elsewhere?
> > >
> > > The first thing I would do is get down to one set of controls
> and one
> > > search
> > > button.
> > > Then I'd write one function called
> > >
> > > GetCardHolder(firstname as string, lastname as string)
> > >
> > > In this function you dynamically build your SQL depending on
> which parm(s)
> > >
> > > have been supplied (ideally you shoud have all your SQL in a
> stored proc,
> > > but that's an issue for another day). This will get all your
> data access
> > > code in one function and make it easier to see what's happening.
> Won't
> > > solve
> > > your problem, but will make it easier to get a handle on where
> it is.
> > >
> > >
> > >
> > > --
> > > Dean Fiala
> > > Very Practical Software, Inc
> > > http://www.vpsw.com
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > SPONSORED LINKS
> > > Basic programming language Computer programming languages
> Programming
> > > languages Java programming language The history of computer
> programming
> > > language
> > >
> > > ---------------------------------
> > > YAHOO! GROUPS LINKS
> > >
> > >
> > > Visit your group "AspNetAnyQuestionIsOk" on the web.
> > >
> > > To unsubscribe from this group, send an email to:
> > > [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
> > >
> > >
> > > ---------------------------------
> > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > SPONSORED LINKS
> > > Basic programming language<http://groups.yahoo.com/gads?
> t=ms&k=Basic+programming+language&w1=Basic+programming+language&w2=Co
> mputer+programming+languages&w3=Programming+languages&w4=Java+program
> ming+language&w5=The+history+of+computer+programming+language&c=5&s=1
> 76&.sig=clJRDppRYABhs6xUhzokKw> Computer
> > > programming languages<http://groups.yahoo.com/gads?
> t=ms&k=Computer+programming+languages&w1=Basic+programming+language&w
> 2=Computer+programming+languages&w3=Programming+languages&w4=Java+pro
> gramming+language&w5=The+history+of+computer+programming+language&c=5
> &s=176&.sig=RiWZhYTiihJ1rWfeFgB2sg> Programming
> > > languages<http://groups.yahoo.com/gads?
> t=ms&k=Programming+languages&w1=Basic+programming+language&w2=Compute
> r+programming+languages&w3=Programming+languages&w4=Java+programming+
> language&w5=The+history+of+computer+programming+language&c=5&s=176&.s
> ig=2BgLsjKfGvxPndstKBMU9g> Java
> > > programming language<http://groups.yahoo.com/gads?
> t=ms&k=Java+programming+language&w1=Basic+programming+language&w2=Com
> puter+programming+languages&w3=Programming+languages&w4=Java+programm
> ing+language&w5=The+history+of+computer+programming+language&c=5&s=17
> 6&.sig=4wWSX5WKx7BCK9SrMVdrxQ> The
> > > history of computer programming
> language<http://groups.yahoo.com/gads?
> t=ms&k=The+history+of+computer+programming+language&w1=Basic+programm
> ing+language&w2=Computer+programming+languages&w3=Programming+languag
> es&w4=Java+programming+language&w5=The+history+of+computer+programmin
> g+language&c=5&s=176&.sig=iNvYp6cfd9HwtDhK1iV-rg>
> > > ------------------------------
> > > YAHOO! GROUPS LINKS
> > >
> > >
> > > - Visit your
> group "AspNetAnyQuestionIsOk<http://groups.yahoo.com/group/AspNetAnyQ
> uestionIsOk>"
> > > on the web.
> > > - To unsubscribe from this group, send an email to:
> > > AspNetAnyQuestionIsOk-
> [EMAIL PROTECTED]<AspNetAnyQuestionIsOk-
> [EMAIL PROTECTED]>
> > > - Your use of Yahoo! Groups is subject to the Yahoo! Terms
> of
> > > Service <http://docs.yahoo.com/info/terms/>.
> > >
> > >
> > > ------------------------------
> > >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
>
>
>
> SPONSORED LINKS
> Basic programming language
> Computer programming languages
> Programming languages
> Java programming language
> The history of computer programming language
>
>
> ________________________________
YAHOO! GROUPS LINKS
>
>
> Visit your group "AspNetAnyQuestionIsOk" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> ________________________________
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
