C#数据库连不上，高手指点

来源：百度知道 编辑：UC知道 时间：2024/06/05 20:00:04
UserDAO user = null;//创建连接对象
// SqlConnection conn=new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Test;Integrated Security=SSPI");
sqlCommand cmd = conn.CreateCommand(); //创建命令对象
cmd.CommandText = "SELECT * FROM [User] WHERE UserName=@userName AND Pwd=@pwd";
conn.Open();
执行conn.Open();发生错误，是不是数据库连不上
数据库放在App_data中的

public void GvProductsDataBind()
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Products;Integrated Security=True");

SqlDataAdapter sda = new SqlDataAdapter("select * from Products", conn);

DataTable dt = new DataTable();

sda.Fill(dt);

this.gvProducts.DataSource = dt;
this.gvProducts.DataKeyNames = new string[] { "id" };
this.gvProducts.DataBind();

}

sql2005
"server=.;uid=sa;pwd=1;database=<数据库名>"
Access
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\数据库名"

这么连是不行的。要获取正确的字符串，sql数据库一定要有sql 服务器，vs中也自带了

是实体类吗？？如果是实体类放在App_code里的
看看:public class DBConnection
{
private SqlConnection _Conn;
public DBConnection()
{
String connectionString = System.Web.Configuration.WebConfigurationManage