protected void Page_Load(object sender, EventArgs e) { try { int id = 0; if (Request.QueryString["product"].Length > 0) { id = Convert.ToInt32(Request.QueryString["product"]); } string strConn = null; strConn = GetConnection.GetConnectionStringByName(); SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = new SqlCommand("select DataSheetUrl,TitlePr,InfoPr from chproduct where ID=@ID", conn); SqlDataReader sdr; try { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ID", id); cmd.Connection = conn; conn.Open(); sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { if (sdr["DataSheetUrl"].ToString() == "-1") { dataSheetDowloadLink.Visible = false; } else { dataSheetDowloadLink.Visible = true; dataSheetDowloadLink.Text = "download datasheet"; dataSheetDowloadLink.NavigateUrl = "DataSheet/" + sdr["DataSheetUrl"].ToString(); } lblTitle.Text = sdr["TitlePr"].ToString(); ltrContent.Text = sdr["InfoPr"].ToString(); } } } catch (Exception ex) { ltrContent.Text = ex.Message; } } catch { Response.Redirect("ugc.aspx"); } }
protected string TextLiteral() { string str = ""; string strConn = null; strConn = GetConnection.GetConnectionStringByName(); SqlConnection conn = new SqlConnection(strConn); try { string query = "select * from tbl_Image where AlbumID=@AlbumID"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader sdr; cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@AlbumID", Request.QueryString["AlbumID"].ToString()); conn.Open(); sdr = cmd.ExecuteReader(); string name_temp; if (sdr.HasRows) { while (sdr.Read()) { name_temp = sdr["ImageName"].ToString(); string thumb = sdr["Thumb"].ToString(); string temp_image_url = sdr["ImageUrl"].ToString(); if (temp_image_url == "") { temp_image_url = "/image/"; } string[] array = new string[2]; str += "<div style='width:200px;height:170px;overflow:hidden;float:left;border:#CCC double thick; border-radius:10px;margin-left:65px;margin-bottom:50px'> <a class=\"vlightbox1\" href='" + temp_image_url + "' style='' title='" + name_temp + "'> <img src='" + thumb + "' style='opacity: 1;' /> </a></div>"; } } } catch (Exception ex) { string stri = ex.Message; Response.Redirect("AlbumFarsi.aspx"); } finally { conn.Close(); } return(str); }
protected void Page_Load(object sender, EventArgs e) { try { if (Request.QueryString["ChemixId"] == "") { Response.Redirect("www.chemixco.com"); } else { string strConn = null; strConn = GetConnection.GetConnectionStringByName(); SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = new SqlCommand("Select PageContent from chcms where Id=@Id", conn); SqlDataReader sdr; try { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Id", Request.QueryString["ChemixId"]); cmd.Connection = conn; conn.Open(); sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { ltrContent.Text = sdr["PageContent"].ToString(); } } } catch (Exception ex) { } finally { cmd.Dispose(); conn.Close(); } } } catch { Response.Redirect("www.chemixco.com"); } }
public string SelectDescription() { string str = null; string strConn = null; strConn = GetConnection.GetConnectionStringByName(); SqlConnection conn = new SqlConnection(strConn); try { string query = "SELECT [Desc] FROM [dbo].[About] Where elanguage=2"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader sdr; cmd.CommandType = CommandType.Text; cmd.Connection = conn; conn.Open(); sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { str = Server.HtmlDecode(sdr["Desc"].ToString()); } } } catch (Exception ex) { string st = ex.Message; } finally { conn.Close(); } return(str); }