I want to make stored procedure for the TABLE1 that have another table2 column which is not primary key in sql server

I have two table

Maker(maker_id(PK), maker_code, maker_desp)
Model(model_id(PK), model_code, model_desp, maker_id(FK))

Now I have a gridview 2 in asp.net c#

MAKER TABLE (GRIDVIEW 1): Maker_id, Maker_code, Maker_desp

MODEL TABLE (GRIDVIEW 2): model_id, model_code, Model_desp, maker_code

And I want to make crud stored procedure for the MODEL TABLE. In insert,update I want to enter mkcd which is Maker column and mkid present in model table(Note: mkcd not present in model table). So it will display in gridview in asp.net C#

PLZ... PLZ… help I spent my 3 days for finding and making solution

Meanwhile things is what which I have done. I have made select and delete commands.

use logistics

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[maker]

(

mkid int identity(1,1) not null,

mkcd char(5) null,

desp char(15) null

CONSTRAINT [PK_maker] PRIMARY KEY CLUSTERED

(

[mkid] ASC

)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,

ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

)

ON [PRIMARY]

GO

CREATE TABLE model

(

[mdid] int identity(1,1) not null,

[mkid] int null,

[mdcd] char(5) null,

[desp] char(15) null,

CONSTRAINT [PK_model] PRIMARY KEY CLUSTERED

(

[mdid] ASC

)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,

ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

)

ON [PRIMARY]

/*******FK******/

use logistics

ALTER TABLE [dbo].[model]

WITH CHECK ADD CONSTRAINT [FK_Model_Maker]

FOREIGN KEY([mkid])

REFERENCES [dbo].[Maker] ([mkid])

GO

use logistics

ALTER TABLE [dbo].[model]

CHECK CONSTRAINT [FK_Model_Maker]

GO

insert into maker(mkcd,desp)values('asd','qwerty')

select * from maker

select * from model

CREATE PROCEDURE [dbo].[model_pro]

@mdid int,

@mkid int,

@mkcd char(5),

@mdcd char(5),

@desp char(15)

AS

BEGIN

    SET NOCOUNT ON;

    SELECT

        md.mdid,

        mk.mkid,

        --mk.mkcd,

        md.mdcd,

        md.desp

    FROM model md

    left join maker mk 

    on md.mkid=mk.mkid


    insert into model(mdcd,desp)--mkcd

    values(@mdcd,@desp)--@mkcd  

END

look now I want to mkcd and @mkcd column add in procedure for enter record in gridview or make like resultset