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