这样删除提示类型不匹配

Question

                long bh = long.Parse(textBox4.Text);         
                string shanchu = "delete from users where bianhao=" + bh + " ";
                OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\用户查询\hbwl.mdb;Persist Security Info=False");
                OleDbCommand od = new OleDbCommand(shanchu, conn);
                conn.Open();
                od.ExecuteNonQuery();
                MessageBox.Show("删除成功!");
                conn.Close();  bianhao是ACCESS数据库是一个自动编号长整型的字段.

Answer 1

这样试试：
string shanchu = "delete from [users] where [bianhao]=" + bh + " ";

Answer 2

string shanchu = string.Format("delete from [users] where bianhao={0}",bh);
或oledbparameter

Answer 3

string shanchu = "delete from users where bianhao=" + bh.ToString();