• C# winform 读取数据库并显示成datagrid


    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.SqlClient;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Windows.Forms;
    
    
    namespace WindowsFormsApplication2 {
        public partial class Form1 : Form {
            public Form1() {
                InitializeComponent();
            }
    
    
            private void Form1_Load(object sender, EventArgs e) {
               
            }
    
            private void button1_Click(object sender, EventArgs e) {
                //string sql = "select * from persons";
                //string connectstr = @"Password=myPassword;Persist Security Info=True;User ID=sa;Initial Catalog=TESTDB;Data Source=IETEST\SQLEXPRESS";
                //using (SqlConnection conn = new SqlConnection(connectstr)) {
                //    conn.Open();
                //    SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
                //    DataSet ds = new DataSet();
                //    ada.Fill(ds);
                //    dataGridView1.DataSource = ds.Tables[0];
                //};
    
                string sql = "select * from persons";
                string conectionStr = @"Password=sa123456;Persist Security Info=True;User ID=sa;Initial Catalog=TESTDB;Data Source=IEGUORENJIE\SQLEXPRESS";
                using (SqlConnection conn = new SqlConnection(conectionStr)) {
                    conn.Open();
                    SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
                    DataSet ds = new DataSet();
                    ada.Fill(ds);
                    dataGridView1.DataSource = ds.Tables[0];
                }
            }
    
            private void toolStripMenuItem1_Click(object sender, EventArgs e) {
    
            }
    
            private void 图1ToolStripMenuItem_Click(object sender, EventArgs e) {
    
            }
        }
            
    }
    
  • 相关阅读:
    记录一次redis-shake跨云迁移阿里云redis混合型到腾讯云tendis
    nginx 通过配置文件切割访问日志
    saltstack 批量修改hostname
    linux 免交互式修改密码
    zabbix 接入钉钉机器人报警
    监控体系
    zabbix自动化监控三种方式
    zabbix 自定义脚本监控activemq
    2021.07.20 总结
    微信小程序总结
  • 原文地址:https://www.cnblogs.com/grj001/p/12225671.html
Copyright © 2020-2023  润新知