EndExecuteNonQuery Error

本文关键字:Error EndExecuteNonQuery | 更新日期: 2023-09-27 17:51:08

我有一个错误,这是在按钮单击事件,因为它显示了一个错误消息在这一行:

com.EndExecuteNonQuery ();

消息文本:错误2没有重载方法'EndExecuteNonQuery'接受0个参数

感谢您的支持

  protected void Page_Load(object sender, EventArgs e)
{
    if (IsPostBack)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["usradmadslistview"].ConnectionString);
        conn.Open();
        string cmdStr = "Select count(*) from UserInfo where UID = '" + UsrNme.Text + "'";
        SqlCommand com = new SqlCommand(cmdStr, conn);
        int temp = Convert.ToInt32(com.ExecuteScalar().ToString());

        if (temp == 1)
        {
            chkusrnamlbl.Visible = true;
        }
        conn.Close();
    }
}


protected void btnSave_Click(object sender, EventArgs e)
{
    try
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["usradmadslistview"].ConnectionString);
        conn.Open();
        string insertquery = "insert into UserInfo (UID,FN,LN,Password,Email,CountID,State,City) Values (@username,@firstn,@lastn,@passbox,@email1,@country,@state,@city)";
        SqlCommand com = new SqlCommand(insertquery, conn);
        com.Parameters.AddWithValue("@username", UsrNme.Text);
        com.Parameters.AddWithValue("@firstn", fnbox.Text);
        com.Parameters.AddWithValue("@lastn", lnamebox.Text);
        com.Parameters.AddWithValue("@passbox", passtxtbx1.Text);
        com.Parameters.AddWithValue("@email1", emailbox.Text);
        com.Parameters.AddWithValue("@country", DrDncoundrlst.SelectedItem.ToString());
        com.Parameters.AddWithValue("@state", DropDownListSwestate.SelectedItem.ToString());
        com.Parameters.AddWithValue("@city", citytxtbox.Text);
        com.EndExecuteNonQuery();
        Response.Redirect("User panel.aspx");
        conn.Close();
    }
   catch(Exception ex) {
        Response.Write("Error:" + ex.ToString());
    }

EndExecuteNonQuery Error

EndExecuteNonQuery需要一个MSDN中提到的IAsyncResult参数。

还有,这只是一个代码片段吗?因为我认为你会想用com.ExecuteNonQuery()代替。EndExecuteNonQuery是异步执行SQL语句的结束对