-
What is Pull Model and Push Model in ADO.Net? What are the situations when we use one over the other?
sudheer27in
- Jun 6th, 2008
Pull Method: when we directely interact with the data through data drivers this method is used. ADO COMPONENT <--------> DATABASEPush Method...
bornToLose
- Sep 22nd, 2007
Pull model is used to take out the element/object from Database.Push model is used to insert the element at top position in table to database through object.If we want to delete the top most record pull method is used over push. Similar to stack operation
-
Explain about rowstate in a dataset table?
Lavanyaaru
- Jan 30th, 2008
contd...A newly created DataRow has its RowState set to Detached until it is added to the DataRowCollection via the DataRowcollection::Add method. The RowState is initialized to Added until ...
Lavanyaaru
- Jan 30th, 2008
It is the current state of the row w.r.t. its relationship to the DataRowCollection.THe value of Rowstate is dependent on the method DataRow.AcceptChanges
-
How is session dumped in ASP .Net?
Read Best Answer
-
What is the execution procedure in oracle ?
Read Best Answer
Editorial / Best Answer
sahu- Member Since Dec-2005 | Mar 29th, 2007
Hi,
if you Passing Parameters,
then
Below it will excute
typesql> execute Procedure_name(arg1,arg2,...,arg n);...
if donot pass Parameters
then
typesql> execute Procedure_namesahu
- Mar 29th, 2007
Hi,if you Passing Parameters,then Below it will excutetypesql> execute Procedure_name(arg1,arg2,...,arg n);...if donot pass Parametersthentypesql> execute Procedure_name
RaviKumar
- Oct 28th, 2005
typesql> execute Procedure_name(arg1,arg2,...,arg n);
-
Differences between OLEDB SQL SERVER , OLEDBDOTNET PROVIDER ?
ynvpavan
- Apr 18th, 2008
u just have a look over the fig 2 in this link and u can get somne info, i think...http://msdn2.microsoft.com/en-us/magazine/cc163933.aspxAnd also, the OLEDBSQL Provider posses native drivers to inter...
Ashish Misra
- Apr 15th, 2006
OleDBDotNet Provider can be used to connect to any DataSource but OleDb SQL SERVER can be used to connect only to a SQL Server DataSource.
-
-
What is the Best Practice for binding Controls [Data in the data grid is to be binded with the controls of some form ] ?
rashid
- Mar 27th, 2006
Some user controls are entirely self contained, for example, a user control displaying current stock quotes does not need to interact with any other content on the page. Other user controls will...
rashid
- Mar 27th, 2006
public partial class UseDataList : System.Web.UI.Page{ protected DataTable GetInventory() { String strConnection = &nb...
-
How many App Domains an ASP.NET Worker Process creates if suppose 10 different users are logged into the web site
Read Best Answer
Editorial / Best Answer
nishant2200- Member Since Jan-2007 | Jan 7th, 2007
One AppDomain is created in the aspnet_wp.exe worker process per website. Inside that appdomain, user's state is kept separate from each other, and from then on server memory side state management can be segregated on basis of Session, Profile etc.
nishant2200
- Jan 7th, 2007
One AppDomain is created in the aspnet_wp.exe worker process per website. Inside that appdomain, user's state is kept separate from each other, and from then on server memory side state management can be segregated on basis of Session, Profile etc.
-
What is meant my datarow versioning in ADO.Net. Where it is used?
Read Best Answer
Editorial / Best Answer
Lavanyaaru- Member Since Jan-2008 | Jan 30th, 2008
There are 3 versions for each DataRow object.
1.Original
2.Current
3.Proposed
The HasVersion( ) method of the DataRow can determine whether a specific version of the row exists. If the version exists, column values for it can be retrieved using one of the three overloads of the DataRow indexer
The Original version contains the values that were loaded into the row.
The Current version contains the latest version of the data, including the changes made since the data was originally loaded. The Original version isn't available for newly created rows.
A Proposed row version is made available while the row is in edit mode and contains the changes that have been made to the row while it was in edit mode
If CancelEdit( ) , RejectChanges() methods are called, the values in the Proposed version are simply discardedLavanyaaru
- Jan 30th, 2008
There are 3 versions for each DataRow object.1.Original2.Current3.ProposedThe HasVersion( ) method of the DataRow can determine whether a specific version of the row exists. If the version e...
-
Add a field at run time to a table in ado.net
Imports System.Data.SqlClientPublic Class Form1Dim cn As New SqlConnection("server=.;database=atten;uid=sa;pwd=sa;")Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click'savecn.Open()Dim query, query1, query2 As StringDim regnum As Integerquery1 = "select max(reg) from sdetail"Dim cmd1 As New SqlCommand(query1, cn)regnum = cmd1.ExecuteScalarTextBox1.Text...
-
How to connect Oracle database and MS Access to .Net framework?
Read Best Answer
Editorial / Best Answer
seemu123- Member Since May-2008 | Nov 11th, 2008
If you have used OleDB you can use an OleDB connectionstring, if you have
used SQLClient, you have to change it to the OracleClient (standard in
2003).seemu123
- Nov 11th, 2008
If you have used OleDB you can use an OleDB connectionstring, if you have used SQLClient, you have to change it to the OracleClient (standard in 2003).
-
Explain how ASP .Net provides increased performance.
stalera
- Apr 3rd, 2010
Disabling the view state wherever necessary, having ajax play its role, removal of unnecessary controls. storing view state at server side if the view state is very heavy.
-
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
Read Best Answer
Editorial / Best Answer
deepti705- Member Since Jan-2010 | Jan 2nd, 2010
Fill() method is use to fill the data through DataSource in DataSet
-
Abstract Class and Interface
Demonstrate a situation when and why you would use Abstract class and Interface in your project?
bhatnagar_prachi845
- Sep 29th, 2010
As multiple inheritance is not permitted but using interfaces we can implement this. Abstract class is used when any derived class wants to implement a base function differently.
-
What is the use of HTTP Handlers in IIS?
Read Best Answer
Editorial / Best Answer
machud- Member Since Apr-2011 | Apr 10th, 2011
HTTP Handlers can be used to process custom requests that may not be in the standard supported format like .htm, .aspx, .asmx etc. One example will be RSS feed processing . One can write .rss? handler which can be configured in the IIS to accept and?delegate the processing to the custom handler written to produce customized output. There are 3 basic steps that need to be performed to make a HTTP handler work properly .
a. Create Handler calss which implements IHttpHandler interface or IHttpAsyncHandler for Asynchrounous handler. IsReusable property and the ProcessRequest method is must be implememented in the Handler class
b. Register the handler class in the web.config file of the application or machine.config
c. Specify the mapping in IIS (Website->Properties->configuration->mappings) add new extension with executable as "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_isapi.dll" ( assumes default installation)machud
- Apr 10th, 2011
HTTP Handlers can be used to process custom requests that may not be in the standard supported format like .htm, .aspx, .asmx etc. One example will be RSS feed processing . One can write .rss? handle...
-
-
What are the Advantages of ADO.Net?
ADO.NET Does Not Depend On Continuously Live ConnectionsDatabase Interactions Are Performed Using Data CommandsData Can Be Cached in DatasetsDatasets Are Independent of Data SourcesData Is Persisted as XMLSchemas Define Data Structures
-
ADO.NET Interview Questions
Read Best Answer
Ans