inserting data in sql

[Asmakhan]

hi! we are facing problems while inserting data into the table.we are sending u the code which we are trying to run.when we run it we get the message that "you must declare @custmer_id" Me.insertCmd.Connection = New SqlClient.SqlConnection(Me.conString) Me.insertCmd.CommandText = "INSERT INTO [SARAMARIAM\ASPNET].[customer new account] (customer_id, first_name, " & _ "last_name, password, email, [company name], address, [alternative address], city" & _ ", [postal code], country, phone, fax) VALUES (@customer_id, @first_name, @last_n" & _ "ame, @password, @email, @Param1, @address, @Param2, @city, @Param3, @country, @p" & _ "hone, @fax)" myCommand = New SqlClient.SqlCommand(Me.insertCmd.CommandText, Me.insertCmd.Connection) myCommand.Parameters.Add(New SqlClient.SqlParameter("@customer_id", _ SqlDbType.VarChar, 11)) myCommand.Parameters("@customer_id").Value = customer_id looking forward to your reply bye

[padvit]

HI there, Why dont you try with only 2 parameters may be u r going wrong with parameter supply Padvit

[Alsvha]

Well - stupid questions first, but have you infact assigned values to your parameters (all the @'s) somewhere in your code? --------------------------- 127.0.0.1 - Sweet 127.0.0.1