got a new problem while trying to add a new user into the database. After i've submitted all the data i get an error message saying "Conversion failed when converting the varchar value "Aron" to data type int" to be honest, im totally stumped as to what this could meen, does it meen its trying to convert string type data to an integer? Anyway heres the code im using
[Code]....
im trying to add a new user login to my database through my program, and i've got the procedure worked out, i just dont know how to retrieve the inputted data.
Basically i've got three text boxes that ask for "Name" "Password" "Phone Extension" but how would i work them into his statement?
CreateLogin.CommandText = ("INSERT INTO Users (UserID, Password, Phone) Values How would i follow up after "Values"??
writing user info such as user, computer name, date, and time to an acces database using a button click event. Then use a query to check if the user has accepted the aggreement. If the user has accepted the aggreement then call a vb.exe that display the aggrement. I have a login script that runs the vb.exe and uses a button click that records the user info to a csv file, but if the user has already agreed to the policies I do not want it run again.
View 4 RepliesThis code is correct...
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName"))
Loop
Suppose i want to add both last and first name..I tried this but getting a error
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName" & " " & "LName"))
Loop
I have selected the info that i want from my database but im unaware of the syntax need to be used to add them to the datagrid.The datagrid has the column...BookName, DateRetun and DateIssued.
cn.ConnectionString = "data source = RayonRayon; initial catalog = library; uid=sa; password=minnie"
cn.Open()
cmd.Connection = cn[codee]....
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 RepliesMy aim is to try to add a new user to a access database. Im doing this using from a form named frmRegister. It seems like the code is working perfectly, and I get no expectations that indicate if any errors occurred. However, the user doesn't get added to the database.
The code I'm using is:
Public Class Register
Dim connectionString As String
Dim connection As OleDbConnection
Dim OLEDBAdapter As New OleDbDataAdapter
Dim OLE As String
[Code] .....
(Files too large for attaching here)
Rar format - [URL]
Zip format - [URL]
I'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 RepliesI have been trying to solve this for 2 days now, every text book I own and google have been well and truely exhausted and I am still no closer to solving my problems.I have a login facility reading in user info from a main user file. This takes all info into a temp array and then splits usernames into a username file, passwords into a password file and a current score in a score file.
I have the login working fine and everything else in my program works as intended but touching up cosmetic aspects I want to add a Message box after login to say hello and display current score. This works great for the first name in the user file i.e - after login User1 welcome to the game. Your current score is 45 As intended.But the problem arises with any other users, my message comes out as
User2 welcome to the game. Your current score is 55 I do not understand where the random new lines are coming from. I have tried assigning the message as a variable and removing new line using
[Code]...
I have a datagrid that has a DataNavigateUrlFormatString that passes info on to the next page when the user clicks on the link. However I am trying to add some functionality to the next page and want to add some data to the url that is not in the bound columns. Is there a way to do this? Right now it looks like
DataNavigateUrlFormatString="~/cakes/PaymentHistory.aspx?id={0}"
and I would like it to look like
DataNavigateUrlFormatString="~/Taxes/PaymentHistory.aspx?id={0}&year="
I am working with an image tagger system. I am done reading the file's properties. Then when I go to code for keywords.. an error exist saying that Retrieving the COM class factory for component with CLSID {58968145-CF05-4341-995F-2EE093F6ABA3} failed due to the following error: 80040154.
I Already added the DSO file.dll and the class library Imports System.IO
An error exist in the Bold text below.
Dim oSummProps As DSOFile.SummaryProperties
Dim strTmp As String = String.Empty
<strong>Dim oDocument As New DSOFile.OleDocumentPropertiesClass()</strong>
[Code] .....
I'm displaying data from a database in a datagridview, but the player also needs to be able to add new rows, which isn't allowed because the datagridview is data-bound. What is the simplest workaround to this problem?
View 10 RepliesI am trying to ask the user the add personaly information in the text boxes. Then based on what the user clicks on the radio button precourse, the application will deterimine what the costs will be for the participant. Here is my code. I am not getting error messages in the objPreCurse or objParticpant class, but in the form on line 47-55 where the If and then statements appear.
Option Strict On
Public Class Form1
Private Sub radNetwork_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles radNetwork.CheckedChanged
End Sub
Private Sub lblTitle_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lblTitle.Click
[Code] .....
I have a form in my application, and when I logIn, I make a query to SELECT the username, the password and the level of username.
"SELECT username, password, level FROM TLogin WHERE [username] = @username and [password] = @password and [level] = @level"
So, when I logIn, I go to a form called "Options", I would like to know how to only show the information about the user that I've loggedIn ?
In my vb.net windows app, which runs on windows server 2003, i will like to return all the users who are logged into the server. How to do that?
View 3 Replieswhat i want is when the user inputs the username and password, his/her information will be showed in the textbox located at the mainform which shows the users information like where he live and his occupation. how to show users data in the textbox of another form when he/she logged in. im using vb.net and mssql
View 1 Repliesim trying to edit a code so that i can display user info in a listview rather than a listbox because listview has some options i want to use , i have 2 errors one in Public Sub removeClient and one in Private Sub AddClientToListview i would be very greatful if some could give a helping hand to resolve these errors
vb.net
Imports System.Net.Sockets
Public Class form1
[Code]....
how to show to a user the file info of a file programamtically. Can I just use the Properties window that Windows use to show all the detals of a file (e.g. name, type, size, path, date created ect.) I am using the IO namespace
View 3 RepliesI need to convert a large VB6 app to vb.net which does a lot of database work and produces a Crystal Report. The initial form is simple a login form which validates the user. I am trying to use a datareader to retrieve the user's login info but it won't compile on the statement where I'm trying to get the Connection String from the app.config file. It complains that the ConfigurationManager is not declared on the dim statement. Where and how do I declare the ConfigurationManager? I thought it was just pointing to the app.config file but apparently that is not correct. [Code]
View 3 Replies1> take a request... ie. First name, Last name, or login ID and Search AD Path can be hard coded so entire forest is not searched.
2> List all entries found
3>once the correct user is selected I need to pull First, last, middle name and , Email , Phone number , @ and GUID for that user.
I'm making a program where the user fills out info, then they click one button and the program takes a screenshot of the form, then they click another button and the screenshot gets saved. I'm having a couple problems with my code though. For one, I'm trying to make the screenshot go to an invisible picturebox to make saving easier, but I cant figure out how to make the image go to the picturebox. The other problem is that I want it to automatically save without showing the dialog, but so far, it won't save.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
TakeShotOfScreens()
Picturebox1.image=allscreenscapture
CODE:...........................
I am trying to learn VB.NET and I've written a user entry screen to store and retrieve information. I keep getting this error. I understand that I have to either change the ref value from the calling code, but my problem is where is the calling code? Here is the error I'm getting (the program is underscoring udtTrans in the FileGet line in this segment).
Private Sub viewRecords()
'open the file and read fields of the first record into the textboxes
Try
FileOpen(1, strFilename, OpenMode.Random, OpenAccess.ReadWrite, OpenShare.Shared, Len(udtTrans))
FileGet(1, udtTrans, intCurrentRecord) 'gets first record
[Code] .....
I created a sign up page for my program using:
Username
Password
Address
State
ETC
How can I save all that info to a file to pull up for later use in the program? All the info was entered into text boxes and at the end of the program I have a button that is named Save Information.
I have a form that has 10 addition execises. The user has the option of using a timer or not. I have the timer part correct, but now I want to be able to check the exercise answer one by one as the user inputs the info.
[Code]...
i have treeview.. in which i want to display info in textbox when user select a certain node..
View 10 RepliesSomething like in the image.I know that <Description("blah blah blah")>_ gives the description, but when the user is in the designer tab, I would like to know how to add that info when intellisense pops up.
View 1 RepliesI wish to put the XMLSerializer behind a 'facade' class of mine so that user wont have to supply type info to the constructor. But doing this has a problem. Consider this class:
Class XmlFormatter
Private Shared xs As XmlSerializer
Public Function Deserialize(ByVal serializationStream As Stream) As Object
Dim o As Object = Nothing
[code]....
The problem is that the user of this class cannot use Deserialize without first using Serialize because the XMLSerializer instance is created in Serialize and it is shared. But using Deserialize without this instance will simply return Nothing.
i am trying to make a login screen that is connect to a database(NOT MS ACCESS).i keep geting an error when i try geting it to conect to the database
"Value of type MySqlData.mySqlClient.MySqlDataReader cannot be converted to System.data.OleDb.OleDbDataReader
At rdr = MyCommand.ExecuteReader()
dose anyone know whats going on
[Code]...
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
I have 3 labels I want to populate with info from my database. I have a SELECT statement that works for only one piece of info but I need it to include the other 2 as well.
I have 3 labels: Current, YTD, and MTD My select statement is working for YTD but I don't know how to write the SELECT statement to include the others.
[Code]...