C#

InstitutionDataSetTableAdapters.BookSalesHeaderTableAdapter adapter = new Institution.InstitutionDataSetTableAdapters.BookSalesHeaderTableAdapter();
                //adapter.Adapter.SelectCommand is null at runtime

bacem smari wrote:

the first is how can i display the header of the columns?

bacem smari wrote:

the second is how can i get data from a data base .sdf and display it on the colomuns of my listview?

private void button1_Click(object sender, EventArgs e)
        {
            string wCS = @"Data Source =\Storage Card\ModeDifféré\BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn = new SqlCeConnection(wCS);
            SqlCeCommand command = sqlceconn.CreateCommand();
            command.CommandText = "SELECT [ID],[Magasin],[qtyonhand] from stocks where ID like @txt";
            SqlCeDataAdapter adapter = new SqlCeDataAdapter(command);
            SqlCeParameter txt = new SqlCeParameter("@txt", SqlDbType.NVarChar);
            txt.Value = textBox1.Text;
            command.Parameters.Add(txt);
            DataSet ds = new DataSet();
            adapter.Fill(ds);
            string[] str = new string[ds.Tables[0].Columns.Count];
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                for (int col = 0; col <= ds.Tables[0].Columns.Count-1; col++)
                {
                    //filling the array of string
                    str[col] = dr[col].ToString();
                }
                ListViewItem ii;
                ii = new ListViewItem(str);
                this.listView1.Items.Add(ii);
            }

        }

txt.Value = "%" + textBox1.Text + "%";

SELECT [ID],[Magasin],[qtyonhand] from stocks where ID like @txt

SELECT * FROM ...