Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sinjin67
Yak Posting Veteran
53 Posts |
 Posted - 2008-12-24 : 16:25:59
|
| G'Day, I think I have over did this. I am trying to create a buttonin my app that will call a Stored Procedure. I believe I am in the ballpark and could use some advice on whats wrong with the folowing..Thanks Dim varAdapter As New SqlDataAdapter() Dim varConnection As New SqlConnection() Dim varQuery As String Dim varCommand As Sqlcommand Dim varUpdateCommand As Sqlcommand varConnection = New SqlConnection("server=PLUTO\PLUTO;Database=core8label;Trusted_Connection=no;User Id=sa;Password=timex2112") varConnection.Open() varQuery = New SqlCommand("@MYSPTEST") varCommand.commandtype = Commandtype.StoredProcedure varAdapter.DeleteCommand = varCommand varAdapter.UpdateCommand = varUpdateCommand varCommand.ExecuteNonQuery() varCommand.Dispose() varConnection.Close() |
|
|
sinjin67
Yak Posting Veteran
53 Posts |
Posted - 2008-12-24 : 16:42:14
|
| Ok, After some reading and search at the MSDN stuff I found a good example to show me what I was doing wrong.. Maybe somebody else might need this info, So here you go.. Dim sqlConnection1 As New SqlConnection("server=PLUTO\PLUTO;Database=core8label;Trusted_Connection=no;User Id=sa;Password=timex2112") Dim cmd As New SqlCommand Dim rowsAffected As Integer cmd.CommandText = "MYSPTEST" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = sqlConnection1 sqlConnection1.Open() rowsAffected = cmd.ExecuteNonQuery() sqlConnection1.Close() |
 |
|
|
|
|
|
syntax help part 2