Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between ExecuteReader,ExecuteNonQuery
and ExecuteScalar.

Answer Posted / sudha

Executereader :-is used with read Method and it will read
the query and fill that in a dataset.we use it in
datareader.

Execute Scalar:-is used when you want a single output.It is
used with Return Value.

ExecuteNonQuery:-This Function is Used When you want to
update your query it does not perform any aoperation like:-
update,deletion,insert.It is used with Perform Action.

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ispostback property?

910


Which object encapsulates state or data of a user?

1066


What are directives in asp.net?

953


Can more than one person use the same login?

969


What are the asp.net list controls and difference between them?

1015


In order to get assembly info which namespace we should import?

994


If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?

2474


What is the concept of postback in asp.net?

1035


What is the difference between globalization and localization?

959


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 = "" & TxtEmpId.Text & "" & _ "" & TxtName.Text & "" & _ "" & TxtSalary.Text & "" 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 100 xxx 2000 yyy dddd 77777 rrrr rrrr 6666 qaqa sini 50000 errrrrrrrr rrrrrrrrr 677777 rrr rrr 33

2123


Define a web service in .net?

1052


In which event are the controls fully loaded?

996


Which is the best institute to learn Microsoft Technologies and the faculty if you Know?

2143


How does session authentication work?

917


What is the default Orientation property in a Menu control?

1040