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();
Ïà¹ØÎĵµ£º
1.//µ¯³ö¶Ô»°¿ò.µã»÷תÏòÖ¸¶¨Ò³Ãæ
Response.Write(" <script>window.alert('¸Ã»áԱûÓÐÌá½»ÉêÇë,ÇëÖØÐÂÌá½»£¡')
</script>"
;
Response.Write(" <script>window.location
='http://www.51aspx.com/bizpulic/upmeb.aspx' </script>"
;
2.//µ¯³ö¶Ô»°¿ò
Response.W ......
Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
¡¡¡¡·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕʱÊÕ»ØÁ ......
¹ØÓÚ asp.net ·þÎñÆ÷¿Ø¼þ¼¸¸ö ID µÄ˵Ã÷[ZT]
Òý×Ô:http://lujf1978.blog.163.com/blog/static/2320126620078114112822/
¶ÔÓÚÿһ¸ö·þÎñÆ÷¿Ø¼þSystem.Web.UI.Control ¶¼¾ßÓÐ ID£¬UniqueID£¬ClientID Èý¸öÊôÐÔ£¬ÄÇôÕâ¸öÈýÕßµ½µ×ÓкӹØÏµ£¬ÔÚ¿Í»§¶ËHTMLÖÐÓÖÊÇÈçºÎ¶ÔÓ¦³ÊÏÖµÄÄØ£¿
ID£º»ñÈ¡»òÉèÖ÷ÖÅ䏸·þÎñÆ÷¿Ø¼þµÄ ......
µ¼³öµ½excelµÄ·½·¨ÓжàÖÖ£¬±È½Ï³£¼ûµÄÊÇÖ±½Óµ¼³öµ½EXCEL,»¹ÓоÍÊÇÏȽ«Ò³ÃæµÄÊý¾Ýдµ½´ÅÅÌÎļþ£¬Ö®ºóÖ±½ÓÔÙ´ò¿ªÎļþ£¬ÁíÍ⻹ÓоÍ
ÊǽèÖúµÚÈý·½µÄ¿Ø¼þ¡£
ǰ¶Îʱ¼äдµÄµ¼³öÊý¾Ýµ½excelÔÚexcel2003ÖÐÕý³£¶øÔÚexcel2007ÖÐÊý¾ÝÂÒÂ룬½ñÌìÁ˽⵽ÔÀ´ÊÇResponse.ContentType = "application/ms-excel";µ¼Ö ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// <summary>
/// Data ......