<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
DataSet Example
void Page_Load()
{
String ConnStr = "Data Source=whsql-v08.prod.mesa1.secureserver.net;Initial Catalog=DB_49907;User ID=rntsoftuser;Password='password';";
String SQL = "SELECT ID, FirstName FROM Employee "
+ "WHERE ID IS NOT NULL";
SqlDataAdapter TitlesAdpt = new SqlDataAdapter(SQL, ConnStr);
DataSet Titles = new DataSet();
// No need to open or close the connection
// since the SqlDataAdapter will do this automatically.
TitlesAdpt.Fill(Titles);
Output.Text = "";
foreach (DataRow Title in Titles.Tables[0].Rows)
{
Output.Text += "";
Output.Text += "" + Title[0] + " ";
Output.Text += "" + String.Format("{0:c}", Title[1])
+ " ";
Output.Text += " ";
}
Output.Text += "
";
}
DataSet Example