asp.net ´æ´¢¹ý³ÌÖ´ÐÐʵÀý
protected void Page_Load(object sender, EventArgs e)
{
/*
sql½Å±¾-´´½¨Ñ§Éú±í
create table student(id int,name varchar(50))
insert into student select 1,'СÕÅ'
insert into student select 2,'СÍõ'
´æ´¢¹ý³Ì ¹¦ÄÜ£º²éѯѧÉúÃû³Æ
create proc proc_getName
@id int,
@name varchar(50) output
as
begin
if exists(select 1 from student where id=@id)
select @name=name from student where id=@id
else
set @name='--δÕÒµ½Ñ§Éú--'
end
*/
}
//Ö´Ðд洢¹ý³Ì
public void RunProcedure(string storedProcName, IDataParameter[] parameters)
{
string connectionString = "server=.;database=my;uid=sa;pwd=bb";//Êý¾Ý¿âÁ¬½Ó´®
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet dataSet = new DataSet();
connection.Open();
SqlDataAdapter sqlDA = new SqlDataAdapter();
Ïà¹ØÎĵµ£º
±¾Ö÷Ìâ¸ÅÊöÓ¦ÓóÌÐòÉúÃüÖÜÆÚ£¬ÁгöÖØÒªµÄÉúÃüÖÜÆÚʼþ£¬²¢ÃèÊöÈçºÎ±àдÊʺÏÓ¦ÓóÌÐòÉúÃüÖÜÆÚµÄ´úÂë¡£ÔÚ ASP.NET ÖУ¬ÈôÒª¶Ô ASP.NET Ó¦ÓóÌÐò½øÐгõʼ»¯²¢Ê¹Ëü´¦ÀíÇëÇ󣬱ØÐëÖ´ÐÐһЩ´¦Àí²½Öè¡£´ËÍ⣬ASP.NET Ö»ÊǶÔä¯ÀÀÆ÷·¢³öµÄÇëÇó½øÐд¦ÀíµÄ Web ·þÎñÆ÷½á¹¹µÄÒ»²¿·Ö¡£Á˽âÓ¦ÓóÌÐòÉúÃüÖÜÆÚ·Ç³£ÖØÒª£¬ÕâÑù²ÅÄÜÔÚÊ ......
ASP.NETÓ¦ÓóÌÐòÉè¼ÆµÄ10´ó¼¼ÇÉ [ ASP.NETÓ¦ÓóÌÐòÉè¼ÆµÄ10´ó¼¼ÇÉ | ÔðÈαà¼: 51»¶ÀÖ°É - ¹ØÌÎ | 2007-09-25 10:38:16 ]
µ÷Õû×ÖÌå´óС: ´ó | ÖÐ | С
ÉùÃ÷:ÈçÓÐÉæ¼°µ½·¨ÂÉÏà¹ØÎÊÌâ,Ç뼰ʱÓë¹ØÌÎÁªÏµ! QQ:364586868 ÁªÏµQQ
--------------------------------------------------------------------------------
Ô ......
ASP.NET·ÖÒ³·½·¨µÄÁ˽â³Ì¶È
¡¾³öÏÖÆµÂÊ¡¿
¡ï¡ï¡ï¡ï¡î
¡¾½â´ð¡¿
ASP.NET·ÖÒ³µÄ³£Ó÷½·¨ÓÐÒÔϼ¸ÖÖ¡£
q ÆôÓò¿·ÖÊý¾Ý¿Ø¼þµÄÄÚÖ÷ÖÒ³¹¦ÄÜ£¬ÈçÉèÖÃGridView¿Ø¼þµÄ“AllowPaging”ÊôÐÔΪ“true”£¬ÀàËÆµÄÊý¾Ý¿Ø¼þ»¹ÓÐDetailsViewµÈ¡£
q ͨ¹ýSQL²éѯÓï¾ä£¬ÒÔÌáȡָ¶¨²¿·ÖµÄÊý¾ÝµÄ·½Ê½Íê³É·ÖÒ³µÄ¹¦ÄÜ¡£Ò ......
µ¼³öµ½excelµÄ·½·¨ÓжàÖÖ£¬±È½Ï³£¼ûµÄÊÇÖ±½Óµ¼³öµ½EXCEL,»¹ÓоÍÊÇÏȽ«Ò³ÃæµÄÊý¾Ýдµ½´ÅÅÌÎļþ£¬Ö®ºóÖ±½ÓÔÙ´ò¿ªÎļþ£¬ÁíÍ⻹ÓоÍ
ÊǽèÖúµÚÈý·½µÄ¿Ø¼þ¡£
ǰ¶Îʱ¼äдµÄµ¼³öÊý¾Ýµ½excelÔÚexcel2003ÖÐÕý³£¶øÔÚexcel2007ÖÐÊý¾ÝÂÒÂ룬½ñÌìÁ˽⵽ÔÀ´ÊÇResponse.ContentType = "application/ms-excel";µ¼Ö ......
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('¼ÓÈëÔÝ´æ¼Ü³É¹¦£¡');</script>");
asp.net¼òµ¥¼ÓÃÜ
//using System.Web.Security;
System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfig ......