2011年10月14日

index.html

<script type="text/javascript">


        var xmlHttp;


        //创建XMLHttpRequest对象
        //目的:兼容浏览器
        function createXMLHttpRequest() {
            if (window.ActiveXObject) {
                xmlHttp = new ActiveXObject("Microsoft.XMLHttp");
            }
            else if (window.XMLHttpRequest) {
                xmlHttp = new XMLHttpRequest();
            }
        }


        function StringBuilder() {

            var userName = document.getElementById("User").value;

            return encodeURI(encodeURI(userName)); //两次编码解决中文乱码问题
        }

 

   //当状态改变的时候

        function StateChange() {
            if (xmlHttp.readyState == 4 && xmlHttp.Status == 200) {
                var responseDiv = document.getElementById("back");
                responseDiv.innerHTML = decodeURI(xmlHttp.responseText); //解码
            }
        }

 

        //发送

        function SendToPage() {

            createXMLHttpRequest();

            var queryString = "Page_1.aspx?U=";
            queryString += StringBuilder();

            xmlHttp.open("GET", queryString);

            xmlHttp.onreadystatechange = StateChange;

            xmlHttp.send(null);
        }

 

<body>
    用户名:<input type="text" name="UserName" id="User" />
    <input type="button" name="btn" value="Show" onclick="SendToPage();" /><br />
    <div id="back">
    </div>
</body>

 

IsExists.aspx.cs

protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.QueryString["U"] != null)
            {
                Session["User"] = Request.QueryString["U"].ToString();
                Response.Write(Check());
                Response.End();
            }
        }

        protected string Check()
        {
            string sql = string.Empty;
            string res = string.Empty;

            if (Session["User"] != null)
            {
                sql = "select count(*) from T_Person where C_Name='" + Session["User"].ToString() + "'";
            }
            else
            {
                res = "error";
                return res;
            }

            if ((int)new SQLHelper().ExecuteScalar(sql) == 0)
            {
                res = "不存在该用户名!";
            }
            else
            {
                res = "已存在该用户名!";
            }
            return res;
        }


                
    </script>

posted @ 2011-10-14 19:50 Curitis 阅读(58) 评论(0) 编辑

2011年10月12日

1.querystring和a标签传值
  语法:目标页面?Text=所要传得值
  eg: "QuerystringTwo.aspx?Text=" + txtBox.Text.ToString();
  注释:这段代码是QuerystringOne.aspx的后台代码
 
2.session
  语法:在当前页面定义,运行当前页面不要关闭。接着运行目标页面,输出结果。
  eg:
  SessionOne.aspx:
  Session["Text"] = txtBox.Text.ToString();
 
  SessionTwo.aspx:
  Response.Write(Session["Text"].ToString());
 
3.Application
  语法: 定义和session一样,这个要在后面对目标页面进行指明
  eg:
  Application["Text"] = txtBox.Text.ToString();
  Server.Transfer("ApplicationTwo.aspx");
 
  string strText;
  Application.Lock();
  strText = Application["Text"].ToString();
  Response.Write(strText);
  Application.UnLock();
  
4.Cookie
   语法:要用到HttpCookie对象,可以想象成键值对
   eg:HttpCookie Cookie = new HttpCookie("Text");
          Cookie.Value = txtBox.Text.ToString();
          Response.AppendCookie(Cookie);
          Server.Transfer("CookieTwo.aspx");
     
          string strCookie= Response.Cookies["Text"].Value.ToString();
          Response.Write(strCookie);
         
5.Server.Transfer
   ServerOne页面
   public string StrText
        {
            get { return txtBox.Text; }
        }

        protected void btn_Click(object sender, EventArgs e)
        {
            Server.Transfer("ServerTwo.aspx");
        }
       
  protected void Page_Load(object sender, EventArgs e)
        {
            ServerOne serverOne=null;
            //定义第一个页面
            serverOne = (ServerOne)Context.Handler;
            Response.Write(serverOne.StrText.ToString());
        }

posted @ 2011-10-12 00:22 Curitis 阅读(9) 评论(0) 编辑

2011年10月11日

posted @ 2011-10-11 23:40 Curitis 阅读(1) 评论(0) 编辑
 

数据库脚本:

use master
go

if exists(select name from sys.databases where name='Test_Page')
drop database Test_Page
go

create database Test_Page
go

use Test_Page
go

--表:T_Person
if exists(select name from sys.objects where name='T_Person')
drop table T_Person
go

create table T_Person
(
 C_ID int identity(1,1),
 C_Name nvarchar(50),
 C_Address nvarchar(200),
 C_Call varchar(11),
 constraint PK_T_Person_C_ID primary key(C_ID)
)
go

--insert into T_Person(C_Name,C_Address,C_Call) values('curitsyang','广东深圳','12510441277')
--go

--存储过程;InsertIntoT_Person
if exists(select name from sys.objects where name='InsertIntoT_Person')
drop procedure InsertIntoT_Person
go

create procedure InsertIntoT_Person
as
 begin
 declare @i int
 set @i=0
 while(@i<10)
 begin
  insert into T_Person(C_Name,C_Address,C_Call) values('curitsyang','广东深圳','13510441277')
  set @i=@i+1
 end
 end
go

execute  InsertIntoT_Person
go

select * from T_Person
go

 

aspx:

<asp:Repeater ID="Repeater_1" runat="server">
            <HeaderTemplate>
                <div>
                </div>
                <table cellpadding="0" cellspacing="0" id="main">
                    <caption style="width: 450px; height: 40px; line-height: 45px; text-align: center;">
                        <strong>Person</strong></caption>
                    <tr>
                        <td>
                            编号
                        </td>
                        <td>
                            姓名
                        </td>
                        <td>
                            地址
                        </td>
                        <td>
                            电话
                        </td>
                    </tr>
            </HeaderTemplate>
            <ItemTemplate>
                <tr>
                    <td>
                        <%# Eval("C_ID") %>
                    </td>
                    <td>
                        <%# Eval("C_Name") %>
                    </td>
                    <td>
                        <%# Eval("C_Address") %>
                    </td>
                    <td>
                        <%# Eval("C_Call") %>
                    </td>
                </tr>
            </ItemTemplate>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
        <div style="margin-top: 5px;">
        </div>
        <webdiyer:AspNetPager ID="AnpFy" runat="server" AlwaysShow="true" FirstPageText="第一页"
            PrevPageTex="上一页" NextPageText="下一页" LastPageText="最后一页" PageSize="3" OnPageChanged="AspNetPage_Changed">
        </webdiyer:AspNetPager>

 

aspx.cs:

protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.Page.IsPostBack)
            {
                this.Bind();
            }
        }

        protected void Bind()
        {
            string sql = "select * from T_Person";

            Repeater_1.DataSource = PageFenYe(new SQLHelper().ExecuteDataTable(sql));

            Repeater_1.DataBind();
        }

        private PagedDataSource PageFenYe(System.Data.DataTable table)
        {
            this.AnpFy.RecordCount = table.Rows.Count;

            PagedDataSource pds = new PagedDataSource();

            pds.AllowPaging = true;

            pds.DataSource = table.DefaultView;

            pds.CurrentPageIndex = this.AnpFy.CurrentPageIndex - 1;

            pds.PageSize = this.AnpFy.PageSize;

            return pds;
        }

        protected void AspNetPage_Changed(object sender, EventArgs e)
        {
            this.Bind();
        }

posted @ 2011-10-11 16:06 Curitis 阅读(3) 评论(0) 编辑

2011年10月10日

 /// <param name="tableName">table名称</param>
        /// <param name="keyFieldName">主键字段名称</param>
        /// <param name="currentPageIndex">当前页码</param>
        /// <param name="pageCount">每页显示记录数</param>
        /// <param name="conditionString">限制条件字符串</param>
        /// <returns></returns>
        protected virtual string GetExecutePageingSql(string tableName, string keyFieldName, int currentPageIndex, int pageCount, string conditionString)
        {
            if (string.IsNullOrEmpty(tableName))
            {
                throw new ArgumentNullException("tableName");
            }

            if (string.IsNullOrEmpty(keyFieldName))
            {
                throw new ArgumentNullException("keyFieldName");
            }

            if (currentPageIndex < 0)
            {
                throw new ApplicationException(string.Format(@"currentPageIndex值为:{0},currentPageIndex必须大于等于1,该值不符合要求。", currentPageIndex));
            }

            if (pageCount < 1)
            {
                throw new ApplicationException(string.Format(@"pageCount值为:{0},pageCount必须大于等于1,该值不符合要求。", pageCount));
            }

            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.AppendFormat(@"select top {0} * from {1} where {2} not in(select top {3} {2} from {1}  where 1=1 {4}) {4};select count(*) from {1} where 1=1 {4};",
                pageCounts,
                tableName,
                keyFieldName,
                pageCount * (currentPageIndex - 1),
                conditionString);

            return Convert.ToString(stringBuilder);
        }

1=1可以理解成and

posted @ 2011-10-10 13:14 Curitis 阅读(16) 评论(0) 编辑

2011年10月9日

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="780" height="250">
  <param name="movie" value="imageshow.swf" />
  <param name="quality" value="high" />
  <param name="wmode" value="transparent" />
  <embed src="imageshow.swf" width="780" height="250" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" wmode="transparent"></embed>
</object>

 

改动上面的几处:

1.  <param name="movie" value="imageshow.swf" />
这个是flash的名称

 

2.只要是width和height改成自己flash大小就OK

posted @ 2011-10-09 20:14 Curitis 阅读(142) 评论(0) 编辑

2011年10月8日

摘要: 李炎恢老师视屏上面的 set rs = server.createobject("adodb.recordset") ' 创建一个表实例指派给 rs rs.open "择友俱乐部",conn,1,1 ' open 方法后面四个参数的个自含义 ' "择友俱乐部":表名 ' conn:连接对象 ' 1,1:这两个参数具体什么意思不用管,只要知道要是只对表中的数据进行查询就是1,1.要是要对表中的数据进行编辑的话就是:1,3 response.Write("恭喜你,找到指定表了!"阅读全文
posted @ 2011-10-08 16:00 Curitis 阅读(1) 评论(0) 编辑
 
摘要: <% dim conn ' 定义变量 set conn=server.createobject("adodb.connection") ' 创建一个数据库实例指派给 conn conn.connectionstring="Provider = Microsoft.Jet.OLEDB.4.0;Data Source="&server.mapPath("friend.mdb") ' 设置数据库的连接字符串 conn.open ' 打开数据库连接 response.Write("恭喜你阅读全文
posted @ 2011-10-08 15:58 Curitis 阅读(0) 评论(0) 编辑

2011年10月2日

摘要: <webdiyer:AspNetPager OnPageChanged="AspNetPager1_PageChanged" ID="AspNetPager1" runat="server" AlwaysShow="True" CustomInfoHTML="第%CurrentPageIndex%页,共%PageCount%页,每页%PageSize%条" CustomInfoSectionWidth="20%" CustomInfoTextAlign="Ce阅读全文
posted @ 2011-10-02 16:05 Curitis 阅读(4) 评论(0) 编辑
 
摘要: create procedure Page@pageIndex int,--当前第几页@pageSize int --每页多少条记录asbeginif(@pageIndex=1)select top (@pageSize) * from 表名 order by 字段名elseselect top (@pageSize) * from 表名 where 字段名 not in (select top (@pageSize*(@pageIndex-1)) 字段名 from 表名 order by 字段名) order by 字段名end阅读全文
posted @ 2011-10-02 16:03 Curitis 阅读(1) 评论(0) 编辑