C#链接数据库的问题
来源:百度知道 编辑:UC知道 时间:2024/05/16 11:37:17
我用的是VS2005,ASP.NET应该是2.0的数据库是SQL Server2000,创建的登陆表为AM_admin,包括AM_ID,AM_name,AM_pwd。写了一下语句,可是完全没有连上数据库,请各位帮我看一下
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Common;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
private void Button1_Click(object sender, EventArgs e)
{
string yzConnStr="servser=.;User id=sa;pwd=";
SqlConnection yzCon = new SqlConnection(yzConnStr);
yzCon.Open();
string SQLStr = "select * from AM_admin where AM_name=='" +TextBox1.Text+ "' and AM_
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Common;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
private void Button1_Click(object sender, EventArgs e)
{
string yzConnStr="servser=.;User id=sa;pwd=";
SqlConnection yzCon = new SqlConnection(yzConnStr);
yzCon.Open();
string SQLStr = "select * from AM_admin where AM_name=='" +TextBox1.Text+ "' and AM_
"servser=.;User id=sa;pwd="
加一个database="...";
他默认的库是master.你AM_admin是在master库中么
string yzConnStr="servser=.;User id=sa;pwd=";
好象不用.吧直接用(local)或者是IP就好了
string yzConnStr="servser=(local);User id=sa;pwd=";
servser=.;User id=sa;pwd="
加一个database="...";
string yzConnStr="servser=.;User id=sa;pwd= database=AM_admin";另外你的代码有问题你可以把他写到web.config中去 然后这样写
string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["testConnectionString"]);
SqlConnection myconn = new SqlConnection(settings);