I have a registration form and I want to feed the contents of it into an SQL database that I created in Visual Web Developer. I have the proper code to insert the contents into the database table, but there is a problem with my connection string. What's the problem with it? (I'm pretty sure the "server" property is causing the problem, so what is it supposed to be set to?) The SQL database is in the same VWD project as this code.
string connection = "server=local; database=AsamaiDB; Trusted_Connection=True"; SqlConnection conn = new SqlConnection(connection);