General information
Title:
Add record using vb.net in sql server 2000
I write following code for insert record.
Dim invenConn As SqlConnection = New SqlConnection("Data Source=DEVELOPE;Integrated Security=SSPI;" & _
"Initial Catalog=inventory")
Dim Invecmd As SqlCommand = New SqlCommand("INSERTGODOWN", invenConn) 'Declare For Sql Command
Invecmd.CommandType = CommandType.StoredProcedure
Dim MyParm As SqlParameter 'Declare For Parameters
MyParm = Invecmd.Parameters.Add("@godname", SqlDbType.VarChar, 15)
MyParm.Value = LTrim(txtGodownName.Text)
invenConn.Open()
Invecmd.ExecuteNonQuery()
Invenconn.Close()
Invecmd.Dispose()
Invenconn.Dispose()
Executing above code follwoing message occure
an unhandled execption of type 'System.data.Sqlclient.Sqlexecption'
occurred in syystem.data.dll
Aditional information : system error.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only