C#本地操作数据库

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;
    }
}