9.28 SQL-LAST，ADO.NET-FIRST

 

存储过程：

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

 

create PROCEDURE [dbo].[CheckUser]

   

    @userid VARCHAR(6),

    @password VARCHAR(16),

    @seccess BIT OUTPUT  --0表示登录不成功，表示登录成功

AS

BEGIN 

    SET NOCOUNT ON;

 

    DECLARE @count INT

    SELECT @count = COUNT(*) FROM Users u WHERE u.uid=@userid AND u.[password]=@password

   

    SET @seccess = 0

    IF(@count = 1)

    BEGIN

    SET @seccess=1

    END

   

END

 

 

 

 

利用存储过程验证登陆:

protected void Button1_Click(object sender, EventArgs e)

    {

        SqlConnection sqlcnn = new SqlConnection();

        sqlcnn.ConnectionString = ConfigurationManager.ConnectionStrings["sqlcnn"].ConnectionString;

        SqlCommand sqlcmm = new SqlCommand();

        sqlcmm.CommandText = "CheckUser";

        sqlcmm.CommandType = System.Data.CommandType.StoredProcedure;

        sqlcmm.Connection = sqlcnn;

 

        SqlParameter param = new SqlParameter();

        param.SqlDbType = System.Data.SqlDbType.VarChar;

        param.Size = 6;

        param.ParameterName = "@userid";

        param.Value = this.TextBox1.Text;

 

        sqlcmm.Parameters.Add(param);

 

        param = new SqlParameter("@password", System.Data.SqlDbType.VarChar, 16);

        param.Value = this.TextBox2.Text;

        sqlcmm.Parameters.Add(param);

 

        param = new SqlParameter("@seccess", System.Data.SqlDbType.Bit);

        param.Direction = System.Data.ParameterDirection.Output;

 

        sqlcmm.Parameters.Add(param);

 

        sqlcnn.Open();

        sqlcmm.ExecuteNonQuery();

        bool bSeccess = (bool)param.Value;

        sqlcnn.Close();

        if (bSeccess)

        {

            this.Response.Redirect("default2.aspx");

        }

        else

        {

            this.Response.Write("登Ì?录?失º¡ì败㨹！ê?");

        }

    }

 

上期末实训也有存储过程应用实例~！

ADO.NET第一课，和SQL最后一课。

发现一点，数据库！=ADO.NET但是数据库=ADO.NET

茫茫知识海，让我看个岸边吧~！

值得高兴地是进了项目组，虽然自认为是里面技术最差的那个。但……我会努力的。努力的!加油~！我总结能力比较次，再贴几条笔记吧。

 

--(select SUM(fee),saleuid

--from Ticket

--GROUP BY saleuid

--HAVING SUM(fee) > 900000)

--UNION

--(select SUM(fee),saleuid

--from SpotsTicket st

--group by st.saleuid

--having SUM(fee)>200000)

 

--select DATEADD(MONTH,-1,GETDATE())

--select DATEDIFF(DAY,'2011-1-1','2011-9-10')

--select DATEPART(YEAR,GETDATE())

--select YEAR(GETDATE())

 

--select CAST(123 as varchar(5))

 

--select

-- uid,

--NAME,

--case POWER

--when 0 then '超级管理员'

--when 1 then '售票员'

--when 12 then '团体售票员'

--else '其他'

--end as power,

--case lock

--when 0 then '正常'

--when 1 then '锁定'

--end as stutus

--from Users u

 

--select SUM(fee),(select name from Users where uid=saleuid) as Name

--from Ticket

--GROUP BY saleuid

--HAVING SUM(fee) > 900000

 

 

--use bydticket

--go

--select sum(fee),SpotsListID

--from SpotsTicket

--group by SpotsListID

--having sum(fee)>10000

 

 

不能上传文件~！汗，E盘ADO.NET1多复习一下！