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 ÖУ¬ÈôÒª¶Ô ASP.NET Ó¦ÓóÌÐò½øÐгõʼ»¯²¢Ê¹Ëü´¦ÀíÇëÇ󣬱ØÐëÖ´ÐÐһЩ´¦Àí²½Öè¡£´ËÍ⣬ASP.NET Ö»ÊǶÔä¯ÀÀÆ÷·¢³öµÄÇëÇó½øÐд¦ÀíµÄ Web ·þÎñÆ÷½á¹¹µÄÒ»²¿·Ö¡£Á˽âÓ¦ÓóÌÐòÉúÃüÖÜÆÚ·Ç³£ÖØÒª£¬ÕâÑù²ÅÄÜÔÚÊ ......
¹ØÓÚ asp.net ·þÎñÆ÷¿Ø¼þ¼¸¸ö ID µÄ˵Ã÷[ZT]
Òý×Ô:http://lujf1978.blog.163.com/blog/static/2320126620078114112822/
¶ÔÓÚÿһ¸ö·þÎñÆ÷¿Ø¼þSystem.Web.UI.Control ¶¼¾ßÓÐ ID£¬UniqueID£¬ClientID Èý¸öÊôÐÔ£¬ÄÇôÕâ¸öÈýÕßµ½µ×ÓкӹØÏµ£¬ÔÚ¿Í»§¶ËHTMLÖÐÓÖÊÇÈçºÎ¶ÔÓ¦³ÊÏÖµÄÄØ£¿
ID£º»ñÈ¡»òÉèÖ÷ÖÅ䏸·þÎñÆ÷¿Ø¼þµÄ ......
ÔÚASP.NetÒ»°ãµÄ³ÌÐò±àдÖУ¬ËùʹÓõÄÊý¾ÝÀïÃæ£¬ÈÕÆÚʱ¼äÊÇÒ»ÖÖÌØÊâµÄÊý¾ÝÀàÐÍ£¬Ò²ÊǾ³£±»Ê¹Óõġ£---µçÄԽ̳̼¼ÊõÑ§Ï°Íø
ÔÚVisual Basic.NETÖеÄÈÕÆÚʱ¼äÊý¾ÝÓÃÊýÖµµÄÊý¾ÝÀàÐͱ£´æ£¬¶øÇÒÓз¶Î§¡£
ÈÕÆÚµÄ·¶Î§Êǹ«Ôª1Äê1ÔÂ1ÈÕ¡«¹«Ôª9999Äê1 2ÔÂ3 1ÈÕ£¬Ê±¼äµÄ·¶Î§ÊÇ00£º00£º00¡«23£º59£º59¡£ÉùÃ÷¸ñÊ½È ......