public static void getZaposlenike(DS_Zaposlenici.view_ZaposleniciDataTable dt_Zaposlenici)
{
using (SqlConnection cn = Connection.GetOpenConnection())
{
DS_ZaposleniciTableAdapters.view_ZaposleniciTableAdapter adapter = new DS_ZaposleniciTableAdapters.view_ZaposleniciTableAdapter();
adapter.Fill(dt_Zaposlenici);
}
}
public static void getZaposlenike_by_fNameAndlName(DS_Zaposlenici.view_ZaposleniciDataTable dt_Zaposlenici, string fName, string lName)
{
using (SqlConnection cn = Connection.GetOpenConnection())
{
dt_Zaposlenici.Clear();
SqlCommand com = new SqlCommand("usp_Zaposlenici_by_fNameAndlName", cn);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@FirstName", fName);
com.Parameters.AddWithValue("@LastName", lName);
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(dt_Zaposlenici);
}
}
