I wish to develop a client-server application in VB.NET. I want to store some fields in Unicode. As per MySQL documentation I tried the fields with varchar and charset UTF-8 for storing Unicode data.I could insert data using the MySQL connector command object but when I try to display data in datagridview some junk is appearing.
View 1 RepliesHow to input the textbox's unicode string to MySQL database. I changed utf8 charset the MySQL Database. I'm using VB.NET 2005 and MySQL Database for Window application.
View 1 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 two textboxes (InputTextBox, OutputTextbox).In the InputTextBox, if I type "a" I need to display tamil letter "அ" in OutputTextBox.For the above requirements, I tried like below,
View 4 RepliesI 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?
how 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]....
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]...
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 RepliesIn VB.net, how can you programmatically launch a .exe file? Is there a way to check if the file is there?
I know there is some way to check using System.IO, but I have no idea. However, I have not even the slightest clue as to how to launch that .exe if it is there,
In my programme, Student have to select 1 major subject out of 5 subjects and 1 subject for major2 subject our of 4 subjects. And student will have to select 1st major subject according to the preference and will have to select each 4 subjects for major 2 subject against each major 1 subject.as an example if student slect csc for major1 he can select 1st preferce stat , 2nd pref.. maths, 3rd pre.. managment. 4 th pre... eltn for 2nd mejor subject.so, if anyone select one subject for major 1 , I want to remove it from major 2 and display the rest of subject.
cmbBox2.Items.Add("CMIS")
cmbBox2.Items.Add("ELTN")
cmbBox2.Items.Add("IMGT")
[code]......
I would like to know how I can get a server ip.I have a textbox (textbox1), a label where the ip will be displayed, and a button that will get that information.this code is not related to this but it performs a simmilar action but instead in displays the ping of a given server:
Dim reply As System.Net.NetworkInformation.PingReply
Dim p As New System.Net.NetworkInformation.Ping
Try
[code]....
i want to use the same textbox to get ping and ip of a given website triggered by the same button.
I'm populating a listview with a list of databases on a selected SQL instance, then retrieving a value from each database (It's internal product version, column doesn't always exist) I'm calling the below function to populate the second column of the listview:
[Code]...
At 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 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 RepliesI have tried connecting to mysql and its working ghood now but the problem is am not able to display it in gridview or datagrid so that the data shown will look formatted
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim conn As ADODB.Connection
[Code].....
well this may be a simple question to some but for me, im not even sure where to start. I have never done a program in VB.NET yet that uses a MySQL database. So this should be a fun thing to learn. I looked at an example for access databases and it seemed pretty straight forward. But I must use MySQL as the database is on a Linux server in Ohio.
What I got so far is how to connect to the database using ADODB. Here the example I'm giving. You got 4 col's call AccountNum (primary key), Phone, Name, and Address. For each row is data of a client. What I'm trying to do: the program asks for the account number. You type in the account number of the client. It then
compares it to the rows of AccountNum col till it finds a row with it. Then it asks if you'd like to change the phone number or address.
So what I'm looking for is the, how to call rows and change data in col's.
I have a problem inserting data into a table on a MySQL database using a VB.NET application. I have a simple form where when I set some data to the textboxes and I press a GO button, the code should execute a function called InsertCar() that takes all these values and insert them into the database and then return true if the transaction is done successfully or false otherwise. My problem is that nothing is being inserted into the table.
Imports MySql.Data.MySqlClient
Imports System.Data.Sql
Imports System
Imports System.Data
[code]....
I have a table in my MySQL database and it contains these items:
User_ID(Primary key, auto-increment)
Username
AvatarPicLink
Location
How can I insert everything into a Datarepeater? Username would be in a Label as would Location, and AvatarPicLink would be in a Picturebox.
Visual Basic 2008 I want to put data in combo box from MySQL database.
View 19 RepliesI have worked out how to get the MySql data into the dataset:Dim DataSet_1 as New DataSet()
Dim SQL_Cmd_1 as New MySqlCommand("Select * from Table where feild = X")
Dim SQL _Dat_Adapter_1 as New MySqlDataAdapter (SQL_CMD_1)
SQL_Cmd_1.Connection = New MySqlConnection("server=localhost;user id=user;password=pwd;database=db")
SQL_Cmd_1.Connection.Open()
'MessageBox.Show("Connection Opened Successfully")
SQL_Dat_Adapter_1.Fill(DataSet_1)
SQL_Cmd_1.Connection.Close()
If the query returns 8 column values and I want to read those values into 8 feilds on a windows form - How do I do it?
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 Replies