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;
}
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;
}
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?
[IMG]http://img233.imageshack.us/img233/5078/thumbnailte1.th.jpg[/IMG]
They say I look like daddy :D