using System; using System.Data; using System.Data.OleDb; // Step 1.Open Database Connection OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\inventory\\inventory\\db\\invent.mdb;"); // Step 2.Connection database opened conn.Open(); // Step 3.Create DataSet and Command objects OleDbCommand cmd = new OleDbCommand( "SELECT * FROM empr4r", conn); // Step 4.Execute the command cmd.ExecuteScalar(); // Step 5.Closed this connection conn.Close();
By:Rajesh Kr
Date:2030-09-10 00:00:00
using System; using System.Data; using System.Data.OleDb; // Step 1.Open Database Connection OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\inventory\\inventory\\db\\invent.mdb;"); // Step 2.Connection database opened conn.Open(); // Step 3.Create DataSet and Command objects OleDbCommand cmd = new OleDbCommand( "SELECT * FROM empr4r", conn); // Step 4.Execute the command cmd.ExecuteScalar(); // Step 5.Closed this connection conn.Close();
By:Rajesh Kr
Date:2030-09-10 00:00:00
Give Short History of ADO.Net.
Why ADO.NET Is a Better Data Access Layer than others?
Write a sample example of ADO.Net?
What is ADO.NET Data Structures?
Define ADO.NET provides data access services in the Microsoft .NET platform?
Tell me about ADO.NET Classes?
Define Data Provider in ADO.NET?
Define types of Datasets in ADO.Net?
Define the ways to populate a Dataset in ADO.Net?
Define DataAdapter in ADO.Net?
Define methods of DataAdapter in ADO.Net?
How to DataBindings for TextBoxes in ADO.Net?
Define ADO.NET Objects in brief?
How to Create a SqlConnection Object in Ado.Net?
How to create a SqlCommand Object in ADO.Net?
How to querying in ADO.Net, when using SqlCommand?
How to Inserting Data when using SqlCommand Object in ADO.Net?
How to Updating Data when using SqlCommand Object in ADO.Net?
How to Deleting Data when using SqlCommand Object in ADO.Net?
How to create a SqlDataReader Object in ADO.Net?
How to Read data with SqlDataReader Object in ADO.Net?
How to Create a DataSet Object in ADO.Net?
How to create a SqlDataAdapter in ADO.Net?
How to Filling the DataSet in Disconnected mode in ADO.Net?
What are the basic Namespaces in ADO.Net?
Compare the Connection-Oriented and Disconnected Scenario in ADO.Net?
Define, how can we load multiple tables in a Dataset?
Explain the difference between an ADO.NET Dataset and an ADO Recordset?
Difference between classic ADO and ADO.NET?
Define Connection Pooling in brief?
Define methods provided by the dataset object to generate XML in ADO.Net?