如何根据离职类型选择在文本框1中显示员工离职余额

本文关键字：显示余额何根类型选择文本 | 更新日期: 2023-09-27 17:59:27

我想在textbox1中显示基于leavetype和emp id的emp休假余额。我正在使用以下代码，但它并没有显示休假总余额。

private void cbleavetype_SelectedIndexChanged()
{
    conn = new SqlConnection(@"Data Source=........")
    conn.Open();
    SqlCommand command = new SqlCommand("select leave from leaveallotment where id='" + comboBox1.Text + "' && leavetype='" + cbleavetype.Text + "'",conn);
    SqlDataAdapter adp = new SqlDataAdapter(command);
    DataTable tbl = new DataTable();
    adp.Fill(tbl);
    // Show total leave in textBox1
    textBox1.Text = cbleavetype.SelectedValue.ToString();
}

我认为需要做的一件事是改变'&amp；'到"answers"

您可以使用下面的代码片段集，

        connectionString.Open();
        SqlCommand command =
            new SqlCommand(
                "select LeaveCount from leaveallotment  where
                 id= '" + comboBox1.Text + "' and 
                 leavetype='" + comboBox2.Text + "'",
                connectionString);
        SqlDataReader da = command.ExecuteReader();
        if (da.Read()) {
            textBox1.Text = da["LeaveCount"].ToString();
        }
        connectionString.Close();