ÔÚasp.netÀïÔõô¸ù¾ÝÓû§È¨ÏÞÀ´Éú³ÉÊ÷Ðβ˵¥
ÔÚasp.netÀïÔõô¸ú¾ÝÓû§È¨ÏÞÀ´Éú³ÉÊ÷Ðβ˵¥
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.Web.UI.WebControls;
using System.Data.SqlClient;
namespace TreeCS
{
/// <summary>
/// WebForm1 µÄժҪ˵Ã÷¡£
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected Microsoft.Web.UI.WebControls.TreeView TreeView1;
private void Page_Load(object sender, System.EventArgs e)
{
// ¶¨ÒåÊý¾Ý¿âÁ¬½Ó
SqlConnection CN = new SqlConnection();
try
{
//³õʼ»¯Á¬½Ó×Ö·û´®
CN.ConnectionString= "data source=pmserver;initial catalog=Benchmark;persist security info=False;user id=sa;Password=sa;";
CN.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from tbTree",CN);
DataSet ds=new DataSet();
adp.Fill(ds);
this.ViewState["ds"]=ds;
}
catch (Exception ex)
{
Session["Error"] = ex.ToString();
Response.Redirect("error.aspx"); //Ìø×ª³ÌÐòµÄ¹«¹²´íÎó´¦ÀíÒ³Ãæ
}
finally
{
CN.Close();
}
//µ÷Óõݹ麯Êý£¬Íê³ÉÊ÷ÐνṹµÄÉú³É
AddTree(0, (TreeNode)null);
}
// µÝ¹éÌí¼ÓÊ÷µÄ½Úµã
public void AddTree(int ParentID,TreeNode pNode)
{
DataSet ds=(DataSet) this.ViewState["ds"];
&nb
Ïà¹ØÎĵµ£º
Request¶ÔÏó¹¦ÄÜÊÇ´Ó¿Í»§¶ËµÃµ½Êý¾Ý£¬³£ÓõÄÈýÖÖÈ¡µÃÊý¾ÝµÄ·½·¨ÊÇ£ºRequest.Form¡¢Request.QueryString£¬Request¡£ÆäµÚÈýÖÖÊÇǰÁ½ÖÖµÄÒ»¸öËõд£¬¿ÉÒÔÈ¡´úǰÁ½ÖÖÇé¿ö¡£¶øÇ°Á½ÖÖÖ÷Òª¶ÔÓ¦µÄFormÌύʱµÄÁ½ÖÖ²»Í¬µÄÌá½»·½·¨£º·Ö±ðÊÇPost·½·¨ºÍGet·½·¨¡£
Request ¶ÔÏóµÄÊôÐԺͷ½·¨± ......
×î½ü×ö±£´æÔ¶³ÌͼƬʱºò£¬¾ÍÔÚ±£´æµÄʱºò×ÜÊdzöÕâ¸ö´íÎó£¬ÍøÉÏgoogleÁËһȦ£¬¶¼ÊÇÔÙ˵ȨÏÞÎÊÌ⣬ÎÊÌâÎÒÊÇÓÃUÅÌ£¬ÄÄÀïÓÐʲôȨÏÞÎÊÌâ¡£
×îºóÎÞÒâÖз¢ÏÖÁËÎÊÌâËùÔÚ
±£´æµÄʱºò²»ÄÜÓÃÏà¶Ô·¾¶£¬Ò»¶¨ÒªÓÃserver.mappath()´¦Àíһϱ£´æµÄ·¾¶¡£¡£¡£°¦£¡ ......
¾³£ÐèÒªÔÚÊý¾Ý¿âÓëExeclÖ®¼ä»¥µ¼Êý¾Ý¡£netʱ´ú£¬ADO.NET¿ÉÒÔʹÓÃʹÓÃMicrosoft.Jet.OleDb·ÃÎÊ·ÃÎÊExcel£¬ÍøÉÏÒѾÓкܶàÀàËÆµÄ×ÊÔ´£¬×îµäÐÍÒ²ÊÇ×î¼òµ¥µÄ¿ÉÄÜÈçÏ£º£¨asp.net»·¾³£©
// Á¬½Ó×Ö·û´®
......
• ²»ÒªÊ¹Óò»±ØÒªµÄSession£¬ºÍASPÖÐÒ»Ñù£¬ÔÚ²»±ØÒªµÄʱºò²»ÒªÊ¹ÓÃSession
• ²»Ê¹Óò»±ØÒªµÄServer Control
• ²»Ê¹Óò»±ØÒªµÄViewState
• ²»ÒªÓÃExcepti ......
ÓÃASP.NETÓëSQL SERVER¿ÉÊÇÔµ·Ý×îºÃÁË£¬ÉÔ´óµÄ³ÌÐòÒ»°ãµÚÒ»ÏÈ¿¼ÂǵÄÊÇSQL SERVER£¬Ö»ÊÇһЩºÜ¿¼ÂǾ¼ÃµÄ²ÅʹÓÃACCESSµÈÁË¡£ÓÃSQL SERVER£¬ÎªÁËʹÊý¾Ý¿âµÄЧÂʸüºÃ£¬Ò»°ã¶¼»á²ÅÈ¡´æ´¢¹ý³Ì£¬Òò´æ´¢¹ý³ÌÖ´ÐÐËٶȿ죬²¢ÇÒ¿ÉÒÔʵÏÖһЩ¸ß¼¶µÄ²éѯµÈ¹¦ÄÜ¡£±ÈÈç´«ÈëһЩÊý¾Ý²ÎÊý£¬µ«Ö´ÐеÄSQL¹ý³Ì¿ÉÄܲ»Í¬µÈ¡£
¡¡¡¡ÏÂÃæ¾ÍÀ´¸öÀý× ......