<asp:DataList runat = "server" ID = "DataList1">
<ItemTemplate>
<%# Eval("ContactName") %>
</ItemTemplate>
</asp:DataList>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataList1.DataSource = GetData("top 10");
DataList1.DataBind();
}
}
protected void btnMore_Click(object sender, EventArgs e)
{
DataList1.DataSource = GetData("");
DataList1.DataBind();
}
private DataSet GetData(string top)
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = "SELECT " + top + " * FROM Customers";
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
return ds;
}
}
}
}