Sunday 13 April 2014

Insert data into database in window form


                                                                                                                                               previous
                                                                                                                                                   next
Here i will explain how to insert data into database in window form. Before this i explain that how to open a second form using first form.

Step(1) : Registration form

Here i make a registration form where i take 4 lable and 4 textbox and a button(save).

Step(2) : database

Now make a database into sql server

Step(3) : Code on save button



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

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

        private void button1_Click(object sender, EventArgs e)
        {
           SqlConnection con = new SqlConnection(str);
                String str = "server=MUNESH-PC;database=windowapp;UID=sa;password=123";
                String query = "insert into data (E.id,name,surname,age) values ('"+this.eid_txt.text+"','"+this.nametxt.text+"','"+this.surname_txt.text+"','"+this.age_txt.text+"')";
     SqlCommand cmd = new sqComamnd(query,con);         
  SqlDataReader dbr;
                       
               try
              {
               con.open();
               dbr = cmd.ExecuteReader();
                MessageBox.Show("saved");
              while(dbr.read())
             {
                 
              }
            }
            catch (Exception es)
            {
                MessageBox.Show(es.Message);

            }
        }
    }
} 

Step(4) : output


Now click on save button
                                                                                                                                               previous
                                                                                                                                                   next

How to open a second form using first form in window form

                                                                                                                                           
                                                                                                                                            previous
                                                                                                                                                 Next

Here i will explain how to open second from using first form in window form.Before this i explain that group box and picture box in window form.

Step(1):  Login form

There is a login from when i enter correct password and username then page direct to another page name is form2.




Step(2):  Add a new form

Now go to solution explorer and select your project and right click on it and select a new window form and give a name it as form2
 





And new form is


Step(3):  Coding

now click on submit button and write a code.



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

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

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (!(usertxt.Text == string.Empty))
                {
                    if (!(passtxt.Text == string.Empty))
                    {
                        String str = "server=MUNESH-PC;database=windowapp;UID=sa;password=123";
                        String query = "select * from data where username = '" + usertxt.Text + "'and password = '" +this.passtxt.Text + "'";
                        SqlConnection con = new SqlConnection(str);
                        SqlCommand cmd = new SqlCommand(query, con);
                        SqlDataReader dbr;
                        con.Open();
                        dbr = cmd.ExecuteReader();
                        int count = 0;
                        while (dbr.Read())
                        {
                            count = count + 1;
                        }
                        if (count == 1)
                        {
                           this.hide();
                           Form2  f2 = new form2();         //this is the change, code for redirect
                           f2.ShowDialog();
                        }
                        else if (count > 1)
                        {
                            MessageBox.Show("Duplicate username and password""login page");
                        }
                        else
                        {
                            MessageBox.Show(" username and password incorrect""login page");
                        }
                    }
                    else
                    {
                        MessageBox.Show(" password empty""login page");
                    }
                }

                else
                {
                    MessageBox.Show(" username empty""login page");
                }
                // con.Close();

            }
            catch (Exception es)
            {
                MessageBox.Show(es.Message);

            }
        }
    }
}

Step(4) :- output

when you click on submit button there will open a new form name is form2
                                                                                                                                            previous
                                                                                                                                                 Next

Thursday 10 April 2014

Group Box and Picture Box in window form



                                                                                                                                            previous
                                                                                                                                               Next

Here i will explain use of  Group Box and Picture Box in window form.

GroupBox :- In a groupBox other controls we can placed like a login form. When designing interface in windowsForms, you can use this control to create shape.

drage and down a group box from tool box it will look like this.





PictureBox :- Picturebox provides a rectangular region for an image. It support multiple format of images.

Step(1): Login form
firstly create a login form with 2 lable and 2 textbox and 1 button.

Step(2): groupbox
Now drag down a groupBox and place these login form into groupbox by selecting this form (shift+click).





Step(3): PictureBox

Now drag down a PictureBox.






It will look like this and for getting picture click on sideBar option and select image




Now click Ok then you will show this picture in picturebox.

 Step(3): Run 
now run you application
                                                                                                                                            previous
                                                                                                                                               Next

Wednesday 9 April 2014

Password protection using Code

 
                                                                                                                                                Previous
                                                                                                                                                    Next

Here i will explain how we do password protection using code.

Step(1) :- Create a login Form

First create a Login form as i shown you in Tutorial 2
Step (2) :- Coding

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace First_Csharp_app
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            pass_txt.passwordChar = '$';    //without this you can also do it by text box property as password
        }

        private void button1_Click(object sender, EventArgs e)
        {
                 //Coding
       }

Step (3) :- Output
                                                                                                                                                Previous
                                                                                                                                                    Next

C# program Selection Sorting

Selection sort is a straightforward sorting algorithm. This algorithm search for the smallest number in the elements array and then swap i...