C#

SELECT * 
FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
WHERE ccu.CONSTRAINT_NAME = 'UserIDfk'

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace DAQ_Simulator
{
    public partial class Form1 : Form
    {
        int counter;
        private DateTime datetime;
        private DateTime datetime2;
        //double next_samplingtime += DateTime.Now;
        //int maxSid = 10; //Number of sensors 7analog and 3 digital
        int maxAI = 7; 
        int maxDI=3;
        int maxSid =11;
        
        // Create an array of 10 sensor objects
        Sensor[] sObj = new Sensor[11];

        public Form1()
        {
            InitializeComponent();

            for (counter = 0; counter < maxSid; counter++)
            {
                sObj[counter] = new Sensor(counter);
            }
        }
        private void displaySensorData(object sender, EventArgs e)
        {
        }
        private void groupSampl_Enter(object sender, EventArgs e)
        {

        }
        private void textSampling_TextChanged(object sender, EventArgs e)
        {
        }
        private void btnSampling_Click(object sender, EventArgs e)
        {
            timer1.Interval = 5900; // sampling time specified in miliseconds
            timer1.Start();
            btnSampling.Enabled = false;
            sampling(); // sample the signals

            datetime2 = DateTime.Now.AddSeconds(5).AddMilliseconds(900);
            string time2 = datetime2.Hour + ":" + datetime2.Minute + ":" + datetime2.Second + "." + datetime2.Millisecond;
            textSampling.Text =time2;
            //  System.TimeSpan diff1 = datetime2.Subtract(datetime);        
        }

    private void groupLogg_Enter(object sender, EventArgs e)
    {
    }
    private void txtLogging_TextChanged(object sender, EventArgs e)
    {
    }
    private void labelLoggingText_Click(object sender, EventArgs e)
    {
    }
    private void btnLogging_Click(object sender, EventArgs e)
    {
    }
    private void labelSensorValues_Click(object sender, EventArgs e)
    {
    }
    private void textSensorValues_TextChanged(object sender, EventArgs e)
    {
    }
    private void timer1_Tick(object sender, EventArgs e)
    {
         btnSampling.Enabled = true;
         timer1.Stop();
    }
    private void sampling()
    {
          
            datetime = DateTime.Now;
           
            string time = datetime.Hour + ":" + datetime.Minute + ":" + datetime.Second + "." + datetime.Millisecond;
            
            // Get the object values as a string

            double sensVal1 = sObj[1].GetAnalogValue();
            double sensVal2 = sObj[2].GetAnalogValue();
            double sensVal3 = sObj[3].GetAnalogValue();
            double sensVal4 = sObj[4].GetAnalogValue();
            double sensVal5 = sObj[5].GetAnalogValue();
            double sensVal6 = sObj[6].GetAnalogValue();
            double sensVal7 = sObj[7].GetAnalogValue();
            
            int sensVal8 = sObj[8].GetDigitalValue();
            int sensVal9 = sObj[9].GetDigitalValue();
            int sensVal10 = sObj[10].GetDigitalValue();

            //Analog values converted to strings and stored in variables 
            String analogSens1 = sensVal1.ToString("F3");
            String analogSens2 = sensVal2.ToString("F3");
            String analogSens3= sensVal3.ToString("F3");
            String analogSens4 = sensVal4.ToString("F3");
            String analogSens5 = sensVal5.ToString("F3");
            String analogSens6 = sensVal6.ToString("F3");
            String analogSens7 = sensVal7.ToString("F3");

            //Digital values converted to strings and stored in variables
            String digSens8 = sensVal8.ToString("F0");
            String digSens9 = sensVal9.ToString("F0");
            String digSens10 = sensVal10.ToString("F0");

            textSensorValues.Text += ("  " + time + "  " + analogSens1 + "  " + analogSens2+ "  " + analogSens3 + "  " + analogSens4+
                "  "+ analogSens5+"  "+analogSens6+"  "+ analogSens7+"  "+digSens8+"  "+digSens9+"  "+digSens10+"\r\n");

            /*
                        for (int id = 0; id < maxAI; id++)
                       {
                            double y = sObj[id].GetAnalogValue();
                            if (id==0)
                            {
                                textSensorValues.Text += time+ " ," + sTxt + "V,";

                            }
                        }

                        for (counter = 0; counter < maxDI; counter++)
                        {

                           // sTxt1 += sObj[3].GetDigitalValue().ToString();
                        }

                */
           
            }
        
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DAQ_Simulator
{
    public class Sensor
    {
        Random ranDigVal;
        double AnalogVal;
        int DigVal;
        int sId;
        Random rSensVal;

        public Sensor(int id)
        {
            sId = id;
            rSensVal = new Random(id);
            ranDigVal = new Random(id);
            AnalogVal = 0.0F;
        }
        
        public double GetAnalogValue(double minAnalogVolt=0.00F,double maxAnalogVolt=1.00F)
        {
            if(minAnalogVolt <= AnalogVal && AnalogVal<= maxAnalogVolt)

                 AnalogVal = rSensVal.NextDouble();
                 return AnalogVal;         
       }
        public int GetDigitalValue(int digMin = 0, int digMax = 1)
        {

            DigVal = ranDigVal.Next(0, 2);
            return DigVal;
        }
        public int GetSensId()
        {
            return sId;
        }      
    }
}

class ndArray
{
    int Dimensions;
    int DimensionLength;
    int[] Array;
    public ndArray(int dimensions, int dimensionLength)
    {
        Dimensions = dimensions;
        DimensionLength = dimensionLength;
        int arrayLength = 1;
        for (int i = 0; i < dimensions; ++i)
            arrayLength *= dimensionLength;
        Array = new int[arrayLength];
    }
    int getIndex(params int[] indices)
    {
        int index = 0;
        int nsPlace = 1;
        for (int i = 0; i < Dimensions; ++i)
        {
            index += indices[i] * nsPlace;
            nsPlace *= DimensionLength;
        }
        return index;
    }
    public int getElement(params int[] indices)
    {
        return Array[getIndex(indices)];
    }
    public void setElement(int element, params int[] indices)
    {
        Array[getIndex(indices)] = element;
    }
}

Member 13670442 wrote:

one track bar to hold the total of the other track bars