.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

< 1 2   Sort: Rank

How can we force the connection object to close after my datareader is closed
How can we force the connection object to close after my datareader is closed ? Command method Executereader takes a parameter called as CommandBehavior where in we can specify saying close connection automatically after the Datareader is close. pobjDataReader = pobjCommand.ExecuteReader(Comm andBeha... 2007-10-24, 5947👍, 0💬

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures? ADO.NET provides the SqlCommand object which provides the functionality of executing stored procedures. Note :- Sample code is provided in folder “WindowsSqlClientCommand”. There are two stored proce... 2007-10-24, 5266👍, 0💬

How do we connect to SQL SERVER, which namespace do we use
How do we connect to SQL SERVER, which namespace do we use ? Below is the code, after the code I have given the explanation for it. For this sample we will also need a SQL Table setup which I have imported using the DTS wizard. Private Sub LoadData() ‘ note :- with and end with makes your code more ... 2007-10-24, 5864👍, 0💬

How can we connect to Microsoft Access , Foxpro , Oracle etc
How can we connect to Microsoft Access , Foxpro , Oracle etc ? Microsoft provides System.Data.OleDb namespace to communicate with databases like scess , Oracle etc. In short any OLE DB-Compliant database can be connected using System.Data.OldDb namespace. Note :- Small sample of OLEDB is provided in... 2007-10-24, 7572👍, 0💬

What are the various objects in Dataset
What are the various objects in Dataset ? Dataset has a collection of DataTable object within the Tables collection. Each DataTable object contains a collection of DataRow objects and a collection of DataColumn objects. There are also collections for the primary keys, constraints, and default values... 2007-10-24, 5149👍, 0💬

What is Dataset object
What is Dataset object? The DataSet provides the basis for disconnected storage and manipulation of relational data. We fill it from a data store,work with it while disconnected from that data store, then reconnect and flush changes back to the data store if required. 2007-10-24, 5084👍, 0💬

What is the use of dataadapter
What is the use of dataadapter ? These are objects that connect one or more Command objects to a Dataset object. They provide logic that would get data from the data store and populates the tables in the DataSet, or pushes the changes in the DataSet back into the data store. ? An OleDbDataAdapter ob... 2007-10-24, 5077👍, 0💬

What is the use of command objects
What is the use of command objects ? They are used to connect connection object to Datareader or dataset. Following are the methods provided by command object ? ExecuteNonQuery :- Executes the command defined in the CommandText property against the connection defined in the Connection property for a... 2007-10-24, 4682👍, 0💬

What is the use of connection object
What is the use of connection object ? They are used to connect a data to a Command object. ? An OleDbConnection object is used with an OLE-DB provider ? A SqlConnection object uses Tabular Data Services (TDS) with MS SQL Server 2007-10-24, 4857👍, 0💬

What are major difference between classic ADO and ADO.NET
What are major difference between classic ADO and ADO.NET ? Following are some major differences between both ? As in classic ADO we had client and server side cursors they are no more present in ADO.NET. Note it's a disconnected model so they are no more applicable. ? Locking is not supported due t... 2007-10-24, 5215👍, 0💬

What is difference between dataset and datareader
What is difference between dataset and datareader ? Following are some major differences between dataset and datareader ? DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data sour... 2007-10-24, 5344👍, 0💬

What are the two fundamental objects in ADO.NET
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental objects in ADO.NET. 2007-10-24, 8272👍, 0💬

Can you give a overview of ADO.NET architecture
Can you give a overview of ADO.NET architecture ? The most important section in ADO.NET architecture is gData Providerh. Data Provider provides access to datasource (SQL SERVER, ACCESS, ORACLE).In short it provides object to achieve functionalities like opening and closing connection, retrieve dat... 2007-10-24, 5450👍, 0💬

What is the namespace in which .NET has the data functionality classes
What is the namespace in which .NET has the data functionality classes ? Following are the namespaces provided by .NET for data management System.data This contains the basic objects used for accessing and storing relational data, such as DataSet,DataTable, and DataRelation. Each of these is indepen... 2007-10-24, 5139👍, 0💬

< 1 2   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML