[fei_hyblade]

ok,i write a code for sql insert in a button like this :

Dim stringAdd As String = "Insert into Maintenance_Table (hardware_desc) values ('"& desc & "')



Dim objcommand As New SqlClient.SqlCommand(stringAdd, New _
SqlClient.SqlConnection("workstation id=max;packet size=4096;integrated security=SSPI;initial catalog=nosys;persist security info=False"))

objcommand.Connection.Open()
objcommand.ExecuteNonQuery()
objcommand.Connection.Close()

objcommand.Dispose()
objcommand = Nothing

and it gives me an error at objcommand.executenonquery().do you know why?? please help .btw,is there any weakness using those pre made data component (data adapter,connection,etc) from windows form? this far i made the program with pure coding .

This post has been edited by fei_hyblade: 12 May 2005 - 12:01 AM

[Amadeus]

What error does it give you? As an fyi, your SQL string is not completely enlcosed in quotes...it should look something like this:

Dim stringAdd As String = "Insert into Maintenance_Table (hardware_desc) values ('"& desc & "')"

[fei_hyblade]

got it fixed ,the error is in my database,i forgot that i declare all of them the "not null" constraint,while i'm testing of inserting only two columns .that figures,solved the problem,the syntax works perfectly