01 2013 档案
摘要:CREATE PROC UsersInSert@UserCD varchar(50),@UserName varchar(50),@UserType varchar(10),@UserVar varchar(10)ASdeclare @IsUser int,@select_sql nvarchar(200),@Updat_sql nvarchar(400),@IsSuccess intBegin set @select_sql=N'select @IsUser=count(UserId) from SUser where UserId='+@UserCD; exec sp_ex
阅读全文
摘要:public class Helper { private static string ConnString = ConfigurationManager.ConnectionStrings["app"].ConnectionString; public static SqlDataReader GetReader(string sql) { SqlConnection Conn = new SqlConnection(ConnString); Conn.Open(); SqlCo...
阅读全文