private void homeToolStripMenuItem_Click(object sender, EventArgs e) { welcomeForm obj = new welcomeForm(); obj.Show(); Visible = false; }
private void SubmitButton_Click_1(object sender, EventArgs e) { SqlConnection cnn; cnn = new SqlConnection("Server=.\\SQLEXPRESS;Database=DTMS; Integrated Security=true"); String Query = "insert into user_table (username,password) values ('" + this.UserNameTextBox.Text + "','" + this.PassWordTextBox.Text + "');"; cnn.Open(); string username = UserNameTextBox.Text; String password = PassWordTextBox.Text; String query = "select username,userpass from user_table;"; SqlCommand com = new SqlCommand(query, cnn); SqlDataReader reader = com.ExecuteReader(); int flag = 0; while (reader.Read()) { string name = reader[0].ToString(); string pass = reader[1].ToString(); if (name == username && pass == password) { flag = 1; break; } } if (flag == 1) //if user credential is matched then Usercount value is 1 otherwise it is 0 { this.Hide(); //hiding form 1 welcomeForm obj = new welcomeForm(); //Main M1 = new Main(username);//ing user Name to Second form so we can user Logged user Name obj.Show(); Visible = false; //MessageBox.Show("welcome"); } else { loginmsg.ForeColor = Color.Red; //if user Name is not available in database } }