دستورات SQLبرای جست و جو

[hassan razavi]

1- : شرط فیلدهایی که از نوع عددی هستند را داخل کوتیشن ' ننویسید
2- : در سطر دوم ، کلمه And به حرف بعدی چسبیده

string strsql = "SELECT *FROM HOME" +

"WHERE (noe_melk='"+cmb_search_noe_melk.Text+"') AND "+

"(metraj>= "+txt_search_metraj.Text+" AND metraj<= " + txt_search_metraj2.Text + " ) AND " +

" (omre_melk>=" + txt_search_omre_melk.Text + " AND omre_melk<=" + txt_search_omre_melk2.Text + ") AND " +

" (pool_pish_ejare>=" + txt_search_pool_pish_ejare.Text + " AND pool_pish_ejare<= " + txt_search_pool_pish_ejare2.Text + ") AND " +

" (pool_mah_ejare>= " + txt_search_pool_mah_ejare.Text + "  AND pool_mah_ejare<=" + txt_search_pool_mah_ejare2.Text + ") AND " +

" (pool_foroosh>=" + txt_search_foroosh.Text + " AND pool_foroosh<=" + txt_search_foroosh2.Text + " ) AND " +

" (foroosh_khas=" + cbx_foroosh_khas.Checked + ")";