connection between asp.net , c# and sql server ( both versions are 2012)

Question

i wrote a connection string in asp.net i.e add 2 data through 2 textboxes into the sql server database . but after pressing submit button i face to an error .

Details:

web.config:

<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>

  <connectionStrings>
    <add name="myconectionstring"
    connectionString="data source=.\SQLEXPRESS;initial catalogue=test;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />
  </connectionStrings>

    <system.web>
      <compilation debug="true" targetFramework="4.5" />
      <httpRuntime targetFramework="4.5" />
    </system.web>

</configuration>

code behind:

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 WebApplication3
{

    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }


        protected void Button1_Click1(object sender, EventArgs e)
        {
            string cs = System.Configuration.ConfigurationManager.ConnectionStrings["myconectionstring"].ConnectionString;
            SqlConnection con = new SqlConnection(cs);

            try
            {
                ///string cs = System.Configuration.ConfigurationManager.ConnectionStrings["myconectionstring"].ConnectionString;

                SqlCommand cmd = new SqlCommand("INSERT INTO Table_1 (name,fathername) VALUES('" + txt1.Text + "','" + txt2.Text + "')", con);
                con.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                String ErrorMsg = ex.ToString();
            }
            finally
            {
                con.Close();
            }
        }
    }
}

Error message :

Server Error in '/' Application.

Keyword not supported: 'initial catalogue'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.ArgumentException: Keyword not supported: 'initial catalogue'.

Source Error: 


Line 21:         {
Line 22:             string cs = System.Configuration.ConfigurationManager.ConnectionStrings["myconectionstring"].ConnectionString;
Line 23:             SqlConnection con = new SqlConnection(cs);
Line 24: 
Line 25:             try

Source File: c:\Users\Admin\Documents\Visual Studio 2012\Projects\WebApplication3\WebApplication3\WebForm1.aspx.cs    Line: 23

Side note: It is recommended to use Parameterized Queries. As you are not using SqlCommand.Parameters your code clearly exposed to sql injections. — Hassan Nisar
– Hassan Nisar, Commented Jun 25, 2014 at 9:25

Pheonyx · Accepted Answer · 2014-06-25 09:22:04Z

1

Your connection string should start as follows:

Server=myServerAddress;Database=myDataBase;

instead of your current

data source=.\SQLEXPRESS;initial catalogue=test;

This should resolve your issue.

answered Jun 25, 2014 at 9:22

Pheonyx

8516 silver badges15 bronze badges

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

Comments

Oscar · Accepted Answer · 2014-06-25 09:31:25Z

1

Use:

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

And whenever you forgot a connection string of any database, go to:

http://www.connectionstrings.com

edited Jun 25, 2014 at 9:31

answered Jun 25, 2014 at 9:19

Oscar

14.1k9 gold badges53 silver badges84 bronze badges

Comments

Khan · Accepted Answer · 2014-06-25 09:19:14Z

0

You misspelled Catalog wrong. Its Initial Catalog

answered Jun 25, 2014 at 9:19

Khan

3421 gold badge7 silver badges22 bronze badges

Comments

Neel · Accepted Answer · 2014-06-25 09:19:41Z

0

its a type at Initial Catalog correct the spelling and it should work !!

for more information :-

http://www.connectionstrings.com/sql-server-2012/

answered Jun 25, 2014 at 9:19

Neel

11.7k3 gold badges46 silver badges63 bronze badges

Collectives™ on Stack Overflow

connection between asp.net , c# and sql server ( both versions are 2012)

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related