[ wex-alpha @ 08.09.2011. 18:19 ] @
Opet SQLCE. Jedan obican query koji radi kada nije parametrizovan. A kada pokusam sa parametrima, nece. Bez parametara i radi Code: public DataTable OdabirPrijavaKorisnika(string brojkartice) { SqlCeConnection con = new SqlCeConnection(@"Data Source = |DataDirectory|\fu.sdf"); con.Open(); SqlCeCommand cmd = new SqlCeCommand(" Select * from logovanje where brojkartice ='č10154_' " , con); SqlCeDataAdapter da = new SqlCeDataAdapter(cmd); DataTable tble = new DataTable(); da.Fill(tble); con.Close(); return tble; } Sa parametrima i ne radi Code: public DataTable OdabirPrijavaKorisnika(string brojkartice) { SqlCeConnection con = new SqlCeConnection(@"Data Source = |DataDirectory|\fu.sdf"); con.Open(); SqlCeCommand cmd = new SqlCeCommand(" Select * from logovanje where brojkartice=@brojkartice", con); SqlCeDataAdapter da = new SqlCeDataAdapter(cmd); DataTable tble = new DataTable(); da.Fill(tble); con.Close(); return tble; } Kaze da mi parametar fali "A parameter is missing. [ Parameter ordinal = 1 ]". Svi primjeri koje sam nasao imaju isti format. Gdje grijesim? |