private void button2_Click(object sender, EventArgs e)
{
string s = textBox1.Text;
int l = 0;
try
{
int count = 0;
//This is my connection string i have assigned the database file address path
string MyConnection2 = "datasource=localhost;port=3306;username=root;password=aman";
//This is my insert query in which i am taking input from the user through windows forms
string pleasechalja = "Select automobile.calc_salary('" + s + "');";// and Password = '******')";
//This is MySqlConnection here i have created the object and pass my connection string.
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
//This is command class which will handle the query and connection object.
MySqlCommand MyCommand2 = new MySqlCommand(pleasechalja, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database.
//MessageBox.Show("Save Data");
while (MyReader2.Read())
{
l = MyReader2.GetInt32(0);
}
MessageBox.Show("Salary = " + l.ToString());
//textBox2.Text = count.ToString();
MyConn2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
string si = textBox1.Text;
int li = 0;
try
{
int count = 0;
//This is my connection string i have assigned the database file address path
string MyConnection2 = "datasource=localhost;port=3306;username=root;password=aman";
//This is my insert query in which i am taking input from the user through windows forms
string pleasechalja = "Select automobile.calc_sales('" + si + "');";// and Password = '******')";
//This is MySqlConnection here i have created the object and pass my connection string.
MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
//This is command class which will handle the query and connection object.
MySqlCommand MyCommand2 = new MySqlCommand(pleasechalja, MyConn2);
MySqlDataReader MyReader2;
MyConn2.Open();
MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database.
//MessageBox.Show("Save Data");
while (MyReader2.Read())
{
li = MyReader2.GetInt32(0);
}
MessageBox.Show("Sales = " + li.ToString());
//textBox2.Text = count.ToString();
MyConn2.Close();
int ans = li - l;
MessageBox.Show("Profit = " + ans.ToString());
Form12 ob = new Form12();
this.Hide();
ob.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
