Insert into database c# connection string error

Question

i am encountering an error when trying to set up an insert command into my database, it appears to be with the connection string. I am extremely new to all this and am trying to get the correct code in order to upload into my database and assume that the syntax i am using may be wrong and the cause of the error.

Here is the code a little bit clearer:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace ComputingProjectwh.TestPages._1._Further_Mechanics
{
    public partial class Moments_and_Energy_Test1 : System.Web.UI.Page
    {


        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected void Submit_Click(object sender, EventArgs e)
        {
            if (!this.IsValid)
                return;
            int score = 0;
            List<RadioButtonList> list = new List<RadioButtonList>() { RadioButtonList1, RadioButtonList2, RadioButtonList3, RadioButtonList4, RadioButtonList5, RadioButtonList6, RadioButtonList7, RadioButtonList8, RadioButtonList9, RadioButtonList10 };
            foreach (var element in list)
            {
                if (element.SelectedValue == "Correct")
                {
                    score++;
                }

            }
            Response.Write("you scored: " + score);
            Button1.Visible = false;

            if (score != 0);
            {
                SqlConnection sqlConnection1 = new SqlConnection (@"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-ComputingProjectwh-20170404101246.mdf;InitialCatalog=aspnet-ComputingProjectwh-20170404101246;IntegratedSecurity=True");

                System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = "INSERT AspNetUserTestScores (Id, MomentAndEnergyTestScore) VALUES (Id, score)";
                cmd.Connection = sqlConnection1;

                sqlConnection1.Open();
                cmd.ExecuteNonQuery();
                sqlConnection1.Close();


            }

        }
    }
}

I am really not sure what the problem is and cant seem to find an answer on the internet. Any help would be greatly appreciated.

Refer connectionstrings.com for correct connection string.

Ashok
– Ashok

2017-04-09 11:00:11 +00:00
Commented Apr 9, 2017 at 11:00 — Ashok
– Ashok, Commented Apr 9, 2017 at 11:00

Koby Douek · Accepted Answer · 2017-04-09 11:01:16Z

2

When connecting to MSSQL, there is no initialcatalog, You are using a wrong connection string.

This is the correct syntax:

  Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Or in your case, for trusted connection:

  Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

With your data:

 SqlConnection sqlConnection1 = new SqlConnection("Server=LocalDb;Database=aspnet-ComputingProjectwh-20170404101246.mdf;Trusted_Connection=True;");

edited Apr 9, 2017 at 11:01

answered Apr 9, 2017 at 10:48

Koby Douek

16.7k21 gold badges79 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Daniel Turville Over a year ago

It doesnt recognise anything in those strings?

Daniel Turville Over a year ago

like this?

SqlConnection sqlConnection1 = new SqlConnection(Server= LocalDb; Database= aspnet - ComputingProjectwh - 20170404101246.mdf; Trusted_Connection = True;);

Daniel Turville Over a year ago

I think that my connection string is correct but the actual data ive put in is wrong now as im getting an error saying that connection could not be established. is that the correct syntax when connecting to a local server created by asp itself?

Koby Douek Over a year ago

Let us continue this discussion in chat.

Daniel Turville Over a year ago

Sorry new to this, how do we do that?

Mantas Čekanauskas · Accepted Answer · 2017-04-09 10:50:09Z

1

InitialCatalog is two separate words initial catalog.

answered Apr 9, 2017 at 10:50

Mantas Čekanauskas

2,2386 gold badges26 silver badges49 bronze badges

2 Comments

Daniel Turville Over a year ago

Didn't seem to make a difference for me. I assume my syntax is wrong or old

Koby Douek Over a year ago

Please see my answer

Collectives™ on Stack Overflow

Insert into database c# connection string error

2 Answers 2

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related