在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; namespace 练习 { class Program { static void Main(string[] args) { string sql= "select * from 图书属性表"; string connect = "server=.;database=Library;integrated security=SSPI"; SqlConnection conn = new SqlConnection(connect); conn.Open(); SqlCommand sc = new SqlCommand(sql, conn); SqlDataReader reader = sc.ExecuteReader(); // SqlDataAdapter sd = sc.ExecuteReader(); while(reader.Read()) { int tsbm = reader.GetInt32(0); string sm = reader.GetString(2); Console.WriteLine("{0}\t{1}\t\n",tsbm,sm); } Console.ReadKey(); } } }
|
请发表评论