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();
}
}
