connection.Open(); DataSet dsa = new DataSet(); DataTable dt = new DataTable(); dsa.Tables.Add(dt); OleDbDataAdapter da = new OleDbDataAdapter(); da = new OleDbDataAdapter("SELECT [Order Status] from [Contacts]", connection); da.Fill(dt); order1.DataSource = dt; order1.DisplayMember = "Order Status"; connection.Close();
dt.AsEnumerable().ToList().ForEach(row=> { if (string.IsNullOrWhiteSpace(Convert.ToString(row[0]))) row.Delete(); }); dt.AcceptChanges();
SELECT [Order Status] from [Contacts] where [Order Status] Not NULL or [Order Status] != ''
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)