I have created a sql server database (2008) using visual studio 2008. I have included it in my project created a "connection" to it using server/explorer toolbar. My issue is how do i connect to in code. How to i get access to be able to SELECT and UPDATE and so on in my database. I am using c# by the way. I create a SqlConnection object and passed in a the necessary parameters. The issue is that i get a error message when I debug my project that says the database could not log in to my user. I cannot figure out which user I need to pass in for my uid field. I have even tried recreating the database, but I never gave it a user id so I am wondering what would be the best solution to get access to a database. I am willing to completely start over, i don't have very much code written.
Answers & Comments
Verified answer
You should be able to create queries that will act like methods. Right click you datasource and see if you can find a query tool. Write the query you want and then you should be able to make this work. I don't know about the user accounts. You should just use windows authentication. Most businesses do this so that they can just control your user account and that will decide what you can do. If you need more direct help, please email me. It is hard to just explain this.
definite, considered one of those workstations could probably host the database - yet determine it has a DHCP reservation, and consequently a static IP, set up in the router. i could additionally ascertain the gadget hosting the database is stored on lots of the time. the likelihood is, you will could re-write the authentication, as dwelling house windows Authentication will place self belief in the lively listing, which calls for a dwelling house windows Server. i could probably write code for authentication and shop the person information in the database - to encrypt the passwords, i could use an MD5 Hash.