I'm working with datatable with a big amount of data. On the way of converting the data to the final form I need I would like to get rid of the datatables that I don't need anymore. This is mainly because I have three really big datatable that pumps up the programs memory usage close to the limit. (Out of Memory Exception).So is there any way for releasing this memory used by the datatable that I don't need anymore?
View 9 RepliesI have a little problem with my program, Boot Animation Previewer.Firstly, it loads the .zip file and extracts the boot animation in a folder called Temp. If there are existing files in the Temp folder it deletes them. But, once the boot animation is previewed, you can't select another boot animation, until you restart the application, because it gives an error, saying that the program can't delete the images, because the process is using them
View 2 RepliesFirstly, it loads the .zip file and extracts the boot animation in a folder called Temp. If there are existing files in the Temp folder it deletes them. But, once the boot animation is previewed, you can't select another boot animation, until you restart the application, because it gives an error, saying that the program can't delete the images, because the process is using them.
My question is: how to stop using the images? I've tried to dispose the form that loads the .zip file, but with no success.
I have created a program that opens and closes web browser controls many times. I need a way to release as much memory as I can but it's difficult as even calling the dispose method doesn't seem to work. Do I need to do anything else to the web browser
View 5 RepliesI have created a program that opens and closes web browser controls many times. I need a way to release as much memory as I can but it's difficult as even calling the dispose method doesn't seem to work. Do I need to do anything else to the web browser control to fully release it's resources?
View 4 RepliesI'm trying to make sure that I don't leave any loose ends open in my application and am concerned about a few but might get my answer from this one. I've "overriden" some functions so that way I can try and keep all the resources as clean and free as possible. So in this instance, I have a function called ExecuteReader which returns a DbDataReader as normal, but all I had to pass to it was a SQL string rather than recreating a DbCommand every time. I want to make sure that even though I'm unable to call dbCommand.Dispose() that it is actually doing so.
[code...]
In here, I set the _dbReader to what I'd get from the function and eventually I close the _dbReader. I do not close the connection as I don't open it each time I make a query. This is a SQLite database that only one user will be using at a time (small application with very very very little likeliness it will grow) so I didn't think it necessary to close and open the connection all the time. Maybe I'm wrong, not sure. Using it this way though, it is potentially ok for cleaning resources?
i'm unable to debug my project that i made. i save it and everything, but it just won't playit says Warning 1 Could not find type 'WindowsApplication1.My.Resources.Resources, Time table'. Please make sure that the assembly that contains this type is referenced. If this type is a part of your development project, make sure that the project has been successfully built. C:SchoolIPTTime table, using 2 loopsTime table, using 2 loopsForm1.Designer.vb 123 0 now when i open it up and try to debug it , it comes up with an error, i even try referencing it but it does nothing ,
View 2 Replieserror: the item "objdebugassociateassist.frmdbsetup.resources" was specified more than once in the "resourceS" parameter. duplicate items are not support by the "resources" parameter.
View 1 RepliesI am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.
View 6 RepliesI'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data
load the contents of a query from a dataTable Adapter into a datatable?
View 2 RepliesI am trying to add NewRow to the database by using datatable in dataset, but before I do that I want to make sure that row is not already there. I create new row for the datatable I am working with, fill it with information. I fill datatable with the row from database that has the same primary key as my NewRow by using tableadapter.fill method, but when I do that my NewRow that was never added to the datatable is filled with information from database(and not information that I assigned to it). I count rows in my datatable before I fill it and it's 0, so why is my NewRow affected by Fill command? (I am using VB.NET 2005 Framework 2.0)
[Code]....
I don't understand. Till now this little app was working ok. Error1 The item "objReleaseRadni_nalozi.GlavnaForm.resources" was specified more than once in the "Resources" parameter. Duplicate items are not supported by the "Resources" parameter.Radni nalozi What gives?
View 4 RepliesWhat is the 'proper way' of giving my application to people?
Ideally I just want to zip up the minimal amount of files and for people to put this in a folder of their choice and just run it.
I've noticed from playing with a "Publish" I end up with a "setup.exe" and also a "Application Files" folder.
Within that folder are the necessary files (a DLL and a .EXE) to run my application. Can I just supply those two files out to people?
I'm trying to save rtf files in this manner to bin (rtb9 is the rtf control and there is button when clicked opens it):
Private Sub tempSave()
f My.Settings.rtbx = "rtb01" Then
[code].....
Currently we are using the Microsoft data access library Writen with a Oracle data provider for the framework 1.1. My customer has mandated that we upgrade from Oracle 10G to 11G release 2. 11G requires the .net framework 2.0 Is there a way to use the new Oracle data provider 11g release 2 with the older frame work. I have looked at/attempted changing the policy for oracle in the Windows assembly but my understanding is because its a third party DLL, I cannot.
View 4 Repliesin main form, when a button is clicked, it opens a new form which has a webbrowser. users can use it to browser some sites. if the user closed this form, it goes back to the main form. and they can click button to open the browser form again.
I noticed that one thing. if the browser form is opened, it uses much memory (which is normal because of the site it browses). however, after the browser form is closed, the memory is not released.
In the browser form, when it is closing, the webbrowser is disposed and dereferenced. and no other part uses much memory in the form. GC is called too. what else should I do to release all memory the browser form uses?
now, it is like once the browser form is opened once, the memory usage never goes down even the form is closed.
i am developing digital album software. using Photoshop.i have an doubt...
Class
Private Appref as Photoshop.Application
Private Sub DocInfo()
[code].....
I'm trying to copy one row from DataTable to another, I looked almost everywhere and I can't find a reason why this is happening, I'm using ImportRow and still the New DataTable is empty. Here's one of the answers similar I found and It's still not working!:
Dim newTable As New DataTable
Dim dsFrom As New DataTable
For Each DBShoes In list
Dim iShoeID As Integer
[code]....
how to copy data from datatable to table in dataset i ry this but its readonly property
ds.datatable1=newdt.copy
I have an asp.net application where I have a datatable ("DataTableA") that returns just one column ("ProductID").
I want to read each row of "ProductID", process some business logic, then copy both those columns (ProductID & ProductIDBusinessLogicValue) to DataTableB. This DataTableB is then displayed on the asp.net page.
What would bhe the best way to read each row of DataTableA ?
I am updating a data table (dt_report_crypt) from an encrypted csv file in the code below:I decrypt the colums and update the same dreport_crypt, such that it will contain de-crypted data.This part is working wellI however need to use this de-crypted datatable as a data source to update a second table(dt_report), using the sql SELECT command to filter relevant data,
Dim dt_report As DataTable
Dim dt_report_crypt As DataTable
Using cn As
[code].....
I have a select statement and it will go to a datatable object, I would like to do the following
textbox1.text=datatable(first field value)
textbox2.text=datatable(second field value)
textbox3.text=datatable(third field value)