amin1000
یک شنبه 15 اسفند 1389, 13: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'.
این خطا رو برای چی میده ؟ لطفا کمک کنید
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'.