i have a table with username, password and email columns.now i have textbox with name emailtxt, i want to see username, on label.when i put an email, then it will select its corrospondese username, so that the username will be shown on label
Protected Sub cmdShow_Click(ByVal sender As Object, ByVal e As System.EventArgs)
dim con as sqlconnection
dim str as string
con = New SqlConnection("server=(local); Data Source=gig;Initial Catalog=myd;User ID=sa;Password=test")
str="select username from mytable where email=' "& emailtxt.text & " ' "
con.open()
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _ Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _ Select log.LogId, emp.FirsName, emp.LastName, log.Value
i want to know how to let the user select a password for a program that i made and would like to know where the password is storedNever Fear Spartucus49 is here
I've got the following code for a password but need it the program to set a certain password. At the moment I just type in anything and it lets me get on with the program.
I have a register.aspx and a login function and i am using vb.net
in my register.aspx...i have a user name textbox and a password text and a submit button. IF the user click on the submit button, the password will be hash and store with the username in the database table called "Customer"
1st Qn: i have a problem is that i never try before hashing, so i not sure how to code it , hopefully if someone got a sample or example to teach me it will be nice
2nd Qn: besides that, in my login function, how am i going to compare the hash value for password that is store in database with the password in the textbox to allow to login?
I am trying to update table to access database in vb.net after changing password. But I have a problem in update error as following Dim dbCommmand As New System.Data.OleDb.OleDbCommand Dim DBConnection As New System.Data.OleDb.OleDbConnection DBConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Users haeayeDocumentsTesting.mdb" dbCommmand.CommandType = CommandType.Text [Code] .....
What i'm trying to do here is login using a table and fields with username and password and also usertype in it. If the user is an Admin then it displays the the command button cmdAdmin and if not admin it disables it. This is the code that i currently have at the moment Hope someone can help me out and also i want to get rid of the username and password that's currently in it and use database instead.?
I have a piece of code that is suppose to update the password field when the user wants to change password but I get an error line: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll error line: cmd.ExecuteNonQuery()
If BindingContext(ds, "login").Position < 0 Then MsgBox("Database Is Empty !", MsgBoxStyle.Information, "Records Management System") Exit Sub End If If ComboBox1.Text = "" Then [Code] .....
I have a table in a sql database and in this table i have a column at the end, that is creating an automating date and time everytime when new record is inserted. I want to select from an application in VB al the records in wich the date and time there where inserted is bigger than one variable that I created on runtime.For example I need to see all the records that were inserted later than 10, august, 2010 13:45:10 How can I do that?
I have code that downloads a webpage into an .html or a .txt file so I have the webpage source code, how do I:Search the HTML source code in the file for a keyword anchor point (Hair Color, it's unique in the entire webpage source code)Step down 3 linesAssign what ever is on that line to a variable called FoundIt?
what sql command i must use. this is my current command but it give me an error saying "The specified filed 'ClientNo' could refer to more than one table listed in the FROM clause of your sql statemate." [code]
I want to select a table on my database but I have the name of the table on a variable.Because I will create tables periodically I have don't know the name of the future tables so I will stored on a variable. The problem is how I call the variable on SQL statment. I made a code using the addwithvalue to use the variable on the SQL but didn't work. Here is my code
Dim tablename As String tablename = InputBox("Enter the table name") Dim myconecction As String
I have a DataGridView table that I allow the user to enter data into. I have a button to add a row. This works OK but how can I select that row after the button has been clicked. The reason for this is so the user will not have to scroll to the bottom of the list the enter data into the new row.
how to select multiple table in vb2010? i trying to create a login so i need to retrieve the data in 3 different tables in one database i have a code but not work.[code]
I will post a sequence of examples and thought about sql injection, I wish the expert will correct any small mistake in what I will say so I can know exactly the possible danger.
The required is to create a function in vb.net that accept 2 parameter (table_name, fields_list) and return the result in datatable
Now, I am aware of that table_name and fields_list cannot be passed as parameter to the command object using .AddParameter
here is a couple of thoughts, what I would like to know is
1- which function is exposed to sql injection
2- Which function is more safe
Public Class Form14 Dim conn as New SqlClient.SqlConnection(connection_string) Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
My following code is only retrives number month(1,2,3,4....12)and not month name(January,February,.....December).Before that i had try using function datepart, Monthname and date_format but i still din get my answer.[code...]
I have a program that I wrote that creates a database in SQL Server called States_02 as a sysadmin user. Later on I want to grant SELECT permissions to that database to another user, web I always get an error that it cannot find States_02 or I don't have permissions to do it. My Code:
Dim Conn As New OleDbConnection(ConnStr) Try Conn.Open()
[Code].....
The user has public and sysadmin server roles and is the same user who created the database. This user can also login to SQL Server and grant the permissions manually.
I want to extract a field (field name is variant, i.e. depend on what the user's choice) from a table using sql statement. How do I do that? Do I have to declare some variables?
I have a stored procedure that I need to be able to change the table name that the select statement in the stored procedure uses depending on a user input, however I am having a problem with the code:
Code: CREATE PROCEDURE [dbo].[spQryParentComments] @projTable as varchar(50) AS
im trying to select a specific bit of data from a table in access using sql in vb.net. My select statement so far is sql = "select [UserAccessLevel] from Member where username = '" & tusername & "'"Useraccesslevel and username being columns in the table and tusername being a variable that stores the username im using to look up the useraccesslevel in the table.
Was wondering if any of you knew anything about select statements.
I'm writing a program for Employees Management and i need to automatically generate a Payroll for each one then calculate some things and save it to another table.
I know how to calculate and save. I just need to get all the ID column of all rows in my Employees table, and select each Employee ID one by one in order to calculate each payroll automatically.
For a project i am working on, i am taking bookings. These bookings are stored in a database alongside a users personal details. The personal details are assigned an ID according to the user who booked it. A user can book more than once with different personal details.
My problem is that i want a user to be able to edit a booking. I want a list of all the names that user booked to be listed in a combo box. This is the part i am having trouble with. i am using an access database and using sql statements to pull out the data. This is what i have tried so far:
SELECT [First Name] FROM PersonalDetails GROUP BY [First Name], UserID HAVING (UserID = ?)
If i execute this query in the query editor, it works and shows the two records currently assigned the input id. However, if i try to output this to, for example, a text box, then it remains blank. I am assuming thisis because there is more than one output, but i'm not sure.
