saw msg in txtbox if data not present after select frm combo

thanks for ur lovely co-operation for me , my problem is solved here below all code for that windows form

namespace main_login

{

public partial class Salary_Form : Form

{

string ConnectionString = "data source=ABC\\MYSQL;initial catalog=saloon;user id=abc\\Anurag;integrated security=sspi";

//SqlCommand com;

//string str;

SqlCommand cmd = new SqlCommand();

public Salary_Form()

{

InitializeComponent();

}

private void Salary_Form_Load(object sender, EventArgs e)

{

string Sql = "select Employee_Id from Employee_Entery_Form";

SqlConnection conn = new SqlConnection(ConnectionString);

conn.Open();

SqlCommand cmd = new SqlCommand(Sql, conn);

SqlDataReader DR = cmd.ExecuteReader();

while (DR.Read())

{

Combo_Emp_Id.Items.Add(DR[0]);

}

private void Combo_Emp_Id_SelectedIndexChanged(object sender, EventArgs e)

{

string str = "data source=ABC\\MYSQL;initial catalog=saloon;user id=abc\\Anurag;integrated security=sspi";

SqlConnection con = new SqlConnection(str);

string query = "select First_name,Designation,Salary from Employee_Entery_Form where Employee_Id='" + Combo_Emp_Id.SelectedItem.ToString() + "'";

SqlCommand cmd = new SqlCommand(query, con);

SqlDataReader dbr;

try

{

con.Open();

dbr = cmd.ExecuteReader();

while (dbr.Read())

{

Txt_Emp_Name.Text = dbr.GetString(0).ToString();

Txt_Designation.Text = dbr.GetString(1).ToString();

Txt_Basic_Sal.Text = Convert.ToString(int.Parse(dbr[2].ToString()));

Txt_Emp_Name.Enabled = false;

Txt_Designation.Enabled = false;

Txt_Basic_Sal.Enabled = false;

}

Txt_Advanced.Text = "";

Txt_Fine.Text = "";

Txt_Net_Sal.Text = "";

}

catch (Exception)

{

Txt_Emp_Name.Text = "Sorry name not found !";

Txt_Designation.Text = "Sorry Desgination not found !";

Txt_Basic_Sal.Text = "Sorry Salary not Found !";

Txt_Advanced.Text = "00";

Txt_Fine.Text = "00";

Txt_Net_Sal.Text = "00";

Txt_Emp_Name.Enabled = false;

Txt_Designation.Enabled = false;

Txt_Advanced.Enabled = false;

Txt_Basic_Sal.Enabled = false;

Txt_Fine.Enabled = false;

Txt_Net_Sal.Enabled = false;

}

private void Combo_Sal_Month_SelectedIndexChanged(object sender, EventArgs e)

{

string str = "data source=ABC\\MYSQL;initial catalog=saloon;user id=abc\\Anurag;integrated security=sspi";

SqlConnection con = new SqlConnection(str);

string query = "select sum(Advanced),sum(Fine) from Advanced_Fine_Form where Advanced_Month='" + Combo_Sal_Month.SelectedItem.ToString() + "' AND Employee_Id ='" + Combo_Emp_Id.SelectedItem.ToString() + "'";

SqlCommand cmd = new SqlCommand(query, con);

SqlDataReader dbr;

try

{

con.Open();

dbr = cmd.ExecuteReader();

while (dbr.Read())

{

Txt_Advanced.Text = Convert.ToString(int.Parse(dbr[0].ToString()));

Txt_Fine.Text = Convert.ToString(int.Parse(dbr[1].ToString()));

Txt_Advanced.Enabled = false;

Txt_Fine.Enabled = false;

}

Txt_Net_Sal.Text = Convert.ToString(int.Parse(Txt_Basic_Sal.Text.ToString()) + int.Parse(Txt_Advanced.Text.ToString()) - int.Parse(Txt_Fine.Text.ToString()));

Txt_Net_Sal.Enabled = false;

}

catch (Exception)

{

Txt_Advanced.Text = "Advanced not Taken By u!";

Txt_Fine.Text = "There is no fine on you !";

Txt_Advanced.Enabled = false;

Txt_Fine.Enabled = false;

Txt_Net_Sal.Text = Txt_Basic_Sal.Text;

Txt_Net_Sal.Enabled = false;

//MessageBox.Show(es.Message);

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
Accepted answer
it would be great if you can show us little bit more in terms of code or screenshot where One can understand what exactly you want to achieve.
As of now, I can suggest to have the property which gets changed on the combobox selectionchanged event and bind that property to "Employee doesn't take advanced....." if those employee doesn't have record for those months.
anurag guhe10y ago
thanks for ur lovely co-operation for me , my problem is solved here below all code for that windows form
namespace main_login
{
public partial class Salary_Form : Form
{
string ConnectionString = "data source=ABC\\MYSQL;initial catalog=saloon;user id=abc\\Anurag;integrated security=sspi";
//SqlCommand com;
//string str;
SqlCommand cmd = new SqlCommand();

public Salary_Form()
{
InitializeComponent();
}
private void Salary_Form_Load(object sender, EventArgs e)
{
string Sql = "select Employee_Id from Employee_Entery_Form";
SqlConnection conn = new SqlConnection(ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(Sql, conn);
SqlDataReader DR = cmd.ExecuteReader();
while (DR.Read())
{
Combo_Emp_Id.Items.Add(DR[0]);
}
}
private void Combo_Emp_Id_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "data source=ABC\\MYSQL;initial catalog=saloon;user id=abc\\Anurag;integrated security=sspi";
SqlConnection con = new SqlConnection(str);
string query = "select First_name,Designation,Salary from Employee_Entery_Form where Employee_Id='" + Combo_Emp_Id.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dbr;
try
{
con.Open();
dbr = cmd.ExecuteReader();
while (dbr.Read())
{
Txt_Emp_Name.Text = dbr.GetString(0).ToString();
Txt_Designation.Text = dbr.GetString(1).ToString();
Txt_Basic_Sal.Text = Convert.ToString(int.Parse(dbr[2].ToString()));
Txt_Emp_Name.Enabled = false;
Txt_Designation.Enabled = false;
Txt_Basic_Sal.Enabled = false;
}
Txt_Advanced.Text = "";
Txt_Fine.Text = "";
Txt_Net_Sal.Text = "";

}
catch (Exception)
{
Txt_Emp_Name.Text = "Sorry name not found !";
Txt_Designation.Text = "Sorry Desgination not found !";
Txt_Basic_Sal.Text = "Sorry Salary not Found !";
Txt_Advanced.Text = "00";
Txt_Fine.Text = "00";
Txt_Net_Sal.Text = "00";
Txt_Emp_Name.Enabled = false;
Txt_Designation.Enabled = false;
Txt_Advanced.Enabled = false;
Txt_Basic_Sal.Enabled = false;
Txt_Fine.Enabled = false;
Txt_Net_Sal.Enabled = false;
}
private void Combo_Sal_Month_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "data source=ABC\\MYSQL;initial catalog=saloon;user id=abc\\Anurag;integrated security=sspi";
SqlConnection con = new SqlConnection(str);
string query = "select sum(Advanced),sum(Fine) from Advanced_Fine_Form where Advanced_Month='" + Combo_Sal_Month.SelectedItem.ToString() + "' AND Employee_Id ='" + Combo_Emp_Id.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dbr;
try
{
con.Open();
dbr = cmd.ExecuteReader();
while (dbr.Read())
{
Txt_Advanced.Text = Convert.ToString(int.Parse(dbr[0].ToString()));
Txt_Fine.Text = Convert.ToString(int.Parse(dbr[1].ToString()));
Txt_Advanced.Enabled = false;
Txt_Fine.Enabled = false;
}
Txt_Net_Sal.Text = Convert.ToString(int.Parse(Txt_Basic_Sal.Text.ToString()) + int.Parse(Txt_Advanced.Text.ToString()) - int.Parse(Txt_Fine.Text.ToString()));
Txt_Net_Sal.Enabled = false;
}
catch (Exception)
{
Txt_Advanced.Text = "Advanced not Taken By u!";
Txt_Fine.Text = "There is no fine on you !";
Txt_Advanced.Enabled = false;
Txt_Fine.Enabled = false;
Txt_Net_Sal.Text = Txt_Basic_Sal.Text;
Txt_Net_Sal.Enabled = false;
//MessageBox.Show(es.Message);
}
}
anurag guhe10y ago
I wantl show message in textbox 2nd or 3rd that like "employee doesnot take advanced / fine" how i can achive this task