ASP.NET Êý¾ÝÁ¬½Ó³öÏÖÎÊÌâ
ÔÚÏÂÏëÇë½Ìһϣ¬Õâ´ÎMS SQLÊý¾ÝÁ¬½ÓͻȻ³öÏÖÎÊÌâ¡£
ÔÚÏÂÏñƽʱһÑùÏȽ¨Á¢Ò»¸öASP.NETÍøÕ¾£¬Ê¹Óüòµ¥µÄ¡°WINDOW Éí·ÝÑéÖ¤Á¬½Ó¡±
<connectionStrings>
<add name="ConnectionString1" connectionString="Data Source=localhost;Initial Catalog=Data1;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
ä¯ÀÀ
http://localhost:3210/Web Site1/Default.aspx
Õâʱºò£¬Êý¾ÝÏÔʾÕý³£¡£
µ«ÒªÊÇÔÚIIS7.0ÖÐÌí¼ÓÓ¦ÓóÌÐòÖ±½ÓÁ¬½Óµ½Õâ¸öASP.NETÏîÄ¿ºó£¬ÔÙä¯ÀÀ
http://localhost/Web Site1/Default.aspx
ÕâʱºòÎÊÌâ³öÁË
¡°/Web Site1¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
Óû§ 'NT AUTHORITY\IUSR' µÇ¼ʧ°Ü¡£
ÇëÎÊΪʲô»áÓÐÕâÖÖÇé¿ö³öÏÖÄØ£¿
Õâ²»¸ö¼ÆËã»úÀïÃæµÄΨһÏîÄ¿£¬ÔÚ´Ë֮ǰÒѾÓкü¸¸öIISÓ¦ÓóÌÐòÔÚÔËÐУ¬ÔÚ¶ÁÈ¡SQLÊý¾Ýʱ¶¼Ã»ÓÐÕâÑùµÄÇé¿ö³öÏÖ¡£
Õ⾿¾¹ÊÇIIS³öÏÖÎÊÌ⣬»¹ÊÇÊý¾Ý¿âÀïµÄÎÊÌâÄØ£¿
½¨ÒéÂ¥Ö÷°ÑÁ¬½Ó×Ö·û´®ÖеÄdata sourceд³É×Ô¼º±¾»úµÄIPÊÔÊÔ
²»ÒªÊ¹Óá°WINDOW ÑéÖ¤¡±£¬Ê¹Óá°SQL Server ÑéÖ¤¡±Á¬½ÓÊý¾Ý¿â¡£ÔÚÊý¾Ý¿âÁ¬½Ó×Ö·û´®ÖÐдÃ÷·ÃÎʵÄusernameºÍpassword¡£ÕâÑù£¬ÄãµÄ³ÌÐò¿ÉÒԱȽÏ̤ʵµØÔÚ¸÷ÖÖ»·¾³ÉÏÓëSQL ServerÁªÍ¨¡£
¶ÔÓÚÍøÕ¾Ò²ÊÇÕâÑù¡£²»ÒªÊ¹ÓÃʲôWindowsµÇ¼ÑéÖ¤£¬Ó¦¸ÃʹÓá°ÄäÃû¡±·½Ê½À´µÇ¼ÄãµÄÍøÕ¾¡£ÔÚ¿ª·¢webÓ¦ÓõÄʱºò£¬¾ÍÓ¦¸ÃÕâÑù¿¼ÂÇ£¬ÒòΪÕâÑù¿ÉÒÔÈÃÄã×îÎȶ¨µ
Ïà¹ØÎÊ´ð£º
ÈçÌ⣡
FileUpload1.PostedFile.FileName
ÎÒÕâÑùдÁË µ«ÊÇ»¹ÊÇ»ñµÃµÄÊÇÒ»¸öÎļþµÄÃû³Æ£¬FileUpload1.FileName Õâ¸öÒ²ÊÇÒ»Ñù£¡
FileUpload1.PostedFile.FileName
IE ÎÊÌâ
¹¤¾ß-internetÑ¡Ïî-°²È«- ......
ÎÒÔÚ Page_Load ÀïдÁË
if(!IsPostBack){
GridView1.DataSource=GroupManager.GetGroups();//GetGroups ·µ»ØµÄÊÇ IList<Group>
GridView1.DataBind();
}
¿ÉÎÒÔÚ Submit_Click Àïд´ú ......
ÔÚc#À
ÎÒ×öµÄÊǵײãµÄ²åÈë¡£
ʵÌå²ã£¬Êý¾Ý²ã£¬ÒµÎñ²ãÒѾÓбíµÄÊôÐÔÁË£¬
ҪʵÏÖ½«excel±íÀïµÄÄÚÈݲåÈëµ½ÒÑÓеÄÊý¾Ý¿âµÄijһ±íÖС£
±ÈÈçexcel±íÀïÓÐÊôÐÔA,B,C,D,E
Êý¾Ý¿âÀïµÄ±íµÄÃû×ÖÊÇexcelTable ......
protected void btuUpdate_Click(object sender, EventArgs e)
{
btuUpdate.Attributes.Add("onclick"," <scr ......