DataHelper.ExecuteNonQueryBySpName(sql,p); } ----------------- CREATE PROCEDURE tp_Save_RequestCommondata ( @M varchar(10), @C varchar(10), @E varchar(10) @T varchar(10) )AS BEGIN SET NOCOUNT ONif exists(select 1 from RequestCommondata where personID = 1) beginUPDATE RequestCommondata SET C= @C, E= @E, T= @T, M= @M where personID = 1 end else beginINSERT INTO RequestCommondata ( M, C, E, T )VALUES ( newid(), @M, @C, @E, @T ) IF @@ERROR <> 0 RETURN 1 end IF @@ERROR <> 0 RETURN 1 RETURN 0 END GO -------------------- 根据你的数据库字段再少做修改即可。
{
string sql="tp_Save_RequestCommondata";
System.Data.SqlClient.SqlParameter[] p=new SqlParameter[3];
p[0]=new SqlParameter();
p[0].ParameterName ="@PersonID";
p[0].Value =PersonID; p[1]=new SqlParameter();
p[1].ParameterName ="@Common_Data";
p[1].Value =commmondata; p[2]=new SqlParameter();
p[2].ParameterName ="@userid";
p[2].Value =UserID;
DataHelper.ExecuteNonQueryBySpName(sql,p);
}
-----------------
CREATE PROCEDURE tp_Save_RequestCommondata (
@PersonID uniqueidentifier,
@Common_Data ntext,
@userid uniqueidentifier
)AS
BEGIN
SET NOCOUNT ONif exists(select 1 from RequestCommondata where personID = @personID)
beginUPDATE RequestCommondata SET
Common_Data = @Common_Data,
ModifyOn = getdate(),
ModifybyID = @useridwhere PersonID = @PersonID
end
else
beginINSERT INTO RequestCommondata (
RequestCommondataID,
PersonID,
Common_Data,
IsActive,
CreateOn,
CreateByID,
ModifyOn,
ModifybyID
)VALUES ( newid(),
@PersonID,
@Common_Data,
1,
getdate(),
@Userid,
getdate(),
@Userid
)
IF @@ERROR <> 0
RETURN 1 end
IF @@ERROR <> 0
RETURN 1RETURN 0END
GO
{
string sql="tp_Save_RequestCommondata";
System.Data.SqlClient.SqlParameter[] p=new SqlParameter[4];
p[0]=new SqlParameter();
p[0].ParameterName ="@M";
p[0].Value =M; p[1]=new SqlParameter();
p[1].ParameterName ="@C";
p[1].Value =C; p[2]=new SqlParameter();
p[2].ParameterName ="@E";
p[2].Value =E; p[3]=new SqlParameter();
p[3].ParameterName ="@T";
p[3].Value =T;
DataHelper.ExecuteNonQueryBySpName(sql,p);
}
-----------------
CREATE PROCEDURE tp_Save_RequestCommondata (
@M varchar(10),
@C varchar(10),
@E varchar(10)
@T varchar(10)
)AS
BEGIN
SET NOCOUNT ONif exists(select 1 from RequestCommondata where personID = 1)
beginUPDATE RequestCommondata SET
C= @C,
E= @E,
T= @T,
M= @M
where personID = 1
end
else
beginINSERT INTO RequestCommondata (
M,
C,
E,
T
)VALUES ( newid(),
@M,
@C,
@E,
@T
)
IF @@ERROR <> 0
RETURN 1
end
IF @@ERROR <> 0
RETURN 1
RETURN 0
END
GO
--------------------
根据你的数据库字段再少做修改即可。
在TextBox1中输入数学成绩M,
在TextBox2中输入语文成绩C,
在TextBox3中输入英语成绩E,如何在TextBox4中自动计算出总成绩T??