C# : Get Value From DataGridView CellMouseClick

Post by Goborijung at 2020-09-14 10:34:19 | ID: 793

private void Form1_Load(object sender, EventArgs e)
{
  DataTable dt = new DataTable();
  dt.Columns.AddRange(new DataColumn[3] 
  {
    new DataColumn("Id", typeof(int)),
    new DataColumn("Name", typeof(string)),
    new DataColumn("Country",typeof(string))
    });
  dt.Rows.Add(1, "John Hammond", "United States");
  dt.Rows.Add(2, "Mudassar Khan", "India");
  dt.Rows.Add(3, "Suzanne Mathews", "France");
  dt.Rows.Add(4, "Robert Schidner", "Russia");
  this.dataGridView1.DataSource = dt;
  this.dataGridView1.AllowUserToAddRows = false;
}

private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
  if (e.RowIndex >= 0)
  {
    DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
    txtID.Text = row.Cells[0].Value.ToString();
    txtName.Text = row.Cells[1].Value.ToString();
    txtCountry.Text = row.Cells[2].Value.ToString();
  }
}

C# : Get Value in ComboBox

Post by Goborijung at 2020-09-11 13:55:29 | ID: 777

>> Get Index เริ่มจาก Index ที่ -1
string cbo = comboBox1.SelectedIndex.ToString();

>> Get Item จะได้ชื่อ Item ออกมา
string cbo = comboBox1.SelectedItem.ToString();

>> Get Value จะได้ค่า Value ออกมา
string cbo = comboBox1.SelectedValue.ToString();

>> Get Text จะได้ Text ออกมา
string cbo = comboBox1.Text;

C# : Hide and Show MenuCollaps Button

Post by Goborijung at 2020-09-14 12:55:48 | ID: 797

>> Hide and Show MenuCollaps | การทำงานคือ เริ่มต้นให้ ซ่อนก่อน แล้วแสดงเมื่อมีการ Click เมนูหลัก
public Form1()
{
  InitializeComponent();
  hideSubMenu();
}

private void hideSubMenu()
{
  panelMediaSubMenu.Visible = false;
}

private void showSubMenu(Panel subMenu)
{
  if (subMenu.Visible == false)
  {
    //hideSubMenu();
    subMenu.Visible = true;
  }
  else
  {
    subMenu.Visible = false;
  }
}

>> ตัวอย่างการใช้งาน
private void btnMainMenu_Click(object sender, EventArgs e)
{
  showSubMenu(panelMediaSubMenu);
}

C# : http://csharp.net-informations.com/ , https://www.c-sharpcorner.com/

Post by Goborijung at 2020-07-18 11:54:18 | ID: 684

http://csharp.net-informations.com/
https://www.c-sharpcorner.com/

C# : Insert , Update , Delete ผ่าน Object dbConn

Post by Goborijung at 2020-10-23 16:56:19 | ID: 848

private void btnH97Gamming3_Click(object sender, EventArgs e) {
  conn = db.H97Gamming3();
  sql = "Update tblUser set UserName = 'User2' Where OID = 2 ";
  int i = db.Query(sql, conn);
  if (i > 0) {
    MessageBox.Show("Insert is Success.");
  }
}

C# : KeyPress (Key Enter)

Post by Goborijung at 2020-09-10 09:52:19 | ID: 680

private void txtCuttingNo_KeyPress(object sender, KeyPressEventArgs e)
{
  if (e.KeyChar == (char)13)
  {
    MessageBox.Show("ok key Enter");
  }
}

C# : Learning > ArrayList

Post by Goborijung at 2020-12-16 13:25:02 | ID: 919

https://www.tutorialsteacher.com/csharp/csharp-arraylist

C# : Learning > Youtube Chanel

Post by Goborijung at 2021-07-07 11:33:11 | ID: 1274

https://www.youtube.com/channel/UCsxUZpXc-Qa7e2aRJyS5-WQ/playlists

C# : len string หรือ นับสตริง | syn: strVar.Length;

Post by Goborijung at 2020-09-22 10:17:19 | ID: 813

ตัวอย่าง

int code = 104;
Console.WriteLine(Convert.ToString(code).Length);

//Output : 3

C# : Load Data to ComboBox (cmb)

Post by Goborijung at 2020-09-05 11:37:01 | ID: 769

>> Load ด้วย SQL Query
private void btnLoadFullName_Click(object sender, EventArgs e)
{
  cmbLoadFullName.Items.Clear();
  sql = "SELECT top 2 OID,FullName From [User]";
  SqlCommand cmd = new SqlCommand(sql,conn);            
  try
  {
    cmd.CommandText = sql;
    conn.Open();                
    SqlDataReader dr = cmd.ExecuteReader();
    while (dr.Read())
    {
      cmbLoadFullName.Items.Add(dr["FullName"].ToString());
      cmbLoadFullName.ValueMember     = dr["OID"].ToString();
      cmbLoadFullName.DisplayMember   = dr["FullName"].ToString();
    }
    conn.Close();
  }
  catch (Exception ex)
  {
    MessageBox.Show("Can not Open Connection! on LoadFullName");
  }
}

>> Load ผ่าน Object
private void loadcmbBranch()
{
  cmbBranch.DisplayMember = "Text";
  cmbBranch.ValueMember = "Value";

  var items = new[]
  {
  new { Text = "All" ,    Value = "1,2,3,4,6" },
  new { Text = "SAI4" ,   Value = "1" },
  new { Text = "SAI4-2" , Value = "2" },
  new { Text = "304" ,    Value = "3" },
  new { Text = "RAMA2" ,  Value = "4" },
  new { Text = "TUW" ,    Value = "6" }
  };

  cmbBranch.DataSource = items;
}