asp.net

[mzeewashooo]

iam trying to save records in a form to my mysql database. but i keep geting an error on the
cmd.ExecuteNonQuery line.

[gusano79]

Please post both the code and the error message; we can't help you if we don't know what's going on.

[mzeewashooo]

`Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
    Dim con As New MySqlConnection
    Dim cmd As New MySqlCommand
    Try
        con.ConnectionString = "Server=localhost;Database=rubber;Uid=root;Pwd=;"
        cmd.Connection = con
        con.Open()
        cmd.CommandText = "INSERT INTO customerdetails (ID,First Name,Second Name,Date,Quantity,Type) VALUES (@ID, @FirstName, @SecondName, @Date, @Quantity, @Type)"
        cmd.Parameters.AddWithValue("@ID", TextBox1.Text)
        cmd.Parameters.AddWithValue("@First Name", TextBox2.Text)
        cmd.Parameters.AddWithValue("@Second Name", TextBox3.Text)
        cmd.Parameters.AddWithValue("@Date", TextBox4.Text)
        cmd.Parameters.AddWithValue("@Quantity", TextBox5.Text)
        cmd.Parameters.AddWithValue("@Type", DropDownList1.Text)
        cmd.ExecuteNonQuery()
    Finally
        con.Close()
    End Try
End Sub`

[mzeewashooo]

the error is then like this,
An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll but was not handled in user code

Additional information: Fatal error encountered during command execution.

[mzeewashooo]

the it tells me that parameter @firstname should be declared

[gusano79]

Are you using the standard MySQL Connector/NET? That's what it looks like; I'm just making sure.

An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll but was not handled in user code

That means something's wrong with your query--can you put a Catch block in your code that prints out the exception details?

[gusano79]

Aha. I might have found your problem.

cmd.CommandText = "INSERT INTO customerdetails (ID,First Name,Second Name,Date,Quantity,Type) VALUES (@ID, @FirstName, @SecondName, @Date, @Quantity, @Type)"

The MySQL Connector/NET doesn't support '@' as a parameter indicator any more. You'll want to use '?' instead.

[mzeewashooo]

yeah, thanks alot. it has worked.

[mzeewashooo]

i have another problem please help me. the post is Asp.net and mysql. i posted it.