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



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

    原因是:没有给SqlDataAdapter传递参数  ,

  • 相关阅读:
    情书2
    情书1
    python_数据分析_正态分布
    python3调用R语言干货
    常见混淆名词
    PID算法图形 python
    A*寻路算法 python实现
    用tensorflow object detection api做手势识别
    tf识别非固定长度图片ocr(数字+字母 n位长度可变)- CNN+RNN+CTC
    tf识别固定长度验证码图片ocr(0到9 4位)- CNN方式
  • 原文地址:https://www.cnblogs.com/xiaoqisfzh/p/4160557.html
Copyright © 2020-2023  润新知