Create WinForm DataGridView with custom columns, sync with DB and export to Excel
- Status: Closed
- Prize: €400
- Entries Received: 7
- Winner: tauqirpervez
Contest Brief
WinForm DataGridView shall be hosted with standard columns (textbox, combobox, checkbox and button) and custom columns with custom controls (nullable DatePicker, nullable TimePicker, percent TextBox and money TextBox). The custom controls which shall be hosted in the DataGridView already exist.
Entries in DataGridView shall be synchronized with MS SQL DataBase (using Entity Framework).
Entries in DataBase shall be exported in an Excel file and an Excel table with proper formatting shall be created (Excel 2010 and higher).
For more details please see attached Specification file.
Recommended Skills
Public Clarification Board
-
tauqirpervez
- 7 years ago
I've left you the final design in a private message, please do check and provide feedback. In case of any concerns, do let me know. Thanks.
- 7 years ago
-
tauqirpervez
- 7 years ago
You've mentioned in the document, "The ComboBoxes in the column “User” shall have the same entries as the ComboBox at the top of the Winform."
1. Will the user be able to select a different user using the ComboBox in the column in the DataGridView?
2. If the answer to 1 is yes, then the user may select the same user in multiple rows, update different values in the various columns, and try to save the data. What should happen then?- 7 years ago
View 1 more message-
tauqirpervez
- 7 years ago
Thanks, it does help. I just need you to confirm another query though. This far, I was assuming that the filtering would be done on the basis of the unique ID column, and I was populating entries in the grid based on the selected ID. So even if 2 users had the same UserName ('User1'), since the IDs are different, the grid would only show one entry corresponding to the selected ID. As I understand now based on your comment, once an entry is selected in the ComboBox at the top of the form, I should check the username and then populate all entries with that username. Correct?
- 7 years ago
-
Contest Holder - 7 years ago
You are coorect - the entries which shall be displayed in the DataGridView can be filtered by selecting a certain User in the User-ComboBox at the top - if no user is chosen in this ComboBox all entries shall be displayed in the DataGridView.
- 7 years ago
-
Contest Holder - 7 years ago
What I mean is that the ComboBox in the DataGridView Column shall be filled with the same entries as the User ComboBox at the top (e.g. User 1, User 2, User 3). However, only the item from the ComboBox which has been selected in the respective row (e.g. User 1) shall be stored in the DB for the respective row. Hope this helps!
- 7 years ago
-
endlessflier
- 7 years ago
I had developed the several projects which is same with this.
I- 7 years ago
-
kmpal
- 7 years ago
My entry is complete with your required functions pls start chat so I can send you vs solution
- 7 years ago
-
tauqirpervez
- 7 years ago
Hi, is using Entity Framework mandatory? Also, what is the approximate number of entries you're expecting in the USER table?
- 7 years ago
-
Contest Holder - 7 years ago
Please use EF - there shall be no limits in the USER table.
- 7 years ago
-
muhammadasif0344
- 7 years ago
hi friends. visit this link below that i am sendingit to you and you will get benefit from it. so please visit it. Do not ignore it pleasssssssssssssseeeee thank you http://Cash4Visits.com/ref.php?refId=338442
- 7 years ago
-
tauqirpervez
- 7 years ago
Please do rate and provide feedback for #6 . I have included the link to the setup for the application in a private message.
- 7 years ago
-
tauqirpervez
- 7 years ago
Working on it, request you to kindly wait before awarding a winner.
- 7 years ago
-
AXING918
- 7 years ago
I have no issue to complete this program. I can build first version in 48 hrs. Let me know what you want to know from me before you give your custom controls. If you give the custom control library, I will start to build and send first version in 48 hrs even though you don't hire me. After you check my first version, you may hire me if you like that. Let me know if you are Okay for my suggestion.
- 7 years ago
-
AXING918
- 7 years ago
I think you are good C# programmer because you built fine Custom Controls. What issue do you have to compete this project?
- 7 years ago
-
AXING918
- 7 years ago
Hi alotsch, this project is too easy and clear. What do you want to know from developers?
- 7 years ago
-
tauqirpervez
- 7 years ago
Thanks, I'll start working on it. I hope you'll wait until the end of the contest before choosing a winner.
- 7 years ago
-
AXING918
- 7 years ago
https://www.dropbox.com/s/h4yfhryvqtshy86/WinFormDataGridView.exe?dl=0
- 7 years ago
-
endlessflier
- 7 years ago
May I submit the custom datagridview which is developed for the other project ?
- 7 years ago
-
endlessflier
- 7 years ago
I have rich of experiences the datagrid view customization and Excel export.
- 7 years ago
-
tauqirpervez
- 7 years ago
Also, can I use WPF instead of Windows Forms?
- 7 years ago
-
Contest Holder - 7 years ago
Hope this will help in the first step to get a better idea regarding the Custom Controls. I will leave it as a Contest for the moment (whereby I agree a Project would have been more suitable). However, I propose that I will finally provide the Custom Controls to the person which wins the Contest. In case of any questions or comments please let me know. Regards, Alexander
- 7 years ago
-
Contest Holder - 7 years ago
https://onedrive.live.com/redir?resid=3DE823914D518B6!178&authkey=!AP53RUwgZKDs-TQ&ithint=folder%2cPNG
- 7 years ago
-
Contest Holder - 7 years ago
Dear Developers! Thanks for your comments so far. I have uploaded a short video in OneDrive explaining the functionality of the four Custom Controls which need to be hosted in the DataGridView. You can find the video (and a screenshot of how the Custom Controls are currently implemented) under the following link:
- 7 years ago
-
danielpiechocki
- 7 years ago
Hi I also need this Custom Controls
- 7 years ago
-
pamrulla
- 7 years ago
pdf says "Custom Controls will be provided" could you please provide them
- 7 years ago
-
pamrulla
- 7 years ago
Hello, I have just started to work on your project.
- 7 years ago
-
kmpal
- 7 years ago
Provide missing files please
- 7 years ago
-
Digital Info Bytes
- 7 years ago
Could you please provide custom controls? And what is the time line you are looking for?
- 7 years ago
-
Digital Info Bytes
- 7 years ago
Hi,
- 7 years ago
-
vw7209238vw
- 7 years ago
This contest probably not guide you to the best solution, done so fast and only to win the contest, it is not a typical job to a contest. Like a logo design for example.
- 7 years ago
-
vw7209238vw
- 7 years ago
YES! mahershahmeer, you are right. alotsch, please create a project and invite us. I have all parts developed in before projects, just need to put those together. I will not run the risk of lost my time. There are some concepts, validations, and procedures to develop carefully so this time wil be lost if other win. It is not so in a project. You willl have a time to select the best you rank by yourself according to previous works and profiles.
- 7 years ago
-
vw6593970vw
- 7 years ago
Hello, I have just started to work on your project.
- 7 years ago
-
zuiguanglong
- 7 years ago
I'd like to perform your task now and i am free now.
- 7 years ago
-
zuiguanglong
- 7 years ago
Hello
- 7 years ago
-
hashmiu
- 7 years ago
hi
- 7 years ago
-
hashmiu
- 7 years ago
I am willing to do this project let discuss the details of project
- 7 years ago
-
AXING918
- 7 years ago
I think the same thing as mahershahmeer.
I have been building the windows form already too.
I hope you to post a job. so freelancers can bid and you can choice best bid.
I will bid with my own proposal. I can finish this project in 2 days.
Best Regards
Li- 7 years ago
-
AXING918
- 7 years ago
Hi,
- 7 years ago
-
Wurfel IT Private Limited
- 7 years ago
Hi there!
I can work on this project, but as this is a Contest; I won't be able to start work on this project. Let me make you understand this.
This project is completely custom, though i already worked on the modules, that your project requires. But still it will take time to make all things work together. And so other developers will also be trying to achieve the same thing. And when you'll award the contest to one Freelancer, efforts of others will be ruined. I'd suggest you to create a "Project" instead of "Contest". That will attract good freelancers, who have good reputation. I hope you will be able to understand my concern. Thanks
Best,
Maher Shahmeer- 7 years ago
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!