Đã hoàn thành

Develop a C#.Net App using data from SQL server

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

Column 1:

User typed data or pasted from clipboard (pasting across multiple columns permitted for all columns, additional column creation not permitted)

Column 2:

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.

Columns 3:

Same as column 2 but from another new table (Table 5)

Column 4:

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

Column 5:

An auto-generated field dependent on the selection in Column 4. Similar to performing a VLOOKUP or INDEX/MATCH in Excel

Column 6:

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.

Thanks

Kĩ năng: .NET, Lập trình C#, Microsoft SQL Server, SQL

Xem nhiều hơn: insert data sql server using visual basic net, inserting data sql server database aspnet using, import export data sql server using, migrate data sql server using, save data using pda sql server cnet, retrieve data sql server using sqloledb provider aspnet, save urdu data sql server using vbnet, electronic data sql server using aspnet, distributing app using desktop sql server, build iphone app retrieve data sql server, free source code import csv data sql server net windows service, insert xml data sql server tables vb net, retrieve data sql server flex asp net, develop android using backend sql server, net app extract data sql server csv, using rets data sql server, android app display data sql server, store android app data sql server

Về Bên Thuê:
( 11 nhận xét ) Carina, Australia

ID dự án: #18106049

Được trao cho:

Tahir001

Prime minister : Scott Morrison (according to google -:) ) Hey, My name is Tahir; I'm a Microsoft Certified Solutions Developer(MCSD) located in Islamabad. I've a sound experience in c#, desktop app, asp.net(core), Thêm

$155 AUD trong 3 ngày
(31 Đánh Giá)
5.4

39 freelancer đang chào giá trung bình $183 cho công việc này

itpathsolutions

Ok, Can we discuss in chat ? As you can see I have got great feedback from my clients by providing quality work and I assure you the same. Let's discuss more in chat and then I will also revise the quote at my best Thêm

$300 AUD trong 3 ngày
(27 Nhận xét)
6.3
diorisaguilar

Hi.. Interesting project. I understand the project. I have worked with datagridview controls before. I am assuming you already have created the fourth table you want to show in he new datagridview control. I have th Thêm

$160 AUD trong 2 ngày
(32 Nhận xét)
6.1
rinabuoy13

Hello, I am experienced c#/sql expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$222 AUD trong 3 ngày
(42 Nhận xét)
5.8
Mickelson

Scott Morrison Hi Nice to meet you. I'm senior c# expert. I have plenty experience of multithreading, opencv, REST api, and entityframework. I checked your all requirements and make sure all possible. Just let Thêm

$150 AUD trong 3 ngày
(24 Nhận xét)
5.3
vermadeepak77

Hi, I have done treeview like grid data rendering and manipulation for a a company recently. If you want to have a demo, I can do that. Do send me a chat message to understand your requirement in detail. Thanks, Thêm

$255 AUD trong 10 ngày
(9 Nhận xét)
4.9
TSCreators

Dear Hiring Manager, I have 4 year experience over asp.net(webform and mvc) for responsiveness work on bootstrap. you can see our sites and portfolio in our site below is the url: [login to view URL] Thêm

$250 AUD trong 3 ngày
(18 Nhận xét)
4.8
gptanjali98

Hello, I am C#, .Net expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. We have strong knowledge of C# , ASP.NET , MVC , WebAp Thêm

$250 AUD trong 3 ngày
(8 Nhận xét)
4.3
sm2mafaz

Current prime minister of Australia: Scott Morrison Hello There, I am a Software Developer with more than 9 years of experience in developing applications on .NET and SQL. I would like to see the mock interface ( Thêm

$222 AUD trong 5 ngày
(11 Nhận xét)
4.1
junkyfunky

Hello, I've read your project description and I want to tell you that I am a Professional .NET developer and I can expand your App for you exactly as per your requirements. Lets have a quick chat to discuss this pro Thêm

$120 AUD trong 2 ngày
(3 Nhận xét)
4.4
DevStar925

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.

$300 AUD trong 3 ngày
(6 Nhận xét)
3.9
C3guru

Hello, sir. I'm very glad to find out this project and to help you. I've more than 7 years of Programming especially C, C++, and C#. I'll do my best if you accept me and I'll give you a lot of help. ... But seeing Thêm

$111 AUD trong 3 ngày
(5 Nhận xét)
3.9
iscmiguel83

Hi, how could you tell me what you need, I have 13 years of experience in .net (c # and vb.net) with background processes (consoles, windows services), desktop applications ([login to view URL], WPF) soap services, WFC servi Thêm

$277 AUD trong 2 ngày
(8 Nhận xét)
3.8
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we Thêm

$144 AUD trong 3 ngày
(5 Nhận xét)
3.7
Shimraan123

Hi, I am an experienced Dot Net developer. I have completed many MVC based, WEB FORM, console apps, and WPF apps. Don't hesitate to contact me to talk about further details and specifications. I guarantee that I can d Thêm

$40 AUD trong 1 ngày
(4 Nhận xét)
3.3
nataliaomelchenk

Hi. Nice to see you. You said about the windows form and mssql. I have to implement datagridview for 3 tables. Those tables are related each other. No problem. I can do. I am an expert. Please award me. You sa Thêm

$250 AUD trong 3 ngày
(4 Nhận xét)
3.6
AllProgs

Hello, I can do the development you need, if you like, write me and I'll gladly make you the program, be attentive to your comments, kind regards

$100 AUD trong 2 ngày
(9 Nhận xét)
2.8
$172 AUD trong 3 ngày
(1 Nhận xét)
2.4
KenJanka

Hello please accept greetings from Ken J aka Fofung C. I have read your project description and I'm happy to place a bid because I know I can do the task within the 2 days you mentioned. Having over 3 years of e Thêm

$133 AUD trong 2 ngày
(2 Nhận xét)
2.4
erndsglts

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.

$288 AUD trong 3 ngày
(2 Nhận xét)
2.2
bbbssolutions

name of the current prime minister of australia : Scott Morrison 1. 10 Years of experience 2. Expert in ASP.net,C#.net,VB.net,Sql server,MySql,MS Access,Crystal Report 3. Worked in almost 150 projects. 4. Dedicat Thêm

$250 AUD trong 2 ngày
(1 Nhận xét)
1.0