A network-related or instance-specific error

Question

Hi all,

 

I got an error like this when i'm gonna run asp.net web forms

 

why is that? How should i prevent this error.

 

Server Error in '/' Application.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

Line 85:

Line 86:

Line 87: con.Open();

Line 88: string pcount = Convert.ToString(command.ExecuteScalar());

Line 89: if (pcount.Length == 0)

Answer 1

Hi ,

 

Below code may help

 

 

$.ajax(

{

type: "POST",

url: "Gridview.aspx/BindSearchDatatable",

//data: "{officename : '"+searchtext+"'}",

data: JSON.stringify({ officename: searchtext }),

contentType: "application/json; charset=utf-8",

dataType: "json",

async: true,

cache: false,

success: function (data) {

//iterate the gridview,bind the json data to gridview

$("#gvDetails").empty();

for (var i = 0; i < data.d.length; i++) {

$("#gvDetails").append("" + data.d[i].OfficeName + "" + data.d[i].City + "" + data.d [i].Country + "");

}

},

error: function (x, e) {

alert("The call to the server side failed. " + x.responseText);

}

}