.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: Date

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, 8554👍, 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, 7848👍, 0💬

Explain in detail the fundamental of connection pooling
Explain in detail the fundamental of connection pooling? When a connection is opened first time a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only works if the connection string is the same. If the conn... 2007-10-24, 7298👍, 0💬

How many ways are there to implement locking in ADO.NET
How many ways are there to implement locking in ADO.NET ? Following are the ways to implement locking using ADO.NET 1. When we call gUpdateh method of DataAdapter it handles locking internally. If the DataSet values are not matching with current data in Database it raises concurrency exception err... 2007-10-24, 6184👍, 0💬

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, 6133👍, 0💬

How Can We Know state of thread?
How Can We Know state of thread? "ThreadState" property can be used to get detail of a thread. Thread can have one or a combination of status.System.Threading. Threadstate enumeration has all the values to detect a state of thread. Some sample states are Isrunning, IsAlive, suspended etc. 2009-03-06, 6111👍, 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, 6094👍, 0💬

What is basic use of “DataView”
What is basic use of “DataView” ? “DataView” represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in “datatable”. Dataview has the following method’s Find It takes a array of values and returns the index of the r... 2007-10-24, 6011👍, 0💬

How can we fine tune the command object when we are expecting a single row
How can we fine tune the command object when we are expecting a single row ? Again CommandBehaviour enumeration provides two values SingleResult and SingleRow. If you are expecting a single value then pass “CommandBehaviour.SingleResult ”and the query is optimized accordingly, if you are expecting s... 2007-10-24, 5738👍, 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, 5733👍, 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, 5692👍, 0💬

How can we check that some changes have been made to dataset since it was loaded
How can we cancel all changes done in dataset ? or How do we get values which are changed in a dataset ? For tracking down changes Dataset has two methods which comes as rescue “GetChanges “and “HasChanges”. GetChanges Returns dataset which are changed since it was loaded or since Acceptchanges was... 2007-10-24, 5679👍, 0💬

What is difference between Dataset. clone and Dataset.copy
What is difference between Dataset. clone and Dataset. copy ? Clone: - It only copies structure, does not copy data. Copy: - Copies both structure and data. 2007-10-24, 5673👍, 0💬

What is Maximum Pool Size in ADO.NET Connection String
What is Maximum Pool Size in ADO.NET Connection String? 2007-10-24, 5590👍, 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, 5585👍, 0💬

Which is the best place to store connectionstring in .NET projects
Which is the best place to store connectionstring in .NET projects ? Config files are the best places to store connectionstrings. If it is a web-based application “Web.config” file will be used and if it is a windows application “App.config” files will be used. 2007-10-24, 5556👍, 0💬

How can we perform transactions in .NET
How can we perform transactions in .NET? The most common sequence of steps that would be performed while developing a transactional application is as follows: ? Open a database connection using the Open method of the connection object. ? Begin a transaction using the Begin Transaction method of the ... 2007-10-24, 5489👍, 0💬

How can we add/remove row’s in “DataTable” object of “DataSet”
How can we add/remove row’s in “DataTable” object of “DataSet” ? “Datatable” provides “NewRow” method to add new row to “DataTable”. “DataTable” has “DataRowCollection” object which has all rows in a “DataTable” object. Following are the methods provided by “DataRowCollection” object Add Ad... 2007-10-24, 5488👍, 0💬

What’s difference between “Optimistic” and “Pessimistic” locking
What’s difference between “Optimistic” and “Pessimistic” locking ? In pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking. In optimistic locking multiple users can open th... 2007-10-24, 5479👍, 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, 5477👍, 0💬

I want to force the datareader to return only schema of the datastore rather than data
I want to force the datareader to return only schema of the datastore rather than data ? pobjDataReader = pobjCommand.ExecuteReader(Comm andBehavior.SchemaOnly) 2007-10-24, 5462👍, 0💬

What is the use of CommandBuilder
What is the use of CommandBuilder ? CommandBuilder builds “Parameter” objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects. Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAd apter)pobjCommandBuilder.DeriveParam eters(pobjCommand)Be careful ... 2007-10-24, 5447👍, 0💬

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset? There two main basic differences between recordset and dataset ? With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with recordset this is not possible ? All r... 2007-10-24, 5438👍, 0💬

How can we use dataadapter to fill a dataset ?
What are the steps involved to fill a dataset ? Sample code is provided in “WindowsDataSetSample” folder in CD.”LoadData” has all the implementation of connecting and loading to dataset. This dataset is finally bind to a ListBox. Below is the sample code. Private Sub LoadData() Dim strConnectionStr... 2007-10-24, 5421👍, 0💬

1 2 >   Sort: Date

.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