c# code --Dropdown code
private void FillBatch()
{
try
{
clsDataAccess da = new clsDataAccess();
da.AddTabletoDataset("SELECT Batch_Year,BatchId FROM Batch", "Batch");
if (da.DataSet.Tables["Batch"].Rows.Count > 0)
{
DDL_Batch.DataSource = da.DataSet.Tables["Batch"];
DDL_Batch.DataTextField = "Batch_Year";
DDL_Batch.DataValueField ="BatchId";
DDL_Batch.DataBind();
DDL_Batch.Items.Insert(0, "Select");
}
}
catch (Exception ex)
{
HandleException.SendMail(ex);
}
}
create table Batch (BatchId int,Batch_Year varchar(50))
database insert script
insert Batch values
(1,'2013'),(2,'2012'),
(3,'2011'),
(4,'2010'),
(5,'2009'),
(6,'2008'),
(7,'2007'),
(8,'2006'),
(9,'2005'),
(10,'2004')