ruhe链接数据库

        private void button1_Click(object sender, EventArgs e)

        {

            using(SqlConnection conn = new SqlConnection(GetConnectString()))

            {

                conn.Open();//打开数据库

                SqlCommand cmd = conn.CreateCommand();//查询

                cmd.CommandText = "SELECT * FROM student where id='" + textBox1.Text+"'";

                SqlDataAdapter sda = new SqlDataAdapter(cmd);

                DataTable P_dt = new DataTable();

                sda.Fill(P_dt);

                this.dataGridView1.DataSource = P_dt;

            }

        }

        //得到一个数据库连接字符

        static string GetConnectString()

        {

            string connStr = "Data Source = VOI105-PC022;Integrated Security = SSPI;database=stu";//需要查询本台机器的数据源

            return connStr;

        }

        }

    }

namespace WindowsFormsApplication5  要附加的