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£®¿É¿¿ÐԸߣº¼üÅÌÊäÈëÊý¾Ý³ö´íÂÊΪÈý°Ù·ÖÖ®Ò»£¬ÀûÓùâѧ×Ö·ûʶ±ð¼¼Êõ³ö´íÂÊΪÍò·ÖÖ®Ò»£¬¶ø²ÉÓÃÌõÐÎÂë¼¼ÊõÎóÂëÂʵ ......
Asp.netÈÕÆÚ×Ö·û´®¸ñʽ»¯ÏÔʾ--DateTime.ToString()Ó÷¨Ïê½â
ÎÒÃǾ³£»áÓöµ½¶Ôʱ¼ä½øÐÐת»»,´ïµ½²»Í¬µÄÏÔʾЧ¹û£¬Ä¬ÈϸñʽΪ:2006-6-6 14:33:34
Èç¹ûÒª»»³É³É200606,06-2006,2006-6-6»ò¸ü¶àµÄ¸ñʽ¸ÃÔõô°ìÄØ£¿
ÕâÀォҪÓõ½:DateTime.ToStringµÄ·½·¨(String, IFormatProvider)
ʾÀý£º
using System;
using Syste ......
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
1. ·ÃÎÊ HTML¿Ø¼þµÄÖµÊÇvalueÊôÐÔ
·ÃÎÊ ASP.NET¿Ø¼þµÄÖµÊÇtextÊôÐÔ
--------------------------------------------------------
2.·Ö±ðÐèÒªµÄÃû×Ö¿Õ¼äΪ£º
using System.Web.UI.HTML.Controls;
using System.Web.UI.WebControls;
-------------------------------------------- ......
CheckBoxÑ¡Ôñ×é¼þÊÇÒ»¸ö³ÌÐòÖж¼¾³£µÄ×é¼þ¡£ÔÚ³ÌÐòÉè¼ÆÖÐʹÓõ½¸Ã×é¼þ£¬Ò»°ã¶¼²»»áֻʹÓõ½Ò»¸ö£¬ÍùÍùÊÇÒÔ¶à¸ö´ËÀà×é¼þµÄÐÎʽ³öÏֵġ£ÔÚASP.NETÒ³ÃæÖÐÈç¹ûҪʹÓõ½¶à¸öCheckBox×é¼þ£¬³ýÁËÌí¼Ó¶à¸öCheckBox×é¼þÔÚÒ³ÃæÖÐÖ®Í⣬»¹ÓÐÒ»ÖֱȽϷ½±ãµÄ·½·¨£¬¾ÍÊÇʹÓÃCheckBoxList ×é¼þ¡£CheckBoxList×é¼þÊÇÓÉÒ»×éµÄCheckBox×é¼þ×é ......