如何在我的ASP.NET项目中连接数据库文件 [英] How to connect database file in my ASP.NET project
问题描述
我已经调整了数据库,当我连接sql它显示服务器名称空白我输入[。]点它连接。
当我运行我的asp.net web应用程序时显示实例错误。
我的连接字符串是:
< add name =WarehouseWebsiteStringconnectionString =Data Source = hostingmssql10; Network Library = dbmssocn; Connection Timeout = 15;数据包大小= 4096;集成安全性=否;用户ID = bea3de-warehousebissdscom;加密=否;初始目录= bea3de-warehousebissdscom;密码= 1234;
providerName =System.Data。 SqlClient/>
i使用数据库创建登录页面但是没有登录给出错误
< b>我尝试过:
使用System;
使用System.Collections.Generic;
使用System.Linq;
使用System.Web;
使用System.Web.UI;
使用System.Web.UI .WebControls;
使用System.Web.Security;
使用System.Data.SqlClient;
使用System.Web.Configuration;
公共部分类AdminLogin:System.Web.UI。页面
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings [WarehouseWebsiteString]。ToString());
protected void Page_Load(对象发送者,EventArgs e)
{
error.Visible = false;
}
protected void imgBtnLogin_Click(object sender,ImageClickEventArgs e)
{
try
{
using(con = new SqlConnection(WebConfigurationManager.ConnectionStrings [WarehouseWebsiteString]。ToString()))
{
// string username = txtUserName.Text;
// string password = txtPassword.Text;
con.Open() ;
string qry =s select * from tblLoginDetails其中UserName ='+ txtUserName.Text +'和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;
}
其他
{
错误。可见=真;
}
}
con.Close();
}
catch(例外情况)
{
回复.Write(ex.Message);
}
}
}
但是它不工作我不明白我在哪里做改变。
I have resotred database when i conect sql it show server name blank i enterd [.] 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
What I have tried:
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()))
{
//string username = txtUserName.Text;
//string password = txtPassword.Text;
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);
}
}
}
but it not work i dont understand where i do change.
推荐答案
当我在 configration 文件中执行此操作时它正常工作: -
When i do this in configration file It working properly:-
<connectionStrings>
<!--<add name="WarehouseWebsiteString" connectionString="Data Source=BISWEBSERVER\SQLSERVER2005; DataBase=Warehouse; User Id=sa; Password=xfiles_76;"/>-->
<add name="WarehouseWebsiteString" connectionString="Data Source=. ;Network Library=dbmssocn;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=warehousebissdscom; Encrypt=no;Initial Catalog=warehousebissdscom; Password=123;Trusted_Connection=true;"/>
</connectionStrings>
这篇关于如何在我的ASP.NET项目中连接数据库文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!