I have the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim connetionString As String
Dim cnn As SqlConnection
[code].....
And I'm trying to display my result from my sql query in the label that I have in my application, but it doesnt seem to work. I get no build errors and the SQL query works on its own.
I'm programatically creating labels in programatically-created panels, and have run into an issue--the label's information isn't completely showing! COnsistently only the first few characters are consistently displayed. I've tried bringtofront, but it doesn't work at all. And the characters stop well short of the panel barrier--does anyone know what to do about this? I used messagebox.show(labelname.text) to make sure it wasn't working properly, and sure enough all the characters I want are in the label, but aren't appearing.
View 2 RepliesI have a datagrid where i am entering numeric values. at design time, i have set the format for each column to C2. So at run time, When i am entering the values, it is being set in the current format. When i am displaying data from sql, instead of showing 400.00, it is showing only 400.
View 15 RepliesI have 5 textboxes embedded in a datagrid that require a date format (mm/dd/yy), but can be left empty if user doesn't have date.User can poplute these textboxes for multiple records and hit submit button.On the submit i loop through the grid. If dates are populated AND they are in the correct format then I call a stored procedure that inserts the record into a table.If any of the dates that are populated in the textbox is not a date or in the incorrect format I need to display error message in a label.I got all this to work, but if it throws error message all the data in the grid is wiped out.How can i keep data in each textbox and still display the error message?
View 1 RepliesI'm trying to come up with some code that will make the 'Acct #' label and text box ONLY appear when some text is typed in the text box beside of 'Prime Broker', 'Custodian', etc.
View 4 RepliesI have a data grid that i am getting the row count of and displaying it into a label. All works, but when there are 0 rows the label still shows 1.
This code updates the label when something changes in the datagrid:
Private Sub AuditProductsDataGridView_CellStateChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellStateChangedEventArgs) Handles AuditProductsDataGridView.CellStateChanged
[Code].....
I've managed to create my game which is working fine. woop woop... (quite an accomplishment for me I must say :-)) My problem now however, is displaying all the users guesses on the label. My code looks at the users guesses and a simple message box tells the user if the guess is higher of lower than the random number generated. I'm simply stuck as to how I am able to retain each guess, and the corresponding result via message box, which will then display via the label.
View 9 RepliesOn form1 I have a InputDialog (Created by code.) on the Dialog there is a InputTextBox that is bound to MyBindingSource. When the Enter Key is pressed I need Label1 to replace the dialog while saving the entry to the DataBase and then display that saved record.
View 5 Repliesmy code below, though it didnt work. i want to display text on label if the colors of label on anoda form is orange.correct me where am wrong. or advice better way to do this.
If Main1.Label15.BackColor = Color.Orange Then
Label2.Text = "1" And Label4.Text = "N5,000"
ElseIf Main1.Label14.BackColor = Color.Orange Then
[code].....
I want to read from a text file and display it in a label. However, when I do that, I see that there is no word wrapping. In the sense, a whole paragraph is displayed in one line and the next one in the next line and so on. Can some one please tell me how to read text from a file and make it display as it is (lines as they are)? I am using the following code right now:
Imports Microsoft.Office.Tools.Word
Imports System.Runtime.InteropServices
Imports Microsoft.Office.Interop.Word
[code]....
I need to display images when I press a key on the keyboard. I have a form with a textbox and a label on it. When I type a letter in the textbox it appears on the label. I got that part to work. But now I want to display a image in the label when I press a key on the keyboard. I have found some images on the internet that I want to display when I press a key on the keyboard. For example when I type the letter A in the textbox instead of A appearing I want an image of an apple to appear, or if I type the letter B a banana would appear, or if I type the letter D a dog would appear. I have been searching on how to this I came across the keyboard event such as the keypress event. Can I use a keypress event of the textbox to do this. Can I assign a certain image to a certain key on the keyboard, and have that image display whenever I press that key.
View 7 RepliesI have a variable which I called ElapsedTime. I press a button and it displays the time in seconds since clicking the button, into a label . I did it with HTML
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
LblElapsedTime1.Text = ElapsedTime
ElapsedTime = ElapsedTime + 1
End Sub
Private Sub BtnStart_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnStart.Click
Timer2.Enabled = True
End Sub
This updates every second a bit like a simple stop watch. Great so far, because I do need the elapsed time (in seconds) for later use in my app. However, whilst elapsed time is being displayed in this label on the screen I want it to be shown in HH:MM:SS format. How can I convert it into a new variable " ElapsedTime2 " so that I can show it in the desired format yet still retain my original " ElapsedTime " variable for later.
So I have coded connection to database and query but when I push button nothing happens. So my question is how can I fix that Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
What is the advantage of using a text box to display an answer in Visual Basic versus a label?
View 2 RepliesI have a list of names in a database and what i want is to get all of these names and display them in a label or a text box to the user on the website. I have tried to do this using a for loop but it is always overwriting the label each time. I have a list of 10 different names in the database and what it is doing is putting the first name in the label and then overwriting this with the second name and so on until it reaches the last name. I think i need to store each of the names from the database into an array or an arrayList and then make the label display all of the contents from the array or arrayList. The for loop i have used for this is:
Dim g As SQLadmin = New SQLadmin()
g.DB("SELECT nameOfPerson FROM Persons")
For i As Integer = 0 To g.array.GetLength(0) - 1
[code]....
i can select the names from the database and store them in an array then make the label display each of the names.
I had done this by using the query builder (in VS Studio) but soon found out thay I gain no points by doing it this way as I am not using any code. I have tried to adapt the code I had to insert data into my database, just changing the SQL sintaxa and some other bits, but it is not working yet. Well, it gives results, but I think it is still geting the results from the query I had built using the query builder. Here is the code I've got so far:
Public Class Form2
Private Sub btn_search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_search.Click
Dim str_search As String = txt_search.Text
Dim str_dob As String = txt_dob.Text
[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 used following code searching records from a table in MsAccess and displaying in a Listview and it is working fine with the search criteria based on Discription.
CODE:
I also tried the above code to search records on the base of CustId and it worked fine too.My table DailyTransaction in MsAccess is as under:DTDate, DTTime, CustId, Description, Quantity, Price, Amount, AccountNumber, Name
Now I want to Search records on the base of Date I tried the following but it did not work.
Dim cmdText As String = "SELECT * FROM DailyTransaction WHERE DTDate=' " & TextBox1.Text & " ' "
Also i want to make following sort of query to retrieve data between two dates and to display the sum of amount group by DTDate. I could sketch following query and deifinitely it is so wrong with Syntex.Select * From DailyTransaction where DTDate Between textbox1.text AND textbox2.text Group By DTDate AND SUM(Amount)
i have a problem trying to query my database based on a value in a label. Here is the code for the query,
[Code]...
I want it so every time I click an ITEM in the Listbox it displays ALL the data into the textbox. I know there's an easy way using table adapters and binding the listbox, but I'd prefer to do it this way for my project.
So this is what I got.
Lst.DataSource = ds
Lst.DisplayMember = "tblStudent.FirstName"
Lst.ValueMember = "tblStudent.StudentID"
[code]....
It only adds the first rows details to the text box when I click the second record the first rows details are still there.
I have a label printer (Argox 1000-x) and i want to print some datas on it. And this printer is connected to my computer via the COM1 port. I can open/write COM1. And when i send some data to printer through COM1, Label Printer's Ready Signal Led will be ON/OFF. But it does not print anything or any label..
View 5 RepliesMy application outputs log text every so often and I need the user to be able to see the latest text at all times. I've tried a label, a text box and a rich text box, but I can't figure out a way to show the bottom-most text at all times.
View 2 RepliesI want display data from database in Listbox...Here is my code, It is not working. In Listbox it is displaying as Object[,].Array..
[Code]...
I would like to know if there's anything that can display data differently than what's stored in the DB.Here's my example. I have a column called Active and in the DB table, 0 represents Active, -1 represents InActive.In my report, when showing whether or not a listing is Active, I'd rather have the words Active and Inactive rather than 0 and -1.
View 3 RepliesIt appears my connection to the db is correct when I select different options the datagrid displays the correct number of records. So I am not sure why I can not see the data in the grid.[code]....
View 4 RepliesI want my mysql data to be showed on datagridview, i'm doing like this but it's not displaying. [code]....
View 4 RepliesCan someone show a beginner how to display data in a chart.I am using VB 2010 and my form displays a datagridview.The Datgridview has 2 fields. Date and numberfield.I would like to show the date along the bottom of a simple bar chart with each number from the numberfield above the relevant date
View 2 RepliesI am working on a program in VB 2008 that will generate a due list. What I need to do is look in a dataset for customers that are due this month and display it in a grid that can be orded by their city. I know how to do a query to that dataset and find the appointments, I do not know how to display the information in a grid from for sorting.
View 3 RepliesWhat I am trying to accomplish is this: I have a login page were a student logs in. After the login the student will be taken to a student user page. This page has 2 list boxes. The first is showing the exams that he has passed and the other shows the exams he has yet to complete or fail. I can not get any data to display in my list box. If I can figure the first one out I can do the second one easily but I can not get the first one to work. Here is my code that I have so far:
Private Sub Student_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = "Welcome " & _passedText
[Code].....
i have problem in displaying data in list box after i click in any row in datagrid view
here is the code
Dim sql As String
Dim conn As New System.Data.OleDb.OleDbConnection
Dim lst, lst2 As New ListBox
[code]....