qianbao

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

2008年3月29日 #

insert ...into...

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

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

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

不一定要ArrayList！！！！！

不一定要ArrayList！！！！！

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

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

Ext太疯狂了



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

Ext..哈哈

posted @ 2008-06-04 23:15 qianbao 阅读(8) | 评论 (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 阅读(10) | 评论 (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 阅读(7) | 评论 (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) | 编辑

AJAX基础模型

<script type="text/javascript">
        var xmlHttp;
        function createXMLHttpRequest()
        {
            if(window.ActiveXObject)
            {
                xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
            }
            else if(window.XMLHttpRequest)
            {
                xmlHttp = new XMLHttpRequest();
            }
        }
        function startRequest()
        {
            createXMLHttpRequest();
            xmlHttp.onreadystatechange = handleStateChange;
            xmlHttp.open("GET","person.xml",true);
            xmlHttp.send(null);
        }
        function handleStateChange()
        {
            if(xmlHttp.readyState==4)
            {
                if(xmlHttp.status==200)
                {
                    alert("来自服务器的响应："+xmlHttp.responseText);
                }
                else
                {
                    alert("aaaa");
                }
            }
        }
    </script>

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

DOS命令批量修改文件后缀名

ren d:\word\*.txt *.htm

posted @ 2008-05-06 12:14 qianbao 阅读(81) | 评论 (0) | 编辑

javascript加载xml到表格内，并实现排序，分页，列拖动，筛选数据等

     摘要:   阅读全文

posted @ 2008-04-24 09:07 qianbao 阅读(96) | 评论 (0) | 编辑

C#调用sqlserver存储过程.总是会忽略掉一些小的细节

     摘要: 小的细节问题,总是会被忽略掉,哎  阅读全文

posted @ 2008-04-19 15:43 qianbao 阅读(46) | 评论 (0) | 编辑

整天昏昏沉沉

    工作已经换了,但是心情还是提不起来.

不知道是什么原因,总是烦..

posted @ 2008-04-14 13:21 qianbao 阅读(8) | 评论 (0) | 编辑

java定时执行程序

Timer t = new Timer();
        t.schedule(new java.util.TimerTask() {
            private int count = 0;

            public void run() {
                count++;
                System.out.println("执行成功-" + count);

                if (count > 40) {
                    this.cancel();
                }
            }
        }, 0, 1000);


也许以后会用上..

posted @ 2008-03-29 21:13 qianbao 阅读(123) | 评论 (0) | 编辑