asp.net µ÷ÓÃmysql´æ´¢¹ý³ÌÈçºÎ»ñÈ¡·µ»Ø¼Ç¼Êý
#region µ÷Óòéѯ´æ´¢¹ý³Ì,ÓÃExecuteNonQuery·½·¨,·µ»ØÓ°ÏìÐÐÊý
public static List <T> SpSelectDataSet <T>(PopulateDelegate <T> pd, string sqName, MySqlParameter[] param, out int RecordCount)
{
using (MySqlConnection cnn = new MySqlConnection(ConnectionString))
{
List <T> lst = new List <T>();
RecordCount = 0;
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = cnn;
cmd.CommandText = sqName;
cmd.CommandTimeout = 120;
cmd.CommandType = CommandType.StoredProcedure;
foreach (MySqlParameter p in param)
{
cmd.Parameters.Add(p);
}
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......
VB.NET code:
'Global.asax
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
'ÔÚÓ¦ÓóÌÐòÆô¶¯Ê±ÔËÐеĴúÂë
Dim RequestUrl As String = HttpContext.Current.Requ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......