Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SqlÓï¾ä³ö´í£¬ - Web ¿ª·¢ / ASP

ÔËÐк󱨴íÎóÈçÏ£º
´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'Êýѧ + 4where ÐÕÃû='Íõ¾²'' ÖС£
/edit.asp, µÚ 13 ÐÐ

[code=VB][/code]
<html><body>
<%
if session("name")="" then
response.redirect("login.asp")
end if
qkname=request("qkname")
number=request("number")
if qkname<>"" and number<>"" then
set conn=server.CreateObject("ADODB.Connection")
conn.open("driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("student.mdb"))
set rs=Server.CreateObject("ADODB.Recordset")
sql="update info set Êýѧ = Êýѧ + " & number & "where ÐÕÃû='" & qkname & "'"
rs.open sql, conn, 2, 2
conn.close()
end if
'response.write(session("name"))

%>


<form action="edit.asp"method=post>
ÐÕÃû£º<input type="text"name="qkname"size="20">ȱ¿Î½ÚÊý£º<input type="text"name="number"size="20"><p>
<input type="submit"value="Ìá½»">
</form>
</body></html>
sql="update info set Êýѧ = Êýѧ + " &


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ