string q = "select monthname from months"
datatable dtmonths = new datatable();
sqldataadapter sd = new sqldataadapter();
sd.Fill(dtmonths);
if (dtmonths.Rows.Count > 0)
{
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "January")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "February")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "March")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "April")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "May")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "June")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "July")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "August")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "September")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "October")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "November")
cbmonthstd.Items.Add(dr[0].ToString());
}
foreach(DataRow dr in dtmonths.Rows)
{
if (dr[0].ToString() == "December")
cbmonthstd.Items.Add(dr[0].ToString());
}
}In this code snippet you will learn sorting months in ComboBox using C#.
If u add month randomly and the try to fill combo box with that , the months will not be in order... to sort monthname take idea from below code:
