C#学习笔记（1）__连接数据库

1.使用SQLSever连接数据库

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;
using MySql.Data.MySqlClient;

namespace WindowsFormsApp3
{
    public partial class 测试连接 : Form
    {
        public 测试连接()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string mystr;
            SqlConnection myconn = new SqlConnection();
 
            String cstring = @"Data Source=(localdb)\ProjectsV13;Initial Catalog=mysql;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
            myconn.ConnectionString = cstring;
            try
            {
                myconn.Open();
                if (myconn.State == ConnectionState.Open)
                    label1.Text = "成功连接到数据库";
                else
                    label1.Text = "不能连接到数据库";
            }
            catch (Exception ex)
            {
                label1.Text = ex.Message;
            }
            finally
            {
                if (myconn.State == ConnectionState.Open)
                    myconn.Close();
            }
        }
    }
}

2.SQLCommand类

ExecuteReader 一般用于查询语句，用 SqlDataReader 存储查询后的结果集
ExecuteNonQuery 一般用于执行插入、删除、修改语句

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;
using Microsoft.CSharp.RuntimeBinder;

namespace WindowsFormsApp3
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
			//建立数据库连接
            SqlConnection sqlConnection = new SqlConnection();
            String cstring = @"Data Source=(localdb)\ProjectsV13;Initial Catalog=mysql;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
            sqlConnection.ConnectionString = cstring;
            sqlConnection.Open();

            String sql = "SELECT * FROM stu";
            SqlCommand cmd = new SqlCommand(sql, sqlConnection);//执行SQL语句
            SqlDataReader reader = cmd.ExecuteReader();//获取数据库数据
            String titie = "学号\t姓名\t\t课程名\t\t分数\t"+"\r\n";
            textBox1.AppendText(titie);
            while (reader.Read())
            {
                textBox1.AppendText(reader[0].ToString() + "\t"+ reader[1].ToString()+"\t"+reader[2].ToString()+"\t"+reader[3].ToString()+"\t"+"\r\n");
            }
            reader.Close();
            sqlConnection.Close();

        }
    }
}

3.补充内容

1.数据库字符串信息

2.数据库数据类型

nchar(20) 固定长度，固定为20
nvarchar(20) 可变长度，最长为20
都可以用于存储中文

3. 访问字段中的值

 reader.GetInt32(0);	//第一列的值
 reader[1].ToString();	//第二列的值
 reader["姓名"].ToString();	//姓名那一列的值