Bindas

Wednesday, December 1, 2010

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?

Friday, August 20, 2010

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

Tuesday, August 17, 2010

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

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;

Sunday, August 15, 2010

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.

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.