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
Comment