how to connect database file in my asp.net project

I have restored database when i connect sql it shows server name blank i entered [.] dot it connect.

when i run my asp.net web application its show instance error.

my connection string is:

<add name="WarehouseWebsiteString" connectionString="Data Source=hostingmssql10;Network Library=dbmssocn;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=bea3de-warehousebissdscom; Encrypt=no;Initial Catalog=bea3de-warehousebissdscom; Password=1234;"providerName="System.Data.SqlClient"/>

i have create login page using database but it not login give error in web.config file:

xml version="1.0"?>
<configuration>
<appSettings>
<add key="warehouse_DataAccessLayerType" value="warehouse.DataAccessLayer.SQLDataAccess"/>
appSettings>
<connectionStrings>
<add name="WarehouseWebsiteString" connectionString="Data Source=hostingmssql06;Network Library=dbmssocn;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=bea3de-warehousebissdscom; Encrypt=no;Initial Catalog=bea3de-warehousebissdscom; Password=1234;"
providerName="System.Data.SqlClient"/>
connectionStrings>
<system.web>
<globalization culture="en-US"/>
<compilation debug="true" targetFramework="4.5"/>
<authentication mode="Windows"/>
<customErrors mode="Off"/>
<pages theme="Theme1" maintainScrollPositionOnPostBack="true" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
system.web>
<system.webServer>
<directoryBrowse enabled="true"/>
system.webServer>
configuration>

i'm doing this in login.aspcx.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using System.Data.SqlClient;
using System.Web.Configuration;
public partial class AdminLogin : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
error.Visible = false;
}
protected void imgBtnLogin_Click(object sender, ImageClickEventArgs e)
{
try
{
using (con = new SqlConnection(WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ToString()))
{
con.Open();
string qry = "select * from tblLoginDetails where UserName='" + txtUserName.Text + "' and Password='" + txtPassword.Text + "'";
SqlCommand cmd = new SqlCommand(qry, con);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count == 1)
{
Session["UserName"] = txtUserName.Text.Trim();
Response.Redirect("~/Admin/Default.aspx");
error.Visible = false;
}
else
{
error.Visible = true;
}
}
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}

what can i do i dont understand where mistak how to sove this

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
if its in loacal then try instead of
Data Source=hostingmssql10
this
Data Source=.
Rafnas T P8y ago
hi,
can you tell me where is your database located, is in your local system or in lan system, or in cloud(internet based) system
Sai Sherlekar8y ago
Your code is not able to connect SQL server Problem can be: internet issue, do telnet and check connectivity, connection string spell mistake
Deekshaa Singh Chauhan8y ago
when i login it give this error:
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: TCP Provider, error: 0 - No such host is known.)