Monday, January 28, 2008

Singer Sunitha official web site

http://www.bitra.com/www/sunita/

Collection of portals

http://www.bitranet.org/html/portfolio_viewall.asp

Thursday, January 24, 2008

What is the advantage of putting the SQL statements inside a procedure?

Speed, security, modularity, consistency and reduced network congestion

Wednesday, January 23, 2008

What is difference between char(1999) and varchar2 (1999)

CHAR is always 1999 characters long physically AND logically. But the varchar is physically 1999 bytes but logically can be any size in between 0 and 1999. The char is always blank padded, not so for the varchar.

Thursday, January 10, 2008

How to use the new reporting service of Microsoft inside your ASP.NET Application

Introduction

Microsoft has introduced a very different and extremely powerful reporting engine called SQL Reporting Services. It is relatively very easy to use reporting services, however it is a bit different from what we are used to in Crystal reports.


Background


Reporting service is basically a reporting server that uses SQL server as its backend database, all reports are deployed on the reporting server and from their you can access any reports you have access rights to. The basic idea is to have a single location where all reports are deployed, and provides a single point of access; this created a very flexible environment to deploy your reports over the enterprise. The idea is a very similar to Crystal Reports Enterprise Reporting.

Requirements:


You will need the following tools before installing the reporting service, those tools are needed for development of reports for deployment.


SQL Server 2000 with SP3


IIS 5.0 or 6.0


Visual Studio .NET



Accessing Report Server Management Interface:


You can start by accessing your reporting service by going to http://localhost/reports this is where you can manage your reporting service. You can view reports and other information directly from this web interface, manages subscriptions, security, data sources and other.


The Reporting Service Web Management provides browsing folders that contain reports, data source names that you have deployed. This tool provides viewing of reports, however for developing reports you must have Visual Studio .NET


Report server windows service


Report server windows service must be running to be able to access, view and deploy reports from your development tool. (You can see ReportServer window service status through services.msc)



Developing Your Own Reports



Ø First you create a new project, and select Report Project this will create a reporting service project. From here you will find two folders shared data sources, and reports. Shared data sources is one very interesting feature, this is where your data source for your reports. You can have more than 1 shared data source or even a single data source for every report; however it wouldn't be a good idea to repeat the same data source twice if you are using the same database.


Ø create a shared data source selecting your SQL server, required database (Northwind)


Ø create new report


Ø Selecting the data for your report through query/stored procedure.


Ø After you are done selecting the data go to, report designer select the layout tab in your report, as you can see in the left toolbox you can use any of the report control to enhance your report functionality and design. You can include charts, images, matrix, etc... After you're done lets preview the report.


Ø Previewing Report: One of the features I love about the reporting service, is the ability to preview your report before deployment, here you can view your report as if you are in the deployment environment.


Ø Deploying Report on Report Service: all your reports are developed on Visual Studio .NET then they are deploying to a reporting server. To start deployment right clicks your application and select properties, you will find the property "OverwriteDataSources" to be false, make it to true, and then select the target folder; this can be anything you like. Then enter the location of your reporting server here it is localhost however it can be a domain, IP address or any location you want as long as reporting service is installed to it. After you are done press F5 or right click the


Ø Project and select deploy, the minute this is done your reports are deployed on your reporting server.


Ø Viewing Report from Report Service: As I said now your report is deployed on the reporting server you can access it directly by going to http://localhost/reports.



Reporting service Features


Ø The SQL 2000 Server Reporting Services provide web based interactive reports, and is integrated with the Visual Studio 2003.


Ø Although you can manipulate report programmatically, no programming is required if you want to use Reporting Services.


Ø This XML based data reporting is extremely easy to use and supports importing MS Access reports as well.


Ø Reports is generated *.rdl extension.


Ø Microsoft SQL Server 2000 Reporting Services is designed with a modular, distributed architecture to help achieve both scalability and flexibility.


Ø A high performance Server based reporting engine for processing and formatting reports.


Ø A complete set of tools for creating, managing, and viewing reports.


Ø Create reports with tables, graphs with data extracted from the database.


Ø Can contain data from relational and/or multidimensional data sources.


Ø Reports are viewed over the web.


Ø Integration with Microsoft products and tools. Reporting Services integrates easily with familiar Microsoft tools such as Visual Studio and applications such as Office and SharePoint Portal Server, without requiring programming and customization.


Ø Managing reports. Reporting Services includes a web-based tool for managing reports as well as integration with the new SQL Server Management Studio. Administrators can use this interface to organize reports and data sources, schedule report execution and delivery, and track reporting history. Or, an enterprise or ISV can use the Reporting Services Web Services APIs to write customized management tools.


Ø Securing reports. Reporting Services implements a flexible, role-based security model to protect reports and reporting resources. The product includes extensible interfaces for integrating other security models if desired.


Ø Delivering reports. You can post reports to a portal, email them to users, or allow users to use the web-based report server to access reports from a folder hierarchy. Navigation, search, and subscription features help users locate and run the reports they need. Personalized subscriptions let them select the rendering format they prefer.



Report Definition Language (RDL) – An Xml schema for representing reports.


What is a Report?

A report is a combination of three kinds of information:


Ø Data or information on how to obtain the data (queries) as well as the structure of the data.


Ø Layout or formatting information that describes how the data is presented.


Ø Properties that the report such as author, parameters, images within the report, etc.

Monday, January 7, 2008

ASP.NET

How to Hide and Show Rows in a DataList?
How to Display BoundColumn Based on a Condition?
How to Change the Column Value Dynamically to display in a DataGrid?
How to Hide a DataGrid Column Dynamically?
How to Sort a DataGrid Column Data Dynamically?
How to use DataFormatString in a DataGrid?
How to use HyperLink Column of DataGrid?
How to use ItemTemplate in a DataGrid Dynamically?
Hide the data if a database field value is null? Hide a DataGrid column?
Reshuffle or Change the order of DataGrid columns?
Change Color of a DataGrid Column Based on Column Values How to Add a Counter Column to the DataGrid?
How to Display Data Vertically?
How to add a DataGrid Column for Calculations?
Determine Windows users logged on a machine? S
tart an outside application programmatically?
Write my "Hello, World!" program in C#?
Read or write data streams?
Get IP Address of a Host?
Call a Windows API?
Open a wav file to play a sound?
Send a mail using SMTP?
Convert from one data type to another?
Create a Windows Service?
Open a browser from my application?
Get Current date/time?
Get all the running process on your machine?
Add events to a Windows Control at design time?
Copy a text file to HTTP output stream?
Developing a multi-threaded application?
Read windows registry?
Provide Cut and Paste functionality by using System Clipboard?
Write my first multithreading application?
Deploy my .NET Applications on other machines?
Find an Operating System version?
What is .NET Framework?
What language can I use to write ASP.NET applications?
What kind of applications can we build using the .NET Framework?
How is ASP.NET different than ASP 3.0?
What do I need to run ASP.NET?
Do I need Visual Studio .NET to develop ASP.NET applications?
Is ASP.NET cross-browser compatible?
What platform ASP.NET will run on?
What is "<%=...%> in ASP.NET?
How do I call an aspx page from a WebForm button Click?
How do I create a table Programmatically?
How do I add check boxes to a table?
How do I add combo boxes to a table?
How do I provide paging support in a DataGrid control?

Ado.Net

• Write a Generic Data Access Component which selects a data provider at run time?

• Transfer data from a SQL Server database to an Excel database?

• Create a Custom Data Provider?• Bind IList to a DataGrid?

• Use DiffGrams in a DataSet? • Data Binding in DataGrid Control?

• How to I get the modified rows (deleted, added, updated) of a DataSet?

• Send only affected rows of a DataSet to the database when saving results?

• Make DataSet save operation faseter? • Get rid of '+' sign from a DataGrid?

• Get all tables of a database programmatically?

• Get all columns of a table without using DataSet?

• Get a list of all available tables of an Access database?

• Update a database using DataSet?

• Add ComboBox to a DataGrid?

• Add CheckBox to a DataGrid?

• Use Date or DateTime values in a SQL statement?

• Create a SQL Server database programmatically?

• Read data from a database using ADO.NET?

• Write data to an access database using SQL Query and ADO?

• Use DataGrid to display data from a table?

• Get a database table's column properties such as name, type etc?

• I'm having problem connecting MySQL Server using ODBC .Net Data Provider.

• Get a list of available ODBC DSNs using ADO.NET?

• Is there any sample available to connect to MySQL Server?

• Navigate through database records in an unbound DataGrid control?

• Transfer data from SQL Server to Excel? • Create my own Data Adapter?

• View an Oracle database tables and their contents? • Connect to an Oracle database?

• Access an Oracle database? • Select, add, update and delete data from a database?

• Display data in a ListBox Web Control?

• Access data from Text files using ADO.NET?

• Read data from a relational database and write to XML Files?

• View data in a DataGrid control in a simple way?

• Get a database table properties programmatically? • Write data to an access database using SQL statement?

• Open and Read Excel Spreadsheet into a ListView

• Read and save Images in a SQL Server database using ADO.NET?

• Call Oracle Stored Procedure with Parameters in ASP.NET and ADO.NET?

• Add records to an Access database with a Stored Procedure?

• Execute Stored Procedures?

• Execute Views?

• Retrieve data from multiple database tables in a DataSet?

• View data from multiple database tables in a DataGrid control?

• Check if a database table has no records?

• Bind two fields of a table to a ListBox control?

Saturday, January 5, 2008

HR INTERVIEW

1.Your job responsibilities in your previous/current job
2.Reason of leaving your earlier/current job.
3.Strengths and Weaknesses (Write down three (3) technical and three (3) non-technical personal strengths.)
4.Tell us about yourself. (Start from your education and give a brief coverage of previous experiences. Emphasize more on your recent experience explaining your job profile.)
5.What do you know about our company?
6.Why do you want to join our company?
7.Where do you see yourself in the next five years?
8.Why are you looking for a change?
9.Why should we hire you? Or why are you interested in this job?(Sum up your work experiences with your abilities and emphasize your strongest qualities and achievements. Let your interviewer know that you will prove to be an asset to the company.)
10.Do you prefer to work in a group? (Be honest and give examples how you've worked by yourself and also with others. Prove your flexibility.)
11.Questions to Ask
At the end of the interview, most interviewers generally ask if you have any questions. Do not ask queries related to your salary, vacation, bonuses, or other benefits. This information should be discussed at the time of getting your joining letter. Here we are giving few sample questions that you can ask at the time of your interview.
Sample Questions
1) Could you tell me the growth plans and goals for the company?
2) What skills are important to be successful in this position?
3) What's the criteria your company uses for performance appraisal?
4) With whom will I be interacting most frequently and what are their responsibilities and the nature of our interaction?

SQL Server Interview Questions

Explain Third normalization form with an example?
When you should use low fill factor?
How you can minimize the deadlock situation?
How to choose between a Clustered Index and a Non-Clustered Index?
Why there is a performance difference between two similar queries that uses UNION and UNION ALL?
Write a SQL Query to find first day of month?
A user is a member of Public role and Sales role. Public role has the permission to select on all the table, and Sales role, which doesnt have a select permission on some of the tables. Will that user be able to select from all tables ?
If a user doesnt have a permission on a table, but he has permission to a view created on it, will he be able to view the data in table?
Describe Application Role and explain a scenario when you will use it?
Both a UNIQUE constraint and a PRIMARY KEY constraint enforce uniqueness, so when you should use UNIQUE Constraint?
What is the difference between the REPEATABLE READ and SERIALIZE isolation levels?
Why one should not prefix user stored procedures with sp_?
You have several tables, and they are joined together for querying. They have clustered indexes and non clustered indexes. To optimize the performance how you will distribute the tables and their indexes on different file Groups?
Which event (Check constraints, Foreign Key, Rule, trigger, Primary key check) will be performed last for integrity check ?
After removing a table from database, what other related objects have to be dropped explicitly ?
How can you get an identity value inside a trigger, there are different ways to get identity value, explain why you will prefer one on another.
How to find out which stored procedure is recompiling?
How to stop stored procedures from recompiling?
When should one use instead of Trigger?
What is a derived table?

ASP.Net Interview Questions

1. Which method do you invoke on the DataAdapter control to load your generated dataset with data?
2. Can you edit data in the Repeater control?
3. Which template must you provide, in order to display data in a Repeater control?
4. How can you provide an alternating color scheme in a Repeater control?
5. What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?
6. What base class do all Web Forms inherit from?
7. What method do you use to explicitly kill a user s session?
8. How do you turn off cookies for one page in your site?
9. Which two properties are on every validation control?
10. What tags do you need to add within the asp:datagrid tags to bind columns manually?
11. How do you create a permanent cookie?
12. What tag do you use to add a hyperlink column to the DataGrid?
13. What is the standard you use to wrap up a call to a Web service
14. Which method do you use to redirect the user to another page without performing a round trip to the client?
15. What is the transport protocol you use to call a Web service SOAP
16. True or False: A Web service can only be written in .NET
17. What does WSDL stand for?
18. What property do you have to set to tell the grid which page to go to when using the Pager object?
19. Where on the Internet would you look for Web services?
20. What tags do you need to add within the asp:datagrid tags to bind columns manually.
21. Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
22. How is a property designated as read-only?
23. Which control would you use if you needed to make sure the values in two different controls matched?
24. True or False: To test a Web service you must create a windows application or Web application to consume this service?
25. How many classes can a single .NET DLL contain?
(a) One and only one(b) Not more than 2(c) Many

FAQs on ASP.Net

How to Hide and Show Rows in a DataList?
How to Display BoundColumn Based on a Condition?
How to Change the Column Value Dynamically to display in a DataGrid?
How to Hide a DataGrid Column Dynamically? How to Sort a DataGrid Column Data Dynamically?
How to use DataFormatString in a DataGrid?
How to use HyperLink Column of DataGrid?
How to use ItemTemplate in a DataGrid Dynamically?
Hide the data if a database field value is null?
Hide a DataGrid column?
Reshuffle or Change the order of DataGrid columns?
Change Color of a DataGrid Column Based on Column Values How to Add a Counter Column to the DataGrid?
How to Display Data Vertically?
How to add a DataGrid Column for Calculations?
Determine Windows users logged on a machine?
Start an outside application programmatically?
Write my "Hello, World!" program in C#?
Read or write data streams? Get IP Address of a Host?
Call a Windows API?
Open a wav file to play a sound?
Send a mail using SMTP? Convert from one data type to another?
Create a Windows Service?
Open a browser from my application?
Get Current date/time?
Get all the running process on your machine?
Add events to a Windows Control at design time?
Copy a text file to HTTP output stream?
Developing a multi-threaded application?
Read windows registry?
Provide Cut and Paste functionality by using System Clipboard?
Write my first multithreading application?
Deploy my .NET Applications on other machines?
Find an Operating System version?
What is .NET Framework?
What language can I use to write ASP.NET applications?
What kind of applications can we build using the .NET Framework?
How is ASP.NET different than ASP 3.0?
What do I need to run ASP.NET?
Do I need Visual Studio .NET to develop ASP.NET applications?
Is ASP.NET cross-browser compatible?
What platform ASP.NET will run on?
What is " in ASP.NET?
How do I call an aspx page from a WebForm button Click?
How do I create a table Programmatically?
How do I add check boxes to a table?
How do I add combo boxes to a table?
How do I provide paging support in a DataGrid control?

FAQs on ADO.Net

Write a Generic Data Access Component which selects a data provider at run time?
Transfer data from a SQL Server database to an Excel database?
Create a Custom Data Provider?Bind IList to a DataGrid?
Use DiffGrams in a DataSet? Data Binding in DataGrid Control?
How to I get the modified rows (deleted, added, updated) of a DataSet?
Send only affected rows of a DataSet to the database when saving results?
Make DataSet save operation faseter? Get rid of '+' sign from a DataGrid?
Get all tables of a database programmatically?
Get all columns of a table without using DataSet?
Get a list of all available tables of an Access database?
Update a database using DataSet? Add ComboBox to a DataGrid?
Add CheckBox to a DataGrid?
Use Date or DateTime values in a SQL statement?
Create a SQL Server database programmatically?
Read data from a database using ADO.NET?
Write data to an access database using SQL Query and ADO?
Use DataGrid to display data from a table?
Get a database table's column properties such as name, type etc?
I'm having problem connecting MySQL Server using ODBC .Net Data Provider. Get a list of available ODBC DSNs using ADO.NET?
Is there any sample available to connect to MySQL Server?
Navigate through database records in an unbound DataGrid control?
Transfer data from SQL Server to Excel? Create my own Data Adapter?
View an Oracle database tables and their contents? Connect to an Oracle database?
Access an Oracle database? Select, add, update and delete data from a database?
Display data in a ListBox Web Control? Access data from Text files using ADO.NET?
Read data from a relational database and write to XML Files?
View data in a DataGrid control in a simple way?
Get a database table properties programmatically?
Write data to an access database using SQL statement?
Open and Read Excel Spreadsheet into a ListView Read and save Images in a SQL Server database using ADO.NET?
Call Oracle Stored Procedure with Parameters in ASP.NET and ADO.NET?
Add records to an Access database with a Stored Procedure?
Execute Stored Procedures?
Execute Views?
Retrieve data from multiple database tables in a DataSet?
View data from multiple database tables in a DataGrid control?
Check if a database table has no records? Bind two fields of a table to a ListBox control?

FTP Address for Books

ftp://ftp.runnet.ru/BOOKS/

Wednesday, January 2, 2008