MySQL£¨asp.net£© ÊÂÎñ
try
{
string _conStr = "Driver={MySQL ODBC 3.51
Driver};server=localhost;database=test;uid=test;password=1;option=3";
OdbcConnection _odbcCon = new OdbcConnection(_conStr);
_odbcCon.Open();
OdbcTransaction trans = _odbcCon.BeginTransaction
(IsolationLevel.ReadCommitted);
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = trans.Connection;
cmd.Transaction = trans;
string _sqlStr = "";
try
{
_sqlStr = "update test ....."
cmd.CommandText = _sqlStr;
cmd.ExecuteNonQuery();
_sqlStr = "";
}
catch
{
&n
Ïà¹ØÎĵµ£º
ÏÂÔØÒ³Ãæ£º
<a href="download.ashx?url=<%=Server.UrlEncode("˵Ã÷.txt")%>">ÏÂÔØ</a>
------------------------------------------------------------------------------
download.ashx
<%@ WebHandler Language="C#" Class="download" %>
using System;
using System.Web;
public ......
1.µ¯³ö¶Ô»°¿ò.
a. µ¯³ö¶Ô»°¿ò£º
C# codeClientScript.RegisterStartupScript(this.GetType(), "",
"<script>window.alert('¸Ã»áԱûÓÐÌá½»ÉêÇë,ÇëÖØÐÂÌá½»£¡')</script>");
b.תÏòÖ¸¶¨Ò³Ãæ
C# code Response.Write("
<script>window.location='http://www. ......
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶¶¼ÓÐÄÄÐ©ÄØ£¿¾ßÌåÓÖÓÐʲôÄÚÈÝÄØ£¿ÈÃÎÒÃÇ¿ªÊ¼°É£º
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶1£®°´Å¥IDÃüÃû£º
btn+°´Å¥²Ù×÷¹¦ÄÜ£¨ÈçbtnSave£©
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶2£®ÆäËü¿Ø¼þ£º
I£®ÓëÊý¾Ý²Ù×÷Ïà¹Ø£ºÆäID<.SPAN>ΪÏàÓ¦µÄ×Ö¶ÎÃû³Æ£¬Èç¹ûÓжà¸ö¿Ø¼þ¶ÔÓ¦Ò»¸ö×ֶΣ¬Ôò°´ÒÔϹ淶ÃüÃû£º
×Ö¶ÎÃû+&rdqu ......
½ñÌì´î½¨mysqlÊý¾Ý¿â,Á¬½ÓÁ˰ëÌì,¶¼Ìáʾ10061´íÎó,ÒÔΪÃÜÂë³öÁËÎÊÌâÊÔÁ˰ëÌì,ѹ¸ùÁ¬·þÎñ¶¼Á¬½Ó²»ÉÏ,æ»îÁ˰ë¸ö¶àСʱ,²Å·¢ÏÖÊÇϵͳ²¹¶¡´òÁËÖ®ºó³öÏÖµÄÎÊÌâ(kb967723)
ÓÚÊÇÍøÉÏÕÒÁËÒ»ÏÂ×ÊÁÏ
×î½üÒ»¸ö¿Í»§·þÎñÆ÷µÄMYSQLƵ·±ÌáʾÁ¬½Ó²»ÉÏ£¬ÐÞ¸ÄÁËMYSQLµÄ×î´óÁ¬½ÓÊý»¹ÊÇÕâÑù£¬ÓÚÊÇ¿ªÊ¼ÎÊÍòÄܵÄËÑË÷ÒýÇæ´óÈË£¡ÖÕÓÚÔÚ΢ÈíÕÒµ½ÁË ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......