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
<*> 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/
