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
Ïà¹ØÎĵµ£º
ÅäÖÃÎļþ¿ÉÓÃÀ´´æ·ÅһЩ¶à´ÎÓõ½µÄ³£Á¿Êý¾Ý£¬ÈçÁ¬½Ó´®£º
<appSettings>
<add key="connStr1" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="connStr2" value="App_Data\test.mdb"/>
</appSettings>
Õâ¸öÅäÖÃÊý¾Ý¿âÁ¬½Ó´®
ʹÓÃʾÀý£º
public class DBCo ......
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 ......
µÇ½ÒÔºóÔËÐÐÒÔÏÂÃüÁ¸øÓèÔ¶³Ì·ÃÎʿͻ§¶ËȨÏÞ..
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
remote±íʾÓû§Ãû.
'172.16.21.39' Ô¶³ÌipµØÖ·
password±íʾԶ³ÌµÇ½ÃÜÂë.
ĬÈÏ×´¿öÏ£¬³öÓÚ°²È«¿¼ÂÇ£¬mysqlÊý¾Ý¿âÆÁ±ÎÁËÔ¶³Ì·ÃÎʹ¦ÄÜ¡£ È»¶øÔÚÐí¶à×´¿öÏ£¬ÄãÐèÒªÔÚ¼Ò
»òÕß´Óweb³ÌÐòÈ¥·ÃÎÊ ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......