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: http://docs.yahoo.com/info/terms/
