Winform 连接 Oracle数据库查询表所有信息在 dataGridView中显示

最新推荐文章于 2021-07-22 21:14:58 发布

凌霜残雪

最新推荐文章于 2021-07-22 21:14:58 发布

阅读量3.4k

点赞数 1

分类专栏： C# Winform 文章标签： dataGridView数据绑定 Oracle数据库连接

本文链接：https://blog.csdn.net/qq_21419015/article/details/83855542

版权

C# Winform 专栏收录该内容

7 篇文章 2 订阅

订阅专栏

1 连接数据库查询数据以DataTable返回值

    public static DataTable GetPlanList()
        {
            DataTable dt = new DataTable();
            try
            {
                string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.111.11.11)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DB1)));Persist Security Info=True;User ID=user1;Password=1234;";
                OracleConnection conn = new OracleConnection(connString);
                conn.Open();
                string sqlStr = "select * from test";
                OracleCommand cmd = new OracleCommand(sqlStr, conn);
                OracleDataAdapter da = new OracleDataAdapter(cmd);
                da.Fill(dt);
                cmd.Dispose();
                conn.Dispose();
                return dt;
            }
            catch (Exception ee)
            {
                throw ee; //如果有错误，输出错误信息
            }
        }

2、窗体展示

public static DataTable dtP;                //生产计划表  
private void Form1_Load(object sender, EventArgs e)
        {
            //生产表初始化
            dtP = new DataTable();       
            dtP.Columns.Add("钢坯号", typeof(String)); 
            dtP.Columns.Add("炉号", typeof(String));
            dtP.Columns.Add("钢种", typeof(String));
            dtP.Columns.Add("厚度", typeof(String));
            dtP.Columns.Add("宽度", typeof(String));
            dtP.Columns.Add("长度", typeof(String));
            dtP.Columns.Add("时间", typeof(DateTime));

            dt = GetPlanList();
                    modelp.Numbers = dt.Rows[i]["Numbers"].ToString();
                    modelp.Heat = dt.Rows[i]["Heat"].ToString();
                    modelp.Steels = dt.Rows[i]["Steels"].ToString();
                    modelp.Thick = dt.Rows[i]["Thick"].ToString();
                    modelp.Widths = dt.Rows[i]["Widths"].ToString();
                    modelp.Lengths = dt.Rows[i]["Lengths"].ToString();
                    modelp.Datetime = Convert.ToDateTime(dt.Rows[i]["Datetime"].ToString());               
            DataRow row = dtP.NewRow();          
            row["钢坯号"] = modelp.Numbers;
            row["炉号"] = modelp.Heat;
            row["钢种"] = modelp.Steels;
            row["厚度"] = modelp.Thick;
            row["宽度"] = modelp.Widths;
            row["长度"] = modelp.Lengths;
            row["时间"] = modelp.Datetime;
            dtP.Rows.Add(row);
            dataGridView1.DataSource = dtP;
            dataGridView1.Columns[0].Width = 60;
            dataGridView1.Columns[1].Width = 100;
            dataGridView1.Columns[2].Width = 100;
            dataGridView1.Columns[3].Width = 100;
            dataGridView1.Columns[4].Width = 100;
            dataGridView1.Columns[5].Width = 100;
            dataGridView1.Columns[6].Width = 100;
            dataGridView1.Columns[7].Width = 100;
        }