C#

<br />
IF OBJECT_ID('TEMPDB..#SomeTmp)	IS NOT NULL DROP TABLE #SomeTmp<br />
CREATE TABLE #SomeTmp<br />
(<br />
	a datetime,<br />
	b float,<br />
	c float,<br />
        ...<br />
)<br />
// Some comment BLOWS UP HERE <br />
insert into #SomeTmp<br />
   exec SomeProc xxxxx

IF OBJECT_ID('TEMPDB..#SomeTmp) IS NOT NULL DROP TABLE #SomeTmp
CREATE TABLE #SomeTmp
(
a datetime,
b float,
c float,
...
GO
// insert into #SomeTmp
GO
exec SomeProc xxxxx
GO

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 + "%";