What are the advantages of using sql stored procedures instead of adhoc sql queries in an asp.net web application?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ASP.NET Interview Questions

How can u handle Exceptions in Asp.Net?

4 Answers  


Which is the parent class of the ASP.NET server control?

0 Answers   Sans Pareil IT Services,


how to do pakaging nd deployment

1 Answers  


Write code to send e-mail from an asp.net application?

0 Answers  


What is server objects in asp.net?

5 Answers  






Hi this is the coding for adding data in to an xml table i want the coding for update and delete Try Dim emp_xml_doc As New XmlDocument If System.IO.File.Exists(Server.MapPath("emp.xml")) Then emp_xml_doc.Load(Server.MapPath("emp.xml")) Dim myrow_element As XmlElement myrow_element = emp_xml_doc.CreateElement("EmpDetails") Dim str As String str = "<EmpID>" & TxtEmpId.Text & "</EmpID>" & _ "<Empname>" & TxtName.Text & "</Empname>" & _ "<EmpSalary>" & TxtSalary.Text & "</EmpSalary>" myrow_element.InnerXml = str emp_xml_doc.DocumentElement.AppendChild(myrow_element) emp_xml_doc.Save(Server.MapPath("emp.xml")) Response.Write("Record Saved") Dim ds As New DataSet ds.ReadXml(Server.MapPath("emp.xml")) GridView1.DataSource = ds GridView1.DataBind() Else Response.Write("File does not exist.") End If Catch ex As Exception Response.Write(ex.ToString) End Try *********************** this is the xml file <?xml version="1.0" encoding="utf-8" ?> <Employee> <empdetails> <empid>100</empid> <empname>xxx</empname> <empsalary>2000</empsalary> </empdetails> <EmpDetails> <EmpID>yyy</EmpID> <Empname>dddd</Empname> <EmpSalary>77777</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>rrrr</EmpID> <Empname>rrrr</Empname> <EmpSalary>6666</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>qaqa</EmpID> <Empname>sini</Empname> <EmpSalary>50000</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>errrrrrrrr</EmpID> <Empname>rrrrrrrrr</Empname> <EmpSalary>677777</EmpSalary> </EmpDetails> <EmpDetails> <EmpID>rrr</EmpID> <Empname>rrr</Empname> <EmpSalary>33</EmpSalary> </EmpDetails> </Employee>

0 Answers   InfoCom,


Can we use html in asp.net?

0 Answers  


Finally and dispose methods?

1 Answers   Microsoft,


What is the significance of finalize method in .net?

0 Answers  


Describe the application event handlers in ASP.NET?

0 Answers   HCL,


Explain the difference between server.transfer and response.redirect? Why would I choose one over the other?

0 Answers  


For which does this Codebehind="MyCode.aspx.cs" is relevent to ?

0 Answers   Siebel,


Categories