Javascript printing question? Using C# , ASP.NET & Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michelle Keys (mathieusgirl2002_at_yahoo.com)
Date: 10/31/04

Next message: Wes: "Re: Reusing code without creating a class library."
Previous message: Guadala Harry: "Re: PLEASE HELP!!!!!!!"
Messages sorted by: [ date ] [ thread ]

Date: Sat, 30 Oct 2004 21:30:22 -0700

I am trying to call a print function to print a string from a database
using javascript.
Which is RC_DATA of Varchar2(2500).
This is a javascript is not being used. I have a thing that needs to be
modified:
if(e.CommandName =="Print")
{
                          string parsedreceipt = null;
     parsedreceipt = DecodeReceipt (e.Item.Cells[3].Text);
     Session["parsedreceipt"] = parsedreceipt;
               /// Response.Write("<script
language=\"JavaScript\">window.OpenNewWin('print.aspx', null,
'height=200,width=400');");
     Response.Write("<script
language=\"JavaScript\">window.open('print.aspx', null,
'height=200,width=400');</script>");
}

I am confused on what to do? I just want to print the string.

===================================
aspx

<%@ Register TagPrefix="cc1" Namespace="ActiveUp.WebControls"
Assembly="ActiveDateTime" %>
<%@ Page Language="c#" Codebehind="Receipts.aspx.cs"
AutoEventWireup="false" Inherits="MSPOS.Receipt" %>
<%@ Register TagPrefix="uc1" TagName="logout"
Src="Engine/Controls/logout.ascx" %>
<%@ Register TagPrefix="mspos" TagName="header"
Src="Engine/Controls/header.ascx" %>
<%@ Register TagPrefix="mspos" TagName="footer"
Src="~/Engine/Controls/footer.ascx" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<script language="javascript">
     function OpenNewWin(Receipt)
     {
     winNew =
window.open("print.aspx?","printwindow","toolbar=no,scrollbar=no,height=
200,width=300,resizable=no,top=200,left=200");
     var PrintHtml ="<Table cellpadding=5 cellspacing=5 broder=0>";
           PrintHtml = PrintHtml + "<TR><TD>Receipt</TD><TD
width=5>:</TD><TD>" + Receipt + "</TD></TR>";
           PrintHtml = PrintHtml + " </TABLE>";
           PrintHtml = PrintHtml + " <DIV id=butPanel align=center>
<input Type=button value=' Print '
onclick=Javascript:document.getElementById('butPanel').style.display='no
ne';window.print();document.getElementById('butPanel').style.display='';
>";
           PrintHtml = PrintHtml + " <input type=button value=cancel
onclick=javascript:window.close();></Div>";
           winNew.document.body.innerHTML=PrintHtml;
           winNew.focus();
     }
     </script>
</HEAD>
<BODY leftMargin="0" background="images/bg.gif" topMargin="0">
<form id="Form1" action="database.aspx" method="post" runat="server">
<strong>
<P><mspos:header id="Header1" runat="server"></mspos:header><BR>
<FONT face="Verdana" size="2"></FONT>
</P>
<FONT face="Verdana" size="2">
<P align="center">
<asp:ImageButton id="MainMenu" runat="server"
ImageUrl="images/mainmenu.jpg"></asp:ImageButton></P>
</FONT><FONT face="Verdana" size="2">
<DIV align="center">
<TABLE id="Table2" height="118" cellSpacing="1" cellPadding="1"
width="355" border="0">
<TR>
<TD vAlign="top" width="147" colSpan="1" rowSpan="4">
<P><asp:radiobuttonlist id="Group_RadioButtonList" runat="server"
BorderWidth="0px" CellSpacing="1" CellPadding="1"
                                                       Height="111px"
Font-Bold="True" Font-Size="12px" Font-Names="Verdana"
                                                       Width="35px"
BackColor="#FEF9E9">
<asp:ListItem Value="PayNumber">1</asp:ListItem>
<asp:ListItem Value="Cashier">2</asp:ListItem>
<asp:ListItem Value="StartDate">3</asp:ListItem>
</asp:radiobuttonlist></P>
  
</TD>
<TD noWrap colSpan="1" rowSpan="1">Payment Number:</TD>
<TD vAlign="middle" noWrap width="200" colSpan="1"
rowSpan="1"><asp:textbox id="txtPayment" runat="server"
MaxLength="10"></asp:textbox></TD>
</TR>
<TR>
<TD width="240">Cashier Number:</TD>
<TD><asp:textbox id="txtCashier" runat="server"
MaxLength="8"></asp:textbox></TD>
</TR>
<TR>
<TD width="240" height="10">Start Date:</TD>
<TD height="10"><cc1:activedatetime id="ActiveDateTime3" runat="server"
AllowNull="False" MonthNamesDisabled="True"

Format="DAY;-;MONTH;-;YEAR"></cc1:activedatetime></TD>
</TR>
<TR>
<TD width="240">End Date:     
</TD>
<TD><cc1:activedatetime id="ActiveDateTime4" runat="server"
AllowNull="False" MonthNamesDisabled="True"

Format="DAY;-;MONTH;-;YEAR"></cc1:activedatetime></TD>
</TR>
<TR>
<TD width="240"></TD>
<TD><asp:button id="btnRunQuery" onclick="btnRunQuery_Click"
runat="server" text="Run Query" type="submit"></asp:button></TD>
</TR>
</TABLE>
</DIV>
</FONT></strong>
<DIV>
<br>
<strong>Results of:<BR>
</strong>
</DIV>
<DIV align="center">
<asp:datagrid id="ReceiptsDataGrid" runat="server" BorderWidth="3"
CellSpacing="1" CellPadding="1"
                         Height="144px" Width="500px"
OnItemDataBound="ReceiptsDataGrid_ItemDataBound"
                         OnItemCommand="ReceiptsDataGrid_ItemCommand"
HeaderStyle-Font-Bold="True"
                         maintainviewstate="false" GridLines="None"
BorderStyle="Outset" font-size="XX-Small"
                         font-names="Verdana" BorderColor="#CCCC99"
AutoGenerateColumns="False">
<AlternatingItemStyle Wrap="False"
BackColor="PaleGoldenrod"></AlternatingItemStyle>
<ItemStyle Wrap="False" BackColor="Beige"></ItemStyle>
<HeaderStyle Font-Size="14px" Font-Bold="True" ForeColor="White"
BackColor="#954896"></HeaderStyle>
<Columns>
<asp:BoundColumn DataField="RC_PAYMNB" HeaderText="Payment Number
"></asp:BoundColumn>
<asp:BoundColumn DataField="RC_CASHNB" HeaderText="Cash
Number"></asp:BoundColumn>
<asp:BoundColumn DataField="RC_DATE"
HeaderText="Date"></asp:BoundColumn>
<asp:BoundColumn DataField="RC_DATA" Visible="False"
HeaderText="Data"></asp:BoundColumn>
<asp:TemplateColumn>
<ItemTemplate>
<asp:Button CommandName="View" Text="View" Runat="server"
ID="Button1"></asp:Button>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn>
<ItemTemplate>
<asp:Button CommandName="Print" Text="Print" Runat="server"
ID="Button2"></asp:Button>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
<P align="center">
<uc1:logout id="Logout1" runat="server"></uc1:logout></P>
</form>
</DIV></FORM>
</BODY>
</HTML>

cs
====================================
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.Odbc;
using System.Text;
using System.Drawing;
using System.Data.Common;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace MSPOS
{
     /// <summary>
     /// Summary description for Receipts.
     /// </summary>
     public class Receipt : System.Web.UI.Page
     {
          protected System.Web.UI.WebControls.RadioButtonList
Group_RadioButtonList;
          protected System.Web.UI.WebControls.DataGrid ReceiptsDataGrid;
          private DataSet ddlDataSet = new DataSet();
          private OdbcConnection myConnection = new
OdbcConnection("DSN=MSPOS;UID=system;PWD=system");
          protected System.Web.UI.WebControls.Button btnRunQuery;
          protected System.Web.UI.WebControls.Button Button2;

          protected System.Web.UI.WebControls.TextBox txtPayment;
          protected System.Web.UI.WebControls.TextBox txtCashier;

          private DataSet ddlDataSet1 = new DataSet();
          private DataSet ddlDataSet2 = new DataSet();
          protected ActiveUp.WebControls.ActiveDateTime ActiveDateTime3;
          protected ActiveUp.WebControls.ActiveDateTime ActiveDateTime4;
          private DataSet ddlDataSet3 = new DataSet();
          protected System.Web.UI.WebControls.ImageButton MainMenu;
          protected System.Web.UI.WebControls.Button Button1;
          protected string AccessLevel = null;

          private void Page_Load(object sender, System.EventArgs e)
          {
               // Put user code to initialize the page here
               if (!Page.IsPostBack)
               {
                    ActiveDateTime3.Date = System.DateTime.Today.Date;
                    ActiveDateTime4.Date = System.DateTime.Today.Date;
               }
          }

          private void MainMenu_Click(Object sender, ImageClickEventArgs
e)
          {
               AccessLevel = Session["Authenticated"].ToString();
               if (AccessLevel == "1")
                    Response.Redirect("AdminStart.aspx");
               else if (AccessLevel == "2")
                    Response.Redirect("CCManStart.aspx");
               else if (AccessLevel == "3")
                    Response.Redirect("CCashierStart.aspx");
               else if (AccessLevel == "4")
                    Response.Redirect("CashierStart.aspx");
               else Response.Redirect("Error.aspx");
          }

          #region Web Form Designer generated code
          override protected void OnInit(EventArgs e)
          {
               //
               // CODEGEN: This call is required by the ASP.NET Web Form
Designer.
               //
               InitializeComponent();
               base.OnInit(e);
          }

          /// <summary>
          /// Required method for Designer support - do not modify
          /// the contents of this method with the code editor.
          /// </summary>
          private void InitializeComponent()
          {
               this.MainMenu.Click += new
System.Web.UI.ImageClickEventHandler(this.MainMenu_Click);
               this.Group_RadioButtonList.SelectedIndexChanged += new
System.EventHandler(this.Group_RadioButtonList_SelectedIndexChanged);
               this.txtCashier.TextChanged += new
System.EventHandler(this.txtCashier_TextChanged);
               this.btnRunQuery.Click += new
System.EventHandler(this.btnRunQuery_Click);
               this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

          public string DecodeReceipt (string szBill)
          {
               string szNewBill="";

               // Create an ASCII encoding.
               Encoding ascii = Encoding.ASCII;

               Byte[] encodedBytes = ascii.GetBytes(szBill);

               foreach (Byte a in encodedBytes)
               {
                    if (a ==10 || a ==15 ||a==18 ||a ==27)
                    {}
                    else if (a == 13)
                         szNewBill = szNewBill + "\\n";
                    else
                         szNewBill = szNewBill +(char) a;

               }
               return szNewBill;
          }

          private void txtPayment_TextChanged(object sender,
System.EventArgs e)
          {

          }

          private void txtCashier_TextChanged(object sender,
System.EventArgs e)
          {

          }

//**********************************************************************
*
          // Get RC_PAYMND and populate dataset
          public DataSet BindRC_PAYMND(string searchstring)
          {
               OdbcConnection myConnection = new
OdbcConnection("DSN=MSPOS;UID=system;PWD=system");

               // Populate the ddlDataSet1
               myConnection.Open();
               string strSQLDDL = @"SELECT RC_PAYMNB FROM TBRECEIPTS
WHERE RC_PAYMNB='"+searchstring+"'";
               OdbcDataAdapter myDataAdapter = new
OdbcDataAdapter(strSQLDDL, myConnection);
               ddlDataSet1.Clear();
               myDataAdapter.Fill(ddlDataSet1, "ddlRC_PAYMNB");
               myDataAdapter.Dispose();
               myDataAdapter = null;
               myConnection.Close();
               strSQLDDL = null;
               return ddlDataSet1;
          }

//**********************************************************************
*

//**********************************************************************
*
          // Get RC_CASHND and populate dataset
          public DataSet BindRC_CASHND(string searchstring)
          {
               OdbcConnection myConnection = new
OdbcConnection("DSN=MSPOS;UID=system;PWD=system");

               // Populate the ddlDataSet2
               myConnection.Open();
               string strSQLDDL = @"SELECT RC_CASHNB FROM TBRECEIPTS
WHERE RC_CASHNB='"+searchstring+"'";
               OdbcDataAdapter myDataAdapter = new
OdbcDataAdapter(strSQLDDL, myConnection);
               ddlDataSet2.Clear();
               myDataAdapter.Fill(ddlDataSet2, "ddlRC_CASHNB");
               myDataAdapter.Dispose();
               myDataAdapter = null;
               myConnection.Close();
               strSQLDDL = null;
               return ddlDataSet2;
          }

//**********************************************************************
*

//**********************************************************************
*
          // Get RC_CASHND and populate dataset with RC_CASHND and
RC_DATE
          public DataSet BindRC_DATE()
          {
               OdbcConnection myConnection = new
OdbcConnection("DSN=MSPOS;UID=system;PWD=system");

               // Populate the ddlDataSet3
               myConnection.Open();
               string strSQLDDL = @"SELECT RC_DATE FROM TBRECEIPTS";
               OdbcDataAdapter myDataAdapter = new
OdbcDataAdapter(strSQLDDL, myConnection);
               ddlDataSet3.Clear();
               myDataAdapter.Fill(ddlDataSet3, "ddlRC_DATE");
               myDataAdapter.Dispose();
               myDataAdapter = null;
               myConnection.Close();
               strSQLDDL = null;
               return ddlDataSet3;
          }

//**********************************************************************
*

          public void ReceiptsDataGrid_ItemDataBound(object
sender,System.Web.UI.WebControls.DataGridItemEventArgs e)
          {
               if(e.Item.ItemType == ListItemType.AlternatingItem ||
e.Item.ItemType==ListItemType.Item )
               {
                    string parsedreceipt = null;
                    string strValue="Javascript:OpenNewWin('"+
DecodeReceipt(e.Item.Cells[3].Text) + "');";
                    Button btn = ( (Button)
e.Item.FindControl("Button2") );
                    Session["parsedreceipt"] = parsedreceipt;
                    btn.Attributes.Add("Onclick",strValue);

               }

}

//**********************************************************************
*

          public void ReceiptsDataGrid_ItemCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
          {
               ListItemType oType = ((ListItemType)e.Item.ItemType);
               if(oType == ListItemType.Item || oType ==
ListItemType.AlternatingItem)
               {
                    e.Item.Attributes.Add("onmouseover",
"this.style.backgroundColor='lightblue'");
                    e.Item.Attributes.Add("onmouseout",
"this.style.backgroundColor='Beige'");
               }

               if(e.CommandName =="View")
               {
                    string parsedreceipt = null;
                    parsedreceipt = DecodeReceipt
(e.Item.Cells[3].Text);
                    StringBuilder strAlert = new StringBuilder();
                    strAlert.Append("<script language=javascript>
alert('");
                    strAlert.Append("Receipt: " +
parsedreceipt + "\\n");
                    strAlert.Append("');</script>");

this.RegisterStartupScript("startup",strAlert.ToString());
}

               if(e.CommandName =="Print")
               {
                    string parsedreceipt = null;
                    parsedreceipt = DecodeReceipt
(e.Item.Cells[3].Text);
                    Session["parsedreceipt"] = parsedreceipt;
            /// Response.Write("<script
language=\"JavaScript\">window.OpenNewWin('print.aspx', null,
'height=200,width=400');");
                    Response.Write("<script
language=\"JavaScript\">window.open('print.aspx', null,
'height=200,width=400');</script>");

               }

}

          private void Group_RadioButtonList_SelectedIndexChanged(object
sender, System.EventArgs e)
          {

          }

          public void btnRunQuery_Click(object sender, System.EventArgs
e)
          {
               string select_statement = "SELECT RC_PAYMNB, RC_CASHNB,
RC_DATE, RC_DATA FROM TBRECEIPTS";
               string DateString1 = ActiveDateTime3.Date.Day.ToString()
+ "-" + ActiveDateTime3.Date.Month.ToString() + "-" +
ActiveDateTime3.Date.Year.ToString();
               string DateString2 = ActiveDateTime4.Date.Day.ToString()
+ "-" + ActiveDateTime4.Date.Month.ToString() + "-" +
ActiveDateTime4.Date.Year.ToString();

               switch (Group_RadioButtonList.SelectedIndex)
               {
                    case 0:
                         select_statement += " Where RC_PAYMNB='" +
txtPayment.Text + "'";
                         break;
                    case 1:
                         select_statement += " Where RC_CASHNB='" +
txtCashier.Text + "'";
                         break;
                    case 2:
                         select_statement += " Where To_Date(RC_DATE,
'dd-mm-yyyy') <= '" + DateString2.ToString() + "' And To_Date(RC_DATE,
'dd-mm-yyyy') >= '" + DateString1.ToString() + "'";
                         break;
               }

OdbcConnection myConnection = new
OdbcConnection("DSN=MSPOS;UID=system;PWD=system");

               // Populate the ddlDataSet1
               myConnection.Open();
               string strSQLDDL = select_statement;
               OdbcDataAdapter myDataAdapter = new
OdbcDataAdapter(strSQLDDL,myConnection);
               ddlDataSet1.Clear();
               myDataAdapter.Fill(ddlDataSet1);
               myDataAdapter.Dispose();
               myDataAdapter = null;
               myConnection.Close();
               ReceiptsDataGrid.DataSource = ddlDataSet1.Tables[0];
               ReceiptsDataGrid.DataBind();

        }

          private void ReceiptsDataGrid_SelectedIndexChanged(object
sender, System.EventArgs e)
          {

          }

}
}

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Next message: Wes: "Re: Reusing code without creating a class library."
Previous message: Guadala Harry: "Re: PLEASE HELP!!!!!!!"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Getting Starting in JavaScript et al
... To date I have had three epiphanies where I have suddenly "got" javascript and realized how utterly diffident my previous understanding of the subject had been. ... Identifying and understanding the types of values that javascript uses; that there are 5 primitive data types (boolean, number, string, null and the undefined type). ... tab would then contain the tab character, ... Javascript has escape sequences that start with a backslash, but there are a number of types. ...
(comp.lang.javascript)
Re: Dynamic variable names
... In Javascript, being "object" oriented, you can access every element ... For instance knowing that a variable is named foo ... string, If a string, it should gon in between quotes. ... ALSO out of the window object, if a variable belongs to it. ...
(comp.lang.javascript)
Re: UTF8 conversion
... Unicode characters. ... Javascript as it represents a string of bytes (it represents ... a string of characters through recode with UTF8 as an output ...
(comp.lang.javascript)
Re: toggle text in different locations on the same page
... have only really dabbled in javascript. ... I have a working text toggle in place on a web page. ... Not here as the inherited default style for a DIV ... the link is cancelled by returning false from the onclick handler (or ...
(comp.lang.javascript)
Re: Implicit object constructor misinterpretation
... In Javascript, being an identifier is a tokenization concept. ... The concept of "string literal" is again a tokenization/parsing ... String literals are sequences of characters flanked by either ...
(comp.lang.javascript)