By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,230 Members | 1,543 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,230 IT Pros & Developers. It's quick & easy.

data type synchronization

P: n/a
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.SelectCommand.Parameters.AddWithValue("@OrderID ",
tbOrderID.Text)

Dim tbl As New DataTable("Orders")
With tbl
.Columns.Add("OrderID", GetType(String))
.Columns.Add("Price", GetType(Decimal))
.Columns.Add("Item", 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

May 2 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Help! I'm desperate and completely stuck. Can anybody help?

May 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.