示例#1
0
        private void WorkerPanel_Load(object sender, EventArgs e)
        {
            // TODO: Ten wiersz kodu wczytuje dane do tabeli 'rSSDataSet.ACTIVITY' . Możesz go przenieść lub usunąć.

            //this.aCTIVITYTableAdapter.Fill(this.rSSDataSet.ACTIVITY);
            this.checkBox1.Checked = true;
            var result = SQLworker.SearchActivity("", "", textBox1.Text.ToString());

            dataGridView1.DataSource = result;

            var dataSource = new List <string>();

            dataSource.Add("ALL");
            dataSource.Add("ACT");
            dataSource.Add("CAN");
            dataSource.Add("EXP");

            comboBox1.DataSource = dataSource;
        }
示例#2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string check;

            if (checkBox1.Checked == true)
            {
                check = textBox1.Text.ToString();
            }
            else
            {
                check = "";
            }


            string d;

            if (dateTimePicker2.Checked == true)
            {
                d = dateTimePicker2.Text.ToString();
            }
            else
            {
                d = "";
            }

            if (comboBox1.Text == "ALL")
            {
                var result = SQLworker.SearchActivity("", d, check);
                dataGridView1.DataSource = result;
            }
            else
            {
                var result = SQLworker.SearchActivity(comboBox1.Text.ToString(), d, check);
                dataGridView1.DataSource = result;
            }
        }
 private void button1_Click(object sender, EventArgs e)
 {
     SQLworker.EditActivity(textBox3.Text.ToString(), dateTimePicker1.Value, comboBox1.Text.ToString(), richTextBox2.Text.ToString());
     this.Close();
 }
示例#4
0
 public dataSourceConnectionForm(ref SQLworker sqlHandler, ref ErrorLogger errLogger)
 {
     InitializeComponent();
     this.sqlConnectionHandler = sqlHandler;
     this.errorLogger          = errLogger;
 }