梦想时光网络团队博客

.clear {visibility:hidden;display:block;font-size:0;content:" ";clear:both;height:0;}

.clear {visibility:hidden;display:block;font-size:0;content:" ";clear:both;height:0;overflow:hidden;}

OleDbConnection con = new OleDbConnection();
try
{
    OpenFileDialog openFile = new OpenFileDialog();//打开文件对话框
    openFile.Filter = ("Excel 文件(*.xls)|*.xls");//后缀名
    if (openFile.ShowDialog() == DialogResult.OK)
    {
        string filename = openFile.FileName;
        int index = filename.LastIndexOf("//");//截取文件的名字
        filename = filename.Substring(index + 1);
        conExcel.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + 
                                        Application.StartupPath + "//Appdata.mdb";
        // 将excel导入access
        // distinct :删除excel重复的行.
        // [excel名].[sheet名] 已有的excel的表要加$
        // where not in : 插入不重复的记录
 
        string sql = "insert into Users2(用户编号,用户姓名) select distinct * from [Excel 8.0;database=" +
                            filename + "].[name$] where 用户编号 not in (select 用户编号 from Users2) ";
        OleDbCommand com = new OleDbCommand(sql, con);
        con.Open();
        com.ExecuteNonQuery();
        MessageBox.Show("导入数据成功", "导入数据", MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
}
catch (Exception ex)
{
    MessageBox.Show(ex.ToString());
}
finally
{
    con.Close();
}

OleDbConnection con = new OleDbConnection();   
try  
{   
    SaveFileDialog saveFile = new SaveFileDialog();   
    saveFile.Filter = ("Excel 文件(*.xls)|*.xls");//指定文件后缀名为Excel 文件   
    if (saveFile.ShowDialog() == DialogResult.OK)   
    {   
        string filename = saveFile.FileName;   
        if (System.IO.File.Exists(filename))   
        {   
            System.IO.File.Delete(filename);//如果文件存在删除文件  
        }   
        int index = filename.LastIndexOf("//");//获取最后一个/的索引   
        filename = filename.Substring(index + 1);//获取excel名称(新建表的路径相对于SaveFileDialog的路径)   
        // select * into 建立新表   
        // [Excel 8.0;database= excel名].[sheet名] 如果是新建sheet表不能加$,如果向sheet里插入数据要加$.　   
        // sheet最多存储65535条数据   
        string sql = "select top 65535 *  into   [Excel 8.0;database=" + filename + "].[用户信息] from Users2";   
        conExcel.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" +
            Application.StartupPath + "//Appdata.mdb";//将数据库放到debug目录下   
        OleDbCommand com = new OleDbCommand(sql, con);   
        con.Open();   
        com.ExecuteNonQuery();  
        MessageBox.Show("导出数据成功", "导出数据", MessageBoxButtons.OK, MessageBoxIcon.Information);   
    }   
}   
catch (Exception ex)   
{   
    MessageBox.Show(ex.ToString());   
}   
finally  
{   
    con.Close();   
}

<div id="imgBox">
    <img src="images/abc.jpg" alt="" />
</div>

#imgBox {
    width: 136px;
    height: 136px;
    text-align: center;
    border: #e0e0e0 solid 1px;
 
    /* 兼容FF chrome等标准浏览器 */
    display: table-cell;
    vertical-align: middle;
 
    /* 兼容IE6 IE7浏览器 */
    *display: block;
    *font-size: 119px; /* 字体大小约为行高的0.873倍 136*0.873=119 */
    *font-family: Arial; /* 防止非utf-8引起的hack失效，如gbk页面编码 */
}
#imgBox img {
    vertical-align:middle;
}

// 数据库文件相对路径
string DBFile = "~/../database/#sitedb.mdb";
// 获取数据库文件物理路径
string DBPath = System.Web.HttpContext.Current.Server.MapPath(DBFile);

<table width="100%" border="1">
  <colgroup span="2" align="left"></colgroup>
  <colgroup align="right" style="color:#0000FF;"></colgroup>
  <tr>
    <th>ISBN</th>
    <th>Title</th>
    <th>Price</th>
  </tr>
  <tr>
    <td>3476896</td>
    <td>My first HTML</td>
    <td>$53</td>
  </tr>
</table>

<img src="1.jpg" style="clip:rect(10px 100px 90px 20px);position: absolute;width: 100px;" />

string sFilePath = System.IO.Path.Combine( sServerDir, sFileName );

Random rd = new Random();
sFileName = DateTime.Now.ToString("yyMMddHHmmss") + rd.Next(100,1000) + System.IO.Path.GetExtension(sFileName); 
string sFilePath = System.IO.Path.Combine( sServerDir, sFileName );

Response.Write( @"(function(){var d=document.domain;while (true){try{var A=window.top.opener.document.domain;break;}catch(e) {};d=d.replace(/.*?(?:.|$)/,'');if (d.length==0) break;try{document.domain=d;}catch (e){break;}}})();" );