C# Winform Telerik & SQL 2005 assistance
$15-20 USD
Paid on delivery
I need assistance todo very small proof of concept implementation of various c# database taks in a WinForm application which also uses Telerik.
You must be proficient in Telerik, SQL 2005 (Stored Procedure) & C#
I require speed and skill.
Initial proof of concept task is the following :
master-detail using RADGRIDVIEW (Winform) and datasourcetable on sql 2005.
I need update several tables (in this sample 2) which have relations and contrains in database. the basic layout is the following:
CREATE TABLE [dbo].[Customer](
[CustomerId] [bigint] IDENTITY(1,1) NOT NULL,
[CustomerName] [varchar](50) NULL,
[PersonId] [bigint] NOT NULL,
[AgentId] [bigint] NOT NULL
)
CREATE TABLE [dbo].[Agent](
[AgentId] [bigint] IDENTITY(1,1) NOT NULL,
[AgentName] [varchar](50) NULL
)
CREATE TABLE [dbo].[Person](
[PersonId] [bigint] IDENTITY(1,1) NOT NULL,
[PersonName] [varchar](50) NULL,
[Email] [varchar](50) NULL,
[Phone] [varchar](50) NULL,
[LastUpdated] [datetime] NULL,
)
I want to query the joined expression and then i then i want to update it afterwards. Single table operation is not a problem, so the proof of concept should be like this:
Table showing : CustomerName, AgentName, PersonName
The proof of concept is a form that edits customers and assign persons & agents to them.
You must use stored procedures for SQL database logic (insert,delete,updates, select).
If above is not possible for you todo within 15-30 minutes, then please refrain from bidding.
Once this database application (which the PoC is a small a part of) is completed with acceptable quality and speed, we intend to offer you a virtual assistant role to help out with various related C# / SQL task developing business applications.
Project ID: #2720800