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ÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕʱÊÕ»ØÁ ......
ASP.NET·þÎñÆ÷¿Ø¼þÖ®ÊÓͼ״̬
ΪWebÒ³Ãæ¼°Æä¿Ø¼þ±£³Ö״̬ÐÅÏ¢ÊǷdz£ÓбØÒªµÄ¡£È»¶ø£¬ÓÉÓÚWebÓ¦ÓóÌÐò´´½¨ÓÚHTTPÐÒéµÄ¶¥²ã£¬ÕâÊÇÒ»¸öÎÞ״̬µÄÐÒ飬Òò´Ë£¬±£³Ö״̬ÐÅÏ¢Ôò±äµÃ·Ç³£À§ÄÑ¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬ASP.net 2.0¼¼ÊõÌṩÁ˶àÖÖ½â¾ö·½°¸£¬ÀýÈ磬ÀûÓÃSession¡¢Cookie¡¢ÊÓͼ״̬¡¢¿Ø¼þ״̬¡¢Òþ²ØÓò¡¢²éѯ×Ö·û´®¡¢¸ö ......
²»¹ÜʹÓÃÄÄÖÖµ×²ãÆ½Ì¨£¬¿É¿¿ÐÔºÍÐÔÄܶ¼ÊǶÔËùÓÐ Web Ó¦ÓóÌÐòµÄÖ÷ÒªÒªÇ󣬾¡¹Ü´ÓijÖÖÒâÒåÉϽ²£¬ÕâÁ½¸öÒªÇóÊÇÏ໥ì¶ÜµÄ¡£ÀýÈ磬Ҫ¹¹½¨¸ü¿É¿¿¡¢¸ü½¡×³µÄÓ¦ÓóÌÐò£¬¿ÉÄÜÐèÒª½« Web ·þÎñÆ÷Óë¾ßÌåµÄÓ¦ÓóÌÐò·ÖÀ룬ʹӦÓóÌÐòÔÚ½ø³ÌÍ⹤×÷¡£µ«ÊÇ£¬Èç¹ûÔÚ²»Í¬ÓÚ Web ·þÎñÆ÷½ø³ÌµÄÄÚ´æ»·¾³Öй¤×÷£¬Ó¦ÓóÌÐò½«±äÂý¡£Òò´Ë£¬ÐèÒª²ÉÈ¡º ......