Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            //this.Hide();
            FirstScreen fs = new FirstScreen();

            fs.Show();
            this.Dispose();
        }
Exemplo n.º 2
0
        private void button2_Click(object sender, EventArgs e)
        {
            variables.rationno = textBox1.Text;
            //this.Hide();
            String          connString = "Server=" + variables.server + ";Port=" + variables.port + ";Database=" + variables.database + ";Uid=" + variables.user + ";password="******";";
            MySqlConnection conn       = new MySqlConnection(connString);
            MySqlCommand    command    = conn.CreateCommand();

            command.CommandText = " Select  * from cardholder_details where Ration_Number = '" + variables.rationno + "' ";
            try
            {
                conn.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Connection Problem. Please check the details of database");
                FirstScreen fs = new FirstScreen();
                fs.Show();
                this.Dispose();
            }
            MySqlDataReader reader = command.ExecuteReader();

            if (reader.Read())
            {
                String temp = variables.rationno + "~" + reader.GetString(reader.GetOrdinal("Card_holder_name")) + "~" + reader.GetString(reader.GetOrdinal("Address")) + "~" +
                              reader.GetInt32("Phone_number").ToString() + "~" + reader.GetInt16("Family_Size").ToString() + "~" + reader.GetString(reader.GetOrdinal("Category"));
                variables.buy   = reader.GetInt16("rice").ToString() + "~" + reader.GetInt16("wheat").ToString() + "~" + reader.GetInt16("kerosene").ToString();
                variables.uname = reader.GetString(reader.GetOrdinal("Card_holder_name"));
                personaldetails pd = new personaldetails(temp);
                pd.Show();
                this.Hide();
            }

            else
            {
                MessageBox.Show("Invalid Ration Card Number");

                //  this.Show();
            }
        }