asp.netÖÐÔõÑùµ÷Óô洢¹ý³ÌºÍ´æ´¢¹ý³ÌµÄд·¨
----´´½¨Ò»¸öÖ»ÓÐÊäÈë²ÎÊýµÄ´æ´¢¹ý³Ì
create procedure proc_user
@name varchar(20),
@Password varchar(100)
as
select * from loginuser
where name like @name
---´´½¨Ò»¸öÓÐÊäÈëºÍÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì
create procedure proc_usertext
@name varchar(20),
@blog varchar(100) output
as
select @blog = blog from loginuser where name = @name
---´´½¨Ò»¸öÓÐÊäÈëºÍ·µ»Ø²ÎÊýµÄ´æ´¢¹ý³Ì
create PROCEDURE returnval
@name varchar(100),
@blog varchar(100) output
AS
begin
select @blog = blog from loginuser where name = @name
if(@blog is null)
set @blog = ''Ä㻹ûÓÐÉêÇ벩¿Í''
return execute(@blog ) --Êý¾ÝÊýÐ͵Äת»»
end
ÔÚasp.netÖеĵ÷ÓÃ
protected void Page_Load(object sender, EventArgs e)
{
DataBind();
}
private void DataBind()
{
//Ö»´øÊäÈë²ÎÊýµÄ´æ´¢¹ý³ÌµÄд·¨¡£
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["strConnection"].ConnectionString);
SqlCommand cmd = new SqlCommand("proc_user", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", "l%");
cmd.Parameters.AddWithValue("@Password", "lcs9702");
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
DropDownList1.DataSource = dr;
DropDownList1.Data
Ïà¹ØÎĵµ£º
ÌõÐÎÂëÊÇÆù½ñΪֹ×á¢ÊµÓõÄÒ»ÖÖ×Ô¶¯Ê¶±ð¼¼Êõ¡£ÌõÐÎÂë¼¼Êõ¾ßÓÐÒÔϼ¸¸ö·½ÃæµÄÓŵã
¡¡¡¡A£®ÊäÈëËٶȿ죺Óë¼üÅÌÊäÈëÏà±È£¬ÌõÐÎÂëÊäÈëµÄËÙ¶ÈÊǼüÅÌÊäÈëµÄ5±¶£¬²¢ÇÒÄÜʵÏÖ“¼´Ê±Êý¾ÝÊäÈ딡£
¡¡¡¡B£®¿É¿¿ÐԸߣº¼üÅÌÊäÈëÊý¾Ý³ö´íÂÊΪÈý°Ù·ÖÖ®Ò»£¬ÀûÓùâѧ×Ö·ûʶ±ð¼¼Êõ³ö´íÂÊΪÍò·ÖÖ®Ò»£¬¶ø²ÉÓÃÌõÐÎÂë¼¼ÊõÎóÂëÂʵ ......
ÓйØÓÚURLµÄÖØÐ´£¬±¾ÎÄÒ²Ö»ÊÇÄÃÀ´Ö÷Òâ¡£Ïà¼ÌÓÐMSµÄ×é¼þ“URLRewriter”ºÍÔÚGlobal.asaxÀïµÄ“Application_BeginRequest()”±àÂ뷽ʽ£¬ÒÔ¼°IISÀïµÄISAPIÉèÖá£
ÄÈÁÐÏÂÀ´£¬ÊµÏÖ·½·¨Ò²¶¼ºÜ¼òµ¥¡£
·½·¨Ò»£ºMS×é¼þ
ÕâÀïÒ²²»ÓÃÏê½âÁË£¬Ïà¹ØÇë¿´£º
http://www.microsoft.com/china/msdn/library/webservic ......
MVC¿ò¼ÜͼÈçÏ£º
ÔÚÄã¾ö¶¨Ê¹ÓÃMVC¿ò¼Ü»òWeb Formsģʽ¿ª·¢Ö®Ç°£¬ÇëÈÏÕæºâÁ¿Ò»Ï¸÷×ÔµÄÓŵ㡣
»ùÓÚMVCµÄWebÓ¦ÓóÌÐòÓŵ㣺
ËüÄܺÜÈÝÒ׵ĹÜÀí¸´ÔÓµÄÓ¦ÓóÌÐò£¬½«Ëü·ÖΪmodel£¬viewºÍcontroller¡£
Ëü²»ÄÜʹÓÃview stateºÍ·þÎñÆ÷¿Ø¼þ£¬ÕâʹµÃMVC¿ò¼Ü¿ª·¢ÈËÔ±ÓµÓжÔÓ¦ÓóÌÐòÍêÈ«¿ØÖƵÄÄÜÁ¦¡£
ËüʹÓÃǰ¶Ë¿ØÖÆÆ÷ģʽ£¬Í¨¹ýµ¥Ò ......
ASP.NETÊý¾Ý¿âÁ¬½Ó×Ö·û´®µÄ¼ÓÃÜÓë½âÃÜ
ASP.NETÊý¾Ý¿âÁ¬½Ó×Ö·û´®µÄ¼ÓÃÜÓë½âÃÜ
ASP.NET web.configÖУ¬Êý¾Ý¿âÁ¬½Ó×Ö·û´®µÄ¼ÓÃÜÓë½âÃÜ¡£
¿ªÊ¼--->ÔËÐÐ,ÊäÈëcmd£¬½Ó×ÅÊäÈëÒÔÏÂÄÚÈÝ
¼ÓÃÜ£º
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -pef "connectionStrings" "ÄãµÄWebÏîĿ·¾¶"
¸´ÖÆ´úÂë ......
ÕâÁ½ÌìÊìϤ¹«Ë¾µÄÍøÕ¾Ç°Ì¨ºÍºǫ́µÄÊý¾Ý½á¹¹ºÍÒµÎñÂß¼£¬¿´µ½Ðí¶à¹¤³Ì϶¼ÓÐÒ»¸ö½Ð“Base”µÄÎļþ¼Ð£¬ÀïÃæÓÐһϵÁдø“***.Generated.cs”µÄÎļþ£¨±ÈÈçBulletin.Generated.cs£©¡£¶®µã±à³Ì֪ʶºÍÓ¢ÓïµÄÈ˶¼Ó¦¸Ã»áÏëµ½ÕâÊÇÓÃʲô¹¤¾ß×Ô¶¯Éú³ÉµÄ°É£¿ÒÔǰÎÒÒ²ÖªµÀC#Óиù¾ÝÄ£°å×Ô¶¯ ......