Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

Asp.netÈÕÆÚ×Ö·û´®¸ñʽ»¯ÏÔʾ

Asp.netÈÕÆÚ×Ö·û´®¸ñʽ»¯ÏÔʾ--DateTime.ToString()Ó÷¨Ïê½â
ÎÒÃǾ­³£»áÓöµ½¶Ôʱ¼ä½øÐÐת»»,´ïµ½²»Í¬µÄÏÔʾЧ¹û£¬Ä¬ÈϸñʽΪ:2006-6-6 14:33:34
Èç¹ûÒª»»³É³É200606,06-2006,2006-6-6»ò¸ü¶àµÄ¸ñʽ¸ÃÔõô°ìÄØ£¿
ÕâÀォҪÓõ½:DateTime.ToStringµÄ·½·¨(String, IFormatProvider)
ʾÀý£º
using System;
using Syste ......

asp.netÃæÊÔÌâ(1)

 
1. ¼òÊö private¡¢ protected¡¢ public¡¢ internal ÐÞÊηûµÄ·ÃÎÊȨÏÞ¡£   
 
´ð . private : ˽ÓгÉÔ±, ÔÚÀàµÄÄÚ²¿²Å¿ÉÒÔ·ÃÎÊ¡£    
    protected : ±£»¤³ÉÔ±£¬¸ÃÀàÄÚ²¿ºÍ¼Ì³ÐÀàÖпÉÒÔ·ÃÎÊ¡£    
    public ......

asp.netÃæÊÔÌâ(8)

121.ÃèÊöÒ»ÏÂc#ÖÐË÷ÒýÆ÷µÄʵÏÖ¹ý³Ì£¬ÊÇ·ñÖ»Äܸù¾ÝÊý×Ö½øÐÐË÷Òý£¿    
 
´ð£º²»ÊÇ¡£¿ÉÒÔÓÃÈÎÒâÀàÐÍ¡£   
 
 
 
122.ÔÚc££ÖУ¬string str = null Óë string str = " " Ç뾡Á¿Ê¹ÓÃÎÄ×Ö»òͼÏó˵Ã÷ÆäÖеÄÇø±ð¡£   
 
´ð£ºnullÊÇÃ»Ó ......

ASP.NET


[±à¼­±¾¶Î]
ʲôÊÇ ASP£¿
¡¡¡¡ASP ÊÇÒ»ÖÖʹǶÈëÍøÒ³ÖеĽű¾¿ÉÓÉÒòÌØÍø·þÎñÆ÷Ö´ÐеķþÎñÆ÷¶Ë½Å±¾¼¼Êõ¡£
¡¡¡¡ASP ÊÇÒ»Ïî΢Èí¹«Ë¾µÄ¼¼Êõ
¡¡¡¡ASP Ö¸ Active Server Pages£¨¶¯Ì¬·þÎñÆ÷Ò³Ãæ£©
¡¡¡¡ASP ÊÇÔËÐÐÓÚ IIS Ö®ÖеijÌÐò
¡¡¡¡IIS Ö¸ Internet Information Services£¨ÒòÌØÍøÐÅÏ¢·þÎñ£©
¡¡¡¡IIS ÊÇ Windows 2000 À ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ