I have this code and whenever i try to run it, I always get an ODBCEXCEPTION WAS UNHANDLED ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]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 'char VALUES('101','noodles')' at line 1
[Code]...
How to create database in my mysql if it the database name is not currently true in mysql? Using vb.net How to check if database name is already created or available in my localhost using vb.net.
View 5 Repliesi have datagrid on my interface with few columns eg. student name, address and age. on top of that there is a text box to include the group name. i want to save all the grid data into table called "groups" in access database. as an instance under group 1 all the students names and their details.
View 1 RepliesI've got a big database driven project...15 forms 50+ input boxes and im wondering how to do it effieciently. I've got code to connect to the mysql databse but i dont want to put it inside each form over and over for every form. How can i do it so that i only have to clal one method to connect to the db or leave the db connected constantly from the start of the app. here is the code that i got to put in every form -_-
Dim conn = New MySqlConnection()
conn.ConnectionString = "server=localhost;" & "user id=root;" & "password=;" & "database=project"
Try
conn.Open()
[CODE]...
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 Repliesi have problem to search and update record database sql. this is my code. i using mysql database and Microsoft Visual Basic 2008
[Code]....
but i have error on Word command.ExecuteNonQuery(): MySqlException was unhandled. There is already an open DataReader associated with this Connection which must be closed first
How can i get one record in my MYSQL database what command should i use like this one in visual basic. How should i do these in vb.net?. I want to total the amount of items stored in my MYSQL database and show it in my listview. . . .I just want to get one record and get their values is their a command that i can do that?. . . .
this my code in vb using MS ACCESS
While rst.EOF = False
If txtpcode = rst!pcode Then
rst!stocks = Val(rst!stocks) - Val(txtqty)
[Code]....
Is this the right way to delete a record in a mysql im using a listview do i have to code the listview? I dont have any errors with this but it just wont delete the record in my database and in my listview.Is this the right way to use listview? when deleting a certain record.Not familiar using the mysql commands it makes me confuse and difficult to the properties of each of mysql commands they dont provide enough example using those properties in mysql and it is not well explained for me each of their properties im new with this stuff. [code]
View 8 RepliesI have 2 tables in mysql:
1. stats (stats_id,statsno,statsName)
2.stats_det (stats_det_ID,stats_id,stat_DateAdd,stat_UserAdd,stat_DateModif,stat_UserModif)
I have a form named status and from here I want to add a new record in the first table (stats).I've created the insert statement in the first table which is running well, but I don't know how to get the last_insert_id from stats table and insert it in the second table stats_det.
[code]...
I have been using the internet to figure out how to INSERT into MySQL database. Im almost there I can feel it. Below is the code I put together, but when I click on the button and check the database to see if the data was inserted, it has not.
Imports System.Data.Odbc
Imports System
Public Class Form1
[Code].....
I have been disturbed for a week now. I have a project in vb.net. And on forms I have two masked text boxes. One is for the user to enter their date of birth and in the second one Iam trying to get the date the record is created. With this one I get the current date from pc and format it to dd/mm/yyyy because I want the user to understand the date. How do I INSERT the user date of birth and the the Now () date which is also in masked text box into a MYSQL database? I know how to insert other text but the date fails to appear in database.
View 2 RepliesIs there way to insert null into mysql from an empty text field in vb.net
View 1 Repliesi use this code to insert textbox 1 and 2 to mysql db
this is the
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using connection As New SqlClient.SqlConnection(?????)
[Code]....
i dont knw anything about connection strings, what i must put here :
Using connection As New SqlClient.SqlConnection(what connection string to use ?)
i have a problem for put in multiply input
Try
Dim StrSQL As String = "INSERT INTO boranga" & _
"(IdBorangA,Answers)" & _
"VALUES (@B_IdA,@B_Answer);"
[Code].....
by adding more parameter "parameterB_IdA.Value = Label1.Text" for IdBorangA
and "parameterB_Answer.Value = TextBox2.Text" for Answer but the result i get that the table only filling with the data from Label2.text and Textbox2.text.
For the last couple of days I've been having problems inserting data into my MySQL database. I'm using parameters to insert the data and have done so in the past without any problems, but for some reason I haven't been able to get it to work this time.I have a form that the user inputs data to be inserted into the database. This data is then pushed into an array and sent to my class (CastProduction.VB) via a Public Sub. The data than pushed into a datarow and than pushed into a datatable. Once this is done I send the dataset and sql insert statement to a private sub that inserts the data into the database.
[Code]...
I want to know if it is possible to perform a mySQL query to get a single record (searched for by ID) and then split each field into a seperate text box.I think im ok with the SQLQuery to get the record. its the splitting it into individual text boxes that im strugling with.
View 1 Repliesi build a code that can insert my records to mysql database.. the codes are correct it can save records to the mysql database. Now i want to know is what code will i used that will show an error if the records already exist, so it will not make the same records again. here is my code for my INSERT code for mysql databas.[code]
View 4 RepliesI'm trying to do a looped insert using the MySQL Connector for .NET and for the most part it's working, except for it's missing out inserts. The code below is what i'm using. An example is there are 20 items in the listview and only 8 out of the list actually insert to the mysql database. It's as if the loop runs too quickly for MySQL to keep up. My issue is that eventually this loop will be inserting many thousands of entries and I can't have it missing information out.
[Code]...
I am trying to to an insert query on my MySql db using VS 2008/VB. I have this query: Insert into allservices StartDate....) values ('" & Me.datesched.Value & "', ....) When I use the single and double quotes, as it is above , I get this error: Quote: Incorrect date value '21/10/2009' for column StartDate at row 1
when I remove the single quotes and have only the double ones I get a completely different thing. The date inserted to the database is 01/01/0001. Even if my datetimepicker has a min and max date. Also if someone has any good links on using mysql with vb.net
an example code of how to tell vb.net to input a textbox data into MySql database, i am a new learner
View 4 RepliesDim insert_coupon_query As String = ("INSERT INTO qa_discountcoupons (id, status_code)
[Code]...
I want to insert image in mysql database using my vb.net program. Then my php script should be able to read from that database and create a file which can be viewed/downloaded by me.Now I am using vb.net program to connect and insert rec in db. Inserting record works okay. But I dunno how to insert contents of image file.
Dim cmd As New MySqlCommand("Insert into " + tables.SelectedItem.ToString() & " (clientid,priority) values(123,'hi')", conn)
' The above code is able to insert a record Now my table has field called img which is blob type. It can store image but how do I sent that image data using insert statement.I am using MySqlDataAdapter.
I am developing a portion of an application that deals with settings reminders and alarms for personal notes. I am trying to insert from a formatted datetimepicker( formatted to show time only ) the time a user wants to get a reminder of something he/she wants. The column in the MySql database is of type 'Time'. I was never succesfull in entering and saving the data. Either I was getting validation problems not allowing me to exit the datetimepicker after I choose the time. To resolve this issues I just made 'false' the option 'causes validation'. Now the problem is that the time is not inserted getting problems saying that :
Quote:
Specified cast is not valid.Couldn't store <01/01/1753 00:00:00> in ntime Column. Expected type is TimeSpan.
here is the code for saving
Dim xtime As DateTime = New DateTime
xtime = Me.NtimeDateTimePicker.Value
Dim result As DialogResult
[code]....
This time it does not even insert a new row it just updates the last entry I have changing its time. This is strange as this happens only when I use the above two lines.
I have a MySQL Table that I would like to insert stuff into using VB.NET.[code]
View 15 RepliesI have one problem regarding how to check whether the record already have or not then do insert or update.I'm using firebird database.i want to pull all record from one table to other database . Here my coding but i'm get stuck to do insert or update. [code]
View 1 Repliesi am creating an application that will upload a picture into a mysql database. I currently am able to add normal records with text and integers into other tables and get the data in the table to display in listview etc, however, i am wondering how i could insert a picture into the mysql database.I know the field needs to be blob type and have that set.The table i want to upload to is "picture" and contains only 3 fields, "ID"; "pic"; "caption".
View 5 RepliesI have this code:
[Code]....
now in my DataTable called "tablaLOGICA" i have 180.000 records as strings and later on in my program i have added 90.000 more strings in this DataTable. QUESTION..'which is the quickest way to update my "real" table in MySql? 'At the moment i make 90.000 INSERT whithin a loop, but it is so slow, it take more than half an hour !!!! is there any other way to do this INSERTs?
I used the following code to insert data from my VB.NET into the MySQL database.[code]..
View 2 RepliesI succeed withe the linking and display the data from MySQL DB but the problem is within the DML Commands ![code]...
View 2 RepliesI am doing a simple registration form in visual basic.net 2005, this form contains the general information about the person, in this form it includes uploading/inserting images for the record. Here is my project, on MS SQL,i can insert and retrieve images easily but when i switch my database into MySQL i encounter the problem that i can't insert image to my database. Can anyone provide me a sample code for inserting and retrieving image from a table on MySQL database?
View 15 Replies