meetweb--触网成就未来

2008年7月22日

Enterprise Library 3.1 简化使用范例一

笔者认为Enterprise Library 3.1 - May 2007提供的功能过于强大,可能项目里很多不需要.所以想简化使用

步骤一. 安装Enterprise Library 3.1 - May 2007

步骤二.建立你的项目.建立bin目录.引入Microsoft.Practices.EnterpriseLibrary.Data.dll

Microsoft.Practices.EnterpriseLibrary.Common.dll

步骤三.在web.config文件里建立一项

<connectionStrings>
    <add name="myconn" connectionString="Data Source=SEE-CLN-059\PMSERVER;Initial Catalog=test;User ID=sa;Password="
      providerName="System.Data.SqlClient" />
  </connectionStrings>

 

下面只展示如何读出数据的例子.其他跟你自己写类差不多效果啦

 

 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="enterprisetest.aspx.cs" Inherits="enterprisetest" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
   
    </div>
    </form>
</body>
</html>

 

 

codebehide

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Data;

public partial class enterprisetest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Database db = null;
        try
        {

            string strconn = "myconn";
            db = DatabaseFactory.CreateDatabase(strconn);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, "select   Class_ID,Class_Name,Class_Pid   from   TC_Class   order   by   Class_ID ");
            this.GridView1.DataSource = ds.Tables[0];
            this.GridView1.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message.ToString());

        }

       
    }
}

 

漏了一点提示.必须建立连接字符串在web.config里,否则会抛出异常.. :-)

 

 

posted @ 2008-07-22 15:35 meetweb 阅读(132) | 评论 (0) | 编辑

2008年7月21日

asp.net ajax实现在线人员的显示

vs2005+ajax要实现以前的效果实在是太简单啦.主要大家熟悉了AJAX Extensions几个控件.做起来就是跟以前的效果一样

 

大家见code吧

 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TTimer.aspx.cs" Inherits="TTimer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>
                <asp:Timer ID="Timer1" runat="server" OnTick="Timer1_Tick">
                </asp:Timer>
                <asp:GridView ID="GridView1" runat="server">
                </asp:GridView>
            </ContentTemplate>
        </asp:UpdatePanel>
   
    </div>
    </form>
</body>
</html>

 

 

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class TTimer : System.Web.UI.Page
{
    private DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!Page.IsPostBack)
        binddata();
    }
    private void binddata()
    {
        string sql = "select   Class_ID,Class_Name,Class_Pid   from   TC_User order   by   Class_ID ";
        string strconn = "Data Source=SEE-CLN-059\\PMSERVER;Initial Catalog=test;uid=sa;pwd=;";
        Conn conn = new Conn(strconn);

        ds = conn.GetSet(sql);
        this.GridView1.DataSource = ds.Tables[0];
        this.GridView1.DataBind();
    }
    protected void Timer1_Tick(object sender, EventArgs e)
    {
        binddata();
    }
}

当然遇到异常的情况请自己写异常错误显示吧...

posted @ 2008-07-21 16:09 meetweb 阅读(170) | 评论 (2) | 编辑

2008年7月18日

vs2005 的Menu功能简单使用

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Menu.aspx.cs" Inherits="Menu" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Menu ID="Menu1" runat="server" BorderStyle="None" Orientation="Horizontal">
        </asp:Menu>
   
    </div>
    </form>
</body>
</html>


代码好简单,其实就是不段写code添加,看来还是比较方便.. 就是样式还没有弄懂

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Menu : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            MenuItem mi1 = new MenuItem();
            MenuItem mi2 = new MenuItem();
            MenuItem mi3 = new MenuItem();
            mi1.Text = "aa";
            mi2.Text = "bb";
            mi3.Text = "cc";

            mi2.ChildItems.Add(mi3);
            mi1.ChildItems.Add(mi2);
            Menu1.Items.Add(mi1);

            MenuItem mi11 = new MenuItem();
            MenuItem mi12 = new MenuItem();
            MenuItem mi13 = new MenuItem();
            mi11.Text = "aa";
            mi12.Text = "bb";
            mi13.Text = "cc";

            mi12.ChildItems.Add(mi13);
            mi11.ChildItems.Add(mi12);
            Menu1.Items.Add(mi11);
        }
    }
}

posted @ 2008-07-18 13:59 meetweb 阅读(115) | 评论 (0) | 编辑
 
vs2005的treeview简单使用之无限级别菜单建立

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="webturnpage.aspx.cs" Inherits="webturnpage" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        &nbsp;</div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
        <webdiyer:AspNetPager ID="AspNetPager1" runat="server">
        </webdiyer:AspNetPager>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>&nbsp;
        <asp:ImageButton ID="ImageButton1" runat="server" OnClick="ImageButton1_Click" />
        <asp:TreeView ID="TreeView1" runat="server">
            <HoverNodeStyle BackColor="#FFFFC0" BorderColor="Lime" />
        </asp:TreeView>
    </form>
</body>
</html>



using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class webturnpage : System.Web.UI.Page
{
    DataSet ds=new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        Bind_TreeView();
      
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {

    }

    private void Tree_Infor(int ParentID, TreeNodeCollection pNode)//treeview树型目录
    {
        DataRow[] rows = ds.Tables[0].Select("Class_Pid= ' " + ParentID + " ' ");
        foreach (DataRow row in rows)
        {
            TreeNode Node = new TreeNode();
            Node.Text = row["Class_Name"].ToString();
            Node.Value = row["Class_ID"].ToString();
            pNode.Add(Node);
            Node.Expand();
            Tree_Infor(Convert.ToInt32(row[0]), Node.ChildNodes);
        }
    }
    void Bind_TreeView()
    {
      
        string sql="select   Class_ID,Class_Name,Class_Pid   from   TC_Class   order   by   Class_ID ";
        string strconn = "Data Source=SEE-CLN-059\\PMSERVER;Initial Catalog=test;uid=sa;pwd=;";
        Conn conn = new Conn(strconn);
     
        ds = conn.GetSet(sql);
        TreeNodeCollection Node = new TreeNodeCollection();
        TreeNode TN = new TreeNode();
        TN.Text = "根目录 ";
        TN.Value = "0 ";
        Node = this.TreeView1.Nodes;
        Node.Add(TN);
        Tree_Infor(0, TN.ChildNodes);

    }

}

posted @ 2008-07-18 10:13 meetweb 阅读(95) | 评论 (0) | 编辑

2007年4月29日

vs2005的cookies删除

   前言：一个朋友在一个项目中提到，到底如何删除cookies.网络里也有很多人提出这样的问题。
现把我的解决方式共享一下
代码很简单，自己看看就明白
public partial class Cookies : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
       
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
     //清除cookies
       // Request.Cookies..clear();
        //将cookies["username"]置空
        HttpCookie usercookie = Request.Cookies["username"];
      
       usercookie.Expires = System.DateTime.Now.AddDays(-10);
       // usercookie.Expires=.AddDays(-1.0);
        Response.Cookies.Add(usercookie);
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
//读取cookies
        HttpCookie mycookie = Request.Cookies["username"];
      
        Response.Write(mycookie.Value);
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
//写入cookies
        HttpCookie usercookie = new HttpCookie("username", "test");
        //usercookie.Expires = System.DateTime.Now.AddMinutes(1);
        usercookie.Expires = System.DateTime.Now.AddDays(1);
        Response.Cookies.Add(usercookie);
    }
}

综上所述，其实方法就是将时间改为失效时间点

posted @ 2007-04-29 10:26 meetweb 阅读(163) | 评论 (0) | 编辑

2007年4月16日

vs2005下实现梅花雪JS日历的解决方案

    以前vs2002 vs2003很多项目都应用了js的日历控件，但是很多人提出vs2005使用该控件出现问题。
通过网络查询，很多人提出了解决方案。
 
   以下见aspx代码
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="calender.aspx.cs" Inherits="calender"  ResponseEncoding="GB2312" EnableEventValidation ="false"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
    <script src ="calendar.js" type="text/javascript"></script>
</head>
<body>

    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server" onFocus="calendar()" ></asp:TextBox>
        </div>
    </form>
</body>
</html>

//calendar.js 代码是日历的javascript代码，网络里一大堆。

大家注意到没有，一般vs生成的.aspx代码里是
<%@ Page Language="C#" AutoEventWireup="true" AutoEventWireup="true" CodeFile="calender.aspx.cs" Inherits="calender" %>
你需要人为的加上以下代码
ResponseEncoding="GB2312" EnableEventValidation ="false"
结果为
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="calender.aspx.cs" Inherits="calender"  ResponseEncoding="GB2312" EnableEventValidation ="false"%>

其实说白啦就是中文编码的问题。相信大家看到这里都明白啦。
如果那位没有以上的js代码，可以发email给我，我会发给你们

posted @ 2007-04-16 16:45 meetweb 阅读(448) | 评论 (2) | 编辑

2007年3月16日

Ajax联动下拉框的实现例子

 AjaxPro.dll 下载地址  http://ajaxpro.schwarz-interactive.de/download/ajaxpro.zip 

Web.Config
<?xml version="1.0"?>
<configuration>
 <system.web>
      <httpHandlers>
   <add verb="POST,GET" path="ajax/*.ashx" type="Ajax.PageHandlerFactory, Ajax" />
   <add verb="POST,GET" path="ajaxpro/*.ashx" type="AjaxPro.AjaxHandlerFactory,AjaxPro.2"/>
  </httpHandlers>
 </system.web>
</configuration>

AjaxTest.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AjaxTest.aspx.cs" Inherits="AjaxTest" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>

</head>

<body>
<script language="javascript" type="text/javascript">
function areaResult()
{
var area=document.getElementById("DropDownList1");
//alert(area.value);
AjaxTest.GetCityList(area.value,get_city_Result_CallBack);
}
function get_city_Result_CallBack(response)
{
if (response.value != null)
{
  document.all("DropDownList2").length=0;　　　　
  var ds = response.value;
  if(ds != null && typeof(ds) == "object" && ds.Tables != null)
  {
   for(var i=0; i<ds.Tables[0].Rows.length; i++)
　 {
　　 var name=ds.Tables[0].Rows[i].name;
　　 var id=ds.Tables[0].Rows[i].id;
　　 document.all("DropDownList2").options.add(new Option(name,id));
　 }
　 //document.all("TextBox1").value="";　　
 }
}
return
}

</script>
  <form id="form1" runat="server">
      &nbsp;&nbsp;
 <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList>
        <asp:DropDownList ID="DropDownList2" runat="server">
        </asp:DropDownList>&nbsp;
      <br />
    </form>
</body>
</html>

AjaxTest.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MeetWeb;
public partial class AjaxTest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxTest));
       if (!Page.IsPostBack)
       {
           BindData();

       }
    }
    private void BindData()
    {
        DataSet ds = new DataSet();
          String sql = "Select id,name from test";
          try
          {
              ds = GetDataSet(sql, "test");
              this.DropDownList1.DataSource = ds.Tables[0];
              this.DropDownList1.DataTextField = "name";
              this.DropDownList1.DataValueField = "id";
              this.DropDownList1.DataBind();
              this.DropDownList1.Attributes.Add("onclick", "areaResult();");
          }
          catch (Exception ex)
          {
              Response.Write(ex.Message);
          }
    }

    public static DataSet GetDataSet(string sql,string aa)
    {
        MeetWeb.SqlDataBase a = new MeetWeb.SqlDataBase("server=localhost\\PMSERVER;uid=sa;pwd=sa;database=test");
        DataSet ds = new DataSet();
        ds=a.CreateSet(sql, aa);
        return ds;
    }

    [AjaxPro.AjaxMethod]
    public DataSet GetCityList(int id)
    {
        string sql = "select name from test where id='" + id + "'";
        return GetDataSet(sql,"test");
    }


}

posted @ 2007-03-16 14:38 meetweb 阅读(531) | 评论 (2) | 编辑

2007年3月2日

vs2005下使用ASPNetPage分页的例子1
页面设计
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
        <webdiyer:AspNetPager ID="AspNetPager1" runat="server" PageSize="1" OnPageChanged="AspNetPager1_PageChanged" OnPageChanging="AspNetPager1_PageChanging">
        </webdiyer:AspNetPager>
    </div>
    </form>
</body>
</html>

CodeBehide

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

        string strsql;

        //统计总的记录数

        SqlConnection Conn = new SqlConnection();

        Conn.ConnectionString = @"server=localhost\\PMSERVER;uid=;pwd=;database=test";
        try
        {
            MeetWeb.SqlDataBase a = new MeetWeb.SqlDataBase("server=localhost\\PMSERVER;uid=sa;pwd=;database=test");
    

            strsql = " Select count(ID) from test";

            DataSet ds = new DataSet();

            SqlDataAdapter Adp = a.CreateAdapter(strsql);

            Adp.Fill(ds, "test"); this.AspNetPager1.RecordCount = System.Convert.ToInt32(ds.Tables[0].Rows[0][0]);

          
            Response.Write(ds.Tables[0].Rows[0][0]);
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
 BindData();
    }

    private void BindData()
    {

        string strsql;

        int RecordPage = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize;

       
   

        strsql = String.Format(" Select Top  {0} *  From test Where  Id Not in ( Select Top {1} Id From test  Order By ID Desc) Order By ID Desc", AspNetPager1.PageSize.ToString(), RecordPage.ToString());
        DataSet ds = new DataSet();
        MeetWeb.SqlDataBase a = new MeetWeb.SqlDataBase("server=;uid=;pwd=;database=test");
    
        SqlDataAdapter Adp =a.CreateAdapter(strsql);

        Adp.Fill(ds, "test");

        this.GridView1.DataSource = ds.Tables["test"];

        this.GridView1.DataBind();

        //动态设置用户自定义文本内容

        Adp.Dispose();

        AspNetPager1.CustomInfoHTML= "记录总数：<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";

        AspNetPager1.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";

        AspNetPager1.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";

    }

//注意这里 和vs2003有区别
 protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;

        BindData();

        System.Text.StringBuilder sb = new StringBuilder("<script Language=\"Javascript\"><!--\n");


        sb.Append("var el=document.all;");

        sb.Append(this.GridView1.ClientID);

        sb.Append(".scrollIntoView(true);");

        sb.Append("<");

        sb.Append("/");

        sb.Append("script>");

        if (!ClientScript.IsStartupScriptRegistered("scrollScript"))

            ClientScript.IsStartupScriptRegistered(sb.ToString());
    }

posted @ 2007-03-02 10:04 meetweb 阅读(528) | 评论 (1) | 编辑

2006年9月19日

vs2005建立页面的主题
 

建立页面的主题

1.       建立一个新的目录App_Themes 在你的网站

注意你的目录必须命名为App_Themes

2.       建立一个子目录在你的App_Themes下去装载你的主题文件。

例如建立一个BlueTheme目录

3.       添加文件到你子目录下。例如添加Button.skin

4.       在button.skin里写如下语句

 

<asp:Button runat="server"

 BackColor="Red"

 ForeColor="White"

 Font-Name="Arial"

 Font-Size="18px" SkinID="aa" />

 

<asp:Button runat="server"

 BackColor="Red"

 ForeColor="blue"

 Font-Name="Arial"

 Font-Size="18px" />

在WebSite中应用你的主题

1 在web.config里加入pages元素

 <configuration>

    <system.web>

          <pages theme="BlueTheme" />

    </system.web>

</configuration>

注意。这里的theme为你的子目录名称

 

2页面中使用

<asp:Button ID="Button1" runat="server" Text="Button" SkinID=aa/>

<asp:Button ID="Button2" runat="server" Text="Button" />

这样你看看你的效果

 How to: Disable ASP.NET Themes
To disable themes for a page

<%@ Page EnableTheming="false" %>

To disable themes for a control

<asp:Calendar id="Calendar1" runat="server" EnableTheming="false" />

动态更改主题   
protected void Page_PreInit(object sender, EventArgs e)
{

    this.Button2.SkinID = "aa";
    }

posted @ 2006-09-19 16:29 meetweb 阅读(113) | 评论 (0) | 编辑

2006年8月7日

关于一个算法的求解
问题如下：
 

有20万条MDB格式写的数据，要隔一条数据删除三条数据，剩下5万条数据。

 然后建多一个新数据库，格式我发给你

 

比如旧数据库字段为

 a   b   c   d   e 等共5个

新数据库字段为 11 22 共2个 要把 11换成a 22换成b+c+d 
posted @ 2006-08-07 22:11 meetweb 阅读(62) | 评论 (0) | 编辑
仅列出标题  下一页
 
Powered by:
博客园
Copyright © meetweb