c#连接数据库进行操作

最新推荐文章于 2024-03-08 16:30:32 发布

极客-杀生丸

最新推荐文章于 2024-03-08 16:30:32 发布

阅读量115

点赞数

分类专栏：学习 c#

本文链接：https://blog.csdn.net/weixin_44772948/article/details/106046961

版权

学习同时被 2 个专栏收录

51 篇文章 0 订阅

订阅专栏

1 篇文章 0 订阅

订阅专栏

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 WindowsFormsApp2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            SqlConnectionStringBuilder db = new SqlConnectionStringBuilder();
            db.DataSource = "127.0.0.1";
            db.UserID = "sa";
            db.Password = "123456789";
            db.InitialCatalog = "bookshop";
            SqlConnection conn = new SqlConnection(db.ToString());
            if (conn.State == System.Data.ConnectionState.Closed)
                conn.Open();
            string strSQL = "select * from [bookshop].[dbo].[user]";
            SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "user");
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "user";

    
        }
    }
}