I'm making a game that I'm connecting mysql to it. I have a labels that display stuff. Such as your username,level,gold. I'd like to know how I would make the label display that information. For each label a different one. Like on label is their level. One is their username. So on and so forth.
Column names are : ID = username
Level = Level
Gold = gold
Does anyone know how to make label1 show the data in textbox1? I simply can't figure it out.Value of type 'System.Windows.Forms.TextBox' cannot be converted to 'System.Windows.Forms.Label'.
View 12 RepliesI have some code here that connects to my Mysql database. It checks your username and password and if your login was successful and it retrieves the phone number under that account. How would the SQL Query look like for retrieving the phone number once connected? Then how would I be able to display that phone number on a label?
View 2 Repliesmy simple program flows like this: a textbox where in you will input a keyword then when you press the 'go' button the data in the mysql database will be shown in the listview. im using mysql and vb .net.i've made the table with sample records in it, the problem is i don't know how to call it to the listview
View 2 RepliesPublic Sub loadme()
Dim cnString As String
Dim sqlQRY As String
[Code].....
i cant see data inside my datagrid..what should i do?i'm using my sql as my database..
I am new to VB. I have created some labels/textboxes in my Form1. I use them to do some calculations. Basically, this is my calculation area (in Form1) and then I want some of the results that have been calculated and showed in these texboxes to be shown in labels which are in another form (Form2). So here is what I have done in terms of coding:
Label12.Text = Transactions.ComboBox1.SelectedItem
Label13.Text = Transactions.ComboBox2.SelectedItem
Label14.Text = Transactions.ComboBox3.SelectedItem
Label15.Text = Transactions.TextBox1.Text
Label16.Text = Transactions.TextBox2.Text
These codes are in Form2 and Labels 12-16 are in my form2 as well. My form1 is called Transactions as you can see. Everything looks OK, when i run no errors, also when do the calculations and I go from form1(Transactions) to form2, labels 12-16 show the results from form1 but the problem when I go back to form1 and change the values and go back to form2, the labels 12-16 are not changed. They simply show the old values regarding of the fact that they have been changed in form1. So how can I make form2 to show them correctly, to refresh the form or what?
I need to click a button but after doing so a label will show the first digit in a text box and
another label will show the second digit. I know the button control but I don't get how to get the label to say what the first and second digit is.
I am trying to get the green label box to show the correct coordinate after the box is scaled. The red box always shows the true coordinate of the mouse in the picturebox. So for example - after you click on [Scale x4], the 32x32 picturebox will be 128x128. The red box will now show from 0-127 x and y. I would like the green box to show 0-3 x and 0-3 y. Does anyone know how to do this? The code is ready to run, just cut and paste. [code]
View 4 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 Repliesi can connect to my database via my program ,now i want to get some columns and show their texts in textboxes for my program btw im still searching.
View 3 RepliesAt moment iam trying to fetch some data out of a mysql database.hope i can explain well what i try to do.Okay i made a form with some text field and a combobox.What i want is at start when the form loads that all the last name will get catcht out of the mysql database. all those last names should go in the combobox.now i have a few textboxes like adress phone number living place go onWhat i try to do now is when all those lastnames are in the combo box when i select a nameand press the button to update that it will catch the info from that user out of the mysql database and puts the info in the right textfields.What i got so far is a succesfull connection to the mysql database.
How do i know that my login to the application is also connected to the database and that one works fine ;)the only thing i cant manage is to take the data out of mysql and put it in the textfields.i made a form called test to testthis out so far this is what i have on code
[Code]...
I've got a program that downloads data from a mysql database via a XML file. I want to store this information locally. If I make a .mdb file could someone use this without have access on their machine?
View 13 Repliesi'm using recordset to retrieve data and then show it through listview, that took more than 2 minute to retrieve data. i think that kinda slow.
View 18 RepliesI have added a MySQL Database as a data source in VB using the MySQL .NET connector and added the dataset . How do i write to the database from there?
View 7 RepliesI'm developing a new programme that uses multiple table to store Orders placed via my website, on the form that i have created i have a Combobox that displays the Point of sale name. what i need it to do is when the record is updated in need the Point_of_sale_ID value that matches the name from the Point_Of_Sale table to be put into the Point_of_Sale_ID field on the Sales_Order tableI have added the Foreign Keys for the fields, but i cannot find any help in regards to this, i mainly wor with PHP but have taken on the new challenge of VB & ADO.Net, i have rear several book on the subject and have produced several single table programs but am now stuck!! [code]
View 6 Replieshow can i get data from mysql table and show it in listbox in visual basic 2008
mysql table
id
filename varchar 255
filetime timestamp
and it is windows application
I have a combobox in my form which I want to fill with data from one column in an SQL database. Any idea on how I do this?
View 1 RepliesI have a .dll file ( MySql.Data.dll ) that I'd like to be able to open, view and possibly edit the database but I can't find any examples or documentation on doing so.
[Code]...
This code creates the chart, and extracts the formula from the trendline. The problem is that the trendline "DisplayEquation" label is formatted as General. In Excel it's easy, just right click and select format. But I can't make it from VB. I thought that:
View 1 Replieshow to add, insert, delete and search data in vb 2008 using mysql databases.
View 1 RepliesHow to Inserting Label.text data into mySql table.i have no problem with textbox.text but i can't figure out how it with Label.text[code]...
View 1 RepliesI am creating a game where i have made a login form thats uses the mysql database for the user accounts.The database stores account's login info, level, XP, Coins.
[Code]...
I have a DLL of classes. The first one stores an ArrayList of numbers. A method from the second class takes the ArrayList and must show the numbers in a table . I should not use windows control library. How can I make it show the data in a table?
View 8 RepliesThe code below works well to load an Excel file into a DataGridView. The menu 'Show Data Source' reveals there is no data source available. Is there a way to set up a data source much in the same way as is possible with a .mdb which I would normally add with the menu 'Add New Data'? Several ways to confugure the DataGridView are not options without a known data source.
Public Class Form1
Private da As New OleDb.OleDbDataAdapter
Private ds As New DataSet
[code].....
error " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
Alright it's been awhile since I messed with this project, so here goes. It's an appointment scheduler and everything works except two things: I can't edit existing appointments and it only records the current time, not the timeslot I click on when I add a new appointment. If I try to edit an existing appointment it doesn't get the row data, just shows me blank text boxes. I assume I have to have those text boxes read the info from the database, but I don't know how to do that. This is how it looks:
[Code]...
My sql database is :and on form1 objects is 5 X Textbox and 1X numericupdown I want with numericupdown value=1 then first 5 rows column name fill on the 5 textbox and so numericupdown value =2 then fill second 5 rows fill on the 5 textbox and so for all rows repeat.
View 5 RepliesI'm populating a datatable with some data from a MySQL-server, and then binding the datatable to a datagridview. Here's my code to populate the datatable[code]...
View 1 RepliesHaving 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].....
Im trying to parse a log file and display the data in a textbox.The log is forever changing so it will have to be some kind of a loop.I only want the new data to be added to the textbox after the application is running, not the contents already in the log file.
View 1 Replies