> 
- Home Page
- > Script C#
- > Script C# Database
- > Dataset ADO.Net
Dataset ADO.Net - << VB.NET VERSION >>
ADO.Net Dataset connections
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<html>
<body>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection objSQLConn = new SqlConnection();
objSQLConn.ConnectionString = "user id=USERID; password=PASSWORD; initial catalog=DATABASE; data source=DATABASESERVER;";
//Apro la connessione;
objSQLConn.Open();
//Data adapter
SqlDataAdapter objAdapter = new SqlDataAdapter("SELECT * FROM TABELLA", objSQLConn);
//Creo il dataset
DataSet ds = new DataSet();
//Lo riempio
objAdapter.Fill(ds, "TABELLA");
}
</script>
</body>
</html>
