c# datagridview 和 链接数据库例子

来源:互联网 发布:国际化 数据库设计 编辑:程序博客网 时间:2024/05/20 20:18
 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";


原创粉丝点击