-
从数据库中读出数据并输出
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Data.SqlClient;
-
- namespace Login
- {
- class Program
- {
- static void Main(string[] args)
- {
-
- using(SqlConnection conn = new SqlConnection(GetConnectString()))
- {
- conn.Open();
-
-
- SqlCommand cmd = conn.CreateCommand();
-
- cmd.CommandText = "SELECT * FROM userinfo";
-
- SqlDataReader reader = cmd.ExecuteReader();
-
-
- while (reader.Read())
- {
-
-
-
- int id = reader.GetInt32(reader.GetOrdinal("id"));
- string name = reader.GetString(reader.GetOrdinal("name"));
- string pwd = reader.GetString(reader.GetOrdinal("password"));
- int age = reader.GetInt32(reader.GetOrdinal("age"));
- string sex = reader.GetString(reader.GetOrdinal("sex"));
- string phone = reader.GetString(reader.GetOrdinal("phone"));
- string address = reader.GetString(reader.GetOrdinal("Address"));
-
-
- Console.Write("ID:{0},Name:{1},PWD:{2},Age:{3},Sex:{4},Phone{5},Address:{6}
", id, name, pwd, age, sex, phone, address);
- }
- }
- Console.ReadKey();
- }
-
- static string GetConnectString()
- {
- return "Data Source=(local);Initial Catalog=db1;Integrated Security=SSPI;";
- }
- }
- }
-
相关阅读:
Python爬取数据(基础,从0开始)
个人作业——软件测评
结对第二次作业
结对第一次作业
寒假作业(2/2)
个人作业———软工实践课程总结
Axios 介绍和使用
软件评测
结对第二次作业
结对第一次——疫情统计可视化(原型设计)
-
原文地址:https://www.cnblogs.com/yanyao/p/5616062.html
Copyright © 2020-2023
润新知