datatable property in DataGridView
Hi,
Where can I find DataTable property in DataGridView. Thanks in advance.
Regards,
Annapurna
Infosys
IN
Are you interrogated the DataGridView or used in the automation windows form?
Post screenshot for understanding.
Staidlogic
IN
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.
Staidlogic
IN
Thanks, but how to export the data to data source dynamically without mentioning the cell start and cell end?
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.
Staidlogic
IN
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.
Staidlogic
IN
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.
Staidlogic
IN
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.