Visual Studio Community
It is a limited edition of Visual Studio, the flagship software from Microsoft. It is a free standalone product and includes the core set of web design features from Visual Studio. ASP.NET web applications could be created by it.
Microsoft ADO.NET (ActiveX Data Objects)
It is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components. Check an example.
using System;
using System.Data.OleDb;
public partial class NextPage : System.Web.UI.Page {
protected void authorList_SelectedIndexChanged( object sender, EventArgs e ) {
OleDbConnection conn = new OleDbConnection(
@"Provider=Microsoft.ACE.OleDb.12.0;Data Source=" +
Server.MapPath( "Access\\bookstore.accdb" ) );
String sql = "SELECT authorID, authorName, email ";
sql += "FROM authors WHERE authorName = @authorName";
OleDbCommand cmd = new OleDbCommand( sql, conn );
cmd.Parameters.AddWithValue( "@authorName", authorList.SelectedValue );
conn.Open( );
var dbread = cmd.ExecuteReader( );
author.DataSource = dbread;
author.DataBind( );
dbread.Close( );
conn.Close( );
}
}
|
|
Worrying is like paying a debt you don’t owe. — Mark Twain |