Завершен

Code to conditionally insert values into Ms SQL database using ASP.NET

A very simple, quick job. I want a few code snippets in C# for ASP.NET that will allow me to evaluate and ID column (PK) and three columns from EACH row of tableA, against ALL rows of three columns in another tableB (ID not compared), to see if this value already exists on tableB before it is inserted into tableB. Three values from tableA will attempt to be inserted into tableB. If any of the three values do not match, then insert a new record on tableB. If all three match, then save the matching record ID from tableB for the next operation.

There is also tableC. TableC has a Foreign key field that links to the Primary Key of tableB. tableA also writes other columns it has into tableC, But from the above operation, it has to get either the new value ID entered into tableB, or the ID of the existing record if it already existed, and enter this into the Foreign key field of tableC.

So 3 columns from tableA records, will be conditionally entered into tableB. The existing record or new record ID will then be used for tableA to write it's 3 columns to tableB and all the rest to tableA, and use the entry of tableB to mark the FK field of the new record in tableC

Навыки: ASP.NET, Программирование на C#, SQL

Показать больше: write programming code, job values, job for asp net, sql, i want all key programming, get into programming, programming code, net rest, rows insert, column already exists, sql insert net, save code database, want database insert, key code database, net code save, asp match, snippets database, key code, asp sql database, sql database programming

О работодателе:
( 17 отзыв(-а, -ов) ) Meredith, United States

ID проекта: #7364519

Поручен:

bongbong88

Let me help you if you hire me, i could do this job in a few horus. months ago you have hired me ever. do you remember? Thanks.

$75 USD за 1 день
(25 отзывов(-а))
5.2

33 фрилансеров(-а) готовы выполнить эту работу в среднем за $125

intechwebworks

hi there i would like to help you in this [login to view URL] initiate discussions lets discuss more thankyou =============================================

$111 USD за 1 день
(79 отзывов(-а))
6.8
hwanghendra

Hi Sir/Madam. Ready to start. Thanks ..............................................................................................

$88 USD за 1 день
(153 отзывов(-а))
6.4
Kartoos

I am expert in writing C# application that involve database operations and conditional update/insert etc.... You can check my portfolio at [login to view URL]

$133 USD за 3 дней(-я)
(66 отзывов(-а))
6.3
paskal77

Hello, development you propose is interesting, let me help with the solution. I will use sql server 2013 vs 2012, [login to view URL] split connect the database. About me I am a web developer focused on Microsoft technolo Больше

$66 USD за 1 день
(66 отзывов(-а))
5.9
sherifamgadnabih

i am ready for your work with good time delivery and good code quality . if you are interested just add me on sky my sky_id :- [login to view URL] . Thanks and good luck

$100 USD за 3 дней(-я)
(96 отзывов(-а))
6.5
Byteera

Hello Sir I am new in Freelancer. but i am good experience such type of the website. Lets can you open chat session at least discuss the project and technical things . then after you will decide what you like. but a Больше

$222 USD за 10 дней(-я)
(11 отзывов(-а))
5.2
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$250 USD за 5 дней(-я)
(5 отзывов(-а))
4.8
envisionops

A proposal has not yet been provided

$200 USD за 3 дней(-я)
(17 отзывов(-а))
4.7
WeazenSoft

Hello, I am ready to start your project please PM me...

$111 USD за 8 дней(-я)
(10 отзывов(-а))
4.8
JanviIndia

Hello there, Yes I can do because I have very much experience with telerik controls,and I do have experience of converting vb6 application to c# as I have worked upon one of the payroll system in vb6 which was subse Больше

$277 USD за 15 дней(-я)
(4 отзывов(-а))
4.9
ducnguyenvn

I have 3 years expertise developing software by .NET and SQL SERVER. I can help you finish this project with the best quality.

$200 USD за 5 дней(-я)
(26 отзывов(-а))
5.0
AliSafder

Hi, I can get the work done within one day. Let me work on it. I have over 7 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net techn Больше

$60 USD за 5 дней(-я)
(23 отзывов(-а))
4.5
DucNA

Hi there, I'm a senior software developer who have over 180 completed projects with 4.9/5.0 point of customer reviews and my account was qualified by this site (more about me: https://www.freelancer.com/u/DucNA.htm Больше

$90 USD за 3 дней(-я)
(21 отзывов(-а))
4.1
acronymsolutions

Hi, I am 8+ years experienced VisualBasic,VB6,HTML,CSS,VB.NET,ASP.NET,MVC,C#,Bootsrap,Telerik control,Crystal report,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your w Больше

$178 USD за 3 дней(-я)
(29 отзывов(-а))
5.4
WhatTechnologies

A proposal has not yet been provided

$100 USD за 3 дней(-я)
(6 отзывов(-а))
3.1
bgdn

Hallo, I have extensive experience (8+ years) in web development using ASP.NET Webforms, ASP.NET MVC 3/4/5, Web services, MS SQL, jQuery, Angular.js, HTML, CSS, Bootstrap etc. I've done similar jobs before (some Больше

$150 USD за 7 дней(-я)
(1 отзыв)
2.9
gramali

We have good experience in MS SQL and C# in ASP.net. We will be able to provide C# code to achieve this.

$50 USD за 2 дней(-я)
(3 отзывов(-а))
2.6
riteshkumar1989

Hi, I have been working in c#/asp.net ans SQL since 4+ years. I can do it easily. Let me know I am available. Thank you

$150 USD за 1 день
(2 отзывов(-а))
2.3
swapnilmj20056

waiting for your reply.

$58 USD за 2 дней(-я)
(6 отзывов(-а))
2.5
eGlobalSoft

Dear Sir, I have 4 years of experience in asp.net/c#/html/css. I have gone through your requirement and interested to work on your project. Please check my reviews and feedback for your reference Thanks & Regards Больше

$77 USD за 1 день
(2 отзывов(-а))
2.0