its possible to find out in a reader how much reading is left to do. My code will be below and i think it be fairly possible during a query that would be returning data but is it possible during a query designed to give data?
Public Function queryup(ByVal queryString As String, ByVal connection As MySqlConnection)
Try
Dim newQuery As String() = Split(queryString, ":")
For Each Query In newQuery
[code]....
How can I make mysql reader? That it will get charatername from row that has the username they entered.
View 2 RepliesI 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 want to launch a application called Foxit Reader pdf Reader .I know System.Diagnostics.Process.Start(path) can do it but . Requirements are Foxit Reader should be installed on machine.Now if it is installed how to serarch for the path of its Executable to provide the parameter as I can not hardcode the path for different machines.
View 3 RepliesI am having an issue with both Adobe Reader and FoxIt Reader when trying to print a PDF document. Both issues are different but a solution to either one will allow me to fix my issue.The issue I am having with Adobe Reader when trying to print using the following code is that it will not print it to the network printer I specify but just the default printer.
Dim AdobeReader As New Process
AdobeReader.StartInfo.CreateNoWindow = False
AdobeReader.StartInfo.Verb = "print"
[code].....
how would I accomplish saving a large piece of data, using the Stream Reader for the Line-by-Line, while keeping the carriage return line feeds in there?
[Code]...
im making a web browser which is intertwind in a project, but i cant get the progress bar to display the current percent of a page that is loaded, i want to have 10 segments, each standing for 10% of the total page loaded. So say a page is loaded 67%, 6 out of 10 of the segments will be shown.
View 3 RepliesI am trying to implement a BGW and want to report progress to a progress bar for my TextFieldParser program, sometimes if your opening very large files it takes a while and I would like the user to be able to see the progress and have some interaction so they know the program is still running I am a little hung up on what to in the reportprogress
I have:
worker.ReportProgress(0, myReader.ReadFields())
and its not doing anything, I didnt expect it too since ReadFields is an array
parser
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
Dim worker As System.ComponentModel.BackgroundWorker = DirectCast(sender, System.ComponentModel.BackgroundWorker)
[code]....
I copied the code here and translate the code to vb [URL]it is working fine but there is one small problem but I cannot solve? Here is my code: SyncClientVB Another Source The scenario is... the progress is reported by an event (OnCopyingFile event)
Public Sub OnCopyingFile(ByVal sender As Object, ByVal e As CopyingFileEventArgs)
If pbFileTransfer.Value <> e.PercentCopied Then
If txtCurrentFile.Text <> e.FilePath Then
txtCurrentFile.Text = e.FilePath
[code]....
The problem is that it is ok when runned but when I click the form it starts to hang but in the console... it is still continuing.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('6f5d1b01659646618ff3bdca29fb1b7f')
get the progress bar show the progress of the batchfile running in the background?
View 10 RepliesI have two forms, when the user selects a button, the second form opens and an external executable begins an automated process. The point of the second form, is to only show the current progress of the automated tasks and closes when those tasks are completed.How would I use a progress bar to show the current progress of an action on a different form without knowing how long it will take?
View 9 RepliesfrmMain - Allows user to pick process or combination of processes they want to run frmProcess - Shows progress of their selection I have three modules. Each runs a specific process. The frmMain allows the user to run any one of the three modules individually or all together in a single process (basically, runs the one after the other until done).
[Code]...
Looked through many tuts, can't find one.
View 1 RepliesI have a filesystemwatcher which place files in a queue when they are created. From the queue the files are further processed (xml into SQL database).
The mechanism works fine, but I want to add a progress bar to follow the progress of the files in the queue: processing 1 of 10......2 of 10......3 of 10 etc.For testing, I created a batch file to simulate the creation of files, so the filesystemwatcher can to his work and place the files in the queue. When I tell the batchfile to simulate the creation of 20 files, I see that the amount of files in the queue change. For example;
[code]...
In the app I'm currently making, I have two progress bars. One for current task being committed and the other is for overall progress.During runtime, I calculate how many tasks are being run and set that as the maximum. As each task completes, the progress bar is incremented by one.
I want the current task progress bar to show the progress of the current task. Some tasks can take a few minutes to complete so that progress bar works great. But, if the task is super quick, like editing registry keys, I see no progress at all.When I edit the registry, it basically goes like this:
'Edit Key
'x
'x
'x
ProgressBar1.PerformStep()[code].....
It completes so quickly that I never see the bar even move.I also have each task report its name into a label and it skips ahead so quickly that I only see the first task name and the last.Is there any way to make this do a better job at reporting the progress?
I came across a problem in my program it takes too long to calculate the values needed (about 10 sec) .But thats not the problem you don't know when the program is working or not, as it just locks up until its finshed and I view that as a problem.
I need to be able to show the progress of this .I looked at using background Workers but I get exception "Object reference not set to an instance" I believe this is because the background worker cannot write values or something ,As it works will a normal handler.
[code]...
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesWhat 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
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
SOrry for long title i've forgotten how to do this so please may i have a code im new to VB 2008
View 3 Repliesi Built A MySQL Login System Using MySQL Connector But If Other People Want To Use The Program Thay Get An Error, I Think This Is Due To Thay Do Not Have The Connector So What Should I Do, Btw Dont Say 'Tell Them To Connector'!
View 5 RepliesIm building an app to manage PSP contents, and it should connect to my MySQL server on my domain to refresh game info and ratings and so on, but I cant make it connect with MySQL Connector 6.1.
[Code]...
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 RepliesI 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 RepliesWhat i am trying to do is get my system to look into the database and recognize if the user is a admin or a user, based on that they have certain rights below is my code
Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Public Class Form3
[code]....
I'm trying to display the progress in a progress bar, my app reads a csv file before it processes it to a database.and to set the maximum property of the Progress bar i need to detect the number of lines is there a way that im not aware of other than looping the file ?
View 4 RepliesI'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 Replieserror " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
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 Replies