Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It looks like you are just updating a column every second. It might be more efficient to make the datatable a property of the form and update that every second (i.e. there should be no need to reset the data source on the grid...this might be causing you a problem as it fires a lot of events when you do that). </p> <p>As per my comment, it looks like you only need to reload the datatable when the file system watcher event fires, and that should be the only time you rebind to your grid.</p> <p>In response to your comment your code should look something like below:</p> <pre><code>namespace XML { public partial class Form1 : Form { DataSet formBindingSource = null; public Form1() { InitializeComponent(); this.timer1.Enabled = true; this.timer1.Interval = 1000; this.timer1.Tick += new System.EventHandler(this.timer1_Tick); FileSystemWatcher incoming = new FileSystemWatcher(); incoming.Path = @"c:\"; incoming.NotifyFilter = NotifyFilters.LastAccess | NotifyFilters.LastWrite | NotifyFilters.FileName; incoming.Filter = "sites.xml"; incoming.Changed += new FileSystemEventHandler(OnChanged); incoming.EnableRaisingEvents = true; } public void OnChanged(object source, FileSystemEventArgs e) { formBindingSource = new DataSet(); using(FileStream stream1 = new FileStream("c:\\sites.xml", FileMode.Open)) { ds.ReadXml(stream1); } this.UpdateDataGrid(); dataGridView1.DataSource = formBindingSource.Tables[0]; } public void UpdateDataGrid() { if (this.InvokeRequired) { this.Invoke((MethodInvoker)delegate { UpdateDataGrid(); }); } else { //refresh column status evry second int count = 0; foreach (DataRow dr in formBindingSource.Tables[0].Rows) { DateTime SystemTime = Convert.ToDateTime(DateTime.Now); DateTime StartTime = Convert.ToDateTime(dr[0]); DateTime EndTime = Convert.ToDateTime(dr[1]); if (StartTime.TimeOfDay.Ticks &lt;= SystemTime.TimeOfDay.Ticks &amp;&amp; SystemTime.TimeOfDay.Ticks &lt; EndTime.TimeOfDay.Ticks) { ds.Tables[0].Rows[count][5] = "ok"; } else { ds.Tables[0].Rows[count][5] = "nok"; } count++; } formBindingSource.Tables[0].DefaultView.RowFilter = "date = #" + DateTime.Today + "#"; } } private void Form1_Load(object sender, EventArgs e) { //Load and bind file OnChanged(null,null) } private void timer1_Tick(object sender, EventArgs e) { this.UpdateDataGrid(); this.label1.Text = DateTime.Now.ToString("dddd, MMMM dd, yyyy hh:mm:ss tt"); } } } </code></pre> <p>Notice how there is a form level dataset called formBindingSource. When you update that your gird should update automatically without you having to reset the datasource for the grid. You only need to rebind when the file changes and you load a new dataset.</p> <p>(Also, its easier to use a <code>using</code> statement around your filestream code than what you have done)</p>
    singulars
    1. This table or related slice is empty.
    1. POticker and dataset datagrid view c#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMike Hanrahan
    1. USMike Hanrahan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POticker and dataset datagrid view c#
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COyes, I'm updating one column every second but ...I'm lost I don't know how to do that.:/
      singulars
      1. PO
      1. USuser1112847
    2. COI modified the code, but I m still in trouble, all it's fine. Except when I modify the data in the XML file the application crash. it Should be updating the datagridview when I modify the data into the xml file.
      singulars
      1. PO
      1. USuser1112847
    3. COSee if you can hook into the appdomains unhandled exception event and find out what the error message is. There is more info here - http://msdn.microsoft.com/en-us/library/system.appdomain.unhandledexception.aspx
      singulars
      1. PO
      1. USMike Hanrahan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload