exceltodatabase.aspx
来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· ASPX 代码 · 共 111 行
ASPX
111 行
<%@ page language="C#" enableeventvalidation="false" autoeventwireup="true" inherits="UserManagement_ExcelToDataBase, App_Web_iy7gp0bk" theme="SkinFile" %>
<!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>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="width: 834px; height: 57px; background-color: #f3f8ff;" >
<tr>
<td style="font-size: small; width: 100px; height: 2px">
<hr style="width: 822px" />
下载Excel文件</td>
</tr>
<tr>
<td style="width: 100px; height: 30px; font-size: small;">
<table style="width: 827px">
<tr>
<td style="font-size: small; width: 87px; height: 26px">
请选择群组
</td>
<td style="font-size: small; width: 159px;">
<asp:DropDownList ID="cbUserTeam" runat="server" Width="153px" AutoPostBack="True" OnSelectedIndexChanged="cbUserTeam_SelectedIndexChanged">
</asp:DropDownList></td>
<td style="font-size: small; width: 98px;">
请选择部门单位
</td>
<td style="font-size: small; ">
<asp:DropDownList ID="cbDept" runat="server" Width="153px">
</asp:DropDownList>
<asp:Button ID="btnQuery" runat="server" Text="查询编码" OnClick="btnExcelFileDown_Click" />
<asp:HyperLink ID="HyperLink1" runat="server" Width="133px" Font-Size="Small" NavigateUrl="~/UserManagement/UpLoadFiles/ExcelFile.xls">下载Excel文件</asp:HyperLink></td>
</tr>
</table>
<table style="width: 825px">
<tr>
<td>
下载Excel用户信息表格注意事项:</td>
</tr>
<tr>
<td>
1、不能修改Excel各单元格格式。</td>
</tr>
<tr>
<td>
2、Excel用户信息表格中的群组号和部门单位号可以从上面的查询功能得到。</td>
</tr>
<tr>
<td>
3、Excel用户信息表格中的群组号、部门单位号、手机号必须填写。</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="font-size: small; width: 100px; height: 30px">
<hr style="width: 821px" />
上传Excel文件</td>
</tr>
<tr>
<td style="width: 100px; ">
<table style="width: 416px; font-size:small;">
<tr>
<td style="width: 88px; height: 15px;">
Excel工作表名</td>
<td style="width: 96px; height: 15px;">
<asp:TextBox ID="tbExcelTableName" runat="server">Sheet1$</asp:TextBox>
<input id="myFile" type="file" runat="server" name="myFile"/></td>
</tr>
<tr>
<td style="width: 88px; height: 17px">
文件名</td>
<td style="width: 96px; height: 17px">
<asp:TextBox ID="tbFileName" runat="server" Width="309px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 88px; height: 16px">
文件类型</td>
<td style="width: 96px; height: 16px">
<asp:TextBox ID="tbFileType" runat="server" Width="309px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 88px; height: 17px">
文件大小</td>
<td style="width: 96px; height: 17px">
<asp:TextBox ID="tbFileSize" runat="server" Width="309px" Enabled="False"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 88px; height: 17px">
</td>
<td style="width: 96px; ">
<asp:Button ID="btnUploadExcel" runat="server" Text="上传Excel文件" OnClick="UploadFile"/>
<asp:Button ID="btnImportData" runat="server" Text="Button" OnClick="btnImportData_Click" /></td>
</tr>
</table>
<asp:Panel ID="Panel1" runat="server" Height="200px" ScrollBars="Vertical" Width="125px">
<asp:GridView ID="gvDownExcel" runat="server" Visible="False" Height="111px" Width="833px">
</asp:GridView>
</asp:Panel>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?