public void bindrow() { using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT [Event_Name] FROM [Event1];")) { cmd.CommandType = CommandType.Text; cmd.Connection = conn; conn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); EventsList.DataTextField = ds.Tables[0].Columns["Event_Name"].ToString(); EventsList.DataSource = ds.Tables[0]; EventsList.DataBind(); conn.Close(); } } EventsList.Items.Insert(0, new ListItem("Select CLUB NAME", "0")); }