DataList高级应用(响应按钮分页)

最新推荐文章于 2020-01-17 17:28:07 发布

TQY2008

最新推荐文章于 2020-01-17 17:28:07 发布

阅读量547

点赞数

文章标签： string output dataset object server asp

本文展示了一个使用ASP.NET进行数据绑定的例子，通过SQL查询从Northwind数据库中获取客户信息，并将其显示在一个易于导航的界面中。该示例涵盖了如何初始化数据、设置样式以及响应用户操作等功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Drawing" %>

<SCRIPT runat="server">
private CheckBox m_checkBox;
private string m_connString = "SERVER=localhost;DATABASE=Northwind;UID=sa;pwd=";
private string m_cmdCustmrs = "SELECT * FROM customers WHERE companyname LIKE '{0}%'";
private string m_cmdInitial = "SELECT DISTINCT substring(companyname, 1, 1) AS Initial FROM customers";

public void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
BindInitials();
}

private void BindInitials()
...{
DataSet _data = new DataSet();

    // Get the initials
    SqlDataAdapter _adapter = new SqlDataAdapter(m_cmdInitial, m_connString);
    _adapter.Fill(_data, "Initials");

Picker.DataSource = _data.Tables["Initials"].DefaultView;
Picker.DataBind();
}

private void BindData()
...{
BindData((string) ViewState["Initial"]);
}

private void BindData(string initial)
...{
    // Store the initial
    ViewState["Initial"] = initial;

    // Get the data
    string _cmdText = m_cmdInitial + ";";
    _cmdText += String.Format(m_cmdCustmrs, initial);
    SqlDataAdapter _adapter = new SqlDataAdapter(_cmdText, m_connString);
    DataSet _data = new DataSet();
    _adapter.Fill(_data);

    // Rename tables
    _data.Tables[0].TableName = "Initials";
    _data.Tables[1].TableName = "Customers";

    // Reset selected and edit items
    Customers.SelectedIndex = -1;
    Customers.EditItemIndex = -1;

    Picker.DataSource = _data.Tables["Initials"].DefaultView;
    Picker.DataBind();
    Customers.DataSource = _data.Tables["Customers"].DefaultView;
    Customers.DataBind();
}

public void SelectedIndexChanged(object sender, EventArgs e)
...{
    // Scroll into view
    if (Customers.SelectedIndex != -1)
    ...{
        string custID = (string) Customers.DataKeys[Customers.SelectedIndex];
        TheBody.Attributes["onload"] = String.Format("ScrollToElem('{0}')", custID);
    }
}

public void OnRefresh(object sender, EventArgs e)
...{
BindData();
}

private string SetCustomerName(object dataItem)
...{
    string _output = "<b>{0} - {1}</b>";
    DataRowView _row = (DataRowView) dataItem;
    _output = String.Format(_output, _row["customerid"], _row["companyname"]);

    return _output;
}

private string ShowInfoBar(object dataItem)
...{
    string color = (m_checkBox.Checked ?"blue" :"black");
    string _output = "<span style='color:{0};'>(<i>{1}, {2}</i>)</span>";
    DataRowView _row = (DataRowView) dataItem;
    _output = String.Format(_output, color, _row["contactname"], _row["contacttitle"]);

return _output;
}

private string ShowAddressBar(object dataItem)
...{
if (!m_checkBox.Checked)
return "";

    string color = (m_checkBox.Checked ?"blue" :"black");
    string _output = "<br><span style='color:{0};'>{1}, {2} ({3})<br>{4}</span>";
    DataRowView _row = (DataRowView) dataItem;
    _output = String.Format(_output, color, _row["address"], _row["city"], _row["country"], _row["Phone"]);

return _output;
}

private string SetHeader()
...{
string _text = "Customers [{0}]";
return String.Format(_text, (string) ViewState["Initial"]);
}

private string SetFooter()
...{
string _text = "{0} customer(s) found.";

ICollection _coll = (ICollection) Customers.DataSource;
return String.Format(_text, _coll.Count);
}

private Color GetBackColor(object dataItem)
...{
    string _initial = (string) ((DataRowView)dataItem)["Initial"];
    if (_initial == (string) ViewState["Initial"])
        return Color.Gray;
    return Color.LightCyan;
}

private Color GetForeColor(object dataItem)
...{
    string _initial = (string) ((DataRowView)dataItem)["Initial"];
    if (_initial == (string) ViewState["Initial"])
        return Color.White;
    return Color.Black;
}

private CheckBox FindCheckBox(Control container)
...{
    CheckBox ctl = (CheckBox) container.FindControl("ExpandButton");
    if (ctl == null)
        return null;

    // Must anticipate the state restoration here. When this function executes we're
    // in the middle of the DataBind call on the given RepeaterItem object and
    // before the ItemDataBound event fires. At this time, the Checked property of the
    // CheckBox (as well as the Text property of a TextBox) has not been updated yet.
    ctl.Checked = (Page.Request.Form[ctl.UniqueID]=="on");

    return ctl;
}

private void ItemCommand(object sender, DataListCommandEventArgs e)
...{
BindData(e.CommandName);
}
</SCRIPT>

<html>
<title>Customers</title>
<style>
a:hover ...{color:red;text-decoration:underline;}
a ...{text-decoration:none;}
</style>

<SCRIPT>
function ScrollToElem(custID)
...{
    var elem = document.all(custID);
    if (elem == null)
        return;
    elem.scrollIntoView(true);
}
</SCRIPT>

<asp:datalist runat="server" id="Picker" repeatlayout="flow" repeatdirection="horizontal" OnItemCommand="ItemCommand">
    <ItemTemplate>
            <asp:button runat="server" style="border:solid 1px gray;width=30px;"
                backcolor='<%# GetBackColor(Container.DataItem) %>'
                forecolor='<%# GetForeColor(Container.DataItem) %>'
                text='<%# DataBinder.Eval(Container.DataItem, "Initial")%>'
                commandname='<%# DataBinder.Eval(Container.DataItem, "Initial")%>' />
    </ItemTemplate>
</asp:datalist>

        <asp:checkbox runat="server" id="ExpandButton" />
        <asp:linkbutton runat="server" commandname="select"
            text='<%# SetCustomerName(Container.DataItem) %>' />
        <br>
        <%# ShowInfoBar(Container.DataItem) %>
        <%# ShowAddressBar(Container.DataItem) %>
        </span>
    </ItemTemplate>

    <SeparatorTemplate>
    </SeparatorTemplate>

    <FooterTemplate>
        </div>
        <div style="background-color:gray;color:white;height:20px;"> <b><%# SetFooter() %></b></div>
    </FooterTemplate>
</asp:datalist>
</div>

</form>
</body>
</html>