asp.net ÏÂweb.configÖÐÅäÖÃÊý¾Ý¿âÁ¬½Ó
1¡¢Web.config ¿ÉÒÔ²ÉÓÃдÁ¬½ÓÌõ¼þ »ò ¸½¼Ó ×.mdf Îļþ
<connectionStrings>
<add name="Sales"
providerName="System.Data.SqlClient"
connectionString= "server=myserver;database=Products;uid=<user name>;pwd=<secure password>" />
<add name="LocalSqlServer"
providerName="System.Data.SqlClient"
connectionString="server=.;database=NorthWind;Integrated Security=SSPI" />
<add name="Sql2005Express"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|NorthWnd.mdf;Integrated Security=True;User Instance=true"
providerName="System.Data.SqlClient"/>
</connectionStrings>
2¡¢×.cs Á¬½ÓÊý¾Ý¿â ´úÂë
string connectionStr = System.Configuration.ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString();
3¡¢MSDN - Ë÷Òý - connectionStrings ¿ÉÒԲ鿴web.configÀïÊý¾Ý¿âÁ¬½Ó»ò¸½¼ÓÉèÖá£
ms-help://MS.MSDNQTR.v90.chs/dv_aspnetgenref/html/b6ffbb2e-a4d1-410e-8f7e-9755e92c65de.htm
Ïà¹ØÎĵµ£º
ASP.NETÒ³Ãæ¼äÖµ´«µÝµÄ¼¸ÖÖ·½·¨
ÒýÓÃÒ³£ºhttp://developer.51cto.com/art/200909/149626.htm 2009-09-04 11:20 ØýÃû Öйú½Ì³ÌÔÚÏß
ÕâÀォ½²ÊöÁËʹÓò»Í¬µÄ·½·¨ÊµÏÖÁËASP.NETÒ³Ãæ¼äÖµ´«µÝµÄ·½·¨£¬ÆäÖеÄÈýÖÖ·½·¨ÊÇ£ºQueryString,SessionºÍServer.Transfer¡£
ASP.NETÒ³Ãæ¼äÖµ´«µÝµÄ·½·¨Ö÷Ò ......
ASP.Net Êý¾Ý¿Ø¼þÖ®GridView ¿Ø¼þ£º
GridView ¿Ø¼þÒÔ±íµÄÐÎʽÏÔʾÊý¾Ý£¬²¢Ìṩ¶ÔÁнøÐÐÅÅÐò¡¢·ÖÒ³¡¢·ÔÄÊý¾ÝÒÔ¼°±à¼»òɾ³ýµ¥¸ö¼Ç¼µÄ¹¦ÄÜ¡£
×¢Ò⣺GridView ¿Ø¼þÊÇ ASP.NET µÄÔçÆÚ°æ±¾ÖÐÌṩµÄ DataGrid ¿Ø¼þµÄºó¼Ì¿Ø¼þ¡£³ýÁËÌí¼ÓÀûÓÃÊý¾ÝÔ´¿Ø¼þ¹¦ÄܵÄй¦ÄÜ£¬GridView ¿ ......
//µÃµ½Êý¾ÝΪ¿âÁ¬½Ó
SqlConnection con=new SqlConnection("Êý¾Ý¿âÁ¬½Ó×Ö·û´®");
//Óô洢¹ý³ÌÃû³ÆºÍÊý¾Ý¿âÁ¬½Ó´´½¨SqlCommand ¶ÔÏó
SqlCommand command = new SqlCommand("´æ´¢¹ý³ÌÃû³Æ",con);
//´ò¿ªÁ¬½Ó
con.Open();
//¶ÔÊý¾Ý¿â½øÐÐÏàÓ¦µÄ²Ù×÷
...................................
........................... ......
1.Asp.NetÖм¸ÖÖÏàËÆµÄ±ê¼Ç·ûºÅ: < %=...%>< %#... %>< % %>< %@ %>½âÊͼ°Ó÷¨
´ð: < %#... %>: ÊÇÔڰ󶨿ؼþDataBind()·½·¨Ö´ÐÐʱ±»Ö´ÐУ¬ÓÃÓÚÊý¾Ý°ó¶¨
Èç: < %# Container.DataItem("tit") %>
< %= %>: ÔÚ³ÌÐòÖ´ÐÐʱ±»µ÷Ó㬿ÉÒÔÏÔʾºǫ́±äÁ¿Öµ
Èç:
*.aspxÖУº < %= ......
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace op_db
{
/**//// <summary>
/// רÃÅÓÃÀ´´¦ÀíÓëÊý¾Ý¿âµÄ²Ù×÷
/// </summary>
public class&n ......