comparing the columns of two tables - C# Discussion Boards

Re: Is there any solution to design report instead of Crystal?

4-Apr-15 6:50

Have you considered MS-Access?

Rich reporting and a free runtime Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

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

Mycroft Holmes5-Apr-15 14:35

Mycroft Holmes

5-Apr-15 14:35

Choke cough spit you are really living up to your sig. Imagine inflicting Access on the poor bastard as a reporting tool, what a nightmare. Not as bad as CR but still has to be one of the lousiest choices.

Never underestimate the power of human stupidity
RAH

Re: Is there any solution to design report instead of Crystal?

Eddy Vluggen6-Apr-15 0:33

Re: Best way to Sync data

6-Apr-15 0:33

Mycroft Holmes wrote:
Imagine inflicting Access on the poor bastard as a reporting tool, what a nightmare

Howso?

I've used it without much problems Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

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

Best way to Sync data

Jassim Rahma3-Apr-15 11:55

Jassim Rahma

3-Apr-15 11:55

Hi,

I have a WinForm C# application with MySQL backend on the server in the company. The application needs to sync with a database on Web.

I thought of adding a is_synced field for the fields needs to be updated but then how can I sync? do I need to SELECT using the first mysql_local_connection and loop through avalable records then connect within the loop to mysql_cloud_connection and do the INSERT?

--> connect to mysql_local_connection
--> SELECT records need to be synced

--> While looping
--------> connect to mysql_cloud_connection
--------> INSERT or UPDATE
--> end loop

is this the best way to do it?

Thanks,
Jassim

Technology News @ www.JassimRahma.com

Afzaal Ahmad Zeeshan3-Apr-15 16:13

Afzaal Ahmad Zeeshan

3-Apr-15 16:13

If you want the best way to do this, then make sure your data is bound (Use binding[^]) and the Mode for binding is set to TwoWay, also that you're application is capturing every key stroke event and is updating the source by the target data (input). And once user has finished the work, commit the changes back to the database (this would ensure less latency delays).

Then you will be able to ensure (hopefully) that the data is synchronized among your Win Forms application and you MySQL database.

If you do not use data binding, then chances are that you're going handle events, create another background object to hold the data, then inside that class use other interfaces to commit data changes to database and so on. So, better is to use bindings.

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

comparing the columns of two tables

Member 107105323-Apr-15 2:49

Re: comparing the columns of two tables

3-Apr-15 2:49

I'm sorry if I'm wrong section...
I'm doing an application in C#. I have two tables "Audience" and "Schedule" in the database. These tables have the column "Number", which store different values. I need to select from the first table "Audience" in the column "Number" all the values that are not found in the column "Number" table "Schedule" and results displayed in dataGridView. Tell me please how to make a select? how to write a SQL query?

Peter Leow3-Apr-15 3:01

Peter Leow

3-Apr-15 3:01

Use NOT EXISTS in the WHERE clause of the SQL, e.g.

SQL

SELECT * FROM audience a
WHERE NOT EXISTS
(SELECT * FROM schedule s WHERE a.number = s.number)

Refer: https://technet.microsoft.com/en-us/library/ms184297%28v=sql.105%29.aspx[^]

Re: comparing the columns of two tables

Member 107105323-Apr-15 3:22

3-Apr-15 3:22

thank you so much! Smile | :)

error ExecuteReader()

Member 107105323-Apr-15 1:03

3-Apr-15 1:03

Can you please tell how to fix the error.The debugger gives an error in the string: "SqlDataReader dr = com.ExecuteReader();".
writes:"There is a designated team of Command open DataReader, which requires the prior close."
Help me please.

class DAL
    {
        string connectionString = @"Data Source=...";
        public ArrayList GetNumber()
        {
            ArrayList getNum = new ArrayList();
            SqlConnection con = new SqlConnection(connectionString);
            SqlCommand com = new SqlCommand("SELECT * FROM Graphik", con);
            con.Open();
            com.ExecuteReader();
            SqlDataReader dr = com.ExecuteReader();
            if (dr.HasRows)
            {
                foreach (DbDataRecord result in dr)
                    getNum.Add(result);
            }
            con.Close();
            return getNum;
        }
    }

Eddy Vluggen3-Apr-15 1:11

3-Apr-15 1:11

You can only have on DataReader open per Connection. Close the previous reader, or open a new connection.

Bastard Programmer from Hell Suspicious | :suss:

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

Member 107105323-Apr-15 1:57

3-Apr-15 1:57

do not quite understand what you mean. I need exactly this connection...

Sascha Lefèvre3-Apr-15 1:19

Sascha Lefèvre

3-Apr-15 1:19

Like Eddy Vluggen said - or use Multiple Active Resultsets (MARS):

https://msdn.microsoft.com/en-us/library/ms131686.aspx[^]
http://www.c-sharpcorner.com/uploadfile/sudhi.pro/multiple-active-result-sets-mars/[^]

Edit: As F-ES Sitecore has spotted, you executed the reader twice.

modified 3-Apr-15 7:50am.

Member 107105323-Apr-15 2:03

3-Apr-15 2:03

Oh yes, now I understand. two readers. thanks!
con.Open();
com.ExecuteReader();

F-ES Sitecore3-Apr-15 1:45

F-ES Sitecore

3-Apr-15 1:45

class DAL
    {
        string connectionString = @"Data Source=...";
        public ArrayList GetNumber()
        {
            ArrayList getNum = new ArrayList();
            SqlConnection con = new SqlConnection(connectionString);
            SqlCommand com = new SqlCommand("SELECT * FROM Graphik", con);
            con.Open();
            // remove the line below
            // com.ExecuteReader();
            SqlDataReader dr = com.ExecuteReader();
            if (dr.HasRows)
            {
                foreach (DbDataRecord result in dr)
                    getNum.Add(result);
            }
            con.Close();
            return getNum;
        }
    }

Sascha Lefèvre3-Apr-15 1:49

Sascha Lefèvre

3-Apr-15 1:49

Member 107105323-Apr-15 2:00

3-Apr-15 2:00

therefore, this line is not needed? oh, you are right. everything works, Thank you very much!

Merge with uEye cam capture program c# with c# socket programming (Server Only)

Richard Deeming7-Apr-15 2:37

Richard Deeming

7-Apr-15 2:37

You should also wrap the SqlConnection, SqlCommand and SqlDataReader objects in using blocks:

using (SqlConnection con = new SqlConnection(connectionString))
using (SqlCommand com = new SqlCommand("SELECT * FROM Graphik", con))
{
    con.Open();
    using (SqlDataReader dr = com.ExecuteReader(CommandBehavior.CloseConnection))
    {
        ...
    }
}

This ensures that the resources get cleaned up even if there is an exception.

Also, unless you're using .NET 1.0 or 1.1, you should replace ArrayList with List<DbDataRecord>:
List<T> Class (System.Collections.Generic)[^]
Generics (C# Programming Guide)[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Member 115345522-Apr-15 22:35

Member 11534552

2-Apr-15 22:35

Hi sir's/mam's

My question is somewhat simple to all i think but here is my problem. I have 2 program in c# using Visual Studio to program this software . But my problem is now i don't know how to merge/implement this both software and make it work.

2 programs are :
1 : uEye ActiveX Demo
2 : c# Socket threading socket programming (server only)

What Should it work for? (if you gonna ask)
=> it should work for connecting from client to server . the client will send a message , (probably an hexadecimal code), and the server will read and accept instruction to capture a picture and save it into the server's file folder it self.

so how to attach this both files and make it work?
Please Help

Below is the c# uEye ActiveX Demo program

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using System.Data;

namespace uEyeActiveXDemo_CS
{
    /// <summary>
    /// Zusammenfassung für Form1.
    /// </summary>
    public class Form1 : System.Windows.Forms.Form
    {
        private System.Windows.Forms.Button Init;
        private System.Windows.Forms.Button Snap;
        private System.Windows.Forms.Button Save;
        private System.Windows.Forms.Button Properties;
        private System.Windows.Forms.GroupBox groupBox1;
        private System.Windows.Forms.RadioButton TriggerSoftware;
        private System.Windows.Forms.RadioButton TriggerFalling;
        private System.Windows.Forms.RadioButton TriggerRising;
        private System.Windows.Forms.TextBox Info1;
        private System.Windows.Forms.TextBox Info2;
        private System.Windows.Forms.TextBox Info3;
        private System.Windows.Forms.ListBox InfoList;
        private bool m_bCameraOpen;
        private bool m_bLive;
        private Int64 m_MemAddr;
        private byte[] rgb;
        private bool m_bContinuousTriggerSupported;
        private int m_nCurrentMode;
        private int m_nTransferFailed;
        private int m_nTransferFailedOld;
        private Timer t1;

        private System.Drawing.Point LastPoint;
        private System.Windows.Forms.RadioButton TriggerOff;
        private System.Windows.Forms.Button CaptureImage;
        private System.Windows.Forms.CheckBox Direct3D;
        private AxuEyeCamLib.AxuEyeCam axuEyeCam;

        /// <summary>
        /// Erforderliche Designervariable.
        /// </summary>
        private System.ComponentModel.Container components = null;

        public Form1()
        {
            //
            // Erforderlich für die Windows Form-Designerunterstützung
            //
            InitializeComponent();
            m_bCameraOpen = false;
            rgb = new byte[3];
            m_MemAddr = 0;
            LastPoint = new System.Drawing.Point(0, 0);
            m_nCurrentMode = 0;
            m_nTransferFailed = 0;
            m_nTransferFailedOld = 0;

            t1 = new Timer();
            t1.Interval = 100;
            t1.Tick += new EventHandler(t1_Tick);
            t1.Start();
        }

        /// <summary>
        /// Die verwendeten Ressourcen bereinigen.
        /// </summary>
        protected override void Dispose( bool disposing )
        {
            if( disposing )
            {
                if (components != null) 
                {
                    components.Dispose();
                }
            }
            base.Dispose( disposing );
        }

        #region Vom Windows Form-Designer generierter Code
        /// <summary>
        /// Erforderliche Methode für die Designerunterstützung. 
        /// Der Inhalt der Methode darf nicht mit dem Code-Editor geändert werden.
        /// </summary>
        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
            this.Init = new System.Windows.Forms.Button();
            this.Snap = new System.Windows.Forms.Button();
            this.CaptureImage = new System.Windows.Forms.Button();
            this.Save = new System.Windows.Forms.Button();
            this.Properties = new System.Windows.Forms.Button();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.TriggerOff = new System.Windows.Forms.RadioButton();
            this.TriggerRising = new System.Windows.Forms.RadioButton();
            this.TriggerSoftware = new System.Windows.Forms.RadioButton();
            this.TriggerFalling = new System.Windows.Forms.RadioButton();
            this.Info1 = new System.Windows.Forms.TextBox();
            this.Info2 = new System.Windows.Forms.TextBox();
            this.Info3 = new System.Windows.Forms.TextBox();
            this.InfoList = new System.Windows.Forms.ListBox();
            this.Direct3D = new System.Windows.Forms.CheckBox();
            this.axuEyeCam = new AxuEyeCamLib.AxuEyeCam();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.axuEyeCam)).BeginInit();
            this.SuspendLayout();
            // 
            // Init
            // 
            this.Init.Location = new System.Drawing.Point(8, 8);
            this.Init.Name = "Init";
            this.Init.Size = new System.Drawing.Size(128, 24);
            this.Init.TabIndex = 0;
            this.Init.Text = "Init Camera";
            this.Init.Click += new System.EventHandler(this.Init_Click);
            // 
            // Snap
            // 
            this.Snap.Location = new System.Drawing.Point(8, 93);
            this.Snap.Name = "Snap";
            this.Snap.Size = new System.Drawing.Size(128, 24);
            this.Snap.TabIndex = 3;
            this.Snap.Text = "Freeze";
            this.Snap.Click += new System.EventHandler(this.Snap_Click);
            // 
            // CaptureImage
            // 
            this.CaptureImage.Location = new System.Drawing.Point(8, 64);
            this.CaptureImage.Name = "CaptureImage";
            this.CaptureImage.Size = new System.Drawing.Size(128, 24);
            this.CaptureImage.TabIndex = 2;
            this.CaptureImage.Text = "Stop capture";
            this.CaptureImage.Click += new System.EventHandler(this.Capture_Click);
            // 
            // Save
            // 
            this.Save.Location = new System.Drawing.Point(8, 36);
            this.Save.Name = "Save";
            this.Save.Size = new System.Drawing.Size(128, 24);
            this.Save.TabIndex = 1;
            this.Save.Text = "Save Image";
            this.Save.Click += new System.EventHandler(this.Save_Click);
            // 
            // Properties
            // 
            this.Properties.Location = new System.Drawing.Point(8, 368);
            this.Properties.Name = "Properties";
            this.Properties.Size = new System.Drawing.Size(128, 24);
            this.Properties.TabIndex = 11;
            this.Properties.Text = "Properties";
            this.Properties.Click += new System.EventHandler(this.Properties_Click);
            // 
            // groupBox1
            // 
            this.groupBox1.Controls.Add(this.TriggerOff);
            this.groupBox1.Controls.Add(this.TriggerRising);
            this.groupBox1.Controls.Add(this.TriggerSoftware);
            this.groupBox1.Controls.Add(this.TriggerFalling);
            this.groupBox1.Location = new System.Drawing.Point(8, 147);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Size = new System.Drawing.Size(128, 117);
            this.groupBox1.TabIndex = 5;
            this.groupBox1.TabStop = false;
            this.groupBox1.Text = "Trigger mode";
            // 
            // TriggerOff
            // 
            this.TriggerOff.Location = new System.Drawing.Point(12, 24);
            this.TriggerOff.Name = "TriggerOff";
            this.TriggerOff.Size = new System.Drawing.Size(88, 16);
            this.TriggerOff.TabIndex = 6;
            this.TriggerOff.Text = "Off";
            this.TriggerOff.Click += new System.EventHandler(this.TriggerOff_Click);
            // 
            // TriggerRising
            // 
            this.TriggerRising.Location = new System.Drawing.Point(12, 93);
            this.TriggerRising.Name = "TriggerRising";
            this.TriggerRising.Size = new System.Drawing.Size(88, 16);
            this.TriggerRising.TabIndex = 9;
            this.TriggerRising.Text = "Rising edge";
            this.TriggerRising.Click += new System.EventHandler(this.TriggerRising_Click);
            // 
            // TriggerSoftware
            // 
            this.TriggerSoftware.Location = new System.Drawing.Point(12, 47);
            this.TriggerSoftware.Name = "TriggerSoftware";
            this.TriggerSoftware.Size = new System.Drawing.Size(80, 16);
            this.TriggerSoftware.TabIndex = 7;
            this.TriggerSoftware.Text = "Software";
            this.TriggerSoftware.Click += new System.EventHandler(this.TriggerSoftware_Click);
            // 
            // TriggerFalling
            // 
            this.TriggerFalling.Location = new System.Drawing.Point(12, 70);
            this.TriggerFalling.Name = "TriggerFalling";
            this.TriggerFalling.Size = new System.Drawing.Size(96, 16);
            this.TriggerFalling.TabIndex = 8;
            this.TriggerFalling.Text = "Falling edge";
            this.TriggerFalling.Click += new System.EventHandler(this.TriggerFalling_Click);
            // 
            // Info1
            // 
            this.Info1.Location = new System.Drawing.Point(144, 370);
            this.Info1.Name = "Info1";
            this.Info1.ReadOnly = true;
            this.Info1.Size = new System.Drawing.Size(176, 20);
            this.Info1.TabIndex = 9;
            this.Info1.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
            // 
            // Info2
            // 
            this.Info2.Location = new System.Drawing.Point(320, 370);
            this.Info2.Name = "Info2";
            this.Info2.ReadOnly = true;
            this.Info2.Size = new System.Drawing.Size(224, 20);
            this.Info2.TabIndex = 10;
            this.Info2.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
            // 
            // Info3
            // 
            this.Info3.Location = new System.Drawing.Point(544, 370);
            this.Info3.Name = "Info3";
            this.Info3.ReadOnly = true;
            this.Info3.Size = new System.Drawing.Size(80, 20);
            this.Info3.TabIndex = 15;
            this.Info3.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
            // 
            // InfoList
            // 
            this.InfoList.Location = new System.Drawing.Point(8, 268);
            this.InfoList.Name = "InfoList";
            this.InfoList.SelectionMode = System.Windows.Forms.SelectionMode.None;
            this.InfoList.Size = new System.Drawing.Size(128, 95);
            this.InfoList.TabIndex = 10;
            // 
            // Direct3D
            // 
            this.Direct3D.Location = new System.Drawing.Point(20, 123);
            this.Direct3D.Name = "Direct3D";
            this.Direct3D.Size = new System.Drawing.Size(104, 20);
            this.Direct3D.TabIndex = 4;
            this.Direct3D.Text = "use Direct3D";
            this.Direct3D.CheckedChanged += new System.EventHandler(this.Direct3D_CheckedChanged);
            // 
            // axuEyeCam
            // 
            this.axuEyeCam.Enabled = true;
            this.axuEyeCam.Location = new System.Drawing.Point(144, 8);
            this.axuEyeCam.Name = "axuEyeCam";
            this.axuEyeCam.OcxState = ((System.Windows.Forms.AxHost.State)(resources.GetObject("axuEyeCam.OcxState")));
            this.axuEyeCam.Size = new System.Drawing.Size(480, 355);
            this.axuEyeCam.TabIndex = 16;
            // 
            // Form1
            // 
            this.AllowDrop = true;
            this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
            this.ClientSize = new System.Drawing.Size(632, 396);
            this.Controls.Add(this.axuEyeCam);
            this.Controls.Add(this.Direct3D);
            this.Controls.Add(this.Info3);
            this.Controls.Add(this.Info2);
            this.Controls.Add(this.Info1);
            this.Controls.Add(this.groupBox1);
            this.Controls.Add(this.Properties);
            this.Controls.Add(this.Save);
            this.Controls.Add(this.CaptureImage);
            this.Controls.Add(this.Snap);
            this.Controls.Add(this.Init);
            this.Controls.Add(this.InfoList);
            this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
            this.MaximizeBox = false;
            this.Name = "Form1";
            this.Text = "IDS uEye ActiveX";
            this.Load += new System.EventHandler(this.Form1_Load);
            this.Closing += new System.ComponentModel.CancelEventHandler(this.Form1_Closing);
            this.groupBox1.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.axuEyeCam)).EndInit();
            this.ResumeLayout(false);
            this.PerformLayout();

        }
        #endregion

        /// <summary>
        /// Der Haupteinstiegspunkt für die Anwendung.
        /// </summary>
        [STAThread]
        static void Main() 
        {
            Application.Run(new Form1());
        }

        private void Form1_Load(object sender, System.EventArgs e)
        {
            UpdateControls( );
        }

        private void Form1_Closing(object sender, System.ComponentModel.CancelEventArgs e)
        {
            axuEyeCam.ExitCamera();
        }

        private void UpdateControls( )
        {
            Save.Enabled = m_bCameraOpen;
            CaptureImage.Enabled = m_bCameraOpen;
            Snap.Enabled = m_bCameraOpen;
            Properties.Enabled = m_bCameraOpen;
            TriggerOff.Enabled = m_bCameraOpen;

            bool bTriggerSoftware = false;
            bool bTriggerLoHi = false;
            bool bTriggerHiLo = false;
            m_bContinuousTriggerSupported = false;

            if (m_bCameraOpen)
            {
                int nSupportedTriggerMode = axuEyeCam.SetExternalTrigger(uEye_defines.IS_GET_SUPPORTED_TRIGGER_MODE);
                if ((nSupportedTriggerMode & uEye_defines.IS_SET_TRIG_SOFTWARE) == uEye_defines.IS_SET_TRIG_SOFTWARE)
                {
                    bTriggerSoftware = true;
                }

                if ((nSupportedTriggerMode & uEye_defines.IS_SET_TRIG_LO_HI) == uEye_defines.IS_SET_TRIG_LO_HI)
                {
                    bTriggerLoHi = true;
                }

                if ((nSupportedTriggerMode & uEye_defines.IS_SET_TRIG_HI_LO) == uEye_defines.IS_SET_TRIG_HI_LO)
                {
                    bTriggerHiLo = true;
                }

                if ((nSupportedTriggerMode & uEye_defines.IS_SET_TRIGGER_CONTINUOUS) == uEye_defines.IS_SET_TRIGGER_CONTINUOUS)
                {
                    m_bContinuousTriggerSupported = true;
                }
            }

            TriggerSoftware.Enabled = m_bCameraOpen & bTriggerSoftware;
            TriggerFalling.Enabled = m_bCameraOpen & bTriggerHiLo;
            TriggerRising.Enabled = m_bCameraOpen & bTriggerLoHi;

            if( m_bCameraOpen )
            {
                Init.Text = "Exit Camera";
                Info1.Text = String.Format("{0} SerNo:{1}", axuEyeCam.GetSensorName(), axuEyeCam.GetSerialNumber());
                Info2.Text = String.Format("{0} x {1}", axuEyeCam.GetImageWidth().ToString(), axuEyeCam.GetImageHeight().ToString() );
                Direct3D.Checked = axuEyeCam.EnableDirect3D;
            }
            else
            {
                Init.Text = "Init Camera";
                Info1.Text = String.Format("No open camera");
                Info2.Text = "-";
                Info3.Text = "0 fps";

                TriggerOff.Checked = true;
            }

            if( axuEyeCam.EnableDirect3D )
            {
                Info2.Text = "Click to draw a cross!";
            }
        }

        private void Init_Click(object sender, System.EventArgs e)
        {
            m_MemAddr = 0;
            if( m_bCameraOpen )
            {
                axuEyeCam.ExitCamera();

                m_bCameraOpen = false;
                m_bLive = false;

                // Disable events
                axuEyeCam.EnableEvent( uEye_defines.IS_FRAME, 0 );  
                axuEyeCam.EnableEvent( uEye_defines.IS_DEVICE_REMOVED, 0 ); 
                axuEyeCam.EnableEvent( uEye_defines.IS_TRANSFER_FAILED, 0 );
                axuEyeCam.EnableEvent( uEye_defines.IS_TRIGGER, 0 );

                axuEyeCam.EventOnFrame -= axuEyeCam_EventOnFrame;
                axuEyeCam.EventOnTransferFailed -= axuEyeCam_EventOnTransferFailed;
                axuEyeCam.MouseMoveEvent -= axuEyeCam_MouseMoveEvent;
                axuEyeCam.MouseDownEvent -= axuEyeCam_MouseDownEvent;
            }
            else
            {
                int nRet = axuEyeCam.InitCamera (0);
                if (nRet == uEye_defines.IS_STARTER_FW_UPLOAD_NEEDED)
                {
                    int nUploadTime = 0;
                    axuEyeCam.GetDuration (uEye_defines.IS_STARTER_FW_UPLOAD, ref nUploadTime);

                    String Str;
                    Str = "This camera requires a new firmware. The upload will take about " + (nUploadTime / 1000).ToString() + " seconds.";

                    MessageBox.Show(Str);

                    nRet = axuEyeCam.InitCamera(0 | uEye_defines.IS_ALLOW_STARTER_FW_UPLOAD);
                }

                if (nRet == uEye_defines.IS_SUCCESS)
                {               
                    m_bCameraOpen = true;
                    m_bLive = true;

                    // Enable events
                    axuEyeCam.EnableEvent( uEye_defines.IS_FRAME, 1 );  
                    axuEyeCam.EnableEvent( uEye_defines.IS_DEVICE_REMOVED, 1 ); 
                    axuEyeCam.EnableEvent( uEye_defines.IS_TRANSFER_FAILED, 1 );
                    axuEyeCam.EnableEvent( uEye_defines.IS_TRIGGER, 1 );

                    axuEyeCam.EventOnFrame += axuEyeCam_EventOnFrame;
                    axuEyeCam.EventOnTransferFailed += axuEyeCam_EventOnTransferFailed;
                    axuEyeCam.MouseMoveEvent += axuEyeCam_MouseMoveEvent;
                    axuEyeCam.MouseDownEvent += axuEyeCam_MouseDownEvent;

                    m_nTransferFailed = 0;
                    m_nTransferFailedOld = 0;
                    InfoList.Items.Clear();
                    InfoList.Items.Add( String.Format( "{0} opened!", axuEyeCam.GetSensorName() ));

                    // Set the trigger timeout to 5 s (500 = 5000 ms)
                    axuEyeCam.SetTimeout(uEye_defines.IS_TRIGGER_TIMEOUT, 500);
                }
                else
                {
                    MessageBox.Show("Init failed","Could not open camera!");
                }
            }

            UpdateControls( );
        }

        private void Snap_Click(object sender, System.EventArgs e)
        {
            axuEyeCam.FreezeImage(uEye_defines.IS_DONT_WAIT);
            m_bLive = false;
            CaptureImage.Text = "Start capture";
        }

        private void Capture_Click(object sender, System.EventArgs e)
        {
            if(m_bLive)
            {
                // Stop capture
                axuEyeCam.StopLiveVideo(uEye_defines.IS_WAIT);
                m_bLive = false;
                CaptureImage.Text = "Start capture";
            }
            else
            {
                if (!m_bContinuousTriggerSupported && (TriggerOff.Checked == false))
                {
                    // Stop capture
                    axuEyeCam.StopLiveVideo(uEye_defines.IS_WAIT);
                    m_bLive = false;
                    CaptureImage.Text = "Start capture";

                    MessageBox.Show("The continuous trigger mode is not supported by this camera");
                }
                else
                {
                    // Start capture
                    axuEyeCam.StartLiveVideo(1);
                    m_bLive = true;
                    CaptureImage.Text = "Stop capture";
                }
            }
        }

        private void Save_Click(object sender, System.EventArgs e)
        {
            axuEyeCam.SaveImage("Test.jpg");
        }

        private void Properties_Click(object sender, System.EventArgs e)
        {
            axuEyeCam.PropertyDialog();
            UpdateControls();
        }

        private void Direct3D_CheckedChanged(object sender, System.EventArgs e)
        {
            axuEyeCam.EnableDirect3D = Direct3D.Checked;
            UpdateControls();
        }

        private void axuEyeCam_EventOnTrigger(object sender, System.EventArgs e)
        {
        }

        private void axuEyeCam_EventOnTransferFailed(object sender, System.EventArgs e)
        {
            m_nTransferFailed++;
        }

        void t1_Tick(object sender, EventArgs e)
        {
            if (m_bCameraOpen && (m_nTransferFailedOld != m_nTransferFailed))
            {
                String str;
                str = "Transfer failed: " + m_nTransferFailed;
                InfoList.Items.Add(str);

                m_nTransferFailedOld = m_nTransferFailed;
            }
        }

        private delegate void UpdateFPS();
        private void ShowFPS()
        {
            Info3.Text = String.Format(" {0} fps ", axuEyeCam.GetFramesPerSecond().ToString().Substring(0, 5));
        }

        private void axuEyeCam_EventOnFrame(object sender, AxuEyeCamLib._DuEyeCamEvents_EventOnFrameEvent e)
        {
            Info3.Invoke(new UpdateFPS(ShowFPS));
            m_MemAddr = System.Convert.ToInt64(axuEyeCam.GetImageMem());
        }

        private void axuEyeCam_MouseMoveEvent(object sender, AxuEyeCamLib._DuEyeCamEvents_MouseMoveEvent e)
        {
            if( m_bCameraOpen && !axuEyeCam.EnableDirect3D )
            {   
                int x = 0, y = 0;
                int width = 0, height = 0, bits = 0, pitch = 0;
                axuEyeCam.InquireImageMem( ref width, ref height, ref bits, ref pitch );

                if( axuEyeCam.InitFitToWindow )
                {
                    x = e.x * width / axuEyeCam.Size.Width;
                    y = e.y * height / axuEyeCam.Size.Height;
                }
                else
                {
                    x = e.x;
                    y = e.y;
                }
                if( (x < 0) || (x > width) || (y < 0) || (y > height) )
                {
                    Info2.Text = String.Format("Invalid position");
                    return; 
                }

                if (this.m_MemAddr != 0)
                {                
                    // try to get the rgb values (in case of 24 or 32 bit images)
                    // on Y8 images you got 3 Y values
                    try
                    {   
                        rgb[0] = Marshal.ReadByte( (IntPtr)this.m_MemAddr, (y*width + x)*bits/8 );
                        rgb[1] = Marshal.ReadByte( (IntPtr)this.m_MemAddr, (y*width + x)*bits/8 + 1 );
                        rgb[2] = Marshal.ReadByte( (IntPtr)this.m_MemAddr, (y*width + x)*bits/8 + 2 );
                    }
                    catch(Exception ee)
                    {
                        Console.WriteLine("ScanForm : " + ee.Message + " Type : " + ee.GetType().ToString());
                    }                   
                    Info2.Text = String.Format(" ({0},{1}) = ({2},{3},{4})", x, y, rgb[0], rgb[1], rgb[2] );
                }   // end if (this.m_MemAddr != 0)
                else
                {
                    Info2.Text = String.Format(" ({0},{1}) = (N/A)", x, y);
                }
            }
        }

        private void axuEyeCam_EventOnDeviceRemoved(object sender, System.EventArgs e)
        {
            // Enable reconnect message
            axuEyeCam.EnableEvent( uEye_defines.IS_DEVICE_RECONNECTED, 1 );
            InfoList.Items.Add( String.Format( "Camera disconnected!"));
            Info1.Text = "Camera disconnected!!";
        }

        private void axuEyeCam_EventOnDeviceReconnected(object sender, System.EventArgs e)
        {
            // Disable reconnect message
            axuEyeCam.EnableEvent( uEye_defines.IS_DEVICE_RECONNECTED, 0 );
            InfoList.Items.Add( String.Format( "Camera reconnected!")); 
            UpdateControls();
        }

        private void axuEyeCam_Error(object sender, AxuEyeCamLib._DuEyeCamEvents_ErrorEvent e)
        {
            InfoList.Items.Add( String.Format( "Error No.{0}, {1}", e.number, e.description ) );
        }

        private void axuEyeCam_MouseDownEvent(object sender, AxuEyeCamLib._DuEyeCamEvents_MouseDownEvent e)
        {
            if( axuEyeCam.EnableDirect3D && m_bCameraOpen )
            {
                System.Drawing.Point p = new System.Drawing.Point( e.x, e.y );
                DrawCross (p);
                axuEyeCam.ShowDirect3DOverlay = true;
            }       
        }

        private void DrawCross (System.Drawing.Point e )
        {
            // Get the size of the display window
            int nDisplayHeight = axuEyeCam.Height;
            int nDisplayWidth = axuEyeCam.Width;
            int nImageHeight = 0;
            int nImageWidth = 0;

            // Get the image size
            axuEyeCam.GetImageSize(ref nImageWidth, ref nImageHeight);

            double dblScaleFactorX = 1.0;
            double dblScaleFactorY = 1.0;

            // Calculate the scaling factors between the image and the display 
            // to show a cross with the correct size
            if ((axuEyeCam.GetRenderMode() & uEye_defines.IS_RENDER_FIT_TO_WINDOW) != 0)
            {
                dblScaleFactorX = (double)nImageWidth / (double)nDisplayWidth;
                dblScaleFactorY = (double)nImageHeight / (double)nDisplayHeight;
            }

            // Create a pen with the color red
            System.Drawing.SolidBrush brush;
            brush = new System.Drawing.SolidBrush (System.Drawing.Color.Red);
            System.Drawing.Pen pen = new System.Drawing.Pen( brush, 3) ;

            // Calculate the correct position of the cross (depending on the scaling factors)
            int x = (int)((double)e.X * dblScaleFactorX);
            int y = (int)((double)e.Y * dblScaleFactorY);

            // Calculate the correct width and height of the cross
            int nCrossWidth = (int)(10 * dblScaleFactorX);
            int nCrossHeight = (int)(10 * dblScaleFactorY);

            System.Drawing.Point pt1 = new System.Drawing.Point( x - nCrossWidth, y - nCrossHeight );
            System.Drawing.Point pt2 = new System.Drawing.Point( x + nCrossWidth, y + nCrossHeight );
            System.Drawing.Point pt3 = new System.Drawing.Point( x + nCrossWidth, y - nCrossHeight );
            System.Drawing.Point pt4 = new System.Drawing.Point( x - nCrossWidth, y + nCrossHeight );

            // Set the Direct3D key color to black
            axuEyeCam.Direct3DKeyColor = System.Drawing.Color.Black;

            // Clear the Direct3D overlay
            axuEyeCam.ClearDirect3DOverlay ();

            // Get the DC of the Direct3D overlay
            int hdc = axuEyeCam.GetDC();
            System.Drawing.Graphics DC = System.Drawing.Graphics.FromHdc( (System.IntPtr)hdc );

            DC.DrawLine( pen, pt1, pt2 );
            DC.DrawLine( pen, pt3, pt4 );

            // Release the DC of the Direct3D overlay
            axuEyeCam.ReleaseDC( hdc );
        }

        private void TriggerOff_Click(object sender, System.EventArgs e)
        {
            if(m_bLive)
            {
                axuEyeCam.StopLiveVideo( uEye_defines.IS_WAIT );
            }

            // Disable trigger
            if (axuEyeCam.SetExternalTrigger(uEye_defines.IS_SET_TRIGGER_OFF) != uEye_defines.IS_SUCCESS)
            {
                if (m_nCurrentMode == 1)
                {
                    TriggerOff.Checked = false;
                    TriggerSoftware.Checked = true;
                    TriggerRising.Checked = false;
                    TriggerFalling.Checked = false;
                }
                else if (m_nCurrentMode == 2)
                {
                    TriggerOff.Checked = false;
                    TriggerSoftware.Checked = false;
                    TriggerRising.Checked = false;
                    TriggerFalling.Checked = true;
                }
                else if (m_nCurrentMode == 3)
                {
                    TriggerOff.Checked = false;
                    TriggerSoftware.Checked = false;
                    TriggerRising.Checked = true;
                    TriggerFalling.Checked = false;
                }

                MessageBox.Show("The trigger mode can not be disabled with the current settings");

                return;
            }

            if(m_bLive)
            {
                axuEyeCam.StartLiveVideo(1);
            }

            m_nCurrentMode = 0;
        }

        private void TriggerSoftware_Click(object sender, System.EventArgs e)
        {
            if(m_bLive)
            {
                axuEyeCam.StopLiveVideo( uEye_defines.IS_WAIT );
            }

            // Enable software trigger
            axuEyeCam.SetExternalTrigger( uEye_defines.IS_SET_TRIGGER_SOFTWARE );

            if(m_bLive)
            {
                if (m_bContinuousTriggerSupported)
                {
                    axuEyeCam.StartLiveVideo(1);
                }
                else
                {
                    // Stop capture
                    axuEyeCam.StopLiveVideo(uEye_defines.IS_WAIT);
                    m_bLive = false;
                    CaptureImage.Text = "Start capture";
                }
            }

            m_nCurrentMode = 1;
        }

        private void TriggerFalling_Click(object sender, System.EventArgs e)
        {
            if(m_bLive)
            {
                axuEyeCam.StopLiveVideo( uEye_defines.IS_WAIT );
            }

            // Enable hardware trigger falling
            axuEyeCam.SetExternalTrigger( uEye_defines.IS_SET_TRIGGER_HI_LO );

            if(m_bLive)
            {
                axuEyeCam.StartLiveVideoWait(100);
            }

            m_nCurrentMode = 2;
        }

        private void TriggerRising_Click(object sender, System.EventArgs e)
        {
            if(m_bLive)
            {
                axuEyeCam.StopLiveVideo( uEye_defines.IS_WAIT );
            }

            // Enable hardware trigger rising
            axuEyeCam.SetExternalTrigger( uEye_defines.IS_SET_TRIGGER_LO_HI );

            if(m_bLive)
            {
                axuEyeCam.StartLiveVideoWait(100);
            }

            m_nCurrentMode = 3;
        }
    }
}

Next one will be the c# socket programming for server only

using System;
using System.Net;
using System.Net.Sockets;
using System.Text;
using System.Threading;

public class ThreadedTcpSrvr {

   private TcpListener client;

   public ThreadedTcpSrvr()
   {
      client = new TcpListener(9050);
      client.Start();

<pre>
  Console.WriteLine("Waiting for clients...");
  while(true)
  {
     while (!client.Pending())
     {
        Thread.Sleep(1000);
     }

     ConnectionThread newconnection = new ConnectionThread();
     newconnection.threadListener = this.client;
     Thread newthread = new Thread(new
               ThreadStart(newconnection.HandleConnection));
     newthread.Start();
  }

}

public static void Main()
{
ThreadedTcpSrvr server = new ThreadedTcpSrvr();
}
}

class ConnectionThread
{
public TcpListener threadListener;
private static int connections = 0;

public void HandleConnection()
{
int recv;
byte[] data = new byte[1024];

TcpClient client = threadListener.AcceptTcpClient();
NetworkStream ns = client.GetStream();
connections++;
Console.WriteLine("New client accepted: {0} active connections",
connections);

string welcome = "Welcome to my test server";
data = Encoding.ASCII.GetBytes(welcome);
ns.Write(data, 0, data.Length);

while(true)
{
data = new byte[1024];
recv = ns.Read(data, 0, data.Length);
if (recv == 0)
break;

ns.Write(data, 0, recv);

for (int i=0; i<data.length;i++) {
="" console.write(data[i]);
="" if="" (data[i]="=" 0x03)="" break;
="" }
="" console.writeline();

="" ns.close();
="" client.close();
="" connections--;
="" console.writeline("client="" disconnected:="" {0}="" active="" connections",
="" connections);
="" }
}
<="" pre="">

Re: Merge with uEye cam capture program c# with c# socket programming (Server Only)

OriginalGriff2-Apr-15 22:41

OriginalGriff

2-Apr-15 22:41

That is a code dump - and one that tells us nothing about your actual problem.
I'm guessing that you have found some code on the internet which you think will do what you want, but you have no idea how to use it or integrate it into your app - but I can;t be sure.

If that is the case, then that's down to you - we aren't here to deal with that kind of thing.
If it isn't, then get rid of the code dump, explain what you have tried, where you are stuck, what help you need. And only show us the code fragments relevant to that!

Would you want to wade through that lot without that info? Because I don't!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: Merge with uEye cam capture program c# with c# socket programming (Server Only)

Member 115345522-Apr-15 23:20

Member 11534552

2-Apr-15 23:20

Ok thanks

Re: Merge with uEye cam capture program c# with c# socket programming (Server Only)

OriginalGriff2-Apr-15 23:23

OriginalGriff

2-Apr-15 23:23

You're welcome!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: Merge with uEye cam capture program c# with c# socket programming (Server Only)

Eddy Vluggen3-Apr-15 1:13