In datasource i have 5 columns and i want 3 columns data in particular dropdownlist having a distinct value...
plz help
You can try it this way: List<string> values = new List<string>(); using (SqlConnection conn = new SqlConnection()) { using (SqlCommand cmd = new SqlCommand(@"SELECT Col1, Col2, Col3, Col4 FROM MyTable", conn)) //change your table name { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { values.Add(reader[0].ToString()); values.Add(reader[1].ToString()); values.Add(reader[2].ToString()); values.Add(reader[3].ToString()); } … Read More