Read the data from the database and output

2. Using System;
4. Using System.Collections.Generic;
6. Using System.Linq;
8. Using System.Text;
10. Using System.Data.SqlClient;
14. Namespace Login
16. {
18. Class Program
20. {
22. static void Main (string[] args)
24. {
26. //Create a new database connection
28. using (SqlConnection conn = new SqlConnection (Getconnectstring ()))
30. {
32. Conn. Open (); //Open Database
34. //console.writeline ("Database open successfully!");
36. //CREATE DATABASE command
38. SqlCommand cmd = conn. CreateCommand ();
40. //Create query Statements
42. Cmd.commandtext = "SELECT * from UserInfo";
44. //Read data stream from the database into reader
46. SqlDataReader reader = cmd. ExecuteReader ();
50. //Read the next line of data from reader, if there is no data, reader. Read () returns flase
52. While (reader. Read ())
54. {
56. //reader. GetOrdinal ("id") is the index of the column in which the ID is obtained .
58. //reader. GetInt32 (int n) This is the data in the nth column returned in the format Int32
60. //reader. GetString (int n) This is the data in column n is returned in string format
62. int id = reader. GetInt32 (reader.  GetOrdinal ("id"));
64. String name = Reader. GetString (reader.  GetOrdinal ("name"));
66. string pwd = reader. GetString (reader.  GetOrdinal ("password"));
68. int age = Reader. GetInt32 (reader.  GetOrdinal ("age"));
70. string sex = reader. GetString (reader.  GetOrdinal ("Sex"));
72. string phone = reader. GetString (reader.  GetOrdinal ("Phone"));
74. string address = reader. GetString (reader.  GetOrdinal ("Address"));
78. //Format output data
80. Console.Write ("id:{0},name:{1},pwd:{2},age:{3},sex:{4},phone{5},address:{6}\n", ID, Name, PWD, age, Sex, Phone,  address);
82. }
84. }
86. Console.readkey ();
88. }
90. //Get a database connection string
92. static string getconnectstring ()
94. {
96. return "Data source= (local); Initial catalog=db1;integrated security=sspi;";
98. }
100. }
102. }

Read data from the database and output