public void rightmain() { string config = System.Web.Configuration.WebConfigurationManager .ConnectionStrings["ProjectConnection"].ConnectionString; SqlConnection connectionID = new SqlConnection(config); SqlCommand commandID = new SqlCommand($"Select * FROM YachtsNews where id=@id", connectionID); commandID.Parameters.Add("@id", SqlDbType.NVarChar); //設定參數資料型態 commandID.Parameters["@id"].Value = Request.QueryString["id"]; SqlDataAdapter loginAdapterID = new SqlDataAdapter(commandID); DataTable userID = new DataTable(); loginAdapterID.Fill(userID); NewsMainName.InnerHtml = userID.Rows[0]["title"].ToString(); NewsMains.InnerHtml = userID.Rows[0]["main"].ToString(); //download SqlConnection RPconnection = new SqlConnection(config); SqlCommand RPcommand = new SqlCommand($"Select ROW_NUMBER() OVER (ORDER BY id ASC) as ROW_ID, filename ,(Select title from YachtsNews where id=NewsDownload.uid) as title from NewsDownload where uid=@uid", RPconnection); RPcommand.Parameters.Add("@uid", SqlDbType.NVarChar); //設定參數資料型態 RPcommand.Parameters["@uid"].Value = Request.QueryString["id"]; //接id的值變成參數的值 RPconnection.Open(); SqlDataReader RPrereader = RPcommand.ExecuteReader(); Repeater_download.DataSource = RPrereader; //repeater的資料來源是從rereader來 Repeater_download.DataBind(); //執行繫結 }
public void rightmain() { string config = System.Web.Configuration.WebConfigurationManager .ConnectionStrings["ProjectConnection"].ConnectionString; SqlConnection connectionID = new SqlConnection(config); SqlCommand commandID = new SqlCommand($"Select * FROM YachtsType ", connectionID); SqlDataAdapter loginAdapterID = new SqlDataAdapter(commandID); DataTable userID = new DataTable(); loginAdapterID.Fill(userID); //判斷Request.QueryString["id"]有沒有資料,因為一開始進網頁時要直接抓第一筆id,但網址一開始載入會沒有id資料 //抓名字(標題) SqlConnection rconnection = new SqlConnection(config); SqlCommand Rcommand = new SqlCommand($"Select * FROM YachtsType where id =@id ", rconnection); if (string.IsNullOrEmpty($"{Request.QueryString["id"]}")) { string id = Request.QueryString["id"] ?? $"{userID.Rows[0]["id"].ToString()}"; Rcommand.Parameters.Add("@id", SqlDbType.NVarChar); //設定參數資料型態 Rcommand.Parameters["@id"].Value = id; //接id的值變成參數的值 menuOverview.HRef = "Overview.aspx?id=" + id; menuLayout.HRef = "Layout.aspx?id=" + id; menuSpec.HRef = "Specifications.aspx?id=" + id; } else { Rcommand.Parameters.Add("@id", SqlDbType.NVarChar); //設定參數資料型態 Rcommand.Parameters["@id"].Value = Request.QueryString["id"]; //接id的值變成參數的值 menuOverview.HRef = "Overview.aspx?id=" + Request.QueryString["id"]; menuLayout.HRef = "Layout.aspx?id=" + Request.QueryString["id"]; menuSpec.HRef = "Specifications.aspx?id=" + Request.QueryString["id"]; } SqlDataAdapter loginAdapter = new SqlDataAdapter(Rcommand); DataTable user = new DataTable(); loginAdapter.Fill(user); if (user.Rows[0]["NewYachts"].ToString() == "False") { rightYachtsName.InnerHtml = user.Rows[0]["YachtsType"].ToString(); } else { rightYachtsName.InnerHtml = user.Rows[0]["YachtsType"].ToString(); spanname.InnerHtml = " New"; } Yachtsnnn.InnerHtml = user.Rows[0]["YachtsType"].ToString(); rightYachtsName1.InnerHtml = user.Rows[0]["YachtsType"].ToString(); SqlConnection connectionMain = new SqlConnection(config); SqlCommand commandMain = new SqlCommand($"Select Overview,Dimensions FROM YachtsType where id=@id ", connectionMain); if (string.IsNullOrEmpty($"{Request.QueryString["id"]}")) { string id = Request.QueryString["id"] ?? $"{userID.Rows[0]["id"].ToString()}"; commandMain.Parameters.Add("@id", SqlDbType.NVarChar); //設定參數資料型態 commandMain.Parameters["@id"].Value = id; //接id的值變成參數的值 } else { commandMain.Parameters.Add("@id", SqlDbType.NVarChar); //設定參數資料型態 commandMain.Parameters["@id"].Value = Request.QueryString["id"]; //接id的值變成參數的值 } SqlDataAdapter loginAdapterMain = new SqlDataAdapter(commandMain); DataTable userMain = new DataTable(); loginAdapterMain.Fill(userMain); yacht001.InnerHtml = userMain.Rows[0]["Overview"].ToString(); yacht002.InnerHtml = userMain.Rows[0]["Dimensions"].ToString(); //下載 SqlConnection RPconnection = new SqlConnection(config); SqlCommand RPcommand = new SqlCommand($"Select ROW_NUMBER() OVER (ORDER BY id ASC) as ROW_ID, DownloadName ,(Select YachtsType from YachtsType where id=YachtsDownload.YachtsID) as YachtsName from YachtsDownload where YachtsID=@rid", RPconnection); if (string.IsNullOrEmpty($"{Request.QueryString["id"]}")) { string id = Request.QueryString["id"] ?? $"{userID.Rows[0]["id"].ToString()}"; RPcommand.Parameters.Add("@rid", SqlDbType.NVarChar); //設定參數資料型態 RPcommand.Parameters["@rid"].Value = id; //接id的值變成參數的值 } else { RPcommand.Parameters.Add("@rid", SqlDbType.NVarChar); //設定參數資料型態 RPcommand.Parameters["@rid"].Value = Request.QueryString["id"]; //接id的值變成參數的值 } RPconnection.Open(); SqlDataReader RPrereader = RPcommand.ExecuteReader(); Repeater_download.DataSource = RPrereader; //repeater的資料來源是從rereader來 Repeater_download.DataBind(); //執行繫結 }