在条件表达式中获取数据类型不匹配 [英] Getting Data type mismatch in criteria expression..

问题描述

喜!!



如果任何一个字段与d / b中的记录匹配，此代码显示结果



但是我我得到例外......



''标准表达式中的数据类型不匹配。''

 DataTable dt =  new  DataTable（）; 
 
  string  custname = cust_name_txt.Text.ToString（）; 
 
  Int32  chassi，engine; 
 
 
  bool  result =  Int32  .TryParse（cust_chassi_no_txt.Text ， out  chassi）; 
  bool  res2 =  Int32  .TryParse（sales_engine_no_txt.Text， out 引擎）; 
 
  string  month = sale_month_cmb.Text; 
 
 OleDbDataAdapter da =  new  OleDbDataAdapter（  select * from sales WHERE [Customer Name] =' + custname +  'OR [ Chassi Number] =' + chassi +  '或[Engine Number] =' + engine +  '或[销售月份] =' +月+  '，con）; 
 
 
 con.Open（）; 
 
 da.Fill（dt）;  //  条件表达式中的数据类型不匹配。发生在这里..  
 dataGridView1.DataSource = dt; 
 
 con.Close（）; 

D / B中的所有数据类型都是正确的。我正在使用MS Access进行数据库..



有人可以帮助我解决这个异常...

解决方案

为你的错误提供更多结果一些相关主题可以帮助您找到代码中的瑕疵......



[已解决]标准表达式中的数据类型不匹配 [ ^ ]



条件表达式中的数据类型不匹配 [ ^ ]



http://social.msdn.microsoft.com/Forums / en-US / csharplanguage / thread / e268f6d6-4507-408d-ab84-1f0b95324479 / [ ^ ]

if
[销售月份] ]

[发动机编号]

[Chassi编号]

是整数字段......



检查您是否传递了正确的值，例如如果 [销售月份] 是 int 列，并且您传递''1''然后它会导致错误 你无法在int栏中传递 char 甚至 space

所以，你应该通过''1''



快乐编码！

：）

hi!!

this code displays result if any one field matches with the records in d/b

but i am getting an Exception...

'' Data type mismatch in criteria expression.''

DataTable dt = new DataTable();

string custname = cust_name_txt.Text.ToString();

Int32 chassi, engine;


bool result = Int32.TryParse(cust_chassi_no_txt.Text, out chassi);
bool res2 = Int32.TryParse(sales_engine_no_txt.Text, out engine);

string month = sale_month_cmb.Text;

OleDbDataAdapter da = new OleDbDataAdapter("select * from  sales WHERE [Customer Name] = '" + custname + "' OR [Chassi Number] = '" + chassi + "' OR [Engine Number] = '" + engine + "' OR  [Month of Sale] = '" + month + "' ", con);


con.Open();

da.Fill(dt);              //Data type mismatch in criteria expression. occurs here..
dataGridView1.DataSource = dt;

con.Close();

all the datatypes in D/B are proper.i am using MS Access for database..

can someone please help me with this exception...

解决方案

for more result to your error there is some related topics that can help you to find your foult in code....

[SOLVED] Data type mismatch in criteria expression[^]

data type mismatch in criteria expression[^]

http://social.msdn.microsoft.com/Forums/en-US/csharplanguage/thread/e268f6d6-4507-408d-ab84-1f0b95324479/[^]

if [Month of Sale]
[Engine Number]
[Chassi Number]
are integer field...

Check you are passing correct values e.g. if [Month of Sale] is int column and you are passing ''1 '' then it will cause error you can not pass char or even space in int column
so, you should pass ''1''

Happy Coding!
:)

这篇关于在条件表达式中获取数据类型不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！