Why DataReader is Forward Only?
Answers were Sorted based on User's Feedback
Answer / pankaj kumar
BECAUSE WE CAN NOT TRAVERSE BACK TO PREVIOUS RECORDS OF THE
TABLE,THATSWHY DATA READER IS FORWARD ONLY.IT FOLLOW OFFLINE
MODE THAT MEANS IT IS DISCONNECTED ARCHITECTURE.
| Is This Answer Correct ? | 0 Yes | 3 No |
Because it supported dissconnected architecture
| Is This Answer Correct ? | 10 Yes | 110 No |
Answer / ankit
Because it suppport the disconnected architecture :)
| Is This Answer Correct ? | 22 Yes | 141 No |
How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();
Explain the difference between data reader and data adapter?
Define executenonquery?
What is a datagridview?
Advantage of ADO.Net?
Give an example that shows how to execute a stored procedure in ado.net?
Difference between function and trigger?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is sqldatareader in ado.net?
If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?
What are the objects of ado.net?
I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)