.net 连接sql2005

        SqlConnection conn;
        conn = new SqlConnection();
      //  conn.ConnectionString = "Data Source=Z-EDBBD13F6D384;Initial Catalog=student;User Id=sa;Password=123456";
        conn.ConnectionString = "Data Source=192.168.1.108;Initial Catalog=student;User Id=sa;Password=123456";
        conn.Open();
        String sql = "select * from stutbl";
        SqlCommand command = new SqlCommand(sql, conn);   //创建 Command 对象
        SqlDataReader reder = command.ExecuteReader();
        while (reder.Read())
        {
            //读出内容列
            string str = reder["stu_name"].ToString();
            //读取分类列
            string str1 = reder["stu_pass"].ToString();
            //分别为文本框加载数据
        }  

 

posted @ 2013-07-17 23:19  double0zhou  阅读(146)  评论(0编辑  收藏  举报