private void button1_Click(object sender, EventArgs e)
{
DtServer = pg_Connect.connect_database();
string connstring = DtServer.dt_connection;
bool conn_True = DtServer.fileExist;
if (conn_True)
{
try
{
connection = new NpgsqlConnection(connstring);
connection.Open();
command = new NpgsqlCommand("SELECT * FROM public.student", connection);
dataReader = command.ExecuteReader();
for (int i = 0; dataReader.Read(); i++)
{
dataItems.Add(dataReader[4].ToString() + " " + dataReader[0].ToString() + " " + dataReader[2].ToString() + " " + dataReader[1].ToString() + " " + dataReader[3].ToString() + "\r\n");
}
connection.Close();
}
catch (Exception msg)
{
MessageBox.Show("You can't connect with database!Please chek data connections saved in the file and try again!" + "Server=127.0.0.1; Port=5432; User Id=postgres; Password=b2b4cc1b2; Database=DataStudent;");
//MessageBox.Show(msg.ToString());
//throw;
}
}
else
{
MessageBox.Show("Connection to dataBase has Failed Because File with data connections not Exist or name of the file has changed!");
}
tbDataItems.Clear();
for (int i = 0; i < dataItems.Count; i++)
{
tbDataItems.Text += dataItems[i];
tbDataItems.ScrollToCaret();
}
dataItems.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
DtServer = pg_Connect.connect_database();
string connstring = DtServer.dt_connection;
bool conn_True = DtServer.fileExist;
if (conn_True)
{
try
{
bool login_ok = false;
// string Query = "insert into public.login (id_user,username,password) values ('2','user1','admin1');";
// NpgsqlDataAdapter adapter = new NpgsqlDataAdapter("SELECT `username`, `password` FROM `public.login` WHERE `username` = '" + textBox1.Text + "' AND `password` = '" + textBox2.Text + "'", connection);
connection = new NpgsqlConnection(connstring);
connection.Open();
NpgsqlCommand cmd = new NpgsqlCommand("select * from login where username = '******' and password = '******'", connection);
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Form1 frm1 = new Form1();
this.Hide();
frm1.Show();
login_ok = true;
connection.Close();
}
if (login_ok == false)
{
MessageBox.Show("Username or pasword are incorect!");
}
//adapter.Fill(table);
// if (table.Rows.Count <= 0)
//{
// label_Message = Color.Red;
// label_Message= "Username Or Password Are Invalid";
//}
// command = new NpgsqlCommand(Query, connection);
//// NpgsqlDataReader dataReader;
//dataReader = command.ExecuteReader();
}
catch (Exception ex)
{
MessageBox.Show("You can't connect with database!Please chek data connections saved in the file and try again!" + "Server=127.0.0.1; Port=5432; User Id=postgres; Password=b2b4cc1b2; Database=DataStudent;");
// MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Connection to dataBase has Failed Because File with data connections not Exist or name of the file has changed!");
}
////if (textBox1.Text == "user1" && textBox2.Text == "1")
////{
// DtServer = pg_Connect.connect_database();
// string connstring = DtServer.dt_connection;
// bool conn_True = DtServer.fileExist;
// if (conn_True)
// {
// try
// {
// connection = new NpgsqlConnection(connstring);
// connection.Open();
// Form1 frm1 = new Form1();
// this.Hide();
// frm1.Show();
// connection.Close();
// }
// catch (Exception msg)
// {
// MessageBox.Show("You can't connect with database!Please chek data connections saved in the file and try again!" + "Server=127.0.0.1; Port=5432; User Id=postgres; Password=b2b4cc1b2; Database=DataStudent;");
// //MessageBox.Show(msg.ToString());
// //throw;
// //-------
// }
// }
// else
// {
// MessageBox.Show("Connection to dataBase has Failed Because File with data connections not Exist or name of the file has changed!");
// }
////}
////else
////{
//// MessageBox.Show("Incorrect user name or password!(Or both!)");
////}
}
