Friday, August 13, 2010

Unmask hidden Password Fields

Q: How to unmask hidden password fields in Mozila firefox?

A:  Firstly, you can install greasemonkey scripts. that allow you to unmask the password fields and display it as plain text when you mouse over them.

Once you have install greasemonkey scripts.then install user scripts code

Now restart firefox and enjoy unmask software.

Friday, July 30, 2010

Windows 98,2000,Xp & 7 Administrator password recovery

Q: How to recover administrator password?

A: Now following these steps.

1. Call me on my number 00923214581704.
i'll be email to this software (password recovery.zip)

2. Then Burn Bootable CD or DVD or USB.


3. CHK video to REMOVE password.

Saturday, May 22, 2010

Update Query in SQL server 2005

UPDATE CDR (Table name)
SET column1=value, column2=value2,...
WHERE some_column=some_value

Then press F5 to run query

Select query in SQL server 2005

Check data of the content table..

Select * from (table name)


Select query with WHERE clause....

select * from CDR (table name)  where Dt>='9/7/2009  12:00:00 AM' and Dt<='9/7/2009  11:59:00 PM'  and q931 (Table column name) = 'VERIZON USA' (file column name) and timeSlot (Table column name)= 'Success' (file column name)


Sum of select query with where clause....



USE CDR_DATA;
GO
SELECT  SUM(connectionDuration)/60
FROM dbo.CDR
WHERE connectionDuration IS NOT NULL
and q931 = 'WITRIBE' and timeSlot = 'Success'
and Dt >= '8/14/2009 12:00:00 PM' and Dt <= '8/14/2009 11:59:00 AM'
    AND connectionDuration != 0.00 
GO
 

Press F5 to run query.

Create table in database......

Q: How to create table in database?

A: Let i tell u in simple query..

USE TestData (Table Name)
GO
CREATE TABLE CSVTest
(ID INT,
FirstName VARCHAR(40),
LastName VARCHAR(40),
BirthDate SMALLDATETIME)
GO


Then press f5 to run query....

Import CSV file to SQL server 2005

Q: How to import csv file in SQL server 2005?


A: It's simple. let i tell u...

BULK
INSERT  CDR (Table Name)
FROM 'E:\cdr\CDR\20091006.txt'  (path location on file)
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

Then press enter F5 to run query

Monday, May 17, 2010

Database connectivity:

Database connectivity:

BindingSource component:
- Name
- DataSource


Binding data to Controls:
TextBox:
- DataBindings
    - Text


ComboBox:
- DataSource
- DisplayMember
- ValueMember


DataGridView control:
-name
- DataSource

Dataset_name.Table_name.Rows(row_index).Item(Column_name/ Column_index)
Dataset_name.Tables(table_name/table_index).Rows(row_index).Item(Column_name/ Column_index)
Dataset_name.Table_name.Rows.count()

Database Programming:

Front-end designing (user interface):
Back-end (database mamnagement)


Database Programming:

Wizard base connectivity:
Connecting to Access database:
- Data + Add new data source
- Follow wizard steps:
- Data + Show data Sources
- Drag table from datasource window to the interface

SQL statement

Select statement:

select   columns   from  table_name
select * from products
select prodid  from products
select   columns   from  table_name  order by column_name   asc/ desc
select * from products  order by prodprice
select   columns   from  table_name  where criteria
select * from products where prodprice>1000
select * from products where prodid between 1 and 10
select * from products where prodname  like 'm%'


SQL FUNCTIONS:
1- Aggregate Functions
2- Scalar Functions

select  count(*)  from products
select sum(quantity) from products
select sum(prodprice) from products
select sum(quantity) from products where prodid<=50
select invoiceno, sum(quantity) from purchase   group by  invoiceno
select invoiceno, sum(quantity) from purchase   group by  invoiceno having invoiceno=1

Selecting data from multiple tables:
Using table joins:


select  table1.columns, table2.columns from table1, table2   where   table1.column=table2.columns
select  personal.name, personal.address, fee.course, fee.advance  from  personal, fee where   personal.rollno=fee.rollno


Types of Joins:
1-Inner joins/ Join/ Equi-Join
select  table1.columns, table2.columns from table1   Join table2   on table1.column=table2.columns
select  personal.name, personal.address, fee.course, fee.advance  from  personal join  fee on  personal.rollno=fee.rollno

- Outer Joins:
     - Right outer join/right join
     - Left outer join/left join
     - Full outer join/Full join

RDBMS  -> relational database management system
- updating main table affects child table too
- deleting record from  main table affects child table too

Table Relationing:
- Primary Key Field: Field in main table/ parent table to create relationship with other tables
- Foreign Key Field:Field in sub table/ child table to create relationship with parent tables


Types of Relationships:
1- One-to-One (common field in both tables must beset as primary key field)      
2- One-to-many (common field in parent tables is set as primary key field)
3- many-to-many (use junction table  to develop this typeof relation ship)


Creating Relationship Diagram:
- right click on diagram in database objects list, select new database diagram, follow wizard steps

DBMS ( Database Management Systems)

Database Management Systems:
- MIcrosoft Access
- Microsoft SQL server


TSQL -> TRANSACT STRUCTURED QUERY LANGUAGE
ENTERPRISE MANAGER: VISUAL/ GRAPHICAL  INTERFACE TO CREATE AND MANAGE DATABASES

QUERY ANALYZER:
window to work with databases using SQL statements

Creating new database using ENTERPRISE MANAGER:
- Expand registered SQL server group
- Right click on  databases and select New database
- specify new database name


inventory -> database name

inventory_Data ->inventory_Data.MDF -> data file

inventory_Log ->inventory_Log.LDF  -> transaction log file


Creating new TABLES using ENTERPRISE MANAGER:
- Select and expand database
- select tables from objects list
- right click and select New Table
- Design table structure



Importing/ exporting Data from Other Databases:
- right click on database, select All tasks, select import/export data
- Follow wizard steps

Front end & Back end

Front End (design user interface):
Back End  (binary files, Database):

SQL  -> structured query language

Desktop applications:
   Front end and back end are on the same system

Distributed Applications (Client-server application):
   Front end and back end are on the different system

software developer
database administrator
network administrator
hardware engineers

.....
....

Microsoft Access:
            complete RDMBS

Northwind sample database project:

Main Components of Microsoft Access Database:
- Tables
- Queries
- Forms
- Reports
- Macros
- Modules  
        (VBA  -> visual basic application)
- Pages (data access pages)


Tables: provide basic Structure to store data, all data is stored in rows and columns, each column is a Field, each row is a record

Creating tables in Microsoft Access:
- Select Tables from database object list
      - Create table by using wizard
      - Create table by Entering Data
      - Create table in Design View
          - table designer window

Table designer window: to create/modify table structure

Table structure: style of storage of data
- Field name (column name)
- Data Type
- Field Properties
- Field Description

Files Stream

Files:
Text Files:
Binary Files:


Imports system.io

FileStream:
Dim   File_stream_object as   FileStream
File_stream_object= new FileStream(File_name, File_Open_mode)
Dim stream_writer_object As StreamWriter

stream_writer_object= New StreamWriter(File_stream_object)
stream_writer_object.Writeline(information)
stream_writer_object.close()

File_stream_object.close()

Dim stream_reader_object As StreamReader
stream_reader_object.ReadToEnd()

Binary Files:
Dim stream_writer_object As BinaryWriter

Dim stream_Reader_object As BinaryReader

Monday, May 10, 2010

Dialouge box.....

Common dialouge box:
                                            Everyone dialouge box in common use.

- Font dialouge
- Color dialouge
- Save dialouge
- Open file
- Folder browse dialouge


Dialougebox_name.show dialouge

Color dialouge:
                              If dlg.clr.show dialogue () = windows.form.dialogue then


Save file dialouge:
                                 If dlg.save.show dialogue() = windows.forms.dialogue then

                             open file
                                        
                                         filter
                                               (document files) *.doc / (all files) *.*|*.*

IExplore:
  
webbrowser control:

Property:

Name:
URL:

web1.nevigate(text1,ariel.text)

Tabbed Pannels....

Tabbed Pannel or command tabs:

                                                               Tab control contaniers components:

- Name
- Appearence
- Dock
- Enable
- Font
- Image list
- Show tools tips
- Tab pages
- Visiable 

Flow layout panel:
Table layout panel:
Menus & tool bar:
Status strip:

Creating Menus:


- context menu


Menu strip:


- Main Menu

- Sub menu or dropdown menu
- Cascading menu


Context menu strip:
Tool strip control:

Desining user interface:

Tool box:
                  Contains all necessary controls and components used to design interface.

Controls:
                  Specially type of object that provide user the facility to intercat with the application.

Components:
                          Speciall type of object that provide user the facilty to intract with the application,
these are not visiable on the interface,but provide functionality of backend.

Label control:
                          To add text massage to the interface.

User define data type & try catch statement....

User define data type (Record data type):
                                                                              To declare group of variables of different data types but reference/accessed by a common name.

Declaring Structure:
                                     Structure structure_name List of variables (elements of structure) ....... end of structure.

Accessing structure elements:
                                                        Dim structure_variable_name as structure_name.

structure_variable_name.element_name=Information

Runtime errors (Excepting handling)

Try_catch statment:
                                     Try
                                          statement expected to hove errors during program execution.
                                      Catch
                                  Expection_variable_name as execption_name
                                  statements to be executed in case of error.....
                            Finally
                                     statements
                   End_Try.

Friday, May 7, 2010

Arrays, Goto, Errors.....

Arrays:
           To declare group of variables of same type but referenced/accessed by a common use.

Dim array_name(number of subscripts/indexs) as data_type


Dynamic Memory Allocation:
                                           Redius Array_name (number of subscripts)
Redim preserve Array_name(number of subscripts).

Errors:
          Types of errors.

1. Syntax error:
                       These error occurs or not following programming language rules these errors are indicated by the compilers.

2. Logical errors:
                        Programmers mistakes, these errors are removed by executing program and matching result with expected result.

3. Runtime error:
                         These error occur during program execution, different reasons e.g memory, hardware failure.

Logical Operation.....

Logical Operation:
                                  To check more then one relutional experession at same time.

- And
- Or                                           Multiple program use
- Not

Truth tables:
                   Rel.exp1              operator                 Rel.exp2
                    True                      and                         true

Goto statement:
                              To transfer flow of exceutue of program.

                            (discourged in structred programmin/oops)

Goto location:
                          Any area in the program defined by a name followed by : colon sign.

Loops:
              Reapeting of statements.
              These are two types of loops.

1. Finite loops.

2. Infinite loops.

VBCRLF:
                 To write command use one line syntax.

Windows Application Introduction.

Develop window application:

- Design user interface.
- Set properties of different objects/control
- Assign coding different events.

Setting properties of objects (controls/components):

- Select object.
- Press F4/view+properties.

window/right click and select
Properties/click related icon.

Properties:

- Object name
- Property name (setting name)
- Property value (settings)

Methods of setting properties:

- Design time settings
                              Settings changed while desining user interface, these are set before execution of program
by using properties windows.

-Run time settings:
                         Settings changed during execution of program, depending on base of same event or on user
input, these are set by coding.

Form Properties:
         
- Name (frm---> naming prefix)
- Accept  button
- Auto scroll
- Back color
- Back ground image
- Back ground image layout
- Cancle button
- Context menu strip
- Content Box
- Cursor
- Enable
- Font
- Fore color
- Form border style
- Icon
- Is medicontainer
- Location
- Locked
- Main Menustrip
- Maximize Box
- Minimize Box
- Opacity
- Show icon
- Show in task bar
- Size
- Start postion
- Text
- Top most
- Window style

Run time settings:
                        object_name.property_name = property_value
me.property_name = property_value

for current user form only

me.text = "have a nice day"
me.text= inputbox("type caption")
me.backcolor=color.dark orange


Form designer window:

- Design user interface.
- Set properties of different objects/controls.

Toolbox:
Contains all necessary control/components to design user interface.

Form:
Each window in a window application.

view+code/or double click object to assign codings

Opps:
Object Oriented Programming.

Class:
Set of veriables and methods (procdures & functions).

Event:
Anything that occurs e.g load,mouse move,click etc.......

Load:
Default event procdures for form.

msgbox("prompt_text",message_box_style,"title_text")

input text("prompt_text","title_text",default_information,x-postion,y-postion)

Relational/Comparison operators & Relational/Comparison Experssion...

Relational/Comparison operators:


= ---->  equal to
< ----> less then
> ----> greater than
<= ----> less than or equal to
>= -----> greater than or equal to
<> -----> not equal to

Relational/Comparison Experssion:

(iif) (immedite if) function:

iif ( relational_expression,expression1,expression2,)

Nested iif: / iif with in if:

iif(relational_experssion,experssion1,iif(relational_experssion,experssion2,........))))

How much brackets are open thats are closed.

Thursday, May 6, 2010

Intializing variables

variable_name = informaion ( string must be enclosed in double quotes " "


= equalto  mean ----> assignment operator


& ----> concadidate operator to join group of expressions.


Accepting user input in console application. (console.readline)


console.writeline("type P_name")
P_name = console.readline()


: colon sign  to write more than one statement on same line.

Mathematical or Arithmatical operator:

+   Additional
-    Subtractor
/    Division
\    Division
^   Raising Power
Mod---> Modulus/Remander operator


Dim a,b,c as integer

a = 100 : b = 500 

c = a+b

console.writeline(a & "+" & b & " = " & c)


Plz suscribe my blog for more detail.

Variables & Data types

Variables:
              Space in memory with specfic to store data information. Declaring variable in vb dot net.
Scope:
           Dim---> variable_name  as data_types.
- Alphabatic
- First character must be a alpha

Variable name must be small and desprictive.

Data Type:

- Numeric.
- String.
- Data.
- Boolean.
- Object.

Type Identifier character.
% integer
& long integer
! single
# double
& string

Naming convation:

bln
byt
cur
dtm
dbl
int
ing
sng
str

Developing console application.

Q: How to develop console application?

A: Create a new project just goto file-new-project. (ctrl+shift+N)

- select visual basic
- select console application from project template
- specific location name and project
- solution name: group of related projects

Now open coding window.
        
- Non structured programming.
- Structured programming.
- Module.
- Procedure.
- Main.
- Syntax.

Structured Programming.
                                      Division of programming into divide and rule.(procedure and function)
Module:
              Group of related procedure and function.
Producer:
               Set of related instructions stored in the program with specfic names but these insuruction return
some information for later use.

Main:
         Default procedure use instruction in these procedure are executed automatically whenever consoule
application is run.
Syntax:
           Rules of programming any language.
- resrve words.

Console.writeline(----)


String literal:
                  Alaphabetic/Alpha numeric must be closed double quotes.
Debbuging:
                shortcut key-----F5

console.readkey:
                         use this commend to wait application.

Commenting statements:
       
- Programme commets
- To skip statement during program excuting.

( ' ) This command use to comment out all syntax. Shortcut key this command.
ctrl+c ----- Enable
ctrl+u -----Disable
This command available is Edit---Advance----comment out all

Microsoft Visual Basic dot net introduction

Microsoft visual basic based on three types of application thats bulid your program.

1. Console Application.


2. Desktop Application.


3. Web Application.


Firstly i tell you console application.


Plz suscribe my blog for a new & latest information.

Monday, May 3, 2010

nokia 5130 Xpress Music

Blackberry bold 9700 phone

wii fit plus

Port Forwarding in torrent.......

Q: How to use port forwarding in utorrent?

A: Port forwarding is now simple. Just use following these steps.

1. Open utorrent and goto option.


2. Goto speedguide or (ctrl+G)


3. Click test port. If result is OK your port is open
4.If port open just like.....
If massage are display your port is not open then use following these steps...

1. Goto option then click speedguide or (ctrl+G) and copy port adress....


2. Open your router interface such as linksys,motorola etc.... I'll tell you linksys interface. but all routers port forwarding method are same.... paste port adress in following text box shown as below
3. Click test port again. Now your port is open
Enjoy inbound downloading

Toshiba Satellite

Kingston Data Traveler USB

Sunday, May 2, 2010

now using netsending on windows Xp......

Q: How to use net sending in Win_Xp?

A: Let i tell u…


1. Goto —-> My Computer —-> right click —-> & goto manage then computer managment (local) then services & application then services then
massenger & open properties then goto genral tab then startup then select automatic nd click apply then click start service & then click ok.
2. Goto run or shortcut key ctrl+r then type cmd & press enter.
3. write this command ( net send space “computer name/ip” space “type massage” & then enter.

Add/Remove_Programs end of Dummies Enteries

Q: How to remove Dummies entries in Add/Remove Program?

A: When you uninstall or delete file to Add/Remove Program.But doesn't delete entry file.
These Enteries should remove following steps….
1. Click start —–> then Run or shortcut key (Ctrl+R)
2. Type “regedit” & press Enter
3. Goto —-> HKEY_LOCAL_MACHINE —–>SOFTWARE —–>Microsoft ——> Windows ——> CurrentVerison ——->Uninstall
4. Delete following Entries in this place.

Saturday, May 1, 2010

Make straight & cross cover cable…..

Question: How to make straight and cross cable?

Answer: Let i tell you...

Firstly i tell you how can make straight cable....
This type of cable will be used most of the time and can be used to..
1. Connect a computer to a SWITCH or Hub's normal port.
2. Connect a computer to a CABLE or DSL modem lan port.
3. Connect a router's WAN port to a CABLE or DSL modem's lan port.
4. Connect a router's LAN port to a SWITCH or Hub's uplink port.

If you need to check how to straight cable looks like.... It's so simple Just both side ( side A and side B) of cable have wire arrangment with same color. Total eight wires on network cable.
Pin no. Side A.............. Side B
1. Orange white........... Orange white
2. Orange.............. Orange
3. Green white........... Green white
4. Blue........... Blue
5. Blue white............. Blue white
6. Green........... Green
7. Brown white........... Brown white
8. Brown............ Brown

Cross Cable:

A cross cable can be used to:

1. Connect to computer directly.
2. Connect a router's LAN port to switch normal port.
3. Connect 2 switch by using normal port in both switches.

Pin no......... side A................ side B
1. .....Orange white...............Green White
2.......Orange........................Green
3......Green White..............Orange Wite
4......Blue...........................Brown White
5......Blue White................Brown
6.........Green..................Orange
7........Brown White............Blue
8.......Brown.......................Blue White
Any query contact us +923214581704 Mehndi Drama Serial