Author: Nusrat Faria

PrintDialog printdialog = new PrintDialog();
printdialog.ShowDialog();

                   OpenFileDialog openfiledialog = new OpenFileDialog();
 openfiledialog.Filter = "*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.*";

        if(openfiledialog.ShowDialog() == DialogResult.OK){
            pictureBox1.Image = Bitmap.FromFile(openfiledialog.FileName);
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;

        }

    public Form1()
{
InitializeComponent();    
// Initialize Data Table
        DataTable datatable = new DataTable();

        // Intialize Column
        datatable.Columns.Add("Name");
        datatable.Columns.Add("Email");
        datatable.Columns.Add("Address");

        // initialize Row 
        datatable.Rows.Add("Olee", "oleetechs@gmail.com", "Dhaka Bangladesh");
        datagridview1.DataSource = datatable;
    }

 Form1 form1 = new Form1();
            form1.Show();
            this.Hide();

string cs = @"server=localhost;userid=root;password=root;database=test";
bool isConn = false;         
try
         {
             MySqlConnection con = new MySqlConnection(cs);
             con.Open();
             isConn = true;
         }
         catch (Exception)
         {

             isConn = false;

         }


         if (isConn) {
             MessageBox.Show("ok");
         }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Windows.Forms;


namespace StudentManagementSystem
{
    class Database
    {

        private MySqlConnection connection;

        private String server;
        private String database;
        private String dbusername;
        private String dbpassword;
        private int Port;

        public Database()
        {

            Initialize();
        }

        private void Initialize()
        {
            server = "localhost";
            Port = 3306;
            database = "test";
            dbusername = "root";
            dbpassword = "root";
            String connectingString = "SERVER=" + server + ";Port="+3306+";" + "DATABASE=" +
        database + ";" + "UID=" + dbusername + ";" + "PASSWORD=" + dbpassword + ";";

            connection = new MySqlConnection(connectingString);

        }

        //open connection to database
        public bool OpenConnection()
        {

            try { 
            connection.Open();
                return true;
            }

            catch(MySqlException e){
                //When handling errors, you can your application's response based 
                //on the error number.
                //The two most common error numbers when connecting are as follows:
                //0: Cannot connect to server.
                //1045: Invalid user name and/or password.
                switch (e.Number)
                {
                    case 0:
                        MessageBox.Show("Cannot connect to server.  Contact administrator");
                        break;

                    case 1045:
                        MessageBox.Show("Invalid username/password, please try again");
                        break;
                }
                return false;

            }
            
        }

        //Close connection
        private bool CloseConnection()
        {
            try
            {
                connection.Close();
                return true;
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
                return false;
            }

        }

        //Insert statement
        public void Insert(String query)
        {
            if (this.OpenConnection() == true) {
                //create mysql command
                MySqlCommand mysqlcommand = new MySqlCommand();
                //Assign the query using CommandText
                mysqlcommand.CommandText = query;
                //Assign the connection using Connection
                mysqlcommand.Connection = connection;
                mysqlcommand.ExecuteNonQuery();
                this.CloseConnection();
            }
           
        }

        //Update statement
        public void Update()
        {
        }

        //Delete statement
        public void Delete( String query)
        {
            if (this.OpenConnection() == true)
            {
                MySqlCommand mysqlcommand = new MySqlCommand(query, connection);
                mysqlcommand.ExecuteNonQuery();
                this.CloseConnection();
            }

        }

        //Count statement
        public int Count(String query)
        {
            int Count = -1;

            //Open Connection
            if (this.OpenConnection() == true)
            {
                //Create Mysql Command
                MySqlCommand mysqlcommand = new MySqlCommand(query, connection);

                //ExecuteScalar will return one value
                Count = int.Parse(mysqlcommand.ExecuteScalar() + "");

                //close Connection
                this.CloseConnection();

                return Count;
            }
            else
            {
                return Count;
            }
        }

        //Backup
        public void Backup()
        {
        }

        //Restore
        public void Restore()
        {
        }

    }
}

    bool isConn = false;
        public MySqlConnection connection() {
            MySqlConnection con = null;
            string cs = @"server=localhost;userid=root;password=root;database=test";
            try
            {
                 con = new MySqlConnection(cs);
                con.Open();
                isConn = true;
                return con;

            }
            catch (Exception)
            {

                isConn = false;


            }

            return con;
        }

     


        private void button1_Click(object sender, EventArgs e)
        {


           MySqlConnection con =  connection();
            
            if (isConn)
            {

                String dates =  date.Value.ToString("yyyy-MM-dd"); 
                String insertquery = "INSERT INTO samplercvd ( sl, date) VALUES ('" + serial.Text + "','" + dates + "')";
                MySqlCommand mySqlCommand = new MySqlCommand(insertquery, con);

                try
                {
                    if (mySqlCommand.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("Data Inserted");
                    }
                    else
                    {
                        MessageBox.Show("Data Not Inserted");
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }


            }
        }

  using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM Customers", con))
        {
            cmd.CommandType = CommandType.Text;
            using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
            {
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    dataGridView1.DataSource = dt;
                }
            }
        }

    private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";
            string sql = "SELECT * FROM Authors";
            SqlConnection connection = new SqlConnection(connectionString);
            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            connection.Open();
            dataadapter.Fill(ds, "Authors_table");
            connection.Close();
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "Authors_table";
        }

<?php

$_GET["name"] = "gujgjghj";
$_GET["age"] = "yuhgfyhgfjh";
if (isset($_GET["name"]) && isset($_GET["age"])) {
   echo $_GET["name"].$_GET["age"];
}

        private void button1_Click(object sender, EventArgs e)
        {
            String name = "olee";
            String age = "35";
            String urlAddress = "http://localhost/TEST/";

            using (WebClient client = new WebClient())
            {
                NameValueCollection postData = new NameValueCollection()
       {
              { "name", name },  //order: {"parameter name", "parameter value"}
              { "age", age }
       };

                // client.UploadValues returns page's source as byte array (byte[])
                // so it must be transformed into a string
                string pagesource = Encoding.UTF8.GetString(client.UploadValues(urlAddress, postData));
                MessageBox.Show(pagesource);
            }
        }

string username = "john";
string urlAddress = "http://www.yoursite.tld/somepage.php?name=" + username;  

using (WebClient client = new WebClient())
{
       // this string contains the webpage's source
       string pagesource = client.DownloadString(urlAddress);  
}

<?php
$a = array(
    array('one' => 'Bangladesh'),
    array('two' => 'India'));

if (isset($_POST["name"]) && isset($_POST["age"])) {
    $json = json_encode($a);
echo  $json;
    
}

        private void button1_Click(object sender, EventArgs e)
        {
            String name = "olee";
            String age = "35";
            String urlAddress = "http://localhost/TEST/";

            using (WebClient client = new WebClient())
            {
                NameValueCollection postData = new NameValueCollection()
{
       { "name", name },  //order: {"parameter name", "parameter value"}
       { "age", age }
};

                // client.UploadValues returns page's source as byte array (byte[])
                // so it must be transformed into a string
                string pagesource = Encoding.UTF8.GetString(client.UploadValues(urlAddress, postData));
                MessageBox.Show(pagesource);
            }
        }