I have an assignment where I have to develop a Windows application using Visual Basic .NET. From the form that I have designed, it should save all records in a table in a MySQL database. How should I do this? Here's what I've got so far:
Imports System.Data
Imports System.Data.SqlClient
Public Class AddMember
[code]....
I have a problem in inserting database entry, suppose I have two paragraph entered in one richtextbox what I want is that When I hit save, every paragraph will be save as one database entry therefore my database will have two records..This uses VB.net 2010.
View 17 RepliesDim lvitem As Object
Dim iCount As Integer
Dim iLoop As Integer
[code]....
That is my code. message box show up but the record is not saved in my database?
I want to retrieve a data from my mysql database into my textbox, my problem is how can i show the previous and next data in a column? because it only shows the last data entry.
this what i have done so far
Sub filltextbox()
strsql = "select * from tbl_studinfo"
mysqlcmd.CommandText = strsql
[Code].....
if i had a cancel button which showed a message box, how would i get the message box to show OK and Cancel and for each of them to do something?
and how would i get an OK (paired with the first cancel from above) to save an entry/ changes to a database?
I am trying to save a date to a mysql database and usually the only format permited to be saved in the table is YYYY-MM-DD
On the form the datetime picker is formated like this MM-DD-YYYY
The thing is i am using dataset created by wizard to save the data, what should i do to be able to format this for save and read because it is giving me errors.
I whant to entry data in a database (fild) by pressing a button. The problem is that the button is in form 1 and the database is in form 2.
In the Button1_Click i have the cod for Form 2 to show.
i am trying to save image into MySQL database ...is there any easier way to do that ?
View 1 RepliesHow to save ITEMS on listbox to MySQL Database in vb.net.
View 10 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 program in vb.net and my program will upload any type of file to my database, e.g common ext. to upload (.doc.xls) Im using mysql as database?
View 1 RepliesI'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 RepliesIs that possible to save values from a listbox to mysql database? I guess yes. I have a list of values in a listbox obtained from splitting a file. The strings are like numbers but they are of type string. What I need is to get those values in the database in the integer type. How can I proceed?
View 8 Replieshow to convert video file into binary to save to mysql database and how to retrieve it.
View 1 Repliesthis is the code for my save button
Dim iCount As Integer
Dim iLoop As Integer
Dim query3 As New MySqlCommand
[Code]....
every time i hit save, there is no error but it does not save on my database.
I am developing a program and stuck up with an issue. I am able to enter single value in MSAccess database however, when I create a programe to enter multiple entries I am getting an error. developing a code to enter multiple entries in MSAccess 2002 db with the help of VB based form?
I Following code I am using for single entry:
Private Sub Button1_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Enter
Dim query As String
[code]....
I have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
give me a sample code that works when uploading data from access database into MySQL database...
View 6 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]...
well this may be a simple question to some but for me, im not even sure where to start. I have never done a program in VB.NET yet that uses a MySQL database. So this should be a fun thing to learn. I looked at an example for access databases and it seemed pretty straight forward. But I must use MySQL as the database is on a Linux server in Ohio.
What I got so far is how to connect to the database using ADODB. Here the example I'm giving. You got 4 col's call AccountNum (primary key), Phone, Name, and Address. For each row is data of a client. What I'm trying to do: the program asks for the account number. You type in the account number of the client. It then
compares it to the rows of AccountNum col till it finds a row with it. Then it asks if you'd like to change the phone number or address.
So what I'm looking for is the, how to call rows and change data in col's.
Visual Basic 2008 I want to put data in combo box from MySQL database.
View 19 RepliesHow 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 RepliesWhen user inserts a duplicate entry in a unique field, Castle ActiveRecord throws the following exception:
Castle.ActiveRecord.Framework.ActiveRecordException was unhandled
Message="Could not perform Save for SerieNotaFiscal"
Source="Castle.ActiveRecord"
StackTrace:
[Code] .....
Public 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..
I'm looking into creating a program which will on program opening connect to a remote mysql database, download the data and store the data into a local file (keeping both in sync is the idea).
Getting a connection to the remote database is my first hurdle, and i'm not suceeding, i know i need to read through more info but if i could get this working it would help me tremendously.
I have attempted to connect using the mysql connector, using the server IP and port number ie. 199.002.999.000:3306 but it doesnt connect, it does connect locally ie. localhost but for some reason it won't connect to the remote server.
My other problem is that i cannot control the mysql server, i.e connections allowed remote etc, i think they're just enabled to accept connections from the server.
Is there a way to run a hidden browser script behind the scenes, download and run the file? I've tried looking for possible ways to acheive this, but have come up trumps so far.
i have a site that is running in php with a mysql db and i want creat a app wiht .net 2008 to return/send values to that database what is the best way to do that? i have think in this options:
[Code]...
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 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'm trying to test some stuff out, like adding employees and stuff like that.
Now it used to run on an Access database, but I've made the jump to MySQL.
Now to add an employee I use this code
Private Sub btnOpslaanWerknemer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpslaanWerknemer.Click
Try
[Code].....
now I get the following error: "Error: MySQL.Data - You have an error in your SQL syntax; check manual that corresponds with your MySQL server version for the right syntax to use near '?,?,?,?)' at line 1.