Windows Services and VB.NET Stored procs with Standard version

[Peter]

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

 

[Cor Ligthert [MVP]]

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]

I should've been a little bit more specific.
Sorry about that.

My query was whether i could develop VB.NET 2005 Stored Procedures (Stored
procedures written in VB.NET itself).
Thanks anways.

 

[Cor Ligthert [MVP]]

Peter,

Stored procedures are never written in VB.Net, in not any version. Stored
procedures are forever in SQL transact code.

The designer creates those.

Cor