Tricks to create a MiNi project

         HERE WE ARE GOING TO SEE HOW TO CREATE A MINI PROJECT IN DATABASE MANAGEMENT SYSTEM

    Before straightly going inside the project let's we know about it.

    Now we are going to see how to create a mini project in the DBMS using DOT NET through VISUAL STUDIO IDE.
  
    Using this we are going to create an windows application.We can create all types of application such as android application, windows applications, etc..

    Just install the MICROSOFT VISUAL STUDIO.[IF YOU NEED JUST BRING A PENDRIVE .YOU CAN GET IT FROM US]

  Here I had installed visual studio 2008.After installing we can find our PC screen as shown above.
   *click FILE->NEW->PROJECT
you can find the screen as shown below.

    * Then a new window will appear, there select visual c# [c sharp] at the left corner and select windows below it and at the templates select windows forms application and click on OK  button.As shown below.

 * Now your screen will be got changed as shown below:

Here whatever we find inside is said to be a CONTROL.

FORM1 is also a CONTROL,if we insert a text box then it also will said to be a  CONTROL.

    *If you were unable to see the options as SOLUTION EXPLORER and PROPERTIES don't worry.There are the few steps.

    *click on VIEW on the top of the page.It will be looking like as shown below.

Here we can see some important features alone.

(i)Toolbox

(ii)Properties

(iii)Server explorer

(iv)Error list

Let's see one by one:

(i) Toolbox

By selecting view->Toolbox ,we will be find a dialogue box as shown.Here right click on the toolbox it will show option as AUTO HIDE  if u select this as shown below, it will display in left side of the dialogue box as shown below.

using this toolbox we can insert BUTTON, CHECKBOX, LABEL, LIST BOX AND SO ON...

*HOW TO INSERT A TOOLBOX FEATURE INTO FORM1:

It is a simple way that just drag and drop inside the form1 control.

 (ii)Properties

Here we can change the name of the label so that we can identify what should be entered in that title box.

And for button we can use words like SUBMIT,NEXT,OK AND SO ON..

  Here in above image if we click on button and if we view properties means there in that we can find the TEXT option.Here in that position there it is named  button1. we can change it by changing the name in properties as shown below.

(iii)Server explorer

It is used to connect our oracle database with our project.We can also connect MY SQL  (or) SQL server.

Click on server explorer, then Right click on the Data connections then select add connecton and then add Oracle Database (OracleClient) then click ok.

Enter your server name, user name ,password then click on OK button.

By connecting here itself we can see our tables and its attributes and also sequences, functions,etc as shown below.

(iv)Error list

Here using this error list we can find whether the error is there or not.Here the error will get displayed if there is presence of any errors.If there is no error means this list will be looked empty.

How to make a connectivity between our oracle table with DOT NET for our project...?

*Just DOUBLE  click on button as i had inserted early.

*There form1 design will be getting opened.Here just below the 

using System.Windows.Forms; type the sentence 

using system.data.oledb; so that here by this command we can access the oledb package which will be used instead of  several large  commands.

In system.data.oleb there four process should takes place.They are 

1.CONNECTION ESTABLISHMENT,

2.CONNECTION OPEN,

3.EXECUTION OF QUERIES,

4.CONNECTION CLOSE.

1.Connection establishment:

    Here first we want to create a connection so for that we will be using the strings.

   The below code will be used for the connection establishment

OleDbConnection conn = new OleDbConnection("PROVIDER=MSDAORA;Data Source=orcle;User ID=system;Password=gowdham;Unicode=True");

Before doing this include command given below as underlined.

Then the command used for connection establishment is 

OleDbConnection conn = new OleDbConnection("PROVIDER=MSDAORA;Data Source=orcle;User ID=system;Password=gowdham;Unicode=True");

The line in blue show be copied from your system as given below

2.CONNECTION OPEN

   OPEN THE CONNECTION BY GIVING THE COMMAND

conn.Open();

3.EXECUTION OF QUERIES

    WE CAN EXECUTE OUR QUERIES THROUGH STRINGS AS BELOW

OleDbCommand cmd = new OleDbCommand("INSERT INTO BORROW VALUES('"+textBox1.Text+"','"+textBox2.Text+"',SYSDATE,' ')", conn);

HERE TEXTBOX1 IS THE VALUE GIVEN IN TEXTBOX1 AND TEXTBOX2 IS GIVEN IN THAT TEXTBOX2

4.CONNECTION CLOSE

CLOSE USING THE COMMAND

conn.Close();

IF YOU WANT TO DISPLAY ANY CONTENT WHILE FINISHING IT CAN BE GIVEN AS BELOW 

MessageBox.Show("RECORDS INSERTED SUCCESSFULLY");

THE ABOVE WILL BE FOR BUTTONS AND TEXTBOX 

FOR GRID VIEW

THE FOLLLOWING COMMANDS WILL BE USED 

OleDbConnection conn = new OleDbConnection("PROVIDER=MSDAORA;Data Source=orcle;User ID=system;Password=gowdham;Unicode=True");

            conn.Open();

            DataSet ds = new DataSet();

            OleDbDataAdapter adapt = new OleDbDataAdapter("SELECT * FROM BORROW", conn);

            adapt.Fill(ds);

            conn.Close();

            dataGridView1.DataSource = ds.Tables[0];

TO CREATE A REPORT SELECT WINDOWS CRYSTAL VIEWER FROM TOOLBOX, THEN RIGHT CLICK ON THE PROJECT SELECT ADD->NEW ITEM ->REPORTING->CRYSTAL REPORT

NOW A REPORT HAD BEEN CREATED

Creating a nameless folder

How To Make Nameless Folder ?

Before attempting this trick, try to
make a
folder with no name and you will
fail to do so.

This is what this trick will let you
do.....!

Creating nameless folder
Make a Newfolder on desktop or
where ever
you want.

Right click on this newly created
folder and
select Rename.
Erase the text showing "New
Folder".
Now keep Pressing Alt (i.e alter
key) and type
255. If you are on laptop then you
need to
enable your Num Lock and type
from the
highlighted number keys not from
those below
function keys.
After that leave alt key and Press
enter.

Done ! You just created nameless
folder.

Time taken for Hackers to hack

TIP to KNOW

Prefer saftier one after reading this post

How Fast can a Hacker's Computer Guess your password?

-If your password is

* 6 Lowercase letters : 10 minutes
* 7 Lowercase and upper case letters : 23 Days
* 8 Lower,upper case,numbers and
symbols: 463 years

So, choose your password wisely and make it safe.........!

How anti-virus software detects virus ?

How Does Anti virus detects
viruses?

I hope you know what is computer
Anti Virus.
But you may not know how the anti
virus
works. Here i am sharing how the
antivirus
software works.

* What you know about Anti Virus
software?
Antivirus software gives protection
against the
viruses and Malware. Antivirus can
detect the
malicious software ,then delete or
put it in
quarantine.

# The process behind the Anti Virus
The Antivirus follows two methods
to detect the
malicious software.
They are,

* Virus Dictionary Based Detection
* Suspicious Activity Detection

1.Virus Dictionary Based Detection :

In this method, Antivirus manage a
dictionary
file which has the identified virus
signatures.
Whenever an executable is running,
antivirus
will check the executable file
source code with
the dictionary. If the source code
match with
any virus signature, then antivirus
will
immediately inform you that the
virus is found.
Antivirus will check the executable
file whenever
file is opened or created or emailed
or
downloading.

Example:
Let us assume the malicious code
is
"11010011" and this code is in
dictionary file. If
any executable file runs with the
above
malicious code, the antivirus
immediately block
and alerts the user.
Day to day the hackers can create
new viruses,
the source code of virus will vary.
The antivirus
can not detect the virus with old
Signature of
viruses. You have to update the
virus signature
so that it can detect new viruses.

Drawback of this Method

Hackers found a hacking trick to
bypass this
security method, The Crypter. Yes,
hackers can
encrypt the source code into
different source
code such that it will look like
safest source
code. So if the antivirus checks for
the source
code, it won't find the malicious
code (because
it is another form).
The drawback can be solved by
including the
crypted malicious code to
dictionary file.

2.Suspicious Activity Detection :

The suspicious activity detection
method is
more effective than the Dictionary
based
approach. It can detect even a new
virus.
Antivirus observes the behavior of
the
executable file. If the executable
file does any
illegal process or create any
executable file, the
antivirus will block the executable
file and alert
the user .

Drawback

It is annoying process. The
accuracy is less so
it may detect any safe executable
file as virus.

Tricks on Google

Tricks to try in Home page of Google :

1. Google Gravity (Google
Magic) :

Open any web browser
(Google Chrome). Type
“ Google Gravity “ into the
search query bar then click
on I’m Feeling Lucky button.
Watch the Google home page
to come crashing down to
the bottom. Try this as a trick
on friends or family that They
may believe they broke
Google’s website. Click any
of the elements, move your
cursor and release them.
When you search “Flowers”
into query bar then all results
show in gravity.
Experience: Amazing Google
Gravity effects via elgooG .

2. Google Sphere :

Google Sphere will have to
type into the query bar, then
please click on the I’m
Feeling Lucky button. You
will see all the elements that
are circulating in the shape
of spheres. When you will
search in the search bar, they
will also circulate in the
shape of spheres. Normal
photos show just a single
viewpoint while photo
spheres.

3. Google Rainbow :

Google Rainbow will have to
type into the query bar, then
please click on the I’m
Feeling Lucky button. The
color pattern of a rainbow is
different from a spectrum.
Newton originally (1672)
divided the spectrum into
Seven main colors: Red,
Orange, Yellow, Green, Blue,
Indigo, Violet. All elements of
Google appear as a rainbow.

4. Google Epic :

Google Epic will have to type
into the query bar, then
please click on the I’m
Feeling Lucky button. All the
elements seem to be larger
and larger. When You search
“Toy” / “Flowers” after that
click on I’m Feeling
EXCESSIVE, Open online or
branded official websites.

5. Google Hacker :

Ever wondered what Google
would look like if it was
hacked? Google Hacker can
give you an idea of such a
scenario.
In Google hacker tricks, all
elements change into
numbers, alphabets and
special characters. You can
also search ( Google
l33t/1337 ) into query bar and
click I’m Feeling Lucky
button.

Www.tricksout.blogspot.in

VIDEOS IN BLOG?

   Are you feeling difficult to upload videos... 

you don't have any ideas to do it?

   It is a simple process we can do it easily.. 

     Blog is a initiative of an website.Where we can expose our views and ideas through this free site.Inserting videos,images,audios everything can be done easily.

 DO YOU WANT TO KNOW HOW TO INSERT AN IMAGE IN YOUR BLOG POST.IT IS VERY SIMPLE AND EASY PROCESS JUST FOLLOW BELOW STEPS:

• JUST CLICK ON NEW POST
• JUST START TYPING YOUR POST
• CREATE THE POST, AND IF YOU NEED TO INSERT AN VIDEO, IT CAN BE DONE EASILY.
• CLICK ON THE INSERT VIDEO ICON THERE ABOVE AS SHOWN BELOW:

  

  
  

• AFTER CLICKING A SMALL NEW TAB WILL GET OPEN.IN THAT SELECT THE OPTION FROM WHICH YOU GOING TO UPLOAD AN VIDEO.
• IT WILL TAKE TIME TO GET UPLOAD, THEN CLICK ON ADD SELECTED.
• YA. HERE YOUR VIDEO IS SUCCESSFULLY UPLOADED INTO YOUR POST.
• JUST ENJOY BY WATCHING THE VIDEO BELOW.