I'm used to use the Listview, but need/want to use the datagrid. The problem is that I have never used the datagrid, so don't know how to import the data from the mySQL-database. I'm loading the data directly from the database, without any dataset.The code I use:
vb.net
Try
mysqlConn.Open()
Dim mysqlComm As New MySqlCommand(strBeslagdataComm, mysqlConn)
[code]....
What i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
how 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 RepliesHow to use Datagrid in VB.net. I am about to configure the MySQL Records to the VB.net form having DataGrid. I am using Microsoft Visual Studio 2005 ; Database- MySQL 5.1; Form1 having DataGrid in it. Step by Step procedure to get MySQL Database output in the VB.net DataGrid from beginning to end?
View 1 RepliesPublic Sub loadme()
Dim cnString As String
Dim sqlQRY As String
[Code].....
i cant see data inside my datagrid..what should i do?i'm using my sql as my database..
the form loads, it loads the fetch data from mysql in a datagridview, but when i click cancel button, it will again load the same data.
View 1 RepliesI am making a invoice system in Visual Basic 2010 and i am stuck here Here is my code
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
For Each row As DataGridViewRow In datagrid.SelectedRows
Dim selectedindex As String = datagrid.CurrentRow.Cells(0).Value.ToString()
datagrid.Rows.Remove(row)
[Code]...
This code is not working well please have a look to my invoice screen shot and suggest me a better code
When i try to delete the selected row the code does not work and if any one can tell me i can delete multiple selected rows? they are deleted from the datagrid but not from database
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 RepliesNow I have my databases in .sdf-files. These files are located on a server and loaded into several listviews. It has worked fine for a while, but I found out that last week one of the computers didn't close the connection with the database, which resulted in (a bunch of) errors on the other computers.
I have a mySQL server (external) where I can add the data into, but I think that it would slow down the loading severely, but it's very important that people can import the data at the same time.
im a beginner in visual basic.
View 4 RepliesI am trying to connect my application to my database that's hosted on my website through another host. I am using the System.Data.SqlClient Namespace, and I have tried about every connection string possible, and I either get a long delay (About 30 seconds) before the main form displays with a warning in the Console box or it just gives me the warning and loads fast. Either way, it's not connecting.
code:
The x's represent just a masking. The server value is the ip address of my website. Basically, I am wanting this app to connect to my database of my website and it will be used to compare login information as well as the status of the logged in account (blacklisted, active, or needs to be activated).
I'm coding a personal auth system using MySQL and I have made it using MySql.Data.MySqlClient but when I build the final version people required the MySQL.Data dll to run the application
Is their way of not requiring this or another way to linkup?
I've written an application and I'm trying to utilise a database behind it. I've created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within Visual studio connected to the database using the add data source wizard, I then dragged and dropped my db table's column onto my form that intends to display them all (6 textboxes, including primary key) and that now displays the first record of the table. It confused me, because i did this as soon as I had setup the database with no visual basic code assisting, so there wasn't even a connection string?!
One functionality i want to have is to press a button and cycle through the table's records using the form by the unique id, how would I do this? I'm essentially asking how can I enter a number in a textbox which would then return me the relevant primary key and data attached to that record.
I'm pretty new to Visual Basic, do mostly web programming in PHP/MySQL. Need to pull data from a MySQL Database using Visual Basic Program I'm making. Need to when I click a radio button, it shows in text box only the results from a table with a certain trait(as set in the database) etc. For example if an item is set to a certain category. And i click the radio button for that category it shows me only items in that category. I've attached an image of sort of what I've got. I've already downloaded the ADO connector from mysql site. I just need kind of a push from there or a link to a few really good articles. Followed a few youtube videos but I was unsuccessful somehow.
View 1 RepliesIm trying to execute on the click of the submit button adding the text in textbox 1 to the field status within the mysql table. My code is:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
End Sub
Private Sub Submit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit.Click
[code]....
And the error I get is NotImplementedException was unhandled.
I'm using the latest version of the MYSQL DotNet Connector (currently 6.3.7) and I am unable to connect to my database at all with it. It keeps giving me an error. I can connect the the database using SQLyog with the exact same information but not with this.
This is the error:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Here is the code I'm using:
Dim conn As New MySql.Data.MySqlClient.MySqlConnection("" _
& "server=mydomain;" _
& "user=myusername;" _
[Code]....
I have an app, that is going to connect to a remote MYSQL DB.I've look around online, and didnt find any good resources. I've seen some where you have to download an odbc driver etc
View 10 RepliesI want to add a new Data Source (so I can use it with Crystal Reports) but using mysql, I did this before.
In the left side under: 'Data Sources' and then choosed 'Add New DataSource'Then I choose: Database > Dataset I clicked in 'New Connection' and I changed the first box (with 'change' button (as you can see in the image attached)) to what is showed in the image (MySQL Database..)The problem is, as I type the first letter of any of the textbox's that are below (server, user, or pwd) it closes that form showing the previous form (where I clicked 'New Connection')
Have someone had this problem ?I had a connection there, but since I changed the project from 'Framwork 4 Client Profile' to 'Framework 4' (so I could have the Crystal Report Viewer) the connection has gone and don't leaves me create it again.PD: I'm using dotNetConnector (already Added as a Reference)
I have a MySQL Table that I would like to insert stuff into using VB.NET.[code]
View 15 RepliesI know this is simple, but for some reason.. Im just simply trying to take my whole dataset and put it into my premade mysql tables.
[Code]...
So I'm creating this little app to generate words from A-Za-z0-9 and then save that on my local database.Here is my code to do this:
[Code]...
PS. Fell free to help me modify my code. It's quite simple and horrible since if I start generating words more then 5 characters long, it will crash
My program needs to connect to a mysql db, but if the users has no internet or fails to connect i don't want my app to crash
View 4 RepliesI've gone through different sites and got ideas about how to connect MySQL but it didn't work.
Imports MySql.Data.MySqlClient
Public Class Form1
Dim con As MySqlConnection
[code]....
I am trying to follow this userguide url... to basically build an application that will allow users to connect to my database, from an exe file. I'll try to explain as best i can. The plan is, users will launch an exe file that i have built in Visual Basic(VB) 2010 Express. When they launch the application they will see a 'login screen'.I am following the example guide (see link above), and will customise it once i can connect to the database. For some reason whenever i connect to the database it gives me two errors, the first is if i use the 'debug' mode in VB to test the script (note it doesn't produce any build errors), the second is if i build the application and run it as my users would.
1)Error Connecting to Database:Access denied for user 'mike'@'92.**.**.***' (using password:YES)
2)Error Connecting to Database:Unable to access any of the specified MySQL hosts..The ip address starred out (*) is my local machine ip address.The server is the server in which my Database runs on. 'mike' is a listed user on my 'user' table, the password i use is the password assigned to this user on my table.
3)I've rebuilt the whole VB project, but still no joy, wern't expecting it to as there were no errors generated.
4) I've read, but don't really understand that it could be something to do with my database not being able to be controlled remotely, only locally. I started digging into 'Access Your MySQL Server Remotely Over SSH', didn't really know if i was going completely off the mark, it didn't mention needing to do any of this in the guide i've been following, but just a thought. It might be the case as i've tried to access my database through a programme called MySQL Administrator. I punch in the host,username etc and connect to my database, for some reason it won't allow me to add new users, could this be because i can't control my database remotely? Would this stop what i'm trying to do working?
5) When trying to install the MySQL.Data.dll file i had great difficulty in choosing one and finding it, adding it to my project using the 'Add reference' in VB. Finnally got it how it should be (i think), installed MySQL.Data.dll Ver 6.1.2.0 into my project.
I want my vb application to communicate with a MySql database on server on a LAN. What connection string can i use? Also, what syntax can i use? My application is installed on many computers in LAN with one central MySql database. I want all data to go to the database.
View 1 RepliesI have an application developed in VB.NET 3.5 2010 with MySQL as Database server.I need to generate a report type on on a form datagrid View.In the table i have fields as below
Reviewed_By - varchar
Stage - varchar
Review_Status - varchar
[code]....
I Need to retrieve the data to a dataset in below format Reviewed_By are repeated in the table, so i need only 1 cell to be filled by the data and the other empty.I used the below SQL code which worked well at MySQL prompt
SET @PrvSupervisor='';
SELECT IF(@PrvSupervisor=Reviewed_By,'',@PrvSupervisor:=Reviewed_By) Reviewed_By,Stage,sum(Review_Status='Int_Approved') as Approved,sum(Review_Status='Retake') as Retake,COUNT(*) AS TotCount,GROUP_CONCAT(Shot_Num) as ShotsList FROM ShotTable WHERE DATE_FORMAT(Review_Date_Time,'%d/%m/%y') LIKE '10/05/12' AND (Review_Status='Retake' OR
[code]....
In the above result as the last 4 rows are from Person2, so only 1st record of that person is having data remaining 3 are empty.but when i used it from VB.NET i am getting below error.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':=Reviewed_By) Reviewed_By,Stage,sum(Review_Status='Int_Approved') as Approved,s' at line 1
I've been reaserching for 3 hours on how to save data and retrieve data in mysql database I am using vb.net 2010 it would be nice if someone will post some codes or links
View 7 RepliesI'm wondering if I create a program that connects to a mysql database, will they be able to decompile it and do anything with the mysql connection information?
View 18 RepliesI'm creating a database management program and I just got started. I will be using a login form and a form that is the management part. The MySQL connection will be created on the login form and I was wondering how to get it to the other form. What I thought I should do is create a public mysqlconnection property on the login form and just use it from there. I don't think I have ever known the correct way of transferring a mysqlconnection over 2 forms.
View 2 RepliesI'm working on a MySQL database with a VB.NET front end, and I'd like the installer to first install MySQL and Connector/.NET (if they aren't already installed) and then run a query to load the dump file that I'm including among the program resources.Is this possible, or will I have to instruct my users how to install MySQL and Connector/.NET themselves beforehand?
View 21 Replies