面对执行中的问题?错误->你调用的对象是空的.在dap.InsertCommand.CommandType = CommandType.StoredProcedure;中行Plz帮助我其正常运行... [英] Facing Problem in execution? error--> Object reference not set to an instance of an object. in dap.InsertCommand.CommandType =CommandType.StoredProcedure; line Plz Help me its running properly...

问题描述

SqlDataAdapter dap = new SqlDataAdapter("HotelInsert", con);
        dap.InsertCommand.CommandType =CommandType.StoredProcedure;
        dap.InsertCommand.Parameters.AddWithValue("@Country", ddlCountry.SelectedValue);
        dap.InsertCommand.Parameters.AddWithValue("@City", ddlCity.SelectedValue);
        dap.InsertCommand.Parameters.AddWithValue("@HotelName", hotelName.Text);
        dap.InsertCommand.Parameters.AddWithValue("@HotelChain", ddlHotelChain.SelectedValue);
        dap.InsertCommand.Parameters.AddWithValue("@AlterHotelName", altHotelName.Text);
        dap.InsertCommand.Parameters.AddWithValue("@Recommanded", chkRecommended.Checked);
        dap.InsertCommand.Parameters.AddWithValue("@BidAllow", chkBid.Checked);
        dap.InsertCommand.Parameters.AddWithValue("@NCow", chkNCow.Checked);
        dap.InsertCommand.Parameters.AddWithValue("@starRating", ddlStarRating.SelectedValue);
        dap.InsertCommand.Parameters.AddWithValue("@PropertyType", ddlPropertyType.SelectedValue);

        //con.Open();
        DataSet ds=new DataSet();
        dap.Fill(ds);
        //cmd.ExecuteNonQuery();
        //con.Close();
    }

推荐答案

尝试如下:-----

Try as below:-----

SqlDataAdapter da=new SqlDataAdapter();
dap.InsertCommand.CommandText="HotelInsert";
dap.InsertCommand.CommandType =CommandType.StoredProcedure;
con.Open();


dap.InsertCommand.CommandType =CommandType.StoredProcedure;
dap.InsertCommand.Parameters.AddWithValue("@Country", ddlCountry.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@City", ddlCity.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@HotelName", hotelName.Text);
dap.InsertCommand.Parameters.AddWithValue("@HotelChain", ddlHotelChain.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@AlterHotelName", altHotelName.Text);
dap.InsertCommand.Parameters.AddWithValue("@Recommanded", chkRecommended.Checked);
dap.InsertCommand.Parameters.AddWithValue("@BidAllow", chkBid.Checked);
dap.InsertCommand.Parameters.AddWithValue("@NCow", chkNCow.Checked);
dap.InsertCommand.Parameters.AddWithValue("@starRating", ddlStarRating.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@PropertyType", ddlPropertyType.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@CheckinHour", CheckIn);
dap.InsertCommand.Parameters.AddWithValue("@CheckOutHour", CheckOut);
dap.InsertCommand.Parameters.AddWithValue("@WebUrl", WebUrl.Text);
dap.InsertCommand.Parameters.AddWithValue("@Address", Address.Text);
dap.InsertCommand.Parameters.AddWithValue("@Area", Area.Text);
dap.InsertCommand.Parameters.AddWithValue("@AddressCity", City.Text);
dap.InsertCommand.Parameters.AddWithValue("@State", State.Text);
dap.InsertCommand.Parameters.AddWithValue("@Pincode", PinCode.Text);
dap.InsertCommand.Parameters.AddWithValue("@ContactPersFname", fName.Text);
dap.InsertCommand.Parameters.AddWithValue("@ContactPersLname", lName.Text);
dap.InsertCommand.Parameters.AddWithValue("@MobileNum", MobileNum);
dap.InsertCommand.Parameters.AddWithValue("@LandLineNum", LandLine);
dap.InsertCommand.Parameters.AddWithValue("@EmailId", Email.Text);
dap.InsertCommand.Parameters.AddWithValue("@FaxNum", Fax.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionalfName", AdfName.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionallName", AdlName.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionalPurpose", AdPurpose.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionalMobileNum", AdMobile.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionallLineNum", AdlLine.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionalEmailID", AdeMail.Text);
dap.InsertCommand.Parameters.AddWithValue("@AdditionalFax", AdFax.Text);
dap.InsertCommand.Parameters.AddWithValue("@AboutHotel", abtHotel.Text);
dap.InsertCommand.Parameters.AddWithValue("@Gos", ddlGos.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@GosHotelCode", GHotelCode.Text);
dap.InsertCommand.Parameters.AddWithValue("@GosName", ddlGName.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@HotelMapCode", hotelMapCode.Text);
dap.InsertCommand.Parameters.AddWithValue("@Status", ddlStatus.SelectedValue);
dap.InsertCommand.Parameters.AddWithValue("@ModifiedBy", modifiedBy.Text);
dap.InsertCommand.Parameters.AddWithValue("@CreatedBy", createdBy.Text);

DataSet ds=new DataSet();
dap.Fill(ds);

InsertCommand属性为null.您必须创建一个Command对象并进行分配，例如

The InsertCommand property is null. You must create a Command object and assign it, e.g.

SqlDataAdapter dap = new SqlDataAdapter();
dap.InsertCommand =  new SqlCommand("HotelInsert", con);

然后继续您的代码.
顺便说一句

and then continue with your code.
By the way,

DataSet ds=new DataSet();
dap.Fill(ds);

在这里没有意义:您的SQL命令用于将数据写入数据库，而不是从数据库中检索数据.

does not make sense here: your SQL command is used to write data into the database, not to retrieve data from the database.

这篇关于面对执行中的问题?错误->你调用的对象是空的.在dap.InsertCommand.CommandType = CommandType.StoredProcedure;中行Plz帮助我其正常运行...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！