VB.NET Selecting datatable for Login verification - Visual Basic Discussion Boards

salam ellayan2-Jul-08 6:11

2-Jul-08 6:11

i need the VB.net code for the camera program which exists in the pocket pc that drive the picturing and recording applications.
it is important plz

Re: reply

Dave Kreskowiak2-Jul-08 7:11

Dave Kreskowiak

2-Jul-08 7:11

I repeat my previous question. Not answering it will not change my answer.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: reply

salam ellayan2-Jul-08 20:27

salam ellayan

2-Jul-08 20:27

i need to compress jpeg
my main task is to send this picture via GPRS connection to laptop so it is very big so i need a compression technique to acheive it,
then i'll try to send a video .
capturing , streaming then sending
so plz if you have any idea help me

Re: reply

Dave Kreskowiak3-Jul-08 1:39

Dave Kreskowiak

3-Jul-08 1:39

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

salam ellayan24-Sep-08 22:17

salam ellayan

24-Sep-08 22:17

hi i need something called POCKET PC OCX
if u konow anything about it plz forward it to me
thanks anyway

Re: C#

Dave Kreskowiak25-Sep-08 1:35

Dave Kreskowiak

25-Sep-08 1:35

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Burn audio cd and audio wave reader

Indra PR1-Jul-08 19:59

Indra PR

1-Jul-08 19:59

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 Poke tongue | ;-P

- No Signature Available -

VB.NET Selecting datatable for Login verification

drexler_kk1-Jul-08 18:10

drexler_kk

1-Jul-08 18:10

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

Re: VB.NET Selecting datatable for Login verification

N a v a n e e t h1-Jul-08 19:32

N a v a n e e t h

1-Jul-08 19:32

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: VB.NET Selecting datatable for Login verification

drexler_kk1-Jul-08 20:19

drexler_kk

1-Jul-08 20:19

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

Re: VB.NET Selecting datatable for Login verification

N a v a n e e t h1-Jul-08 20:49

N a v a n e e t h

1-Jul-08 20:49

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

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: VB.NET Selecting datatable for Login verification

drexler_kk1-Jul-08 22:26

drexler_kk

1-Jul-08 22:26

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 Wink | ;)

Re: VB.NET Selecting datatable for Login verification

N a v a n e e t h1-Jul-08 22:43

N a v a n e e t h

1-Jul-08 22:43

Great ! glad to help.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: VB.NET Selecting datatable for Login verification

darkelv1-Jul-08 23:46

darkelv

1-Jul-08 23:46

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.

Setting frame in animated GIF

threemp31-Jul-08 14:01

threemp3

1-Jul-08 14:01

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!

Re: Setting frame in animated GIF

jzonthemtn2-Jul-08 6:05

jzonthemtn

2-Jul-08 6:05

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.

Password Decryption

raing31-Jul-08 13:23

raing3

1-Jul-08 13:23

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?

Re: Password Decryption

Christian Graus1-Jul-08 15:56

Christian Graus

1-Jul-08 15:56

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.

Re: Password Decryption

Paul Conrad1-Jul-08 16:57

Paul Conrad

1-Jul-08 16:57

Well, yeah... Roll eyes | :rolleyes:

"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

Re: Password Decryption

Dave Kreskowiak2-Jul-08 4:14

Dave Kreskowiak

2-Jul-08 4:14

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

I need help with VBA to extract Oracle data to Excel

torgerjl1-Jul-08 12:07

torgerjl

1-Jul-08 12:07

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."

D'Oh! | :doh:

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

Get "Created" date from and Access table

chuckf1-Jul-08 9:37

chuckf

1-Jul-08 9:37

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

Re: Get "Created" date from and Access table

jzonthemtn1-Jul-08 11:19

jzonthemtn

1-Jul-08 11:19

Use the DateCreated property - search for Debug.Print cat.Tables("tblCompanies").DateCreated on this page[^].

Re: Get "Created" date from and Access table

chuckf2-Jul-08 2:19

chuckf

2-Jul-08 2:19

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

Re: Get "Created" date from and Access table

jzonthemtn2-Jul-08 5:59

jzonthemtn

2-Jul-08 5:59

Ah! I'll try to commit that one to memory.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.