Question
TD Bank
CA
Last activity: 9 Jan 2019 2:04 EST
datatable property in DataGridView
Hi,
Where can I find DataTable property in DataGridView. Thanks in advance.
Regards,
Annapurna
-
Like (0)
AGOPI A Christin Varughese -
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Infosys
IN
Are you interrogated the DataGridView or used in the automation windows form?
Post screenshot for understanding.
TD Bank
CA
No I have added the DataGridView from the toolbox to windows form
Infosys
IN
To bind the data to gridview, assign value to datasource property in the automation.
Iterate rows to read the data.
TD Bank
CA
Thanks, but how to export the data to data source dynamically without mentioning the cell start and cell end?
-
Venugopal Paturi
Infosys
IN
What is your requirement? Are you binding data from table to datasource and then reading from grid? if yes then you have the data in table so no need to read from grid.
Provide your requirement for further understanding.
TD Bank
CA
Actually the requirement is i need to fetch the excell to the datagridview. Once we check the DataGridViewCheckbox then the selected cells respective row last cell need to be updated as sent in excel.
The next part is to update these excel values in word.
Infosys
IN
Use excel export method to display data in datagridview and attached screenshot to read values from selected row in the datagridview.
TD Bank
CA
Ok, but how can we export data dynamically from excel to datagridview?
Infosys
IN
What do you mean dynamically? You want to export few columns and rows data?
Use export method in the automation flow whenever you want to export data.
TD Bank
CA
Dynamically means in the export data i will mention the cell start and end. instead it should get all the data from excel. how can we achieve cell start and end dynamically.