c# datagridview 和 链接数据库例子

 string conn_sring = "Data Source=127.0.0.1;Initial Catalog=atm;Persist Security Info=True;User ID=sa;Password=123";
 DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
            DbConnection conn = factory.CreateConnection();
            conn.ConnectionString = conn_sring;
            conn.Open();
            DbDataAdapter adapter = factory.CreateDataAdapter();
            DbCommand command = conn.CreateCommand();
            command.CommandText = "select * from [user]";
            command.CommandType = CommandType.Text;
            adapter.SelectCommand = command;
            DataTable ds = new DataTable();
            adapter.Fill(ds);
            this.dataGridView1.AutoGenerateColumns = true;
            this.dataGridView1.DataSource = ds;
            this.dataGridView1.DataMember = "user";