search this blog [2700+ asp.net c# examples]

Loading...

How to use SqlDataSource in asp.net

asp.net SqlDataSource: how to use
SqlDataSource.aspx 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SqlDataSource.aspx.cs" Inherits="SqlDataSource" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>asp.net SqlDataSource: how to use</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h2 style="color:Green">SqlDataSource</h2>
        <asp:SqlDataSource 
            ID="SqlDataSource1"
            runat="server"
            ConnectionString="<%$ ConnectionStrings:Northwind %>"
            SelectCommand="SELECT CategoryID, CategoryName FROM Categories"
            DataSourceMode="DataReader"
            >
        </asp:SqlDataSource>
        <asp:CheckBoxList 
            ID="CheckBoxList1"
            runat="server"
            >
        </asp:CheckBoxList>
    </div>
    </form>
</body>
</html>
SqlDataSource.aspx.cs 
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class SqlDataSource : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!this.IsPostBack)
        {
            CheckBoxList1.DataSourceID = "SqlDataSource1";
            CheckBoxList1.DataTextField = "CategoryName";
            CheckBoxList1.DataValueField = "CategoryID";
            CheckBoxList1.RepeatColumns = 3;
            CheckBoxList1.BorderWidth = 2;
            CheckBoxList1.BorderColor = System.Drawing.Color.Green;
            CheckBoxList1.BackColor = System.Drawing.Color.SeaGreen;
            CheckBoxList1.ForeColor = System.Drawing.Color.Snow;
        }
    }
}




Related asp.net example
Labels: