SQL Server数据库基本操作类

最近在学习C#操作数据库，结合网上参与考的例子，放出来，希望这些简单的东西会给像与我一样起步的“菜鸟”们一点点帮助。

using System;
using System.Collections.Generic;
using System.Text;

namespace map_1.baseclass
{
        class Sql_DataBase
        {
建立数据库连接#region    建立数据库连接
                /// <summary>
                /// 建立数据库连接.
                /// </summary>
                /// <returns>返回SqlConnection对象</returns>
                public SqlConnection Get_con()
                {
                        string sqlstr = "Data Source=;Database=;Integrated Security=SSPI";
                        SqlConnection myCoon = new SqlConnection(sqlstr);
                        return myCoon;
                }
                #endregion

执行SqlCommand命令#region    执行SqlCommand命令
                /// <summary>
                /// 执行SqlCommand
                /// </summary>
                /// <param name="M_str_sqlstr">SQL语句</param>
                public void getcom(string M_sqlstr)
                {
                        SqlConnection sqlcon = this.getcon();
                        sqlcon.Open();
                        SqlCommand sqlcom = new SqlCommand(M_sqlstr, sqlcon);
                        sqlcom.ExecuteNonQuery();
                        sqlcom.Dispose();
                        sqlcon.Close();
                        sqlcon.Dispose();
                }
                #endregion

创建DataSet对象#region    创建DataSet对象
                /// <summary>
                /// 创建一个DataSet对象
                /// </summary>
                /// <param name="M_str_sqlstr">SQL语句</param>
                /// <param name="M_str_table">表名</param>
                /// <returns>返回DataSet对象</returns>
                public DataSet getds(string M_sqlstr, string M_table)
                {
                        SqlConnection sqlcon = this.getcon();
                        SqlDataAdapter sqlda = new SqlDataAdapter(M_sqlstr, sqlcon);
                        DataSet myds = new DataSet();
                        sqlda.Fill(myds, M_table);
                        return myds;
                }
                #endregion

创建SqlDataReader对象#region    创建SqlDataReader对象
                /// <summary>
                /// 创建一个SqlDataReader对象
                /// </summary>
                /// <param name="M_str_sqlstr">SQL语句</param>
                /// <returns>返回SqlDataReader对象</returns>
                public SqlDataReader getread(string M_sqlstr)
                {
                        SqlConnection sqlcon = this.getcon();
                        SqlCommand sqlcom = new SqlCommand(M_sqlstr, sqlcon);
                        sqlcon.Open();
                        SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
                        return sqlread;
                }
                #endregion
        }
}