//запись данных в файл
//запись в базу данных
private void Button_Click(object sender, RoutedEventArgs e)
{
//работа с Excel
//save.XLWb = save.XApp.Workbooks.Open(save.FileName);
//save.Worksheet = save.XLWb.Sheets[1];
//save.NumLastRow = save.Worksheet.Cells[save.Worksheet.Rows.Count, "C"].End[Excel.XlDirection.xlUp].Row;
//save.NumLastRow++;
//save.Worksheet.Cells[save.NumLastRow, "A"] = TBSite.Text;
//save.Worksheet.Cells[save.NumLastRow, "B"] = TBLogin.Text;
//save.Worksheet.Cells[save.NumLastRow, "C"] = PBPass.Password;
//MessageBox.Show("Save data!");
//save.XLWb.Close(true);
// для удаления из базы данных DataBaseWorker.QueryWithoutResponse("DELETE FROM [DBPass] WHERE id=1");
DataBaseWorker.Conection();
string site = TBSite.Text;
string log = TBLogin.Text;
string pas = PBPass.Password;
if (site != "Write Source" && log != "Write Login" && log != "")
{
string sqlExpression = String.Format("INSERT INTO DBPass(LoginSite,Login,Password) VALUES ('{0}', '{1}','{2}')", site, log, pas);
DataBaseWorker.QueryWithoutResponse(sqlExpression);
DataBaseWorker.CloseConection();
TBSite.Text = "Write Source";
TBLogin.Text = "Write Login";
PBPass.Clear();
}
else
{
MessageBox.Show("Specify data to write", "Attantion", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
//очистить базу данных
private void Button_Click_3(object sender, RoutedEventArgs e)
{
MessageBoxResult result;
result = MessageBox.Show("Delete DataBase?", "Attantion", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
DataBaseWorker.Conection();
string qury = "TRUNCATE TABLE DBPass";
DataBaseWorker.QueryWithoutResponse(qury);
DataBaseWorker.CloseConection();
}
}