c# ado.net 简单实验

原创于 2021-05-14 16:05:21 发布 · 221 阅读

1 ·

CC 4.0 BY-SA版权

c# 专栏收录该内容

192 篇文章

订阅专栏

该代码示例展示了如何使用C#的SqlConnection和SqlCommand类连接到SQL数据库并执行查询。程序通过Integrated Security连接到本地db1数据库，并读取tb1表中的所有数据，将查询结果打印到控制台。

概要

SqlConnection .ConnectionString .Open()

SqlCommand .Connection .CommandText .ExecuteReader()

SqlDataReader []

代码

CREATE TABLE tb1(
	id int,
	v1 int
)

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace dataTest
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = new SqlConnection();
            //conn.ConnectionString = "Data Source=127.0.0.1;Initial Catalog=db1;User ID=sa;Password=sa@123";
            conn.ConnectionString = "Data Source=.;Initial Catalog=db1;Integrated Security=True";
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "select * from tb1";
                cmd.Connection = conn;
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    string str = reader["id"].ToString();
                    Console.WriteLine(str);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
            conn.Close();
            Console.ReadKey();
        }
    }
}

执行结果