Click here to Skip to main content
15,031,132 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Dear,
Is there any api to get the covid vaccine already injected details by given id

please give me a solution

What I have tried:

i searched on google getting more result in total cases admitted, total cases death...but i dont need these details, i need if am given a id, that id already covid vaccine taken or not details only.
Posted
Updated 17-Jun-21 18:44pm

IF you're talking about a global database of everyone who's been vaccinated, no, there no such thing.

You have no way of looking anyone up to see if they have gotten the shots or not.

Now, if this is you've own database, that's a different story.
   
Comments
Patrice T 18-Jun-21 0:02am
   
+5
To add to what Dave has said, how could you look up to see if anyone in the world has been vaccinated given an id, given two important details:
1) There is no global "People ID" which will uniquely identify a person in any system. It would probably make things a whole load simbler if there were ...
2) Access to any information on individuals is likely to be heavily restricted - and that includes vaccination status - because it will contain personal information. And local / global legislation generally provides severe penalties for releasing that without the persons consent: Google "GDPR" for one example.

If you are talking about your own database, then it's just a matter of issuing a parameterised SELECT query or similar (and being careful not to violate GDPR and other data protection legislation) but we can't tell you "do this" without knowing a lot more about your system and where / how the data is stored.
For SQL Server in C# it would be something like this:
C#
using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT Date1stJab, Date2ndJab FROM Vaccinations WHERE ID = @ID", con))
        {
        cmd.Parameters.AddWithValue("@ID", myTextBox.Text);
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                DateTime first = (DateTime) reader["Date1stJab"];
                DateTime second = (DateTime) reader["Date2ndJab"];
                ...
                }
            }
        }
    }
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900