ÔÚasp.net ÖÐmysql²éѯÓï¾ä???
public static UserTest GetUserByLoginName(string name)
{
string sql = "SELECT * from nt_user WHERE name = @name";
try
{
SqlDataReader reader = DBconn.GetReader(sql, new SqlParameter("@name", name));
if (reader.Read())
{
UserTest user = new UserTest();
user.Id = (int)reader["id"];
user.Name = (string)reader["name"];
user.Password= (string)reader["password"];
reader.Close();
return user;
}
else
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.Design
Imports System.Web.UI.WebControls
Namespace CBDAspNet.WebControls.HTML
''' <summary>
'' ......
asp.net°ÙÍò¼¶Êý¾Ý·ÖÒ³ÓÃʲô·½·¨µÄ£¬ÊÔ¹ýaspnetpager¿ØÄ꣬³¬¹ýÊ®Íò¶¼ÂýµÃ²»ÐУ¬ºǫ́Êý¾Ý¿âÊÇsqlserver2000£¬²»ÏëÓý¨Á¢´¢´æ¹ý³ÌµÄ·½Ê½£¬Çë´ó¼ÒÖ¸µãÒ»¶þ.
²»ÏëÓý¨Á¢´¢´æ¹ý³ÌµÄ·½Ê½£¿
ÎÞÓïÁË
ÄǾÍ×Ô¼ºÆ´SQLÁË
......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ÉÊÇÎÒÕÒ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......