ใครพอมี Code Auto Fill มั้ยครับ แค่พิมหรือเลือกข้อมูลใน combobox ที่ใส่ ID ของพนักงาน แล้ว ข้อมูลที่เหลือของพนักงานจะโชว์อัตโนมัติ

void textBox1_TextChanged(object sender, EventArgs e)
{
 Code อะไรก็ว่าไป
}

string constr = Properties.Settings.Default.DatabaseCarserviceConnectionString;
            OleDbConnection conn = new OleDbConnection(constr);
            conn.Open();
            DataTable dt = new DataTable();
            string sql = "SELECT * FROM [Bill_Detail],[Product] WHERE [Bill_Detial].Pro_ID='" + cmbProID.Text + "'and [Product].Pro_ID='" + cmbProID.Text + "'";
            OleDbCommand cmd = new OleDbCommand(sql, conn);
            OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
            DatabaseCarserviceDataSet data = new DatabaseCarserviceDataSet();
            adapter.Fill(dt);
            dataGridView1.DataSource = data.Tables["Product"];
            conn.Close();
            OleDbDataReader render = cmd.ExecuteReader();
            if (render.Read() != false)
            {
                txtName.Text = render["Pro_Name"].ToString();
                txtPrice.Text = render["S_Price"].ToString();
                txtAmount.Text = render["Amount"].ToString();
            }

private void cmbProID_SelectedIndexChanged(object sender, EventArgs e)
        {
            string constr = Properties.Settings.Default.DatabaseCarserviceConnectionString;
            OleDbConnection conn = new OleDbConnection(constr);
            DataTable dt = new DataTable();
            string str = "SELECT [Pro_ID]  ,[Pro_Name] ,[Price]  FROM Product where Pro_ID = '" + cmbProID.Text + "'  ";
            OleDbCommand cmd = new OleDbCommand(str, conn);
            OleDbDataAdapter adapter = new OleDbDataAdapter(str, conn);
            adapter.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                this.txtName.Text = (string)dt.Rows[0]["Pro_Name"];
                this.txtPrice.Text = (string)dt.Rows[0]["Price"].ToString();
            }  
        }