我在用插入数据并显示时出现,,在调用“Fill”前，SelectCommand 属性尚未初始化

Question

如果是更新内容:
OleDbConnection conn = new OleDbConnection();
        OleDbCommand comm = new OleDbCommand();
        conn.ConnectionString = connst;
        comm.Connection = conn;
        comm.CommandText = a;
        try
        {
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
        }
        catch (Exception ex)
        {
            //HttpResponse myex = new HttpResponse(ex);
            //myex.Write(ex);
        }
        finally
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
        }
如果是绑定 OleDbConnection conn = new OleDbConnection(connst);
        conn.Open();
        OleDbCommand comm = new OleDbCommand(a, conn);
        OleDbDataAdapter myAdp = new OleDbDataAdapter(a, conn);
        DataSet myDt = new DataSet();
        try
        {
            myAdp.Fill(myDt);        }
        catch (OleDbException ex)
        {
        }
        finally
        {
            conn.Close();
        }你是插入新内容还是绑定啊?

Answer 1

ole_adap.Fill(inse_set, "first01");执行有问题，
你ole_adap.SelectCommand没有实例化怎么填充数据.
参考这里，
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx

Answer 2

ole_adap.SelectCommand没有实例化,所以报尚未初始化...
SelectCommand.CommandText和Connection两个属性是必须的,
调用fill方法,会自动调用连接的Open()和Close()方法.