I want to use a background worker to reduce a form's loading time. I have already created this and reduced the loading time. But this time, something didn't work right:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Cursor = Cursors.WaitCursor
BackgroundWorkerMain.RunWorkerAsync()
End Sub
[Code]...
When I declare two datatables and fill them both from a datatable returned by a function in class, that when i filter the one it seems to filter the other aswell?
For example:
I declare the datatable and initiate my class:
Dim DatatableOne As New Datatable
Dim DatatableTwo As New Datatable
Dim MyClass As New MyClass
I then call the function that returns a datatable and apply it to datatable1 and 2 Then fill two DataGrids with the table:
DatatableOne = MyClass.GetTable()
DatatableTwo = MyClass.GetTable()
DatatableOne.DefaultView.RowFilter = "Name = 'Tom'"
[CODE]...
For some reason i don't understand but both grids end up with the filtered data?
while this is first time I need to use some kind of database and I think that database is the way to go here while...
I need 'datatable's' that will be filled by user run time in a next way:
-Folder (fixed)
---User 1
[code].....
I'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 would like the main form I am designing in VB.net to appear as quickly as possible. As a result I don't want to fill a datatable in the load event but instead fill it as soon as the form appears, in the background.Then when a user clicks the button a listbox can quickly be populated.
With this in mind I called a function to fill the datable from the _Shown event. The trouble is that the form freezes until the query executes, making the process pointless for my needs.
Does anyone know how to keep the form active while the datatable fills silently in the background?
I'm using this code to set a picture as the desktop background:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
SetDesktopWallpaper("C:\image.jpg")
End Sub
Private Shared Sub SetDesktopWallpaper(ByVal fileName As String)
[Code] .....
It works well, except the wallpaper is always centered. How can I have the ability to choose Fill, tile or center with separate buttons?
I have an image saved in a bitmap (bmp) as a result of some graphic manipulation. Part of it is transparent. And I can save it to a file in bmp, jpg, png, tif with no problem. I also want to fill the image background with a color of choice, which is saved in a PictureBox control (ColorBox1). I suppose I need to draw a rectangle like[code]...
View 2 RepliesI'm trying to fill a pdf with iTextsharp and save a new file with a different name to a directory. I'm not getting any errors when I run it, nor do I see anything in the code as an error. But I'm missing something. Maybe I'm not writing the file to the directory correctly. I removed several af.SetField's for brevity.
Public Sub fill_form(ByVal Source As Object, ByVal e As EventArgs)
Dim newFile As String = "D:\Inetpub\wwwroot\pdfs\" + data1.Text + ".pdf"
Dim ps As PdfStamper = Nothing
Try
[code].....
VB
RichTextBox1.SaveFile(FileName , RichTextBoxStreamType.RichText)
This is the way i am saving my rtb files , But it don't save the background color , can anyone tell me of anyway to save the background color or whatever content is on the rtb.
I made a simple code that changes the background color for my program and then save it. But for some reason, it will not work if the RGB code has 255 in it.
Public Class Form1
Dim R, G, B As Integer
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
R = TextBoxR.Text
[CODE]........................
I am working on an virtual operating system. And I want the user to be able to change background, and at the same time save it! So, the next time he opens the application, the background is saved and changed.
I know that I have do this through project > settings, but I don't know how to program it. I have managed to allow the user to change background, but dont how to save it. Could anyone solve this little problem for me?
I'm making a program and in which the user can select a background image from their computer, but I have not found a way to save the picture to my.settings or my.resources
View 3 RepliesBackground of form: black
background of char, bombs and shrooms: transparent
picbox behind char, bombs and shrooms is regular (marioland)
How can i fix it so the transparent parts dont see form as background but marioland as background?
I am using query from a SQLite database as the AutocompleteCustomSource for a ComboBox. Also, I want to load data in separate thread. My LoadData method works fine when called directly, but it fails when it is called from the BackgroundWorker thread. When it is called from the background thread, it throws a Specified cast is not valid exception on the csearch.AutoCompleteCustomSource.Add(hh("Taj")) line. Below is my code:
Sub LoadData()
Dim connetionString As String
Dim cnn As SQLiteConnection
[Code].....
I just want to display data of a single column from an oracle table into a datagridview or a listbox for readonly with no requirements to make changes to it. Simply display the information.What is the best way forward... To used DATAADAPTER or DATAREADER.s DATAGRIDVIEW SLOWER TO FILL THAN a LISTBOX.i am using the following code to fill datatgridview but for some odd reasons at time it is slow to display the data. I want to use listbox instead
Dim ds As New DataSet
Dim adp As OracleDataAdapter
adp = New OracleDataAdapter("select customer_name from customers")
[code].....
I'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.
I'm making a front end to dvdauthor.I have a picturebox which holds the menu background. In order to draw a textbutton on the background image I store the image in a hidden picturebox. So the text doesn't get drawn to the visible background.
Dim ctl As Control
For Each c As Control In pbMenu1.Controls
If c.GetType() Is GetType(TextBtn) Then[code]...
This works the first time. But if I hit save again it writes the text to the background image on pbMenu1.
I've seen several posts on the subject, but none seem to answer this particular dilemma. I have two datatables that I obtained by querying two separate servers.[code]
View 7 RepliesI am trying to compare two datatables and generate a resultant datatable of rows that do not match based on customer number. The main table "Customers" contains all customers that have been placed in our system. I am trying to generate a table of customers, "dtResults," that we have not ever generated an invoice from a table called "CurrentCust".I would like someone to look at the attached code and see how I can handle the 'InvalidCastException was unhandled', 'Unable to cast object of type 'System.String' to type 'CustomerDataTable' error. Error occurs at line 43.
1
Option Explicit On
2
Option Strict Off
[code]....
using VB.net 2010 using DataAdapter and DataTables I'm trying to merge two datatables together and update a database with the results if I use the following code it works (though not ideal):
For Each tRow As DataRow In excelDt.Rows
accessDt.Rows.Add(tRow.Item(0))
Next
however if I use the following I don't get a error, it just doesn't update:
accessDt.Merge(excelDt)
accessDt.AcceptChanges()
For ease here I named the DataTables to describe where they are coming from. accessDt is a empty DataTable (to start) from a Temp Access database table with 1 or more columns in it and excelDt is a DataTable created from a Excel Worksheet with the same columns (same order as well) as the Access Table. Basically just trying to get the data from Excel into Access. They are using the same update command just swapping out which method is commented out. I have checked and accessDt does have the data in it before the Update is called using both methods.
I am in the process of revising code to use TVP to send data from our VB.NET app to the SQL 2008 DB and try to keep all the writes atomic.[url]...
I am in the process of creating all the in-code datatables to be sent to the SQL stored procedure
However, I will have to create these datatables and datacolumns (then add the columns to the tables) repeatedly for multiple tables.