protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["BackUrl"] = Request.UrlReferrer.ToString();
}
}
/// <summary>
/// ·µ»Ø°´Å¥µã»÷ʼþ
/// </summary>
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect(ViewState["BackUrl"].ToString());
}
ÁíÒ»ÖÖ·½·¨
ÔÚC# Web³ÌÐòÖУ¬ÈçΪҳÃ水ťд·µ»ØÉÏÒ»Ò³´úÂë
this.RegisterClientScriptBlock("E", "<script language=javascript>history.go(-2);</script>");
ÆäÖУ¬history.go(-2)£¬ÒªÐ´Îª-2£¬ÒòÔÚ°´Å¥Ê¼þ´¥·¢Ç°£¬ÒÑË¢ÐÂÒ»´ÎÒ³Ã棬ËùÒÔÓ¦ÊÇ-2¡£
Response.Write("<script language=javascript>history.go(-2);</script>");
´Ë´¦Ò²ÒªÐ´Îª“-2”¡£¸úÖ±½Óд½Å±¾µÄÓÐËù²»Í¬¡£ ......
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["BackUrl"] = Request.UrlReferrer.ToString();
}
}
/// <summary>
/// ·µ»Ø°´Å¥µã»÷ʼþ
/// </summary>
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect(ViewState["BackUrl"].ToString());
}
ÁíÒ»ÖÖ·½·¨
ÔÚC# Web³ÌÐòÖУ¬ÈçΪҳÃ水ťд·µ»ØÉÏÒ»Ò³´úÂë
this.RegisterClientScriptBlock("E", "<script language=javascript>history.go(-2);</script>");
ÆäÖУ¬history.go(-2)£¬ÒªÐ´Îª-2£¬ÒòÔÚ°´Å¥Ê¼þ´¥·¢Ç°£¬ÒÑË¢ÐÂÒ»´ÎÒ³Ã棬ËùÒÔÓ¦ÊÇ-2¡£
Response.Write("<script language=javascript>history.go(-2);</script>");
´Ë´¦Ò²ÒªÐ´Îª“-2”¡£¸úÖ±½Óд½Å±¾µÄÓÐËù²»Í¬¡£ ......
·¢ËͶËÒÔ163ΪÀý
Ò»¡¢asp.net°æ using System.Web.Mail; //ÃüÃû¿Õ¼äÒýÓÃ
c#
MailMessage mail = new MailMessage();
mail.To = "shadow103@qq.com"; //½ÓÊÜÈ˵ÄÓÊÏä
mail.from = "xxx@163.com"; //Äã×Ô¼ºµÄÓÊÏä(×¢ÒâqqÓÊÏä²»ÐÐ)
mail.Subject = "ÄãºÃ˧¸ç"; //ÓÊÏä±êÌâ
mail.Body = "ÕýÎÄ";
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusing","2")
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); //stmpÑéÖ¤
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", ÄãÓÊÏäÕʺÅ");
mail.Fields.Add("h ......
·¢ËͶËÒÔ163ΪÀý
Ò»¡¢asp.net°æ using System.Web.Mail; //ÃüÃû¿Õ¼äÒýÓÃ
c#
MailMessage mail = new MailMessage();
mail.To = "shadow103@qq.com"; //½ÓÊÜÈ˵ÄÓÊÏä
mail.from = "xxx@163.com"; //Äã×Ô¼ºµÄÓÊÏä(×¢ÒâqqÓÊÏä²»ÐÐ)
mail.Subject = "ÄãºÃ˧¸ç"; //ÓÊÏä±êÌâ
mail.Body = "ÕýÎÄ";
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusing","2")
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); //stmpÑéÖ¤
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", ÄãÓÊÏäÕʺÅ");
mail.Fields.Add("h ......
·¢ËͶËÒÔ163ΪÀý
Ò»¡¢asp.net°æ using System.Web.Mail; //ÃüÃû¿Õ¼äÒýÓÃ
c#
MailMessage mail = new MailMessage();
mail.To = "shadow103@qq.com"; //½ÓÊÜÈ˵ÄÓÊÏä
mail.from = "xxx@163.com"; //Äã×Ô¼ºµÄÓÊÏä(×¢ÒâqqÓÊÏä²»ÐÐ)
mail.Subject = "ÄãºÃ˧¸ç"; //ÓÊÏä±êÌâ
mail.Body = "ÕýÎÄ";
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusing","2")
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); //stmpÑéÖ¤
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", ÄãÓÊÏäÕʺÅ");
mail.Fields.Add("h ......
ÒòΪ¸Õ¸Õ½Ó´¥C#ÓïÑÔ²»¾Ã,ÓÚÊÇÎÒ°Ñ¿ØÖÆ̨¸øÈÓÁË,ÒòΪÎÒÌÖÑá¿ØÖÆ̨!
¶øÊÂʵÉÏÎÒÖ»¶ÔWinForm¼¼Êõ¸ÐÐËȤ,µ«ÊÂʵÉϵ½ÏÖÔÚÎÒ·¢ÏÖASP.Net C#µÄWeb¼¼ÊõÊÇÈÕÏÔÖØÒªÆðÀ´!
ÓÚÊÇ¿ªÊ¼½Ó´¥,¸Õ¸ÕÆð²½ÓÚËùÖª,ÓÈÆäÊÇһЩ×î¼òµ¥µÄ¶«Î÷,µ½ÍøÉÏËÑË÷Á˺ܾÃ,²»ÊÇÌ«ÂÒ¾ÍÊÇ˵²»Çå³þ!
¾Ù¸öÀý×ÓÀ´Ëµ,¾Í˵SessionºÃÁË,²»ÖªµÀÍøÉϵÄÄÇЩ¼Ò»ïµ½µ×ÔÚ½²Ê²Ã´?
»òÐíÊÇÎÒÌ«±¿°É!ÕæÊÇÎÞ·¨Àí½âËûÃǵĶ«¶«!
ÓÚÊÇÎÒ»¹ÊǾö¶¨×Ô¼ºÑо¿Ò»ÏÂ,½ñÌìÏÂÎ绨ÁËÒ»µãʱ¼ä,Êܵ½³É¹ûÈçÏÂ:
(1)Load.aspx.csÎļþÖÐ:
public class MYuser
{
public MYuser()
{
}
private string name;
public string Name
{
get
& ......
ÒòΪ¸Õ¸Õ½Ó´¥C#ÓïÑÔ²»¾Ã,ÓÚÊÇÎÒ°Ñ¿ØÖÆ̨¸øÈÓÁË,ÒòΪÎÒÌÖÑá¿ØÖÆ̨!
¶øÊÂʵÉÏÎÒÖ»¶ÔWinForm¼¼Êõ¸ÐÐËȤ,µ«ÊÂʵÉϵ½ÏÖÔÚÎÒ·¢ÏÖASP.Net C#µÄWeb¼¼ÊõÊÇÈÕÏÔÖØÒªÆðÀ´!
ÓÚÊÇ¿ªÊ¼½Ó´¥,¸Õ¸ÕÆð²½ÓÚËùÖª,ÓÈÆäÊÇһЩ×î¼òµ¥µÄ¶«Î÷,µ½ÍøÉÏËÑË÷Á˺ܾÃ,²»ÊÇÌ«ÂÒ¾ÍÊÇ˵²»Çå³þ!
¾Ù¸öÀý×ÓÀ´Ëµ,¾Í˵SessionºÃÁË,²»ÖªµÀÍøÉϵÄÄÇЩ¼Ò»ïµ½µ×ÔÚ½²Ê²Ã´?
»òÐíÊÇÎÒÌ«±¿°É!ÕæÊÇÎÞ·¨Àí½âËûÃǵĶ«¶«!
ÓÚÊÇÎÒ»¹ÊǾö¶¨×Ô¼ºÑо¿Ò»ÏÂ,½ñÌìÏÂÎ绨ÁËÒ»µãʱ¼ä,Êܵ½³É¹ûÈçÏÂ:
(1)Load.aspx.csÎļþÖÐ:
public class MYuser
{
public MYuser()
{
}
private string name;
public string Name
{
get
& ......
½ñÌìÔÚÓÃDataListµÄÄ£°åÁеÄʱºòÏ°¹ßÐÔµØÏñÔÚ03ÖÐÄÇÑùÈ¥¸øÄ£°åÁеİó¶¨×ֶμӸö´¦Àíº¯Êý£º
< asp:Label ID = " Label1 " runat = " server " Text = ' <%#ConvertState(Bind("Status"))%> ' ></ asp:Label >
¿ÉÊǾ¹È»³ö´í£ºµ±Ç°ÉÏÏÂÎÄÖв»´æÔÚÃû³Æ“Bind” ¡£
ºóÀ´ÓÖÏ°¹ßÐÔµØÏë°Ñ°ó¶¨×ֶ奶ÀÄóöÀ´ÏÔʾ£¬ÓÖÌáʾ£º¾¯¸æ 2 Éè¼ÆÆ÷ÎļþÉú³Éʧ°Ü: ±ØÐ뽫¶Ô Bind µÄµ÷Ó÷ÖÅä¸øÄ£°åÖеĿؼþµÄÊôÐÔ¡£ ¸Ð¾õºÜÓôÃÆ£¬ÓÚÊÇ°ÑBind»»³ÉEvalÒ»µãÎÊÌⶼûÁË¡£
< asp:Label ID = " Label1 " runat = " server " Text = ' <%#ConvertState(Eval("Status"))%> ' ></ asp:Label >
ÉÏÍø²éһϲŷ¢ÏÖ¶þÕßµÄÇø±ð£º
eval()·½·¨ÔÚÔËÐÐʱʹÓ÷´ÉäÖ´ÐкóÆڰ󶨼ÆË㣬Òò´ËÓë±ê×¼µÄASP.NETÊý¾Ý°ó¶¨·½·¨bindÏà±È£¬»áµ¼ÖÂÐÔÄÜÃ÷ÏÔϽµ¡£ËüÒ»°ãÓÃÔÚ°ó¶¨Ê±ÐèÒª¸ñʽ»¯×Ö·û´®µÄÇé¿öÏ¡£¶àÊýÇé¿ö¾¡Á¿ÉÙÓô˷½·¨
Eval ·½·¨ÊǾ²Ì¬£¨Ö»¶Á£©·½·¨£¬¸Ã·½·¨²ÉÓÃÊý¾Ý×ֶεÄÖµ×÷Ϊ²ÎÊý²¢½«Æä×÷Ϊ×Ö·û´®·µ»Ø¡£Bind ·½·¨Ö§³Ö¶Á/д¹¦ÄÜ£¬¿ÉÒÔ¼ìË÷Êý¾Ý°ó¶¨¿Ø¼ ......
½ñÌìÔÚÓÃDataListµÄÄ£°åÁеÄʱºòÏ°¹ßÐÔµØÏñÔÚ03ÖÐÄÇÑùÈ¥¸øÄ£°åÁеİó¶¨×ֶμӸö´¦Àíº¯Êý£º
< asp:Label ID = " Label1 " runat = " server " Text = ' <%#ConvertState(Bind("Status"))%> ' ></ asp:Label >
¿ÉÊǾ¹È»³ö´í£ºµ±Ç°ÉÏÏÂÎÄÖв»´æÔÚÃû³Æ“Bind” ¡£
ºóÀ´ÓÖÏ°¹ßÐÔµØÏë°Ñ°ó¶¨×ֶ奶ÀÄóöÀ´ÏÔʾ£¬ÓÖÌáʾ£º¾¯¸æ 2 Éè¼ÆÆ÷ÎļþÉú³Éʧ°Ü: ±ØÐ뽫¶Ô Bind µÄµ÷Ó÷ÖÅä¸øÄ£°åÖеĿؼþµÄÊôÐÔ¡£ ¸Ð¾õºÜÓôÃÆ£¬ÓÚÊÇ°ÑBind»»³ÉEvalÒ»µãÎÊÌⶼûÁË¡£
< asp:Label ID = " Label1 " runat = " server " Text = ' <%#ConvertState(Eval("Status"))%> ' ></ asp:Label >
ÉÏÍø²éһϲŷ¢ÏÖ¶þÕßµÄÇø±ð£º
eval()·½·¨ÔÚÔËÐÐʱʹÓ÷´ÉäÖ´ÐкóÆڰ󶨼ÆË㣬Òò´ËÓë±ê×¼µÄASP.NETÊý¾Ý°ó¶¨·½·¨bindÏà±È£¬»áµ¼ÖÂÐÔÄÜÃ÷ÏÔϽµ¡£ËüÒ»°ãÓÃÔÚ°ó¶¨Ê±ÐèÒª¸ñʽ»¯×Ö·û´®µÄÇé¿öÏ¡£¶àÊýÇé¿ö¾¡Á¿ÉÙÓô˷½·¨
Eval ·½·¨ÊǾ²Ì¬£¨Ö»¶Á£©·½·¨£¬¸Ã·½·¨²ÉÓÃÊý¾Ý×ֶεÄÖµ×÷Ϊ²ÎÊý²¢½«Æä×÷Ϊ×Ö·û´®·µ»Ø¡£Bind ·½·¨Ö§³Ö¶Á/д¹¦ÄÜ£¬¿ÉÒÔ¼ìË÷Êý¾Ý°ó¶¨¿Ø¼ ......
c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
1£ºIntegrated Security²ÎÊý
µ±ÉèÖÃIntegrated SecurityΪ True µÄʱºò£¬Á¬½ÓÓï¾äÇ°ÃæµÄ UserID, PW ÊDz»Æð×÷Óõģ¬¼´²ÉÓÃwindowsÉí·ÝÑé֤ģʽ¡£
Ö»ÓÐÉèÖÃΪ False »òÊ¡ÂÔ¸ÃÏîµÄʱºò£¬²Å°´ÕÕ UserID, PW À´Á¬½Ó¡£
Integrated Security »¹¿ÉÒÔÉèÖÃΪ£ºsspi £¬Ï൱ÓÚ True£¬½¨ÒéÓÃÕâ¸ö´úÌæ True¡£
Data Source=myServerAddress; ......
c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
1£ºIntegrated Security²ÎÊý
µ±ÉèÖÃIntegrated SecurityΪ True µÄʱºò£¬Á¬½ÓÓï¾äÇ°ÃæµÄ UserID, PW ÊDz»Æð×÷Óõģ¬¼´²ÉÓÃwindowsÉí·ÝÑé֤ģʽ¡£
Ö»ÓÐÉèÖÃΪ False »òÊ¡ÂÔ¸ÃÏîµÄʱºò£¬²Å°´ÕÕ UserID, PW À´Á¬½Ó¡£
Integrated Security »¹¿ÉÒÔÉèÖÃΪ£ºsspi £¬Ï൱ÓÚ True£¬½¨ÒéÓÃÕâ¸ö´úÌæ True¡£
Data Source=myServerAddress; ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ”Óû§£¬°ÑÄ㽨µÄÓû§Ìí¼Ó½øÈ¥¡£
¹Ø¼üµØ·½£¬²é¿´“·þÎñÆ÷ ÊôÐÔ”ÔÚ “°²È«ÐԔѡÉÏ “SQL Server ºÍ Windows Éí·ÝÑé֤ģʽ”µã “È·¶¨”ϵͳ»áÌáʾÄãÖØÐÂÆô¶¯SQL Server Äã“Í£Ö¹”ÖØÆôһϾÍÅäºÃÁË¡£
½Ó×Å¿´C#Á¬½ÓSQL Server2005µÄ´úÂëÓï¾ä£º
strcon = strcon + @"Data Source=" + strcons[0];
strcon = strcon + "," + strcons[2] + ";";
strcon = strcon + "Network Library=" + strcons[1] + ";";
strcon = strcon + "Initial Catalog=" + strcons[3] + ";";
strcon = strcon + "User ID=" + strcons[4] + ";";
strcon = strcon + "Password=" + strcons[5] + ";";
strcon = strcon + "Persist Security Info=True";
.Õ¾
strcons[0] ·þÎñÆ÷Ãû³Æ£¬Ò»°ãΪ»úÆ÷µÄIP
strcons[1 ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ”Óû§£¬°ÑÄ㽨µÄÓû§Ìí¼Ó½øÈ¥¡£
¹Ø¼üµØ·½£¬²é¿´“·þÎñÆ÷ ÊôÐÔ”ÔÚ “°²È«ÐԔѡÉÏ “SQL Server ºÍ Windows Éí·ÝÑé֤ģʽ”µã “È·¶¨”ϵͳ»áÌáʾÄãÖØÐÂÆô¶¯SQL Server Äã“Í£Ö¹”ÖØÆôһϾÍÅäºÃÁË¡£
½Ó×Å¿´C#Á¬½ÓSQL Server2005µÄ´úÂëÓï¾ä£º
strcon = strcon + @"Data Source=" + strcons[0];
strcon = strcon + "," + strcons[2] + ";";
strcon = strcon + "Network Library=" + strcons[1] + ";";
strcon = strcon + "Initial Catalog=" + strcons[3] + ";";
strcon = strcon + "User ID=" + strcons[4] + ";";
strcon = strcon + "Password=" + strcons[5] + ";";
strcon = strcon + "Persist Security Info=True";
.Õ¾
strcons[0] ·þÎñÆ÷Ãû³Æ£¬Ò»°ãΪ»úÆ÷µÄIP
strcons[1 ......