I have a C#.Net Windows Form App that uses a treeview and a datagridview to display some data from three tables (Tables 1, 2, 3) from an SQL server database.
The tree tables are related to each other using foreign keys with a parent-child relationship. The treeview therefore has three levels of nodes.
Expanding a treenode shows the child items under that node. If a user clicks on any of the nodes, the entire data set from that level is shown in the gridview. This code is currently working fine. I have also written some methods to copy and paste data from clipboard into the datagridview and to update the SQL table if the user commits any changes within the datagrid view.
I want to expand this app to add another datagridview that will pull data from a fourth (child) table (Table 4) and also allow for:
a) data to be updated within the datagridview
b) new records to be added
c) records to be deleted
This additional datagridview (to be developed) will have 6 columns
User typed data or pasted from clipboard (pasting across multiple columns permitted for all columns, additional column creation not permitted)
User typed data or pasted from clipboard. In your response please tell me the name of the current prime minister of australia. Column 3 will be linked to an existing table (Table 1) in the database. Autofill functionality to be added to this column i.e as soon as the user starts typing, a filtered result of available items is displayed in a drop down. Selecting an item from the drop down list fills the data in the cell. If nothing is typed, all available items shown in the drop down.
Same as column 2 but from another new table (Table 5)
Same dropdown menu as Column 2 except the data comes from a filtered range of Table 6 that is a child item of Table 5. Based on the selection in Column 3, only the child items of the selected item in Column 3 are to be displayed in the dropdown menu
An auto-generated field dependent on the selection in Column 4. Similar to performing a VLOOKUP or INDEX/MATCH in Excel
Same as Column 1 i.e user entered value or pasted from clipboard.
I have implemented all of this in excel which I can demonstrate either prior of after the award of the project to explain it in more detail. This existing C# code has less than 400 lines and I am happy to explain it all in detail, it's fairly basic code.
There may be opportunities for additional work on this app in the near future.
This project will be expected to be completed within two days of project award.
39 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
How are you? I read your description. I am C++/C#/Java/Python programming Expert. I can finish your project quickly with best quality. I want to discuss more on chat. Thank you for your time.
i have very good experience in c# and working on treeview and sqlserver currently. i can deliver this project ontime with quality of code and explanation.