I added this Session("TypeNameDataSet") = TypeName(objDataSet)
and it prints out
TypeNameDataSet = DataSet
whether it returns no records or has records.
-----Original Message-----
From: Mike Belcher [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 6:58 PM
To: [email protected]
Subject: RE: [AspNetAnyQuestionIsOk] CHecking if a returned dataset or table
is null
I got the trace information to display but there is a ton of information
that is returned. What am I looking for and how can I get the typename I am
not sure were to look. Huge listing.
-----Original Message-----
From: Charles Carroll [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 6:17 PM
To: [email protected]
Subject: Re: [AspNetAnyQuestionIsOk] CHecking if a returned dataset or table
is null
<%@ trace="true"%>
or add trace="true" to <[EMAIL PROTECTED] .... %> if already there.
You really need to read
http://www.learnasp.com/freebook/learn/debug1.aspx
http://www.learnasp.com/freebook/learn/debug2.aspx
Trace is your friend along with typename.
ASP.net without trace is rough going. Trace illuminates all things and
times all things.
On Apr 4, 2005 5:58 PM, Mike Belcher
<[EMAIL PROTECTED]> wrote:
> I tried that but nothing prints out. Is there a way to response.Write the
> results?
>
> -----Original Message-----
> From: Charles Carroll [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 04, 2005 4:26 PM
> To: [email protected]
> Subject: Re: [AspNetAnyQuestionIsOk] CHecking if a returned dataset or
> table
> is null
>
>
> On Apr 4, 2005 4:12 PM, Mike Belcher
> <[EMAIL PROTECTED]> wrote:
> > Im still confused a little. I tried the below but it Doesn't work. It
is
> > probably easy for one of you masters of .Net on here.
> >
> >
> > 'Create a DataSet
> > ----------------------------------------
> > Dim objDataSet As New DataSet
> > 'Create a DataSet
> > ----------------------------------------
> >
> > 'Create a DataAdapter
> > ------------------------------------
> > Dim objDataAdapter As SqlDataAdapter
> > objDataAdapter = New SqlDataAdapter(strSQLstring, objConn)
> > objDataAdapter.Fill(objDataSet, "users")
> > 'Create a DataAdapter
> > ------------------------------------
>
> trace.warn("typename of
> objDataSet",typename(objDataSet))
>
> > If Not objDataSet.Tables.Count = 0 Then
> > Session("SQLstring") = strSQLstring
> >
> > Else
> > Session("SQLstring") = "NoRecords"
> >
> > End If
>
> and now you can design an IF statement or CASE based on the typename
> results once you see what typename an empty dataset looks like.
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> ________________________________
> 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 the Yahoo! Terms of Service.
Yahoo! Groups Links
Yahoo! Groups Links
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/
