TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
apeterson
NA
12
0
Help with Sql parameters...
Dec 21 2004 3:49 PM
I'm having some problems getting this to work so I took out what I had been attempting to see if you all had any suggestions. So what I am trying to do is on the login page I am putting a client's name in a session variable. Once I get redirected to the Default.aspx page I want to use that information to display files from a database but only those files that the specific client should see. I have most of it working fine. The problem is I haven't been able to figure out how to pass the session object to the sql query and have it use that in the WHERE statement...Here is the code I am working with. namespace LandFormFileProject.UploadAccess { public class Default : Generic { public string CmdText = "SELECT ID, FileName, FileSize, " + "ContentType FROM Files"; protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.Label Label2; protected HtmlGenericControl allFiles; public void Page_Load(object sender, System.EventArgs e) { allFiles.InnerHtml = GetFilesFromAccessDb(); string client = (String)Session["clientLogon"]; //I know this does not go here. } private string GetFilesFromAccessDb() { StringBuilder buffer = new StringBuilder(1024); buffer.Append("
"); buffer.Append("
Name
"); buffer.Append("
Size
"); buffer.Append("
Content Type
"); buffer.Append("
"); using(OleDbConnection con = new OleDbConnection(ConnectionString)) using(OleDbCommand cmd = new OleDbCommand(CmdText, con)) { con.Open(); OleDbDataReader rd = cmd.ExecuteReader(CommandBehavior.SingleResult | CommandBehavior.CloseConnection); while(rd.Read()) { int fileId; string fileName; int fileLength; string contentType; fileId = rd.GetInt32(0); fileName = rd.GetString(1); fileLength = rd.GetInt32(2); contentType = rd.GetString(3); buffer.Append("
"); buffer.Append(fileName); buffer.Append("
[
Del
]"); buffer.Append(" [
Dnld
]"); buffer.Append("
"); buffer.Append(fileLength); buffer.Append("
"); buffer.Append(contentType); buffer.Append("
"); } rd.Close(); buffer.Append("
"); } return buffer.ToString(); } #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); } ///
/// Required method for Designer support - do not modify /// the contents of this method with the code editor. ///
private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion } }
Reply
Answers (
4
)
CDO Problem, but not always.
Need Help with INPUT type="file"