private void btnSave_Click(object sender, EventArgs e)
{
String connString;
connString = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection cnn = MiscFunction.OpenConnection(connString);
String strSQL;
strSQL = "INSERT INTO Password (name, login, password, date) " +
"VALUES (@name, @login, @password, @date)";
if (tBName.Text == String.Empty || tBLogin.Text == String.Empty || tBPassword.Text == String.Empty)
{
lbInform.Text = "Enter your data";
}
else
{
SqlCommand cmd = new SqlCommand(strSQL, cnn)
{
CommandTimeout = 60
};
cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 128)).Value = Convert.ToString(tBName.Text);
cmd.Parameters.Add(new SqlParameter("@login", SqlDbType.NVarChar, 50)).Value = Convert.ToString(tBLogin.Text);
cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 50)).Value = Convert.ToString(tBPassword.Text);
cmd.Parameters.Add(new SqlParameter("@date", DateTime.Now.Date));
cmd.ExecuteNonQuery();
tBName.Clear();
tBLogin.Clear();
tBPassword.Clear();
lbInform.Text = "Save";
}
}
private void btnGetPassword_Click(object sender, EventArgs e)
{
using (ResultSearchPassword frmrsp = new ResultSearchPassword())
{
frmrsp.ShowDialog();
String connString;
connString = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection cnn = MiscFunction.OpenConnection(connString);
using (SqlDataAdapter a = new SqlDataAdapter("SELECT name, login, password FROM Password", cnn))
{
SqlCommandBuilder cb = new SqlCommandBuilder(a);
DataSet ds = new DataSet();
a.Fill(ds, "Notes");
//dataGridView1.DataSource = ds.Tables[0];
//DataGridViewRow dr = dataGridView1.SelectedRows[0];
//dr.Cells[1].Value = ds;
//dr.Cells[2].Value = ds;
//dr.Cells[3].Value = ds;
//dr.Cells[4].Value = ds;
}
}
}
private void btnConnect_Click(object sender, EventArgs e)
{
String connString;
connString = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection cnn = MiscFunction.OpenConnection(connString);
//Вывод в таблицу информации
using (SqlDataAdapter a = new SqlDataAdapter("SELECT id, name, text, date FROM Notes", cnn))
{
SqlCommandBuilder cb = new SqlCommandBuilder(a);
DataSet ds = new DataSet();
a.Fill(ds, "Notes");
dataGridView1.DataSource = ds.Tables[0];
//datagridviewrow dr = datagridview1.selectedrows[0];
//dr.cells[1].value = ds.tables[1];
//dr.cells[2].value = ds.tables[2];
//dr.cells[3].value = ds.tables[3];
//dr.cells[3].value = ds.tables[4];
}
}