If your application is a windows application, then you have to use a datatable instead of a datareader, but if its a web application you can use this
DataGrid1.DataSource=myODBCreader
DataGrid1.DataBind()
You can do it using a function
Private Function CheckIfDBNull(ByVal ob as Object) as Integer
If ob Is DBNull.Value Then
return 0
Else
Return Ctype(ob,Integer)
End Function
then you can use this function
row.Item("Future")=CheckIfDBNull(row.Item("Future"))
I sometimes get this error and I'm using .NET Framework 1.1 and vs.net 2003. But I only get this error sometimes only when I'm still developing the page, since I compile and recompile many times...
what do you mean by 'But the problem is I dont know the exact location of this w6.aspx file.' Isn't it in folder3??
you can use this to redirect to it
Response.Redirect("../folder3/w6.aspx")