[SqlException (0x80131904): Invalid operator for data type.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

[SqlException (0x80131904): Invalid operator for data type.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-06 : 09:19:35

Amoako writes "Please,

i get the following message whenever i try populating my Gridview:

[SqlException (0x80131904): Invalid operator for data type. Operator equals boolean AND, type equals varchar.]

i'm using vb2005 with vb code.

this happens whenerver i click a command button to the ff code in asp.net

Protected Sub CmdSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CmdSearch.Click

Dim myConnString As String = "Data Source=yaw\zenith;Initial Catalog=ClubDVD;Integrated Security=True"
Dim MyConnection As New SqlConnection(myConnString)

Dim strCmdText As String
Dim MyDataAdapter As SqlDataAdapter
Dim MyDataSet As New DataSet()
Dim strCriteria As String
Dim strType As String
strType = FirstSearch.SelectedItem.Text

Select Case strType
Case "Actor"
strCriteria = " Where Actor.First_Name+Actor.Last_Name Like'%" + txtSearch.Text + "%'"
Case "Director"
strCriteria = " Where Director.First_Name+Director.Last_Name Like'%" + txtSearch.Text + "%'"
Case "Producer"
strCriteria = " Where Producer.Name Like'%" + txtSearch.Text + "%'"
Case "Movie"
strCriteria = " Where Movie.Movie_Title Like'%" + txtSearch.Text + "%'"
End Select

strCmdText = "SELECT Distinct Movie.Movie_ID, Movie.Movie_Title,Video.Format, Actor.First_Name +' '+Actor.Last_Name AS Actor, Di" & _
"rector.First_Name +' '+ Director.Last_Name AS Director, Producer.Name AS Producer" & _
" FROM Actor INNER JOIN ActorMovie ON Actor.Actor_ID = ActorMovie.Acto" & _
"r_ID INNER JOIN Movie ON ActorMovie.Movie_ID = Movie.Movie_ID INNER JOIN Director ON Mo" & _
"vie.Director_ID = Director.Director_ID INNER JOIN Producer ON Movie.Producer_ID = Producer.Producer_ID INNER JOIN Video ON Movie.Movie_ID = Video.Movie_ID" & _
"" + strCriteria

MyDataAdapter = New SqlDataAdapter(strCmdText, MyConnection)
MyDataAdapter.Fill(MyDataSet)
GridView1.DataSource = MyDataSet
GridView1.DataBind()

End Sub

Please help me out"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-06-06 : 14:23:18

In Visual Basic, you use "&" as string concatenator, not "+".

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources