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?

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?