Sorting a DropDownList? - C#, ASP.NET

Try it

-------Store Procedure-----(SQL)

USE [Your Database]
GO


CRATE PROC [dbo].[GetAllDataByID]

@ID int


AS
BEGIN
SELECT * FROM Your_Table
WHERE ID=@ID
ORDER BY Your_ColumnName
END

----------Default.aspx---------



>

<asp:DropDownList ID="ddlYourTable" runat="server"></asp:DropDownList>



---------Default.aspx.cs-------




protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)
{
List<YourTable> table= new List<YourTable>();

YourtableRepository tableRepo = new YourtableRepository();

int conuntryInfoID=1;

table= tableRepo.GetAllDataByID(ID);

ddlYourTable.DataSource = stateInfo;
ddlYourTable.DataTextField = "Your_ColumnName";
ddlYourTable.DataValueField = "ID";
ddlYourTable.DataBind();

}
}

-------LINQ Helper Class----





public class TableRepository

{

string connstr;

public TableRepository()
{
connstr = Settings.Default.YourTableConnectionString.ToString();
}

public List<YourTable> GetAllDataByID(int ID)
{
List<YourTable> table= new List<YourTable>();
using (YourTableDBDataContext dc = new YourTableDBDataContext ())
{
table= dc.GetAllDataByID(ID).ToList();
}
return table;
}
}