梦飞家园

Dot Net 交流区
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

dbconn 调用Key连接数据库

Posted on 2005-08-04 17:48  梦飞家园  阅读(272)  评论(0)    收藏  举报
<%@ Page language="c#" Codebehind="dbconn.aspx.cs" AutoEventWireup="false" Inherits="c_web.dbconn" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
 <HEAD>
  <title>dbconn</title>
  <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
  <meta name="CODE_LANGUAGE" Content="C#">
  <meta name="vs_defaultClientScript" content="JavaScript">
  <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
 </HEAD>
 <body MS_POSITIONING="GridLayout">
  <form id="Form1" method="post" runat="server">
   <FONT face="宋体">
    <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server"
     Width="100%" Height="104px" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" BackColor="White"
     CellPadding="4" AllowPaging="True" PageSize="5" AutoGenerateColumns="False">
     <SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
     <ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
     <HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
     <FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
     <Columns>
      <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" HeaderText="操作" CancelText="取消" EditText="编辑">
       <HeaderStyle Width="15%"></HeaderStyle>
      </asp:EditCommandColumn>
      <asp:BoundColumn DataField="学号" HeaderText="学号">
       <HeaderStyle Width="10%"></HeaderStyle>
      </asp:BoundColumn>
      <asp:BoundColumn DataField="姓名" HeaderText="姓名">
       <HeaderStyle Width="10%"></HeaderStyle>
      </asp:BoundColumn>
      <asp:BoundColumn DataField="专业名" HeaderText="专业名">
       <HeaderStyle Width="15%"></HeaderStyle>
      </asp:BoundColumn>
      <asp:BoundColumn DataField="生日" HeaderText="生日" DataFormatString="{0:yyyy-M-d}">
       <HeaderStyle Width="15%"></HeaderStyle>
      </asp:BoundColumn>
      <asp:BoundColumn DataField="备注" HeaderText="备注">
       <HeaderStyle Width="15%"></HeaderStyle>
      </asp:BoundColumn>
      <asp:TemplateColumn HeaderText="性别">
       <HeaderStyle Width="10%"></HeaderStyle>
       <ItemTemplate>
        <asp:DropDownList id="DropDownList1" runat="server">
         <asp:ListItem Value="1">男</asp:ListItem>
         <asp:ListItem Value="0">女</asp:ListItem>
        </asp:DropDownList>
       </ItemTemplate>
      </asp:TemplateColumn>
      <asp:BoundColumn DataField="性别" HeaderText="sex">
       <HeaderStyle Width="10px"></HeaderStyle>
      </asp:BoundColumn>
     </Columns>
     <PagerStyle NextPageText="下一页" PrevPageText="上一页" HorizontalAlign="Center" ForeColor="#330099"
      BackColor="#FFFFCC"></PagerStyle>
    </asp:DataGrid></FONT>
  </form>
 </body>
</HTML>