c#编程连接数据库问题
目的:想在查询服务窗体,输入书名或编号时,在DataGridView显示符合条件的数据。调试到第三句代码时,却出现始料未及的问题,求解!!!求帮忙!!!初学实在有太多问题了。
代码如下:
        string yanzheng = this.textBox1.Text.Trim();
        int id = Int32.Parse(this.textBox2.Text.Trim());
        SqlConnection cnn = new SqlConnection("Data Source=DJK-PC;Initial Catalog=图书管理系统;Integrated Security=True");
          cnn.Open();
          SqlCommand cd = new SqlCommand();
          cmd.CommandText = "select * from 图书状态表 where book_name ='" + yanzheng + "'or book_id ='" + id + "' ";
          cmd.Connection = conn;
          SqlDataAdapter ada = new SqlDataAdapter(cmd);
          DataSet ds = new DataSet();
          ada.Fill(ds, "图书状态表");
          dataGridView1.DataSource = ds.Tables["图书状态表"];
          conn.Close();
------解决方案--------------------
[code=C#][/code] SqlConnection cnn = new SqlConnection("Data Source=DJK-PC;Initial Catalog=图书管理系统;Integrated Security=True");
 cnn.Open();
含有转义字符。改成[code=C#][/code]SqlConnection cnn = new SqlConnection(@"Data Source=DJK-PC;Initial Catalog=图书管理系统;Integrated Security=True");
 cnn.Open();