private void Button_Click_1(object sender, RoutedEventArgs e) { ButAdd.Visibility = Visibility.Visible; ButDel.Visibility = Visibility.Visible; TSearch.Visibility = Visibility.Visible; ButSear.Visibility = Visibility.Visible; DPick_Start.Visibility = Visibility.Hidden; DPick_End.Visibility = Visibility.Hidden; SL.Visibility = Visibility.Hidden; EL.Visibility = Visibility.Hidden; EdL.Visibility = Visibility.Hidden; ButV.Visibility = Visibility.Hidden; CatAdd.Visibility = Visibility.Hidden; NameS.Visibility = Visibility.Hidden; ButVN.Visibility = Visibility.Hidden; NameAdd.Visibility = Visibility.Hidden; L1.Items.Clear(); DataSet table = new DataSet(); string sqlExpression = ("select * from Product"); using (SqlConnection connection = new SqlConnection(connectingString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(table); foreach (DataTable dt in table.Tables) { foreach (DataRow row in dt.Rows) { var cells = row.ItemArray; Controls.AdmOutControl admOutControl = new Controls.AdmOutControl(); admOutControl.Name1.Content = cells[1].ToString(); admOutControl.Name1.Content = cells[0].ToString(); admOutControl.Name2.Content = cells[1].ToString(); admOutControl.Name3.Content = cells[2].ToString(); admOutControl.Name4.Content = cells[3].ToString(); admOutControl.Name5.Content = cells[4].ToString(); L1.Items.Add(admOutControl); } } command.ExecuteNonQuery(); connection.Close(); } }
private void ButSear_Click(object sender, RoutedEventArgs e) { L1.Items.Clear(); bool check = true; string sqlExpression = ("Select * from Product group by prod_ID,Name,Category,Material,Price having Name like @name or Category like @name or Material like @name or Price like @name"); SqlConnection connection = new SqlConnection(connectingString); connection.Open(); try { check = true; SqlCommand command = new SqlCommand(sqlExpression, connection); command.Parameters.AddWithValue("@name", "%" + TSearch.Text + "%"); DataSet table = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(table); foreach (DataTable dt in table.Tables) { foreach (DataRow row in dt.Rows) { var cells = row.ItemArray; Controls.AdmOutControl admOutControl = new Controls.AdmOutControl(); admOutControl.Name1.Content = cells[0].ToString(); admOutControl.Name2.Content = cells[1].ToString(); admOutControl.Name3.Content = cells[2].ToString(); admOutControl.Name4.Content = cells[3].ToString(); admOutControl.Name5.Content = cells[4].ToString(); L1.Items.Add(admOutControl); } } command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); check = false; } finally { connection.Close(); } }