自己写的SqlHelper,提示在调用"Fill"前,SelectCommand 属性尚未初始化.错误

时间:2014-12-12 23:25:45   收藏:0   阅读:458


namespace 操作数据
{
    class SqlHelper
    {
        public DataSet SqlTODs(string cmdstring)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlstring = System.Configuration.ConfigurationManager.ConnectionStrings["dbStr"].ConnectionString;
                using (SqlConnection conn = new SqlConnection(sqlstring))
                {
                    conn.Open();
                    //string cmd = cmdstring;
                    SqlCommand cmd = conn.CreateCommand();
                    cmd.CommandText = cmdstring;
                    SqlDataAdapter da = new SqlDataAdapter();
                    da.Fill(ds);
                    return ds;
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show("错误信息为:  " + ex.Message);
                return ds;
            }
          
        }
    }
}

原文:http://www.cnblogs.com/xiaoqisfzh/p/4160557.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!