SQL String returning Cast Exception based on boolean value??

jaycast · Feb 2, 2005

I'm trying to fill a datagrid (in VB.NET) based on a SQL String that is determined by a parameter value passed from another page. All SQL String values work fine except the second one shown below:
Public Sub FillSongGrid()
Dim cnn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\web\tizmoretcom\htdocs\_database\funkytizdb.mdb")
Dim strSQL As String
Dim variable As String = Request.QueryString.Item("Type")

Select Case variable
Case "EC"
Me.Label1.Text = "CURRENT ENGLISH SONGS"
strSQL = "SELECT SongName, Arranger, SoundByteURL FROM tblSongs Where Language] = 'ENGLISH' and [Current] = True"
Case "EY"
Label1.Text = "ENGLISH SONGS OF YESTERYEAR"
strSQL = "SELECT SongName, Arranger, SoundByteURL FROM tblSongs Where[Language] = 'ENGLISH' and [Current] = False"
Case "HC"
Label1.Text = "CURRENT HEBREW SONGS"
strSQL = "SELECT SongName, Arranger, SoundByteURL FROM tblSongs Where [Language] = 'HEBREW' and [Current] = -1"
Case "HY"
Label1.Text = "HEBREW SONGS OF YESTERYEAR"
strSQL = "SELECT SongName, Arranger, SoundByteURL FROM tblSongs Where [Language] ='HEBREW' and [Current] = 0"
End Select
Response.Write(strSQL)
cnn.Open()
Dim cmd As New OleDbCommand(strSQL, cnn)
Dim dr As OleDbDataReader
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
dgSongs.DataSource = dr
dgSongs.DataBind()
dgSongs.Visible = True
cnn.Close()
End Sub</CODE>For some strange reason, I keep getting the same Stack Trace Error:

Type mismatch. 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: Type mismatch.

Source Error:
Code:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
Code:
[InvalidCastException: Type mismatch.]
   Microsoft.VisualBasic.Strings.Len(Object Expression) +289
   tiz_main.songs.SetHyperLinkColumnProps(Object sender, DataGridItemEventArgs e) in C:\Documents and Settings\Jason Castellano\VSWebCache\[url]www.tizmoret.com\tiz_main\songs.aspx.vb:37[/url]
   System.Web.UI.WebControls.DataGrid.OnItemDataBound(DataGridItemEventArgs e) +110
   System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource) +181
   System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) +1411
   System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +49
   System.Web.UI.WebControls.BaseDataList.DataBind() +23
   tiz_main.songs.FillSongGrid() in C:\Documents and Settings\Jason Castellano\VSWebCache\[url]www.tizmoret.com\tiz_main\songs.aspx.vb:73[/url]
   tiz_main.songs.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\Jason Castellano\VSWebCache\[url]www.tizmoret.com\tiz_main\songs.aspx.vb:30[/url]
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750
This seems to be pretty straight forward. I change the False to True and it processes fine. I can't see how one boolean variable can totally alter the command/connection.

Any ideas?

Also, how can I better "read" the stack trace file so I can figure out on my own where the problem is coming from. I don't see any real errors, just a bunch of gobbledygook.
</CODE>
Click to expand...

Scott · Feb 2, 2005

I think that instead of '[Current] = False', you need '[Current] = 0'

Log in or Sign up

SQL String returning Cast Exception based on boolean value??

jaycast

Scott

Share This Page

Log in or Sign up

SQL String returning Cast Exception based on boolean value??

jaycast

Scott

Share This Page

Useful Searches