
In code Page:
SqlConnection scn = new SqlConnection("Data Source=.;Initial Catalog=test;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
scn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from video", scn);
DataSet ds = new DataSet();
da.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
scn.Close();
}
Output:

No comments:
Post a Comment