public static void GetKandidatiByIme(DSKandidati.KandidatiDataTable dtKandidati, string Ime, string Prezime, int drzavaID)
{
dtKandidati.Clear();
SqlConnection cn = Connection.GetConnection();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("usp_Kandidati_SelectByName", cn);
cmd.CommandType = CommandType.StoredProcedure;
if (Ime != "")
{
cmd.Parameters.Add("@ime", SqlDbType.NVarChar).Value = Ime;
}
if (Prezime != "")
{
cmd.Parameters.Add("@prezime", SqlDbType.NVarChar).Value = Prezime;
}
if (drzavaID != 0)
{
cmd.Parameters.Add("@drzavaID", SqlDbType.Int).Value = drzavaID;
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtKandidati);
}
finally
{
cn.Close();
}
}
public Frm_KandidatiReport(DSKandidati.KandidatiDataTable dtKandidati)
{
InitializeComponent();
DSKandidatiBindingSource.DataSource = dtKandidati;
}
