I have searched google and youtube for a tut on this but cant seem to find any :/I have a script that adds contents of textbox1 ans textbox2 to a online mysql database like username and and password.All this works perfect What i now need is to display the contents of the given database in a listbox or something.How would i go about this or is there any good tuts on this, all i seem to find is tuts using ms database not mysql
View 6 RepliesI am doing database coding for the first time. I wanted to get connected to MYSQL database with "Root" as username, "Password" as password , "DBNAME" as database name, "Local Host" as host and Append the contents of a textbox control to MYSQL column. So can anybody please post code bit in VB.Net for doing this task.
View 17 RepliesI am trying to create a code where I placed sets of numbers in an array.I'll use a masktextbox to have the user enter the numbers to match what's in the array. If the user enters the number, ex: social, and the data is correct (matches the numbers in the array), something happens if the number entered in the masktextbox does not match any of the number sets in an array then another thing happens.The masktextbox so far only validates format and gets number only, however, I want the number entered to match whats in the array.
View 1 RepliesI need to open an archive and list the contents, size of files, and crc of files inside any compressed file. Be it rar, zip, ace, lha, 7zip, etc.. What's the easiest or best way to do this?
View 1 RepliesImports MySql.Data.MySqlClient
Public Class Form2
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As MySqlConnection
[code]....
I can't quite figure out how to populate the dang list with that code, am I doing something wrong?
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 Repliesi have sql 2005 and i want to develop a small program that can access the database and amend a few rows of data. in sql database, i have 1 table and it consist of 3 columns = datetime, type & price. below is example:
[Code]....
I'm having a problem with Dim query As New MySqlCommand("Select count(*)....") I would like to take the variable query and do an If query <> 1 Then statement on it. Is this possible or is there a completely other way to go about this comparing the contents of a MySQL select statement. I'm rather new to Visual Basic.
View 1 RepliesI have one Field in MYSQL DB. Name is ' Field1 '. I can store the Richtextbox text(it contains Bold, Italic, Etc). using the code ' Richtextbox1.rtf 'But when i am trying to display using 'Richtextbox1.rtf=dt.rows(0).item(0).tostring ',It shows 'File Format is not Valid '.
View 2 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]...
connect to MySQL to create a database in visual Basic 2008
View 11 RepliesI'm trying to connect to my MySQL database I have online at (mywebsite.com), however it just hangs for about 30 seconds and says and does nothing.
Dim sConnection As String = "Server=mywebsite.com;Database=mydatabase;Uid=myusername;Pwd=mypassword;"
Dim scConnection As New SqlConnection(sConnection)
Dim scCommand As New SqlCommand("SELECT * FROM mytable WHERE user = @user AND password = @pass", scConnection)
[Code]...
I'm guessing the connection string is wrong, I'm going to try the server as localhost, but in the mean time hopefully someone might see what I might be doing wrong.I'd also like to look into doing it asynchronously, so the UI doesn't freeze,
Is is possible to connect to a database that it not on the internet via a Visual Basic form?
View 11 RepliesWhat i need it to display all records in that database into a richtextbox or something.This is because i need to regarly check the database records and it would save a lot of time rather than manually logining into the cpanel and checking.I was looking at datagrid but that only does:Microsoft Access Database File (OLE DB)Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)
View 2 RepliesI have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
I developed a project in VB.NET..In this project I want to use data from MySQL that is resides in my WEB Server.I can communicate with the MySQL server of my localhost but can not communicate with the WEB Server.In my CPanel I added Host from the Remote Database Access..But I can't communicate with WEB MySQL Server.
View 2 RepliesHow to make module to vb.net 2008 and using mysql database
View 1 RepliesI am using the following codes to Save records to MySQL database from VS2008.
Dim cmd As New MySqlCommand
If cmdSave.Text = "&Save" Then
'save computer main
ConnectComputerDB()
cmd.Connection = CompDBCon
cmd.CommandText = "INSERT INTO tbl_items " _
[Code] .....
Is it the right way and proper method to save records to MySQL database...?
I have a database in MySQL server called MD
Server: Local host
User: root
Pass: wccmd12
port 3306
How do I connect to this database in vb.net?
insert a datatable into a mysql database? The way I'm doing it now is that I'm doing a for each-loop and inserting one and one row. Is there a better way to do this? I have like 500+ rows, so it takes a while to execute the loop.
View 4 RepliesI looked everywhere online and I couldn't locate an equivalent VB2008 code for this php code.
$field = mysql_fetch_assoc($result);
$field_title=$field["title"];
I'm trying to read the content of a field in a mysql database. I found this code below that does it but you must select the position of the field (column 0, 1, 2 etc) myData.GetString(1) instead of the name of the field. In the php code above it is "title". I'm looking for a command like myData.GetString("title")
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim myData As MySqlDataReader
[code]....
I 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 recently added a login that uses mysql database now it use to pull data from text file but as i said i made it use mysql now..it works great locally but when i sent it to a friend to test the login he got this error. unhandled exception has occurred in the your application. if you click continue, the application will ignore this error and attempt to conttinue. if the click quit, the application will close immediately could not load file and assembly 'MySql.Data. version=5.1.7.0 Culture=neutral, public key token=c5687fc88969c44d' or one of its dependencies. this system cannot find the file specified.not sure what to do i was thinking about having him install the MySQL Connector net but i thought i would come here first and ask..and can someone also help me on how can i retreive data from the login part? i can get it to keep the username but for some reason i can pull the rest of the data here is the login script.[code]
View 11 RepliesI want to connect to an MySQL database on the website, I want to write and retrieve information from that database into a table on my program.
Can anybody link me to a tutorial on how to do this? Or give me some insight, I'm relatively new to Visual Basic (7 months) and I'm not exactly sure on how to do this.
My connection that I am using is via connection string, so there's no dataset that will be created for the datasource. How can i create one for this type of connection?
View 3 RepliesIm trying to make a program and i have everything done but i need to make a login bar that if the user logs in, it takes them to form10 but if they log in and they are in a special user group on the forum (VIP) they go to form11.
View 39 RepliesThis has really been a problem for me in the past and with deadlines, we decided to just have the app copy the image to the server, rename it and save the link in the database. This is the worst way of saving that kind of sensitive data, I know. We now have the time to fix that.
View 4 RepliesI have a website with MySQL databases. I'm wanting it to connect and: display a table's data, login using a table with logins, and submit a form to go to be put in the table.
View 2 Repliesi am about develop an application and i want to do the following.
1. use vb.net 2008 for the application
2. use mysql database as the database for the application
Question:
1. is it possible to package the application by adding the mysql database so that during deployment it will be installed as well eg. vb.net 2008 and access database can be attached and deployed without installing any file to support