PDA

View Full Version : این خطا یعنی چی؟



amin1000
یک شنبه 15 اسفند 1389, 12:26 عصر
سلام
این خطا رو برای چی میده ؟ لطفا کمک کنید

SqlDataAdapter objdataadapter = new SqlDataAdapter("SELECT st_info.st_num AS st_num, st_info.st_name AS st_name, st_info.st_fam AS st_family, st_info.st_field AS st_reshte, " +
" st_info.st_sal_vorood AS st_sal_vorood, st_info.st_maghta AS st_maghta, tbl_moarefi_be_ostad.shahriye_motaghayer_moarefi AS st_shahriye, " +
" tbl_moarefi_be_ostad.hagh_nezarat_moarefi AS st_hagh_nezarat, tbl_moarefi_be_ostad.shahriye_fish_num AS st_sh_fish_num, " +
" tbl_moarefi_be_ostad.hagh_nezarat_fish_num AS st_hagh_nezarat_fish_num " +
" FROM st_info INNER JOIN " +
" tbl_moarefi_be_ostad ON st_info.st_num = tbl_moarefi_be_ostad.st_num where tbl_moarefi_be_ostad.st_num =@tbl_moarefi_be_ostad.st_num ", objconnection);

objdataadapter.SelectCommand.Parameters.AddWithVal ue("@tbl_moarefi_be_ostad.st_num", textBox1.Text);




Line 1: Incorrect syntax near '.'.
Must declare the variable '@tbl_moarefi_be_ostad'.

ma.rad
یک شنبه 15 اسفند 1389, 12:45 عصر
احتمالا متغییری بنام tbl_moarefi_be_ostad' را در تعریف نکردید تابتونید مقدار بهش پاس بدید