第三天ASP.NET学习总结

1.DataGrid控件不用模板时显示头部文字和超链接:
<asp:DataGrid
  ID="dgrdLinks"
  AutoGenerateColumns="False"
  EnableViewState="False"
  CellPadding="10"
  Runat="Server">
<Columns>
  <asp:HyperLinkColumn
    DataNavigateUrlField="link_url"
    DataTextField="link_title"
    HeaderText="链接标题"
    HeaderStyle-Font-Name="Arial"/>
</Columns>
</asp:DataGrid>         //DataGrid默认时显示header,不显示footer的

2.DataGrid的GridLines=none时是没有单元格线的....BackImgeUrl是背景图片的地址.

3.DataGrid的style....同样可以对DataGrid的个别列进行样式设置
<asp:DataGrid
  ID="dgrdTitles"
  CellPadding="10"
  BorderStyle="Dashed"   //虚线框
  BorderColor="blue"
  BorderWidth="8px"
  HeaderStyle-Font-Name="Arial"
  HeaderStyle-Font-Bold="True"
  HeaderStyle-BackColor="lightyellow"
  ItemStyle-Font-Name="Arial"
  ItemStyle-Font-Size="10pt"
  AlternatingItemStyle-BackColor="AliceBlue"
  Runat="Server" />

4.DataGrid对列进行排序(必须将AllowSorting设为True,并要响应一个SortCommand事件)
前台:
     <asp:DataGrid
  ID="dgrdTitles"
  AllowSorting="True"
  OnSortCommand="dgrdTitles_SortCommand"
  AutoGenerateColumns="False"
  CellPadding="10"
  Runat="Server">
<Columns>
  <asp:BoundColumn
    DataField="Title"
    HeaderText="Sort Titles"
    SortExpression="title"/>
  <asp:BoundColumn
    HeaderText="Sort Price"
    DataField="price"
    DataFormatString="{0:c}"
    SortExpression="price"/>
  <asp:BoundColumn
    DataField="Notes" />
</Columns>
</asp:DataGrid>

后台:
     void Page_Load(Object sender , EventArgs e)
{
 if (! IsPostBack ) {
  BindDataGrid( "Title" );
 }
}

void BindDataGrid( string  strSortField ) {
 SqlConnection conPubs;
 SqlCommand cmdSelect;

 conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Pubs" );
 cmdSelect = new SqlCommand( "Select * From Titles Order By " + strSortField, conPubs );
 conPubs.Open();
 dgrdTitles.DataSource = cmdSelect.ExecuteReader();
 dgrdTitles.DataBind();
 conPubs.Close();
}

void dgrdTitles_SortCommand( object s, DataGridSortCommandEventArgs e ) {
 BindDataGrid( e.SortExpression );
}

5.DataGrid对数据进行分页显示(必须将AllowPaging设为True,并要响应一个PageIndexChanged事件)
前台:
<asp:DataGrid
  ID="dgrdProducts"
  AllowPaging="True"
  AllowCustomPaging="True"
  PageSize="3"
  OnPageIndexChanged="dgrdProducts_PageIndexChanged"
  PagerStyle-Mode="NumericPages"
  CellPadding="3"
  Runat="Server" />
后台:
SqlConnection conNorthwind;
string  strSelect;
int intStartIndex;
int intEndIndex;

void Page_Load(Object sender , EventArgs e)
{
 SqlCommand cmdSelect;

 conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Northwind" );
 if (! IsPostBack )
 {
  // Get  Total Pages
  strSelect = "Select Count(*) From Products";
  cmdSelect = new SqlCommand( strSelect, conNorthwind );
  conNorthwind.Open();
  dgrdProducts.VirtualItemCount = ( (int)cmdSelect.ExecuteScalar() / dgrdProducts.PageSize );
  conNorthwind.Close();
  BindDataGrid();
 }
}

void BindDataGrid ()
{
 SqlDataAdapter dadProducts;
 DataSet dstProducts;

 intEndIndex = intStartIndex + dgrdProducts.PageSize;
 strSelect = "Select * From Products Where ProductID > @startIndex And ProductID <= @endIndex Order By ProductID";
 dadProducts = new SqlDataAdapter( strSelect, conNorthwind );
 dadProducts.SelectCommand.Parameters.Add( "@startIndex", intStartIndex );
 dadProducts.SelectCommand.Parameters.Add( "@endIndex", intEndIndex );
 dstProducts = new DataSet();
 dadProducts.Fill( dstProducts );

 dgrdProducts.DataSource = dstProducts;
 dgrdProducts.DataBind();
}

void dgrdProducts_PageIndexChanged( object s, DataGridPageChangedEventArgs e ) {
 intStartIndex = ( e.NewPageIndex * dgrdProducts.PageSize );
 dgrdProducts.CurrentPageIndex = e.NewPageIndex;
 BindDataGrid();
}

6.DataGrid大类控制小类....
前台:
<asp:DataGrid
  ID="dgrdCategories"
  OnItemCommand="dgrdCategories_ItemCommand"
  DataKeyField="CategoryID"
  AutoGenerateColumns="False"
  SelectedItemStyle-BackColor="LightGreen"
  ShowHeader="False"
  Runat="Server">
<Columns>
  <asp:TemplateColumn>
  <ItemTemplate>
  <asp:LinkButton
    Text='<%# DataBinder.Eval(Container.DataItem, "CategoryName") %>'
    Runat="Server"/>
  </ItemTemplate>
  </asp:TemplateColumn>
  <asp:BoundColumn DataField="Description" />
</Columns>
</asp:DataGrid>

<p>

<asp:DataGrid
  ID="dgrdProducts"
  HeaderStyle-BackColor="yellow"
  Runat="Server" />
后台:
void Page_Load(Object sender, EventArgs e)
{
 BindMasterGrid();
}

void BindMasterGrid (){
 SqlConnection conNorthwind;
 SqlCommand cmdSelect;

 conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Northwind" );
 cmdSelect = new SqlCommand( "Select * From Categories", conNorthwind );
 conNorthwind.Open();
 dgrdCategories.DataSource = cmdSelect.ExecuteReader();
 dgrdCategories.DataBind();
 conNorthwind.Close();
}

void BindDetailGrid( int intCatID ) {
 SqlConnection conNorthwind;
 string  strSelect;
 SqlCommand cmdSelect;

 conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Northwind" );
 strSelect = "Select * From Products Where CategoryID=@catID";
 cmdSelect = new SqlCommand( strSelect, conNorthwind );
 cmdSelect.Parameters.Add( "@catID", intCatID );
 conNorthwind.Open();
 dgrdProducts.DataSource = cmdSelect.ExecuteReader();
 dgrdProducts.DataBind();
 conNorthwind.Close();
}

void dgrdCategories_ItemCommand( object s, DataGridCommandEventArgs e ) {
 int intCatID;

 intCatID = Convert.ToInt32(dgrdCategories.DataKeys[ e.Item.ItemIndex ]);
 dgrdCategories.SelectedIndex = e.Item.ItemIndex;
 BindDetailGrid( intCatID );
}