System.Data.SqlClient.SqlException error at asp.net

Question

I am new at asp.net. I was trying database connection. But I am getting this error. Please advice me.

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

namespace WebApplication1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
           string cs = "Data Source=.;Initial Catalog=test;Integrated Security=SSPI";
           SqlConnection con = new SqlConnection(cs);
           SqlCommand comma = new SqlCommand("select * from try", con);
           con.Open();
           GridView1.DataSource = comma.ExecuteReader();
           GridView1.DataBind();
           con.Close();

        }
    }
}

Your connection string is wrong - either that server (.) doesn't exist, or it's not started up yet, or something else is wrong with it — marc_s
– marc_s, Commented Jun 28, 2016 at 10:28

marc_s · Accepted Answer · 2016-06-28 11:54:57Z

1

The issue is with the connection string you are using.

Data Source=.;Initial Catalog=test;Integrated Security=SSPI

Check the SQL Server instance name running on your local.

Data Source=**.\YourInstanceName**;Initial Catalog=test;Integrated Security=SSPI

You can test your connection string validity by trying to add a connection in Server Explorer (Tools -> Connect to Server - VS2015).

Good luck

edited Jun 28, 2016 at 11:54

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jun 28, 2016 at 10:31

Roy Paruchuri

1064 bronze badges

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

Collectives™ on Stack Overflow

System.Data.SqlClient.SqlException error at asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related