Procedure or function has too many arguments specified

Procedure or function has too many arguments specified

• clrudolphi

  Thanks alot man... the parameter was added in the InitializeComponent. Once again TY.. i was lost .  
  
  

• Crystal1

  I would have to see your code that initilizes sqlSelectCommand1 to be sure (which should be located in InitializeComponent, but I suspect that you have two parameters called "@xqxqID" - one created in InitializeComponent and the other created in your code above. So you're sending the stored proc two parameters when it's expecting only one. Try instead:
  
  try {
    int xqxqID = int.Parse(txt.Text); // I prefer int.Parse rather than Convert.*
    sqlConnection1.Open();
    sqlSelectCommand1.Parameters["@xqxqID"] = 219760896;
    sqlDataAdapter1.Fill(myDataSet21);
    DataGrid2.DataBind();
  } finally {
    if (sqlConnection1 != null) {
      sqlConnection1.Close();
    }
  }
  
  

• Learning

  It would be much more helpful to see the entire code snippet used to call the stored procedure and the interface of the stored procedure.
  
  Showing us an exception without code makes it near impossible to figure out what is wrong.
  
  
  

• bram

  
  try

  {

  int xqxqID;

  xqxqID = Convert.ToInt32(txt.Text);
  sqlConnection1.Open();

  sqlSelectCommand1.Parameters.Add("@xqxqID", 219760896);

  sqlDataAdapter1.Fill(myDataSet21);

  DataGrid2.DataBind();

  }

  finally

  {

  if (sqlConnection1 != null)

  {

  sqlConnection1.Close();

  }

  }
  
  Once again Thank you... i tried with DataReader and it works.. any ideeas how can fill a data set with DataReader.
  
  
  

  SqlConnection conn = null;

  SqlDataReader rdr = null;

  int xqxqID= 219760;

  try

  {

  conn = new

  SqlConnection("Server=(local);DataBase=xqxq2;Integrated Security=SSPI");

  conn.Open();

  SqlCommand cmd = new SqlCommand("xqxq", conn);

  cmd.CommandType = CommandType.StoredProcedure;

  cmd.Parameters.Add(new SqlParameter("@xqxqID", xqxqID));

  
  rdr = cmd.ExecuteReader();

  while (rdr.Read())

  {

  Response.Write(rdr["xqxq_id"]);

  }

  }

  finally

  {

  if (conn != null)

  {

  conn.Close();

  }

  if (rdr != null)

  {

  rdr.Close();

  }

  }

  }

  
  
  
• Procedure or function has too many arguments specified