COPYING FILE USING FILE HANDLING

FILE HANDLING 

STREAM

STREAM IS A CONCEPT BY WHICH WE CAN CONNECT DIFFERENT DEVICES LIKE CONSOLE,HDD,PENDRIVE ETC AND ALSO USE READ AND WRITE OPERATIONS.  

TYPES OF STREAM

• FILE ORIENTED STREAM.
• CHARACTER ORIENTED STREAM.

EXAMPLE OF FILE STREAM

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.IO;

namespace FileHandling

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        

        private void copyingfi_Click(object sender, EventArgs e)

        {

            FileStream source = new FileStream("C:\\sachin.ini", FileMode.Open);

            FileStream destination = new FileStream("D:\\sachin.ini", FileMode.Create);

            source.CopyTo(destination);

            while (true)

            {

                int i = source.ReadByte();

                if (i == -1)

                {

                    break;

                    destination.WriteByte(Convert.ToByte(i));

                  

                }

                

                destination.Close();

                

            }

        }

    }

}

racing numbers using multithreading in c#.

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.Threading;

namespace MultiThreading
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private bool check = true;
        public void race1()
        {
            for (int i = 0; i <=5000; i++)
            {
                if(check)
                {
                    textBox1.Text = i.ToString();
                }
                else
                    break;
            }
            check = false;
        }
        public void race2()
        {
            for (int i = 0; i <=5000; i++)
            {
                if (check)
                {

                    textBox2.Text = i.ToString();
                }
                else
                    break;
            }
            check = false;
        }
        private void button1_Click(object sender, EventArgs e)
        {
            Thread th1 = new Thread(race1);
            th1.Name = "thread1";
            Thread th2 = new Thread(race2);
            th2.Name = "thread2";
            th1.Start();
            th2.Start();
        }

 private void btnsuspend_Click(object sender, EventArgs e)
        {

            Thread th1 = new Thread(race1);
           
            Thread th2 = new Thread(race2);
          
            th1.Suspend();
            th2.Suspend();
        }

        private void btnresume_Click(object sender, EventArgs e)
        {
            Thread th1 = new Thread(race1);

            Thread th2 = new Thread(race2);

            th1.Resume();
            th2.Resume();
        }

        private void btnabort_Click(object sender, EventArgs e)
        {
             Thread th1 = new Thread(race1);

            Thread th2 = new Thread(race2);

            th1.Abort();
            th2.Abort();
        } private void btnsuspend_Click(object sender, EventArgs e)
        {

            Thread th1 = new Thread(race1);
           
            Thread th2 = new Thread(race2);
          
            th1.Suspend();
            th2.Suspend();
        }

        private void btnresume_Click(object sender, EventArgs e)
        {
            Thread th1 = new Thread(race1);

            Thread th2 = new Thread(race2);

            th1.Resume();
            th2.Resume();
        }

        private void btnabort_Click(object sender, EventArgs e)
        {
             Thread th1 = new Thread(race1);

            Thread th2 = new Thread(race2);

            th1.Abort();
            th2.Abort();
        } private void btnsuspend_Click(object sender, EventArgs e)
        {

            Thread th1 = new Thread(race1);
           
            Thread th2 = new Thread(race2);
          
            th1.Suspend();
            th2.Suspend();
        }

        private void btnresume_Click(object sender, EventArgs e)
        {
            Thread th1 = new Thread(race1);

            Thread th2 = new Thread(race2);

            th1.Resume();
            th2.Resume();
        }

        private void btnabort_Click(object sender, EventArgs e)
        {
             Thread th1 = new Thread(race1);

            Thread th2 = new Thread(race2);

            th1.Abort();
            th2.Abort();
        }


 {  
        private void Form1_Load(object sender, EventArgs e)
        {
            Control.CheckForIllegalCrossThreadCalls = false;
        }
    }
}

   

Introduction of ASP.NET

                        About asp.net

Asp.net is a wep applications framework developed and marked by Microsoft to allow programmers to build dynamic websites.

                  Definition of asp.net

Asp.net is a web development platform which provides a programming model, a comprehensive software infrastructure and various services required to build up robust web applications PC as well as mobile device. Asp.net works on top of the http command's and policies to set a browser to server bilateral communication and cooperation. Asp.net is a part of Microsoft .net platforms
ASP.NET is great for building standards-based websites with HTML5, CSS3, and JavaScript. ASP.NET supports three approaches for making web sites. ASP.NET Web Forms uses controls and an event-model for component-based development. ASP.NET MVC values separation of concerns and enables easier test-driven development. ASP.NET Web Pages prefers a single page model that mixes code and HTML markup. You can mix and match these techniques within one application depending on your needs - it's all One ASP.NET.

stored procedure and multiple query in a single procedure.

Definition of stored procedure.

In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).

Create a stored procedure.

create procedure myprocedure

as

begin

(query)

end 

Multiple query in a single procedure.

 

 USE [SqlPractise]

GO

/****** Object:  StoredProcedure [dbo].[myprocedure]    Script Date: 01/15/2016 09:30:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[myprocedure]

@function nvarchar(50)=null,

@Emailid nvarchar(50)=null,

@sreno int= 0,

@name nvarchar(50)=null,

@password nvarchar(50)=null,

@status nvarchar(50)=null,

@activation nvarchar(50)=null

as

begin

if @function='insert'

begin

insert into dbo.gridview(name,Emailid,password,status,activation)values (@name,@Emailid,@password,@status,@activation)

end

if @function='select'

begin

select *from dbo.gridview

end

if @function='selecttrue'

begin

select *from dbo.gridview where activation='true'

end

if @function='selectfalse'

begin

select *from dbo.gridview where activation='false'

end

if @function='update'

begin

update dbo.gridview  set name=@name,Emailid=@Emailid, password =@password,status=@status,activation=@activation

end

if @function='delete'

begin

delete from dbo.gridview where Emailid=@Emailid

end

if @function='search'

begin

select * from dbo.gridview where Emailid=@Emailid and password =@password

end

if @function='update1'

begin

update dbo.gridview  set activation='true' where Emailid=@Emailid

end

end

reversing string and count string in c#.net

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 reversing_of_string
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        string str, revstring;
            int length;

        private void button1_Click(object sender, EventArgs e)
        {
          //  string sac;
            str = txtrev.Text;
            length = str.Length - 1;

            while (length>=0)
            {
               // sac = length + 1.ToString();
                revstring = revstring + str[length];
                length--;
             
            }
            MessageBox.Show(revstring);
        }
        private int getcount(string text)
        {
            int wordcount=text.Split(' ').Length;
            return wordcount;

        }

        private void button2_Click(object sender, EventArgs e)
        {
            int mm = getcount(txtrev.Text);
            MessageBox.Show(mm.ToString());

        }
    }
}

Installing MySql software in windows

Installing MySQL on Windows:

Default installation on any version of Windows is now much easier than it used to be, as MySQL now comes neatly packaged with an installer. Simply download the installer package, unzip it anywhere, and run setup.exe.

Default installer setup.exe will walk you through the trivial process and by default will install everything under C:\mysql.

Test the server by firing it up from the command prompt the first time. Go to the location of the mysqld server which is probably C:\mysql\bin, and type:

mysqld.exe --console

NOTE: If you are on NT, then you will have to use mysqld-nt.exe instead of mysqld.exe

If all went well, you will see some messages about startup and InnoDB. If not, you may have a permissions issue. Make sure that the directory that holds your data is accessible to whatever user (probably mysql) the database processes run under.

MySQL will not add itself to the start menu, and there is no particularly nice GUI way to stop the server either. Therefore, if you tend to start the server by double clicking the mysqld executable, you should remember to halt the process by hand by using mysqladmin, Task List, Task Manager, or other Windows-specific means.

Verifying MySQL Installation:

After MySQL has been successfully installed, the base tables have been initialized, and the server has been started, you can verify that all is working as it should via some simple tests.

Use the mysqladmin Utility to Obtain Server Status:

Use mysqladmin binary to check server version. This binary would be available in /usr/bin on linux and in C:\mysql\bin on windows.

[root@host]# mysqladmin --version

It will produce the following result on Linux. It may vary depending on your installation:

mysqladmin  Ver 8.23 Distrib 5.0.9-0, for redhat-linux-gnu on i386

If you do not get such message, then there may be some problem in your installation and you would need some help to fix it.

Execute simple SQL commands using MySQL Client:

You can connect to your MySQL server by using MySQL client using mysql command. At this moment, you do not need to give any password as by default it will be set to blank.

So just use following command

[root@host]# mysql

It should be rewarded with a mysql> prompt. Now, you are connected to the MySQL server and you can execute all the SQL command at mysql> prompt as follows:

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.13 sec)

Post-installation Steps:

MySQL ships with a blank password for the root MySQL user. As soon as you have successfully installed the database and client, you need to set a root password as follows:

[root@host]# mysqladmin -u root password "new_password";

Now to make a connection to your MySQL server, you would have to use the following command:

[root@host]# mysql -u root -p
Enter password:*******

UNIX users will also want to put your MySQL directory in your PATH, so you won't have to keep typing out the full path every time you want to use the command-line client. For bash, it would be something like:

export PATH=$PATH:/usr/bin:/usr/sbin

Running MySQL at boot time:

If you want to run MySQL server at boot time, then make sure you have following entry in /etc/rc.local file.

/etc/init.d/mysqld start

Definition of Mysql and Database

MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise stack called LAMP. LAMP is a Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language. (Sometimes Perl or Python is used instead of PHP.)MySQL, which was originally conceived by the Swedish company MySQL AB, was acquired byOracle in 2008.  Developers can still use MySQL under the GNU General Public License (GPL), but enterprises must obtain a commercial license from Oracle.

Offshoots of MySQL are called forks. They include: 

Drizzle – a lightweight open source database management system in development based on MySQL 6.0.

What is Database?

A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds.

Other kinds of data stores can be used, such as files on the file system or large hash tables in memory but data fetching and writing would not be so fast and easy with those types of systems.

So nowadays, we use relational database management systems (RDBMS) to store and manage huge volume of data. This is called relational database because all the data is stored into different tables and relations are established using primary keys or other keys known as foreign keys.

A Relational DataBase Management System (RDBMS) is a software that:

• Enables you to implement a database with tables, columns and indexes.
• Guarantees the Referential Integrity between rows of various tables.
• Updates the indexes automatically.
• Interprets an SQL query and combines information from various tables.

RDBMS Terminology:

Before we proceed to explain MySQL database system, let's revise few definitions related to database.

• Database: A database is a collection of tables, with related data.
• Table: A table is a matrix with data. A table in a database looks like a simple spreadsheet.
• Column: One column (data element) contains data of one and the same kind, for example the column postcode.
• Row: A row (= tuple, entry or record) is a group of related data, for example the data of one subscription.
• Redundancy: Storing data twice, redundantly to make the system faster.
• Primary Key: A primary key is unique. A key value can not occur twice in one table. With a key, you can find at most one row.
• Foreign Key: A foreign key is the linking pin between two tables.
• Compound Key: A compound key (composite key) is a key that consists of multiple columns, because one column is not sufficiently unique.
• Index: An index in a database resembles an index at the back of a book.
• Referential Integrity: Referential Integrity makes sure that a foreign key value always points to an existing row.

MySQL Database:

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons:

• MySQL is released under an open-source license. So you have nothing to pay to use it.
• MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
• MySQL uses a standard form of the well-known SQL data language.
• MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
• MySQL works very quickly and works well even with large data sets.
• MySQL is very friendly to PHP, the most appreciated language for web development.
• MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
• MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

Before You Begin:

Before you begin this tutorial, you should have a basic knowledge of the information covered in our PHP and HTML tutorials.

This tutorial focuses heavily on using MySQL in a PHP environment. Many examples given in this tutorial will be useful for PHP Programmers.

What is Database?

A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds.

Other kinds of data stores can be used, such as files on the file system or large hash tables in memory but data fetching and writing would not be so fast and easy with those types of systems.

So nowadays, we use relational database management systems (RDBMS) to store and manage huge volume of data. This is called relational database because all the data is stored into different tables and relations are established using primary keys or other keys known as foreign keys.

A Relational DataBase Management System (RDBMS) is a software that:

• Enables you to implement a database with tables, columns and indexes.
• Guarantees the Referential Integrity between rows of various tables.
• Updates the indexes automatically.
• Interprets an SQL query and combines information from various tables.

RDBMS Terminology:

Before we proceed to explain MySQL database system, let's revise few definitions related to database.

• Database: A database is a collection of tables, with related data.
• Table: A table is a matrix with data. A table in a database looks like a simple spreadsheet.
• Column: One column (data element) contains data of one and the same kind, for example the column postcode.
• Row: A row (= tuple, entry or record) is a group of related data, for example the data of one subscription.
• Redundancy: Storing data twice, redundantly to make the system faster.
• Primary Key: A primary key is unique. A key value can not occur twice in one table. With a key, you can find at most one row.
• Foreign Key: A foreign key is the linking pin between two tables.
• Compound Key: A compound key (composite key) is a key that consists of multiple columns, because one column is not sufficiently unique.
• Index: An index in a database resembles an index at the back of a book.
• Referential Integrity: Referential Integrity makes sure that a foreign key value always points to an existing row.

MySQL Database:

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons:

• MySQL is released under an open-source license. So you have nothing to pay to use it.
• MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
• MySQL uses a standard form of the well-known SQL data language.
• MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
• MySQL works very quickly and works well even with large data sets.
• MySQL is very friendly to PHP, the most appreciated language for web development.
• MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
• MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

Before You Begin:

Before you begin this tutorial, you should have a basic knowledge of the information covered in our PHP and HTML tutorials.

This tutorial focuses heavily on using MySQL in a PHP environment. Many examples given in this tutorial will be useful for PHP Programmers.