lxl
/
JW


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
							<%@ Page Language="C#" Debug=true AutoEventWireup="true" CodeFile="BasicImportDB.aspx.cs" Inherits="Admin_BasicImportDB" %>

<!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 id="Head1" runat="server">
    <title></title>
    <link href="js/tableCSS.css" rel="stylesheet" type="text/css" />
    <link href="js/ASPNET2BaseCss.css" rel="stylesheet" type="text/css" />
    <link rel="stylesheet" href="css/dataTable.css" media="screen">
    <style>
#maindiv,#maindiv1,#maindiv2,#maindiv3{
	width:98%;
	height:auto;
	border:#06F 1px groove;
	margin:0 auto;
	margin-top:10px;
	border-radius:15px;
	box-shadow:#CCC 6px 6px;
	padding:10px;
	font-size:12px;	
	background-color:White;
	}
#menu1{
	
	background-color:#E7F4F8;
	border:#03C 1px dotted;
	border-radius:8px;
	
	color:White;
	padding:3px;
	box-shadow:#859CAD 4px 4px;
	text-align:left;
	color:#333399;
	
	}

#stNav,#stNav1,#stNav2,#stNav3
{
	padding:5px;
	margin-top:6px;
	background-color:#F8FBFC;
	text-align:center;
	border:#F00 1px thick;

	box-shadow:#859CAD 3px 3px;
	border-radius:10px;

	}
table
{box-shadow:#859CAD 3px 3px;
	border-radius:10px;
    }
 td
 {
     padding:5px;
     
     }
input,select
{ padding:5px;
    }
  
  h3
  {
      color:Gray;   
      }  
#CheckBoxList1
{color:Blue;
    }
    </style>
   
</head>
<body>

<form id="form1" runat="server">
<asp:Panel ID="Panel1" runat="server">
    <div id="maindiv"><div id="stNav">
           <h3> 第一步：选择要导入的Excel文件</h3><br />
           <asp:FileUpload ID="File1" runat="server" c="" Height="30px" Width="242px" />
           <asp:Button ID="B1" runat="server" CssClass="Input3" Height="36px" OnClick="input_Click" Text="提交" Width="100px" />
    </div></div>  
</asp:Panel>
 <asp:Panel ID="Panel2" runat="server">
     <div id="maindiv1"><div id="stNav1">
             <h3> 第二 步：从下面选择要导入数据的表</h3><br />    <center>
                    选择你要导入数据存在的EXCEL表名：<asp:DropDownList ID="DropDownList1" runat="server" >
                    </asp:DropDownList>
             
                    <asp:Button ID="Button3" runat="server" OnClick="Button3_Click"
                        Text="查看要导入的列名(字段名)" Width="230px" />
                    <h3>
                        第三 步： 选择要导入数据的字段名(列名)：<br /> 
                        <asp:CheckBoxList ID="CheckBoxList1" runat="server" 
                            RepeatDirection="Horizontal">
                        </asp:CheckBoxList>
                    </h3>
                    <asp:Button ID="Button1" runat="server" CssClass="Input3" Height="36px" 
                        OnClick="Button1_Click" Text="查看EXCEL要导入的数据" Visible="False" />
                </center>
     </div></div> 
</asp:Panel>
<asp:Panel ID="Panel3" runat="server">
  <div id="maindiv2"><div id="stNav2">
              <h3> 第四步：  选择表的数据是：</h3><br />
                <asp:Literal ID="Literal1" runat="server"></asp:Literal>
                <br />
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" CssClass="Input3"
                    Height="36px" Text="上面数据准确无误，点此导入数据" />
   </div></div>  
</asp:Panel>
<asp:Panel ID="Panel4" runat="server">
 <div id="maindiv3"><div id="stNav3">
               <h3> 第五步：显示导入结果</h3><br />
                <br />
                导入表的最后10条记录是：<br />
                <asp:Literal ID="Literal2" runat="server"></asp:Literal>
                <br />
                <asp:Literal ID="Literal3" runat="server"></asp:Literal>
  </div></div>
</asp:Panel>
      
    </form>
</body>
</html>