Dot Net WindowsForms Interview Preparation Guide

You have to get the "dotnet driver" of the database (or any
other datasource) you want to access to.

For example:
MySQL: Connector/Net
Access: Microsoft Access Driver
Oracle: Oracle Data Access Components (ODAC)

Afterwards you build a connection string to tell your
programm which driver you want to use and where the
datasource can be found, for example:

public const string DB_CONN_STRING =
"Driver={Microsoft Access Driver (*.mdb)}; "+
"DBQ=D:\\CS\\TestDbReadWrite\\SimpleTest.mdb";

Afterwards you just have to open a connection to the
database using the previously created connection string and
send a query to the database to get the record:

ADOConnection conn = new ADOConnection(DB_CONN_STRING);
conn.Open();
ADODataReader dr;
ADOCommand cmd = new ADOCommand( "SELECT * FROM <table>",
conn );
cmd.Execute(out dr);
while (dr.Read()){
....}

Its very easy.
1-Take a barcode font like we used Arial, Time new Roman
2-Install this font at window fonts directory
3-Use Steric (*) at both ends of a field of Report with the
help of double/single commas
4.Change this field Font Like from Time new roman to
Barcode font
e.g Bar is field that contain digit from 1 to 8 as shown
below
*12345678*
After changing font these digit were converted into Black
Lines mean barcode
|||||||||||||||

5-Take print of barcode and enjoy.

Dim Query
Query="insert into TableName(username)values('" &
txt_username.text & "')"
Dim cmd as sqlclient.sqlcommand=new
sqlclient.sqlcommand(Query,connection)
cmd.ExecuteNonquery()

insert into <tablename> values (Parm1,parm2....)

validate event to cntrl

In List Box we have to choose one of the option from the
drop down list
In Combo just like radio button we have to choose any one

Item property cannot be set at runtime.

Listindex : This property is used to check the index value
of the items in the Listbox

Tabindex : This property is used to set the flow of
controls in the form when we press the tab button.

Z order method is the use of the show the design of the
output form to use z order technique.
z order technique is Show view of the Z corner to print the
z style.
Z order is Access the data in the two dimension Array to
access data
Ex:
1234
5678
9065
call Z order method to pass order For ex: pass 3
then output is
1396 to Access four corner of the z order

TextBox.Enabled = True;

This property is used to lock the text box to enter data.