qianbao

文采有限,写不出系统的文章....所以只能记录一些小小的知识点
没有真正的捷径能绕过黑暗直达黎明..

2008年5月16日 #

insert ...into...

insert into tablename(name,s) select name,5 from test where s=1

没想到还挺有用的。。以前从没用过。。

posted @ 2008-07-03 11:56 qianbao 阅读(13) | 评论 (0) | 编辑

不一定要ArrayList！！！！！

不一定要ArrayList！！！！！

返回DataReader有时可以减轻很多工作量

posted @ 2008-06-25 18:18 qianbao 阅读(20) | 评论 (0) | 编辑

Ext太疯狂了



Ext太疯狂了..无语,从此Myblogs又要多一个分类了..

Ext..哈哈

posted @ 2008-06-04 23:15 qianbao 阅读(11) | 评论 (0) | 编辑

Excel to gridview

protected void Button1_Click(object sender, EventArgs e)
        {
            if (this.FileUpload1.HasFile)
            {
                // FileInfo file = new FileInfo(this.FileUpload1.FileName);
                this.FileUpload1.PostedFile.SaveAs(Server.MapPath(this.FileUpload1.FileName));
                //string con = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(this.FileUpload1.FileName) + ";Extended Properties=Excel 8.0; ";//下面连接字符串03和07都支持
                string con = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(this.FileUpload1.FileName) + ";Extended Properties=\"Excel 12.0;HDR=YES\";";
                OleDbConnection objCon = new OleDbConnection(con);
                string strSel = "select * from [Sheet1$]";
                OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSel, objCon);
                DataSet ds = new DataSet();
                objCon.Open();
                objAdapter.Fill(ds);
                objCon.Close();
                this.GridView1.DataSource = ds;
                this.GridView1.DataBind();
            }
        }

posted @ 2008-05-31 12:18 qianbao 阅读(11) | 评论 (0) | 编辑

上传文件

 
 if (this.FileUpload1.HasFile)
            {
               // FileInfo file = new FileInfo(this.FileUpload1.FileName);
                this.FileUpload1.PostedFile.SaveAs(Server.MapPath(this.FileUpload1.FileName));
            }

posted @ 2008-05-31 11:55 qianbao 阅读(3) | 评论 (0) | 编辑

javascript绑定事件的类



//构造函数
function Listener()
{
}

Listener.isie=document.all?true:false;
//参数：对象，事件（不用on）,绑定的方法名
Listener.addListener=function(obj,eventname,method)
{
    if(eventname.indexOf("on") == 0)
    {
        alert("添加的事件不要前缀on！");
        return;
    }
    if(method!=null)
    {
        if(Listener.isie)
        {    
            eventname = "on" + eventname;
            obj.attachEvent(eventname,method);
        }
        else
        {
            obj.addEventListener(eventname,method,false);
        }    
    }
}

posted @ 2008-05-20 21:28 qianbao 阅读(11) | 评论 (0) | 编辑

选择是痛苦的!

    放弃了一2000+/月
    又放弃了3000+/月
    却选择了1000+/月

    我对了?我错了?

posted @ 2008-05-20 14:36 qianbao 阅读(2) | 评论 (0) | 编辑

html读XML

<database>
    <school-info>
        <name>aaaaaaaaaaaaa</name>
        <city>aaaaaa</city>
        <stu>aaaaaaa</stu>
    </school-info>
    <school-info>
        <name>aaaaaaaaaaaaa</name>
        <city>aaaaaa</city>
        <stu>aaaaaaa</stu>
    </school-info>
    <school-info>
        <name>aaaaaaaaaaaaa</name>
        <city>aaaaaa</city>
        <stu>aaaaaaa</stu>
    </school-info>
    <school-info>
        <name>aaaaaaaaaaaaa</name>
        <city>aaaaaa</city>
        <stu>aaaaaaa</stu>
    </school-info>
</database>

 <BODY>
  <xml id="schools" src="example.xml"></xml>
  <table datasrc="#schools" id="schoolinfo" width="80%" align="center" cellpadding="0" cellspacing="0" border="1">
  <thead>
    <th>学校名称</th>
    <th>城市</th>
    <th>学生人数</th>
  </thead>
  <tr>
    <td><div datafld="name"></div></td>
    <td><div datafld="city"></div></td>
    <td><div datafld="stu"></div></td>
  </tr>
  </table>
 </BODY>
</HTML>

posted @ 2008-05-16 12:52 qianbao 阅读(5) | 评论 (0) | 编辑