this 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.
Dim 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?
here is my code
Dim lvitem
Dim iCount As Integer
Dim iLoop As Integer
[code].....
With vb.net 2008 exp + MySQL 5.0
i am unable to get the data from a query / SP created in the database.
kindly have some patience to teach me what basically makes difference in extracting data from a table directly and from a QUERY / SP[code]....
This code runs at my other sample prog. but when I try to use it to my actual prog., it wont work.
(variables changed, connection's ok) . . . cant show data at listview
Imports MySql.Data.MySqlClient
Public Class Form1
Public sconnection As New MySqlConnection
[CODE]...
my simple program flows like this: a textbox where in you will input a keyword then when you press the 'go' button the data in the mysql database will be shown in the listview. im using mysql and vb .net.i've made the table with sample records in it, the problem is i don't know how to call it to the listview
View 2 Replieshow to input data in mysql, different tables with one query?is it possible to do in gridview in vb.net 2008?
View 4 Replieshow to get 1 Thing from a internal DB but. i use a external DB to show the online games. But now the other players must see a list of online games.
vb.net
Dim conn As MySqlConnection
'connect to DB
[Code].....
I have a basic calendar schedule i want to loop through and then do some checks. My first data reader works fine. But as soon as i put in the second data reader it does not finish.Here is my code
Dim mycommand As New MySqlCommand
Dim mycommand2 As New MySqlCommand
Dim myData As New DataTable[code].....
Basically the above code looks up distinct calendar entries in the database.i then loop through the entries and put the items in a list view.The code above will list about 1600 rows.in the above code if i uncomment the 2 lines the system will break It will on display one line of code. What im trying to do in the second query is to see if there are double bookings in the database.
I am trying to write a query on an .aspx webpage connected to an .aspx.vb file to access some parts information on my mysql server. Everything works fine except for one poorly named file, which keeps breaking the query. The fields name (with the table name in front) is
invf12.PRICEE(1STU_M)
Those brackets seem to be the problem. I have tried putting single quotes around them, as in
invf12.' PRICEE(1STU_M)',
I can't do anything about the fieldname. The query in total looks like this:
Protected Sub LookupPart_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LookupPart.Click
Dim strSQL As String = "SELECT invf12.ITEMCODE as Part, invf02.DESCRIPTION as Description, " + _
"SUM(invf12.QUANTITYONHAND - invf12.QUANTITYRESERVED) as Available, invf12.PRICEE(1STU_M) as Price" + vbCrLf + _
"FROM invf12, invf02" + vbCrLf + _
[Code] .....
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'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 RepliesHOW TO SEARCH or FILTER MYSQL DATA IN TEXT BOX & WILL DISPLAY TO THE LISTVIEW
View 10 Repliesi am currently working on an Application Manager that basically will free up my desktop of all my shortcuts by adding them to a program, or in my case, the listview object. Basically, so far i have set up a toolbar on top with a few options that will add listview objects, listview groups, remove those, and some other help and support things.
What i want to do is allow the user to add a listview object, which will be an application shortcut- they can choose the name, the icon, descriptions, whatever. (In essence, i am basically moving the desktop style of shortcuts into an application, where you can categorize and organize these shortcuts).
The questions i have are: 1. Is the listview object a good option for what i am trying to accomplish? 2. I saw that you can import imagelists, but how can i incorporate that to include icon pictures selected when a user adds an application? 3. How do you save listview data? 4. Anyone have a good strategy on how to approach this project? 5. Do i/Should i make an 'application' class that handles all the application information rather than using direct listview methods?
I want to save data that I have typed into a datagridview column. The datagrid view is filled from a simple query. I can save when in access but not when I want to from a screen using vb2008. hat do I need to do?
View 7 RepliesMy first thread to as for something here but i like daniweb a lot i'm trying to save data from listview to sql server[code]...
View 10 Replieshave here a code to save the data in my listview to my database but its not working.
Dim lvitem
Dim iCount As Integer
Dim iLoop As Integer
[code].....
I have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
View 1 RepliesI have a Listview with 5 columns. It display data taken from 2 textbox, 1 combobox, 1 datetimepicker and auto generated number. I want to save all these data to a database. While trying with my code I was getting some errors. I add my whole project here . Below is my code -
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
For x As Integer = 0 To ListView1.Items.Count - 1
CMD.Connection = CN
CMD.CommandText = "INSERT INTO SaveData (CatID, Item, SubItem, Date, Amount) " + _
[Code]...
i'm using the below code to insert data from listview to sql table
but the problem is that i won't data duplicate i try to use trim but not works
can some one help to insert new data only if it's exist
and sure if not will add nothing and i wish some one can help most of time no one reply here i dunno why
I have a question because in my I.O.File. I use this to save the data in the listview in a c: est.txt but the problem is that it only save one data and every time I click the save the previous data that I save is deleted and it change the new one that I save. And also when I click the remove in the listview it will also delete the data that save in the c: est.txt and the format should like this
First name | lastname | address |
rae alanah new york
john smith los angeles
Here the code that I did...
Dim myFile As String = "C: est.txt" '//file location
System.IO.File.WriteAllText(myFile, TextBox1.Text & " " & ComboBox1.Text & " " & TextBox4.Text & " " & ComboBox2.Text & " " & TextBox3.Text & " " & TextBox2.Text & " " & TextBox5.Text)
Or you can also create new code base on ur understanding. This is the first time I use the I.O file or file stream in vb.net because my crystal report does not detect my database that's why I need to do this.
Below is a project that I am creating and with it is a listview table with name and telephone number I can add and remove contacts no problem that part is solved
What I am trying to solve the problem to is how to save that data once the form is closed and be at the same point when I close the form'[code...]
[code]the bold part must be changed cause everytime i open the saved file, word success is the data in there.
View 3 Repliesi already know how to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet.[code]
View 1 Replieshow to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet.
this is my code for saving
Public Sub saveExcelFile(ByVal FileName As String)
Dim xls As New Excel.Application
Dim sheet As Excel.Worksheet
[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 Repliesi am creating a web browser using microsoft vb.net 2008 and i want to save all images only displaying on any web page in my browser. i have added check box to save images. browser.PNG when i click on check box , the browser will prompt to save only images files on web page.
View 9 RepliesIf I run a MySQL query at the same time I have a timer going, the timer lags, even though the query is on a seperate form. My computer has 8GB of RAM, so I doubt that that's the issue. Does VB stop the timer to run the query intentionally? Is there a way to prevent the timer from stopping/ lagging?
View 10 RepliesI'm trying to run a MySQL Query, but I keep getting a syntax error for this.[code]...
View 3 RepliesMy problem is, when I query by a usual ID, like number with no segments = 1234567890, it works nicely.
But I need to query by some kind of segmented values or ID as = 123-4567-890, when I try by 123-4567-890 this id it does not query anything in mysql although in the database this 123-4567-890 ID is present.
So what is the possible solution to search by segmented value in mysql in VB.NET Here is below, my trying codes in vb
[Code]...