|
Can Somebody please show me an example code on how to make a user login and password that will look to a database table with fields username & password for verification.
I would greatly appreciate your help.
Thanks & more power to the group....
neal
|
|
|
|
|
Is this a windows app or a web app ? Which bits are you stuck on ? Do you know any SQL ? Do you know how to access a database ? What is the database you're using ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
yes sir its in MS VB6.0 and the database is in ms access and it is in windows app.
Thank you very much for your interest on helping me...
Regards,
Neal
|
|
|
|
|
OK - VB6 is a dead language. You need to specify if you're using VB6, as people will assume .NET otherwise.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Sir christian,Its not in .Net. Sory I'm not specific in details. But once again. Thank you very much for your concern on helping me.
May you contionue your support to all people in-need of help. God Bless!
Best regards,
Neal
|
|
|
|
|
hi neal,
takes two text box(TextBoxlogin,TextBoxpassword) and on click event of button use following code
Dim q As String
Dim oleadapter As OleDbDataAdapter
Dim mdataset As New DataSet
If TextBoxlogin.Text = "" or TextBoxpassword.Text = "" Then
MsgBox("Enter Login ID & Password ", MsgBoxStyle.Information, mdGlobal.myMessage)
TextBoxlogin.Focus()
TextBoxlogin.Text = ""
TextBoxpassword.Text = ""
Exit Sub
End If
try
q = "select * from login where username='" & TextBoxlogin.Text.Trim & "' and password='" & TextBoxpassword.Text.Trim & "';"
oleadapter = New OleDbDataAdapter(q, mdGlobal.conn)
'where mdglobal is module and conn is oledb connection object
oleadapter.Fill(mdataset) ' mdataset is dataset
If mdataset.Tables(0).Rows.Count > 0 Then
loginok = True
Me.Close()
mainform.show
Else
MsgBox("Wrong Login ID / Password ", MsgBoxStyle.Information, mdGlobal.myMessage)
TextBoxlogin.Focus()
TextBoxlogin.Text = ""
TextBoxpassword.Text = ""
End If
Catch ex as exception
msgbox (ex.message.tostring)
End Try
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Sir Rupesh, Thank you very much evrything, this is realy a big help for me. I'm wishing you more success in life and again thank you...and may God continously Bless you!
Best regards,
Neal
|
|
|
|
|
Hey All,
Was wondering if someone could shed some light on the use of the System.Drawing.ImageFormatConverter class in VB.NET (2005).
Could someone provide an example as I'm getting no-where:
dim pBMP = new Bitmap("c:\test.bmp")
dim pCON as new System.Drawing.ImageFormatConverter()
pCON.ConvertFrom(pBMP)
...Now where to?
Any help would be appreciated.
Thanks In Advance.
Lachlan.
|
|
|
|
|
|
Thanks,
The example in the link converts file formats, where my purpose is to convert the colors in the image from 24bpp to 16bpp bitmaps.
Therefore I believe I need the ImageFormatConverter.
Cheers
Lachlan.
|
|
|
|
|
The easiest way to do this is to create a 16bpp bitmap and draw the 24 bpp bitmap onto it. You can probably also use the color matrix to do this. In fact, the way to do it is just to strip the least significant bits of the red, green and blue component of each color. That is, if you wanted to build it yourself, which you probably don't.
The ImageFormatConverter converts between file formats, as in gif, jpeg, etc. So MSDN tells me, anyhow
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello frnds,
i want to show a message box in word document, when i clicked the button in word 2003.
for that purpose the method i used was :
i took the button from visual basic tool bar in word2003,then i double click a button, it shows me a visual basic editor and i wrote a code to display a message box and save the word and exit from it,
if i again open the word and click the button then nothing happens ..means no event fires..Why????????
where i am wrong ????
what should i do ?
how can i use visual basic for applciation..
plz help...regards,Koolprasasd2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
hi KoolPrasad,
THE REASON WHY IT IS NOT DISPLAYING THAT MSGBOX WHEN U RESTART, IS U NEED TO ENABLE MACROS IN MS-WORD. ENABLE THE MACROS THEN IT WILL SURELY DISPLAY THE MSGBOX.
HOPE IT HELPS..
REGARDS
IPS
|
|
|
|
|
Thankx many for reply IPS,
but please send me the steps to enable the macro in word 2003
thankx for help ....
regards,
koolprasad2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
hi
To enable macros in MS word.. follow these steps..
open MSword->open Tools menu-> open Macros-> click on Security menu-item.
this will open the Security dialog box. now under the Security level Tab u will find three options.. now try clicking medium and Low options. first try using medium... hope it will solve ur proble.. else try using LOw. then close the document and restart it. This time u surely gonna get the msgbox.
regards
Nilish
|
|
|
|
|
OK ...Thankx a lot yar Nilesh....
regards,
koolprasad2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
I am using VS .NET 2003 with add-in crystal report. I have to create a cross report with summarised fields as different columns. But this facility is not getting in add-in crystal report, possible in Crystal Report XI developer edition.
So, <b>How can i integrate Crystal report XI with VS .NET 2003 ?</b>rr : dll s not found when add in cr removes, which dll i have to refer
: report created in higher ver do not allow to run in VS.NET 2003
Plz help me ASAP !!!
Jeneesh k v
Programmer, NIC
|
|
|
|
|
There are 12 subkeys in a particular key.Instead of writing each subkey name , is there any way to list all the subkeys using loops or any other way?
|
|
|
|
|
I want to apply commit transaction. I have created BLL.
In the case of Business layer logic
While update / insert / delete operation.
If I do direct connection to oracle with out crating BLL then I have command.
Try
..
…
SqlTransaction mytrans = myConnection.BeginTransaction();
…
myTrans.Commit;
Catch ex as Exception
'Something went wrong, so rollback the transaction
myTrans.Rollback();
but how to do for BLL.
vijaya
vijaya
|
|
|
|
|
|
Hello Frnds,
I have a problem i want to "log OFF" my pc using vb.net and if there is any other window open then they should also get close..
if any one have idea then please telll........
Thankx and regards,
koolprasad2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
This code is just an Example. And try to Change your code as per your Machine Specification.
Const WM_ENDSESSION As Integer = &H16<br />
<br />
Dim osexit As Boolean = False<br />
<br />
<br />
<br />
Protected Overrides Sub WndProc(ByRef e As Message)<br />
<br />
If (e.Msg = WM_ENDSESSION) Then<br />
<br />
osexit = True<br />
<br />
Application.Exit()<br />
<br />
End If<br />
<br />
MyBaseProc(e)<br />
<br />
End Sub<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Private Sub Form1_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing<br />
<br />
If osexit Then<br />
<br />
'Not doing anything will let the application close<br />
<br />
Else<br />
<br />
e.Cancel = True 'This will cause the application to ignore the close & continue running<br />
<br />
Me.WindowState = FormWindowState.Minimized 'Minimize the Window<br />
<br />
End If<br />
<br />
End Sub <br />
<br />
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi Satips,
I am using the following chunk of code , which u provided.
Const WM_ENDSESSION As Integer = &H16<br />
Dim osexit As Boolean = False<br />
Protected Overrides Sub WndProc(ByRef e As Message)<br />
If (e.Msg = WM_ENDSESSION) Then<br />
osexit = True<br />
Application.Exit()<br />
End If<br />
MyBaseProc(e)<br />
End Sub
i had two windows opened with my project in which i am testing ur code(two internet explorer windows)
Control first goes to this function even before the form load.
This function executes consecutively three times
Now the problem is
After comleting the execution three times , it gives the following error
Error creating the window Handle.
So Where the problem can be ?
|
|
|
|
|
”Error Creating Window Handle” is a Win32 error, therefore the first thing you should look at the code that did any thing with Unmanaged code.
I think you will simply run out of window handles. How many controls are you using in your Application ?
Regards,
Satips.
|
|
|
|
|
Thankx, it helps me a lot
- koolprasad2006
Life is swing with you..Enjoy..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
