mysql

how to input data in mysql, different tables with one query? is it possible to do in gridview in vb.net 2008?

hey there guys. I have coded my own mysql login program. But I have got a problem with it. I have added the following codes in my program Dim MySqlConnection As MySqlConnection MySqlConnection = New MySqlConnection() MySqlConnection.ConnectionString = "server=***; user id=***...

I am looking for the best method of sharing database info between an vb.net desktop app and a server? I am wanting to start a membership website where people can signup from my PHP/Mysql server and clients download an VB.net App. When the VB.net app is loaded it asks for a username and...

I want to connect to a remote MySQL database but the only connection available is a telephone line, a dial-up connection. Can you guide me on how to start on this issue? Any links or comment will be much appreciated. Thanks!

Hi Guys, can you help me out on creating a MySQL database backup through VB.NET coding? I want it to have a button for backup and restore for the convenience of the user. thanks in advance:):tears_of_joy:

hi, please help in my project in visual studio 2008 and connecting it to mySQL, I'm going to create a simple identification system, can you please help me with the codes? (Form1 - Log-in, Log-out) Here's my project proposal, I need to identify an ID number and a password. Like this,(Form1)...

Dear Sir/Madam, we are using Mysql.exe to restore database by the following query string cmd ="-h" + ViewState["host"].ToString() + " " + "-u" + ViewState["user"].ToString() + " " + "-p" + ViewState["password"].ToString() + " " + ViewState["dbName"].ToString() + "<" + " " +...

Dear Sir/Madam, We are using NSIS to install an application. and we have a MySql Script file, which is using inside the installer class. This file is working with Mysql but not from the installer. This is giving a ERROR 42000 syntax error. Any help will be appreciated Santhosha H P

Hi guys, I Googled my problem but couldn't get exactly what i want. My problem's here: I finished developing my VB.NET project in Microsoft Visual Studio 2008 I use MySQL Server 5.0 for the database and MySQL Connector/NET 5.0.9 to communicate. I also have crystal reports in the project. I...

I want to modify this function to populate an array with each item in the database. I have tried various options, but I just can't get it to work Private Function ConnectMe() As DataTable Dim conn As String = "Server=192.168.0.36;Port=3306;Database=wswc;Uid=root;Pwd=Jack"...

My system use to run on from a access database. Now I created the database on a MySQL server. I can connect to it using the connection wizzard, but I prefer using my old methods as shown below. I used this to connect to my access database: Private Function MYDATA() As DataTable Dim...

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? Can you give me the code and/or what to do please

Hi to all, i am trying to set the logon data for crystal reports that i have created. in crystal report builder i manage to connect to mysql by the jdbc driver downloaded from the official site of mysql. but i want to change the ip of the mysql database ex instead of 127.0.0.1 a want to...

Hi folks. I hope y'all haven't gone bush for the weekend and left me to my own devices. I definitely can't be trusted on my own! I'm trying to transition from Classic Asp to VB.NET and I have to confess some confusion when it comes to using a MySQL database. Here is the initial connection code...

What’s new in this release? The latest version release 3.0.0 of Aspose.Workflow for .NET allows editing XPDL packages using a web based XPDL designer. However the previous version 2.1.0 has already announced the support for configuring workflow applications with MySQL and PostgreSQL databases...

Hi, How to make my MySQL Server more secure beside putting password on it. From : MySqlConnectionString = "Database=dbtest;hostname=localhost;userid=admin;" Become : MySqlConnectionString = "Database=dbtest;hostname=localhost;userid=admin;password=gagigugego;" I am making an application...

Imports Microsoft.SqlServer Public Class Form1 'How do I use the SQL database? End Class I'm wondering what the class name in the SQL database DLL is. Can anyone help me? :(

hi all im writing some software at the moment, i have a mysql database backing it all and i have a page called "edit items". its basically a datagrid which displays all the rows from the sql database in the products table. now i identified a problem which is that if i leave the "category" area...

I have to develop a database application in vb.net 2005 with the following rules 1. The application connects with an online mysql database (i.e database resides on a remote machine) 2. The application has no local database but it should have a local cache to stores new records and the changes...

Hello, I'm a noob when it comes to programming with mysql(I understand databases, but I don't really understand the sql syntax very well). I'm creating a database application, and I want to UPDATE a row with all the fields from various textboxes. How do I sanitize the strings from the textboxes...