ÎÒ°²×°SQL SERVER2008µÄʱºòÑ¡ÔñWINDOWSÉí·ÝÑéÖ¤Á¬½ÓµÄ£¬ÎÒ²»ÖªµÀÔõôдÁ¬½Ó¡£¡£¡£
»¹ÓÐÎÒÏë¸Ä³ÉSQL SERVERÉí·ÝÑéÖ¤Ôõô¸Ä£¿£¿
лл´ó¼ÒÁË£¡
XML code:
<configuration>
<appSettings>
<add key="ConnectionString" value="Server=·þÎñÆ÷IPµØÖ· ;Initial Catalog=Êý¾Ý¿âÃû³Æ;Integrated Security=True" />
</appSettings>
</configuration>
C# code:
string str = ConfigurationManager.AppSettings["sqlconnection1"];
<configuration>
<appSettings>
<add key="ConnectionString" value="Server=·þÎñÆ÷IPµØÖ· ;Initial Catalog=Êý¾Ý¿âÃû³Æ;Integrated Security=True" />
</appSettings>
</configuration>
¸ü¸ÄµÇ½ÑéÖ¤·½Ê½:
µÇ½SQLºó,Êó±êÓÒ¼üÊý¾Ý¿â,ÊôÐÔ,È»ºóÑ¡Ôñ »ìºÏÑéÖ¤ È·¶¨ÖØÐÂÆô¶¯SQL·þÎñ
ÎÒ¶¼ÊÇÔÚWeb.configÀïÅäÖÃÕâÑùµÄÒ»¶Î»°Á¬½ÓµÄ¡£
</sectionGroup>
</configSections>
<appSettings>
<add key="SQLConnectingString" value="Data Source =.\SQLEXPRESS;database =WaterGrassDB;Integrated Security=SSPI;"/>
</appSettings>
Ïà¹ØÎÊ´ð£º
ǰ¶Îʱ¼äÅöµ½Ò»µÀÃæÊÔÌâÈçÏ£º
test.aspxÒ³ÃæÓÐÈçÏ´úÂ룺
Response.Write(Test.GetDate());
TestÀàÈçÏ£º
public class Test
{
static string dt="";
public static s ......
ÎÒÔÚ Page_Load ÀïдÁË
if(!IsPostBack){
GridView1.DataSource=GroupManager.GetGroups();//GetGroups ·µ»ØµÄÊÇ IList<Group>
GridView1.DataBind();
}
¿ÉÎÒÔÚ Submit_Click Àïд´ú ......
ÎÒÓг§¼Ò×öµÄASPµÄ¼à¿ØÂ¼Ïñ£¨DVR£©µÄ¾ÖÓòÍø²¥·ÅµÄÔ´³ÌÐòÓë¿Ø¼þ£¬ÏëÒªÓÃASP.net×öÒ»¸öÊÓÆµ»Ø·ÅµÄ³ÌÐò£¨ÀûÓÃËûµÄ¿Ø¼þ£©µ«²»ÖªÈçÏÂÈ¥×ö£¬Íû¸÷λָµã¡£
ÏȸãÇå³þËûÃǵĿؼþÊÇÔõôÓõÄ,
È»ºó¾ÍÖ±½ÓÓúÃÁË.
²»¹ý,Èç ......
ÓÃDWдµÄaspxºÍvs C#дµÄÍøÕ¾ÏµÍ³(Ö÷ÒªÒ³ÃæÎļþÒ²ÊÇaspxµÄÎļþ)ÓÐÊ²Ã´Çø±ð,VSдµÄÍøÕ¾·¢²¼ºó,ËùÓеĴúÂ벿·ÖºÏ³ÉÒ»¸öDLLÎļþ,¶øDW¾ÍûÓа취,ÕâÁ½¸ö¹¤¾ßд³öÀ´µÄÍøÕ¾Í¬ÑùÊÇaspxµÄÎļþ,µ«Çø±ðºÜ´ó°¡.
°ïÄã¶¥ÏÂ~£¬Çó ......
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......