Search:

Type: Posts; User: selfay

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    6,197

    Re: How to kill background process

    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...
  2. Replies
    9
    Views
    6,197

    Re: How to kill background process

    Hi jmcilhinney,

    You are right. I try to close it by its name.




    If SourceExcel IsNot Nothing Then
    SourceExcel.Quit()
    End If
  3. Replies
    9
    Views
    6,197

    How to kill background process

    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...
  4. Replies
    2
    Views
    6,996

    Re: WPF Datagrid cannot refresh timely

    Thanks, I solved it.
  5. Replies
    2
    Views
    6,996

    WPF Datagrid cannot refresh timely

    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...
  6. Is there a simplest way to copy rows in one datagrid and paste it to another

    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...
  7. Replies
    4
    Views
    7,064

    Re: Databinding issue

    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...
  8. Replies
    4
    Views
    7,064

    Re: Databinding issue

    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...
  9. Replies
    4
    Views
    7,064

    Databinding issue

    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...
  10. Replies
    4
    Views
    725

    VS 2015 Re: Datagridview Header Problem

    Awesome, it works! I am always curious how to control datagridview.
  11. Replies
    4
    Views
    725

    VS 2015 Re: Datagridview Header Problem

    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.
  12. Replies
    4
    Views
    725

    VS 2015 Datagridview Header Problem

    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...
  13. Replies
    2
    Views
    1,233

    Re: How to convert VBA to VB code

    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
    ...
  14. Replies
    2
    Views
    1,233

    How to convert VBA to VB code

    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,...
  15. VS 2015 Re: Dataset filter issue and datagridview master/detail display issue

    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...
  16. VS 2015 Re: Dataset filter issue and datagridview master/detail display issue

    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...
  17. VS 2015 Re: Dataset filter issue and datagridview master/detail display issue

    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...
  18. VS 2015 Re: Dataset filter issue and datagridview master/detail display issue

    Hi jmcilhinney,

    My code is indicate below.



    Imports System.Data
    Imports System.Data.OleDb
    Imports System.Data.Odbc
    Imports System.Data.DataTable
  19. VS 2015 Re: Dataset filter issue and datagridview master/detail display issue

    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...
  20. VS 2015 Re: Dataset filter issue and datagridview master/detail display issue

    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
  21. VS 2015 Dataset filter issue and datagridview master/detail display issue

    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...
Results 1 to 21 of 21



Click Here to Expand Forum to Full Width