Windows Forms

Member 8387808 wrote:

I'm getting error Cannot insert explicit value for identity column in table 'Project_Table' when IDENTITY_INSERT is set to OFF

Member 8387808 wrote:

Another table Phases_table has dependency on Project_Table through FK constraint. Is the error because of this constraint?

Member 8387808 wrote:

Are there any sample examples on C# with MSSQL database which use multiple windows forms with multiples table linked in an hierarchy?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

lbxQuotes.DataSource = null;
lbxQuotes.DataSource = _quotes;
lbxQuotes.SelectionMode = SelectionMode.None;
lbxQuotes.SelectionMode = SelectionMode.One;

public void RefreshLbx()
{
    if (lbxQuotes.InvokeRequired)
    {
        lbxQuotes.Invoke(_refreshLbx);
    }
    else
    {
        lbxQuotes.DataSource = null;
        lbxQuotes.DataSource = _quotes;
    }
}

private delegate void RefreshLbxDg8();
private RefreshLbxDg8 _refreshLbx;

_refreshLbx = RefreshLbx;

rbsbscrp wrote:

Weird, I'm NOT running a method - I'm changing data... hmmm...

rbsbscrp wrote:

if the DataSource is instead a Property (which secretly runs a method).

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

You can NOT so much as touch ANY part of a control from a thread other than the one that created it, the UI (or startup) thread. This is where your entire problem comes from.

rbsbscrp wrote:

It just so *happens* that C# chooses internally to implement a timer via a separate new thread.

rbsbscrp wrote:

That is not *my* problem.

rbsbscrp wrote:

I found some code example for doing a "invoke" via a deleagate, etc., etc., and got it working.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Wow! You have such a myopic view of what's going on.

private delegate void RefreshLbxDg8();
private RefreshLbxDg8 _refreshLbx;
...
_refreshLbx = RefreshLbx;
...
public void RefreshLbx()
{
    if (lbxQuotes.InvokeRequired)
    {
        lbxQuotes.Invoke(_refreshLbx);
    }
    else
    {
        lbxQuotes.DataSource = null;
        lbxQuotes.DataSource = _quotes;
    }
}

Dave Kreskowiak wrote:

go write code for Linux.

rbsbscrp wrote:

No! (so there)

Dave Kreskowiak wrote:

Then quit bitching...

rbsbscrp wrote:

Me, I think this is a horrible and terribly primitive solution and design.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

rbsbscrp wrote:

the timer that I'm using is the System.Windows.Forms.Timer one

using System;
using System.Windows.Forms;
using System.Threading;
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            Thread.CurrentThread.Name = "UI Thread";
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            Text = String.Format("{0}, {1}", Thread.CurrentThread.Name, Environment.TickCount);
            // Thread.Sleep(1000); Try resizing after uncommenting this
        }
    }
}

// System.Windows.Forms.Timer.TimerNativeWindow
protected override void WndProc(ref Message m)
{
	if (m.Msg == 275)
	{
		if ((int)m.WParam == this._timerID)
		{
			this._owner.OnTick(EventArgs.Empty);
			return;
		}
	}
	else
	{
		if (m.Msg == 16)
		{
			this.StopTimer(true, m.HWnd);
			return;
		}
	}
	base.WndProc(ref m);
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        List<int> L1 = new List<int>();
        BindingList<int> L2 = new BindingList<int>();
        private void Form1_Load(object sender, EventArgs e)
        {
            L1.Add(1);
            L1.Add(2);
            L2.Add(11);
            L2.Add(22);
            listBox1.DataSource = L1;
            listBox2.DataSource = L2;
            this.button1.Click += new System.EventHandler(this.button1_Click);
            this.button2.Click += new System.EventHandler(this.button2_Click);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            L1.Add(3);  // adds a value to L1, but listBox1 does not display it until the binding is refresshed
            L2.Add(33); // adds a value to L2 and listBox2 is automatically refreshed to display it
        }

        private void button2_Click(object sender, EventArgs e)
        {
            // tell listBox1 to refresh the data
            ((CurrencyManager)this.BindingContext[L1]).Refresh();
        }
    }
}