C#对PostgreSQL的操作

最新推荐文章于 2024-08-02 17:37:29 发布

weixin_30877755

最新推荐文章于 2024-08-02 17:37:29 发布

阅读量292

点赞数

文章标签：数据库 c#

原文链接：http://www.cnblogs.com/bulege/archive/2011/11/01/2231195.html

版权

需要添加2个dll文件:Mono.Security.dll; Npgsql.dll。
例子大家自己参考一下:

         private void button1_Click(object sender, System.EventArgs e)
         {
            richTextBox1.Text = string.Format(
                 "Server={0};Port={1};Userid={2};database=testdb;password={3};Protocol=3;SSL=false;Pooling=true;MinPoolSize=1;MaxPoolSize=20;Encoding=UNICODE;Timeout=60;SslMode=Disable",
                 textBox1.Text.Trim(), textBox2.Text.Trim(), textBox3.Text.Trim(), textBox4.Text.Trim());
 
             NpgsqlConnection conn = new NpgsqlConnection();
             conn.ConnectionString = richTextBox1.Text;
 
            NpgsqlCommand comm = new NpgsqlCommand();
            comm.Connection = conn;
            conn.Open();
            comm.CommandText = @"select * from datas;";
            DataSet ds = new DataSet();
            NpgsqlDataAdapter sda = new NpgsqlDataAdapter();
            sda.SelectCommand = comm;
            sda.Fill(ds, "datas");
            if (ds.Tables[0].Rows.Count != 0)
            {
                dataGrid1.DataSource = ds.Tables["datas"];
                MessageBox.Show("OK");
            }
            conn.Close();
        }

转载于:https://www.cnblogs.com/bulege/archive/2011/11/01/2231195.html