views:

18

answers:

0

hi

after i make some query's in my C# program (Windows-CE)-the program start to be heavy.....

i use: dsView.dispose() and dsView.clear() or Cmd.dispose()

after and still the program work's very slow after 20-30 query's

ds = new DataSet();
            SQL = "SELECT * FROM MyCount  where Name = '" + txtMakat.Text.Trim() + "'";
            adp = new SqlCeDataAdapter(SQL, Form1.Conn);
            adp.Fill(ds, "MyCount");
            dataGrid1.DataSource = ds.Tables["MyCount"].DefaultView;
            adp.Dispose();
            ds.Clear();
            ds.Dispose();

or

 SQL = "DELETE  FROM MyCount where Line = '" + txtCode.Text.Trim() + "'";
            SqlCeCommand CMD = new SqlCeCommand(SQL, Form1.Conn);
            CMD.ExecuteNonQuery();
            CMD.Dispose();

what i do wrong ?

thank's in advance

related questions