Question

C#连接ACCESS数据库的程序中出现"标准表达式中数据类型不匹配。"怎么处理?

代码如下:
int a = this.dataGrid1.CurrentCell.RowNumber ;
string mystr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\\book.mdb";
OleDbConnection myconn = new OleDbConnection(mystr);
myconn.Open();
string mycom = "delete from pass where xh=";
mycom += this.myset.Tables [0].Rows[a][0];
OleDbCommand com = new OleDbCommand(mycom,myconn);
com.ExecuteNonQuery();
OleDbDataAdapter myda = new OleDbDataAdapter("select * from pass order by xh",myconn);
this.myset.Clear();
myda.Fill(myset,"pass");
myconn.Close();

Answer 1

mycom += this.myset.Tables [0].Rows[a][0];
myset在哪定义的，数据类型不匹配是不是string mycom = "delete from pass where xh='";
mycom += this.myset.Tables [0].Rows[a][0] + "'";
中的xh是整型，而后面的是字符串型啊，自己注意一下。

Answer 2

this.myset.Tables [0].Rows[a][0];???
a的值是多少？？怎么没看到？

xh是什么类型的字段，字符类型的话应该这么写:
string mycom = "delete from pass where xh='";
mycom += this.myset.Tables [0].Rows[a][0] + "'";