C#.NET Frequently Asked Questions
ADO.Net Architecture
Disconnected and connected architecture of data access
- What does it mean by disconnected data access architecture of ADO.Net?
- What does it mean by connected data access architecture of ADO.Net?
- What's the difference between accessing data with dataset or data reader?
- What are the performance considerations when using dataset?
- How to select dataset or data reader?
XML support in ADO.Net
Components of ADO.Net
- What are the different components of ADO.Net?
- What is a dataset?
- What is a data adapter?
- What is a database connection?
- What is a database command?
- What is a data reader?
- How do different components of ADO.Net interact with each other when disconnected?
- How do different components of ADO.Net interact with each other in connected architecture?
Dot Net Framework Data Providers
- What does it mean by Dot Net Framework Data Provider?
- What are the core objects that make up a dot net framework data provider?
- What are the standard data providers Framework 1.1?
- Why use a specialized data provider when a general data provider can be used?
- What is the Dot Net Framework data provider for SQL Server?
- What is the Dot Net Framework data provider for Oracle?
- What is the Dot Net Framework data provider for OLEDB?
- What is the Dot Net Framework data provider for ODBC?
Implementing Data Access with ADO.Net
- What are the basic steps involved in data access with ADO.Net in disconnected environment?
- Which namespaces I need to add to my project for each of the standard data provider?
- How do I define a connection string for the database server?
- How do I find the connection string for the database server?
- How do I define the connection to database?
- How do I create a command and supply the SQL query to ADO.Net?
Working in Disconnected Architecture of ADO.Net with DataSet
- How do I define a data adapter?
- How do I get the result of my command and fill it to the dataset?
- How do I read records from the data tables?
- How do I save the changes, made in the dataset, to the database?
- How do I make my first “Hello, ADO.Net” Application in C#?
- How do I make my first “Hello, ADO.Net” Application in VB.Net?
- How do I navigate through the records?
- How do I update tables in the dataset?
- How do I use a CommandBuilder object to prepare the update commands in my dataset?
- What are the general steps for updating the records in dataset?
Updating data with ADO.Net
- How do I update the dataset with the updates in records?
- How do I update the physical database with the changes in the dataset?
- How do I update a record in the table using ADO.Net dataset?
- How do I insert a record in the table using ADO.Net dataset?
- How do I delete a record in the table using ADO.Net dataset?
Connected architecture of data access in ADO.Net
- What is the architecture of connected environment of data access in ADO.Net?
- How do I read data (or records) from database using data reader?
- How do I insert records using data reader?
- How do I update records using data reader?
- How do I delete records using data reader?
Writing common code for different data providers
Using Stored Procedure
- What is a stored procedure?
- What is the advantage of using stored procedure over the SQL queries?
- What do stored procedure look like, can you provide some sample stored procedures?
- How do I call a stored procedure from my app using ADO.Net?
- How do I make my first application to call stored procedure using ADO.Net?
- What are the important points when developing a data access app with ADO.Net?
Using DataGrid with ADO.Net
- What is data grid and what is the use of it?
- How can I make my first application with DataGrid using the data from ADO.Net?
- How can I make my data grid to view data from multiple related tables?
Deploying ADO.Net applications
- What are the issues related to the deployment of data access application?
- How do I solve the deployment issues (mentioned in the previous FAQ)?
- How do I set the connection string at installation :specific data provider?
- How do I set the connection string at installation :general data provider?
- How do I supply the connection string during first run or during the regular execution?
- How do I store / retrieve the connection string in / from a text file?
- How do I store / retrieve the connection string in / from an XML file?
- How do I make my first "Hello, Data Access Application Deployment" setup program?
More
- How to use relation objects in a dataset?
- DataReader Vs DataSet?
- How do I access a SQL stored procedure?
- Methods of the Command Objects with databases
- How do I display a data table in a data grid?
- How do I insert data entered in a textbox into the database?
- How do I access SQL server in VB.NET?
- How to insert an image in Access Database?
FAQ Home
Sponsored links
Build IT Knowledge with Current & Trusted Content
Helps Employees Develop & Hone New Technical Programming Skills. Sign Up & Get Full Access.
Helps Employees Develop & Hone New Technical Programming Skills. Sign Up & Get Full Access.
Check Out IT Certification Preparation Materials
Sign Up With SkillSoft & Get Access to Training Materials for Over 50 Professional Certifications.
Sign Up With SkillSoft & Get Access to Training Materials for Over 50 Professional Certifications.
Villanova University Six Sigma & IT Certificate Programs
100% Online programs in Six Sigma, IS Security, CISSP Prep, Business Analysis, Proj. Mgmt. and more!
100% Online programs in Six Sigma, IS Security, CISSP Prep, Business Analysis, Proj. Mgmt. and more!
3 Months Free - ASP.NET Web Hosting
3 Months Free & No Setup Fees on ASP.NET 3.5/2.0 Hosting on Windows 2008/2003 Servers ? Click Here!
3 Months Free & No Setup Fees on ASP.NET 3.5/2.0 Hosting on Windows 2008/2003 Servers ? Click Here!
SFTP components for .NET
Add complete SSH and SFTP support to your .NET framework application
Add complete SSH and SFTP support to your .NET framework application
