using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Collections.Generic;
namespace ConsoleApp3
{
class Program
{
static void Main(string[] args)
{ //studentname ,gender,birthday,studentidnumber,age,phonenumber,studentaddress,classid
string connectionString = "server=.;database=mydatabase082;uid=sa;pwd=886566";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string sql = "select studentname,gender,birthday,studentidnumber,age,phonenumber,studentaddress,classid from student ";
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataReader objReader = comm.ExecuteReader();
//conn.Close()
//objReader.Close();
List<Student> stulist = new List<Student>();
while (objReader.Read())
{
Student objstu = new Student();
objstu.studentname = objReader["studentname"].ToString();
objstu.gender = objReader["gender"].ToString();
stulist.Add(objstu);
}
Student objstu111 = new Student();
foreach ( Student item in stulist)
{
Console.WriteLine(item.studentname.ToString()+"\t"+ item.gender.ToString()+"\t");
Console.WriteLine("-------------------------------------------------------");
}
}
}
public class Student
{
public string studentname { get; set; }
public string gender { get; set; }
public DateTime birthday { get; set; }
public string studentidnumber { get; set; }
public int age { get; set; }
public int phonenumber { get; set; }
public string studentaddress { get; set; }
public int classid { get; set; }
}
}