Asp.net/perl.net Database Access Example
One of the features of the. NET Framework is it ability to handle multiple languages. Third party compiler vendors can create and implement a compiler targeted for the. NET Runtime. In fact, over the course of the "next year", you can expect to the some languages to the. NET ported. This would allow companies with the huge codebase in a "Non-microsoft language" to continue building onto their.
Note:all of the software required to create and run asp.net pages built using Perl.net can is downloaded here.
This is the code for the whole page (we'll dissect and explain each bit of the code throughout the rest of the article):
<%@ Page
Language= "Perl"%>
<script runat= "Server" >
Use namespace "System::D ata";
Use namespace "System::D ata::sqlclient";
=for interface
protected override void OnLoad (System.EventArgs e);
=cut
Sub OnLoad {
My ($this, $e) = @_;
My $myConnection = Sqlconnection->new ("Data source=" (local); Trusted_connection=yes; Initial
Catalog=pubs ");
My $myCommand = sqlcommand->new ("Select * from Publishers", $myConnection);
$myConnection->open ();
$this->{mydatagrid}{datasource} = $myCommand->executereader (perlnet::enum
("CommandBehavior.CloseConnection"));
$this->{mydatagrid}->databind;
}
</script>
<body>
<form runat= "Server" >
<asp:datagrid id= "Mydatagrid" runat= "Server"/>
</form>
</body>
