Comments by RajkumarGnanaraj (Top 12 by date)

i opened database nothing was there

not giving error it is not showing in videosource event list

Dim connectionString As String = ConfigurationManager.ConnectionStrings("ConString").ConnectionString
Dim conn As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(query, conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@fName", txtFirstName.Text)
cmd.Parameters.AddWithValue("@Lname", txtLName.Text)
cmd.Parameters.AddWithValue("@Sex", CBSex.SelectedItem.ToString)
cmd.Parameters.AddWithValue("@DOB", Convert.ToDateTime(DTDOB.Text))
cmd.Parameters.AddWithValue("@Age", txtAge.Text)
cmd.Parameters.AddWithValue("@Address", txtAddress.Text)
cmd.Parameters.AddWithValue("@phno", txtPhNo.Text)
cmd.Parameters.AddWithValue("@Email", txtEmail.Text)
cmd.Parameters.AddWithValue("@IdNo", txtIDNo.Text)
cmd.Parameters.AddWithValue("@contactPerson", txtContactPerson.Text)
cmd.Parameters.AddWithValue("@Relation", txtRelation.Text)
cmd.Parameters.AddWithValue("@claimid", SqlDbType.VarChar)
cmd.Parameters("@claimid").Direction = ParameterDirection.Output
cmd.Parameters.AddWithValue("@cpPhno", txtCPPhno.Text)
cmd.Parameters.AddWithValue("@Photo", profilepicture)
cmd.Parameters.AddWithValue("@ID", idorpassport)
Dim a As Integer
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
'If Not String.IsNullOrEmpty(cmd.Parameters("@claimid").Value.ToString) Then
If a > 0 Then
MessageBox.Show("Data Added successfully and your clientID is :" & cmd.Parameters("@claimid").Value.ToString)
Else
MessageBox.Show("Please try Again")
End If

BEGIN
if @Sex='Male'
begin
set @Sex='M'
end
if @Sex='Female'
begin
set @Sex='F'
end

insert into Client(FirstName,LastName,Sex,DOB,Age,[Address],PhNo,email,[IDCard/passNumber],ContactPerson,Relation,TelephoneNOContact,Created_date,photo,
[pass/idcard]) values(@fName,@Lname,@Sex,@DOB,@Age,@Address,@phno,@Email,@IdNo,@contactPerson,@Relation,@cpPhno,GETDATE(),@Photo,@ID)

select @claimid=ClientID from dbo.Client where clientcode=SCOPE_IDENTITY()
End

I changed like this

@Richard Deeming i want varchar as output i removed return @claimid line .but i am getting same error