|
I have 2 phone number fields in the database that right now are a text dataType. They were an int, then I changed them to varchar(13). When I try to do an insert into the database there is an exception that says the following.
Failed to convert paramater value from a string to an Integer.
Here is my code. I declared addRow globally.
addRow = lpDataSet.Tables("tbl_students").NewRow()
addRow("stud_cell") = txtStudCell.Text
addRow("stud_phone") = txtStudPhone.Text
lpDataSet.Tables("tbl_students").Rows.Add(addRow)
Try
studTableAdapter.Update(addRow)
Catch err As Exception
MessageBox.Show(err.Message)
End Try
|
|
|
|
|
AAGTHosting wrote: Try studTableAdapter.Update(addRow)
Me thinks you didn't update the DataSet to change the datatype of the phone number field.
|
|
|
|
|
I checked the dataSet and it says the phone number field is text. Also, when I try to do an insert the info does not get inserted into the database.
|
|
|
|
|
AAGTHosting wrote: I checked the dataSet and it says the phone number field is text.
Well, the code is throwing an exception that says otherwise. After changing the field type in the database, did you do ANYTHING to update the schema of the dataset?? If not, then it's not updated and it's still using an Integer type for one of those fields.
|
|
|
|
|
I did update the schema of the dataset. In fact, when I tried to change the dataType in the designer it was already text.
|
|
|
|
|
I have a form which in effect is a launch pad for other forms.
When an option is clicked by the user, I wish to open a form associated with the option.
The problem I have, is that the opened form should remain on top of the main form, like an mdi child would remain on top of an mdi parent.
To achieve this, I have tried setting the TopMost property and the TopLevel property of the child form, which seemed to work until I drag a other application over my app, then the application will appear between the my parent form and my child form.
By the way, my parent form is NOT an MDI parent.
Any help on resolving this would be gratefully received.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Steven J Jowett wrote: like an mdi child would remain on top of an mdi parent.
An MDIChild form doesn't sit on top of an MDIParent. It's rendered inside an MDIClient control on the MDIParent form.
The TopMost property sets the form as the TopMost form system-wide, not application-wide.
You need the call the Show(IWin32Window) method of your second form to make it a application "TopMost" window. Something like this:
Dim newForm As New Form2()
newForm.Show(Me)
|
|
|
|
|
Thanks for the quick reply and solution
Best regards
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Dear Frnd
I have one form with name is FrmInvoice.
On that form, i have InvoiceId- Primary Key (AutoGenerate) and Other is InvoiceNo-(which is manual entry)
I want to checked that the Value in InvoiceNo is must enter unique, i try so many things but i was unable.
So please tell me how i control this.
Please reply on that email address: sikhan555@yahoo.com
Regards,
sikhan
|
|
|
|
|
sikhan555 wrote: I want to checked that the Value in InvoiceNo is must enter unique, i try so many things but i was unable.
Did you try to simply lookup the entered Invoice number in the database and see what it returned??
|
|
|
|
|
I was used the data reader for checking the duplicate record, I want to check the InvoiceNo (Format is Inv/001/2008) is not duplicating in the database. I am already asign primary key to InvoiceId.
Please tell me what i do for checking the duplicate record.
Thanks in advance.
sikhan
|
|
|
|
|
I already did. You don't use a DataReader to get all the records in the table and then search them. You write another query to the database looking for the entered invoice number. If it's there, meaning you get a record back from the database, you tell the user that the invoice already exists. If not, then it's a good invoice number. The SQL statement might look something like:
SELECT invoiceNumber FROM Invoices WHERE invoiceNumber = @userEnteredNumber
|
|
|
|
|
Why dont you add an index constrained to be unique to the 2nd column of the second databable in your database, then when trying to insert catch the error (duplicated key or violation of primary key (I dont remember the exact error)) but it should work
Alexei Rodriguez
|
|
|
|
|
hi all,
i create simple add ins for excel 2007 using vb.net. However it automatically add a setup project(which contains dependencies files & some other files) when i begin this application but this is not works for me.
Can anybody guide me that how can i create Setup/installer for my excel add ins ?
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
i have try to put all control in one form.it takes time to load the page.there are more then 2000 control in one page.can it be possible to make the page load faster.right now it take about 2 minutes to load the page.this are done for window mobile development.
@h3aR
|
|
|
|
|
Sounds like you need to rethink your design. 2000 controls on a form ? You're kidding right ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
2 minutes with 2000 controls on a mobile device is freakingly fast, if you ask me.... 
|
|
|
|
|
The only way to make it faster is to rethink your design and GREATLY reduce the number of controls you're using on this form. 2,000 controls is just an insane number to put on a form. Creating a new instance of a control is a very expensive operation and there is simply no way to speed that up.
|
|
|
|
|
ahzarmokhli wrote: there are more then 2000 control in one page
How do you find the right button to click?
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
|
|
|
|
|
Can Any body give me link for a software which is use to make setup of a VB.Net software i know how to make setup using vsiual studio ? but i need some other software of the same purpose
Thanx
help as a alias.
Be happy and make others happy.Cheer up...........
|
|
|
|
|
www.advancedinstaller.com[^] always works for me
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
|
Hi,
I am creating installer. In that I am inclueded Licence.rtf file.
In the user interface I want to show Licence.rtf file. but only blank window appeared when installing the application.
How can I show the rtf file.
Thanks
|
|
|
|
|
By configuring your installer software properly.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Does anyone know how i can create a line graph using data from a microsoft access data source...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
