试着将dataGrid里面的内容写入SQL本地数据库里,"user"是被读入dataGrid,原先是Access文件里的一个表。在下面的代码处出错,提示Cannot open database "userdata" requested by the login. The login failed.
Login failed for user 'user-PC\user'.想问下这代码是否有问题 SqlConnection dataConnection = new SqlConnection();
DataSet dSet = new DataSet();
dataConnection.Open();
SqlDataAdapter daAuthors = new SqlDataAdapter("Select * From user ", dataConnection);
daAuthors.Fill(dSet, "user");
dataGrid1.DataContext = dSet.Tables[0];
dataConnection.Close();
Login failed for user 'user-PC\user'.想问下这代码是否有问题 SqlConnection dataConnection = new SqlConnection();
DataSet dSet = new DataSet();
dataConnection.Open();
SqlDataAdapter daAuthors = new SqlDataAdapter("Select * From user ", dataConnection);
daAuthors.Fill(dSet, "user");
dataGrid1.DataContext = dSet.Tables[0];
dataConnection.Close();
参数呢?
<summary>
/// Access 的数据库连接字符串.
/// </summary>
private const String connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\TeamMemberManager.mdb";
// 建立数据库连接.
OleDbConnection conn = new OleDbConnection(connString);
String SQL = "Select * From user";
// 创建一个适配器
OleDbDataAdapter adapter = new OleDbDataAdapter(SQL, conn); // 创建DataSet,用于存储数据.
DataSet testDataSet = new DataSet(); // 执行查询,并将数据导入DataSet.
adapter.Fill(testDataSet, "user");
datagird1.DataSource=testDataSet.Tables[0];
datagird1.databind();
// 关闭数据库连接.
conn.Close();
builder.DataSource = ".\\SQLExpress";
builder.InitialCatalog = "userdata";
builder.IntegratedSecurity = true;
dataConnection.ConnectionString = builder.ConnectionString;
Login failed for user 'user-PC\user'
这个用户没在数据库里面定义过
dataGrid1.DataSource = testDataSet.Tables[0];
dataGrid1.DataBind();
这样这两个有错误提示..Error 1 'System.Windows.Controls.DataGrid' does not contain a definition for 'DataSource' and no extension method 'DataSource' accepting a first argument of type 'System.Windows.Controls.DataGrid' could be found (are you missing a using directive or an assembly reference?)
Error 2 'System.Windows.Controls.DataGrid' does not contain a definition for 'DataBind' and no extension method 'DataBind' accepting a first argument of type 'System.Windows.Controls.DataGrid' could be found (are you missing a using directive or an assembly reference?)