Search results for query: *

Here is my code... private bmp as bitmap Private Sub GridDetail_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridDetail.Click bmp = getsnap(GridDetail) 'PrintDocument1.Print() PrintPreviewDialog1.ShowDialog() End Sub Private Function getsnap(ByVal ctrl As...

What are you trying to accomplish? Encrypting a password? Please enlighten us.

I know you are using SQL Server, but the solution in Oracle would be something like this...and hopefully SQL Server has the same capabilities. Declare a cursor by selecting specific records by a key. This creates an array in PL/SQL (even though its called a cursor). Then you loop through...

The Foreign Key is acting as a constraint. You MUST delete the record on the other table first, then proceed with the delete on the intended record

Try using a trigger when you insert a record that gets the max sequence number and adds one, then inserts it into the record. This should always be done on the database side. You only hurt your program's performance this way....

Post your code, including the connection string

I think you are missing the code that sets the command type to stored procedure. Can you post your code again? Just the part that creates the connection object, opens the connection, creates the command type, set command type to stored procedure and the line of code that executes it.

Have you tried creating the stored procedure through the VS IDE? What version of Oracle are you using?

Have you tried issuing the command from the client using SQL*Plus or something similiar? Are the ODP drivers the most up to date? Check out this link... http://download-east.oracle.com/docs/html/B28089_01/extenRest.htm I saw this on there, very interesting... Unsupported SQL Commands...

Try renaming your stored procedure to something else other than "vb".

You should always post what you have done so far

SQL Server examples will work for Oracle. You only have to change the property to reflect which class you are using ie. OledbClient, OracleClient. SQLCommand would be oledbcommand or OracleCommand, SQLConnection would be OledbConnection or OracleConnection Dim sqlINS As SqlCommand Dim sconn...

BTW... Most books don't always have their code correct

So what is your error? No one can help you if you don't mention what it is. Saying that you can't do it like your book is NOT an error description.

No database was specified. So I'll do this the VB way... Use the Format function on both dates so that they can be compared. Format(inDate, "MM/dd/yyyy") or whatever mask you please for the second parameter in the function

Try something like this... sqlINS.Parameters.Add("@CopyPointsFile", SqlDbType.VarChar, 50).Value = textbox1.text

At the risk of bringing hellfire of this forum upon me, Use Oracle!

You can reference www.connectionstrings.com for your connection string for different databases.

Don't know SQL Server that well. Try asking in that section of VBDOTNETFORUMS

You can use the SQL examples almost to the "T". Depending on whether you use the Oledb or OracleClient class for your connection. Both of them have corresponding methods to the SQLClient class. SQLConnection, SQLCommand would be OledbConnection, OledbCommand or OracleConnection...