关于DataGrid控件中实现超连接,help me.

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server">    protected void Page_Load(Object Src, EventArgs E )
    {
        SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI");        SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection);        DataSet ds = new DataSet();
        myCommand.Fill(ds, "Authors");        MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
        MyDataGrid.DataBind();
    }</script><body style="font: 10pt verdana">  <form runat="server">    <h3><font face="Verdana">Working with Master-Detail Relationships</font></h3>    <span id="Message" EnableViewState="false" style="font: arial 11pt;" runat="server"/><p>    <ASP:DataGrid id="MyDataGrid" runat="server"
      Width="800"
      BackColor="#ccccff"
      BorderColor="black"
      ShowFooter="false"
      CellPadding=3
      CellSpacing="0"
      Font-Name="Verdana"
      Font-Size="8pt"
      HeaderStyle-BackColor="#aaaadd"
      DataKeyField="au_id"
    >      <Columns>
          <asp:HyperLinkColumn
            DataNavigateUrlField="au_id"
            DataNavigateUrlFormatString="datagrid13_details.aspx?id={0}"
            Text="Get Details"
          />
      </Columns>    </ASP:DataGrid>  </form></body>
</html>

解决方案 »

  1.   

    hyperlinkColumn的TEXT属性我想是从数据库中读出来的，该如何呢？
      

  2.   

    呵呵，这个问题我好像已经回答过你了，现在中文版：
    实施步鄹：
    1.建立数据库，用于存放新闻，可以设置3列，ID,TITLE,CONTENT,URL。
    2.需要做2-3个界面，分别用于对新闻的管理：插入，更新，察看
    3.用DataGrid来显示新闻，把Title列转换成魔板列，然后进入魔板编辑器，把ItemTemplate
      中的Label删掉，拖一个linkButton过来，命名为lnkTitle,
      CommandName也设置为  lnkTitle.
    3.可以coding了。下面举例说明，如何用DataGrid来显示你的信息。
    private void Page_Load()
    {
    if(!this.IsPostBack)
    {
    SqlConnection cn=new SqlConnection(ConnectString);
    SqlCommand cmd=new SqlCommand("getNews",cn);
    cmd.CommandType=CommandType.StoredProcedure;
    SqlDataAdapter adp=new SqlDataAdapter();
    adp.SelectCommand=cmd;
    DataSet ds=new DataSet();
    adp.Fill(ds);
    myDataGrid.DataSource=ds.Tables[0].DefaultView;
    myDataGrid.DataBind();
    }
    }//在DataGrid的ItemDataBound事件里，书写如下代码：
    private void myDataGrid_ItemDataBound(object sender,DataItemEventArgs e)
    {
    LinkButton _lnk=(LinkButton)e.Item.FindControl("lnkTitle");
    string _url=e.Item.Cells[3].Text;      //URL列
    _lnk.Attributes["onclick"]="Javascript:window.open('"+_url+"');";
    }
    //以下是存储过程，在数据库里写
    Create Procedure getNews
    ()
    as
    Select * From News哎，实在不能再详细了，呵呵，希望对你有所帮助
      

  3.   

    <asp:datagrid id="DataGrid1" runat="server" Width="635px" OnPageIndexChanged=" DataGrid1_PageIndexChanged" PageSize="8" AllowPaging="True" AllowSorting="True" HeaderStyle-Font-Size="12" ItemStyle-Font-Size="2" AutoGenerateColumns="False" DataKeyField="c_id" CellPadding="6">
                                                        <FooterStyle font-size="Small"></FooterStyle>
                                                        <HeaderStyle font-size="12pt" font-names="楷体_GB2312" horizontalalign="Center"></HeaderStyle>
                                                        <PagerStyle nextpagetext="下一页" prevpagetext="上一页"></PagerStyle>
                                                        <ItemStyle font-size="9pt"></ItemStyle>
                                                        <Columns>
                                                                                                                    <asp:HyperLinkColumn DataNavigateUrlField="c_id" DataNavigateUrlFormatString="content.ASPX?c_ID={0}" DataTextField="c_title" HeaderText="标题" NavigateUrl="content.aspx">
                                                                <HeaderStyle width="425px"></HeaderStyle>
                                                            </asp:HyperLinkColumn>
                                                            <asp:TemplateColumn>
                                                                <HeaderStyle width="110px"></HeaderStyle>
                                                                <HeaderTemplate >
                                                                    时间 
                                                                </HeaderTemplate>
                                                                <ItemTemplate>
                                                                    <asp:Label ID="province_j" Runat="server" text='<%#DataBinder.Eval(Container.DataItem,"c_date")%>' />
                                                                </ItemTemplate>
                                                            </asp:TemplateColumn>
                                                            <asp:TemplateColumn>
                                                                <HeaderStyle width="60px"></HeaderStyle>
                                                                <HeaderTemplate>
                                                                    类别 
                                                                </HeaderTemplate>
                                                                <ItemTemplate>
                                                                    <asp:Label text='<%#DataBinder.Eval(Container.DataItem,"c_class")%>' Runat="server" ID="label_j" />
                                                                </ItemTemplate>
                                                            </asp:TemplateColumn>
                                                        </Columns>
                                                    </asp:datagrid>
      

  4.   

    http://dotnetjunkies.com/tutorials.aspx?tutorialid=505这篇文章讲的应该很详细了。