2008年4月24日
#
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>