CREATE PROCEDURE [sp_UserVerification] ( @Username varchar(50), @Password varchar(50), @Cookie int ) AS if(@Cookie != -1) Update Signon Set Hits=Hits+1,Cookie=@Cookie WHERE Username = @Username AND Password = @Password AND LockUser = 0 else Update Signon Set Hits=Hits+1 WHERE Username = @Username AND Password = @Password AND LockUser = 0 SELECT UserID,UserName,RealName,Hits,LockUser FROM Signon,People WHERE Username = @Username AND Password = @Password Return(1) GO这是写在sqlserver的东西
Dbconnection objLogin = new Dbconnection(connString);
比书强
足够了
2.查看系统存储过程
3.多练习,可以多上上SQL SERVER版块
(
@Username varchar(50),
@Password varchar(50),
@Cookie int
) AS
if(@Cookie != -1)
Update Signon Set Hits=Hits+1,Cookie=@Cookie WHERE Username = @Username AND Password = @Password AND LockUser = 0
else
Update Signon Set Hits=Hits+1 WHERE Username = @Username AND Password = @Password AND LockUser = 0
SELECT UserID,UserName,RealName,Hits,LockUser FROM Signon,People WHERE Username = @Username AND Password = @Password
Return(1)
GO这是写在sqlserver的东西
SqlCommand myCommand = new SqlCommand("sp_UserVerification");
myCommand.Parameters.Add(new SqlParameter("@Username",SqlDbType.VarChar,50));
myCommand.Parameters.Add(new SqlParameter("@Password",SqlDbType.VarChar,50));
myCommand.Parameters.Add(new SqlParameter("@Cookie",SqlDbType.Int));
myCommand.Parameters["@Username"].Value = userName;
myCommand.Parameters["@Password"].Value = password;
myCommand.Parameters["@Cookie"].Value = cookie; SqlDataReader rs = objLogin.executeQuery(myCommand);
if(rs.Read())
{
。
}
else
{
} rs.Close();
objLogin.connClose();
{
if (m_myConnection==null)
{
m_myConnection=new SqlConnection(ConnectionString);
}
if(this.m_myConnection.State == System.Data.ConnectionState.Closed)
{
m_myConnection.Open();
}
this.m_PlanQueryDay=this.dtpPlanQueryDay.Value;
this.m_PlanNo=this.tbPlanNo.Text.Trim().ToString();
SqlCommand myCommand=new SqlCommand("LI_DayPlanQuery",m_myConnection);
myCommand.CommandType=System.Data.CommandType.StoredProcedure; myCommand.Parameters.Add("@Day",this.m_PlanQueryDay);
myCommand.Parameters.Add("@PlanNo",this.m_PlanNo);
System.Data.SqlClient.SqlDataAdapter com= new System.Data.SqlClient.SqlDataAdapter(myCommand );
Dataset1 ds= new Dataset1();
com.Fill(ds,"LI_DayPlanQuery" );
crDayPlanQuery MyReport = new crDayPlanQuery();
MyReport.SetDataSource(ds);
crystalReportViewer1.ReportSource = MyReport;
}
catch(Exception e1)
{
MessageBox.Show(e1.Message,"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
finally
{
m_myConnection.Close();
}
{
。
}
else
{
} rs.Close();
objLogin.connClose();
实现了什么?
lisoft2002(lisoft2002) 你真乖,厉害 厉害 佩服 佩服。
存储过程还是看看书吧,
sqlserver本身的帮助文档也介绍了。