在一个已有的网站上加上Microsoft.Web.Atlas

最新推荐文章于 2009-04-28 11:32:00 发布

Open2ye

最新推荐文章于 2009-04-28 11:32:00 发布

阅读量1.5k

点赞数

分类专栏： Asp.net 文章标签： assembly string asp server compilation authentication

Asp.net 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

建一个 Bin 目录　　将 Microsoft.Web.Atlas.dll 复制进去

打开Web.Config 在

在“ <system.web>”内加入

3.在aspx文件中加入Atlas 例如

ajax.aspx

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

<!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 id="Head1" runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
   <input type="text" id="asdf" />
        <atlas:ScriptManager ID="s1" runat="server" EnablePartialRendering="true" />

        <atlas:UpdatePanel ID="u1" runat="server">
            <ContentTemplate>


                <asp:GridView ID="GridView1" DataSourceID="ObjectDataSource1" DataKeyNames="ID" AutoGenerateColumns="false"
                    AutoGenerateEditButton="true" AutoGenerateDeleteButton="true" runat="Server">
                    <Columns>
                        <asp:BoundField DataField="Name" />
                        <asp:BoundField DataField="Des" />
                    </Columns>
                </asp:GridView>


                <asp:ObjectDataSource ID="ObjectDataSource1" TypeName="ProductInfo" SelectMethod="GetProducts"
                    UpdateMethod="UpdateProduct" DeleteMethod="DeleteProduct" runat="Server">
                    <UpdateParameters>
                        <asp:Parameter Name="ID" Type="Int32" />
                        <asp:Parameter Name="Name" />
                        <asp:Parameter Name="Des" />
                    </UpdateParameters>
                </asp:ObjectDataSource>


            </ContentTemplate>
        </atlas:UpdatePanel>
    </form>
</body>
</html>

ProductInfo.cs

using System;
using System.Data;
using System.Data.SqlClient;

public class ProductInfo
{
const string conString =
@"Data Source=./SQLEXPRESS;AttachDbFilename=c:/t/DataSourceDemo/App_Data/ASPNETDB.mdf;Integrated Security=True;User Instance=True";

    public static SqlDataReader GetProducts()
    {
        SqlConnection con = new SqlConnection(conString);
        string selectString = "SELECT * FROM Products";
        SqlCommand cmd = new SqlCommand(selectString, con);
        con.Open();

        SqlDataReader dtr =
          cmd.ExecuteReader(CommandBehavior.CloseConnection);
        return dtr;
    }

    public static void UpdateProduct(int Id,string Name, string des)
    {
        SqlConnection con = new SqlConnection(conString);
        string updateString = "UPDATE Products SET " +
          "Name=@Name,Des=@Des " +
          "WHERE ID=@Id";
        SqlCommand cmd = new SqlCommand(updateString, con);
        cmd.Parameters.AddWithValue("@Id", Id);
        cmd.Parameters.AddWithValue("@Name", Name);
        cmd.Parameters.AddWithValue("@Des", des);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
    }

    public static void DeleteProduct(int Id)
    {
        SqlConnection con = new SqlConnection(conString);
        string deleteString = "DELETE Products " +
          "WHERE ID=@Id";
        SqlCommand cmd = new SqlCommand(deleteString, con);
        cmd.Parameters.AddWithValue("@Id", Id);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
    }

}

Web.Config

<?xml version="1.0"?>