By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

Displaying records

P: n/a
Hope someone can help.
I am still learning, so no laughing please.

I am displaying records from a database using Response.Write(""); instead of
the usual datagrid method.
I am doing it this way to achieve the result I require.

However. Since I have added a button to the screen, and have had to include
the "object sender, System.EventArgs e", the Response.Write code has been
appearing within the Documents_Table(null,null); tag on the aspx screen, and
also at the top of the screen.

Why is the code appearing twice on the screen!!!!!?????

Can I put the html code into an asp:tag?? I've tried an asp:label, but this
will only display 1 record at a time.

HOPE YOU CAN HELP!!
MY CODE:

ASPX FRONTEND TAGS

<% Documents_Table(null,null); %>

<% Document_Cat(); %>

<asp:button Text="Search" ID="BTNDownloadSearch" OnClick="Documents_Table"
runat="server"/>
C# BACKEND CODE

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Web.Security;
using System.Data.Odbc;
using System.Net;

namespace NCCIS_WEB
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class Documents : System.Web.UI.Page
{
//Variables
string DocImg;
string ImgAlt;
string todayDate;
string CatCode = "NoRecord";
string CatDesc;
public Label CatDownload_Nav;
string SQLQuery;
string FileCatRef;
public Label CitrixAccess;
string UserOrg;
string UserPerm;
string UserAccessLevel;
string TempAccessLevel;
string SQLKeyword;
string SQLPartnership;
string SQLContent;
//string DocumentDownload;

//public DataList temp;

public TextBox Keyword;
public TextBox Partnership;
public TextBox Content;
public Button BTNDocumentsSearch;

GlobalClass GlobalFuncs = new GlobalClass();

private void Page_Load(object sender, System.EventArgs e)
{
//Initial Page Check - Security
GlobalFuncs.InitPageCheck();
CitrixAccess.Text = GlobalFuncs.CitrixLabel;

if (!Page.IsPostBack)
{
Documents_Table(null,null);
}

}

public void Document_Cat() {

OdbcConnection Odbccon1 = new
OdbcConnection(GlobalFuncs.GlobalODBCConnString);
Odbccon1.Open();

OdbcDataAdapter adpt1 = new OdbcDataAdapter("select code,description from
documentcat", Odbccon1);

DataSet dset1 = new DataSet();
DataTable dt1 = dset1.Tables.Add("DocumentCat");

adpt1.Fill(dset1, "DocumentCat");

foreach (DataRow dr in dt1.Rows) {

Response.Write("<tr>");
Response.Write("<td><li class='body_text_white'><a
href='documents.aspx?FileCatRef="+dr["code"]+"'
class='body_text_white'>"+dr["description"]+"</a></li></td>");
Response.Write("</tr>");

}

Response.Write("<tr>");
Response.Write("<td><li class='body_text_white'><a
href='documents.aspx?FileCatRef=0' class='body_text_white'>Display All
Categories</a></li></td>");
Response.Write("</tr>");

}

public void Documents_Table(object sender, System.EventArgs e) {

string StrKeyword = Keyword.Text;
string StrPartnership = Partnership.Text;
string StrContent = Content.Text;

FileCatRef = Request.Params["FileCatRef"];
HttpCookie cookie = Context.Request.Cookies["NCCIS_Cookie"];

string cookieCXUser = cookie["CXUser"].ToString().Trim();
string cookieUserName = cookie["UserName"].ToString().Trim();
string cookieAccessLevel = cookie["AccessLevel"].ToString().Trim();

OdbcConnection Odbccon = new
OdbcConnection(GlobalFuncs.GlobalODBCConnString);
Odbccon.Open();

OdbcCommand cmd3 = new OdbcCommand("select UserCode,CXPartnership from
CX_USERS where UserCode = '"+cookieCXUser+"'", Odbccon);
OdbcDataReader rdr3 = cmd3.ExecuteReader();

while (rdr3.Read()) {
UserPerm = rdr3.GetString(0);
UserOrg = rdr3.GetString(1);
}

rdr3.Close();

OdbcCommand cmd5 = new OdbcCommand("select CanSeeLevel from SECURITY
where Level = '"+cookieAccessLevel+"'", Odbccon);
OdbcDataReader rdr5 = cmd5.ExecuteReader();

while (rdr5.Read()) {
TempAccessLevel = rdr5.GetString(0);
}

rdr5.Close();

//LEVEL FORMATING
UserAccessLevel = TempAccessLevel.Replace(" ","").Replace(",","','");

todayDate =
DateTime.Now.ToLocalTime().ToString("yyyy/MM/dd").Trim();

if (FileCatRef == "0"){
SQLQuery = "select
refno,doctype,added,addedby,title,description,orgf ilename,\"file
cat\",securityorg,securityuser,securitylevel from documents WHERE
contenttype = 'DOCUMENT' "+SQLKeyword+" "+SQLPartnership+" "+SQLContent+"
AND (ExpiryDate >= '"+todayDate+"' OR ExpiryDate is NULL) AND (SecurityLevel
IN ('"+UserAccessLevel+"')) AND (SecurityOrg like '%"+UserOrg+"%' OR
SecurityOrg IS NULL) AND (SecurityUser like '%"+UserPerm+"%' OR SecurityUser
IS NULL) order by \"file cat\" asc, added desc";
} else {
SQLQuery = "select
refno,doctype,added,addedby,title,description,orgf ilename,\"file
cat\",securityorg,securityuser,securitylevel from documents WHERE
contenttype = 'DOCUMENT' "+SQLKeyword+" "+SQLPartnership+" "+SQLContent+"
AND (ExpiryDate >= '"+todayDate+"' OR ExpiryDate is NULL) AND (SecurityLevel
IN ('"+UserAccessLevel+"')) AND (SecurityOrg like '%"+UserOrg+"%' OR
SecurityOrg IS NULL) AND (SecurityUser like '%"+UserPerm+"%' OR SecurityUser
IS NULL) AND \"file cat\" = "+FileCatRef+" order by added desc";
}

if (StrKeyword == "") {
SQLKeyword = "";
} else {
SQLKeyword = "AND title LIKE '%"+StrKeyword+"%'";
}

if (StrContent == "") {
SQLContent = "";
} else {
SQLContent = "AND description LIKE '%"+StrContent+"%'";
}

if (StrPartnership == "") {
SQLPartnership = "";
} else {
SQLPartnership = "AND description LIKE '%"+StrPartnership+"%'";
}

OdbcDataAdapter adpt = new OdbcDataAdapter(SQLQuery, Odbccon);

DataSet dset = new DataSet();
DataTable dt = dset.Tables.Add("Documents");

adpt.Fill(dset, "Documents");

foreach (DataRow dr in dt.Rows) {

OdbcCommand cmd = new OdbcCommand("select * from DOCUMENTCAT where Code =
'"+dr["file cat"]+"'", Odbccon);
OdbcDataReader rdr = cmd.ExecuteReader();

while (rdr.Read()) {
CatDesc = rdr.GetString(1).Trim();
}

rdr.Close();

OdbcCommand cmd1 = new OdbcCommand("select * from DOCTYPE where
Code = '"+dr["doctype"]+"'", Odbccon);
OdbcDataReader rdr4 = cmd1.ExecuteReader();

while (rdr4.Read()) {
DocImg = rdr4.GetString(2).Trim();
ImgAlt = rdr4.GetString(1).Trim();
}

if (CatCode == dr["file cat"].ToString()){

Response.Write("<tr class='body_text'>");
Response.Write("<td align='right' valign='top' width='100%'
colspan='3'>");
Response.Write("<table width='98%' border='0' cellpadding='0'
cellspacing='0'>");
Response.Write("<tr class='body_text'>");
Response.Write("<td valign='top'><b>"+ dr["Title"] +"</b></td>");
Response.Write("<td valign='top' align='right'><b>Posted:</b>&nbsp;"+
dr["Added"].ToString().Remove(10, 9) +"</td>");
Response.Write("<td align='right' valign='top'><a
href='docdownload.aspx?docref="+dr["refno"]+"' target='doc'
onclick='tracker.location.href=\"tracker.aspx?docr ef="+dr["refno"]+"\"'><img
src='../images/"+DocImg+"' border='0' alt='"+ImgAlt+" -
"+dr["orgfilename"]+"'></a></td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan='3' class='body_text' valign='top'>"+
dr["Description"] +"</td>");
Response.Write("</tr>");
Response.Write("</table>");
Response.Write("</td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan='3'><hr></td>");
Response.Write("</tr>");

} else {

Response.Write("<tr class='body_text'>");
Response.Write("<td valign='top' colspan='3' class='CatTitle'><b>::
"+CatDesc+" ::</b></td>");
Response.Write("</tr>");
Response.Write("<tr class='body_text'>");
Response.Write("<td align='right' valign='top' width='100%'
colspan='3'>");
Response.Write("<table width='98%' border='0' cellpadding='0'
cellspacing='0'>");
Response.Write("<tr class='body_text'>");
Response.Write("<td valign='top'><b>"+ dr["Title"] +"</b></td>");
Response.Write("<td valign='top' align='right'><b>Posted:</b>&nbsp;"+
dr["Added"].ToString().Remove(10, 9) +"</td>");
Response.Write("<td align='right' valign='top'><a
href='docdownload.aspx?docref="+dr["refno"]+"' target='doc'
onclick='tracker.location.href=\"tracker.aspx?docr ef="+dr["refno"]+"\"'><img
src='../images/"+DocImg+"' border='0' alt='"+ImgAlt+" -
"+dr["orgfilename"]+"'></a></td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan='3' class='body_text' valign='top'>"+
dr["Description"] +"</td>");
Response.Write("</tr>");
Response.Write("</table>");
Response.Write("</td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan='3'><hr></td>");
Response.Write("</tr>");

CatCode = dr["file cat"].ToString();

}

rdr4.Close();
}
Odbccon.Close();
}
}
Nov 17 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.