INSERT function in ASP.NET

[zaiena]

hi
i'm using asp.net(vb lamguage),and trying to write an sql statemnet to insert values in my table,i'have tried many ways but no one work as i need tere is alawya an error.i'm also using componentart tools and try to insert values in the table to appear at grid.
here is my last one
cmd.CommandText = "insert into std_t(std_no,std_name)values(@std_no,@std_name)"

can any one help or have another ideas.
thanx lot

[JamieHowarth0]

Hi zaiena,

Your question is a .NET-specific one and so has been moved to the .NET Forum.

With regard to INSERT statements, I'm a newbie to ASP.NET but I believe that if you use a DataSet and add an INSERT function to the TableAdapter then you can call that from your ASP.NET code (if you're using Visual Web Developer).

Best regards,

medicineworker

[jaz215]

hi
i'm using asp.net(vb lamguage),and trying to write an sql statemnet to insert values in my table,i'have tried many ways but no one work as i need tere is alawya an error.i'm also using componentart tools and try to insert values in the table to appear at grid.
here is my last one
cmd.CommandText = "insert into std_t(std_no,std_name)values(@std_no,@std_name)"

can any one help or have another ideas.
thanx lot

you talked about errors, maybe we could see about your errors and that we can solve it from there :P
could you note what are you using to develop asp so we can better help you..
regarding you query have you tried using:

comInsert.CommandText = "Insert into [Table] values " & _
                                    "('" & firstvalue & "', " & _
                                    "'" & value2 & "', " & _
                                    "'" & value3 & "', " & _
                                    "'" & value4 & "', " & _
                                    "'" & lastvalue & "')"
 
comInsert.ExecuteNonQuery()