[2008/06/26]code

[2008/06/26]code [已结贴,结贴人:only_endure]

加为好友

发送私信

在线聊天

only_endure
大宋提刑官 Recite MSDN classic code :)
等级:
可用分等级：贫农
总技术专家分：12372
总技术专家分排名：1462
揭帖率：93.77%

发表于：2008-06-26 08:57:25 楼主

Repeater within Gridview in C# ASP.NET 2.0

HTML code

<div style="width:400px; font-family:Arial; font-size:small">
  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    Width="100%" GridLines="None">
    <Columns>
      <asp:TemplateField>
      <ItemTemplate>
        <div style="color:Blue;font-weight:bold">
          <asp:Label ID="Label1" runat="server" Text='<%#
          DataBinder.Eval(Container.DataItem,"compname") %>'></asp:Label>
        </div>
        <asp:Repeater ID="Repeater1" runat="server" DataSource='<%#DataBinder.Eval(
          Container, "DataItem.InnerVal") %>'>
        <ItemTemplate>
        <div style="padding-left:20px; padding-top:5px">
        <asp:Label ID="Label2" runat="server" Text='<%#
           DataBinder.Eval(Container.DataItem,"news") %>'></asp:Label>
        </div>
 
        </ItemTemplate>
        </asp:Repeater>
        <div style="text-align:right">
          <asp:HyperLink ID="link" runat="server">More</asp:HyperLink>
        </div>
        </ItemTemplate>
        </asp:TemplateField>
      </Columns>
    </asp:GridView>
</div>

C# code

using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class DevRnD_Datacontrol : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        binddata();
    }

    // Function to bind data in data controls..
    public void binddata()
    {
        string str = "Data Source=VS-NAVINCHANDRA\\SQLEXPRESS;Initial Catalog=dbNavin;Integrated Security=SSPI"; // your connection string here
        SqlConnection con = new SqlConnection(str);
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter("getCompNews", con); // name of your stored procedure,
        da.Fill(ds);

        ds.Relations.Add("InnerVal", ds.Tables[0].Columns["compname"], ds.Tables[1].Columns["compname"]);   // making a relation between two tables.
        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }

    // Bind url for more button...
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            HyperLink lnkMore = (HyperLink)e.Row.FindControl("link");
            Label lbl=(Label)e.Row.FindControl("Label1");
            lnkMore.NavigateUrl = "~/Company.aspx?cmp="+lbl.Text;
        }
    }
}

SQL code

Create Procedure [dbo].[getCompNews]

as 
begin
create table #Temp
(
compname varchar(50),
news varchar(150)
)

Insert into #Temp
select a.compname, b.news from Company as a

inner join CompNews as b on a.CompId=b.CompId order by compname


Select distinct compname from #Temp
select * from #Temp
end
drop table #Temp

问题点数：0 回复次数：8 修改删除举报引用回复

protected void Page_PreInit(object sender, EventArgs e) { string thm; thm = (string)Session["themeSelected"]; if (thm != null) { Page.Theme = thm; DropDownList1.Text = thm; } else { Session["themeSelected"] = DropDownList1.Text; Page.Theme = "Blue"; } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { Session["themeSelected"] = DropDownList1.Text; Server.Transfer(Request.FilePath);///重新刷新页面，待应用新的THEME样式 }

ListItem myListItem = SearchType.SelectedItem; ListItem crItem = null; String searchText = TextBox1.Text; if(myListItem.Value == "Name") { if(TextBox1.Text != "") { String searchSubfir = searchText.Substring(0,1); String searchSubsec = searchText.Substring(1); searchText = searchSubfir.ToUpper()+searchSubsec.ToLower(); // Search by country or region name. crItem = ItemCollection.FindByText(searchText); } } else { // Search by country or region code. crItem = ItemCollection.FindByValue(searchText.ToUpper()); } String str = "Search is successful. Match is Found.<br />"; str =str + "The results for search string '" + searchText + "' are:<br />"; str = str + "the country or region code is " + crItem.Value + "<br />"; str = str + "the country or region name is " + crItem.Text; // Add the string to the label. Label1.Text = str;

void gridView_RowDataBound(object sender, GridViewRowEventArgs e) { if(e.Row.RowType == DataControlRowType.DataRow) { DropDownList ddl = (DropDownList)e.Row.Cells[x].FindControl(dropDownList); // Cells[x]就是包含了dropdownlist控件的哪个列 ddl.SelectedValue = DataBinder.Eval(e.Row.DataItem, "列名").ToString(); // 或者： // DataRowView drv = (DataRowView)e.Row.DataItem; // ddl.SelectedValue = drv["列名"].ToString(); } }

public class BaseClass : System.Web.UI.Page { public void ChangeButtons() { foreach(Control ctrl in this.Form.Controls) { if (ctrl is Button) { ((Button)ctrl).Text = "Hello"; } } } } public partial class _Default : BaseClass { protected void Page_Load(object sender, EventArgs e) { ChangeButtons(); } }

protected void Page_Load(object sender, EventArgs e) { Table tbl = new Table(); TableRow r = new TableRow(); TableCell c = new TableCell(); Label l = new Label(); l.ID = "Label1"; l.Text = "A Label"; c.Attributes.Add("style", "border: solid 1px red; width:150px; height:20px"); c.Controls.Add(l); r.Cells.Add(c); tbl.Rows.Add(r); form1.Controls.Add(tbl); }

LinkButton lb = new LinkButton(); lb.ID = "lb1"; lb.Click += new EventHandler(Button_Click); void Button_Click(object sender, EventArgs e) { int key = int.Parse(((LinkButton)sender).CommandArgument); //Do something with the key. }

HTML> <HEAD> <title>One Time Clickable Button</title> <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <script language="javascript">  </script> </HEAD> <body> <form id="Form1" method="post" runat="server"> <asp:Button ID="btnSave" Text="Save" Runat="server"></asp:Button> </form> </body> </HTML>

Private Sub Page_Load(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles MyBase.Load btnSave.Attributes.Add("onclick", "DisableButton()") End Sub Private Sub btnSave_Click(ByVal sender As Object, _ ByVal e As System.EventArgs) Handles btnSave.Click System.Threading.Thread.Sleep(5000) Response.Write("Page has been saved.") End Sub