<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:test1ConnectionString %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SELECT quran_simple.text, trjm_fa_ayati.tr AS Expr5 FROM trjm_fa_ayati INNER JOIN quran_simple ON trjm_fa_ayati.ID = quran_simple.id"></asp:SqlDataSource> </div> <br /> <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="text" HeaderText="text" SortExpression="text" /> <asp:BoundField DataField="Expr5" HeaderText="Expr5" SortExpression="Expr5" /> </Columns> </asp:GridView> <br /> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> <asp:ListItem>Test1</asp:ListItem> <asp:ListItem>Test2</asp:ListItem> <asp:ListItem>Test3</asp:ListItem> </asp:DropDownList> <br /> <br /> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Query; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { switch (DropDownList1.SelectedIndex) { case 0: SqlDataSource1.SelectCommand = "SELECT quran_simple.text, trjm_fa_moezzi.tr AS Expr5 FROM trjm_fa_moezzi INNER JOIN quran_simple ON trjm_fa_moezzi.ID = quran_simple.id"; GridView1.DataBind(); break; case 1: SqlDataSource1.SelectCommand = "SELECT quran_othmani.text, trjm_fa_makarem.tr AS Expr5 FROM trjm_fa_makarem INNER JOIN quran_othmani ON trjm_fa_makarem.ID = quran_othmani.id"; GridView1.DataBind(); break; case 2: SqlDataSource1.SelectCommand = "SELECT quran_othmani.text, trjm_fa_moezzi.tr AS Expr5 FROM trjm_fa_moezzi INNER JOIN quran_othmani ON trjm_fa_moezzi.ID = quran_othmani.id"; GridView1.DataBind(); break; default: break; } } }
protected void GridView1_PagIndexchangin(object sender, GridViewPageEventArgs e) { DropDownList1_SelectedIndexChanged(null,null) }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)