Skip to main content

ADO.NET



ADO.Net provides a bridge between the front end controls and the back end database. The ADO.Net objects encapsulate all the data access operations and the controls interact with these objects to display data, thus hiding the details of movement of data.
The following figure shows the ADO.Net objects at a glance:



Comments

Post a Comment

Popular posts from this blog

Export html table to csv using javascript

<table>     <tr><th>Name</th><th>Age</th><th>Country</th></tr>     <tr><td>MANOJ</td><td>26</td><td>INDIA</td></tr>     <tr><td>KRISHAN</td><td>19</td><td>INDIA</td></tr>     <tr><td>SUSHEEL</td><td>32</td><td>INDIA</td></tr> </table> <button onclick="Export_CSV ()">Export HTML table to CSV file</button> function download_csv(csv, filename) {     var csvFile;     var downloadLink;     csvFile = new Blob([csv], {type: "text/csv"});     downloadLink = document.createElement("a");     downloadLink.download = filename;     downloadLink.href = window.URL.createObjectURL(csvFile);     downloadLink.style.d...
Post a Comment
Read more

Difference between SQL Function and Stored Procedure

The main difference between functions and stored procedures  are given bellow: Function(User Defined) It returns only one value We can’t use transaction in function Only have input parameter We can’t called SP from function We can’t use exception handling using Try-Catch block in function We can use function in select/where/having statement Stored Procedure (Store Procedure) It returns zero, single or multiple values We can use transaction in SP Can have input/output parameter We can called function from SP We can use exception handling using Try-Catch block in SP We can’t use SP in select/where/having statement
Post a Comment
Read more