public static void get_Certificates(DS_Certifikati.view_CertifikatiDataTable dtCertifikati) { dtCertifikati.Clear(); using (SqlConnection cn = Connection.GetOpenConnection()) { DS_CertifikatiTableAdapters.view_CertifikatiTableAdapter adapter = new DS_CertifikatiTableAdapters.view_CertifikatiTableAdapter(); adapter.Fill(dtCertifikati); } }
public static void get_Certificates_by_name(DS_Certifikati.view_CertifikatiDataTable dtCertifikati, string fName, string lName) { dtCertifikati.Clear(); using (SqlConnection cn = Connection.GetOpenConnection()) { SqlCommand com = new SqlCommand("usp_Certifikati_by_name", cn); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.AddWithValue("@fName", fName); com.Parameters.AddWithValue("@lName", lName); SqlDataAdapter adapter = new SqlDataAdapter(com); adapter.Fill(dtCertifikati); } }