using System; using System.Data; using System.Data.SqlClient; public sealed class Student { public static int Main() { try { //当服务器与程序不是在同一台电脑时,需要指定服务器名 string connectionString = "server=localhost;" + "database=studentInfo;UID=sa;PWD=tianshi520"; //创建Connection对象 SqlConnection mySqlConnection = new SqlConnection(connectionString); //创建Command对象 SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); string sqlStatement = "select sno, sname, sage, ssex, sdept from student where sage = 21"; //设置CommandText属性 mySqlCommand.CommandText = sqlStatement; //设置CommandTimeout属性 mySqlCommand.CommandTimeout = 20; //生成SqlDataAdapter对象 SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); //设置SelectCommand属性 mySqlDataAdapter.SelectCommand = mySqlCommand; //生成DataSet对象,存储Select语句的结果 DataSet myDataSet = new DataSet(); //打开数据库 mySqlConnection.Open(); //用SqlDataAdapter对象的Fill()方法从表中取行 //其中stuInfo是新起的表名,以存储结果 mySqlDataAdapter.Fill(myDataSet, "stuInfo"); //关闭数据库 mySqlConnection.Close(); //用tables属性取得指定的表 DataTable myDataTable = myDataSet.Tables["stuInfo"]; //显示表中每一行内容 foreach (DataRow myDataRow in myDataTable.Rows) { Console.WriteLine("Sno: " + myDataRow["Sno"]); Console.WriteLine("Sname: " + myDataRow["Sname"]); Console.WriteLine("Sage: " + myDataRow["Sage"]); Console.WriteLine("Ssex: " + myDataRow["Ssex"]); } } catch (SqlException e) { Console.WriteLine(e.StackTrace); Console.WriteLine(e.Errors); } return 0; } }