private void InquiryUpdatebutton_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=lingo_Database;Integrated Security=True");
                con.Open();
                SqlCommand cmd = new SqlCommand("update Inquiry_Table set Inquiry_Date='" + InquirydateTimePicker.Text + "',Attendant='" + InquiryAttendantcomboBox.Text + "',Program='" + InquiryProgramcomboBox.Text + "',Course_Name='" + InquiryCourseNamecomboBox.Text + "',Student_Name='" + InquiryStudentNametextBox.Text + "',Phone='" + InquiryPhonetextBox.Text + "',Potential='" + InquiryPotentialcomboBox.Text + "',Expected_Strength='" + InquiryExpectedStrengthcomboBox.Text + "',Know_About='" + InquiryHowKnowcomboBox.Text + "',Expected_Visit_Date='" + InquiryVisitdateTimePicker.Text + "',Day='" + InquiryDaycomboBox.Text + "',Comments='" + InquiryCommentstextBox.Text + "',Teacher_Name='" + InquiryTeacherNamecomboBox.Text + "',Demo_Class='" + InquiryDemoClasscomboBox.Text + "',Follow_1='" + InquiryFollow1comboBox.Text + "',Follwer_1_Name='" + InquiryFollowerName1comboBox.Text + "',Follower_1_Response='" + InquiryResponse1comboBox.Text + "',Follower_Date_1='" + Follower1dateTimePicker.Text + "',Follow_2='" + InquiryFollow2comboBox.Text + "',Follwer_2_Name='" + InquiryFollowerName2comboBox.Text + "',Follower_2_Response='" + InquiryResponse2comboBox.Text + "',Follower_Date_2='" + Follower2dateTimePicker.Text + "',Follow_3='" + InquiryFollow3comboBox.Text + "',Follwer_3_Name='" + InquiryFollowerName3comboBox.Text + "',Follower_3_Response='" + InquiryResponse3comboBox.Text + "',Follower_Date_3='" + Follower3dateTimePicker.Text + "',Pending_Done_Cencal='" + InquiryPendingDonecomboBox.Text + "',Expected_Fee='" + InquiryExpectedFeetextBox.Text + "' where Inquiry_No='" + InquiryNotextBox.Text + "'", con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Data Updated into Database.");

                SqlCommand cmd0         = new SqlCommand("select COUNT(Inquiry_No) from Inquiry_Table", con);
                int        TotalInquiry = Convert.ToInt32(cmd0.ExecuteScalar());
                TotalInquirylabel.Text = TotalInquiry.ToString();

                SqlCommand cmd1           = new SqlCommand("select COUNT(Inquiry_No) from Inquiry_Table where Pending_Done_Cencal='Pending'", con);
                int        InquiryPending = Convert.ToInt32(cmd1.ExecuteScalar());
                InquiryPendinglabel.Text = InquiryPending.ToString();

                SqlCommand cmd3          = new SqlCommand("select COUNT(Inquiry_No) from Inquiry_Table where Pending_Done_Cencal='Cancel'", con);
                int        InquiryCancel = Convert.ToInt32(cmd3.ExecuteScalar());
                InquiryCancellabel.Text = InquiryCancel.ToString();

                if (InquiryPendingDonecomboBox.Text == "Done")
                {
                    Admission_Form s = new Admission_Form();
                    s.Show();
                }
            }
            catch
            {
                MessageBox.Show("Data is not update.");
            }
        }
Esempio n. 2
0
        private void AdmissionFrombutton_Click(object sender, EventArgs e)
        {
            Admission_Form s = new Admission_Form();

            s.Show();
        }