C#.Net(Array And ArrayList)

In This Post We Will discuss about array and array list.Difference b/w Array and arraylist

Difference B/w Array And Array list
1.In Array We have to mention the size of array.But in Array List We Don't Need To Mention the size
2.In Array it is used for homogenous type of data.Arraylist Use for heterogeneous type of data.

C#.Net(Control Statements Syntax)

     Control Statements Syntax
Divided Into Two Parts
1.Branching
2.Looping
      1.Branching:
            1.If
                 If(Condition)
                {
                }
            2.If-else
                   If(Condition)
                  {
                  }
                   else
                  {
                  }
             3.Nested If-else
                   If(Condition)
                    {
                    }
                   else if(condition)
                    {
                    }
                    else
                     {
                     }
              4.Switch
                    Switch(a)
                       {
                     Case 0:
                    //Instructions;
                     break;
                      Case 1:
                    //Instructions;
                     break;

                        }
 2.Looping
        1.For
                for(initilization ; condition ; increment/decrement)
                  {
                             //Body(Instructions)
                  }
          2.While(conditions)
               {
                  //Body(Instructions)
                }
          3.Do-While
            do
             {
              }
             while(condition);

C#.Net(Input integer And String Values)

If U see First C#.Net Program then U Know How To Select New Console  Application.Now In This Post I Want To Tell U How to input integer and string Value In C#

Starting C#.Net(Basic Output display program)

To Make program in C#(C Sharp) We Will Use The IDE(Integrated Development Environment) Visual Studio . I Am Using Visual Studio 2010 . U can Use Which Visual Studio Version U have

Steps
1.When Open The VS Then Go to File->New->Project

2.When Click On Project A Window Will Open

3.

 
  Through this hello will display on black screen when execute it

Query string(Pass multiple value from one page to next page)

1.First page from where value input

2.coding on button event

3.Next Page

4.Coding on page load event of next.aspx page

Add Session in asp.net application and use that session in another pages

So In this i will add session in login page and i will use that session in another pages.{before this i want to tell you that your data should be present in the table  which you are accesing at login time}
Steps
1.firstly create Login Page

2.coding on button event

3.Now use this session in next page ....
        front end page
    

        back end page
                                        

Now run from the login page.....

Interview Question Of Sql Queries

1.Insert Data Into Table
insert into tablename values('column value','column value');

2.Update data Into Table
Update tablename set columnname='value' where columnname='value';

3.Delete Data FromTable
Delete from tablename where columnname='value';

4.Select data from table
select * from tablename  if want to access particular column then write select columnname1,columnname2 from tablename

5.Select Last Five Records From Table
select top(5) * from signup(tablename) order by  id(Column name) desc
Column Name data type should be int and its identity specification property should be Yes(In Sql Server)

6.If you want to see the unique record from the column in table
select distinct(column name)  fromtablename

7.Check The No Of Records in a table
select count(*) from tablename

8.Sum the salary column in table
select SUM(column name) from tablename