i just want to ask how can i show information from my database into label..
Im using Visual Basic 2010 and . Net connector..
this is my sample codes and i dont know how to put it..
CN.ConnectionString = "Server=localhost; database=libsysdb; Uid= root; pwd=dbpass; Port=3306"
Dim myCommand As New MySqlCommand
[Code]...
I have an online database, and I have a program to insert information into database and to login using the information in the database, now I am wondering how to take something from a database and display it in a label, lets say if I log in with my username and password I want it to display my e-mail address from the database in a label, this is the code that I have for the register:
Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Public Class Form2
[code]....
i wants to show the label when status='C' and 'F' (selected from the database) here i want to show the label message as like "rooms 2 (status ='C' ) and 3 (status='F') are free" by using database conditions. here iam using sqlserver as database. here my coding is given below
[Code]...
how to create a program that can access information held in an excel database and show it in a simple form.
View 2 Replieshow do you show information from a datagrid cell to show up in a text box in another form, this is for a college project.
View 1 Repliesis it possible to show a figure in one Label in another label through a button click event? for instance, i have a figure in label1 and i want to display that figure in a label of another form is it possible?
View 1 RepliesThe program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and runs the QueryDatabase() Function i am encountering an error of: "OleDB exception unhandled: No value given for one or more of the required parameters." This occurs on line 15 of the first code snippet. Can anyone explain this and/or identify any code issues if that is the cause.
[Code]...
I want to (for an example) find out the computername of a specific computer. Now I already know the computers name, so I will test the result with the actual computer name, just to see if I am using the WMI properly. This is at the moment only for learning, in the future I want to be able to find out the Current User, How much memory, what applications are installed, what applications are running etc.
Here is my code
vb.net
Dim Options As New ConnectionOptions
Options.Username = "***********"
[Code]....
I'm trying to grab information entered in textboxes. I'm trying to grab a name, an age, and a movie title from three separate textboxes, and put them into a single label like this:
"Name" is "age," her favourite film is "movie title."
after clicking the "Show" button.
I know it's a click event for the show button, but I can't quite figure out how to make the concatenated message.
I'm just starting out with vb and am working on a single form project.
Basically I'm trying to take information entered in a textbox on the main forum, Appear in a tab control at the bottom of the forum through the use of a button.
As far as I can tell, I need to code the onclick button portion of it but am unsure about how to pass the information to the specific label in the tab control.
I have an app where users form up an e-mail by filling out various fields. They give the form the data, then the e-mail is assembled in the background from all the data they put into the form. Pretty straightforward.
I've added a "Preview" button. When they click, I want a box to pop up and show them what their e-mail will look like when they send it.
I can use MessageBox.Show but these e-mails can get pretty long and as best I understand it, there's no way to control the MessageBox.Show size, word-wrap or add a scroller; so this isn't really appropriate to the overall task.
That said, the information IS all concatenated into a single string with CrLf and such in there for most fields. I just need something that I can send this to and have it create the output window at size X with auto-word-wrap and scroller.
Is there a straightforward way to do this in VB.Net 2010?
Can I databind label to display a piece of information from dataset?
View 3 RepliesI am using bindingsource.find to quirie information, its working so nice but I have a problem when the bindingsource cannot find the information I want it to show me the information that is inside the field, even knowing that the information that am looking for is not there:
I have something like this:
dim findinformatio as string
inputbox=(type the name)
dim findme as intenger=me.bindingsource.find("LastName", FindName)
me.bindingsource.position=findme
if bindingsource.position=findme then
msgbox(Findname)
else
msgbox(me.bindingsource.find("LastName", findName)
I am doing it because if the information that am looking for is not in the record field. I want the bindingsource show me the information that is inside the recordset field(LastName). I used to do it with odbc and works fine but with bindingsource I cannot, Why? And I have a compact database, sdf. I loaded the tables on my project.
Im suppose to make an application that tracks electric motors in a manufacturing plant. It needs to have
MotorID:Five-digit string, such as "02340"
Description:String
RPM: Integer, values in the range of 10 to 10000
[Code]......
I was thinking about doing this part in radiobuttons
The application should be able to store at least 10 motor class objects in an array, create an input form in the application that allow users to input new motor records to be added to the array and create another form that displays all the motors in the array in a list box. This is what I got so far, I know its not much, but whats really puzzling me is how am I suppose to show all the data in the listbox in the second form.
This is whatI got for the first form
Public Class Form1
Dim range As Integer = 0
Dim voltage As Integer = 0
[Code]....
and the second form I really dont know where to even start on that one.
I have to write an application that has the user input data in 3 separate text-boxes and press "OK" to save it. The user can repeat this as many times as they want.I then need the application to show the information inputted in each of the 3 separate arrays. Now I was told this can either be done by using a print page or by having another form show the information. I was told having another form would work best. I guess my question(s) are: is it possible to show the information from all 3 arrays in another form? Also, is there a link to any code that can help me out in listing information from a
View 7 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.
Having trouble getting this to work. Only one number shows in the label. I need all 10 to show in the label.
Dim list As New ArrayList
Dim selected(19) As Boolean
Dim thisnumber, i As Integer
[Code].....
I'm starting to learn programming in Visual Basic .Net , I need to open an excell file show the information on the screen,
View 2 RepliesI'm trying to load up a comma delimited text file and have only the name of a person loaded into a listbox. Then when the user selects a person from the listbox have additional stats pertaining to that person show up in a label.
View 4 RepliesI have another probably easy question to answer but i can't figure it out... I have made a little snake game with a score attached to it running through a timer that outputs to a label.
View 2 RepliesHow do i show the date in a label 2 months before today?[code]...
View 9 RepliesI have a form that I am loading text (strings) from a database into a label.text (so the text from the database shows up into the label) I have done this code in a class that keeps all my database stuff seperate.
Public Function getQuestions() As List(Of String)
Dim question As New List(Of String)
objConnection.Open()
objReader = objcommand.ExecuteReader
[CODE]...
Within the form that the label is in I have done this code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text(db.getQuestions().ToArray)
End Sub
I am basically making a quiz, so that when the form loads, question 1 is on there is 4 possible answers. You then press next button and it goes to the next question.
I need to format a Label to show numbers in a certain way. I had asked this before about textboxes so I looked into that first but it didn't do what I wanted.
[Code]...
Im working on a project containing a couple of forms. On the main form I want to labels in the status bar that show the X,Y location of the cursor when it moves over the form. I thought this code would do it but it doesnt work
Private Sub MainForm_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Me.MouseMove
lblCursorX.Text = "X: " & e.X
lblCursorY.Text = "Y: " & e.Y[code].......
I have to work with network program with vb 2010. I'm trying to show the ReadLine stream in label text but it won't show.
Dim tcpCli As TcpClient = tcpList.AcceptTcpClient() 'claiming tcp listener to accept the tcp client
Dim ns As NetworkStream = tcpCli.GetStream ' assign ns as network stream and assign as client to get nw stream
[Code]....
I've got two forms. I have a combobox named 'cmbThrow' in the first form. I need to pass the numeric value of it to the second form and show it with a label.
View 12 RepliesI want to perform following action when i click on a item in a listview it would also show in a separate label.....
View 4 RepliesI would like to have a label that shows a message when a warranty is past its determined days. Here is what I got for now.[code]....
View 12 RepliesMan I've tried to figure it out but i cant get it, anyone know how to?
View 1 RepliesI have a assignment and I have got to do the total cost and put the total in a label, here is the code. Select Case pizza1
[Code]...