<pedrocorreia.net ⁄>
<portugal ⁄><tecnologia ⁄><desporto ⁄><musica ⁄><mundo ⁄><ciencia ⁄>

<software ⁄><programacao ⁄><entretenimento ⁄><misc ⁄>
 

<Retrieving Database Information using ASP.NET and SQL Server 2005/2008 ⁄ >




clicks: 903 903 2009-02-26 2009-02-26 goto programacao myNews programacao  Bookmark This Bookmark This


In this article, we will retrieve database information using ASP.NET and SQL Server. We will be listing down the databases on our server and a list of database objects like Constraints, Procedures, Views etc. belonging to that database.
Let us get started. Create an ASP.NET application. Drag and drop a DropDownList, GridView and a SQLDataSource from the toolbox.
We will first populate the DropDownList with a list of databases present on the server. Use the following code to do so. Here we make use of the sys.sysdatabases system view. This view contains one row for each database in an instance of Microsoft SQL Server



este é só um excerto do artigo, para aceder ao artigo completo, clique no link em baixo:
this is just a small excerpt from the article, to access the full article please click in the link below:
http://www.dotnetcurry.com/ShowArticle.aspx?ID=278




Subscribe News RSS  Subscribe News Updates by E-mail





myNews <myNews show="rand" cat="programacao" ⁄>

RouterJs: easy routing for your ajax Web applications

RouterJs is a simple router for your ajax web apps. It's build upon History.js which means that Rout (...)

clicks: 100 100 2012-05-14 2012-05-14 goto url (new window) haithembelhaj.g... goto myNews programacao


Backbone computed properties

This gist shows one way to implement read- and write-enabled computed properties on a Backbone Model (...)

clicks: 114 114 2012-05-13 2012-05-13 goto url (new window) https://gist.gi... goto myNews programacao


Android Query

Android-Query (AQuery) is a light-weight library for doing asynchronous tasks and manipulating UI el (...)

clicks: 111 111 2012-05-12 2012-05-12 goto url (new window) code.google.com... goto myNews programacao


HTML5 jQuery Paint Plugin

Websanova Paint is a HTML5 canvas based jQuery plugin. It allows you to free paint on a canvas area (...)

clicks: 103 103 2012-05-12 2012-05-12 goto url (new window) websanova.com/t... goto myNews programacao


Create Instagram Filters With PHP

In this tutorial, I'll demonstrate how to create vintage (just like Instagram does) photos with PHP (...)

clicks: 110 110 2012-05-12 2012-05-12 goto url (new window) net.tutsplus.co... goto myNews programacao


Sass vs. LESS vs. Stylus: Preprocessor Shootout

CSS3 preprocessors are languages written for the sole purpose of adding cool, inventive features to (...)

clicks: 117 117 2012-05-11 2012-05-11 goto url (new window) net.tutsplus.co... goto myNews programacao


Real-time Applications With Node.js and Socket.IO

Hey everyone! Sorry about the long pause since the last blog post, life has been quite hectic for th (...)

clicks: 113 113 2012-05-11 2012-05-11 goto url (new window) codingcookies.c... goto myNews programacao


15 Handpicked jQuery Drop Down Menus Tutorials

Here we are presenting another brilliant collection of 15 jQuery navigation menu that you can downlo (...)

clicks: 125 125 2012-05-10 2012-05-10 goto url (new window) smashingapps.co... goto myNews programacao