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); } }