Visual Basic

Uploading binary file by using Inputsteam [modified]

3-Jul-06 2:26

Using the DataAdapter and TableAdapers, you can't. They require keys on the tables you use them with.

Either you'll have to add keys to your tables, which is highly recommended, or you'll have to write your own procedures for udating records using fields that can uniquely identify each record.

Dave Kreskowiak
Microsoft MVP - Visual Basic

jibcht2-Jul-06 17:19

jibcht

2-Jul-06 17:19

Hi! All

I have a problem when I tried to upload file by using system.IO Inputsteam my code is following

Dim UploadedFile As HttpPostedFile = FileUpload1.PostedFile

Dim binFileData As Byte()
ReDim binFileData(UploadedFile.ContentLength)
UploadedFile.InputStream.Read(binFileData, 0, UploadedFile.ContentLength)

Dim strConn As String = "Server=[servername];Database=[dbname];UID=sa;PWD=sa;"
Dim connection As SqlConnection = New SqlConnection(strConn)

Dim str1 As String = "Update DocumentImage set DocImage = @CVData where DocumentID=122"
Dim command As SqlCommand = New SqlCommand(str1, connection)
Dim param1 As SqlParameter = New SqlParameter("@CVData", SqlDbType.Image)
param1.Value = binData
command.Parameters.Add(param1)
connection.Open()
Dim numRowsAffected As Integer = command.ExecuteNonQuery()
connection.Close()

It said Cannot access a closed file. on codeline

UploadedFile.InputStream.Read(binFileData, 0, UploadedFile.ContentLength)

The contentLength was 292836 and the ContentType was "application/pdf"
and I have already put the config into web.config

<httpruntime
="" executiontimeout="1200" maxrequestlength="1000000" usefullyqualifiedredirecturl="false" minfreethreads="8" minlocalrequestfreethreads="4" apprequestqueuelimit="100">

But it didn't work fine
Is there somebody who know how to solve the problem this?

thank you in advance

Jibcht

-- modified at 23:23 Sunday 2nd July, 2006

Oracle 9.2 Stored Procedure help in VB .NET

mikewypy2-Jul-06 14:18

mikewypy

2-Jul-06 14:18

I'm receiving an error when attempting to use an Oracle stored procedure in a VB .NET 2005 application; the database is Oracle 9.2. The error is ORA-06550 wrong number or types of arguments in call to <sproc name="">. I'm making the call with an Oracle DataReader. The sproc is pretty simple - selecting two columns from a database table, it doesn't even have a WHERE clause.

I've Googled the error and seen that other people have come across the error but I haven't seen any solutions to the problem.

Any help / suggestions would be appreciated.

Re: Oracle 9.2 Stored Procedure help in VB .NET

Colin Angus Mackay2-Jul-06 19:30

Colin Angus Mackay

2-Jul-06 19:30

mikewypy wrote:
Any help / suggestions would be appreciated

A snippet of code would be helpful too. Please show the code where you build the command object (Probably OracleCommand) and add the parameters to it. And also show the the signature of the stored procedure (the SQL code that defines the name and parameters of the stored proc)

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Oracle 9.2 Stored Procedure help in VB .NET

User 17164923-Jul-06 4:55

User 1716492

3-Jul-06 4:55

This may help, download the pdf

Taken from http://www.oracle.com/technology/sample_code/tutorials/jdbc10g/namedparameters/files/NamedParams.pdf[^]

Handling Errors
As with the Statement and PreparedStatement objects we have already covered,
if there is something wrong with your stored procedure, callable-statement
syntax, the call to your Connection object's prepareStatement() method will
throw a SQLException. The most common SQLException occurs when a
procedure or function does not exist:
SQL Error: ORA-06550: line 1, column 13:
PLS-00201: identifier 'TONUMBERFUN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
This error may come about because the procedure or function does not actually exist in
the database, or it could be that the username you are using when you call the stored
procedure does not have EXECUTE rights on the procedure.
After you create a CallableStatement object, you need to register any OUT
parameters before executing the statement. Next, let's see how you do that.

modified 1-Aug-19 21:02pm.

control

Mr kilany2-Jul-06 6:54

Mr kilany

2-Jul-06 6:54

dear friend...
if i have a form in vb.net such as (A) and another application in c language such as (B) how can i control the application (B) from the buttons based on form (A) and i mean of control :
1-run application B
2-minimize and mazimize form B
3-close form B
4- the most thing is make the form A always active that mean you cant use the appliation B except throught the form (A)

thanx all

kilany

kilany

kilany

Re: control

Dave Kreskowiak3-Jul-06 2:20

SQL Script to delete empty rows in a table

3-Jul-06 2:20

First, you can NOT make another application a modal child of your own. Once launched, there is nothing you can do to reliably stop a user from switching over to the other application and using it without your interface.

It's very easy to launch the other app (point 1 in your post).

Point 2 is also pretty easy. All you need to do is get the Window handle of the launched app and call the Win32 function ShowWindow with the appropriate parameters.

Point 3 is a bit more complicated, despite it's seeming ease. You can easily tell the application to exit, but if it wants to show some window that wants comfirmation of exit or saving changes, then you've got a problem. You have to find those windows, if they exist, then send the appropriate commands to those windows.

Point 4 - Not practically possible. There is nothing you can do to prevent the user from skipping your app, or shutting it down, and just using the app your trying to control.

Point 5 (you didn't put this) - How do you intend to control the other application?? The only way to do it is not reliable and is far more complex than the benefits your going to get from implementing it.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Rashar2-Jul-06 5:17

Rashar

2-Jul-06 5:17

Hello,
How do you delete a row in vb.net where there is blank data?

I've tried the following, and all do not work...

strSQL = DELETE FROM tblProducts WHERE prodID = & " "

strSQL = DELETE FROM tblProducts WHERE prodID = & Nothing

Thanks in advance.

Colin Angus Mackay2-Jul-06 6:12

Colin Angus Mackay

2-Jul-06 6:12

Rashar wrote:
strSQL = DELETE FROM tblProducts WHERE prodID = & " "

Aren't your quotes in the wrong place?

Rashar wrote:
How do you delete a row in vb.net where there is blank data?

What do you mean by "blank data"? From the two examples you gave you appear to be trying to check whether prodID is an empty string (or is that a string with one space), or possibly if it is NULL.

strSQL = "DELETE FROM tblProducts WHERE prodID IS NULL"

strSQL = "DELETE FROM tblProducts WHERE prodID = ''"

The first checks for a null (i.e. the absense of any value), the second checks to see if the value is an empty string.

One of these is likely what you want - but you'll have to be more definite about what consitutes "blank data" in your vocabulary.

Re: SQL Script to delete empty rows in a table [modified]

Rashar2-Jul-06 16:49

Rashar

2-Jul-06 16:49

Colin Angus Mackay wrote:
What do you mean by "blank data"? From the two examples you gave you appear to be trying to check whether prodID is an empty string (or is that a string with one space), or possibly if it is NULL.

Yes. I'm looking to delete the record where prodID is a null field.

I will try the first option.

Thanks

Dave Kreskowiak3-Jul-06 2:06

3-Jul-06 2:06

ProgID sounds like it should be a Primary key. If that's the case, why would it ever be NULL?? If this is the case, you've got much bigger issues that just finding and delete "empty" records. In a properly designed database, this procedure your trying to put together should never be necessary.

Dave Kreskowiak
Microsoft MVP - Visual Basic

-- modified at 8:07 Monday 3rd July, 2006

Rashar3-Jul-06 4:42

Rashar

3-Jul-06 4:42

Actually, I was just using it as an example for a column name. I do have it set to a primary key, it's just that my end user may save a blank form which would populate the prodID column, but the rest of the columns may all be blank. If so, I wanted to clean up the table if there are columns that are blank. I could make it so that all the columns are not null, but with my program it can't work that way, as I need to request an ID first and foremost.

Thanks.

Dave Kreskowiak3-Jul-06 4:58

3-Jul-06 4:58

Rashar wrote:
it's just that my end user may save a blank form which would populate the prodID column

That's what validation is for! Validate the fields before you allow the user to save the record. If all the fields are not filled in, there's no reason you should be letting the user save an incomplete record.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Non-stop Progress Bar

J Liang2-Jul-06 3:34

J Liang

2-Jul-06 3:34

Hey everyone,

I wanted to put a progress bar just like the one in window's booting screen that is never ending as I don't know when all my progress will finish or it varies, I'd check the net and somes really look complicated, can anyone show me some example? Thank you.

J Liang

support.microsoft.com/default.aspx?scid=kb;EN-US;323116[^]

http://www.developer.com/net/vb/article.php/1539051[^]

Mekong River2-Jul-06 4:02

Mekong River

2-Jul-06 4:02

J Liang6-Jul-06 6:04

J Liang

6-Jul-06 6:04

Hey, thanks for the reply, sorry I can't get back to you any sooner, having some problem with my computer. Found an easy way which I already posted on this thread, if you interested, do have a look =)

J Liang

Mekong River6-Jul-06 15:14

Mekong River

6-Jul-06 15:14

J Liang wrote:
if you interested, do have a look =)

Look what?

J Liang6-Jul-06 20:14

J Liang

6-Jul-06 20:14

Ok, I'll copy it to here then, I actually answered to another person in this same thread.

This is what I do for the progress bar:

First, select the progress bar, go to properties, on 'Style', select 'Marquee'.

Then, from the toolbox, drag the Timer to the page. After that, go back to the code and on any place that you wanted the progress bar to start, add

timer1.Enabled = True

Then when you wanted it to stop, just put timer1.Stop() and timer1.Enabled = False

That's all and it work just fine =)

J Liang

Mekong River6-Jul-06 21:28

Mekong River

6-Jul-06 21:28

Thank you. I already see message in your previous post too after I ask you Poke tongue | ;-P

HakunaMatada3-Jul-06 0:33

HakunaMatada

3-Jul-06 0:33

A really simple solution would be to create a Flash animation and display it in a picture box control. I believe the one on Windows booting screen is a Flash Animation. Smile | :)

---

Hakuna-Matada Beer | [beer]

It means no worries for the rest of your days...
It's our problem free, Philosophy
<marquee behavior="alternate" scrollamount="5" scrolldelay="50"> Jig | [Dance]

Dave Kreskowiak3-Jul-06 2:04

3-Jul-06 2:04

Hakuna-Matada wrote:
I believe the one on Windows booting screen is a Flash Animation.

No, it's not. How can Flash be running if Windows hasn't started yet. Also, using Flash for this is overkill. It's easy to build a control like this and it's FAR lighter in weight than Flash could ever be. On top of that, I know I don't want my application depending on an installation of Flash just for a stupid progress bar.

Dave Kreskowiak
Microsoft MVP - Visual Basic

HakunaMatada3-Jul-06 2:56

HakunaMatada

3-Jul-06 2:56

Dave Kreskowiak wrote:
On top of that, I know I don't want my application depending on an installation of Flash just for a stupid progress bar.

Oops... Sorry, Just slipped my mind. Thanks for pointing it out.

Dave Kreskowiak wrote:
How can Flash be running if Windows hasn't started yet

Do you need a Flash control? I thought the PictureBox control of .NET was capable of displaying Flash .swf files on it own. Maybe I was wrong.

Anyways, thanks for pointing out my mistakes. Smile | :)

---

Hakuna-Matada Beer | [beer]

It means no worries for the rest of your days...
It's our problem free, Philosophy
<marquee behavior="alternate" scrollamount="5" scrolldelay="50"> Jig | [Dance]

Dave Kreskowiak3-Jul-06 4:27