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

Post New Web Links

Operator '=' is not defined for type 'DBNull' and string "REJECTED".

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :ASP.Net


I know that the problem is my field having NULL values. However, I don't know how to have it process the code even if the field have nulls

here's my code:

 Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

        If e.Row.RowType = DataControlRowType.DataRow Then
            Select Case DataBinder.Eval(e.Row.DataItem, "userStatus")
                Case "REJECTED"
                    e.Row.ForeColor = Drawing.Color.Red
                    e.Row.Font.Bold = True
                Case "ACCEPTED"
                    e.Row.ForeColor = Drawing.Color.Green
                Case Is = vbNullString
                    e.Row.ForeColor = Drawing.Color.Red
            End Select
            Select Case DataBinder.Eval(e.Row.DataItem, "Status")
                Case "Editing"
                    ' e.Row.Font.Bold = True
                    e.Row.Cells(6).ForeColor = Drawing.Color.DarkOrange
                Case "Active"
                    ' e.Row.Font.Bold = True
                    e.Row.Cells(6).ForeColor = Drawing.Color.DodgerBlue
            End Select
        End If
    End Sub

View Complete Post

More Related Resource Links

Operator '>=' cannot be applied to operands of type 'string' and 'string'


I want to compare two lebel text , but i am getting this error..

Compiler Error Message: CS0019: Operator '>=' cannot be applied to operands of type 'string' and 'string'

Source Error:

Line 39:         Label2.Text = DateTime.Now.AddDays(7).ToString("MM/dd/yyyy");
Line 40: Label3.Text = DateTime.Now.ToString("MM/dd/yyyy");
Line 41: if (Label2.Text>=Label2.Text)
Line 42: {

plz reply me ...how can i compare greater than and greater than equal to values of labels...


Unable to cast object of type 'System.DBNull' to type 'System.String'.


 I saw lots of post about this issue. but haven't got good solution for that yet. Basically, what I did is that: I have a table in SQL database and some of data fields allow null. I built Objectdatasource through dataset. When I built update page using dataset. It generate the following error before showing the update page correctly. It seems I have issue to retrieve the null value from the database through using objectdatasource through dataset. Any suggestions?




Error attached below:

Unable to cast object of type 'System.DBNull' to type 'System.String'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.

Source Error:

Line 1178:            get {
Line 1179:                try {
Line 1180:                    return ((string)(this[this.tablemember.CurrentCityStateColumn]));
Line 1181:                

How do I handle Conversion from type 'DBNull' to type 'String' is not valid


help i am getting error :

Conversion from type 'DBNull' to type 'String' is not valid

Dim OledbString As String = ("SELECT  Product_Hierarchy,Model,Origin,Item_Code,Description,Price_USD FROM [sheet1$]")
                    'Dim eAdapter As New SqlDataAdapter(sqlString, connection)
                    Dim eAdapter As New OleDbDataAdapter(OledbString, connection)
                    Dim eTable As New DataTable()

Dim i As Integer = 0
                    While (i < eTable.Rows.Count)
                        If ((eTable.Rows(i)(0)).ToString().Tri

The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must



This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'.


On web.config I already have this:
<add assembly="System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?


"Type ASP.x is not defined" error for dynamic user control when publishing updateable


I have a user control (ContainerCtrl) which programmatically instantiates another user control (SimpleCtrl) in OnLoad. It builds and runs fine, but when I publish it I get the error "error BC30002: Type 'ASP.SimpleCtrl' is not defined." (If I publish without the "updateable" option there's no error, but I need the site to be updateable.)

I assume this has to do with the particulars of how the assembly(ies) are built for the different compiler options. My question is, how can I get it to work properly for "updateable" publishing?

VS 2008 / .NET 3.5 sp1

The code follows (web.config is the default from Visual Studio).

Many thanks, Dave


<%@ Control Language="VB" ClassName="SimpleCtrl" CodeFile="SimpleCtrl.ascx.vb" Inherits="_SimpleCtrl" %>

    Simple control


Partial Class _SimpleCtrl
    Inherits UserControl

    'Nothing to see here.

End Class


<%@ Control Language="VB" CodeFile="ContainerCtrl.ascx.vb" Inherits="_ContainerCtrl"

BC30506: Handles clause requires a WithEvents variable defined in the containing type or one of its


why do i get

BC30506: Handles clause requires a WithEvents variable defined in the containing type or one of its base types.

with the code

 below ..thanks


<form id="form1" runat="server">
               <asp:Button ID="Button1" runat="server" Text="Run Access" />
In your code behind:

Conversion from string to type 'Date' is not valid



Im receiving a strange error Error Message: Conversion from string "15/08/2010 22:21:35" to type 'Date' is not valid.

I know this is generally down to cultural date formats etc, however the reason this is strange is it just randomly occured twice in the last week, the website has been running since october and nothing has changed,

The error constantly occured until the IIS was reset and recompilled the site, its been running fine since, however im just trying to figure out what could cause such an error to occur.

I've narrowed it down to a line of code which is:

bktime = DReader.Item("Bktime").ToString

bktime = Year(CDate(bktime)) & "-" & fmt(Month(CDate(bktime)), 2) & "-" & fmt(Day(CDate(bktime)), 2)

Has anyone else encountered this randomly occuring and is there anything i can put in place to prevent this in future?



Creating a table-valued function on a user defined type in SQL Server CLR

We would like to be able to create a table-valued function on a user defined type.  We would like the syntax in SQL to look like it works for the XML nodes function:   DECLARE @myXml XML = '<a><b>1</b><b>2</b><b>3</b></a>' ; SELECT  node.query('text()') FROM    @myXml.nodes('a/b') nodes (node) ;   In other words, in the FROM clause, we can access the "nodes" method of the xml variable and it returns a rowset. Thanks!

User Defined Data Type - using SMO *** NEED HELP ! ***

Hi,Is it possible to script out the User Defined Data Types via SMO in .NET and specifically VB.Net?  I have not been able to find some examples on how to do this.  If you have some experience with this, pleasepost some examples or provide links where I can find this information.Thank you in advance.-Sydney

how to include a user defined table type as input for stored procedure

Hi ,  I have a user defined table type which i need to pass as input parameter to the stored procedure .How can i do that?

//Operator '+' cannot be applied to operands of type 'L' and 'L'

  public L Mymethod<L>(L mydate, L myname) {   //it is getting following errro   //Operator '+' cannot be applied to operands of type 'L' and 'L'   return (myname+myname); }   Can any one give me help how to solve following error

Java - Type not defined error with ReportViewerWebControl.axd

I've been searching for several days now looking for threads / solutions in regards to a Report Viewer Problem. OS - Windows Server 2008 all updates installed DN FW - 3.5SP1 and 4.0 ReportViewer.exe was and is installed (Version 10.0.30319.1) The ReportViewer Assemblies are in the GAC The project is a Visual Studio 2010 project The application is running in it's own App Pool with the 4.0 framework in integrated mode In order to pin this down I have reduced a test project to an empty page with a Report Viewer Control and a Button. There is no DataSource and no report associated with the viewer, just the empty viewer control. The web application runs without errors on my dev box and on a new test environment (with the Web Server in a VM) that I set up to test with. When I deploy to our test or staging servers the page fails with Java Script errors. The error that is the root cause is "Type is undefined" which is referring to Reserved.ReportViewerWebControl.axd.  When using the developer tools for IE the script is loaded but fails at Line 1 of the script Type.registerNamespace("Microsoft.Reporting.WebFormsClient"); with the message Type is undefined.   'Type' ist undefiniert  Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=10.0.30319.1&Name=ViewerScript, Zeile 1 Zeichen 1 When I call the ReportViewerWebCont

Conversion from type 'TextBox' to type 'String' is not valid

I have a FormView that allows a user to register for a company event. I want to do a couple of things with this form. 1. I need to write this data to a MS SQL database 2. I need to send an email confirmation of their registration to their email. I know how to do both of these things, but i am having trouble doing both at the same time. It would be nice if I could do it in one click, but I coded it into two pages to try to help simplify it. The first page allows the user to input their information into a formview and when they click the submit button, it places those answers into session variables:Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Session("FirstName") = Me.FormView1.FindControl("FirstName") Session("LastName") = Me.FormView1.FindControl("LastName")  <li> <label> First Name</label> <asp:TextBox ID="FirstName" runat="server" class="text-box" Text='<%# Bind("FirstName") %>' /> </li> </ul> </div>

infopath 2007 Expected value type: end-of-string ! calculated field

Hello I am using infopath since there is no field with type date and time in InfoPath 2007. I created three fields one for date one, for hours, and one for minutes then I created forth field that concatenate the values of the three fields this field will be used as column in form template library used by my form. All seems good so far but when I tried to concatenate those fields go the following error Expected value type: end-of-string how can I solve this ? my xpath looks like ../my:calmomoDate../my:cbmomoHours:../my:cbmomoMunites Thanks  Momo

Error: "Type 'System.Web.UI.UpdatePanel' is not defined"?

Can anybody tell me why I'm getting this error on the first line of all my aspx pages? The lines have a blue squiggly line underneath them:<%@ Page Language="VB" Debug="true" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> Error: Type 'System.Web.UI.UpdatePanel' is not defined 

Weird Issue with the MOSS Search : FileExtension metadata object type instead of string

Hello, We 've got a strange issue with the search and especially with the FileExtension metadata. when we make a query on the search engine, we receive for the FileExtension metadata an unexcpected result. here is a printscreen showing the issue. http://cid-53eee937847a625e.photos.live.com/self.aspx/Public/Untitled.jpg as you can see the Type of the FileExtension is object and it should be string and I checked the type of the object and it's System.String[] the element at the index 0 contains the value! what's wrong ? thx in advance


Hi all,Here's some simple code<a href='<%= string.Format("../Print/Print1.aspx?withParameter={0}", Para )%>'>HyperLinkText</a>and it works well. so i guess i can write anything like this, so i wrote a test:<input type="button" value="Btn1" onclick='<%= string.Format("window.open('','_blank')") %>'/> <input type="button" value="Btn2" onclick="window.open('','_blank')"/>However, Btn1 does not work.. for some reason i have to NOT to use server control, so i wite it in inline-code style,why the first hyperlink work well, but Btn1 fails?could anyone tell me?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