metallica
شنبه 21 خرداد 1390, 11:45 صبح
سلام
مشکل این کد چیه؟!!هنگام delete کردن این Error رو میده
Syntax error (missing operator) in query expression 'ID='.
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=D:\\L.mdb";
Con = new OleDbConnection(strCon);
Con.Open();
strSql = "Delete From L Where ID=" + "" + selectedRow + "";
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds,"L");
ds.Clear();
this.lTableAdapter.Fill(this.lDataSet1.L);
MessageBox.Show("ِdeleted");
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=D:\\L.mdb";
strSql = "Select*from L";
Con = new OleDbConnection(strCon);
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "L");
مشکل این کد چیه؟!!هنگام delete کردن این Error رو میده
Syntax error (missing operator) in query expression 'ID='.
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=D:\\L.mdb";
Con = new OleDbConnection(strCon);
Con.Open();
strSql = "Delete From L Where ID=" + "" + selectedRow + "";
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds,"L");
ds.Clear();
this.lTableAdapter.Fill(this.lDataSet1.L);
MessageBox.Show("ِdeleted");
strCon = "Provider=Microsoft.jet.OLEDB.4.0;" + "Data Source=D:\\L.mdb";
strSql = "Select*from L";
Con = new OleDbConnection(strCon);
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "L");