C#.net4.5连接达梦数据库

C#.net4.5连接达梦数据库

官方网址：https://eco.dameng.com/document/dm/zh-cn/app-dev/dot-Net-Data-Provider.html

很简单：

private void button1_Click(object sender, EventArgs e)
{
    DmConnection conn = new DmConnection("Server=127.0.0.1:5236; UserId=SYSDBA; PWD=666666;");
    DataSet ds = new DataSet();
    DataTable dt = null;
    try
    {   
        conn.Open();
        DmCommand cmd = new DmCommand("select * from jxkh.h_zhibiao;", conn);
        //DbDataReader dr = cmd.ExecuteReader();
        DmDataAdapter da = new DmDataAdapter(cmd);
        da.Fill(ds);
        dt = ds.Tables[0];
        //
        grd_main.AutoGenerateColumns = true;
        grd_main.DataSource = dt;
    }
    catch (Exception x)
    {
        MessageBox.Show(x.Message);
    }
    finally
    {   //释放资源
        conn.Close();
    }
}