Sunday, 13 April 2014

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

Tuesday, 8 April 2014

Creating Login Form with Sql Server in window form

                                     
                                                                                                                                     Previous
                                                                                                                                           Next

Here i will explain a how to create a login form with Sql Server. before this i explain that to connect window form with database(sql server).

Step(1):  login form
 drag and down two lable (for username and password) and two text box and a button(submit) on window form and change their name as  usrtxt and passtxt.

Step(2):database table

Step(3): Coding on button click
click on button and write this 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();
        }

        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)
                        {
                            MessageBox.Show("username and password is correct");
                        }
                        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(3): Run your application
if username and password is not correct
if username and password is correct



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