Database

foreach (DataRow row dt.Rows) {
    listViewColumns.Items.Add(row[0].ToString());
}

string Sql = "select column_name from all_tab_columns where table_name = '" + sSelectedTable + "' order by column_id";
                       OleDbCommand Comm = new OleDbCommand(Sql, Conn);

                       listViewColumns.Items.Clear();

                       try
                       {
                           //List the schema info for the selected table
                           OleDbDataAdapter da = new OleDbDataAdapter(Sql, Conn);
                           DataTable dt = new DataTable();
                           da.Fill(dt);

                           foreach (DataRow row in dt.Rows)
                           {
                               listViewColumns.Items.Add(row[0].ToString());
                           }
                       }

PDTUM wrote:

Mr Holmes Shameel

PDTUM wrote:

PLEASE accept my apology...

PDTUM wrote:

I hope that you will want to respond to me the next time

select max(serialnumber), Name, City, State
  from YourTable
 group by Name, City, State

select yourtable.serialnumber, yourtable.name, yourtable.city, yourtable.state 
from yourtable 
Inner join (
    select Max(serialnumber), state
    from yourtable 
    group by state) as sub1
on yourtable.serialnumber = sub1.serialnumber 

AppDomain.CurrentDomain.SetData("DataDirectory", System.Environment.GetFolderPath(System.Environment.SpecialFolder.CommonApplicationData));//LocalApplicationData));

Emejulu JVT wrote:

Source=|DataDirectory|\electionsoft.sdf

ivo75 wrote:

I want to add 1 column in first table and column in query will be 4.