Creating Stored Procedures

Dim MyCommandText as String = "Select * From MyTable Where (((MyFIeld)=[?]));
Dim MyConn as New OledbCOnnection(MyConnString)
Dim MyCommand as New OleDbCommand(MyCommandText, MyConn)
Dim MyParam as New OledbParameter
MyParam.value = 1
MyCommand.Parameters.add(MyParam)

thats just a quick sample...once it is created and stored you can call it by name
MyCommand.Text = "MyStoredProcedureName"
MyC0mmand.Parameters(0).value = 1
MyCommand.CommandType = CommandType.StoredProcedure
MyCommand.executenonquery

edit: sorry used vb here in c# forum shouldn't be to hard to read and translate though ....

DMan1 at 2007-9-9 >