public Main(myInfo infoFromLogin) { InitializeComponent(); userInfo = infoFromLogin; // Example of use lblMessage.Text = userInfo.loginMessage; }
private void BtnLogin_Click(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = connectionString; try { // OPEN THE CONNECTION myConnection.Open(); // PERFORM THE COMMAND SqlCommand myCommand = new SqlCommand(); myCommand.CommandText = String.Format( "SELECT * FROM Login WHERE UserId ='{0}' AND Password='******'", txtUsername.Text.Trim().Replace("\"", "").Replace(";", ""), txtPassword.Text.Trim().Replace("\"", "").Replace(";", "") ); myCommand.Connection = myConnection; SqlDataReader myDataReader = myCommand.ExecuteReader(); if (myDataReader.Read()) { // Set the data you want to pass myInfo infoFromLogin = new myInfo(); infoFromLogin.loginMessage = "Welcome!! You are " + txtUsername.Text; // Pass it on! Main newForm = new Main(infoFromLogin); newForm.Show(); this.Hide(); } else { MessageBox.Show("Not found!"); } } catch (Exception ex) { // CATCH ANY ERRORS AND DEBUG MessageBox.Show(ex.Message); } finally { // ALWAYS CLOSE THE CONNECTION if (myConnection.State == ConnectionState.Open) { myConnection.Close(); } } }