Peter,
Normally you can do everything in code that you can do with the designers. I
assume that many persons here active use seldom designers (beside the
obvious ones as screen designing etc.). Although they are at least nice to
try or to create tests and most of them are very well done.
A sample of a Stored procedures, just see the SQL transact code for the rest
on MSDN2
\\\Changed code in this messages so watch typos
dim cmd as New SQLCommand
cmd.CommandText = _
"CREATE PROCEDURE SelectWhatever " & vbCrLf & _
"@ToSearch nvarchar " & vbCrLf & _
"AS" & vbCrLf & _
"SELECT * FROM MyTable WHERE ToSearch LIKE @Element"
dim conn as New SQLConnection("ConnectionString")
cmd.Connection = conn
conn.Open()
Try
cmd.ExecuteNonQuery()
Catch ex As Exception
Messagebox.Show(ex.ToString)
End Try
///
I hope this helps,
Cor
"Peter" <pe*******@gmail.com>
....
I just bought VS.NET Standard 2005.
But there aren't any projects for Windows Services and I know that I
cannot develop VB.NET Stored Procedures (perhaps no projects for this too)
But can I get around the above two limitations (develop them without the
above project types).
I assume that there would be additional work involved, but could i achieve
the above?
Please could someone point me in the right direction.
Thanks