private void btnsearch_Click(object sender, RoutedEventArgs e) { Enquiry1 n = new Enquiry1(); if (date.Text == "" || date1.Text == "") { } else { datet = DateTime.Parse(date.Text); datet1 = DateTime.Parse(date1.Text); if (datet1.Ticks > datet.Ticks) { DataTable d = n.insertdate(); if (d.Rows.Count == 0) { date.Text = ""; date1.Text = ""; MessageBox.Show("there is no data please check the value"); } else { dg.ItemsSource = d.DefaultView; } } else { date.Text = ""; date1.Text = ""; MessageBox.Show("Select to-date greter then from-date"); } } }
//private void Button_Click_1(object sender, RoutedEventArgs e) //{ // Enquiry1 n = new Enquiry1(); // if (enquiryid.Text != "") // { // n.Enquiry_id = Convert.ToInt32(enquiryid.Text); // DataTable d = n.id(); // dg.ItemsSource = d.DefaultView; // } // else if (enquirydate.Text != "") // { // n.Expected_Arrival_Date = enquirydate.Text; // // Convert.ToDateTime(enquirydate.Text); // DataTable d1 = n.date(); // dg.ItemsSource = d1.DefaultView; // } // else if (enquiryname.Text != "") // { // n.Name = enquiryname.Text; // DataTable d2 = n.Name1(); // dg.ItemsSource = d2.DefaultView; // } // else if (enquirycontact.Text != "") // { // n.Contact = Convert.ToInt64(enquirycontact.Text); // DataTable d3 = n.Contact1(); // dg.ItemsSource = d3.DefaultView; // } //} private void btnok_Click(object sender, RoutedEventArgs e) { Enquiry1 n = new Enquiry1(); //var list = new List<SqlParameter>(); //string s = "select * from Enquiry where Insert_Date between @fromdate and @todate"; //string a = date.Text; //string b = date1.Text; //list.AddSqlParameter("@fromdate", date); //list.AddSqlParameter("@todate", date1); //n.Date = CHANGEFORMAT(date.Text); //n.Date1 = CHANGEFORMAT(date1.Text); n.Date = date.Text; n.Date1 = date1.Text; DataTable d = n.insertdate(); dg.ItemsSource = d.DefaultView; }