Visual Basic

1-Jun-07 23:02

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

Christian Graus1-Jun-07 23:22

Christian Graus

1-Jun-07 23:22

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 )

ravenathan1-Jun-07 23:40

1-Jun-07 23:40

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

Christian Graus2-Jun-07 0:33

Christian Graus

2-Jun-07 0:33

OK - VB6 is a dead language. You need to specify if you're using VB6, as people will assume .NET otherwise.

ravenathan2-Jun-07 1:02

Re: Create a login username and password

2-Jun-07 1:02

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

Rupesh Kumar Swami2-Jun-07 0:19

Rupesh Kumar Swami

2-Jun-07 0:19

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)

Re: Create a login username and password

ravenathan2-Jun-07 0:55

System.Drawing.ImageFormatConverter.. VB.NET Help!

2-Jun-07 0:55

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

LachlanGro1-Jun-07 22:19

LachlanGro

1-Jun-07 22:19

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.

Re: System.Drawing.ImageFormatConverter.. VB.NET Help!

Sonia Gupta1-Jun-07 22:27

Re: System.Drawing.ImageFormatConverter.. VB.NET Help!

1-Jun-07 22:27

Try this link

LachlanGro1-Jun-07 22:32

LachlanGro

1-Jun-07 22:32

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.

Re: System.Drawing.ImageFormatConverter.. VB.NET Help!

Christian Graus1-Jun-07 23:27

Christian Graus

1-Jun-07 23:27

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

How can i use visual basic for application...

koolprasad20031-Jun-07 21:11

1-Jun-07 21:11

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.. Confused | :confused:

plz help...regards,Koolprasasd2003

Be A Good S/W Eng... Life is swing with you..Enjoy..

ips_sun2-Jun-07 0:47

ips_sun

2-Jun-07 0:47

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

koolprasad20032-Jun-07 1:38

2-Jun-07 1:38

Thankx many for reply IPS,

but please send me the steps to enable the macro in word 2003

thankx for help ....

regards,
koolprasad2003 Smile | :)

Be A Good S/W Eng... Life is swing with you..Enjoy..

Sonia Gupta2-Jun-07 2:03

2-Jun-07 2:03

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

koolprasad20032-Jun-07 2:17

How to integrate Crystal report XI with .net 2003 ?

2-Jun-07 2:17

OK ...Thankx a lot yar Nilesh....

regards,
koolprasad2003 Smile | :)

Be A Good S/W Eng... Life is swing with you..Enjoy..

Jeneesh K. Velayudhan1-Jun-07 19:48

Jeneesh K. Velayudhan

1-Jun-07 19:48

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

registry sub keys

Sonia Gupta1-Jun-07 19:00

1-Jun-07 19:00

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?

commit transaction

kvijayajyothy1-Jun-07 18:34

kvijayajyothy

1-Jun-07 18:34

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

Re: commit transaction

Sonia Gupta1-Jun-07 19:27

This article should help u out from the problem.It is a very simple article.Hope u will find it very useful.

1-Jun-07 19:27

How can i log off my pc using vb.net....

koolprasad20031-Jun-07 18:20

Re: How can i log off my pc using vb.net....

1-Jun-07 18:20

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 Smile | :)

Be A Good S/W Eng... Life is swing with you..Enjoy..

Sathesh Sakthivel1-Jun-07 18:31

Sathesh Sakthivel

1-Jun-07 18:31

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]

Re: How can i log off my pc using vb.net....

Sonia Gupta1-Jun-07 20:26