<div data-role = "collapsible-set">
<ul data-role="listview" data-filter="true">
<div data-role ="collapsible">
資料....
</div>
</ul>
</div>
<asp:SqlDataSource
id="SqlDataSource1"
runat="server"
DataSourceMode="DataSet"
ConnectionString="<%$ ConnectionStrings:MyNorthwind%>"
EnableCaching="True"
CacheDuration="20"
SelectCommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees">
</asp:SqlDataSource>
DateTime Date= myDataReader.GetDateTime(第幾攔位數);
DateTime.Now.ToShortDateString() + " 上午 12:00:00"
Connection.open();
指令一
Connection.close();
Connection.open();
指令二
Connection.close();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Img"] != null)
{
lblGetName.Text = "發現圖檔已傳送，" + Session["Img"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// 這裡是讀取圖片資料夾，並取出資料
// 資料夾資料
DirectoryInfo dir = new DirectoryInfo(Server.MapPath ("Image"));
// 檔案資料 (取出自資料夾)
FileInfo[] file = dir.GetFiles();
// 計算ID 流水號
int ID = 0;
foreach (FileInfo result in file)
{
ID++;
// 創出 CheckBox，並設定相關的數值
CheckBox img = new CheckBox();
img.ID = "Img" + ID;
img.Text = "<img src='Image\\" + result.Name + "' width='100' height='100' />";
img.InputAttributes["value"] = result.Name;
// 加入到 PlaceHolder 內
PlaceHolderImage.Controls.Add(img);
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
// 取得檔案路徑
string saveDir = "\\Image\\";
string fileName, savePath;
// 取得檔案名稱並儲存檔案
// 這裡是.NET 4.5的多重檔案上傳(PostedFiles)
foreach (HttpPostedFile postedFile in FuImage.PostedFiles)
{
fileName = postedFile.FileName;
savePath = Server.MapPath(saveDir + fileName);
postedFile.SaveAs(savePath);
}
Response.Write("<script language='javascript'>alert('上傳成功');location.href='ImageManager.aspx';</script>");
}
protected void btnUse_Click(object sender, EventArgs e)
{
// 取出選取檔案的名稱
string useimage = "";
for (int chk = 1; chk <= PlaceHolderImage.Controls.Count; chk++)
{
// PlaceHolder內的Checkbox
CheckBox chkimg = (CheckBox)PlaceHolderImage.FindControl("Img" + chk);
// 確認是否選取
if (chkimg.Checked)
{
useimage += Request.Form["Img" + chk]+",";
}
}
// 使用 Session 紀錄資料
Session["Img"] = useimage;
Response.Redirect("Default.aspx");
}
protected void btnDel_Click(object sender, EventArgs e)
{
// 刪除圖片
bool notexist = false;
DirectoryInfo dir = new DirectoryInfo(Server.MapPath("Image"));
FileInfo[] file = dir.GetFiles();
int ID = 0;
foreach (FileInfo delfile in file)
{
ID ++ ;
CheckBox chk = (CheckBox)PlaceHolderImage.FindControl("Img" + ID);
if (chk.Checked)
{
//確認檔案存在
if (delfile.Exists)
{
delfile.Delete();
}
else
{
notexist = true;
}
}
}
if (notexist == true)
{
Response.Write("<script language='javascript'>alert('刪除失敗，圖檔不存在')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('刪除成功');location.href='ImageManager.aspx';</script>");
}
}
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|NorthWind.mdb;Persist Security Info=True"); //連結字串
conn.Open(); // 開啟連結
OleDbCommand cmd = new OleDbCommand(readcmd , conn); //指令 設定住在London的人
OleDbDataReader dr = cmd.ExecuteReader(); // 讀取到DataReader
//while (dr.Read()) // 如果有讀取到 (這裡是直接輸出)
//{
// Response.Write(dr[0].ToString() +" "+dr[1].ToString ()+" "+dr[2].ToString ()+" "+dr[3].ToString ()+" "+dr[4].ToString ()+" "+dr[5].ToString ()+ "
"); //輸出
//}
// 這裡是使用GridView輸出
GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close(); //關閉連結
// 註：readcmd 是連結的指令 例如：Select * From Student...
// 連結
AccessDataSource1.DataFile = "~/App_Data/NorthWind.mdb";
// 這是Sql的例子
SqlDataSource1.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
// 指令
AccessDataSource1.SelectCommand = "Select * From Customers Where City='London'";
GridView1.DataSourceID = "AccessDataSource1";
<add name connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|NorthWind.mdb;Persist Security Info=True" name="ConnectionString" providername="System.Data.OleDb">
<asp:accessdatasource ID="AccessDataSource1" 控制項ID
runat="server" 在伺服器上運作
DataFile="~/App_Data/NorthWind.mdb" 實體資料庫
SelectCommand="Select * From Customers Where City = 'London'"> 指令