Friday 13 December 2013

How to insert data with query into table in visual studio using c#?

Firstly select the option new query from tables.


 Then a tab displays on screen from that click add and close the tab.


Then write the code for inserting data into table.

Execute SQL by clicking the symbol ! on top.

Then you can see the label one row affected.So SQL query is executed.
See data by clicking option"show table data"



Thursday 12 December 2013

How to create a database with tables to store inputs in visual studio using c#

Take the option server explorer from  view.
On top of data connections click the image with label "connect to database".
Then you can view a tab where we have to fill database new or existing with a new name like "dbs" or any other name.

Then you can see dbs.mdf symbol,which shows database is created.
Click it and you can see many options from that select option "Tables".

From Tables click option "add new table".


Then a  tab comes where you can fill the table details.
Here you have to select the apt data type for each column.


Thursday 5 December 2013

How to add image into a webform in visual studio using c#.





Firstly add image by clicking the option "add existing item" from the website "demo"(can give any name) on solution explorer.
Then we can select any image from computer and add it in solution explorer.
From toolbox then select "image " into web form demo1.
Then change properties of it where imageurl option is to be changed by adding image.
web form demo1 in website demo
Clicking option add existing item from website demo
Here remember to change file name to all files and select any image
Now add image from toolbox to webform like this

select image and change property by adding image into  image url like this
image added

Friday 29 November 2013

How to create a username and password page with login to another page?

Step 1-Firstly from toolbox select Label and select properties from solution explorer of label and change text "username"in demo.aspx web form..
Step 2-Similarly for password also select a Label and change text "password".
Step 3-Then straight to username label place textbox for the input of username.
Step 4-Similarly for password place a textbox.
Step 5-Then select validation from toolbox for both username and password.
For both regular expression validation is to be selected.
Step 6-For username change properties of validation where error message "enter email"
and control to validate "Textbox1",validation expression "\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" is to be given.
Step 7-Similarly for password validation property error message "enter password",control to validate "Textbox2",validation expression "\d{6}" is to be given. 
Step 8-Now from toolbox button is selected change properties from solution explorer where text "login",PostBackUrl "demo2.aspx" is to be selected.
Step 9-click the login button and write this code.
Code
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;


public partial class demo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text=TextBox1.Text;
        Label2.Text=TextBox2.Text;
    }
}

Thursday 28 November 2013

How to create a new website,web form in visual studio with visual c#


Microsoft visual studio-It is an integrated development environment(IDE) or interactive development environment  from Microsoft.That means IDE  is a software application which provide a comprehensive facility to computer programmers for software development.An IDE  mostly consists of a source code editor,build automation tool and a debugger.Some contains a compiler and interpreter both like Net Beans and Eclipse.
To create a website
File->New->Website->ASP.NET Empty Website


 

Installed templates->visual c#
Change  C:\Users\Administrator\Documents\Visual Studio 2010\WebSites\Websites1 to

 C:\Users\Administrator\Documents\Visual Studio 2010\WebSites\Demo
Where Demo or any other names can be given.Then  a project named Demo is created successfully.

In right side we can see a solution explorer tab ->right click and select the option 'add new item'->
Web form->name given as 'demo1.aspx' is added.
Here you can see the demo1.aspx web form.
Here you can get the design,split and source page which would be named as demo1.aspx

Tuesday 26 November 2013

Myths on testing

Myths:"Testing is too expensive"-Test when software development,it results in lesser cost.Otherwise the resulting product will be useless and have to pay more for maintenance and correction later.

Myths:"Missed bugs are due to testers" -It is not right to blame testers for bugs remaining.It depends on time,cost and requirement changing constraints.
Myths:"If software is tested it must be bug free"-No one can say that the software is 100% bug free if tester will superb skills has tested it.

Myths:"Anyone can test the software"-Testers know it well that it is a myth.It is not even possible for whose who developed it to find the bugs.

Myths:"Testers task is to find the bugs"-Testers understand the overall working of the software,what the dependencies are,and what the impacts of one module on another module are.Developers are only responsible for the specific component that is assigned to them.

Software Testing Overview

Testing-It is the process of evaluating a system or its components with the aim to find that whether it satisfies the specified requirements or not.

When to start testing?
An early start to testing reduces the cost,time to rework and error free software that is delivered to the client.

When to stop testing?
Testing is a never ending process.No one can say that any software is 100% tested.

Following professionals are included in testing field-

  • software testers
  • software developers
  • project managers
  • end users
Myths on testing

Sunday 24 November 2013

ATM



Full form is automated teller machine.ATM's are very basic computer(or data terminal).It have 2 input devices keypad,card reader and 4 output devices cash dispenser,receipt printer,speaker and screen.
Procedure
  • Firstly insert a card into the card reader.The card reader reads information encoded on the magnetic strip on back of the card.
  • The card black strip is encoded with a unique card number,expiry date or CVV and a PIN.
  • Response to the prompts on the screen.The ATM asks the PIN.The authentication to access account fund is provided by entering the PIN(personal identification number).
  • ATM communicates with bank and within a minute we get money and a receipt from the bank account balance.

Friday 22 November 2013

Difference between Internel and External modem

Internal modem
Internal modem-It is plugged directly into the CPU.Physically it is in the form of a card plugged into one of the expansion slots on the mainboard on CPU.The advantage is lesser in price and economical compared to external modem.The drawback of is that it has no indicator which is present in external modem.
External modem

External modem-It is connected external to the CPU.It is connected to CPU through an USB.It uses separate voltage source as an adapter.The advantage is its portability so that it can be used for another computer.It is equipped with an indicator which allow us to monitor the status of it.The drawback is it is expensive and need a separate space to put it though small.

Wednesday 20 November 2013

How Internet Speed Is Measured

Internet speed is measured in bits by service provider.Since most computer files arrange data in group of eight bits.8 bit=1 bytes.For this reason transfer rate shown when files are downloaded is always in bytes.

  • bit per second=bps
  • kilobit per second=kbps
  • megabit per second=mbps
  • byte per second=Bps
  • kilobyte per second=kBps
  • megabyte per second=mBps
Bit(binary digit)-A bit is the smallest unit of data in computer.A bit has a single binary value either 0 or 1.
Bit rate-It is the rate of bits transmitted usually per second.
  • 4 bits called nibble
  • 8 bits=1 byte(octet)
  • 4 byte=a 32 bit word
  • 1000 bits= 1 kilo bit
  • 1000 kilobits=1 megabit
Example-
 a 6 kbps internet connection can transfer data at speed of 6000 bits per second (since 1000 bits=1 kilobits)

Tuesday 19 November 2013

Things needed to get Internet connection

1. a computer

2. a modem- The modem is used to modulate digital data of a personal computer to electrical signals,these signals are transmitted through telephone lines and demodulated by another modem at the receiver side to recover the digital data.

3. a telephone line-It refers to the physical wire which connects users telephone to the telecommunication network.

4. an internet browser- The main purpose of browser is to bring information to the user (retrieve) ,allowing them to view the information (display) and access other information (navigation) on www.
They can also be used to access information provided by web servers in private network or files in file system.The major web browsers are Google chrome,Mozilla Firefox,Internet Explorer,Opera,Safari.

5. software to connect to ISP
6.an ISP account with username and password

Tuesday 29 October 2013

Internet

  • Internet means connecting one computer to any other computer anywhere in world via dedicated routers or servers.
  • When two computers are connected through internet they can share any kind of information like text,voice,video,images,computer programs etc..
  • The high speed fiber optic cables through which internet data travels are owned by telephone companies in their respective companies.
  • Through internet users in one computer can talk directly to users in other computer.
  • Today internet is accessible by hundreds of millions of people worldwide.
  • Internet was conceived by ARPA(Advanced Research Project Agency)of USA government in 1969 and was first known as ARPANET.The aim was to create a network that would allow users of a research computer at one university to talk to research computer  at other university.
  • Via internet the world wide web(www or web) is accessed.

Saturday 26 October 2013

Computer Output Devices

Definition
These are devices  which are used to get information out of a computer.
It is an equipment connected to a computer and used to transfer data out of the computer in the form of text, images, sounds, or other media.
Examples 
Monitor-It is the screen on which words, numbers, and graphics can be seen.

Printer-A printer prints whatever is on the monitor onto paper.  Printers can print words, numbers, or pictures.

Speaker-It gives sound from computer,some speaker are inbuilt and some separate.

Disk drive-It is used to record information from computer to CD/floppy disk.

Headphone-It give sound from computer.It is similar to speaker,but the only difference is that they are worn on the ears so only one person can hear the output at a time.

Friday 25 October 2013

Computer Input Devices

Input device-It is any peripheral device(piece of computer hardware equipment)which is used to put information into the computer.
Examples
Camera-It can be used to take a picture,record a video or for live conversation.


CD-Since CD stores information,it can be opened and added into another computer.


Keyboard-It input numbers or letters into different applications or programs.


Digital camera-It can be used to transfer pictures or videos into the computer.


Drawing Tablet-It has a pen to write on it.When connected to computer,the word or image you draw can be saved to computer.


Microphone-Through it we can record sound and save it on computer.


Scanner-It is used to copy pictures or other things and saved on computer.


Bar code scanner-It is used to scan a little label that has a bar code in it.The information is saved in computer then.


Disk drive-It can hold a CD or floppy disk.It reads information on it.


Mouse-It is used to open/close files,navigate websites,and click on lots of commands on different applications.

What is a computer


It is an electronic device.
It has the ability to store,retrieve and manipulate data.
It is a device that accepts information and manipulates it for some result based on a sequence of instructions on how the data is to be processed.
It accepts inputs,stores,manipulates and generates output in form of number,text,graphics,voice or video file according to the instructions called programs.
It consists of input device,output device and CPU.
It can be used to type documents,send email,browse internet.
All types of computer consist of two basic parts-hardware and software.
Hardware is any part of computer that has a physical structure,such as a computer  monitor or a keyboard.
Software is any set of instructions that tells hardware what to do.Examples are web browser,game,and word processors such as Microsoft word.
Hardware examples-

 Software example-