I have this MySQL Query glitch in my VB.NET program. Here is the query in VB.NET:
"SELECT Points FROM user WHERE Username = '" & UsernameText.Text & "';"
It will select the points column from the user table from the Username they entered. When I deploy this it will set the value for points to 0 on their account. I'm not even inserting anything in.
I have a login control inside a loginview control and on the loggedin template, there is a gridview and an sqldatasource. What I need is to use the username to filter that gridview. But I always get the error Object reference not set to an instance of an object. I also tried adding .tostring to the page.user.identity.name [Code]
View 1 Replieshow do i create restrictions whereby there cannot be two similar username in the table, while registering? i am using SQL server.
View 3 RepliesI'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.
How to use Select Case in reading rows in a table in mySQL? by not using the username of the user.
View 1 RepliesIm trying to fumble my way through selecting data from a mysql table and populating it to a combo box. I feel Im almost there, could someone look over my code and see whats going wrong?
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
Dim con As New MySqlConnection
[Code].....
I am going to make a invoices then.. they are going to have a id it is not going to be identity, it is not my idea, this is the idea's my professor's. then he want it so..he didn't want i change id to int, he want it was varchar..but now i have seen this is as identity.. id =1, next id=2, next=id=3.. but it doesn't mind he told me in the future it is going to be so..
abc000002
abc000003
abc000004
[code]....
then for that he doesn't want i change it to int how can i get the last? i want it one plus next i want it was
abc000010
how can i do it? i am working on visual basic and visual studio 2008i can use a loop-for, or a query for solve it?
I'm using VB.net to write a MYSQL application and one feature I need to add is the ability to add a column for each week that my employees worked. For example I want the first column to be called "W1" and the next one to be "W2" and so on, right up to "W52". How would I add a column to my table and have it's name add 1 to its current value? If there wasn't any letters in the name it would be easy but I need it to have the "W" in the title as well to avoid confusion. to add the column I have this:
Alter Table Manager ADD W1 MediumINT;
I just need the part that adds an INTEGER to a VARCHAR datatype if possible... Maybe there should be some sort of data type conversion involved? Just to explain further, the black bar at the very top are the date stamps for each week, I would like to have this included in the datagridview if possible but it is not required. Under each week column the employees will be entering the percents they worked (example: 20%, or 0.20 is one day of work) I know this is an odd way of doing things but its mandatory... and i was wondering if it were possible to automate the creation of these columns rather than me having to manually enter them.
I have written some code so i can connect to a Mysql db. But how can i get like an array of the columnnames?
View 2 RepliesI need to display a grade based on the number of points entered. store the min and grade in a 2d array here's my code that I have currently:
Dim strGrade(,) As String = {{"0", "F"},
{"300", "D"},
{"350", "C"},
[code]....
I had created login form in vb.net. There are two fields username & password. I want to check username & password enter in the login form, from the first.mdf (database file). If it is correct then message is displayed. I had written code for this but I got error in the code.
The code of login form is below:
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlConnection
Imports System.Data.SqlClient.SqlCommand
Public Class Login
Inherits System.Windows.Forms.Form
[Code] .....
I hv to create a login for my windows appn(this is the first tym i am creating a login in visual studio) i am unable to figure out exactly what should i do
I tried the following:
Public Function User_Login(ByVal unam As String, ByVal pwd As String) As Boolean
ada = New OleDbDataAdapter("Select * from UserProfile where UName='" + unam + "' and
[CODE]...
Now i called this function on the button click of my login form and passed the values of username and password textboxes as parameters to it. But the problem arising is that it is logging in by simply clicking the button irrespective of what is entered in the username and password textboxes.
I think this is because ds.Tables.Count is never 0(whether the username and password match or not) Use code tags when posting your code. Code tags are used like so =>
send a solution for this "update login SET password=@password,username=@username where username=@user"
while executing i got the error"syntax error in update statement "
I got an error when I tried to save a deleted record in a table which I use to store username and password.
I can delete with no problems but the error message popped up when I clicked on the update icon
My login code is like this
Imports System.Data.SqlClient
Public Class Form1
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As
[Code]....
I'm making a login form in VB.NET, and I have a table in mysql called user. What I want to do is before a user can login the Administrator column of the user table must be TRUE and the DELETED column must be FALSE. I've tried everything I know but all non admin users are still able to login... Heres how the user table looks like:
[Code]...
I need application with login form which gets username and password from mysql database and validate it, if it's correct show form 2...
Currently I made only this version
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login.Click
[Code].....
Can i use the timer when the user tries to log-in and the user entered a wrong password 3 times.i will give the user 5 mins to log-in again with the correct password and if the user enters the wrong pass. 3 times again i will give another 10mins also this is what i want when the user close the program the timer is also their and running that it will give the user the remaining tym on how much tym left 4 him to log-in again.Can i do this in vb.net??i dont know how 2 do this i dont have a clue if it is possible can someone give me a code??
View 9 RepliesI'm working on a project and my boss insists I use a DataGrid for this. The grid holds information for work orders, one of the cols has a check box in it. I need the user to be able to select any number of those checkboxes/rows and then return a value to the table "stamping" that users ID. This is what I have so far to get the grids populated... I'm using 2005 with a 2000 Access Database if that helps. Though this will be changed to SQL Server once we get it working (yay more work)...
[code]...
I removed the code from the second grid to make it easier to read, obviously once I can get one to work the second shouldn't be as much trouble.
This is the check box: dgvNewBiz.Columns(1).HeaderText = "Select"At this point if someone knows how to get it to recognize the click event of the check box and pass that row info to a variable that would be super as I'm sure I could probably figure it out from there.
I have a chat server / client system running, but I want users to authenticate with my vBulletin forum database.I don't want the client to do it, because it is possible to fake the 'successful login' and connect with a fake username. I want to send the username and password details to the server, and make the server check it with the local vBulletin MySQL database for the username and password.Is there a way to do this? To my knowledge vBulletin has a username and a password entries in the database which is salted, and the salt varies from user to user.
View 7 RepliesI've got a TableAdapter that could point to one of 2 tables (Live vs Dev) - right now, i'm manually going in and changing the table names when before i publish the project, but it's annoying, to say the least.Is there a way to set the table as a variable / parameter?Basically, I'm looking for the equivalent of:
SELECT @hTable1.*, @hTable2.*
FROM @hTable1
LEFT JOIN @hTable2 ON (@hTable1.PO_ID = @hTable1.PO_ID)
[code].....
What i am trying to do is get my system to look into the database and recognize if the user is a admin or a user, based on that they have certain rights below is my code
Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Public Class Form3
[code]....
If I enter a data in a textbox, I want my listview to select the same data entered in the textbox. Example: I have a StudentNumber column in my listview and it has data on it (ex. 123456)
I will enter 123456 in the textbox. The ListView must select 123456?
I do the same thing with URLdownloadtoFile: IT WORKS.Wih the WEBCLIENT part I just DO NOT GET the Text file from the PHP/MYSQL server: I only get message "Invalid Username/Password or no list download permission: ||"
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim urlStr1, urlStr2 As String
Dim fileToStoreStr, fileToStoreStr1, fileToStoreStr2 As String
[CODE]...
code that creates a program where a user can key in 3 coordinate points and when the click "Generate Triangle" button. the program automatically creates the program.
View 5 RepliesI am building a game project for a school project. User gets points for completing certain tasks. I have it all coded - curious as how I should do high score table. I was thinking an Access DB, but that seems like total overkill. Does XML seem reasonable?
View 5 Repliesi want to check the validity by select data from access and then chek1-select data with (there are error)
Dim result
As
Object
[code].....
Unable to select multiple column in datatable
Code:
Dim Activitydtb As DataTable = DirectCast(ViewState("TalentcharacterActivty"), DataTable)
grdviewactivity.DataSource = Activitydtb.Select("SELECT
[Code].....
My problem is with the tickets table, I have listed the user that created the ticket, the tech who will solve the ticket and a user that over sees the ticket. All three users reference the users table. So how do I can I query the tickets table and get all three users that reference the same table storing the users?
Table1: Tickets
1) Ticketnumber
2) EnteredBy User 100
3) Issue
[code]....
What I can do now is something like this:
Select Ticketnumber, EnteredBy, Issue, UserName FROM Tickets INNER JOIN Users
ON Tickets.EnteredBy = Users.UserID
How can I update local dataset with mysql database without making duplicates. Assuming I set some column in mysql as primary key, which has unique string.
adapter.fill will just add duplicates, but adapter.clear before that is not an option.
So I want to update if the key column is the same with mysql data and if there is option for ignore adding new row.
I sent the application exe to a user to test and they get an unhandled exception error and the details show my personal My Documents Folder/DEBUG path from the project. So I tried to use Application.ExecutablePath but when I release that it points to "My Documents" Folder (not the debug) folder. The file to open is in the same folder as the exe is in but for some reason the error occurs because the application is not looking for the file using the path where the EXE was launched from. Here is my code that relates to the section giving my users a problem:
from the module
Public Class shrd
Public Shared ocSess As cSession
[code]....
How can I get the application to open the file that is in the same folder as the exe when the user launches