|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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" or
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.
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
J Liang wrote: if you interested, do have a look =)
Look what?
|
|
|
|
|
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
|
|
|
|
|
Thank you. I already see message in your previous post too after I ask you 
|
|
|
|
|
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. 
---
![Beer | [beer]](https://codeproject.freetls.fastly.net/script/Forums/Images/beer.gif) Hakuna-Matada
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]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif)
|
|
|
|
|
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
|
|
|
|
|
|
Hakuna-Matada wrote: I thought the PictureBox control of .NET was capable of displaying Flash .swf files on it own
No, it can't.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hey guys,
Thanks for the replies, sorry I can't get back to all of you earlier as my computer was facing some problem.
Yup, having flash in my program would slow things down and guess what, I found out the easy that will show the same as the booting screen 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
|
|
|
|
|
Hi!
I wonder how to change the font name or size of the text in the rich text box without loosing other properties (bold, italic, ...).
It worked fine with VB6 but with VB.NET all properties are lost when I set new font name.
I am pasting rtf text from another form and traying to set new font name and size. None of the following lines works.
object.SelectionFont = New Font(name, size)
object.SelectionFont = VB6.FontChangeName(object,name)
object.SelectionFont = VB6.FontChangeSize(object,name)
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
