?? course.aspx
字號:
?<!-- #include virtual="/include/pagedirective.inc" -->
<!-- #include virtual="/include/imports.inc" -->
<!-- #include virtual="/include/common_function.inc" -->
<html>
<head>
<link REL="StyleSheet" HREF="/css/standard.css" >
<script language="C#" runat="server">
/*************************************************
* 模塊: course.aspx
* 作者: miles
* 修改: 1/30/2001
* 目的: course table maintain
* 參數: none
* 數據: sel: course
* ins: course
* del: course
* upt: none
***************************************************/
private void Page_Load(Object Src, EventArgs E) {
}
private void Add_Click(Object sender, EventArgs E) {
try {
string insertCmd = "insert into course (course_id,course_name) values (@course_id,@course_name)";
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@course_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@course_id"].Value = course_id.Value;
myCommand.Parameters.Add(new SqlParameter("@course_name", SqlDbType.VarChar, 50));
myCommand.Parameters["@course_name"].Value = course_name.Value;
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLInsDone();
}
catch (System.Data.SqlClient.SqlException e) {
SQLErrorHandler(e);
}
myConnection.Close();
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
private void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs E) {
try {
string deleteCmd = "delete from course where course_id = @course_id";
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@course_id", SqlDbType.VarChar, 50));
myCommand.Parameters["@course_id"].Value = MyDataGrid.DataKeys[(int)E.Item.ItemIndex];
myConnection.Open();
try {
myCommand.ExecuteNonQuery();
MessageSQLDelDone();
}
catch (System.Data.SqlClient.SqlException e) {
SQLErrorHandler(e);
}
myConnection.Close();
BindGrid();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
private void MyDataGrid_Page(Object sender, DataGridPageChangedEventArgs E) {
try {
MyDataGrid.CurrentPageIndex = E.NewPageIndex;
BindGrid();
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void FilterApply_Click(Object sender, EventArgs E) {
try {
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
SqlDataAdapter myCommand = new SqlDataAdapter("select * from course where course_id like '"+course_id_filter.Value.ToString().Trim()+"%' or course_name like '%"+course_id_filter.Value.ToString().Trim()+"%' ", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "course");
MyDataGrid.DataSource=ds.Tables["course"].DefaultView;
MyDataGrid.CurrentPageIndex=0;
MyDataGrid.DataBind();
recordcount.Text="["+course_id_filter.Value+"] 共"+ds.Tables["course"].Rows.Count.ToString();
}
catch (System.Exception e) {
ErrorHandler(e.ToString());
}
}
private void BindGrid() {
try {
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["edu"]);
SqlDataAdapter myCommand = new SqlDataAdapter("select * from course where course_id like '"+course_id_filter.Value.ToString().Trim()+"%' or course_name like '%"+course_id_filter.Value.ToString().Trim()+"%' ", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "course");
MyDataGrid.DataSource=ds.Tables["course"].DefaultView;
MyDataGrid.DataBind();
recordcount.Text="["+course_id_filter.Value+"] 共"+ds.Tables["course"].Rows.Count.ToString();
}
catch (System.Exception e){
ErrorHandler(e.ToString());
}
}
</script>
</head>
<body style="font: 10pt verdana">
<!-- #include virtual="/include/header.inc" -->
<form runat="server">
<table width=100% cellspacing=0 cellpadding=0>
<tr>
<td align="center" class="CONTENTTITLE" width="100%" bgcolor="D3C9C7">
科目維護
</td>
</tr>
<tr>
<td>
<span id="Message" EnableViewState="false" class="MESSAGE" runat="server"/>
</td>
</tr>
<tr>
<td colspan="10" bgcolor="#aaaadd" style="font:10pt verdana">新增:</td>
</tr>
</table>
<table style="font: 8pt verdana">
<tr>
<TD VALIGN="top" ALIGN="left"><span class="REQUIREDFIELD">科目代碼:</span><BR><input type="text" id="course_id" value="000" runat="server"></FONT></TD>
<TD VALIGN="top" ALIGN="left"><span class="REQUIREDFIELD">科目名稱:</span><BR><input type="text" id="course_name" value="000" runat="server"></FONT></TD>
<TD VALIGN="top" ALIGN="left"><FONT FACE="Verdana,Helvetica,Arial" SIZE=1> <BR> <input type="submit" OnServerClick="Add_Click" value="新增" runat="server"></FONT></TD>
</tr>
<TR>
<TD ><asp:RequiredFieldValidator ControlToValidate="course_id" Display="Static" ErrorMessage="*:不可空白" runat=server/></TD>
<TD ><asp:RequiredFieldValidator ControlToValidate="course_name" Display="Static" ErrorMessage="*:不可空白" runat=server/></TD>
</TR>
</table>
<table style="font: 8pt verdana" width=100% >
<tr><td colspan="5" bgcolor="#aaaadd" style="font:10pt verdana">查詢科目代碼及名稱:
<input type="text" id="course_id_filter" runat="server">
<input type="submit" OnServerClick="FilterApply_Click" value="查詢" runat="server">
<asp:Label id="recordcount" runat="server" />筆 </td>
<tr>
<td colspan="5" bgcolor="#aaaadd" style="font:10pt verdana">修改/刪除:</td>
</tr>
</table>
<ASP:DataGrid id="MyDataGrid" runat="server"
AllowPaging="True"
PageSize="15"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
OnPageIndexChanged="MyDataGrid_Page"
BackColor="#F4FFF4"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="lightblue"
OnDeleteCommand="MyDataGrid_Delete"
DataKeyField="course_id"
AutoGenerateColumns="false"
>
<Columns>
<asp:ButtonColumn Text="刪除" CommandName="Delete" ButtonType="PushButton" />
<asp:TemplateColumn HeaderText="科目代碼" >
<ItemTemplate>
<a href="course_upt.aspx?course_id=<%# DataBinder.Eval(Container.DataItem, "course_id") %>"><asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "course_id") %>'/> </a>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="科目名稱" SortExpression="course_name">
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "course_name") %>'/>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</ASP:DataGrid>
</form>
<!-- #include virtual="/include/footer.inc" -->
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -