ASP.NET Routing for URLRewriting with QueryStrings
In the last post I showed how to use the ASP.NET 3.5 Routing Engine
for URLRewriting purposes. I want to go further in this post by adding
the ability to add variables into a route path and forward and append
query string variables to the destination Web Form request.
A route can contain one or more variables expressed by its {name}.
RouteTable.Routes.Add(
new
Route(
"articles/{id}"
,
new
devcoach.Web.RoutingPageHandler()));
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
Inside of the RoutingHandler we can iterate through the variables by
accessing them by the RouteData property on the parameter passing the
RequestContext:
var queryString = new
StringBuilder("?"
);
foreach
(var aux in
requestContext.RouteData.Values)
{
queryString.Append(
requestContext.HttpContext.Server.UrlEncode(aux.Key));
queryString.Append("="
);
queryString.Append(
requestContext.HttpContext.Server.UrlEncode(
aux.Value.ToString()));
queryString.Append("&"
);
}
queryString.Remove(queryString.Length - 1, 1);
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0e
Ïà¹ØÎĵµ£º
System.Windows.Forms;
FolderBrowserDialog ÌṩÁËÎÒÃÇÐèÒªµÄÎļþ¼Ðä¯ÀÀ¶Ô»°¿ò£¬ÒòΪÊÇCOM±ØÐëÊÇSTAµÄ£¬ÉèÖà AspCompat="true"À´½â¾öÕâ¸öÎÊÌâ¡£
Ó÷¨£º
protected void Button1_Click(object sender, EventArgs e)
{
  ......
1.·½·¨Ò»£º²ÉÓÃOleDB¶ÁÈ¡EXCELÎļþ£º
°ÑEXCELÎļþµ±×öÒ»¸öÊý¾ÝÔ´À´½øÐÐÊý¾ÝµÄ¶ÁÈ¡²Ù×÷£¬ÊµÀýÈçÏ£º
public DataSet ExcelToDS(string Path)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(str ......
//Á¬½ÓÊý¾Ý¿â
string myStr = CODE.DbHelperSQL.connectionString;
SqlConnection myConn = new SqlConnection(myStr);
myConn.Open();
&nbs ......
ûÓÐÏëµ½ÕæµÄÕâô·½±ã!¸ü¼Ó¼á¶¨ÎÒѧϰASP.NETµÄ¾öÐÄ! ÏÖÔÚÎÒÃÇÒ»ÆðÀ´¿´¿´°É
1,ÇëÈ·¶¨ÄãµÄµçÄÔ°²×°ÁËÒÔϵÄÈí¼þ£¡
1.1£¬ WINDWOS 2000ÒÔÉϰ汾(±Ø×°)
1.2£¬ .NET Framework(±Ø×°)
1.3£¬ Visual Studio .NET 2005(±Ø×°)
2,½¨Á¢Ò»¸öACCESSÊý¾Ý¿â,
3,Í϶¯VS2005 µÄGRIDVIEW µ½Éè ......
ÏÈ¿´¿´ASP.NETÒ³ÃæË¢ÐµÄʵÏÖ·½·¨£º
µÚÒ»£º
private void Button1_Click( object sender, System.EventArgs e ) { Response.Redirect( Request.Url.ToString( ) ); }
µ ......