doparealestate.blogg.se - Vb net 2010 dropdownitemclicked

#VB NET 2010 DROPDOWNITEMCLICKED UPGRADE#
#VB NET 2010 DROPDOWNITEMCLICKED CODE#
#VB NET 2010 DROPDOWNITEMCLICKED PASSWORD#

Mycommands = New OleDbCommand(mydbstandard, myconnection)ĭim sdr As OleDb.OleDbDataReader = mycommands.ExecuteReader Mydbadmin = "Select * From AdminTable Where UserAdmin = '" & Loginid.Text & "' AND PassAdmin = '" & loginpass.Text & "'" Mydbstandard = "Select * From standarduser Where UserName = '" & Loginid.Text & "' AND UPassword = '" & loginpass.Text & "'" Myconnection = New OleDb.OleDbConnection(myprovider) Standarduser - name of the table for standard user

Is there a way that i can minimize the code.tnx Is does not log in for both of user that has same password.

#VB NET 2010 DROPDOWNITEMCLICKED PASSWORD#

Now i redesign my project.ive created a radio button to differentiate whats the standard from admin.īut i encountered a new problem.if ever there are same password from different user. Using cmd As New OleDbCommand("SELECT Count(*) + (SELECT Count(*) FROM adminaccdb where = and FROM accdb where = and cn)Ĭmd.Parameters.AddWithValue("Uname", "some_username")Ĭmd.Parameters.AddWithValue("Password", "xyz")

#VB NET 2010 DROPDOWNITEMCLICKED CODE#

And instead of 2 calls to the database, 1 call with will do the job also with only a few lines of code which will also take care of properly closing and disposing the connection: That match the search and can be retrieved using ExecuteScalar.

#VB NET 2010 DROPDOWNITEMCLICKED UPGRADE#

Visual Basic.NET includes an upgrade tool to assist in converting VB6 projects to. Much of the current VB6 code base will not run under VB.NET due to changes in VB.NETs syntax and language, its use of the new common runtime, and its switch to WinForms from the VB6 form model. However, it might be easiest for you to declare the ToolStripMenuItems 'WithEvents', then you can see the events and wire them up in the VS IDE. You can pass the AddressOf it to the ToolStripMenuItem constructor or use the AddHandler keyword. Instead of SELECT *, SELECT Count(*) will return the amount of records This article describes some of the many differences between VB6 and VB.NET. there are a number of ways to add event handlers to a ToolStripMenuItem. Also, you r using a datareader to check if a record is retrieved, which is unnecessary. In your example code your using a OleDbConnection (which is OK), a Command and a SQLDataReader.įurthermore, you don't close and dispose the connection, which is very important when using Access. Maybe you should take more time to answer. I also try some code but it bypasses the password, meaning if the username is exsisting on the db it will not confirmĭecker. Mydb = "SELECT * FROM accdb where = '" & idtext.Text Mystr = ("Provider=.4.0 " & _Ĭonnection = New OleDb.OleDbConnection(mystr) Private Sub login_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles login.Click

2 text boxes namely loginid.text and loginpass.text.

While in my vb.net my main page form has the followings Uname and UPassword, the table is named as accdb and saved as useracc.mdb in 2k3 format. I am biginner regarding Database in vb.net Pls help on the codes that im working on.