programerinfonet
جمعه 19 آبان 1391, 16:21 عصر
مشکل این کد کجاست که هم تو کوئری اس کیو ال و هم تو برنامه یک خطا میده
"SELECT sanadcaption.captionid,ashkhasgroups.groupname,ash khas.name,sanadcaption.regdate,sanadcaption.type,v isitor.visitorname,sanadcaption.jamekol,sanadcapti on.visit FROM sanadcaption INNER JOIN visitor ON visitor.id=sanadcaption.visitor INNER JOIN ashkhas ON ashkhas.id=sanadcaption.ashkhas INNER JOIN ashkhasgroups ON ashkhasgroups.id=sanadcaption.shcod WHERE regdate between '" + mtxtdate.Text + "'AND '" + mtxtdate2.Text + "' WHERE name='" + comboBox2.Text + "'"
"SELECT sanadcaption.captionid,ashkhasgroups.groupname,ash khas.name,sanadcaption.regdate,sanadcaption.type,v isitor.visitorname,sanadcaption.jamekol,sanadcapti on.visit FROM sanadcaption INNER JOIN visitor ON visitor.id=sanadcaption.visitor INNER JOIN ashkhas ON ashkhas.id=sanadcaption.ashkhas INNER JOIN ashkhasgroups ON ashkhasgroups.id=sanadcaption.shcod WHERE regdate between '" + mtxtdate.Text + "'AND '" + mtxtdate2.Text + "' WHERE name='" + comboBox2.Text + "'"