How to add validation controls to update event in gridview?

In this article  i will explain how to validate the controls which are placed in grid view
http://aswinialuri.blogspot.in/2014/03/how-to-insert-editdelete-update-and.html

In the above article i explained how to insert,edit,delete,update and cancelling operations in grid view using Asp.net.
So here  i will explain how to update the data using validation to avoid  empty cell upadating

code in .aspx page:

 <div>

    <asp:GridView ID="gridview" runat="server" AutoGenerateColumns="False" 

            AutoGenerateEditButton="True"  AutoGenerateDeleteButton="True" 

             DataKeyNames="Id" onrowcancelingedit="gridview_RowCancelingEdit" 

            onrowdeleting="gridview_RowDeleting" onrowediting="gridview_RowEditing" 

            onrowupdating="gridview_RowUpdating" >

            

            <Columns><asp:TemplateField HeaderText="Id"><ItemTemplate><asp:Label ID="lbl_id" runat="server" Text='<%#Eval("Id")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_id" runat="server" Text='<%#Eval("Id")%>'></asp:TextBox>

            </EditItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Name"><ItemTemplate><asp:Label ID="lbl_name" runat="server" Text='<%#Eval("Name")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_name" runat="server" Text='<%#Eval("Name")%>'></asp:TextBox>

            </EditItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Salary"><ItemTemplate><asp:Label ID="lbl_sal" runat="server" Text='<%#Eval("salary")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_salary" runat="server" Text='<%#Eval("salary")%>'></asp:TextBox>

            </EditItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Department"><ItemTemplate><asp:Label ID="lbl_dept" runat="server" Text='<%#Eval("Department")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_dept" runat="server" Text='<%#Eval("Department")%>'></asp:TextBox>

                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="txt_dept" Text="*" runat="server" ErrorMessage="RequiredFieldValidator"></asp:RequiredFieldValidator>

            </EditItemTemplate>

            </asp:TemplateField>

             </Columns>

        </asp:GridView>

        <br />

    </div>

    <table><tr><td>Id:</td><td>

            <asp:TextBox ID="txt_id" runat="server"></asp:TextBox></td></tr>

            <tr><td>Name:</td><td>

                <asp:TextBox ID="txt_name" runat="server"></asp:TextBox></td></tr>

                <tr><td>Salary:</td><td>

                    <asp:TextBox ID="txt_salary" runat="server"></asp:TextBox></td></tr>

                    <tr><td>Department:</td><td>

                        <asp:TextBox ID="txt_dept" runat="server"></asp:TextBox></td></tr>

                        <tr><td colspan="2" align="center">

                            <asp:Button ID="btn_submit" runat="server" Text="Submit" 

                                onclick="btn_submit_Click" /></td></tr>

            </table>

code in .aspx.cs page:

//To update a row event

 protected void gridview_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow row = gridview.Rows[e.RowIndex] as GridViewRow;
        int id = Convert.ToInt32(gridview.DataKeys[e.RowIndex].Values["Id"].ToString());
        TextBox txtname = (TextBox)gridview.Rows[e.RowIndex].FindControl("txt_name");
        TextBox txtsalary = (TextBox)gridview.Rows[e.RowIndex].FindControl("txt_salary");
        TextBox txtdepartment = (TextBox)gridview.Rows[e.RowIndex].FindControl("txt_dept");
        SqlConnection con = new SqlConnection(strcon);
        SqlCommand cmd = new SqlCommand("update Emp1 set Name=@Name,salary=@salary,Department=@Department "+" where Id=@Id", con);
        cmd.Parameters.AddWithValue("@Name", txtname.Text);
        cmd.Parameters.AddWithValue("@salary", txtsalary.Text);
        cmd.Parameters.AddWithValue("@Department", txtdepartment.Text);
        cmd.Parameters.AddWithValue("@Id",id);
        con.Open();
        cmd.ExecuteNonQuery();
        gridview.EditIndex = -1;
        con.Close();
        binddata();

    }

I f you click on update button 

required field validator is set into the department if you leave the text box empty it shown an error so the row will not be updated and you will assign the text for particular department .

I hope you understand the article how to validate the text in row event

If you have any queries make a comment.

How to Insert, Edit,Delete ,Update and Canceling in Grid view using asp.net?

In this article i will explain how to insert edit update delete and canceling operations in grid view

You can achieve by using the
1.onrowediting-Is used to Edit the particular row
2.onrowupdating-Is used to update the particular row
3.onrowdeleting-Is used to delete the particular row
4.onrowcancelingedit-Is used to cancel the particular row

code in .aspx page:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 

            AutoGenerateEditButton="True" onrowediting="GridView1_RowEditing" 

            onrowupdating="GridView1_RowUpdating" AutoGenerateDeleteButton="True" 

            onrowdeleting="GridView1_RowDeleting" DataKeyNames="Id" 

            onrowcancelingedit="GridView1_RowCancelingEdit">

            <Columns><asp:TemplateField HeaderText="Id"><ItemTemplate><asp:Label ID="lbl_id" runat="server" Text='<%#Eval("Id")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_id" runat="server" Text='<%#Eval("Id")%>'></asp:TextBox>

            </EditItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Name"><ItemTemplate><asp:Label ID="lbl_name" runat="server" Text='<%#Eval("Name")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_name" runat="server" Text='<%#Eval("Name")%>'></asp:TextBox>

            </EditItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Salary"><ItemTemplate><asp:Label ID="lbl_sal" runat="server" Text='<%#Eval("salary")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_salary" runat="server" Text='<%#Eval("salary")%>'></asp:TextBox>

            </EditItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Department"><ItemTemplate><asp:Label ID="lbl_dept" runat="server" Text='<%#Eval("Department")%>'></asp:Label>

            </ItemTemplate>

            <EditItemTemplate><asp:TextBox ID="txt_dept" runat="server" Text='<%#Eval("Department")%>'></asp:TextBox>

                </EditItemTemplate>

            </asp:TemplateField>

             </Columns>

        </asp:GridView>

        <br />

        <table><tr><td>Id:</td><td>

            <asp:TextBox ID="txt_id" runat="server"></asp:TextBox></td></tr>

            <tr><td>Name:</td><td>

                <asp:TextBox ID="txt_name" runat="server"></asp:TextBox></td></tr>

                <tr><td>Salary:</td><td>

                    <asp:TextBox ID="txt_salary" runat="server"></asp:TextBox></td></tr>

                    <tr><td>Department:</td><td>

                        <asp:TextBox ID="txt_dept" runat="server"></asp:TextBox></td></tr>

                        <tr><td colspan="2" align="center">

                            <asp:Button ID="btn_submit" runat="server" Text="Submit" 

                                onclick="btn_submit_Click" /></td></tr>

            </table>

    </div>

    </form>

create table in sql server

column name                       datatype

Id                                         Int(set identity property =true)
Name                                     Nvarchar(100)
Salary                                    Nvarchar(50)
Deprtment                             Nvarchar(50)

code in .aspx.cs page:
Add namespaces 
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


 string strcon = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            getdata();
        }
    }
//To bind the data from database to grid view
    public void getdata()
    {
        SqlConnection con = new SqlConnection(strcon);
        SqlCommand cmd = new SqlCommand("select * from Emp", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataSource=ds;
        GridView1.DataBind();
    }
//To edit the the row event
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        getdata();
    }
//To update the row event
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow row = GridView1.Rows[e.RowIndex] as GridViewRow;
        int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["Id"].ToString());
        TextBox tname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_name");
        TextBox tsalary = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_salary");
        TextBox tdept = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt_dept");
        SqlConnection con = new SqlConnection(strcon);
        SqlCommand cmd = new SqlCommand("update Emp set Name=@Name,salary=@salary,Department=@Department"+" where Id=@Id", con);
        cmd.Parameters.AddWithValue("@Name", tname.Text.Trim());
        cmd.Parameters.AddWithValue("@salary",tsalary.Text.Trim());
        cmd.Parameters.AddWithValue("@Department", tdept.Text.Trim());
        cmd.Parameters.AddWithValue("@Id", Id);
        con.Open();
        cmd.ExecuteNonQuery();
        GridView1.EditIndex = -1;
        getdata();
        con.Close();
   
    }
//To delete the row event
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["Id"].ToString());
        SqlConnection con = new SqlConnection(strcon);
        SqlCommand cmd = new SqlCommand("delete from Emp where Id=@Id", con);
        con.Open();
        cmd.Parameters.AddWithValue("@Id", Id);
        cmd.ExecuteNonQuery();
        
        GridView1.DataBind();
        con.Close();
        getdata();
    }
//To canceling the row
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        getdata();
    }
    protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
            }
//To insert the data and bind into gridview as well as data base
    protected void btn_submit_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(strcon);
        con.Open();
        SqlCommand cmd = new SqlCommand("emp_insert_sp", con);
        cmd.CommandType = CommandType.StoredProcedure;
        //cmd.Parameters.AddWithValue("@Id", txt_id.Text);
        cmd.Parameters.AddWithValue("@Name", txt_name.Text);
        cmd.Parameters.AddWithValue("@salary", txt_salary.Text);
        cmd.Parameters.AddWithValue("@Department", txt_dept.Text);
        cmd.ExecuteNonQuery();

        con.Close();

I hope you understand how to insert ,edit ,update ,delete and canceling in gridview using asp.net

OOPS Concepts

oops(Object oriented programming structure)

1.Abstraction 
2.Encapsulation
3.Polymorphism
4.Inheritance.

It can use while implementing the functionality of your projects ,according to your requirement

Class:

class is an user defined data type

class is a collection fields , Methods, properties and events.

A class exist logically whereas object exist physically

Public class Customer

{

}

Customer objCust=new Customer();

Object: Object is an instance of class

Syntax: customer ObjCust;

ObjCust=new customer();

Abstraction: Hiding the unnecessary details from the view of the users is called  abstraction

Or

 Hiding the implementation is known as Abstraction.

Abstraction is a process that involves identifying the critical behavior of an object and eliminating irrelevant and complex details.

Encapsulation:

Binding or Encapsulating the methods with the fields by providing the security for data.

Or

Accessing  the public properties by using private variables is one of the good example in encapsulation

Example:

private int _id;

    public int Id

    {

        get { return _id; }

        set { _id = value; }

    }

Here you are not accessing the private variable id but you are accessing the public property id

Polymorphism:

Same function with the different behavior   with different no of values is called is polymorphism

By achieving polymorphism in Three types:

Function Overloading, Operator overloading-early binding-compile time

Method Overloading:

Same function with different  signature is known as method overloading.

Function Overloading is implemented within the same  class.

Example:

public class class1

    {

        public int add(int a, int b)

        {

            return a + b;

        }

        public int add(int a, int b, int c)

        {

            return a + b + c;

        }

    }

Function overriding-late binding-run time Polymorphism

Method Overriding:

Overriding means changing the functionality of a method without changing the signature. We can override a function in base class by creating a similar function in derived class. This is done by usingvirtual/override keywords

class Baseclass

    {

       

            public virtual void A()

            {

                Console.WriteLine("BaseMethod");

            }

            public class derivedclass : Baseclass

            {

                public override void A()

                {

                    Console.WriteLine("DerivedMethod");

                }

           

        }

        static void Main(string[] args)

        {

            derivedclass objprog = new derivedclass();

            objprog.A();

            Baseclass objprog1 = new derivedclass();

            objprog1.A();

            Console.ReadLine();

        }

    }

o/P: Derived Method

     Derived Method

Method Hiding:

It is a concept of polymorphism while method shadowing redefines the whole element,

Shadowing helps you override a function in a parent method even if that is not marked virtual

 New keyword helps you to override a non-virtual method in the child class.

Example:

public class Baseclass

    {

public void A()

        {

            Console.WriteLine("BaseMethod");

        }

        public class derivedclass : Baseclass

        {

            public new void A()

            {

                Console.WriteLine("DerivedMethod");

            }

        }

        static void Main(string[] args)

        {

            derivedclass objprog = new derivedclass();

            objprog.A();

            Baseclass objprog1 = new derivedclass();

            objprog1.A();

            Console.ReadLine();

}

}

O/p: Derived Method

     Base Method.

The new keyword is used to hide the method because the base class method is not marked as

Virtual. If it is marked as virtual and if there is any overridable method is available then you will get derived method output.

Note:Overriding redefines only the element while shadowing redefines the whole element.

Inheritance: This is a process of creating a new class from already existing class

Whereas  existing class is known as parent class or Base class  and new class is known as child class or derived class, Inheritance is the purpose of code reusability and providing additional features.

Example:

public class Baseclass

    {

       public Baseclass()

       {

             Console.WriteLine ("Base Class");

    }

                                

    public void Write ()

    {

        Console.WriteLine ("Write method in baseclass");

    }

                               

public class ChildClass:Baseclass

{

                                

    public ChildClass ()

    {

        Console.WriteLine("Child Class");

    }

  

    public static void Main ()

    {

        ChildClass CC = new ChildClass ();

        CC.Write ();

        Console.ReadLine();

    }

}

       }

Types of Inheritance:

Single Inheritance: Creating Single new class from single base class is known as single inheritance.

Multiple Inheritance: Creating a new class from two or more base classes is known as multiple inheritance.

Note: In c# multiple inheritance is not possible  using inheritance instead of that you can use interfaces.

Mutli Level Inheritance: Creating a new class from already derived class is known as multilevel inheritance.

Hybrid Inheritance: It is the combination of multiple and Multilevel Inheritance

Backup and Restore using sql server?

This article will explain you how to restore the database and how to take an backup of our database file , different types of backup and how it will be used.

Introduction:

Backup is nothing but copy of original data.It is used when the your database is crashed by some problem the backup is used at the time.

They are seven types of Back Up's are there:

1)Full Backup

2)Differential Backup.

3)Transaction Log Backup.

4)Tail-Log(Point-in-time).

5)Mirror.

6)Copy-only.

7)File&File Group.

Full Backup:

Full Backup is used to take an entire database and extension is .bak 

Differential Backup:

Differential Backup is used to take the backup of the modify data or changed data after taking the full backup.

Extension .bak

Transaction Log Backup:

Transaction Log Backup is used to take the Current transaction backup 

Extension .trn

Tail-Log Backup:

Trail-Log Backup is used to take the backup of after crashing the database.

Extension .trn

Mirror Backup:

Mirror Backup is used to take the backup more than one disk.

Extension .bak

Copy-Only Backup:

Copy-only backup is used to take the backup with out disturbing the Mdf & ndf files.

Extension .bak

File &File Group Backup:

File&File Group Backup is used to take the individual Backup or group of files then we can use file or file group.

Extension .bak

Syntax for Full BackUp:

backup database<database name>to disk='Location\Full.bak' with stats=5

If it is in Differential log Backup then we indicate with differential stats

Syntax for Transaction log Backup

backup log database name from disk='location\tlog.trn with stats 2

Syntax for Tail-log Backup

same as transaction log slite change in point-in-time file name.

Syntax for Mirror Backup

backup database<database name> to disk='Location\Full.bak' mirror to disk='location\full.bak'.

Syntax for Copy-Only Backup:

backup database to disk='location with copy-only'.

File &File group:

File backup is nothing but take the backup of mdf files&ndf files.

To take the backup for individual files and file groups.

GUI Based Full Backup:

Open object Explorer in the toolbar,Now we can got to database folder and right click on tasks , Now select the backup 

Now click on backup and select backup type is Full change the location and click on Add button(change the previous location)

 Backup destination window should appear, select the location using browser button 

Now select the location and file name must be with the extension of .bak file which as shown below and click ok button.

Now select the options page select Overwrite all existing backup sets radio button and chech the checkbox verify 

backup when finished then click on ok.

After we click ok me get a message box then again click on ok

I hope this step by step process will help you to backup the database.

How to Restore the Database?

Syntax of Restore db:

Restore Database<database name>from Disk='Location\full.bak with No Recovery stats=10

GUI based:

 Open object explorer in the tool bar,Now we can go to database and right click on database and select restore database

Restore Window database should appear and type the database name on 'to database' and select device radio button and click browse button.

Select Backup device click add button with the extension of .bak

Select the checkbox 

Go to options page check the overwrite the existing database on restore option in Recovery state select Restore with Recovery and click on ok.

After we click ok we get message box which in our case says "Database database name restored successfully

This step by step tutorial will help you for restore the database.

By using this article we can easily restore and backup the database.

i hope you understand.

How to insert the data into gridview using textboxes in asp.net?

I would like to explain about inserting values into textbox and that will be displayed in grid view 
so  for that  
In visual studio click on file -->New project-->Add weapplication-> add new item-->
add new web form

In .aspx page:

  <table>
        <tr><td>Name:</td><td>
            <asp:TextBox ID="txt_name" runat="server"></asp:TextBox></td></tr>
            <tr><td>Description:</td><td>
                <asp:TextBox ID="txt_description" runat="server"></asp:TextBox></td></tr>
                <tr><td>Department:</td><td>
                    <asp:TextBox ID="txt_depart" runat="server"></asp:TextBox></td></tr>
                    <tr><td colspan="2" align="center">
                        <asp:Button ID="Button1" runat="server" Text="Submit" onclick="Button1_Click" /></td></tr>
        </table>
<asp:label: id="1abel1" runat="server" >

The page will be display like this 
code in .aspx.cs page:
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls;

namespace WebApplication1
{
    public partial class insert : System.Web.UI.Page
    {
        string strcon = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
// you have to add configuration in name space .
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
            }
        }
code in button click event

        protected void Button1_Click(object sender, EventArgs e)
        {
try
{
            SqlConnection con = new SqlConnection(strcon);
            SqlCommand cmd = new SqlCommand("insert_sp_emp", con);
 //here i passed stored procedure instead ofinsert  query.
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Name", txt_name.Text);
            cmd.Parameters.AddWithValue("@Description", txt_description.Text);
            cmd.Parameters.AddWithValue("@Department", txt_depart.Text);
            con.Open();
            cmd.ExecuteNonQuery();
       label1.text="Record Inserted Succesfully;
            con.Close();
}
catch(Exception,ex)
{
label1.Text=ex.message;
}
        }
    }
}
in sql server 
 crete table 
and write  procedure for insert query i.e,

create procedure insert_sp_emp(@Name nvarchar(50),@Description nvarchar(50),@Department nvarchr(50))
AS
BEGIN
insert into tablename(Name,Description,Department) values(@Name,@Description,@Department)
END

if you set an identity true no need to mention id as parameter-(@Id int)

Web Config file:

<configuration>
  <connectionStrings>
    <add name="sqlconn" connectionString="Data Source=SYS-2;Initial Catalog=Emp;Integrated Security=True"/>

  </connectionStrings>

So build your application and start debugging then it shown your output like this 

then you have to display the complete record into gridview using asp.net:
in .aspx page:
drag and drop gridview from datbound controls
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="Id" />
                <asp:BoundField DataField="Name" HeaderText="Name" />
                <asp:BoundField DataField="Description" HeaderText="Description" />
                <asp:BoundField DataField="Department" HeaderText="Department" />
            </Columns>


        </asp:GridView>

code in .aspx.cs page:
 public void binddata()
        {
            SqlConnection con = new SqlConnection(strcon);
            SqlCommand cmd = new SqlCommand("select* from Emp", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();

        }
In button click event  you have to mention 
bindata(); before con.close();//connection close
then build the and debug the code once
then it will be displayed liked this

so it is useful for beginners who are learning asp.net newly
I hope you understand  raise a query you have any doubt about this

Interview questions and answers for dotnet developers

1.You need to identify

Is Always a number

Is Always greater than 

      a.int32

      b.int64

      c.system.unit16

      d.system.unit32

2.You have created an assembly that utilizes unmanaged code to access external resources. You need to deploy the assembly with the appropriate permissions. Which permission set should you use?

1. safe
2. unsafe
3. EXTERNAL_ACCESS
4. Default Permission set

3.You have an application that is used by international clients. All clients connect by using Windows Authentication. You need to ensure that system and user-defined error messages are displayed in the localized language for the clients.

1. Use @@LANGUAGE function
2. Use the "set language" option of sp_configure
3. Use default language for each login

Use default language for each login and another option is Use @lang parameter of sp_addmessage

4.Your application uses two threads, named threadOne and threadTwo. 
You need to modify the code to prevent the execution of threadOne 
until threadTwo completes execution. 
What should you do?

1. Configure threadOne to run at a lower priority.
2. Call the Sleep method of threadOne.
3. Configure threadTwo to run at a higher priority.
4. Use a WaitCallback delegate to synchronize the threads.

you have to use a waitcallback delegate to synchronize the threads

5.You need to create a method to clear a Queue named q.

1. foreach(object e in q){q.Dequeue();
2. foreach(object e in q){q.Enqueue(null);
3. q.clear();
4. q.Dequeue();

Queue method will clear while using q.clear();

6.You need to write a multicast delegate that accepts a DateTime argument 
which code type you can choose

1. public delegate int PowerDeviceOn(bool result, DateTime autoPowerOff);
2. public delegate void PowerDeviceOn(DataTime autoPowerOff);
3. public delegate bool PowerDeviceOn(object sender, EventsArgs autoPowerOff);
4. public delegate bool PowerDeviceOn(DataTime autoPowerOff);

public delegate void PowerDeviceOn(DataTime autoPowerOff);

7.Differentiate between a page theme and a global theme?

Page Theme: 
Where as Page theme applies to a particular web pages of the project. It is stored inside a subfolder of the App_Themes folder. 

Global Theme: 
Where as Global theme applies to all the web applications on the web server. It is stored inside the Themes folder on a Web server.

8.Which of the following is NOT used for getting auto-incremented value of a IDENTITY Column in SQL Server?

1. SCOPE_IDENTITY()
2. @@IDENTITY
3. IDENT_CURRENT('TableName')
4. MAX(id).

SCOPE_IDENTITY(), @@IDENTITY, IDENT_CURRENT('TableName') are used for getting auto incremented value from recent INSERT statement in SQL Server

9.ASP .Net Page class, in which of them would you attach an event handler to an event published by a control on the web page?

1. onload()
2. OnPageload()
3. OnInit().
4. OnPostback()

OnInit() method is called when an ASP.Net page is  intialized , this would be the most appropriate place to attach an event to its event handler.

10.Why can't you open a new browser window from within server code?

Server code executes on the server, where as the new window is created on the client.You need to use the client-side code to do things that affect the client,such as upload Files ,display new windows or navigate back in history.

11.What is the main difference between the Button server control and the Button Html control?

when clicked the Button server control triggers are asp.net click event procedure on the server.The Button HTML control triggers the event procedure indicated in the buttons onclick attribute,which runs on the client.

12.List the EmpNo,EName,Sal Daily Sal of all Emps in the ascending order of annual salary?

Select EmpNo,EName,Sal,Sal/30,12 * Sal annual salary from Emp order by annual salary 
you can detect by this query.

13.write a query the name ends with 'i' using sql server?

select * from emp where name like '%i' 
output: 
aswini 
aluri 
devi 

the query displays the person name ends with i only

14.write a query name starts with 's' using sql server?

select * from emp where name like 's%' 
output: 
siri 
spandu 
seshu 

The query displays the name starts with s only

15.write a query allow only 4 characters in name column using sql server?

select name from salary where name like '____' 
after like 4 dashes with in single quote 

o/p::ashu 

siri 
hari 

the output will shown like that it can show only 4 characters.

16.How to allow only alphabets using regular expression validator?

1. "[a-zA-Z]"
2. "^[a-zA-Z]+$".
3. [A-za-z]

Validation Expression="^[a-zA-Z]+$"
it can allow only alphabets

17.How many generations in Gc within managed heap and what are the default sizes?

1. 3geneartions, sizes-45kb.45mb,7mb
2. 3Generations Sizes-128kb,2mb&10 mb.
3. 2 Generations Sizes-222kb,455mb

Maximum number of generations allowed are only three
In general always generation 2memory size is bigger than the generation 1 memory size and generation 1 memory size is bigger than the generation 0 memory size.

18.what is the max size of rows in a particular table

1. 1024
2. 8060.
3. 1824

8060 rows only

19.how to detect the product level,product version and edition in sql server 2008

select serverproperty('product level') 
select serverproperty('productversion') 
select serverproperty('edition') 
By using three queries you can get the product level,product version and edition

20.In.Net which is the parent class to create all windows service?

1. Eventloginstaller
2. Service Installer
3. servicebase.

The service base class is the parent class to create all windows service

21.how to change the database owner?

1. sp_helptext owner
2. sp_changeowner
3. sp_changeDBowner 'sa'.

sp_changeDBowner 'sa'

22.What is the maximum size of columns in a particular table?

1. 65,535
2. 8060
3. 1024.

for a table it can allow only 1024 columns in sql server

23.What is the maximum size of columns in a particular table?

1. 65,535
2. 8060
3. 1024.

for a table it can allow only 1024 columns in sql server

24.How to convert server name to host name?

convert server name to host name using this query 
sp_drop server hcl 
sp_add server'hcl/infotech','local'

25.How can you detect the host name and Ip address?

>xp_cmdshell hostname--for hostname 
-->xp_cmdshell Ipconfig---for ip address.

26.How can you detect the servername ?

1. select* servername
2. select @servername
3. select@@servername

to detect server name using this query on your db
select@@ servername

27.How can you detect the version properties?

by using this query you can achieve. 

-->select @@ version

28.How can you detect the how many mdf & ndf & ldf files in your database?

1. sp_helptext
2. sp_helpindex
3. sp_helpdb'text'

by using sp_helpdb'text' you can detect your mdf&ndf&ldf files

29.can one dll contain the compiled code of more than one programming language?

1. Yes
2. No
3. both a&b

no,a dll file contain the compiled code of only one programming language.

30.How many web servers are needed for a web site?

There is only one web server are required for a web site.But large web sites like yahoo ,google,msn etc will have millions of visitors every minute one computer cannot process such huge data ,so they will have a hundreds of servers then it can give the fast response

31.How many web sites can be hosted in one server?

A web server can host hundreds of web sites.Most of the small web sites in the Internets are shared on web servers.They are several web hosting companies who offer shared web hosting  from a web hosting company,they will host your web site along with their web server along with several other web sites. 

Ex Of web servers applications are: 
1.IIS
2,Apache

32.Is validation is done by server side or client side validation?

Server side Validation

1. ClientSide validation
2. both 1&2.

by default it is done by client side ,server side validation is possible when you switch off the client side.

33.Difference between Typed DataSet and UnTypedDataSet

Typed DataSet is a Custom class generated by visual studio 
It adds things like named properties that match column and row data in the tables. It's generated code and not a part of .NET, so you can't use typed datasets without Visual studio unless you copy all of the code and manually customize it for your project. An untyped dataset is an object of the DataSet class. It's a part of .NET and you can use it even if you don't have Visual Studio. 
typed dataset is generally used as it is easy to use and moreover gives errors at compile time...compared to untyped which gives on run time

34.Difference between label and literal controls in asp.net?

label: 
Label control renders text within span tag to browser. It is possible to apply style and style sheet class to label. 
Literal: 
Literal will render it's text that is assign to text property. It cannot render any additional html tag. Default mode for literal is “Transform”. Best practice to set Mode="Encode" for literal control 

It is best practice to use literal instead of Label control wherever it possible in asp.net application..

35.If i write system.exit(0);at the end of try block is finally block will execute?

No,the finally block can't execute in this case because when you mention system.exit(0); 
the control goes out of the program and the finally block never execute.

36.How to find out which index is defined on table?

1. sp_tablename
2. sp_helpindex
3. sp_helpindextablename.

sp_helpindextablename

37.In which events controls are fully loaded?

In page load events all controls are loaded 
controls are accessed in page_init event but you see that view state is not fully loaded during this event

38.which statements is used to replace multiple if-else statements in code?

In Vb.net the select case statement is used to replace multiple if-else statement. 
and in c# the switch-case statement is used to replace multiple if-else statement.

39.Is it possible to host web site from desktop?

1. No
2. Yes.
3. Some Times It can be

Yes you can host web site from desktop

40.why we are using distinct keyword in sql server?

The DISTINCT keyword in SQL allows you to select only those records that contain unique values for the columns requested in a Select statement,. Duplicate values are ignored and only displayed once. 
Ex:- using emp table 
Emp ID EmpName 
1 Aswini A 
2 Aswini A 
3 Aluri 


then 
select distinct EmpName from emp 
then it displays 
only 
EmpName 
Aswini A 
Aluri

41.ACID rules in sql server?

Atomicity 

Consistency

Isolation
Durablity 

Atomicity: 
Modification on the data in the database either fail or succeed. The beginning of such a modification starts with a transactionand ends when a transaction finishes (either by a commit or arollback). A software crash entails an implicit rollback. 
Consisyency: 
Modification on the data in the database either fail or succeed. The beginning of such a modification starts with a transactionand ends when a transaction finishes (either by a commit or arollback). A software crash entails an implicit rollback. 

Isolation: 
One transaction does not interfere with another. The 'executor' of a transaction has the feeling that he has the entire database for himeself. 
Durablity: 
A commited transaction will not be lost.

42.What is the difference between Dot Net 4.0 and 4.5 Framework .

As practically the difference between dot net 4.0 and 4.5 are mentioned below- 
>> You can compile an application for .NET 4.5 and run it on the 4.0 runtime – that is a new feature of 4.5, that doesn’t exist on 4.0. 
<configuration> 
<startup> 
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /> 
</startup>

43.Can you split the one column in to two columns 
For Ex:FullName:Aswini Aluri 
It must split into firstname: Aswini. 
LastName :Aluri

Create splitS(FullName NVARCHAR(50)) 
select LEFT(fullname, CHARINDEX(' ', fullname + ' ') -1), 
STUFF(fullname, 1, Len(FullName) +1- CHARINDEX(' ',Reverse(fullname)), '') 
from splits.

I hope it will help you

This questions are asked in many interviews.