my 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 RepliesThis code runs at my other sample prog. but when I try to use it to my actual prog., it wont work.
(variables changed, connection's ok) . . . cant show data at listview
Imports MySql.Data.MySqlClient
Public Class Form1
Public sconnection As New MySqlConnection
[CODE]...
Public 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'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
how to get 1 Thing from a internal DB but. i use a external DB to show the online games. But now the other players must see a list of online games.
vb.net
Dim conn As MySqlConnection
'connect to DB
[Code].....
this is the code for my save button
Dim iCount As Integer
Dim iLoop As Integer
Dim query3 As New MySqlCommand
[Code]....
every time i hit save, there is no error but it does not save on my database.
here is my code
Dim lvitem
Dim iCount As Integer
Dim iLoop As Integer
[code].....
Dim lvitem As Object
Dim iCount As Integer
Dim iLoop As Integer
[code]....
That is my code. message box show up but the record is not saved in my database?
HOW TO SEARCH or FILTER MYSQL DATA IN TEXT BOX & WILL DISPLAY TO THE LISTVIEW
View 10 RepliesI'm trying to put data in my listview but the data doesn't show in my listview.
When i put this code in my form i dont have any problem but when i put this inside the module the data doesn't show up.
Code:
Public Sub getEmployee(ByVal myConnString As String)
Dim mySelectQuery As String = "SELECT names FROM employee ORDER BY ID ASC"
Dim myConnection As New MySqlConnection(myConnString)
[Code].....
I am having a issue as above title. How to show data from file (txt file) in list view control?
View 7 Repliesive written a query to show data from my database in a listview (using more than or equal to in the query itself) the problem is it doesnt show all my data that is greater than what i have put in and it still shows some data however that is less than,
SELECT * FROM Room WHERE [Room Size] > = '" & Noofppl.Text & "' AND [Number of PC's] > = '" & noofpcs.Text & "'"
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]...
I have a local MySQL server which has a database. Now, I want to populate a listview with all entries (Rows) in that database. [code]...
View 4 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 RepliesI have searched and searched but have not found code that worked for me. I need to get the data from a mysql db to my listview. I can already connect to the db, i just need the code to get the stuff from it to the listview.
View 5 RepliesI'm loading my listview with records from a mySQL Table, which works great. But I'm having issues when I try to add records to another listview according the selected row in the first listview.
vb.net
Dim mysqlDataComm As New MySqlCommand("SELECT jan, feb, mrt, apr, mei, jun, jul, aug, sep, okt, nov, dec FROM data_table WHERE datum ='" & frm_main.Listview1.SelectedItems(0).SubItems(1).Text & "'", mysqlConn)Dim mysqlReader As MySqlDataReaderTrymysqlConn.Open() With frm_main.lstv_data.Items.Clear() mysqlReader = mysqlDataComm.ExecuteReader While mysqlReader.ReadDim lvi2 As New
[code]....
It works until ".Items.Clear()"... after that nothing happens and I really don't know what I'm doing wrong. No error, whatever.
highlight listview item from mysql search statement then get the index?
View 6 RepliesHow do you refresh a datagridview in code to show to show new data in the DB?
View 3 RepliesI have a vb-2008 program that contains a (listview) control.
View = details
AllowColumnReorder = true
Lets say the table has 3 columns (a,b,c) and 1 row of data.
a b c
1 2 3
I want the user to be able to re-arrange the columns (by dragging the column headers) before printing the contents of the table.
c a b
3 1 2
Statements like:
.. ListViewX.Columns(2).Text
.. ListViewX.Columns.Item(2).Text
.. ListViewX.Items(0).SubItems(2).ToString
Give the column-name (c) and cell-contents (3) of the origional table .. not the (3rd) column (b) of the re-arranged table.
How can i get the column-name and cell-contents of the (3rd) column of the re-arranged table?
i am developing a point of sales system. currently i have my product code scanned and displayed in a listview. lets say that i have 5 product codes displayed in my first listview. By clicking on a button, how can i use these codes to call upon the details (prices, product name, etc.) of the corresponding codes and display in another listview?
i am using Visual Basic 2008 and MsAccess as my database. who have the idea on solving my question. (As my last thread has not been answered at all..
i am developing a point of sales system. currently i have my product code scanned and displayed in a listview. lets say that i have 5 product codes displayed in my first listview.
By clicking on a button, how can i use these codes to call upon the details (prices, product name, etc.) of the corresponding codes and display in another listview?
i am using Visual Basic 2008 and MsAccess as my database.
i created a listview, and i have a button5 "view records" if i click the button, all the records should be shown to the listview but yeah i doesn't work
here are may codes:
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
conn = New OleDbConnection("Provider = Microsoft.ace.oledb.12.0; data
[Code].....
get 3 columns in a ListView?
View 3 RepliesI currently grab some html code from a web page in the format of a link: <a href="">text</a> this shows up in the list view as html: <a href="">text</a> is there any way in vb.net to show the text hyperlinked? so it just displays: Text
View 1 RepliesI used this codes to show the records but this doesnt works .. but when use the query
("Select * from Schedulings") it works .. it shows the all records. but i want to show the records that satisfy this query.
[code]...
how I show the selected value in a listview?
I've been trying several ways, some of them below:
MsgBox(ListOfSongs.Items(ListOfSongs.SelectedIndices.Item(0).ToString))
MsgBox(ListOfSongs.SelectedItems(ListOfSongs.SelectedIndices.Item(0).ToString))
MsgBox(ListOfSongs.SelectedItems(ListOfSongs.SelectedIndices.Item(0)))
I have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
I am listing folders and folder sizes in a ListView for a VB.NET WinForm program I'm writing. I would like to total the folder sizes in the last entry of the ListView and 'lock' it show it always shows (even if scrolling through the list. Is there a way to do this? I'd really like to avoid adding another control on the Windows Form to display the total.
EDIT:Space is somewhat of an issue as I'm trying to keep this window small enough to work in a min screen resolution of 800x600 (I know, not the standard, but I want to make this available to even those in the elderly community with problematic eyesight.
I want to perform following action when i click on a item in a listview it would also show in a separate label.....
View 4 Replies