RE: Error Message: Operator is not valid for type 'DBNull' and string "0".

Carlos Muniz — Fri, 28 Oct 2005 09:38:43 GMT

Dear Graber,

It seems that some rows in the InstantKb_Articles table has null in the ArticleType column. Could you please run the following command on your database?

Update InstantKB_Articles Set ArticleType = 'INFO: ' where ArticleType is Null.

Error Message: Operator is not valid for type 'DBNull' and string "0".

graber — Tue, 18 Oct 2005 16:02:13 GMT

When trying to do an artical serch from the admin login, I receive this error. As far as I know nothing has changed on the system and it used to work ok. All other functions appear ok. Below is the latest contents of the exceptions.config file which the error says to send to support to debug this.

Any suggestions?

Thanks!

<Exception>
<Message>Operator is not valid for type 'DBNull' and string "0".</Message>
<Source>Microsoft.VisualBasic</Source>
<StackTrace> at Microsoft.VisualBasic.CompilerServices.ObjectType.ThrowNoValidOperator(Object obj1, Object obj2)
at Microsoft.VisualBasic.CompilerServices.ObjectType.ObjTst(Object o1, Object o2, Boolean TextCompare)
at InstantKB.InstantKB_AdminUpdate.ArticleGrid_ItemDataBound(Object Sender, DataGridItemEventArgs e)
at System.Web.UI.WebControls.DataGrid.OnItemDataBound(DataGridItemEventArgs e)
at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource)
at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.BaseDataList.DataBind()
at InstantKB.InstantKB_AdminUpdate.BindQuestionData()</StackTrace>
<AppPath>http://wenco3/instantkb13/</AppPath>
<URI>/instantkb13/admin/update.aspx</URI>
<DateTime>10/18/2005 11:48:41 AM</DateTime>
</Exception>
</ExceptionLog>

InstantASP Community Forums / Old Forums / InstantKB.NET 1.x / Installation / Update / Error Message: Operator is not valid for type 'DBNull' and string "0". / Latest Posts

RE: Error Message: Operator is not valid for type 'DBNull' and string "0".

Error Message: Operator is not valid for type 'DBNull' and string "0".