ASP.NET

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="order_id" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:BoundField DataField="order_id" HeaderText="order_id" 
            InsertVisible="False" ReadOnly="True" SortExpression="order_id" />
        <asp:BoundField DataField="order_date" HeaderText="order_date" 
            SortExpression="order_date" />
        <asp:BoundField DataField="order_value" HeaderText="order_value" 
            SortExpression="order_value" />
        <asp:BoundField DataField="order_status" HeaderText="order_status" 
            SortExpression="order_status" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:BoardGamesConnectionString %>" 
    SelectCommand="'OrderInfo'" SelectCommandType="StoredProcedure">
    <SelectParameters>
        <asp:Parameter Name="order_id" Type="Int32" />
        <asp:Parameter Name="order_value" Type="String" />
        <asp:Parameter Name="order_date" Type="String" />
        <asp:Parameter Name="order_status" Type="String" />
        <asp:SessionParameter Name="UserID" SessionField="UserID" 
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

ALTER PROCEDURE [dbo].[Orderinfo]

    @order_id int,
    @order_value nvarchar(max),
    @order_date nvarchar(max),
    @order_status nvarchar(max),
    @UserID int
   
    
AS

   Select order_id, order_date, order_value, order_status from Orders Where UserID=@UserID And order_status='Εκκρεμεί'

SiteAdminSoap website_stats = new add_website_stats.SiteAdminSoap();

add_website_stats.ConfigLogLocation[] logLocations = new add_website_stats.ConfigLogLocation[1];
add_website_stats.ConfigLogLocation logLocation = new add_website_stats.ConfigLogLocation();
logLocation.FilePath = @"C:\Inetpub\vhosts\website.com\statistics\logs\W3SVC37";
logLocation.FileWildcard = "*.log";
logLocations[0] = logLocation;

website_stats.AddSite3("xxxuser", "xxxpassword", "testUserName", "testPasswordHere", "myFirstName", "myLastName", 1, 333, "www.website.com/mychannel22", "W3Cex", logLocations, @"C:\Inetpub\vhosts\website.users\statistics\logs\SmarterLogDirectory", 0, @"C:\Inetpub\vhosts\website.users\statistics\logs\SmarterExportDirectory", "", -1);

SiteAdminSoap website_stats = new add_website_stats.SiteAdminSoap();

public ActionResult Index(){
  ViewBag.Clubs = db.Clubs.OrderByDescending(c => c.Name).ToList();
  ViewBag.Comps = db.Competitions.OrderByDescending(c => c.StartDate).ToList();
  ViewBag.Teams = db.Teams.OrderBy(t => t.Name).ToList();
  return View();
}

public IList<Competition> GetCompetitionList(int clubid)
{...}

public IList<Team> GetTeamList(int compid)
{...}

[AcceptVerbs(HttpVerbs.Get)]
public JsonResult LoadCompsByClubId(string clubid)
{
  var compsList = this.GetCompetitionList(Convert.ToInt32(clubid));
  var compsData = compsList.Select(m => new SelectListItem(){
			Text = m.Name,
			Value = m.Id.ToString()
			});
  return Json(compsData, JsonRequestBehavior.AllowGet);
}

[AcceptVerbs(HttpVerbs.Get)]
public JsonResult LoadTeamsByCompId(string compid)
{
  var teamsList = this.GetTeamList(Convert.ToInt32(compid));
  var teamsData = teamsList.Select(c => new SelectListItem(){
			Text = c.Division.Name,
			Value = c.Id.ToString()
			});
return Json(teamsData, JsonRequestBehavior.AllowGet);
}

public ActionResult PlayerList(Team team)
{
if (team == null)
{
return HttpNotFound();
}
  var players = from p in db.Sharks_Player
		join t in db.Sharks_Player_CompTeam
		on p.Id equals t.PlayerId
		orderby p.FirstName
		where t.CompTeam_Id == team.Id
		select p;
  return View(players);
}

<script type="text/javascript">
	$(document).ready(function () {
		$("#ddlClubs").change(function () {
			var clubid = $(this).val();
			$.getJSON("../Players/LoadCompsByClubId", { clubid: clubid },
                    function (compsData) {
                    	var select = $("#ddlComps");
                    	select.empty();
                    	select.append($('<option/>', {
                    		value: 0,
                    		text: "Select a Competition"
                    	}));
                    	$.each(compsData, function (index, itemData) {
                    		
                    		select.append($('<option/>', {
                    			value: itemData.Value,
                    			text: itemData.Text
                    		}));
                    	});

                    });
		});
		$("#ddlComps").change(function () {
			var compid = $(this).val();
			$.getJSON("../Players/LoadTeamsByCompId", { compid: compid },
				function (teamsData) {
					var select = $("#ddlTeams");
					select.empty();
					select.append($('<option/>', {
						value: 0,
						text: "Select a Team"
				}));
				$.each(teamsData, function (index, itemData) {
					select.append($('<option/>', {
					value: itemData.Value,
					text: itemData.Text
				}));
			});
		});
	});
});
</script>

 <p>
     @Html.DropDownListFor(Model => Model.Clubs, new SelectList(ViewBag.Clubs as System.Collections.IEnumerable, "Id", "Name"),
         "Select a Club", new { id = "ddlClubs" })

 </p>

 <p>

    @Html.DropDownListFor(Model => Model.Competitions, new SelectList(Enumerable.Empty<SelectListItem>(), "Id", "Name"),
        "Select a Competition", new { id = "ddlComps" })

 </p>

 <p>
    @using(Html.BeginForm("PlayerList", "Players", FormMethod.Get)){
	@Html.DropDownListFor(Model => Model.Teams, new SelectList(Enumerable.Empty<SelectListItem>(), "Id", "Name"),
          "Select a Team", new { id = "ddlTeams" })<input type="submit" value="Get Player List" />
    }
 </p>