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


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")