กด Emter แล้วไป Control ต่อไป

         private void Control_KeyUp(object sender, KeyEventArgs e)

        {

            if ((e.KeyCode == Keys.Enter) || (e.KeyCode == Keys.Return))

            {

                this.SelectNextControl((Control)sender, true, true, true, true);

            }

        }

string format 0,000

i.ToString("0,0")

await async

        public Task<int> ExecuteAsync(MySqlConnection con, string sSQL)
        {
            return Task.Run(() =>
            {
                string constring = "Server = localhost; Database = jhcisdb;Port=3333; Uid = root; Pwd = 123456; AllowZeroDateTime = True;CharSet=utf8;default command timeout=100000";
                jcon = new MySqlConnection(constring);
                // using (var newConnection = new SqlConnection(sConnectionString))
                using (var newCommand = new MySqlCommand(sSQL, con))
                {
                    newCommand.CommandType = CommandType.Text;
                 

                    con.Open();
                    return newCommand.ExecuteNonQuery();
               
                }
            });
        }


//-------------------------------
        private async Task ExecuteSomeData()
        {
            //Use Async method to get data
            await ExecuteAsync(jcon, sqlAll);
         
        }
//----------------------------------------------
        private void BtnTest_Click(object sender, EventArgs e)
        {
             ExecuteSomeData();
            //MessageBox.Show("OK");
        }

Returning a column value from a table in dataset

https://stackoverflow.com/questions/23648132/returning-a-column-value-from-a-table-in-dataset

การจัดการ dateTimePicker

https://www.thaicreate.com/community/windows-form-datetimepicker.html


using System.Globalization;
using System.Threading;

            if (fromDate.Value.Date <= toDate.Value.Date)
            {
                CultureInfo _cultureEnInfo = new CultureInfo("en-US");

                DateTime dateBEgin = Convert.ToDateTime(this.fromDate.Value, _cultureEnInfo);
                DateTime dateEnd = Convert.ToDateTime(this.toDate.Value, _cultureEnInfo);
                //this.lblEng.Text = dateEng.ToString("dd MMM yyyy", _cultureEnInfo);
                this.lblEng.Text = dateBEgin.ToString("yyyy MM dd", _cultureEnInfo);
                lblEndate.Text = dateEnd.ToString("yyyy MM dd", _cultureEnInfo);

                lblXX.Text = getDate(fromDate);
                MessageBox.Show("OK");
            }
            else
            {
                MessageBox.Show("พ่องตาย");
            }

----------------------------------------------
        private string getDate(DateTimePicker d)
        {
            string xx;
            CultureInfo _cultureEnInfo = new CultureInfo("en-US");
            DateTime xDate = Convert.ToDateTime(d.Value, _cultureEnInfo);
            xx = xDate.ToString("yyyyMMdd", _cultureEnInfo);

            return xx;
        }

gridControl Export to Excel

 //code on export to excel button
     private void buttonExportExcel_Click(object sender, EventArgs e)
    {
        SaveFileDialog saveFileDialogExcel = new SaveFileDialog();
        saveFileDialogExcel.Filter = "Excel files (*.xlsx)|*.xlsx";
        if (saveFileDialogExcel.ShowDialog() == DialogResult.OK)
        {
            string exportFilePath = saveFileDialogExcel.FileName;
            gridControl1.DataSource = selectgridvalues();
            gridControl1.ExportToXlsx(exportFilePath);
        }

    }

gridControl Caption

gridview1 properties
optionView=>
ShowViewCaption=true;
ViewCaption="xxxxx";

ตรวจสอบสถานะ Connection

var sqlCon= new SqlConnection(Properties.Settings.Default.sString);
var mySQLCon= new MySqlConnection(Properties.Settings.Default.dString);
sqlCon.Open();
mySQLCon.Open();
var temp = mySQLConn.State.ToString();
if (sqlCon.State==ConnectionState.Open && temp=="Open")
 {
   MessageBox.Show(@"Connection working.");
 }
else
 {
  MessageBox.Show(@"Please check connection string");
 }

grid control datasource

grid cell allignment

gridView2.Columns[i].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;

gridcontrol Column Header

ASPxGridView1.Columns[0].Caption = "Some Value";

จัดหัวตารางอยู่กึ่งกลาง

int ccount = gridView2.Columns.Count;
for (int i = 0; i <= ccount-1; i++)
{
gridView2.Columns[i].AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
gridView2.Columns[i].AppearanceHeader.Options.UseTextOptions = true;
}

gridcontrol Caption

gridview properties


OptionView->ShowViewCaption=true
viewcaption="ชื่อวิว"

ตรวจสอบ textbox คีย์ตัวเลข

            if (txtpidsearch.TextLength > 0)
            {
                int parsedValue;
                if (!int.TryParse(txtpidsearch.Text, out parsedValue))
                {
                    MessageBox.Show("กรอกเฉพาะตัวเลข !!!");
                    return;
                }
                else
                {}
              }
             else
             {}

InputBox

using inputbox;
using Microsoft.VisualBasic;




        {
            string msg, title, df;
            object myvalue;

            msg = "input";

            title = "test";

            df = "bb";

            myvalue = Interaction.InputBox(msg, title, df);

            if ((string)myvalue=="")
            {
                myvalue = df;
                Interaction.MsgBox("MyValue=" + myvalue.ToString(), MsgBoxStyle.OkOnly | MsgBoxStyle.Information, "C# Msgbox Demo");
         
            }
            else {
                Interaction.MsgBox("Hello, " + myvalue.ToString() + "!"+Environment.NewLine+"Nice to meet you",MsgBoxStyle.OkOnly|MsgBoxStyle.Information,"C# Demo");
            }


        }


https://www.youtube.com/watch?v=LEsl_psykrQ&t=4s

ส่งค่าข้าม Form

ฟอร้มหลัก
            if (Application.OpenForms["formnutri05"] != null)
            {
                Application.OpenForms["formnutri05"].Close();
            }
            formnutri05 frm = new formnutri05();
        frm.ConJ = connectionJhcis;
            frm.ConServer = connectionServer;
            frm.hcode = hcode;
            frm.hname = hname;
            frm.yearprocess = yearprocess;
            frm.MdiParent = this;
            frm.Dock = DockStyle.Fill;
            frm.Show();
// ต้องเรียงลำดับตามนี้ ก่อนฟอร์ม โชว์
 

ฟอร์มที่รับค่า

        public string hcode { get; set; }
        public string hname { get; set; }
        public int yearprocess { get; set; }
        public MySqlConnection ConJ { get; set; }
        public MySqlConnection ConServer { get; set; }

ตรวจสอบเปิด form ซ้ำ

            if (Application.OpenForms["formnutri05"] != null)
            {
                Application.OpenForms["formnutri05"].Close();
            }
            formnutri05 frm = new formnutri05();
            frm.MdiParent = this;
            frm.Dock = DockStyle.Fill;
            frm.Show();
            frm.ConJ = connectionJhcis;
            frm.ConServer = connectionServer;
            frm.hcode = hcode;
            frm.hname = hname;
            frm.yearprocess = yearprocess;

เพิ่มปีใน Combobox +- 10 ปี

1.สร้าง class

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

namespace testmenu
{
    public class yearP
    {
        public string tyear { get; set; }
        public int pyear { get; set; }
    }
}

2.สร้าง procedure ใน Form

        void AddValue()

        {

            comboBox1.Items.Clear();

            int year = DateTime.Now.Year;

            string a = year.ToString();

            //comboBox1.Items.Add(a);

            List<yearP> list = new List<yearP>();

            for (int i = 1; i <= 10; i++)

            {

                int my = year + i;

                string tmy = (my + 543).ToString();

                list.Add(new yearP() { tyear = tmy, pyear = my });

            }

            for (int i = 0; i <= 10; i++)           

            {

                int my = year - i;

                string tmy = (my + 543).ToString();

                list.Add(new yearP() { tyear = tmy, pyear = my });

            }

            comboBox1.DataSource = list;

            comboBox1.ValueMember = "pyear";

            comboBox1.DisplayMember = "tyear";

        }

3.เรียกใช้

        private void FormMain_Load(object sender, EventArgs e)

        {

            AddValue();

    

            comboBox1.SelectedIndex = 10;

        }

How to: Make the entire focused row highlighted เลือกทั้งแถว

This example shows how to paint the focused cell using the same appearance as the entire focused row:

// Make the grid read-only. 
gridView1.OptionsBehavior.Editable = false;
// Prevent the focused cell from being highlighted. 
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
// Draw a dotted focus rectangle around the entire row. 
gridView1.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;

C# - Logical Operators

Operator	Description	Example
&&	Called Logical AND operator. If both the operands are non zero then condition becomes true.	(A && B) is false.
||	Called Logical OR Operator. If any of the two operands is non zero then condition becomes true.	(A || B) is true.
!	Called Logical NOT Operator. Use to reverses the logical state of its operand. If a condition is true then Logical NOT operator will make false.	!(A && B) is true.

Example

using System;

namespace OperatorsAppl {
   class Program {
      static void Main(string[] args) {
         bool a = true; 
         bool b = true;
         
         if (a && b) {
            Console.WriteLine("Line 1 - Condition is true");
         }
         
         if (a || b) {
            Console.WriteLine("Line 2 - Condition is true");
         }
         
         /* lets change the value of  a and b */
         a = false;
         b = true;
         
         if (a && b) {
            Console.WriteLine("Line 3 - Condition is true");
         } else {
            Console.WriteLine("Line 3 - Condition is not true");
         }
         
         if (!(a && b)) {
            Console.WriteLine("Line 4 - Condition is true");
         }
         Console.ReadLine();
      }
   }
}

Get connection string from App.config

using System.Configuration;

//--------------------------------------------
            InitializeComponent();
            var j = Properties.Settings.Default;
            string jserver = j.jserver;
            string jport = j.jport.ToString();
            string jdbname = j.jdbname;
            string jusername = j.juser;
            string jpassword = j.jpassword;
            StringBuilder jsb = new StringBuilder();
            jsb.Append("server=" + jserver + ";");
            jsb.Append("port=" + jport + ";");
            jsb.Append("Database=" + jdbname + ";");
            jsb.Append("Uid=" + jusername + ";");
            jsb.Append("Pwd=" + jpassword + ";");
            jsb.Append("CharSet=utf8;");
            jsb.Append("Convert Zero Datetime=True;Use Affected Rows=true;AllowUserVariables=True;CheckParameters=False;");
            string jconString = jsb.ToString();
            jcon = new MySqlConnection(jconString);