Hey .. I am using SQL server and visual studio for attendance using qr code ..

Question

1.00/5 (1 vote)

See more:

so I dont know since I am a beginner ..
I want to know if i should create a table for the qr code or not .. and also if I should create a table for the camera that will scan the qr code before connecting the sql server to visual studio ..

as well I want to know if i connect sql server to visual studio will it be possible to add more tables to sql server or i will not have anymore access to the database??

I Know those questions are annoying but sorry I am a beginner hope u'll help :D

What I have tried:

want to know to try ..?
i still did not try anthing yet since i dont really know so therefore I am asking this question .. to have information that will help me try .. so please answer me if it can be possible . . .
if not am still thankfull ..

Posted 17-Mar-21 23:00pm

User 15069278

Updated 17-Mar-21 23:33pm

Add a Solution

Comments

Maciej Los 18-Mar-21 5:14am

Sorry, but your question is NOT clear. We can't read in your mind or direct from your screen, so please be more specific and exaplain in details what you want to achieve and where you did stuck.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2021-03-17T23:33:00

To be honest, we can't tell you if you need to "create a table for a QR Code", partly because we have no idea what you mean by that - remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.

But mostly because we have no idea what you expect to do with the table, or teh dtaa it will contain.

If you connect VS to your DB, that doesn't stop it being an SQL Database - if you had access to it before via SQL Server (using SSMS, or your code) then that will not change. All you are doing is adding it to data sources VS knows about so it's "easier" to attach your data to some controls. Generally, I use SSMS for DB design and alteration, and don't connect my DB's to VS at all. But I'm odd like that.

What you need to do is work out what data you needs to store, and how it interelates - then think about designing a database and it's tables to hold it. And we can;t tell you what that will look like because we have no idea what data you will be dealing with, or what you will be doing with it!