|
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
|
|
|
|
|
Scenerio: predecessor built a screencapture VB applet to call from a shortcut in third-party app...but I need to modify it to maximize the app before snapshot.
Hints? how do I maximaize an already open app?
Another option wwould be to capture just the active window instead of full screen...
Public Class Form1
Dim memoryImage As Bitmap 'The bitmap of the screen
Dim srcWidth As Int16 'The width of the usable screen
Dim srcHeight As Int16 'The height of the usable screen
Dim tmr As New System.Windows.Forms.Timer
Private Sub PrintDocument1_PrintPage(ByVal sender As System.Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Handles PrintDocument1.PrintPage
Dim dstWidth As Int16 'Destination width
Dim dstRect As Rectangle 'Destination height
Dim srcRect As New Rectangle(0, 0, srcWidth, srcHeight) 'Source Rectangle
'Set the dstWidth to the printable height of the document. The height is used
'because the document is printed in landscape
dstWidth = PrintDocument1.DefaultPageSettings.PrintableArea.Height
dstRect.Width = dstWidth ' Set the width of the destination rectangle
'Scale the height in relation to the width and the source rectangle
dstRect.Height = (dstWidth / srcWidth * srcHeight)
'Draw the image scaling from the srcRect to the dstRect
e.Graphics.DrawImage(memoryImage, dstRect, srcRect, GraphicsUnit.Pixel)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
PrintDocument1.DocumentName = "Screen Print" 'Name the document
PrintDocument1.DefaultPageSettings.Landscape = True 'Swith to landscape
PrintPreviewDialog1.ShowDialog() 'Show the print preview dialog
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Visible = False 'Hide the form
tmr.Enabled = True
tmr.Interval = 1500
AddHandler tmr.Tick, AddressOf Me.TimerTick
tmr.Start()
End Sub
Private Sub TimerTick(ByVal Sender As Object, ByVal e As EventArgs)
Dim myGraphics As Graphics
Dim s As Size
tmr.Enabled = False
tmr.Stop()
'Set the srcWidth and srcHeight to the working dimensions of the screen
srcWidth = System.Windows.Forms.Screen.PrimaryScreen.WorkingArea.Width
srcHeight = System.Windows.Forms.Screen.PrimaryScreen.WorkingArea.Height
s.Width = srcWidth 'Set the width of the size object
s.Height = srcHeight 'Set the height of the size object
myGraphics = Me.CreateGraphics
'Create a bitmap based on the size of the screen
memoryImage = New Bitmap(srcWidth, srcHeight, myGraphics)
'Create a graphics object to paint the bitmap
Dim memoryGraphics As Graphics = Graphics.FromImage(memoryImage)
'Get a capture of the screen
memoryGraphics.CopyFromScreen(200, 0, 0, 0, s)
'PictureBox1.Image() = memoryImage
Button1_Click(Sender, e)
Application.Exit()
End Sub
End Class
modified on Tuesday, July 1, 2008 9:33 AM
|
|
|
|
|
If I understand your question correctly, get the HWND of the window you want to take a screen capture of and then call the ShowWindow()[^] API passing SW_SHOWMAXIMIZED.
|
|
|
|
|
That sounds like what I've seen on Technet/Help....problem is I'm not a programmer & dont know the syntax or where in my vb app it should go(ie form1_load)....how would you script that, given the app name of "CDA"?
This is great OJT....I'll keep digging in Help documents, but your help is great to get me putting the pieces together. Thanks!
|
|
|
|