what i'm working on is, i have VB with a loaded Access DB, and i'm using a query to display the information, in a list box and in indivual labels. i have it so it will allow new entries to be made, however i can't figure out the exact code to get it to update to the program the only code i currently am able to show is this since everything is basically being done through access
[Code]...
I have been coding an application for a LeaderBoard for a game. I have all the Login sorted using Mysql and even have all the Account infomation displaying in lables etc. for account info form. Now I am trying to UPDATE information and this is how I was trying to do this...
Dim UpdateInfo As New MySqlDataAdapter
Dim mycommand As New MySqlCommand()
Dim mydata As MySqlDataReader
Dim query = "UPDATE Login SET Pword = '" + UpdateTxtBox.Text + "' WHERE Uname = " + Login.Uname
mycommand.Connection = conn
mycommand.CommandText = query
UpdateInfo.SelectCommand = mycommand
mydata = mycommand.ExecuteReader()
But comes back with an Error saying... Unknown column 'username here' in 'where clause'. Now the username is in the database as I have just logged in with it and I am taking it I have the Query wrong somewhere.
I'm having trouble with collections and how it works, what I have so far is classes and I have attempted to do collection but it is not working properly. I am trying to have the collection hold the classPerson,classCustomer, and classPreferredCustomer properties, and then display it to list and labels in the Main form. [Code]
View 7 RepliesIt's simple question. I am confused since I am new to vb.net and windows form. I would like to display combining of one column (lastname+firstname) in the list box control from the query. My code display something.
[Code]...
How do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 RepliesIn a VB.Net application, how can I either: Find the dropDownList selectedIndex position of something just added to a database.Have a form restart with the most recently-added entry showing in the DropDownList, by way of modifying the inline SQL query to display by date/time added
View 3 RepliesMy project will end up with several forms to be filled out. Once a form is completed, a button can be pressed revealing the next form or previous form if something is going to be changed. I've been using Me.Hide() so that the users screen doesn't get to cramped.
I'd like a few things to happen. If an input from one form changes a value on another I'd like it to update automatically, I figure some event on button_click or form_load. My problem is that different things work depending on how I open or hide a form. I would also like the forms that have been Me.Hide() to retain the value in the textboxes. Let me show you from a practice vb project so that you don't have to dig through the larger code.
Public Class Form1
Public Shared Info1, Xcord, Ycord As Double
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
1) If I don't use "Public Shared", TextBox1.Text does not update.
2) If I reopen Form1 with the "Dim First As New Form1" method it seems to refresh the Form1_Load. If I use My.Forms.Form1.Show() it does not. Another side effect is that clicking the close button on the ControlBox ends debugging when using "Dim First As New Form1" and does not when using My.Forms.Form1.Show(). Wierd. I've set ControlBox to False on Form2 and Form3, otherwise the program remains running in the task manager. I've read other solutions to that problem, but my solution seems to work for me so far.
3) Xcord and Ycord are my attempts to have the other forms open on top of the first form. My problem now is that I have them set to CenterParent and they open where the first form used to be. If I move Form1, Form2 and 3 open where I've left them instead of centered on Form1, maybe. Form1 is set to WindowsDefaultLocation. My new plan is to set to manual and have Xcord and Ycord update and then offset based on form size. So far I haven't implemented that code.
4) Me.Close() ends the program.
Public Class Form2
Public Info2 As Double
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim First As New Form1 'Done so that Form1.Info1 works
[code]....
I'd like a consistent method that represents good programming practice. My understanding is that Public Shared is frowned upon. I'm also wandering if Me.Hide() is the right choice. I've also played around with .ShowDialog() which didn't work?
I have a windows form where i try to update a form which has 1000 labels. By update i mean i try to set the color of the labels. And i am doing this update in windows form timer every 1 sec.
My problem is the UI freezes. I tried using a thread. In the thread i tried to call the update code, but still the UI hangs.
I've got labels on my form using the following "Shift1Time1Label" to "Shift1Time8Label".I'm trying to get information from a access database and change the text of the labels.I'm getting the information, but having an "Object reference not set to an instance of an object" on the directcast to the label....
[code]...
I'm writing a program where I need to have the label that I'm working query a row in table that I have in a DB.The problem is that I don't want to put it around a button or a click. I may not be saying that right.Here's the code I have so far:
Dim cmd As New SqlCommand
Dim conn As New SqlClient.SqlConnection
[code].....
When I look at the form a check the label or when I click on the label until I get the update feature worked out where it automatically updates to when I do have to click over the label or use a button to update what's there.I was reading some earlier postings and thought I had it right. The return value that I am getting from the form is a -1.
I have a database with about 10 records - each with their own ID. I'm trying to add a new record, and to do this I decided to have a text box on my application form show what the next ID will be. Here's the code I am using:
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
'get EmployeeID from the textbox:
Dim intEmployeeID As Int16 = Val(txtEmployeeID.Text) + 1
'store the emlpoyee
[code]....
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.How would I go about finding the maximum ID in the database and then adding 1 to it so I can display it in the text box?
Here's a dialog box which runs for approximately 16 projects and takes over 5 minutes to complete (in total).
View 1 RepliesIf it is at all possible, I would like to print a page that is layed out with labels filled with text from previousley stored information from the program. now, obviousley, because the text can change in amount, and so the labels need to be able to change in size, and if at all possible allow multiple lines, though if there is no way to do it, then an unchagable text box would serfice.
There is a problem though, the fact that the labels will be changing size means that the position of the labels needs to be variable to the previouse. Example: the box above needs to be bigger, so the box bellow needs to drop down equall to the amount that the above grows.
I use a List(Of T) (where each T is a custom type with a few members) to keep track of about 500 items that change all the time. The list can be changed from different locations within the program (uses background workers that monitor the list).
Question: Is there some built-in way to prevent the List from being updated from different locations or from different threads at the same time? For example, one thread may remove an item from the list while another location changes one of the members of an item, causing conflict, wrong data and errors. Perhaps there is a standard way in VB.Net (framework) to solve this type of problem?
I use VB2008 (VS2008 Pro) and WinXP SP2.
I am trying to understand classes in VB 2010. I am a bit confused with displaying information from a list into a listbox.When I run the following code, the word collection appears in my list box. How do I drill down into 'hostnames' to display the info I want.
Public Class computer
Private _HostName As String
Public Property HostName As String
[CODE]...
I have a data table that looks like this:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
LAGX03 1698 1112 05-07-2012
LAGX04 4598 1555 05-07-2012
LAGX05 2589 3245 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX07 3698 3458 05-07-2012
LAGX08 2589 4587 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX10 3156 1987 05-07-2012
LAGX11 5547 2011 05-07-2012
LAGX12 9456 3459 05-07-2012
Now, I want to execute a sql query that will display the top 5 based on average, so i did this:
SELECT DISTINCT USERNAME,IAVERAGE FROM myTable WHERE IAVERAGE > 0 AND DATE_LOGGED='05-07-2012' ORDER BY IAVERAGE LIMIT 0,5 and the result is:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX03 1698 1112 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
Now, I want to numberize my query result, so it will look like this:
RANK USERNAME ICOUNT IAVERAGE DATE_LOGGED
1 LAGX03 1698 1112 05-07-2012
2 LAGX09 1598 1142 05-07-2012
3 LAGX06 3321 1155 05-07-2012
4 LAGX01 1245 1245 05-07-2012
5 LAGX02 2211 1422 05-07-2012
I am using VB 2008 with Oracle8i Database
Dim rsResult as new ADODB.Recordset
Do While Not rsResult.EOF
...........FILLING mshflexgrid.
[code]....
During MoveNext, i am getting this error, -21474667259 Insufficient base table information for updating or refreshing There is a problem in formating, but it showing error on recordset....why..?
is d query rite ?q = "update FIRSTBBA WHERE FBBANAME<>"" ORDER BY FBBANAME"Need to update a table in ascending order
View 2 RepliesI am trying to update a query in a datagridview using user input from a textbox and a button to apply the query to the grid........
Public Class Form4
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]....
I'm just starting to learn VB and I can't seem to get the label to display 4 separate lines that I wanted it to. It always seems to display Grand Total: (number)[code]...
View 7 RepliesHow can i display search results on textbox etc. like i have wrote code for searching and then it selects values as per search but later how can i display those values on textbox , i have no any idea about how to do this, i usualy use databinding but in this case i dont think i can use databinding
View 4 RepliesI have a label in my form which displays the text-content stored in a text file. However it is not able to display special characters like ", ', : etc. Instead it just puts a small rectangular box (same size as that of the text).
How do I get them to display these characters? Should I not use text files in this case or do I have to turn on some control-properties?
I've been working with my project. I make a quiz and I put check value for every label. If the user is correct the label with shows or else the label is in a hide status. My problem now is how do I count those labels to display his/her result. If there are 3 labels shown in the form in automatically the user got 3 points and that "3" with be put into a textbox...
View 5 RepliesI can't get it to display the computed values in the label fields when I run the form. I've been through the example code provide to me, my textbook, google (how I found DaniWeb), and I've been over the code probably 50 times and the problem just isn't jumping out at me and it doesn't generate any errors or trigger the try catch, so I'm asking for fresh eye.[code]
View 1 RepliesI need a program that will display the contents of an array in two labels. I'v been having problems. Does anybody know how to debug my code?
HTML
' displays the first and last names in label controls
Dim names() As String = {{"Mary", "Jones"}, _
{"Susan", "Washington"}, _
[Code].....
I have the following code:
' Now retabulate the current occupancy.
For Each row In assignments
Try
[code]....
I am using the following code in my vb.net while using that code it will show me syntax error. Private Sub updateinfo()Dim con As OleDbConnection
[Code]...
I have a datagrid which is getting populated by two tables. I want to know how do i perform an update on these tables once the user tries to save any edited data. I am doing the following which i found in one of the articles online: [Code]
If objDataset.HasChanges()
Then Dim data_adapter As OleDbDataAdapter Dim command_builder As OleDbCommandBuilder fillSql = "Select [Price Info].[Product Quick Find ID] As
[Code].....
I am writing a program that has a listbox which is bound to a dataset. When I click a button (e.g. delete) the item is deleted from the database ok using an SQL query but is still shown in the listbox. How do I get the listbox to refresh/update its display?
View 8 RepliesThe user has to enter the text in the textbox , to write a text user need to press the keys and release the keys. Write a code to count the number of keypresses and keyreleases and display the value in the labels.
View 1 Replies