2012.4.18
在CookieDemo.aspx.cs中
protected void btnCookie_Click()
{
if(Request.Cookies["BirthdayMonth"] == null)
{//using System.Globalization;
cookie = new HttpCookie("birthdayMonth",DateTime.Now.Month.ToString(CultureInfo.InvariantCulture));
Response.AppendCookie(cookie);
}
---
protected void Page_Load()
//using System.Configuration;
sdsCookie.ConnectionString = ConfigurationManager.ConnectionStrings["courseConnectionString"].ConnectionString;
sdsCookie.SelectCommand = "SELECT 身份证号码,姓名,性别,出生日期,部门 FROM 飞狐工作室 WHERE Month(出生日期) = @出生月份 AND 部门 = @部门名称";
sdsCookie.SelectParameters.Add(new CookieParameter("出生月份", "BirthdayMonth"));
sdsCookie.SelectParameters.Add(new CookieParameter("部门名称","Department"));
gvwCookie.DataSource = sdsCookie;
gvwCookie.EmptyDataText = "没有符合条件的数据";
gvwCookie.DataBind();
---------------------------------------
if(!IsPostBack)
{
//using System.Configuration;
sdsCookie.ConnectionString = ConfigurationManager.ConnectionStrings["courseConnectionString"].ConnectionString;
sdsCookie.SelectCommand = "SELECT 身份证号码,姓名,性别,出生日期,部门 FROM 飞狐工作室 WHERE Month(出生日期) = @出生月份 AND 部门 = @部门名称";
sdsCookie.SelectParameters.Add(new CookieParameter("出生月份", "BirthdayMonth"));
sdsCookie.SelectParameters.Add(new CookieParameter("部门名称","Department"));
gvwCookie.DataSource = sdsCookie;
gvwCookie.EmptyDataText = "没有符合条件的数据";
gvwCookie.DataBind();
}
-----------------------------------------
if(!IsPostBack)
{
sdsCookie.SelectParameters.Add(new CookieParameter("出生月份", "BirthdayMonth"));
sdsCookie.SelectParameters.Add(new CookieParameter("部门名称","Department"));
}
//using System.Configuration;
sdsCookie.ConnectionString = ConfigurationManager.ConnectionStrings["courseConnectionString"].ConnectionString;
sdsCookie.SelectCommand = "SELECT 身份证号码,姓名,性别,出生日期,部门 FROM 飞狐工作室 WHERE Month(出生日期) = @出生月份 AND 部门 = @部门名称";
gvwCookie.DataSource = sdsCookie;
gvwCookie.EmptyDataText = "没有符合条件的数据";
gvwCookie.DataBind();
---浏览时，添加cookie 出现信息表数据
添加FormView 控件 套用格式
--
<asp:Panel runat="server" ID="pnlComment" GroupingText="评论">
<asp:FormView ID="frmComment" runat="server" CellPadding="4" ForeColor="#333333"
Width="298px" DefaultMode ="Insert">
<InsertItemTemplate>
<asp:Label runat ="server" ID="lblComments" Text="请输入你对本书的评价"></asp:Label>
<asp:TextBox runat="server" ID="tbxComments" TextMode="MultiLine" Columns ="50" Rows="4" Text='<% #Bind("书评")%>'></asp:TextBox><br />
<asp:Button runat="server" ID="btComments" Text="提交" CommandName="Insert" />
</InsertItemTemplate>
</asp:FormView>
<asp:GridView runat="server" ID="gvwComments" DataSourceID="sdsComments"></asp:GridView>
<asp:SqlDataSource ID="sdsComments" runat="server" SelectCommand="SELECT 姓名,书评,日期 FROM 无责任书评 ORDER BY 编号 DESC" ConnectionString ="<%$ ConnectionStrings:courseConnectionString %>"></asp:SqlDataSource>
</asp:Panel>
--
在page_load写
if(Request.Cookies["YourName"] == null)
{
// string userName = "sa";
string userName = Request.LogonUserIdentity.Name;
HttpCookie cookie = new HttpCookie("Name",userName);
Response.AppendCookie(cookie);
}
--修改
<asp:SqlDataSource ID="sdsComments" runat="server" SelectCommand="SELECT 姓名,书评,日期 FROM 无责任书评 ORDER BY 编号 DESC" InsertCommand="INSERT INTO 无责任书评(姓名,书评) VALUES (@姓名,@书评)"
ConnectionString ="<%$ ConnectionStrings:courseConnectionString %>">
<InsertParameters>
<asp:CookieParameter runat="server" Name="姓名" CookieName="Name" />
</InsertParameters>
---------------------------------------
-----------------
#3366CC #009999
------------------
添加 Web窗体
CookieDemoWithoutMasterpage.aspx
----------------------------------------
在DataReceive.aspx.cs添加
if (VerifyUser(strName, strPassword))
{
Response.Cookies.Remove("Name");
Response.AppendCookie(new HttpCookie("Name", strName));
tbxResult.Text = "通过验证";
}
else
{
Response.Cookies.Remove("Name");
tbxResult.Text = "验证失败";
}
柳文冰 123456
Sql
用户账户- 打开表
无责任书评 - 右键 删除
--浏览
DataSend.aspx
添加成功 验证成功
