بیتا حکمت
شنبه 12 اردیبهشت 1394, 18:36 عصر
سلام . بهترین روش برای اینکه کوئری های متفاوت رو ترکیب کنیم و جواب رو به دست بیاریم چه روشی است . به این صورت نوشتم خطا داد
SqlCeConnection connsoal = new SqlCeConnection(puclicclass.strcon);
connsoal.Open();
string strquery = "SELECT ID_subgroups FROM subgroups Where Name='" + comboBox3.SelectedItem.ToString() + "' And user_code=" + puclicclass.current_user_code;
strquery=strquery+";"+
"SELECT ID_subgroups FROM subgroups Where Name='" + comboBox4.SelectedItem.ToString() + "' And user_code=" + puclicclass.current_user_code;
SqlCeCommand comm10 = new SqlCeCommand(strquery, connsoal);
SqlCeDataReader readerm = comm10.ExecuteReader();
// MessageBox.Show(reader.GetName(4), reader.GetName(1));
while (readerm.Read())
{
// MessageBox.Show(readerm.GetInt32(0).ToString());
groupid_Mabda = readerm.GetInt32(0);
groupid_mgasd = readerm.GetInt32(0);
}
متن خطا :
There was an error parsing the query. [ Token line number = 1,Token line offset = 75,Token in error = SELECT ]
SqlCeConnection connsoal = new SqlCeConnection(puclicclass.strcon);
connsoal.Open();
string strquery = "SELECT ID_subgroups FROM subgroups Where Name='" + comboBox3.SelectedItem.ToString() + "' And user_code=" + puclicclass.current_user_code;
strquery=strquery+";"+
"SELECT ID_subgroups FROM subgroups Where Name='" + comboBox4.SelectedItem.ToString() + "' And user_code=" + puclicclass.current_user_code;
SqlCeCommand comm10 = new SqlCeCommand(strquery, connsoal);
SqlCeDataReader readerm = comm10.ExecuteReader();
// MessageBox.Show(reader.GetName(4), reader.GetName(1));
while (readerm.Read())
{
// MessageBox.Show(readerm.GetInt32(0).ToString());
groupid_Mabda = readerm.GetInt32(0);
groupid_mgasd = readerm.GetInt32(0);
}
متن خطا :
There was an error parsing the query. [ Token line number = 1,Token line offset = 75,Token in error = SELECT ]