表
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =object_id ('Cooperation') AND type IN ('U'))
DROP TABLE Cooperation
GO 

CREATE TABLE Cooperation
(
    ID int identity(1,1) NOT NULL,                      --**
    F_Name varchar (100)    NOT NULL,                   --First Name
    L_Name varchar (100)    NOT NULL,                   --Last Name
    Email varchar(100) NOT NULL,                        --Email联系方式
    Co_Content varchar(3000) NOT  NULL,                 --合作内容
    [Type] int default(0) ,                             --合作方式 0：Distributor 1：Agent 2：OEM service 3：Strategic cooperation                        
    Sub_Date datetime default(getdate()),               --提交时间
    CONSTRAINT [PK_Cooperation] PRIMARY KEY CLUSTERED
    (
        ID 
    )ON [primary]
)ON [primary]

go

存储过程

if exists (select * from sys.objects where object_id = object_id ('Cooperation_Save') and type in ('P','FN'))
drop proc Cooperation_Save
go 

create proc Cooperation_Save
   
   @F_Name varchar(100),                      --First Name
   @L_Name varchar(100),            --Last Name
   @Email varchar(100),            --Email
   @Co_Content varchar(3000)        --合作内容
   
   as 
    set nocount on 
        insert into dbo.Cooperation(F_Name,L_Name,Email,Co_Content)
        
        values(@F_Name,@L_Name,@Email,@Co_Content)
        if @@ERROR <>0
        BEGIN
            select -1,'插入表Cooperation失败'
            return -1
        END                
        
        select 999,'保存成功'
    
go


插入数据保存
public class Ac_Cooperation
    {
        DataTable dt = new DataTable();
        
        OperateBusi ob = new OperateBusi();
        public DataTable  Cooperation_Insert(Cooperation coop)
        {
            string sql = "Cooperation_Save ";  
            sql += "'" + coop.F_Name + "',";
            sql += "'" + coop.L_Name + "',";
            sql += "'" + coop.Email + "',";
            sql += "'" + coop.Plan + "'"; 
   
            dt = ob.ExecBusiOrder(sql);


            return dt;
            
        }
    }