C# Code For Beginners (Part 1)

-
1. Add item to Textbox from Textbox

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


        private void btnadd_Click(object sender, EventArgs e)
        {
            int code1 = int.Parse(tbcode1.Text);
            tbcode2.Text=code1.ToString();
            string name1= tbname1.Text;
            tbname2.Text = name1;
         
        }


    }
}


output





2. Add item to Datagridview from Datagridview

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


        private void btnadd_Click(object sender, EventArgs e)
        {

            int n = 0;
            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                if (dataGridView1.Rows.Count != n + 1)
                {
                    dataGridView2.Rows.Add();
                    dataGridView2.Rows[n].Cells[0].Value = row.Cells[0].Value.ToString();
                    dataGridView2.Rows[n].Cells[1].Value = row.Cells[1].Value.ToString();
               
                }
                n += 1;

            }
        }

    }
}

output






3. Add item to Datagridview from Textbox

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        int n = 0;

        private void btnadd_Click(object sender, EventArgs e)
        {

            {
                    dataGridView1.Rows.Add();
                    dataGridView1.Rows[n].Cells[0].Value = tbcode.Text;
                    dataGridView1.Rows[n].Cells[1].Value = tbname.Text;
            }
                    n += 1;
        }
    }
}


output







4. Add item to Textbox from Datagridview

i.

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        int n = 0;

        private void btnadd_Click(object sender, EventArgs e)
        {
            if (n >= 0)
            {
                DataGridViewRow row = this.dataGridView1.Rows[n];
                tbcode.Text = row.Cells[0].Value.ToString();
                tbname.Text = row.Cells[1].Value.ToString();

            }
                   n += 1;
        }
    }
}

output










ii.

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
   

        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {

            if (e.RowIndex >= 0)
            {
                DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
                tbcode.Text = row.Cells[0].Value.ToString();
                tbname.Text = row.Cells[1].Value.ToString();


            }



        }
    }
}

output





5.Add data to Database from Textbox

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnadd_Click(object sender, EventArgs e)
        {
            string Conn1 = "server=localhost;user id=root;password=;database=blog";
            string Query = "insert into example(Item_Code,Item_Name) values('" + this.tbcode.Text + "','" + this.tbname
                .Text + "');";
            MySqlConnection Conn2 = new MySqlConnection(Conn1);
            MySqlCommand Command = new MySqlCommand(Query, Conn2);
            MySqlDataReader Reader;
         
            Conn2.Open();
         
            Reader = Command.ExecuteReader();
            MessageBox.Show("Item added to the Database successfully!");
            while (Reader.Read())
            {

            }
           Conn2.Close();

        }
    }
}

output



6.Add data to Database from Datagridview

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnadd_Click(object sender, EventArgs e)
        {
            MySqlConnection MyConn2 = new MySqlConnection("server=localhost;user id=root;password=;database=blog");
            MyConn2.Open();
            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                MySqlCommand MyCommand2 = new MySqlCommand("INSERT INTO example(Item_Code,Item_Name) VALUES('" + dataGridView1.Rows[i].Cells["I_Code"].Value + "','" + dataGridView1.Rows[i].Cells["I_Name"].Value + "')", MyConn2);

                MyCommand2.ExecuteNonQuery();

            }

            MessageBox.Show("Item Add Successfully..!");
            MyConn2.Close();
        }
    }
}

output




7.Add data to Textbox from Database

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnsrch_Click(object sender, EventArgs e)
        {
            string Conn1 = "server=localhost;user id=root;password=;database=blog";
            string Query = "(Select Item_Name From example Where Item_Code Like '" + tbcode.Text + "');";
            MySqlConnection Conn2 = new MySqlConnection(Conn1);
            MySqlCommand Command = new MySqlCommand(Query, Conn2);
            MySqlDataReader Reader;
            Conn2.Open();
            Reader = Command.ExecuteReader();

            while (Reader.Read())
            {
                tbname.Text = Reader.GetString("Item_Name");
            }

            Conn2.Close();
        }
    }
}

output





8.Add data to Datagridview from Database

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;
using MySql.Data.MySqlClient;

namespace Blog1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnsrch_Click(object sender, EventArgs e)
        {
            string Conn1 = "server=localhost;user id=root;password=;database=blog";
            string Query = "(Select Item_Code as 'Code',Item_Name as 'Name' From example Where Item_Code Like '" + tbcode.Text + "');";
            MySqlConnection Conn2 = new MySqlConnection(Conn1);
            MySqlCommand Command = new MySqlCommand(Query, Conn2);
            MySqlDataReader Reader;
            Conn2.Open();
            Reader = Command.ExecuteReader();


            while (Reader.Read())
            {
             
            }

            Conn2.Close();
            MySqlDataAdapter Adapter = new MySqlDataAdapter();
            Adapter.SelectCommand = Command;
            DataTable dTable = new DataTable();
            Adapter.Fill(dTable);
            dataGridView1.DataSource = dTable;
         
        }
    }
}

output






Comments

Post a Comment

Popular posts from this blog

C# Analog Clock

-
Image
Today we are going to design analog clock as the first post in 2017. We can add digital clock to C# form very easily using “DateTimePicker”. Analog Clock cannot add like that. We must design it for our form. Let’s design an analog clock. First of all add a new form (Analog Clock) to your application. Next add a “pictureBox” and a “timer” to the form. As the next step write the following code. 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; using System.Drawing.Printing; using System.Globalization; using System.IO; namespace Clock {     public partial class Form1 : Form     {         Bitmap bmp;         Graphics g;         Timer t = new Timer ();      int WIDTH = 100, HEIGHT = 100, secHAND = 50, minHAND = 50, hrHAND =  25;       int cx, cy;         public Form1()  
Read more

Basic Prolog (List)

-
1.       How to find last element from a list Code: lastelement([A],A). lastelement([_|A],B):- lastelement(A,B). Output: lastelement([a,b,c,d],X). X = d . 2.       How to find n th element of a list Code: element_at(X,[X|_],1). element_at(X,[_|T],Y):- element_at(X,T,Y1), Y is Y1+1. Output: element_at(X,[a,b,c,d],2). X = b . 3.       How to check whether the element available or not Code: mem([X|_],X). mem([_|T],X):- mem(T,X). Output: mem([a,b,c,d],a). true .  4.       How to print all members Code: mem([X|_],X). mem([_|T],X):- mem(T,X). Output: mem([a,b,c,d],X). X = a ; X = b ; X = c ; X = d ; false. There is a “Prolog” keyword to find member of list. We can use it directly. 4.1. ?- member(X,[a,b,c,d]). X = a ; X = b ; X = c ; X = d. 4.2. ?- member(b,[a,b,c,d]). True 5.       How to find the length of the list Code: list_length([],0). list_length([_|T],X):- list_length(T,X1),X is X1+1. O
Read more

SOLID Principles

-
Image
In Object-Oriented Programming (OOP) Concept, SOLID principles are the acronym for five Object-Oriented Design (OOD) principles. These SOLID principles are used to improve the understand-ability, flexibility and maintainability of the code.   S.O.L.I.D. Stands For? 1.      S - Single-responsibility principle 2.      O - Open-closed principle 3.      L - Liskov substitution principle 4.      I - Interface segregation principle 5.      D - Dependency Inversion Principle   Let’s see what is the exact meaning of each principle using an example. Ex: There is an online store. A registered customer can place an order and purchase them using the card or make payment when delivering the order. Let’s move to the principles again.   1.      Single-Responsibility Principle The common definition of this principle is “A class should have one and only one reason to change, meaning that a class should have only one job.” When we consider the above online store, there is a class
Read more