What is the difference between excute query and excute
nonquery.?
Answers were Sorted based on User's Feedback
Answer / riddhi
excute nonquery :-- use when insert,update,delete will fire.
excute query:-- when non dml query is used.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / shreekant
execute qurey is used for a select statement
ex:"select * from employees";
execute nonquery is used when insert, update,delete statement.
ex:insert into employees values("yourrecirds");
delete from employees
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rina baranwal
use ExecuteQuery with "select" query but we use Execute
NonQuery with Update,insert and delete query.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / bhagwat prasad sharma
1)>>> when we insert data into database, delete data from database, update data from database than use ExecuteNonQuery
statement .
but when we select data from database than use ExecuteQuery
statement . that solves
| Is This Answer Correct ? | 3 Yes | 0 No |
How do you use a custom validator? When might you want to use one?
Explain the features that make asp.net more used framework? : asp.net mvc
What is the difference between Server.Transfer and Response.Redirect? Why would you choose one over the other?
What language is asp.net written in?
Name the control which can be used to reserve the space on web page for storing localized data.
Is it possible to perform data validations in the database?
Can we change the page layout in ASP.NET 2.0 as Grid Layout like in previous version
can we pass coditions in swtich case?
how to retrieve property settings from xml .config file.
Features of a dataset ?
I M working in 1.1 .net framework. In a page I have 5 text box & 2 data grid. In PageLoad() All text box will populate with blank value & 1st dataGrid with some value. When I click on EDIT button Of the 1st dataGrid,The Relevent data Of the particular row will populate in first 3 textboxs & corresponding relevent data Will populate in the 2nd DataGrid. Now when I click 2nd datagrid's EDIT button of a perticular Row,relevent data will populate on last 2 textboxs & 1st 3 textbox's value will be same as per as it was........ ........My Problem Is ........... When I click on edit button Of 2nd DataGrid, 1st 3 text boxes values goes Off & 2nd DataGrid Is goes off Due to Postback.but The relevent value is populated In last 2 textboxes.So How I stoped this postback??So that all the data in 1st 3 textboxes will be same.So that I can edit the values of 2nd Grid with 1st 3 textBoxes value.. plz dirctly mail me 1 copy of post to... maloy.adhikari@in.com
Explain about solution explorer window?
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)