一、查询显示
引用命名空间: using System.Data.SqlClient;
1、连接数据库(数据库连接类)
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; namespace ado1 { class Program { static void Main(string[] args) { //数据库连接 SqlConnection s = new SqlConnection("server=.;database=banji0425;user=sa;pwd=123;"); //数据库操作 SqlCommand n = s.CreateCommand();//链接 让sqlcommand操作的是s这个类 n.CommandText = "select * from gongsi"; //数据库连接通道开启 s.Open(); //数据读取类 SqlDataReader dr = n.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { int age = DateTime.Now.Year - Convert.ToDateTime(dr["birthday"]).Year; string sex = ((bool)dr[2]) ? "男" : "女"; string shengri = Convert.ToDateTime(dr[3]).ToString("yyyy年mm月dd日"); string chengji = ((decimal)dr[5]).ToString("#.##"); Console.WriteLine("学号:" + dr[0] + ",姓名:" + dr[1] + ",性别:" + sex + ",生日:" + shengri + ",年龄:" + age + ",成绩:" + chengji); } } s.Close(); Console.ReadLine(); } } }
2、数据库操作(数据库操作类)
3、数据库数据读取(数据库读取类)