简单的数据库调用

    /// <summary>
    /// 秋式开源团队---WinForm小组数据访问类 编写:铁公鸡-权
    /// 2011-04-19
    /// </summary>
    public class QSW_Data_Sql
    {
        string QSW_SqlCommand_Text = null;
        string QSW_SqlConnection_String = null;

        SqlConnection QSW_SqlConnection = null;
        SqlCommand QSW_SqlCommand = null;
        SqlDataAdapter QSW_SqlDataAdapter = null;
        DataSet QSW_DataSet = null;

        /// <summary>
        /// SQL连接字符串属性
        /// </summary>
        public string QSW_SqlConnectionString
        {
            get
            {
                return QSW_SqlConnection_String;

            }
            set
            {
                QSW_SqlConnection_String = value;
            }
        }

        /// <summary>
        /// SQL命令文本属性
        /// </summary>
        public string QSW_SqlCommandText
        {
            get
            {
                return QSW_SqlCommand_Text;
            }
            set
            {
                QSW_SqlCommand_Text = value;
            }
        }


        /// <summary>
        /// 根据查询文本查询数据库,并返回数据集。
        /// </summary>
        /// <param name="ConnectString">数据库连接字符串</param>
        /// <param name="CommandText">查询命令文本</param>
        /// <returns>返回数据通道填充了的数据集</returns>
        public DataSet QSW_SelectDatabase(string ConnectString,string CommandText)
        {
            QSW_SqlConnection = new SqlConnection(ConnectString);
            QSW_SqlConnection.Open();

            QSW_SqlCommand = new SqlCommand(CommandText, QSW_SqlConnection);
            QSW_SqlDataAdapter = new SqlDataAdapter(QSW_SqlCommand);
            QSW_DataSet = new DataSet();

            QSW_SqlDataAdapter.Fill(QSW_DataSet);

            return QSW_DataSet;
        }

    }

 

调用上面类的方法:

 QSW_Data_Sql qsw_data = new QSW_Data_Sql();
            qsw_data.QSW_SqlConnectionString = @"Data Source=LINHQ-PC;Initial Catalog=UR_Manage;Integrated Security=True";
            qsw_data.QSW_SqlCommandText = "SELECT * FROM Users";
           
            DataSet ds = qsw_data.QSW_SelectDatabase(qsw_data.QSW_SqlConnectionString, qsw_data.QSW_SqlCommandText);
            dataGridView1.DataSource = ds.Tables[0];

效果如下:

新浪微博粉丝精灵,刷粉丝、刷评论、刷转发、企业商家微博营销必备工具"
关键字
发表于:2011/4/18 20:44:29WINFORM  浏览(2278)  评论(0)