.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to check if a Dataview is empty?

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :ASP.Net
I am having trouble with the syntax to check if my Dataview is empty.  If it is empty then the next line when I try draw information from it generates an error. How can I fix this?Dim ProjectDV As DataViewDim arg As New DataSourceSelectArgumentsProjectDV = SqlDataSource1.Select(arg)   If ProjectDV.Count <> 0 ThenpicAd.Text = LCase(ProjectDV(0)("Ad"))End If  

View Complete Post

More Related Resource Links

How to check for null/empty strings on dynamic objects?


What is the proper way to check for null or empty strings on dynamic objects? This is the only solution I've found so far:

if (admin.PasswordHash.GetType() == typeof(DBNull) || admin.PasswordHash == string.Empty)

If the field is null, the object returned is DBNull.Value, but if the field is empty string, it's return as a System.String object. This makes it impossible to do regular "admin.PasswordHash == DBNull.Value" check, as that will fail whenever the field has been set to empty string. Is my example the right (and only) way to go?

How to check if DataTable row is empty



Im using "string user = Database.GetMostRecentReply(id).Rows[0][2].ToString();" to get the username from the most recent reply in my forum.

But how do I check if the row is empty? Im using a try catch at the moment, but there must be a better way to do this.


Dataview filter on querystring parameters - how to return all when empty?




I'm creating a page with a dataview wepart. The dataview is filtered by three querystring parameters. This works fine as long as all parameters are present in the querystring. The parameters currently all have defaultvalue set to "". If one parameter is missing from the querystring, the dataview returns no results (no column values matches "" they all have values). I would like it to return all results if the parameter is not present, does anyone know how to do this?


The dataview is displaying items in a Sharepoint list and currently the filter uses "equals" because I'm filtering on a MultipleLookup field type. 


I would really like to see a wildcard character in CAML like I can use % when I do this for a dataview with a sql server datasource.





When to check if something Is Nothing? How do you check an empty textbox?


I currently do something like...

If TextBox1.Text Is Nothing OR Trim(TextBox1.Text) = "" Then

' Do whatever

End If

Now I know this works.. but what is the right way to have this? I don't want to be checking something twice instead of just having it written out once.

Check for empty array?


How do i check for empty array?


If I write

If Not ls_filename.Length = 0 then


End If


I get object refernce set to null error

Check Empty WebPart Using JQuery


Hi All,

Is it possible to identify a empty webpart in the page?

For e.g, we have an annoucement webPart that has no item, The webpart will display an default OOB Message.

Our Requriement is to identify those empty webpart and hide them. Whether this is possible using JQuery/ Javascript?

Note: Solution should in either in JQuery or Javascript or any those OOB option. We should not do any Coding?

Please let me know whether this is possible?


Ganesh Moorthy S

Check if all members of MeasureGroupMeasures are empty

Is there a way to check if all members of MeasureGroupMeasures are empty in the MDX query?

Javier Guillen

Check Whether the grid view is empty or not



Hello all Members,

I am new to asp.net.

i don't know where to post this issue.

Problem that i am facing is,

I have a grid view bind with LINQdatasource control & i want to check whether it is empty or not.

How do i do this ?

and also, If it is empty, then i have to enable a button control on my form.

Please help me in this issue.

Thanks in advance.


Using trim to check element is empty in jQuery

Using trim method, one can also check element is empty or not.

Using a CompareValidator to check input is a valid date

The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

Check All with JQuery and a Asp.Net GridView

Display a Grid on the screen with a checkbox in each row. At the bottom of the page have "Check All" button.

Typically if I need to do anything interesting I use a template column. So my GridView will look like the one below (most other columns removed for readability). The only interesting point to note is the CssClass="ApprovalCheckBox" in the CheckBox ItemTemplate.

check box control


Hi ,

I have a three check box in my web form ,i need to choose only one check box, if i choose one check box

another 2 check box automatically unchecked

can i use jquery for check box

I thought this would be simple... Trying to create a login does an ajax check before submit


I have the standard .net login control that is working.  (Still learning .net after 15yrs of classic)

What I want to do is OnButtonClick run a javascript function (to do an ajax call to the db to check if login is valid or not) and if it returns true, then submit the form normally, else don't submit. The piece that I can't figure out, is how to correctly override the default click even to hit my JS routine and then submit the form properly afterwards.

Thanks ahead of time

how to check a textbox value in jquery?



I want to perform some action when an asp.net textbox value length is greater than 1 character. And for this I wanted to know how to write this check in jquery?

I have created a check like below-

if ($('[id=txtUserInput]').val().length > 2)
{ do some work...} 

But its giving me the following error

$("[id=txtUserInput]").val() is undefined

Can anybody let me know the right way of doing this?



Automatically redirect to HTTPS and check if SSL is active



I've set in the web.config:

    <!-- User Authentication -->
    <authentication mode="Forms">
      <forms loginUrl="~/Page/View/Content/Login.aspx" timeout="2880" requireSSL="true" />

This works fine. If there is no ssl connection, the login form doesn't continue. But I would like to check if ssl is active (in codebehind) and, if it's possible, to automatically the user to the https page if he's currently on http. (I could do this job by manually redirect with page.response("https://url.../login.aspx"); but this is not really generic. For example if the webapp is moved to another domain it doesn't work anymore... I'm looking for something like: FormsAuthentication.RedirectWithSSL(); or so... :D)


how to check which pages of my site that my visitor visiting at the moment


 Hi all, and thanks a lot for the replies since now. I have a new question :

I prepared a simple instant messaging system for my web site and i would like to learn which visitor (registered member) is at which page of my site. 

For example : 

Uid:10000, Username:donald, NameSurname:Donald DUCK is a registered and signed in visitor.

I need the code which tells me that visitor is at which page (ie. images.aspx?imageid=143223)

Sorry for my poor english, and let me know if i should explain more clearly :)

Have a good evening...

http/localhost is empty


I have Win , I install the following

in Internet Information Service->

Web Management Tools (check)

Application Development Features I check (.Net Extensibility, ASP.net, ISAPIExtensions, ISAPIFilterd,  I can see  IIS Manager under my Administrative tool , but when I call


I  can't see the welcome page , what is wrong

thank you!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend