Hi
You really need to be more specific here. This question spans 2 technologies, C# database connects and SQL.
I suggest you consult the
MSDN for the code required to connect to a DB and one of the millions of sights regarding SQL code.
The C# section of your question is fairly easy to answer, please feel free to post any code which is causing you problems and we will have a look at it.
As for the SQL, this can be really simple or rather complex depending on what exactly you want to do with the table you create. I know a fair bit about SQL and could help you with some of the code but if you want indexes, primary keys and relations I really think you should post that section of your code in the
Access Forum as its not in the scope of C#.
Again, read up on the code and feel free to post any code which is unclear to you and we'll have a look at it.
To give you a short explanation:
You need to create a database connection which uses a connection string containing the authentication information. Next you need to create an SQL command and finally execute this command against your database.
You will most probably also have to look at the security settings of your database to ensure that you can indeed execute the command.
Your next step will be to consider .config files which store the connection settings and possibly a separate namespace which will control data access and encapsulate DB responses.