|
salam ellayan wrote: i need to compress jpeg
JPEG is already a compressed format. Trying to compress an already compressed file isn't going to get you anywhere.
JPEG uses a "lossy" compression, so the more you compression the image data, the more the image becomes distorted. It also cannot be "reinflated" to it's full previous quality.
|
|
|
|
|
hi
i need something called POCKET PC OCX
if u konow anything about it plz forward it to me
thanks anyway
|
|
|
|
|
There's no such thing. "Pocket PC" is just that, a PC that fits in your pocket. "OCX" is just another term for an ActiveX component.
|
|
|
|
|
I am looking for source code that able to burn audio cd from mp3 files and read audio wave that will be shown as equalizer, I've tried some codes from other sites but it won't work. Can anyone help me? Please 
- No Signature Available -
|
|
|
|
|
Hello all,
I'm trying to create a user login verification for my Window Form Application using VB.NET 2003 connect with MySQL 5.0 database.
When the login form load,I have load all the USERID,USERNAME and USERPASSWORD into a dataset and put into a datatable name"cashier"
shown inside my code below:
ObjConn = New OdbcConnection(Connect())
ObjComm = New OdbcCommand("SELECT * FROM pos_cashier WHERE LocationCode='" & TerminalLocate & "'", ObjConn)
ObjConn.Open()
ObjAdapter.SelectCommand = ObjComm
ObjAdapter.Fill(DS, "cashier")
DT = DS.Tables("cashier")
ObjConn.Close()
Now I need someone can guide me how to select a row or column inside this datatable so I can check the user login name and password
are same with what inside this cashier datatable which used to authorise user login. What I wish to do is something as follow:
If textbox1.text = datatable.cashier.USERNAME Then
If textbox2.text = datatable.cashier.USERPASSWORD Then
UserloginSuccess = True
Dim MainForm as new MainForm
Me.Hide()
MainForm.Show()
Else
Messagebox.show("Sorry,Wrong Password")
End If
Else
Messagebox.Show("Sorry,Username not available on the system.")
End IF
Anyone can give me some help about selecting this datatable?
Thank you for reading.
Regards
Drex
|
|
|
|
|
You can use DataTable.Select() method. It returns DataRow array.
drexler_kk wrote: When the login form load,I have load all the USERID,USERNAME and USERPASSWORD into a dataset and put into a datatable name"cashier"
It's bad design.
Why don't you do user verification in the database when user clicks the login button ? When you are loading all the data to dataset on form load, your application will take long time to load when there are more number of users.
|
|
|
|
|
Sorry,can you give me some sample how should I used this DataTable.Select() method?
Hello Navaneeth,
I have try to change it to the following code but it doesn't work.
For i = 0 to DT.Rows(i).Count - 1
If Test =DT.Select("USERNAME='"& textbox1.text &"'")(i) Then
If DT.Select("USERPASSWORD='" & textbox2.text &"'")(i) Then
UserloginSuccess = True
Dim MainForm as new MainForm
Me.Hide()
MainForm.Show()
Exit For
Else
Messagebox.show("Sorry,Wrong Password!")
End If
Else
Messagebox.show("Sorry,Username not available on ths system.")
End If
Next
The code above can't work. Can you tell me how to fixed it?
Besides,what do you mean by do the user verification in the database? You mean directly use a SELECT statement which depend on the username and userpassword from the server to check if the server have the username with the right password??
Thanks for reading everyone,hope to hear from you all again soon.
Regards
Drex
|
|
|
|
|
If you look at the documentation[^], it would be easy.
drexler_kk wrote: For i = 0 to DT.Rows(i).Count - 1
No need of loop here. Select() returns a DataRow array.
drexler_kk wrote: If Test =DT.Select("USERNAME='"& textbox1.text &"'")(i) Then
This is wrong. Test =DT.Select("USERNAME='"& textbox1.text &"'"). Test should be DataRow array.
drexler_kk wrote: Besides,what do you mean by do the user verification in the database? You mean directly use a SELECT statement which depend on the username and userpassword from the server to check if the server have the username with the right password??
Yes. That would be faster than the method you are using. When user clicks on the login button, supply the user details entered to the database. Run a query to select the details. If everything is OK, proceed with login, else display error.
Hope this helps
|
|
|
|
|
Hello Navaneeth,
Yeah,thanks my friend. I have solve this problem by checking the site you provide. Thank You so much for the information and advice share me.
Have a wonderful day.
Regards
Drex 
|
|
|
|
|
|
IMO, you should try to select the user from table with the name and password without loading everybody into the dataset, ie
Select * from pos_cashier Where LocationCode = @loc And UserName = @name And UserPassword = @password
If you get a row, the password is valid, otherwise invalid.
|
|
|
|
|
Hi guys
Does anyone know how to set each individual frame in an animated GIF? For example, I want to load a GIF using Drawing.Image.FromFile() and then set/modify each frame in the GIF. I can use SelectActiveFrame() to select the frame, but how do I set/modify the selected frame?
Any pointers would be very appreciated.
Thanks!
|
|
|
|
|
I may be wrong, but I think you'll need a non-.NET component to manage frames in animated GIFs. Maybe this article[^] will help.
|
|
|
|
|
I am wanting to create a serial/password retriever for messenger apps and stuff like that and I can't figure out anyway to decrypt the encrypt password from the registry. Does anybody know how to?
|
|
|
|
|
See, the POINT of the password being encrypted, the REASON it's encrypted is.....
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
Well, yeah... 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Weel, first you have to find out HOW it was encrypted, then you have to know if the password was encrypted using a symmetric algo or if it was a one-way hash. Usually, it's a one-way hash, in which case, there's no way to decrypt it. You have to use a dictionary attack method to "guess" what the password is, hashing millions of letter combinations and comparing those hashes to the stored hashed password. This could take a year or two for the more complex passwords.
|
|
|
|
|
I know minimal VBA (one online class that took an hour) and now I need to complete a project in Excel that queries an Oracle database. They would like the user to input a search criteria and then push a button to populate the sheet. For example, the user inputs "shoes" and pushes a macro button that says, "Refresh" and the database then returns the current database "Sizes, Colors and Styles, etc."
 So far I have been able to make a connection to the database:
Sub OpenDatabase()
Dim strConnection As String
Dim wrkSheet As Worksheet
Application.StatusBar = "Opening Database"
strConnection = "Driver={Microsoft ODBC for Oracle};" & _
"Server=X;uid=Y;pwd=Z;"
Set g_conDB = New ADODB.Connection
g_conDB.Open strConnection
End Sub
Can anyone help me with what to do next?
thanks
|
|
|
|
|
Hello,
How can I use vb.net to get the creation date of an access table? I'd like to be able to know when the tables where last created in an application that drops and adds tables each time it is run.
Thanks
|
|
|
|
|
Use the DateCreated property - search for Debug.Print cat.Tables("tblCompanies").DateCreated on this page[^].
|
|
|
|
|
Thanks for your reply. I ended up using this code to get the information about the access tables. It looks at the "TABLE" in the schema. Information about the tables is stored in "TABLE"
' open connection to mdb
objConn.Open()
Dim SchemaTable As DataTable=objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
For Each dr As DataRow In SchemaTable.Rows
Debug.Print(dr!TABLE_NAME.ToString())
Debug.Print(dr!DATE_CREATED.ToString())
Next
|
|
|
|
|
Ah! I'll try to commit that one to memory.
|
|
|
|
|
I am new with progress bars. I am getting help from the great help information in Visual Studios 2005. But, I am not understanding what is wrong. Here is my code so far. I am trying to display a progress bar on a .net compact framework form because when I launch the program I am trying to get a file on the network and it take 30 seconds the first launch of the program.
ProgressBar1.Visible = True
ProgressBar1.Minimum = 1
ProgressBar1.Maximum = 3
ProgressBar1.Value = 1
This is ok. But, when I try to use the STEP (progressbar1.step) it does not give me the option. I imported windows.forms. What else do I need. the help says .net compact will work.
|
|
|
|
|
If it doesn't show up it may not be supported, but I could be wrong. You can always do ProgressBar1.Value += 1 or try the Increment[^] method, if it's supported.
|
|
|
|
|
How do I set File I/O permission in my application which is devioping in Vb2003 for Win CE platform. I get IOException on opening a file.
Thanks
Terry
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
