3 Years above Exprience question in DotNet

Question Paper For Exp People

Hi All Once Again, Good Morning, I got Good  Link about DotNet As well as Sql Server Question, Please Go through that if you have any dought please send me the mail.

This Question From My side this is only for TCS

1)    Tell me about u r self?
2)    Asp.net page life cycle? Explain briefly?
3)    Asp.net page events?
4)    How iis recognize that which web application we are
requesting?
5)    How iis recognize that web application is developed in
which language?
6)    How iis will use authentication?
7)    Is it pages will compile in server?
8)    In server pages will compile or execute?
9)     What is diff between compile and execute?
10)    What is appdomain?
11)    What is aspnet_issapi.dll?
12)    What is aspnet_wp.exe?
13)    What is application?
14)     What is view state?
15)    Why we use view state?
16)    What are the validation controls? Explain the use of
validation controls?
17)    Validation controls are client side or server side?
18)    How to make raise JavaScript at the page is displaying?
 (which page event will use eg: page_load) ?
19)    What is session?
20)    Is it necessary to create session object? (ans :no) 
21)    What is application object?
22)    Diff between session and application object?
23)    When application object will create?
24)    When session object will create? (ans : when user login)
25)    Where u will store connection string?
26)    What is appsettings?
27)    How can i register my assembly in gac?
28)    What is strong name?
29)    How to generate strong name?
30)    How to register strong name with my class library?
31)    Can i register my assembly in gac with out strong name?
32)    What is dataset?
33)    Diff between dataset and datareder?
34)    How can we made changes in database? (ans: da.update())
35)    One user changed one record in dataset and updated in
database but at same time another user also changed the same
record in his dataset and try nto update in database so is
the change is accepted in database or rejected? (ans; he
said no)
36)    Where dataset will store?
37)    What is heap memory?
38)    What is stack memory?
39)    When heap memory will create?
40)    When stack memory will create?
41)    If heap memory is full what happens? (how much memory it
extends? Or it uses the stack memory)
42)    If stack memory also full what happen?
43)    What is constructor?
44)    Why we use constructor?
45)    What is destructor?
46)    Why we use destructor?
47)    Garbage collector?
48)    What is dispose?
49)    What is finalize?
50)    How to remove the object reference?(ans : passing null
value)
51)    What is final key word? (try catch final)
52)    What is autopostback?
53)    What is dataview? Usage?
54)    What is caching?
55)    How to expire my cache? ( ans : using duration in page
directive)
56)    Types of caching?
57)    If i store cache in server the server will over load
because of cache objects so how can i prevent that? (ans :
using downstream caching eg: net provider serve and local
system cache)
58)    What is data cache?
59)    How can i get the value from cache?
60)    If i want insert record in database tell me the steps?
61)    Diff between authentication and authorization?
62)    How to authenticate user in asp.net?
63)     Types of authorizations?
64)    Explain the three types of authorizations?
65)    How iis uses the windows authentication?
66)    What is forms authentication?
67)    What is impersonation?
68)    What is default impersonation in asp.net?
69)    What is interface?
70)    Usage of interface?
71)    What is abstract?
72)    Interface methods are public and protected? Is it right?
73)    What is protected?
74)    What is polymorphism?
75)    Diff between overloading and overriding?
76)    How to restrict my class to inherited?
77)    How to restrict my class to create object?
78)    What is delegate?
79)    What is thread?
80)    What are the Ado.net objects?
81)    Difference between forms authentication and windows authentication?
Side why windows authentication is more secured when compare to forms authentication?


SQL SERVER
1)    What is dts?
2)    What is diff between primary key and unique key?
3)    How many primary keys we can create in a single table?
4)    What is index?
5)    Types of index?
6)    How many indexes we can create?
7)    How many clustered indexes we can create? (ans : 1)
8)    How many non clustered indexes we can create?  (ans : 246)
9)    What is stored procedure? Use?
10)    Diff between function and stored procedure?
11)    How can we return a value in stored procedure?
12)    How can we handle error in stored procedure?
13)    Diff between delete and truncate?




Cherrs


Bindas.......

How To Fill The Grid Using XML and XSLT

Today Topic is Fill The Grid Using XML and XSLT
                 I have taken help from my Senior.
                 1> You Need To Create XML File.
                 2> You Need to Create XSLT it Mean schema File Using XSLT.
                 3> After that take the XML Control in Your .aspx Page.
                 this is the process to achieve the desire result.
                 if you are facing any Problem please send me a message i am trying to solve that problem

My XML File Name Is Text.XML

<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" herf="TestDemo.xsl"?>
<Test>
  <Tests>
    <name>C++</name>
    <cost>2000</cost>
  </Tests>
  <Tests>
    <name>DotNet</name>
    <cost>10000</cost>
  </Tests>
</Test>

My XLST File Name Is Tests.Xsl

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">

  <xsl:template match="/">
    <table border="1">
      <tr>
        <th>Name</th>
        <th>Price</th>
      </tr>
      <xsl:for-each select="Test/Tests">
        <tr>
          <td>
            <br>
              <xsl:value-of select="name"/>
            </br>
          </td>
          <td>
            <br>
              <xsl:value-of select="cost"/>
            </br>
          </td>
        </tr>
      </xsl:for-each>
    </table>
  </xsl:template>
</xsl:stylesheet>

My .aspx page name is Default.aspx

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <asp:gridview ID="Gridview1" runat="server"
            AutoGenerateColumns="True"
           >
    </asp:gridview>

 

        <asp:Xml ID="Xml1" runat="server"></asp:Xml>

 

    </div>
    </form>
</body>
</html>

And last but not the list  My .CS File name is Default.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Xml;
using System.Xml.Xsl;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            XmlDocument docXML = new XmlDocument();
            docXML.Load(Server.MapPath("Test.xml"));
            XslTransform docXSL = new XslTransform();
            docXSL.Load(Server.MapPath("Tests.xslt"));
            Xml1.Document = docXML;
            Xml1.Transform = docXSL;

            DataSet DataSet;
            string filePath = Server.MapPath("Test.xml");
            DataSet = new DataSet();
            //Read the contents of the XML file into the DataSet
            DataSet.ReadXml(filePath);
            Gridview1.DataSource = DataSet.Tables[0].DefaultView;
            Gridview1.DataBind();
        }
       
    }
}
This is The Solution

Cheers
Bindas....

How To Bind The Grid Dynamically In Wpf

Window Presentation Foundation How To Bind The Grid Dynamically In Wpf. I want to Express My Thought Through Coding Please Understand. if you have any dought please Send Me Your Query. This is Simple Example I have taken one List Box and Fireing One Event on Window Load Event.

 First Of All You Need To Create The Database, In This Sample Application I am Using Sql Server. My Database Name is Test That Contain table and table Contain Some Attribute Name Is EmpId, Ename, Address and My Table Name is tblEmp. So, Viewer you need to do This part i am unable to upload my sample application

After That This Couple Of Line You write in Window1.XAML

<Window x:Class="WpfApplication2.Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    Title="Window1" Height="280" Width="563" Loaded="Window_Loaded">
    <Window.Resources>
        <DataTemplate x:Key="listBoxTemplate">
            <StackPanel Margin="4">
                <DockPanel >
                    <TextBlock FontWeight="Bold" Text="EmpIdentification:"
                      DockPanel.Dock="Right"
                      Margin="5,0,10,0"/>
                    <TextBlock Text="  " />
                    <TextBlock Text="{Binding EId}" Foreground="Green" FontWeight="Bold" />
                </DockPanel>
                <DockPanel >
                    <TextBlock FontWeight="Bold" Text="Name:" Foreground ="DarkOrange"
                      DockPanel.Dock="Left"
                      Margin="5,0,5,0"/>
                    <TextBlock Text="{Binding Ename}" />
                   </DockPanel>
                <DockPanel>
                    <TextBlock FontWeight="Bold" Text="Address" Foreground="RoyalBlue"
                               DockPanel.Dock="Left"
                               Margin="5,0,15,0"/>
                    <TextBlock Text="{Binding Address}"/>
                </DockPanel>
            </StackPanel>
        </DataTemplate>
    </Window.Resources>
     <Grid Margin="49,12,29,0" Name="grid1" Height="221" VerticalAlignment="Top" Width="467">
     <ListBox Margin="17,8,15,26" Name="lstnox1" ItemsSource="{Binding Tables[0]}"
     ItemTemplate="{StaticResource listBoxTemplate}" />
     </Grid>
       
</Window>

And after That You Need To Open Your Window1.XAML.CS and put These Couple Of Lines

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;

namespace WpfApplication2
{
    /// <summary>
    /// Interaction logic for Window1.xaml
    /// </summary>
    public partial class Window1 : Window
    {
         public SqlConnection connection;
        public SqlCommand command;
        string sql = "SELECT EmpId,Ename,Address FROM tblEmp";
        string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Test.mdf;Integrated Security=True;User Instance=True";
       
        public Window1()
        {
            InitializeComponent();
        }

        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            BindGrid();
        }

        private void BindGrid()
        {
            DataSet dtSet = new DataSet();
            using (connection = new SqlConnection(connectionString))
            {
                command = new SqlCommand(sql, connection);
                SqlDataAdapter adapter = new SqlDataAdapter();
                connection.Open();
                adapter.SelectCommand = command;
                adapter.Fill(dtSet, "tblEmp");
                lstnox1.DataContext = dtSet;
            }

        }

      
    }
}

This is Code For Dynamically You Can Bind The Grid In WPF And You Out Put Look Like



Cheers


Bindas.....

What is Mvc Design Pattern

Hi, All
                   This is My Second Blogs, if you Know about The three tire architecture then MVC is very easy
             to understand becoz it follow three tire architechture rule. first of all
             What is MVC Design Pattern ?

              MVC (Model View Controller) pattern is very useful for Web
                based e-commerce application.

                Asp.Net web application

                aspx, ascx, master pages are View

                aspx.cs, ascx.cs, master.cs are Controller

                App_Code folder contains classes and some references –
                Model Component

                The Model holds the data displayed by the View and managed by the
               Controller. The View is responsible for delivering output to the End User,
               and the Controller reacts to End User actions and updates the Model
               appropriately

             But I want to Tell You About Model, You Very Careful about this Layer.

            Model
This layer has all our business logic. This is the most important layer. This layer will have our core        functionality. This layer should be designed in such a way that out core and complex logic should be designed as functions and these function should be marked as overridable so that the inheriting classes can re-use the logic or override the logic. We should not make all the functions in the layer as overridable this may raise some security Issue. 

                MVC Advantages: Business logic can be easily modified
                without affecting or any need to make changes in UI.
                This is the Meaning of MVC Design pattern. but if you relate with Three tire architechture.
                 then first we define the Business Layer, Data Access Layer and last but not the list Presentation layer.
                  same thing here also aspx page represent Presentation Layer. Business layer it is a class library, In that case you need write
                  The logic how you can connect with the data access layer and presentation layer, data access layer you are connect with database and business Logic layer.

MVC Nothing But a successful development and reuse of code

Cheers

Bindas.........

SomeThing

This is Ajit Singh, I am a Software Engg.. This is My First Blog. I decide Today i need to write the Blogs and After That I Have Start Writing Blogs. This is Good Things wright.

I want To Tell To Something To U All.


Work hard and raise yourself to a level where, before penning your destiny,
God himself will ask "tell me,
what do you want your destiny to be!" 


But In This is Morden Era U Need to Change Your Self


In Place Work hard U are need to put Smart Work. This is The Definition Of Success...

Cheers


Always Bindassssssssssss............................................