Search:
Type: Posts; User: selfay
Search:
Search took 0.03 seconds.
-
hmm, it must be creating object problem. But even I manually shut the excel window in task bar. I notice the process are still in background process. If I use ctrl+alt+del, then can manually kill the...
-
Hi jmcilhinney,
You are right. I try to close it by its name.
If SourceExcel IsNot Nothing Then
SourceExcel.Quit()
End If
-
Hi, I have several excel in task manager. Some are in apps. Some are in background processes. The background ones are created by setting the windowstyle hidden in my code. I want to know how to close...
-
-
I have a WPF datagird which is bound to a datatable. After I changed the value of certain cell, like the first row, column qty from 1 to 2. The same row will not update if I just click other cell in...
-
It is simple in Winform. How to simply do it in WPF?
For Each DRow As DataGridViewRow In Datagrid1.SelectedRows
Dim ClnRow As DataGridViewRow = CType(DRow.Clone(), DataGridViewRow)
For i...
-
I can load the data from data table to datagrid. But my two data tables can change from time to time, and they have parent and child relationship. I also need filter the parent table when I input in...
-
Hi jmcilhinney, sorry that I could not ask the question clearly.
I have two datagrids which need display two datatables with relationship. The datatables are not fixed. I also have a search...
-
I need display parent and child or Master and detail table in two datagrids. The source table is not fixed. In winform, I added two databindings and used below method. However, there is no...
-
Awesome, it works! I am always curious how to control datagridview.
-
No, it couldn't. It is the same as DataGridView1.DataSource = Nothing. When you click the button again, you can see CNY and USD are still there.
-
I use OleDbConnection and OleDbDataAdapter to get data from an excel file. Then display the data in Datagridview. However, I found the Dategridview header could not update accordingly but just added...
-
finally, i solved it by myself. I am still testing the code, but put my code here in case other people need it.
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
...
-
I need import a text file to excel. The text file has more than 100,000 rows and several columns. If I read line by line, it takes really a long time. However, if I import the text directly in excel,...
-
Thanks, jmcilhinney.
The last question is the datagridview still display nothing if there are some rows in Child table which have no relation with parent table. Do you know how to fix it? Just...
-
Hi jmcilhinney,
Thanks for your help. The problem is almost solved.
I noticed the problem may be caused by the source file. If there is one data in child table which does not have relationship...
-
136771
Hi jmcilhinney,
please change test.txt to test.xlsx. I could not upload the xlsx directly.
I changed the filter, but it did not work. The problem is the datagridview load nothing at...
-
Hi jmcilhinney,
My code is indicate below.
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.Odbc
Imports System.Data.DataTable
-
Hi jmcilhinney,
Your code works well. But I am confused that why I still failed if I use below code to get parent datable and child datatable rather than use your GetChildTable() and get...
-
Thanks. I wrap the code as below
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.Odbc
Imports System.Data.DataTable
Imports Excel = Microsoft.Office.Interop.Excel
-
I have a search textbox, two datagridviews as master/detail. I want to filter master when I input in search textbox.
There are two questions which I could not figure out for the whole week.
1. The...
|
Click Here to Expand Forum to Full Width
|