Hi,
I have three different data types coming out of my SQL tables that I
need to align with my VB code and the data set properties. I'm
getting an error message that reads "SQL exception unhandled. The
data types text and nvarchar are incompatible in the equal to
operator." Here is the relevant code.
Dim da As New SqlDataAdapter( strSQL, cn)
da.SelectComman d.Parameters.Ad dWithValue("@Or derID",
tbOrderID.Text)
Dim tbl As New DataTable("Orde rs")
With tbl
.Columns.Add("O rderID", GetType(String) )
.Columns.Add("P rice", GetType(Decimal ))
.Columns.Add("I tem", GetType(Integer ))
End With
da.Fill(tbl)
Previously, I had all of the fields set to text in SQL, String in the
VB code and System.String in the data set properties. Everything
executed fine. However, when I tightened up my data types, attempting
to change them to their correct types, the app crashed. That was the
only thing that I changed between successful runs and the run-time
error.
So I suspect that I just have some sort of contradiction in how I have
set the data types in the various settings (sql, vb code, data set).
I have attempted to synchronize these data types using:
Text (sql), String (vb code), System.String (data set
properties);
Money, Decimal, System.Decimal;
Int, Integer, System.Int16.
No matter what I try, I get the exact same error.
Am I right or is the error message coming from somewhere else? Also,
does anybody know of a reference that shows what data types are
"legal" matches between these different settings?
I appreciate any help.
Alex
I have three different data types coming out of my SQL tables that I
need to align with my VB code and the data set properties. I'm
getting an error message that reads "SQL exception unhandled. The
data types text and nvarchar are incompatible in the equal to
operator." Here is the relevant code.
Dim da As New SqlDataAdapter( strSQL, cn)
da.SelectComman d.Parameters.Ad dWithValue("@Or derID",
tbOrderID.Text)
Dim tbl As New DataTable("Orde rs")
With tbl
.Columns.Add("O rderID", GetType(String) )
.Columns.Add("P rice", GetType(Decimal ))
.Columns.Add("I tem", GetType(Integer ))
End With
da.Fill(tbl)
Previously, I had all of the fields set to text in SQL, String in the
VB code and System.String in the data set properties. Everything
executed fine. However, when I tightened up my data types, attempting
to change them to their correct types, the app crashed. That was the
only thing that I changed between successful runs and the run-time
error.
So I suspect that I just have some sort of contradiction in how I have
set the data types in the various settings (sql, vb code, data set).
I have attempted to synchronize these data types using:
Text (sql), String (vb code), System.String (data set
properties);
Money, Decimal, System.Decimal;
Int, Integer, System.Int16.
No matter what I try, I get the exact same error.
Am I right or is the error message coming from somewhere else? Also,
does anybody know of a reference that shows what data types are
"legal" matches between these different settings?
I appreciate any help.
Alex
Comment