Hi wrox,
i've been trying to save data into sql server database with this code
on saving, it gives me no error but it doesnt save in the database too
kindly help me

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim connection As SqlConnection = Nothing

Dim conn As String = ConfigurationManager.ConnectionStrings("CrimeManag ementConnectionString").ConnectionString
connection = New SqlConnection(conn)

connection.Open()
Dim sql As String = "INSERT INTO Case(ComplainantName,ContactNumber) VALUES(@ComplainantName, @ContactNumber)"
Dim cmd As SqlCommand = New SqlCommand(sql, connection)
cmd.Parameters.AddWithValue("@ComplainantName", txtCmplntName.Text.Trim())
cmd.Parameters.AddWithValue("@ContactNumber", txtCmplntContact.Text.Trim())
connection.Close()

Response.Redirect("ComplainMain.aspx")

End Sub