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

Question

hi guys i am developing windows form & in that form 2 combobxes 3 textboxes are present 1st combobox is for emp_id & 2nd combobox for sal_month which are retriving sucessfully data from sql on page load after selecting id from combobox it gives name in 1st-textbox and from selecting month from 2nd combobox it also gives advanced and fine in 2ndtextbox & in 3rd textbox but now problem is that my some employee doesnot taken either advance or fine or both in selected month then it will show message in textbox 2nd or 3rd that like employee doesnot take advanced / fine how i can achive this task

Tapan Patel · 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 guhe · Answer

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_nameDesignationSalary 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 guhe · Answer

I wantl show message in textbox 2nd or 3rd that like employee doesnot take advanced / fine how i can achive this task