Procedure or function 'REGSTD' expects parameter '@FIRSTNAME', which was not supplied

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mboHassan
    New Member
    • Jul 2012
    • 1

    #1

    Procedure or function 'REGSTD' expects parameter '@FIRSTNAME', which was not supplied

    This is the code iam using
    .............
    Code:
      Dim con As New SqlConnection
            con.ConnectionString = " Data Source=(local)\sqlexpress; initial Catalog=SEC; Integrated security=true;   "
            con.Open()
            Dim cmd As New SqlCommand()
            cmd.CommandText = "REGSTD"
            cmd.CommandType = Data.CommandType.StoredProcedure
            cmd.Parameters.AddWithValue("STUDENT_ID", Txtid.Text)
            cmd.Parameters.AddWithValue("STUDENT_FNAME", Txtfname.Text)
            cmd.Parameters.AddWithValue("STUDENT_SNAME", TxtSName.Text)
            cmd.Parameters.AddWithValue("STUDENT_LNAME", TxtTName.Text)
            cmd.Parameters.AddWithValue("STUDENT_GNAME", TxtGName.Text)
            cmd.Parameters.AddWithValue("GENDER", DropDownListgender.SelectedItem.Value)
            cmd.Parameters.AddWithValue("PLACEOFBIRTH", TxtPOB.Text)
            cmd.Parameters.AddWithValue("MOTHER_NAME", TxtFMotherName.Text)
            cmd.Parameters.AddWithValue("School", DropDownListSchool.SelectedItem.Value)
            cmd.Parameters.AddWithValue("Region", DropDownListRegion.SelectedItem.Value)
            cmd.Parameters.AddWithValue("District", DropDownListDistrict.SelectedItem.Value)
            cmd.Parameters.AddWithValue("STREAM", DropDownListStream.SelectedItem.Value)
            cmd.Parameters.AddWithValue("BATCH", TxtBatch.Text)
            cmd.Parameters.AddWithValue("Photo", FileUploadPhoto.FileName)
            cmd.Parameters.AddWithValue("Approval", TxtApproval.Text)
            cmd.Parameters.AddWithValue("ApprovedDate", TxtApprovalDate.Text)
            cmd.Connection = con
            Label19.Text = cmd.ExecuteScalar
    
            con.Close
    Last edited by Rabbit; Jul 9 '12, 03:18 PM. Reason: Please use code tags when posting code.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Please use code tags when posting code.

    That error message can't be clearer. It's looking for the parameter '@FIRSTNAME', which you didn't supply.

    Comment

    Working...