Display firm name and financial year on title bar of Form

Answer:

First of all we will create login form (Form1) in which we are taking two field, First is CompanyName as UserName and Second is Password Field.



then we will write code for login button in which we will setup connection to the database and check whether CompanyName and its corresponding password is Correct or Not.
            if it is correct then we will pass the value of CompanyName Field in Form2 object as Parameter
as shown below:

using System;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
 
namespace MySQLConnectionProject
{
  public partial class Form1 : Form
  {
  public Form1()
  {
  InitializeComponent();
  }
  private void button1_Click(object sender, EventArgs e)
  {
  try
  {
  String myconnection = "datasource=localhost; port=3306;username=root;password=";
  MySqlConnection con = new MySqlConnection(myconnection);
  MySqlDataAdapter myAdapter = new MySqlDataAdapter();
  MySqlCommand SelectCommand = new MySqlCommand("select * from hrms.userdetail where UserName ='" + this.textBox1.Text + "' and Password='" + this.textBox2.Text + "';", con);
  MySqlCommandBuilder cb = new MySqlCommandBuilder(myAdapter);
  con.Open();
  MySqlDataReader reader =SelectCommand.ExecuteReader();
  int count = 0;
  while (reader.Read())
  {
  count = count + 1;
  }
  if(count ==1)
  {
  this.Hide();
  Form2 obj = new Form2("WELCOME : "+textBox1.Text);
  obj.ShowDialog();
               }
   else if (count > 1)
  {
  MessageBox.Show("Duplicate Values");
  }
  else
               {
  MessageBox.Show("UserName Password is not correct !");
  }
  con.Close();
  }
  catch(Exception ex)
  {
  MessageBox.Show(ex.Message);
  }
  }
  private void button2_Click(object sender, EventArgs e)
  {
  Application.Exit();
  }
  }
}


After that we will write code for Form2 in which we want to display Company Name on Title Bar

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
 
namespace MySQLConnectionProject
{
  public partial class Form2 : Form
  {
  public Form2(string str)
  {
  InitializeComponent();
  this.Text = str;
 
  }
       private void Form2_FormClosing(object sender, FormClosingEventArgs e)
  {
  Application.Exit();
  }
  }
}

try this:
public Form1()
        {
            InitializeComponent();            
            this.Text="First Name : Financial Year";
        }
you can use Company name and financial year and pass them as a string here in place of "First Name : Financial Year". Hope this helps you.