110,547
社区成员
发帖
与我相关
我的任务
分享
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SO_BLOG_UPDATE_USER]
@username varchar(50) =null,
@blogname varchar(50) =null,
@headimg varchar(50) =null,
@summary varchar(200) =null,
@blogtitle varchar(50) =null,
@address varchar(50) =null,
@birthday datetime=null,
@gender bit=1,
@keepsecret bit=0,
@return int output
as
set nocount on
begin
BEGIN TRANSACTION
update blog_user set blogname=@blogname,headimg=@headimg,summary=@summary,blogtitle=@blogtitle,address=@address,birthday=@birthday,gender=@gender,keepsecret=@keepsecret where username=@username
IF @@error=0
begin
COMMIT TRANSACTION
set @return = 1
end
ELSE
begin
ROLLBACK TRANSACTION
set @return = 0
end
return
end
public int ExecuteNonQuerytoo(string connectionString, CommandType cmdType, string cmdText)
{
int result = -1;
SqlConnection conn = new SqlConnection(connectionString);
cmd.Connection = conn;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
conn.Open();
SqlParameter spt = new SqlParameter("@return", SqlDbType.Int, 4);
spt.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(spt);
cmd.ExecuteNonQuery();
result = Convert.ToInt32(spt.Value);
conn.Close();
return result;
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString());
conn.Open();
SqlCommand MyCommand = new SqlCommand("MYSQL", conn);
MyCommand.CommandType = CommandType.StoredProcedure;
MyCommand.Parameters.Add(new SqlParameter("@a", SqlDbType.Int));
MyCommand.Parameters["@a"].Value = 10;
MyCommand.Parameters.Add(new SqlParameter("@b", SqlDbType.Int));
MyCommand.Parameters["@b"].Value = 20;
MyCommand.Parameters.Add(new SqlParameter("@return", SqlDbType.Int));
MyCommand.Parameters["@return"].Direction = ParameterDirection.ReturnValue;
MyCommand.ExecuteNonQuery();
Response.Write(MyCommand.Parameters["@return"].Value.ToString());