private void button1_Click(object sender, EventArgs e)
{
string sql = "select * from saleBill";
string DBConfig_sql = @"Data Source=5656FEAAC843486\SQLEXPRESS;Initial Catalog=Test;User ID=5656FEAAC843486\Administrator";
DataSet ds = new DataSet();
Sqlconnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql,sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "sql"); MISCrystalReport1.Load(Application.StartupPath + "MISCrystalReport.rpt");
MISCrystalReport1.SetDataSource(ds.Tables["sql"]);
crystalReportViewer1.ReportSource = MISCrystalReport1;
}
//系统报错 说 5656FEAAC843486\Administrator这个用户 登陆失败,但是我用的就是这个用户名啊,用的WINDOWS集成验证,这个该怎么改呀,5656FEAAC843486\Administrator确实就是我的用户名啊我都无奈了怎么回事
{
string sql = "select * from saleBill";
string DBConfig_sql = @"Data Source=5656FEAAC843486\SQLEXPRESS;Initial Catalog=Test;User ID=5656FEAAC843486\Administrator";
DataSet ds = new DataSet();
Sqlconnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql,sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "sql"); MISCrystalReport1.Load(Application.StartupPath + "MISCrystalReport.rpt");
MISCrystalReport1.SetDataSource(ds.Tables["sql"]);
crystalReportViewer1.ReportSource = MISCrystalReport1;
}
//系统报错 说 5656FEAAC843486\Administrator这个用户 登陆失败,但是我用的就是这个用户名啊,用的WINDOWS集成验证,这个该怎么改呀,5656FEAAC843486\Administrator确实就是我的用户名啊我都无奈了怎么回事
string DBConfig_sql = @"Data Source=5656FEAAC843486\SQLEXPRESS;Initial Catalog=Test;User ID=5656FEAAC843486\Administrator"; 可以考虑用vs直接连接数据库,然后看一下他自动生成的字串是怎样的