I just discovered that ODBC and OLEDB drivers I need to use do not support Access nested queryDefs. The database I was given is full of many layers of nested queryDefs. Is there any way I can build the tables in memory from simple query defs and then use those tables in subsequent querys?
View 8 RepliesI'm having a hard time joining 2 datatables and have the joined datatable as result. First datatable (labels) holds data including a printerid. Second datatable (printers) holds printer references (id > unc). I would like to have as endresult (joined) a datatable with all data from the first datatable with the field (unc) of the second datatable. [Code]
View 3 RepliesI m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
I'm trying to filter my access database and when I "search" by name, it works, but when I search by policy number it doesn't seem to work.
Here's my code:
If RadioButton3.Checked = True Then
Form3.Show()
Me.Close()
[CODE]...
i want to filter date and also time (shortime) for example if Datum.hour="8:15" andalso Datum.day of week "Saturday"or "Monday" now i can only filter date ... this is my filterline objbindingsource.Filter = "Datum > = '" & Dtp1.Value.Date & "'"
View 5 RepliesIn VB 2005, I am calling a C++ DLL function that returns the address in memory and size in bytes of a jpeg image. How can I load that jpeg image directly from memory into a picture box in my VB form? I cannot afford to save it to disk first.
View 10 RepliesIm getting a problem with one of my programs I have made in visual basic.NET where it gives me a memory error when i debug the program in the IDE. the exact error is this: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt". My program basically has a few forms with text fields on that get their text values from an access database on the same hard drive. Im wondering if im doing something wrong because my program just seems to eat up memory whenever it does anything. For example I have one form that has a combobox on it and when you change the drop down list selection it retreives a few strings from the database and puts them into the relevant text boxes, if you keep changing the selection then the memory usage (in task manager) just keeps going up and up. occasionally I get the error mentioned above when debugging but in my built version of the program it throws an exception everytime the memory usage gets past 49K.
Also I noticed when debugging in the "immediate window" frame I get the following message often:A first chance exception of type 'System. Invalid OperationException' occurred in System.Data.dll...Do I need to somehow be "releasing" the memory that is used to gather data once it becomes redundant?
I am using the following code
This error occurs :
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Public Class FormRegEnumValue
[CODE]......................
QuoteSystem.AccessViolationException was unhandled Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt." Source="System.Windows.Forms"
Im designing a web browser and i continue to receive this error after going to about 3 websites it crashes with that error.
I have a BackgroundWorker object that I instantiated to perform a DB process on a background thread ansynchronously. I have event handlers for DoWork and RunWorkerCompleted. I can tell that the BackgroundWorker is disposing of itself because I added a message box into the Disposed event handler.Is it necessary to detach the event handlers to ensure that the memory is cleaned up and that there are not memory leaks?
View 1 RepliesI've noticed that every time I start a new thread in my program, the memory usage jumps about 1000k and it never goes back down. I have ensured that the thread is no longer running, and only one instance of my worker thread is ever running at a time. I am using ThreadPool.QueueUserWorkItem and ASyncOperation to get stuff done. The program starts using a Sub Main in a module that uses STAThread; I read that using STAThread instead of MTAThread makes it impossible for the Garbage Collector to get in and consider objects for garbage collection. However, when I change the STAThread to an MTAThread, the WebBrowser control in my frmMain cannot be instantiated.
I get this exception:
Code: An unhandled exception of type 'System.Threading.ThreadStateException' occurred in System.Windows.Forms.dll
Additional information: ActiveX control '8856f961-340a-11d0-a96b-00c04fd705a2' cannot be instantiated because the current thread is not in a single-threaded apartment. I do threading with the WebBrowser control, so will using MTAThread fix my problem? If so, how should I partition my code so that the WebBrowser control won't be affected by the above exception? I call the thread repeatedly with a timer (although only one instance ever runs at a time), and my program's memory usage starts at about 5000k and can jump to 300,000k+ depending on many times the thread needs to be called.
I cannot use Visual Basic 2008 at all. When I go to "new project" and choose "Windows Form Application" I get this error.I have tried multiple uninstall/reinstall with no result.A microsoft reply to this suggested that I needed: " .NET Framework 2.0 Service Pack 1 " I checked, and I did not have the .netframework 2.0 service Pack 1.
When I tried to download and install the above from Microsoft.com, the istaller said that "it was not allowsed" and I was not able to install the service pack 1.
I tried Uninstalling net framework 3.5, 3.0, 2.0 and then reinstalling .netframework 2.0 sevice pack 1; then reinstalling Visual basic 2008 express edition. At the reinstall of Visual basic 2008, .netframework 2.0 sevice pack 1 is unistalled by .net framework service pack 2.When I check the foruims for simiar problems, the formus are mostly for Visual basic 5.0, or other programs that I do not have.
Here is the programs I have installed:
Operating system: Windows XP
Microsoft .net framework 1.1
Microsoft .NET framwork 1.1 Hotfix(KB928366)
Microsoft .Net Framework 2.0 Service Pack 2
[code]....
All the security updates and hotfixes for Widows XP.
The follow code can be called about 6K times on the server it is run on then gets a out of memory error in the last catch statement. I don't see what is wrong with the code, it works well up until the out of memory..
Public Function AddUserToGroup(ByVal sSamAccountName As String, ByVal sGroupName As String) As Boolean
Try
Dim returnStatus As Boolean = True[code]......
I have two forms, Form1 and Form2. Form2 has a button to show OpenFileDialog. I call Form2 from Form1 by a button. My startUp Form is Form1. When i start debugging, i press my Form1's button to show my Form2, it shows, but when i click On Form2's Button to show OpenFileDialog it is giving me exception that
"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
When i set my startup Form to Form2 and click Form2's Button to show OpenFileDialog then it shows!
I want to filter a text in all columns in a datagridview. So I use Like % in the filter text. However, I found that the text(strFilter in my code) may contain % sometimes. So it have a syntax error. How can I use filter with like clause when the filter text contains %?
Private Sub PassFilter(ByRef dataTable As DataTable, ByVal strFilter As String)
Try
Dim dataview As DataView = dataTable.DefaultView
[Code].....
i want to filter row and put it in a textbox and filter another row in another text box vb.
ex.
ID--------- Date -------- msg_num ------------ Message <<
10001 -- 01/01/2012 ------ msg1 ------------- Blah! Blah![code].....
I have a new problem with this same Form Printing project and I get exactly the same exception but from the different point of code:
line 538: d.PrintFunction(c, typePrint, mp, x, y, extendedHeight, ScanForChildControls)
The exception type is System.AccessViolationException and it says (after I translate it from my own language in which the message is given in my pc, into English):"Protected memory was tried to be read or written. This often indicates that the other memory is damaged"
I am getting the following error: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt". i am using interop service.
View 2 RepliesI'm trying to the contents of a datatable to a datatable thats allready in my form using the openfiledialog.[code]...
View 4 RepliesI'm trying to create a program that will merge two data tables (one from a database on a network drive, the other is found in a database on the local machine). Each datatable is identical in structure, only (maybe) differs in content. The structure has a primary key, dateCreated, and dateLastEdited fields (plus other fields). I would like to merge down from the network to the local database. If the primary key does not exist on the local db but does on the network, copy from the network db to the local table. If it does exist, check the dateLastEdited column and copy the latest row to the local table.
How would i set up the code to do this? Any assistance would be great.
How to intersect two dataTables in vb.net 2.0? I want to get common rows in two datatables and add it in third datatable.
View 1 RepliesI need to marge two datatables with condition. I have a datatable where the data comes from a local XML Database and another datatable where the data comes from a remote SQL Server. If any update made in the remote datatable I need to update/merge with the local datatable. Here is what I have so far:
Public Sub MargeTwoTable()
Dim SQL As String = ""
Dim RemoteTable As New DataTable
Dim LocalTable As DataTable
[code]....
In this code data comes from the remote database which updates a date getter then the local database . Both tables have "ID" as the primary key. The code is working well, but the problem is that when more than 1000 records are updated this function takes too long using loops.
I have two datatables which I intends to bind them to Gridview. But I need bit of the first dt and bit from second dt.
Second table has only one row that represents to every row in the same column in first table.
There is no primary key or relationship between two tables though.
For example,
I tried datatable.merge though. Didn't produce the last table i want.
I have a Main Table that contains all the distinct values in a DataTable.DataColumn. also have a Child Table that contains distinct values created by the user.I want to merge the Child Table DataRows that match on the Value column with theMain Table DataRows to create the New Table (shown below).I want to preserve the values in the Selected column of the Child Table.Here is my problem, if I use the DataTable.Merge method the DataRow that contains "888" in the Child Table is added to the New Table, but it doesn't contain a RowState = Added, thus I can't filter for added rows to remove them.
View 4 RepliesI am using VB Express 2008 and SQL Server Express 2008.I have one DataGridView on a Windows Form, which I am attempting to populate from two datatables. Both tables are identical in structure, but with data from two different dates. The respective SELECT statements are identical, except for the date; one calls for yesterday, one for today. I need a seperate Sum column from each table.I've tried to JOIN, UNION, and MERGE the tables, but that gives me all the data consecutively and I saw no way to seperate the days. I'm able to add DataColumns, and sum the fields with an expression, but is it possible to create DGV columns and bind them to the seperate DataTable columns? [code]
View 6 RepliesI am stuck with an issue.I have two datatables, with the same table structure, i need to select data from table1 such that the records arent existing in table2is it possible to do this in vb.net? if yes then how?
Table1(AAno,Agencyname,location)
Table2(AAno,Agencyname,location)
Criteria:Select AAno,Agencyname,location from table1,table2 where table1.AAno<>table2.AAno
I'm stumped trying to do an equivalent SQL statement in VB 2010 working with two DataTables, & am hoping someone could point me in the right dirction.I currently have two data tables with three fields each :- A, B, C. The data in field A is the same in both tables & could be used to join the two tables.How could I input data into a third data table having data from both primary tables ? Something along the lines of the following SQL code.[code]
View 3 RepliesI have a datatable with a yes/no checkbox in it and when I filter my datasource it loads form2. Right now I'm using this code to have a label's color as green if it's checked and red if it isn't:
Private Sub Customers2BindingSource_CurrentChanged(sender As Object, e As System.EventArgs) Handles Customers2BindingSource.CurrentChanged
If ActiveCheckBox.Checked = True Then
Label1.Text = "Active"
[code].....
That works when I do something like bindingsource.movenext because it's in the bindingsource_currentchanged event, but when I try adding that to the form_load it's automatically set to Inactive, color red. I figured it's because is set to checked = false, but what event do I use to make this work when the form loads?
What's the value of a checked checkbox for the update/delete/insert commands? Like dates are DateDateTimePicker.Value.Date. Is it something like this?
.AddWithValue("@Active", ActiveCheckBox.Checked)
I don't use checkboxes to often.
This code was put together for a one time run. It's purpose is to count all the pages in a group of images. After about 6000 of 1,250,000 images in ##X it throws an "out of memory" error. Besides it being thrown together for a one time run does anybody see anything obvious that could be causing the error?
CODE: