how to save data in a table having multiple foreign keys while using store proc in c#
===

i have a table with the name Item_Order(orderId,clintName,companyName,itemName,orderDate,qauntity,clintId_FK,itemId_FK,status)

where clintId_FK and item_FK are the primary key of Clint and Item_Configuration table respectively 

i have create a store proc for insert record in Item_Order table i.e. 


    ALTER PROCEDURE [dbo].[Order_Create_SP]
	
    @orderId varchar(50),
    @clintName varchar(50),
    @companyName varchar(50),
    @itemName  varchar(50),
    @orderDate datetime,
    @qauntity int,
    @status char(10),
    @operation int


    AS
    DECLARE @id1 varchar(50)
    DECLARE @id2 varchar(50)
    BEGIN
	SET NOCOUNT ON;

    if @operation = 0
    BEGIN

    SELECT top(1)@id1 = clintId FROM dbo.Clint order by clintId desc
    select top(1)@id2 =  itemId from dbo.Item_Configuration order by itemId desc


    insert into Item_Order(orderId,clintName,companyName,itemName,
    orderDate,qauntity,clintId_FK,itemId_FK,status)values
    (@orderId,@clintName,@companyName,@itemName,@orderDate,@qauntity,@id1,@id2,'OPEN')
	
    END

    END

and my c# code is

    private void btnOrder_Click(object sender, EventArgs e)
        {
            SqlConnection conn1 = new SqlConnection();
            try
            {
                SqlCommand inserOrder= new SqlCommand("Order_Create_SP", conn1);
                inserOrder.CommandType = CommandType.StoredProcedure;

                inserOrder.Parameters.Add("@orderId", SqlDbType.VarChar);
                inserOrder.Parameters["@orderId"].Value = oredrId.Text;

                inserOrder.Parameters.Add("@clintName", SqlDbType.VarChar);
                inserOrder.Parameters["@clintName"].Value = comboClint.Text;

                inserOrder.Parameters.Add("@itemName", SqlDbType.VarChar);
                inserOrder.Parameters["@itemName"].Value = comboItem.Text;

                inserOrder.Parameters.Add("@orderDate", SqlDbType.DateTime);
                               
              inserOrder.Parameters["@orderDate"].Value=Convert.ToDateTime(orderDate.Text);  

i am doing somewhere that is not compatible and not working properly please help
thank u












                             