UC知道c#与数据库的问题
来源：百度知道 编辑：UC知道 时间：2024/05/22 09:54:28
private void button1_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection("data source = (local);initial catalog = shuju");
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT ID FROM [sheet1$]";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read()) {
richTextBox1.Text = reader["ID"].ToString();
}
reader.Close();
connection.Close();
为什么老是是connection.Open();这一行有错误? 为什么呀
{
SqlConnection connection = new SqlConnection("data source = (local);initial catalog = shuju");
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT ID FROM [sheet1$]";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read()) {
richTextBox1.Text = reader["ID"].ToString();
}
reader.Close();
connection.Close();
为什么老是是connection.Open();这一行有错误? 为什么呀
使用WINDOWS登录身份链接数据库
SqlConnection connection = new SqlConnection("server=(local);database=shuju;integrated security=SSPI");
使用数据库身份登录
SqlConnection connection = new SqlConnection("server=(local);database=shuju;uid=sa;pwd=你的数据库密码");
Uid=sa 表示登录身份是SA用户
("data source = (local);initial catalog = shuju");
连接字符串试试
datasou = .;database = <数据库名字>;user = sa; pwd =sa
连接字符串有问题.
后面加一行:
Data Source=.;Initial Catalog=shuju;Integrated Security=True
如果还有问题给我发消息.
连接字符串有问题.
你如果不会写连接客串时,建议先用个vs数据源控件,拖一下,把控件的连接字符串Copy过了,这样肯定不会出错的