I have a varbinary(MAX) field in my MS SQL Server database. The SqlDataAdapter.Fill() method takes a relatively long time (in LAN). I want to show progress for the SqlDataAdapter.Fill() method itself, using a ProgressBar.
Note: I know how to deal with UI controls and how to implement multi-threading.
I'm have a very peculiar error. I have a query from a VB.NET app that hits a Oracle instance. I retrieve that data into a dataset, then dump the data into a spreadsheet. Always for the same row and same column i retriving an error:
System.OutOfMemoryException: Not enough storage is available to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY) at Microsoft.VisualBasic.CompilerServices.LastBinding.InternalLateSet(Object, Type& objType, String name, Objectp[ args, String[] paramnames, Boolean OptimisticSet, CallType UseCall Type
The column is CLOB I am doing: DBMS_LOB.substr(myfield, 4000, 1). In that field in database : "myfield" are stored descriptions of something but it's always error on that field, i checked in dataset:
Old TT 767611 closed by mistake by IOAA. ret still active. So team. Please find the old re updates:
CODE:
What could i do? mayby that's why the record starts with
I am using that code for filling the excel:
CODE:
I am having difficulties with Filling a dataset. It seems to be automatically assigning a datatype to the column based off of the first field of data it finds in that column. The column sometimes contains an integer, but it may also contain letters and numbers. If the first field is an integer, it says the fields in the column that contain a letter are DBNull. I'd like for the entire dataset to be formatted as a string/text type since I do not know what the values will be that I'm importing 100% of the time. How do I tell the dataset to expect a certain datatype for all columns and rows i'm going to import?
View 19 RepliesI am trying to fill a combo box using a dataset and data adapt. I am struggling too work out how to do it. I thought it would have been easy but I was wrong. i can set the text to read the first line of the colomn but nothing else. I was wondering if anyone could help me out with what I have to do. I think I have to increment inc and add a line underneath but I don't know how to do that
comboMaps.Text = datSet.Tables("TheLastShot").Rows(inc).Item("Maps")
I'm having trouble filling a ComboBox from a dataset. When the program runs, the combobox has the correct number of lines, but they all appear as System.Data.DataRowView.[code]
View 1 Replies ok normally when i fill data i do it this way adapter.Fill(dataset, "table1") However instead of using Strings, i prefer using enums so for example i have:
public enum Tables
T1
T2
end Enum
but since adapter.fill does not provide an "integer" argument when i add i had to convert it to a string as such adapter.Fill(dataset, cstr(Tables.T1)). i find this "dirty" and was wondering if there is a better fix
The SQL string won't return data from Access. I've tested this exact SQL String in Access and it works fine.First of all, Am I getting a SQL query from Access in the proper manner?Second... should I be using a stored procedure for this? Or is making a query from tables like this a good practice? Third, if I'm doing it right, why won't Access query return and fill my dataset?These are the results I'm getting.
Connection State = 1
Tables in Dataset = 0
Where am I going wrong?
SQL:
SELECT PageSetupData.Size, PageSetupData.Category,
PrinterList.Location, PageSetupData.isPlotter, PrinterList.LocationSuffix,
PaperSizeData.PrinterName, PrinterList.HasAltPrinter, PageSetupData.SetupTitle,
[code]....
[code]when I run my program and press this button Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles exceptionsButton.Click..I have my date range within a time that I know that my dataset should produce a result, but when I put a line break in my code here: adapter.Fill(ds)and look at it in debug, I show a table value of 0. If I run the same query that I have to produce these results in sql analyser, I see 1 result. Can someone see why my query on my form produces a different result than the sql analyser does? [code]I can also verify that the variables are passing the correct values. Can anyone please assist as to why this isnt working?
View 1 RepliesI have the following
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[Code]......
I have the following code:
Code:
Imports System.Data.SqlClient
Public Class Main[code]....
and when I run my program, I have my date range within a time that I know that my dataset should produce a result, but when I put a line break in my code here:
Code:
adapter.Fill(ds)
and look at it in debug, I show a table value of 0. If I run the same query that I have to produce these results in sql analyser, I see 1 result. Can someone see why my query on my form produces a different result than the sql analyser does? Also here is my schema for my two tables:
Exceptions
employeenumbervarcharno 50 yesnonoSQL_Latin1_General_CP1_CI_AS
exceptiondatedatetime no8 yes(n/a)(n/a)NULL[code]......
I have a dataset in my application that I fill using tableadapters like this:
Class Form1:
sub new()
Database = new Database
end sub
Class Database:
sub new()
tblLalalalaTableAdapter.Fill(DataSet.tblLalalala)
end sub
I am told it is too early to call the tableadapter.fill method inside the constructor. If the database is unavailable now, the application won't even start. It will just kinda crash. What is the proper way to do this? When should I call the tableadapter.fill methods?
i would like to know something more relating to parameters. i have always been adviced to use parameters but i am bit confused as to how to use parameters while filling a dataset like if i am using a oledbcommand i can always use paramters but how do i parameterise the following :
dgMastDet.DataSource = Nothing
myBindingPenBase = Nothing
txtCd.DataBindings.Clear()
[code]....
i am using the above code to filter a list in the dgv as a help dialog for the selection of a master.my prob. is the now xFilter is to be typed in a regional language. so it is bound to have an ' as a character at some point or the other and if that comes in the char. then it will b giving me an error.. so how do i use it as a parameter ?
I am running a test program for VB.NET, and it will simply crunch a million numbers in for loop. I've linked a variable implying the progress of the for loop with the progress bar, but it seems that when I run the program, the progress bar does not update itself. The bar itself has only value 0-100 as input (as stated in the document) and I've tested it without using the for loop, and it works.
View 2 Repliesbelow is my code:
myCommand = New SqlCommand("SELECT VisitorID, VisitorName, Skill FROM tblVisitor LEFT JOIN tblSkill ON tblVisitor.SkillID = tblSkill.SkillID", myConnection)
myAdapter = New SqlDataAdapter(myCommand)[code]....
then it catch an error as Incorrect Syntax near". which it points to myAdapter.Fill(myDataSet, "tblVisitor") not the Select command.
I recently updated an app that I wrote to allow the clients to run the app in read only mode disconnected from the database by serializing the typed dataset, and when they are offsite/offline instead of connecting to the database the serialized dataset is loaded. This has been working great and then I hit a major snag.
A majority of the graphs and reports are based on sql views that are typed views in the dataset. Of course offlline the tableadapters cannot run the sql views.
Does anyone know a way to run/fill the view with the already loaded dataset? I can add rows clientside so I'm inclined to believe there must be some way to fill the view clientside but I've been at this for a number of hours now and not making any real progress.
When I use a command such as:
Me
.TableAdapter.Fill(Me.SomeDataSet.Table)
I am going out to the database, gathering the requested information and filling the dataset. Therefore, everytime I add a query to a table adapter, it is also going to the database to get the information. So, my question is, how do I fill a table in a data set with all the records in the database table and then, filter the information I've already collected in the dataset without going back out to the database again?
I am designing a form to Enter new City Name list where i accept following fields
CityName, District, State, Country, Pin.
because a State names and Country names can be retrived from earlier entries, i want to allow user to select desired name from a list in combo box or a list in Auto Complete Custom Source for text box, to do this i have added a Table Adapter to underlying DataSet having Query "SELECT DISTICT STATE FROM CITY ORDER BY STATE".
Now, how do i use this Table Adapter to fill the ComboBox List without binding
And also Custom Source List for TextBox.
so what I want to do should be pretty simple. I've been following the examples found here Using the BackgroundWorker Component - VBForums . I've been successful, but I'm not smart enough to put it in my project.
What I'd like to happen is this
1. I hit a button to load data from a dataset....
2. have a progress bar show until this action is complete.
The main problem is that I can't figure out how to tie the "progress bar" to the action of "pulling the dataset"
I'm sure this is a crazy question for you all, but hey...
Would I put all of the coding in the button_Click sub?
Would anyone be able to help me here please. I'm fairly new to VB.net and threading so im just trying to figure out what is happening.When I debug this I am getting the error thread operation not valid: Control 'ProgressBar1' accessed from a thread other than the thread it was created on.
I'm a little lost as to why the error is occuring or how to fix it. I've had to put the progress bar in a separate thread otherwise the GUI crashes
[Code]...
I'm trying to convert code from Delphi to .Net. I'm stuck on one line:
//Delphi code ss := Copy(ss, Length(ss), 1) + Copy(ss, 1,Length(ss) - 1); 'vb.net code ss = ss.Substring(0, ss.Length - 1) + ss.Substring(1, ss.Length - 1)
Delphi combines the two substrings, while .Net just concatenate them like a copy.
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]...