|
You can't put the name of a dataset coma the name of a table.
|
|
|
|
|
Maybe it needs AcceptChanges method for that table.
Sourie
|
|
|
|
|
I've spent most of the afternoon searching and looking at all kinds of encryption classes. I know that encryption can be a very detailed topic and it should be, but I'm just looking for something simple.
I want to take a text string 'The cat ate the mouse' and convert it to a SHA2 hex string that I can then store into a database.
Is there code to simply just do this? I've downloaded all kind of samples which have classes involved that are several pages of code. It's got to be simpler than this? Or of course then it might not be secure if it is too simple to encrypt / decrypt.
Any suggestions on something simple would be helpful?
Lost in the vast sea of .NET
|
|
|
|
|
You can use a function like the following:
Public Shared Function EncryptSHA512(ByVal strAs String) As String
Dim Bytes() As Byte
Dim Encoder As New System.Text.UTF8Encoding
Dim SHA512 As New System.Security.Cryptography.SHA512Managed
Dim SHA512String As String
Bytes = Encoder.GetBytes(str)
Bytes = SHA512.ComputeHash(Bytes)
SHA512String = Convert.ToBase64String(Bytes)
Return SHA512String
End Function
Alexei Rodriguez
|
|
|
|
|
This function is exactly what I was looking for. Currently I'm writing a test application that simply has a form and two buttons, encrypt and decrypt. The encrypt works great with this function, but when I try to write the decrypt function everything works, but I can't find logic to reverse the ComputeHash code?
Below is what I have:
Public Shared Function DecryptSHA512(ByVal str As String) As String<br />
Dim Bytes() As Byte<br />
Dim Encoder As New System.Text.UTF8Encoding<br />
Dim SHA512 As New System.Security.Cryptography.SHA512Managed<br />
Dim RegularString As String<br />
Bytes = Convert.FromBase64String(str)<br />
'Bytes = SHA512.??(Bytes) 'Can't find reverse logic<br />
RegularString = Encoder.GetString(Bytes)<br />
Return RegularString<br />
End Function
Thanks again for the code you have given and any suggestions on the decrypt logic is welcome
Lost in the vast sea of .NET
|
|
|
|
|
This can not be decrypted
Its a one way hashing algorithm
Alexei Rodriguez
|
|
|
|
|
SHA is not an encryption algorithm, it's a hashing algorithm.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
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.
|
|
|
|