2008年3月13日
#
insert into tablename(name,s) select name,5 from test where s=1
没想到还挺有用的。。以前从没用过。。
不一定要ArrayList！！！！！
返回DataReader有时可以减轻很多工作量
Ext太疯狂了..无语,从此Myblogs又要多一个分类了..
Ext..哈哈
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();
}
}
if (this.FileUpload1.HasFile)
{
// FileInfo file = new FileInfo(this.FileUpload1.FileName);
this.FileUpload1.PostedFile.SaveAs(Server.MapPath(this.FileUpload1.FileName));
}
//构造函数
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);
}
}
}
放弃了一2000+/月
又放弃了3000+/月
却选择了1000+/月
我对了?我错了?
<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>
<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>
摘要: 小的细节问题,总是会被忽略掉,哎
阅读全文
工作已经换了,但是心情还是提不起来.
不知道是什么原因,总是烦..
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);
也许以后会用上..
DELIMITER $$;
DROP PROCEDURE IF EXISTS `myweb`.`test`$$
CREATE PROCEDURE `test`()
BEGIN
declare _done int default 0;
declare _id int default 0;
declare prod int default (select id from luck limit 5,1);
declare cur_mid cursor for
select m.id from member;
declare continue handler for sqlstate '02000' set _done = 1;
open cur_mid;
repeat
fetch cur_mid into _id; #当然也可以有多个
if not _done then
#处理。。可以使用 _id ,
end if;
until _done end repeat;
close cur_mid;
END$$
DELIMITER ;$$
摘要: asp.net实现发送email
阅读全文