Winform Day1

数据库连接

           //创建连接
            SqlConnectionStringBuilder scab = new SqlConnectionStringBuilder();
            scab.DataSource = "数据库地址";
            scab.UserID = "账户";
            scab.Password = "密码";
            scab.InitialCatalog = "数据库名称j";

            //判断连接是否打开
            SqlConnection conn = new SqlConnection(scab.ToString());
            if (conn.State == System.Data.ConnectionState.Closed)
                conn.Open();

            //拼接SQL语句
            string strSQL = "sql语句 ";

            //执行查询语句
            SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "表名"); //表名可以自定义的，不需要和查询的表名一样

            //方法一
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "表名";

            //方法二
            dataGridView1.DataSource = ds.Tables["表名"];

            //方法三
            DataTable dt = ds.Tables["表名"];
            dataGridView1.DataSource = dt.DefaultView;