2003中datagrid的list使用

datagrid控件中autogeneratecolumns 属性为false
//-------------------------------------------------------------------
<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False">
                            <Columns>
                                <asp:TemplateColumn>
                                    <ItemTemplate>
                                        <a href='edit.aspx?id=<%#DataBinder.Eval(Container.DataItem,"n_id")%>' target=_blank>
                                            编辑</a> ·<a href='view.aspx?id=<%#DataBinder.Eval(Container.DataItem,"n_id")%>' target=_blank><%#DataBinder.Eval(Container.DataItem,"n_title")%></a>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                            </Columns>
                        </asp:DataGrid>


//--------------------------------------------------------------------------------------
  public CData myData = new CData();//调用组件中的类CData
        public DataSet ds = new DataSet();//将DataSet实例化
        protected void Page_Load(object sender, System.EventArgs e)
        {
            ds = myData.GetDataSet("Select * FROM socut_news", 0, 0, "TableName");
            DataGrid1.DataSource = ds;//设置数据源
            DataGrid1.DataBind();//绑定数据
        }
//------------------------------------------------------------------------------
web.config

<?xml version="1.0"?>
<configuration>
    <appSettings>
        <!--***************** 数据库的设置 *****************
 !— SocutDataCode：  数据库操作引擎授权码(自动判断域名)
 !— SocutDataLink：  数据库链接参数(自动判断类型)
 !— Access类型：     \安装目录\库名.mdb
 !— SQL Server类型： uid=用户名;pwd=密码;database=数据库;server=(local)
**************************************************-->
        <add key="SocutDataCode" value="00000000-00000000"/>
        <add key="SocutDataLink" value="\WebSite5\db\Socut.mdb"/>
        <!--***********************************************-->
    </appSettings>
    <system.web>
        <compilation defaultLanguage="c#" debug="true">
            <compilers>
                <compiler language="c#" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" extension=".cs" compilerOptions="/d:DEBUG;TRACE"/>
            </compilers>
        </compilation>
        <customErrors mode="Off"/>
        <authentication mode="Windows"/>
        <authorization>
            <allow users="*"/>
        </authorization>
        <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
        <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20"/>
        <globalization requestEncoding="gb2312" responseEncoding="gb2312"/>
        <pages validateRequest="false"/>
        <xhtmlConformance mode="Legacy"/>
    </system.web>
</configuration>



数据库下载:attachments/Socut.mdb
dll控件下载:attachments/Socut.Data.dll

[本日志由 admin 于 2008-06-03 01:44 AM 编辑]
文章来自: 本站原创
引用通告地址: http://www.is21.cn/trackback.asp?tbID=344
Tags: