private void button2_Click(object sender, EventArgs e)
{
SqlConnection con = Connection.GetConnection();
SqlDataAdapter db = new SqlDataAdapter("Select Count(*) From Login Where UserName='******'and Password ='******'", con);
DataTable dt = new DataTable();
db.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
StockMain sm = new StockMain();
sm.Show();
}
else
{
MessageBox.Show("Invalid UserName & Password..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
button1_Click(sender, e);
}
}
private void Login_Click(object sender, EventArgs e)
{
//Procedure for DBconeection
SqlConnection con = new SqlConnection("Data Source = DESKTOP-0G0868J; Initial Catalog = Stock; Integrated Security = True");
SqlDataAdapter sda = new SqlDataAdapter(@"SELECT * FROM [dbo].[Login] where UserName='******' and Password='******'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
this.Hide(); //to hide loginForm
StockMain main = new StockMain();
main.Show(); //shows Stocks form
}
else
{
MessageBox.Show("Invalid Username & Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
clear_Click(sender, e); //to clear the feilds after pressing OK
}
}
private void button2_Click(object sender, EventArgs e)
{
//TODO : CheckLogin username and password
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Stock;Integrated Security=True");
SqlDataAdapter sda = new SqlDataAdapter(@"SELECT * FROM [dbo].[Login1] where UserName ='******' and Password ='******'", conn);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
this.Hide();
StockMain main = new StockMain();
main.Show();
}
else
{
MessageBox.Show("Invalid Username & password..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
button1_Click(sender, e);
}
}
private void button_Login_Click(object sender, EventArgs e)
{
// TO-DO: Check Login username and password and redirect to main page
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=StockDb;Integrated Security=True");
SqlDataAdapter sda = new SqlDataAdapter(@"SELECT * FROM [StockDb].[dbo].[Login] where Username='******' and Password='******'", conn);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
this.Hide();
StockMain main = new StockMain();
main.Show();
}
else
{
MessageBox.Show("Invalid Username and/or Password, please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
button_Clear_Click(sender, e);
}
}
