编写一个控制台应用程序,将MySchool中Teacher表中的TeacherId、Sex、TeacherName打印出来
运行结果:
static void Main(string[] args)
{
string connString = "Data Source=.;Initial Catalog=MySchool;Uid=sa;Pwd=123456;";
SqlConnection connection = new SqlConnection(connString);
string sql = "select TeacherId,Sex,TeacherName from Teacher";
SqlCommand command = new SqlCommand(sql, connection);
try
{
connection.Open();
SqlDataReader dataReader = command.ExecuteReader