ASP.NET Code: get website url path

ASP.NET Code: get website url path

Dim str_server As String
Dim sArr As String()
Dim str_region As String
Dim str_lang As String

str_server = Request.Path.Substring(0, Request.Path.LastIndexOf("/") + 1)
sArr = Split(str_server, "/")
str_region = sArr(2)
str_lang = sArr(3)

ASP.NET Code: Export Excel from Gridview Data

ASP.NET Code: Export Excel from Gridview Data

如何將GridView的內容匯出成Excel?
http://blog.blueshop.com.tw/lolota/archive/2007/02/25/49703.aspx

Add Code

GridView1.AllowSorting = False
GridView1.AllowPaging = False
GridView1.DataBind()

before

GridView1.RenderControl(hw)

ASP.NET Code: HOW TO: Send email using System.Net.Mail

ASP.NET Code: HOW TO: Send email using System.Net.Mail

Send Email using Gmail ASP.NET C# VB.NET
http://csharpdotnetfreak.blogspot.com/2009/06/aspnet-send-email-using-gmail.html
using username and password in code

Sending Email with System.Net.Mail
http://weblogs.asp.net/scottgu/archive/2005/12/10/432854.aspx
using SMTP setting in web.config

ASP.NET內抓取網址的方式一覽表(Request)
http://demo.tc/view.aspx?id=230
Request.Url.Query[id]

http://digitalcolony.com/2007/08/sending-email-in-aspnet-using-smtp.aspx
http://www.jscape.com/articles/sending_email_using_vb.html

ASP.NET Code: /admin Acces Right

ASP.NET Code: /admin Acces Right

ASP.NET Web 應用程式管理員
安全性
存取規則
建立存取規則

會生一個 Web.config 係 /admin


<?xml version="1.0" encoding="utf-8"?>
<configuration>
<system.web>
<authorization>
<allow users="admin" />
<deny users="?" />
<deny users="*" />
</authorization>
</system.web>
</configuration>


http://www.packtpub.com/article/asp.net-3.5-cms-adding-security-and-membership-part1

http://www.packtpub.com/article/asp.net-3.5-cms-adding-security-and-membership-part2

ASP.NET Code: www.qsh.eu ASPNETDB.MDF

ASP.NET Code: www.qsh.eu ASPNETDB.MDF


<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;Database=www.qsh.eu_8a547bfd-ce62-405a-bbfe-1628ac48aa15;AttachDBFilename=|DataDirectory|ASPNETDB.MDF" />
</connectionStrings>


http://forum.qsh.eu/Forums.aspx?forumid=25&threadid=79

http://forum.qsh.eu/Forums.aspx?searchtext=aspnet

http://www.cnblogs.com/hardrock/archive/2007/11/13/958546.html

ASP.NET Code: www.qsh.eu ConnectionString

ASP.NET Code: www.qsh.eu ConnectionString

For examle you have database "Test.mdf" created at SQL Server Management Studio Express.

1st step: your database must be detached from your SQL server correctly: open management studio -> right click on "Test" database -> Tasks -> Detach.

2nd step: create folder www/App_Data and copy Test.mdf without log file.

3 step: generate connection string at https://www.qsh.eu/admin/EditFreehosting.aspx and save in web.config.

4 step: replace name="LocalSqlServer" with (for example) name="DBAccess".

5 step: in code you can read connection string from web.config:

string connectionString = ConfigurationManager.ConnectionStrings["DBAccess"].ConnectionString;
IDbConnection connection = new SqlConnection(connectionString);

OR
replace name="DBAccess" with (for example) name="LocalSqlServer" in all ASPX
the stupid method i did once...

Login Link for www.qsh.eu
https://www.qsh.eu/admin/Login.aspx

免費asp.net空間(www.qsh.eu)使用詳解
http://www.0379zd.com/news/show/17001.htm

Qantasoft qsh.eu webconfig connectionString problem
http://forums.asp.net/p/1253493/2356606.aspx#2356606

ASP.NET Code: SqlConnection with ConnectionString

ASP.NET Code: SqlConnection with ConnectionString

Dim SQLData As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\db.mdf;Integrated Security=True;User Instance=True")

Dim SQLData As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("
dbConnectionString").ConnectionString)

from
http://www.aspnet101.com/aspnet101/tutorials.aspx?id=64

ASP.NET Code: SQL SELECT command based on DropDownList

ASP.NET Code: SQL SELECT command based on DropDownList

SQL SELECT command based on DropDownList

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:dbConnectionString %>"
SelectCommand="SELECT * FROM [menu] WHERE (([region] = @region) AND ([lang] = @lang)) ORDER BY [menuId]"
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="region"
PropertyName="SelectedValue" Type="String" />
<asp:Parameter DefaultValue="1" Name="lang" Type="String" />
</SelectParameters>

ASP.NET Code: Server.MapPath

ASP.NET Code: Server.MapPath

Dim PathName As String
Dim FileName As String
PathName = LangPath & "/collection" & cat & ".xml"
FileName = Server.MapPath(PathName)

http://fuchangmiao.blogspot.com/2008/11/aspnet-path.html