This 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]...
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 Replieshow 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 Replieserror " 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 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 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 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 having a problem regarding to pass all the data on the listview from one form to another and add another columns. The purpose of my columns is that I want to put text from there because I am sending a mail but I want to get the status of my message if it failed or send and write it at every end of the rows.
View 4 Repliesim using vb.net 2008 and i would like to ask if is it possible that if i click a data in my listview then it would go to another listview and using a db
View 6 Replieshow I get user details from a user table from a mysql database.
Ive already worked out how to connect to the server, im just wondering how to import the data into a datagrid.
Heres my current code
Imports MySql.Data.MySqlClient
Module sql
Dim Connection As New MySqlConnection("server=" & Form1.txtServer.Text & ";user
[Code].....
So I have a text box in a form. The test box needs to take the value entered and insert it into a column within a row in MySQL. I know it's connecting to the MySQL online, I have a message box telling me so upon a successful connection. I'm just having problems adding the value. Here's my code: Public Class frmOptions Dim ServerString As String = "server=db4free.net; Port =3306; user id=dailylogmain; password=XXXXXXX; database=dailylogmain;" Dim SQLConnection As MySqlConnection = New MySqlConnection
Private Sub frmOptions_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
Using VB 2008 Express.
Just downloaded the connector/net from MySQL website, and after installing successfully, I am not able to add a reference to the .dll to continue using the namespaces to establish a connection to a Mysql database on my website.
THIS IS THE SAMPLE OF ENCRYPTED DATA PLEASE HELP ME HOW TO DECRYPT THIS KIND OF ENCRYPTION
View 2 Replieshow am i supposed to get all the data from excel to mysql? and then it will be placed to a temporary table in mysql, after that create a compare and replace query or vb .net code to compare the data.
View 1 RepliesWith vb.net 2008 exp + MySQL 5.0
i am unable to get the data from a query / SP created in the database.
kindly have some patience to teach me what basically makes difference in extracting data from a table directly and from a QUERY / SP[code]....
I use to do programs in VB5 and haven't touch VB for years, and now i just started to pick it up again, VB2010. my problem is getting data from my MySQL Server (local)
i was able to create my Data Source successfully.. however, when i click and drag my CUSTOMERS table to my form the datagridview shows nothing. I read a few online tutorials and they all said that's all i have to do not working for me..i have 9 records in the table already but nothing is showing..
I have for ex. 5 names i table A in table B i have several rows with 50 names.. But i only want to pull out the records that matches the 5 names in table A! I never know the amount of names in table A so i need to pull out every record in that table..I guess i have to get the names from table A and put them into an array and then in the query get the records from table B that contains the data in the array.. I have tried, but no luck..
View 2 Repliesi need to store file paths in mysql database but when i try in puting the path in and up with a path without "" . i did read that i need to put two slashes if i want to add this in mysql. i want somthing like "C:windowssystem" but end up with "C:windowssytem" when i try to add it to mysql.
Dim connStr As String = "Database=" & Dbase.Text & ";" & "Data Source=" & localhost.Text & ";" & "User Id=" & TextBox1.Text & ";Password=" & TextBox2.Text
Dim connection As New MySqlConnection(connStr)
[Code]....
how to retrieve data from mysql using vb.net as frontend. I created database in mysql and able to insert data from vb.net but i dont know how to retrieve data from mysql.
View 8 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 RepliesModifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 Replies