I am building an app where I need to allow a user to add a large text (a story) to his account in server.This will be done like this:
application developed in vb.net for article formatting pass the story to php page using request variables (because direct connection to MySql server can reveal my password in app exe) php file will store data to database.But right now I get: 414 error - url too big.
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 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 want to upload a text file to a table I have in my database. I have never done this kind of a thing so I don't have any clue. The column is in longblob.
View 10 RepliesHow to upload text file and microsoft office file to mysql database using open file dialog.
View 1 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]....
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesI can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 Repliesgive me a sample code that works when uploading data from access database into MySQL database...
View 6 RepliesI have 2 computers. Both with w7 as os. I have installed wampserver on one of them.I have mysql database on wampserver.Then I have made a vb.net program to connect to mysql database. I have put the program on both computers.What I want to do is for those two programs to see the same database that is on one computer. For them to be able to add, delete, update that 1 database. How do I do that? How do I network the mysql database? Do I also have to install wampserver on the other computer?What do I do
View 1 Replieshow can i edit my mysql database using vb.net2008 datagridviewer?i have the code from the reply from other member but mycommand and myadapter is still undifined..
View 1 Repliesi am working on an application which uses login form, search and registration in VB.NET but let this topic focus on login first i am using MySQL database via MySQL.NET connector
here is what i have so far Private Sub btnLogIn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogIn.Click
[Code]...
I'm trying to add values to a MySQL database. The values that I need to save come from several textboxes. The SQL-query is read from a XML-file.
Query: INSERT INTO myTableName(ID, Groep, Naam, Achternaam, Intern, etc...) VALUES(NULL, NULL, tel_txt_group.Text, tel_txt_name.Text, tel_txt_surname.Text, tel_txt_intern.Text, etc...)
Unknown column 'tel_txt_group.Text.ToString' in 'field list'
I am writing an app that uses both an SQLite and MySql database. The reason for this before you ask is that it means I can store a local copy of the data onto my user' own machines when they are offline, and then update them to a central server when they are next online.
The problem I have is that when using datasets (on tables created in identical fashion) the itemarray of the mysql database has 9 extra totally blank fields...where as the SQLite itemarray has only the values for the items.
here is a snippet of the code:
CODE:
ultimately I am getting an index size mismatch error but with both tables having the same number of fields this is confusing.
I am visual studio 2005(VB.NET) and MYSQL 5.0 as Database. I want to Backup my Database. I am using the following but the result is in 0 KB.Process.Start("C:Program FilesMySQLMySQL Server 5.0
inmysqldump.exe", "--user=root --password=root --host=3306 --databases MySQL hospitality -r ""C:BackUpDataBase.sql""")
VB.NET Express 2010.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I think I already know the answer to this, but just to be sure, is there any way to connect to a MySQL database in VB?
View 4 RepliesI have a VB.NET application and I need it to be able to display rows from a MySQL database. How would I do this?
Update: Another thing that I could do is have the app get a PHP page from the site that shows the DB, and gets the page every 10 seconds or so.
I'm having some trouble setting up a working connection to a mysql database from Visual Studio 2010.After downloading and installing the mysql-net connector, I set up a simple testing database in Xampp and experimented around a bit until I managed to read some values from the database and inserting new ones.I'm trying to access another database on a remote server and all I get is an error message: Unable to connect to any of the specified MySQL hosts.Basically, I'm only trying to execute this code:
Dim con As New MySqlConnection("Server=111.11.111.111;Uid=root;Pwd=mypwd;Database=mydb;")
con.Open()
con.Close()
(server ip looks a bit different of course)When I access my local database, it looks quite similar:
Dim con As New MySqlConnection("Server=127.0.0.1;Uid=root;Pwd=;Database=test;")
con.Open()
con.Close()
Nevertheless, I can access the remote database easily using a simple PHP script... no problems there.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim MyConnection As New OdbcConnection("Driver={MySQL ODBC 5.1
[code]....
I'm trying to connect to a database but it doesn't work...
Code:
Dim conn As MysqlConnection
conn = New Mysqlconnection()
conn.ConnectionString = "server=http://www.*****.net/phpMyAdmin; user id=*****; password=****; database=login"
[Code]...
I have memebrship system with mysql database.In the table I have comumns named Username, password, information...I have to found the row with the username who have logged in and put the text from information column in textbox...
View 1 RepliesOk so I have a Mysql dsetup called in-out and I have written a vb.net client program to get information from the table in the database, display it in a data grid view, and then allow to user to edit this information and update it on the server. Right now I am hosting the server on my Gateway laptop and also connecting to it from the same laptop therefore I'm using localhost as the server name. My problem is that when I go into the program and change the information and click update, nothing happens... the information stays the same yet there is no sign of an error, syntax failure, or program crash.
I've tried running this on another computer in my house and i get the same results. I can access the information without a hitch but updating it is where I run into trouble. If there was a problem with my code it would have displayed some sort of error or asked me to debug my script, which would have made it a lot easier to solve, therefore i am certain that it has something to do with my database. Before I got to this step, i kept getting an error when retrieving the information that said something like
[Code]....
I have been trying to update my database I only receive a msg box replyng that my msg is successfull updated but when i check my database no data is being saved!
here is my code for update
CODE:
Here is my changePassword button code where I call the method UpdateDB:[b]
CODE:
how to use linq with mysql database in vb.net,I have searched on google but did not find clear tutorial on this?
View 1 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]...
im trying to let users login to an application i created in vb.net using the user table of the application's database in mysql i heard that The usual way to do this is to have just one MySQL user called "[my_app_name]" with the relevant permissions. Then my application uses it's own user table to control access to the application, and the one MySQL user to access the database.
View 2 RepliesI'm working on an application in VB.NET that has to connect to a MySQL database and FTP. How secure is it if I used it in an application that I gave to other people. E.g. if I was to let other people use this application would they be able to find out the MySQL and FTP connection details through intercepting packets or something like that? If that's the case how can I work round this? Also, part of my application is an uploader for users to upload files, is FTP secure for that or are there better alternatives ways in doing that? My server is a Windows Server 08 if that makes any difference.
View 2 RepliesI'm creating a program with database and it almost done. The only one thing that left is the backup and restore of database. I don't know how to do this.
View 9 Replies
