Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Interview Questions
Steps to Get Visitors Count in ASP.NET?
Posted By :
Posted Date :
August 29, 2011
Create Global.asax File:
Inside the void Application_Start()
Enter code as
and Then Enter the Code inside the Session_Start()
You can also find related Interview Question to
Steps to Get Visitors Count in ASP.NET?
What aggregate functions returns a row count as an integer?
How to get the column count of a report?
SY-LINSZ system variable gives the column count (line size) and SY-LINCT for line count.
What is COUNT Syntax?
SELECT COUNT("EMPLOYEE_NAME") FROM "EMPLOYEE_TABLE";
SELECT COUNT(*) FROM "EMPLOYEE_TABLE";
COUNT is arithmetic function, This is return number of row.
COUNT and DISTINCT Syntax?
SELECT COUNT(DISTINCT EMPLOYEE_NAME) FROM EMPLOYEE_TABLE;
Fetch the number of distinct entries in a Employee_table.
What are the steps you need to follow to use jQuery in ASP.Net project?
and you good to go now for JQuery.
Note : 1.3.2 denotes the library version.. It can be vary depending upon the version of Jquery you download.
select COUNT(column_name) from table_name counts only
NON NULL Columns
Explain the steps involved to populate dataset with data?
Initialize Adapter passing SQL and connection as parameter.;
Call Fill method of the adapter passes dataset as the parameter.;
how can debugging share point application and timer jobs ? with steps?
Steps 1:build application place .dll into gac and reset iis
steps 2:On the Debug menu, select Attach to Process
steps 3:select the Show processes from all users check box.
steps 4:select W3W.exe and OSWTIMER.exe can attach
steps 5:refresh sharepoint site point break point
how to get records count by hourly wise?
SELECT Count (*), to_char(col_datetime,'yyyymmdd HH24') FROM tblname where Trunc(col_datetime) =Trunc(SYSDATE-1) group by to_char(col_datetime,'yyyymmdd HH24')
Using query analyzer, name 3 ways to get an accurate count of the number of records in a table?
SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2
What is satellite assembly? and steps to create satellite assembly?
When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.
Steps to Create Satellite Assembly
a. Set the paths for resgen and al.exe:
b. Create a .resources file.
c. Create the satellite assembly.
d. The assembly should have the naming convention for .NET to be able to search for it.
e. Specify the settings for culture.
f. Put the satellite assembly in the appropriate folder.
g. Once the satellite assembly is created, physically copy it to the appropriate directory.
h. Repeat the process for each language in which you are creating an assembly.
Steps to create a cursor in sql
? Declare cursor
? Open cursor
? Fetch row from the cursor
? Process fetched row
? Close cursor
? Deallocate cursor
what are the Steps to interact with database in connected architecture
1 import sql client.
2 create an obj for sql command
3 create an object for sql command by providing "query",cn.
4 open connection.
5 execute query.
6 close connetcion.
What are the Good Steps to be followed for maintaining Connection Strings in Asp.Net Web Applications ?
There are some basic steps which should be followed inorder maintain Connection strings more efficiently they are
. Connection strings should allways be given in web.config file itself for security resons. Not only for security but also as more accessible at multiple places.
. We should never make connection strings as Declarative property for SqlDataSource control
. Allways Connection strings should be stored in an Encrypted format for secure Database server .
. Do not store it in a plain text format and also never store it in a .aspx page.
Quick Links For Interview Questions Categories:
Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.
So, Start looking our
section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.
Hall of Fame
Terms of Service
Tell A Friend