Web Forms :: Creating Content Pages - Read Data From Database And Display On Template
Jan 4, 2011
I am working on a medium size web site and I am kind of stuck. I need to do the following
1- admin user fill a form and submit (Done)
2- the system create new page storing the info provided in step 1
how can I do that? I need a page to be created I don't want to read the data from data base and display it on a template
View 1 Replies
Similar Messages:
Dec 27, 2010
i have encountered a problem on how to load the database images to be display in the Image content in the web pages. I am currently using an Access database with a table "Images" and there are 4 columns in it. "ImageID", "ImageDescription","ImageofPicture","Description". Below is my code: Words highlighted in bold is where the problem occurs. No image is display in the Image box but theres a red cross at the top left. Image description is displaying fine in the textboxes
int MaxRows = 0;
int inc = 0;
int inc1 = 1;
int inc2 = 2;
int inc3 = 3;
System.Data.OleDb.OleDbConnection cs;
System.Data.OleDb.OleDbDataAdapter dta;
DataSet ds1;
byte[] photo_array;
protected void Page_Load(object sender, EventArgs e)
{
cs = new System.Data.OleDb.OleDbConnection();
//tell the program where the database is located
cs.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\Users\Admin\Desktop\Website1\App_Data\Database.mdb";
ds1 = new DataSet();
string sql = "SELECT * From Images ORDER BY ImageDescription ASC";
dta = new System.Data.OleDb.OleDbDataAdapter(sql, cs);
cs.Open();
dta.Fill(ds1, "Images");
Navigation();
//MaxRows equals to the total amount of records from the database
MaxRows = ds1.Tables["Images"].Rows.Count;
}
private void Navigation()
{
//get the first records from the database
DataRow dtaRow = ds1.Tables["Images"].Rows[inc];
//get column values in the row
TextBox3.Text = dtaRow.ItemArray.GetValue(1).ToString();
TextBox7.Text = dtaRow.ItemArray.GetValue(3).ToString();
DataRow dtaRow1 = ds1.Tables["Images"].Rows[inc1];
TextBox4.Text = dtaRow1.ItemArray.GetValue(1).ToString();
TextBox2.Text = dtaRow1.ItemArray.GetValue(3).ToString();
DataRow dtaRow2 = ds1.Tables["Images"].Rows[inc2];
TextBox5.Text = dtaRow2.ItemArray.GetValue(1).ToString();
TextBox8.Text = dtaRow2.ItemArray.GetValue(3).ToString();
DataRow dtaRow3 = ds1.Tables["Images"].Rows[inc3];
TextBox6.Text = dtaRow3.ItemArray.GetValue(1).ToString();
TextBox9.Text = dtaRow3.ItemArray.GetValue(3).ToString();
//if 3rd column value is not null
if (ds1.Tables[0].Rows[inc][2] != System.DBNull.Value)
{
Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox3.Text;
}
if (ds1.Tables[0].Rows[inc1][2] != System.DBNull.Value)
{
Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox4.Text;
}
if (ds1.Tables[0].Rows[inc2][2] != System.DBNull.Value)
{
Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox5.Text;
}
if (ds1.Tables[0].Rows[inc3][2] != System.DBNull.Value)
{
Image5.ImageUrl = "ImageHandler.ashx?ImageDescription=" + TextBox6.Text;
}
}
}
Code for ImageHandler.ashx:
using System;
using System.Web;
using System.Data.OleDb;
public class ImageHandler : IHttpHandler {
public void ProcessRequest (HttpContext context) {
string qry = "SELECT ImageofPicture FROM Images WHERE ImageDescription = ?";
string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\Users\Admin\Desktop\Website1\App_Data\Database.mdb";
using (OleDbConnection conn = new OleDbConnection(connect))
{
if (context.Request.QueryString["id"] != null)
{
OleDbCommand cmd = new OleDbCommand(qry, conn);
cmd.Parameters.AddWithValue("", context.Request.QueryString["id"]);
conn.Open();
using (OleDbDataReader rdr = cmd.ExecuteReader())
{
if (rdr.HasRows)
{
rdr.Read();
context.Response.ContentType = "image/jpeg";
context.Response.BinaryWrite((byte[])rdr["ImageofPicture"]);
}
}
}
}
}
public bool IsReusable {
get {
return false;
}
View 5 Replies
Feb 4, 2011
I have my repeater loading in plain text from a database right now e.g.
<td>
<a href="<%# DataBinder.Eval(Container.DataItem, "URL")%>">
<img alt="<%# DataBinder.Eval(Container.DataItem, "AltTag_Thumbnail")%>" src="<%# DataBinder.Eval(Container.DataItem, "URL_Thumbnail")%>" />
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Name") %>
</td>
My plain texts are image links and pdf URLs from a database table, in groups, in the correct order but I'm not sure how to render them correctly (sample image below shows what I am trying to render)
Is there any way to make a repeater template intelligent enough to render an "image link" OR "pdf link" based off the [type] column returned in the record?
table:
pk
Name
Type (image or pdf)
URL
Description
URL_Thumbnail (if image)
GroupId (associate these records to each other)
OrderNumber (order of these records within their GroupId)
View 4 Replies
Feb 2, 2010
I'm working on master pages. And I would like to create tabs much like firefox tabs sharing sessions which need to navigate on different pages.I tried many solution but all comes into vain.
View 3 Replies
Apr 10, 2010
I've been searching for some way to open a pdf file on a web browser control and then read the content as text to search for a particular string. So far, I found out that I can display the pdf file on the browser quite easily but I have not been able to read the content from code.
View 5 Replies
Mar 22, 2010
i want to read the pdf file uploaded by the user and to display the content of the pdf file in asp.net webpage...(not the pdf file itself ).
View 3 Replies
Jan 30, 2010
I will be getting data through wcf service coming form commerce server (instead of DB). Data which is coming will be in the form big html content with all html tags or may be a single line sentence. I should display this dynamic data into the placeholder in the content page (master content page). I have been trying but not able to load when the data is in the form of HTML page. html content or may be single lline of senetence.
View 3 Replies
Apr 19, 2010
I have over 300 content pages to create. Each has some standard styling. I would like to generate these pages, and was just wondering if there is a utility in web developer 2008 express to do so (otherwise I will just build one - but it would be great not having to do so!)
View 1 Replies
Jul 31, 2013
i am implementing a update query module.i am displaying all fields from a table for a term searched. well now i am implementing update option for the record which are displayed, i have like 70 columns in my table, and i want to know how to restrict some selected fields to be only read only while the form can be updated ?Like if user select to update a record then some selected field such as "Timestamp, UID etc some selected fields" remains READ ONLY !
View 1 Replies
Mar 5, 2013
i want to display already stored text content (sql server) into asp.net webpage at table format
Now i want to display at table.. alternatively, i want table for gridview. already view at this format. it is gridview..
QaIdQueryAnswer
7
the captain of indian cricket team Mahendra Singh Dhoni
Mahendra Singh Dhoni, commonly known as M. S. Dhoni, is an Indian cricketer and the current captain of the Indian national cricket team and the Chennai Super Kings cricket team. Born: July 7, 1981 (age 31), Ranchi Height: 1.75 m Spouse: Sakshi Dhoni (m. 2010) Salary: 3.5 million USD (2012) Education: DAV Jawahar Vidya Mandir, Shyamali Parents: Pan singh, devki devi.
View 1 Replies
Jan 22, 2011
I am running a Access Database and I have a Intranet site, Administrators can post News to a table in the Access database and Intranet users can see the news when they go to the Intranet site.
Any important/companie news is posted to the Front page and the user can access the news vie a link.
BUT;
if there are more than one post when the user clicks on the link they can only read the first post.
When they click on the 2nd link the first post opens but the Activity ID from my table in access changes!
The Activity Id changes but the page content does not, I am using form view on the Activitydetails2.aspx to view the news table
View 3 Replies
Jan 18, 2011
I have a database which signature images. Images are saved in binary.
I want to retrieve the image and display in an image control. I am kinda new to ASP and what seemed so simple has suddenly become a real problem.
The at the botom is how I would do it on a winform. Unfortunately I have no picturebox control in .asp. So how do I get the image stream into image1.imageurl?
Is there a way to put the stream into a session variable and then point to that as a url?
for instance replacing the last line below with this and then pointo to it from image1.imageurl?
[Code]....
View 9 Replies
Jul 28, 2010
I have a main master page, say MasterPageMain, and a couple of folders with couple of pages in each folder which act as a child page to that master page - MasterPageMain.
Now, I have about 10 pages in one of the folder which follows a certain pattern and they could really use a nested pages since any change on some parts needs me to change all the pages which is a pain really.
I already added a Nested master page, say NestedMasterPage - which is a child of MasterPageMain
I tried to change one of the page's <%@ Page directive to NestedMasterPage, immediately, there were a lot of errors. plus I dint know where the NestedMasterPage's children content would go.
What do I need to know in order to do this succesfully?
ps: I dint do this initially because I only had 2 pages, and I dint need this at that time, as the project grew, now i see that I should have changed it much earlier..
View 2 Replies
Sep 14, 2010
how to create dynamic template columns in gridview .
I have writing some of the code but it gives me error
The type or namespace name 'GridViewLabelTemplatecould' not be found (are you missing a using directive or an assembly reference?)
I have paste some my code
[Code]....
View 8 Replies
Nov 11, 2010
I'm putting together a page that allows the user to enter a new record in an SQL table. A bunch of the fields in the table are bit datatypes. I want to use CheckBoxes to correspond to the bit datatype columns in the SQL table.
How do I bind the checkboxes to the SQL table columns?
Here's what I have, not sure if this is right:
[Code]....
View 1 Replies
Jan 7, 2011
i am using MSSQL Server 2005 with VB in my codebehind. I have an application that I have written as a time tracking system that uses SQL Membership provider to secure the site with forms authentication. I want to add additional functionality to the site. My company has a intranet SharePoint site. I want to add something on the front page of the SharePoint site that will allow the users to clock-in/out without having to login to the application. I have a users table that is not part of the SQL Membership Provider that holds detailed information about the employees. There is a column in that table that identifies users as being able to use the clock-in system. I want to be able to display a clock-in/out button on the paged based on that column. Not all users have the ability to clock-in as their time does not need to be tracked.
View 3 Replies
Nov 17, 2010
In my "insert tempate", I formatted fields, moved them around so everything looked and acted as needed. My Question) Anyway of taking that work (including the field formatting) and copy to the "edit template" ?
VS 2010 - Language: VB
View 1 Replies
Dec 24, 2010
I have a webform developed in VB.NET and I am facing a strange problem. In the webform I have a GridView control which has two bound fields (Item # and Item name) coming from a master table and infront of these two fields I have placed a TEXTBOX control as TEMPLATE FIELD to take any value of particular item. But after filling all the textboxes when i clicked on submit button it loops thru the items and there i need to read the textbox value of that particular item in a variable but unfortunately the value is blank even the data is there. Here is the ASPX code.
[Code]....
Here is the Code behind
[Code]....
View 4 Replies
Mar 15, 2011
I need to get access to the page index of the gridview so I can correctly get some data from a coresponding array to set the cell's contol properties correctly. Below is what I've got so far. The ExcelObject is a class that houses both the data read in from an sutomer submitted excel file and a matching 2 dimensional array of characteristics that I use in this case to set the CssClass property. My problem is that when I enable paging for the gridview I don't get the proper datasource row index when the data is read by the databinder.eval; what I'm getting is the current row of the gridview being generated.
[Code]....
View 2 Replies
Aug 25, 2010
I have written some code to dynamically generate template columns for gridview which works well. However, each cell in the gridview has to be a linkbutton, which when clicked does a db update and redirects to a specific url with some parameters in it.
I have attached a click event handler to the linkbutton in the InstantiateIn method but the event does not seem to fire.
//Dynamically creating the Grid
protected void btnAnalyze_Click(object sender, EventArgs e)
View 5 Replies
Oct 5, 2010
The WorldPay payment gateway suggests using this HTML to take the customer to the payment page:
<form action="https://select-test.wp3.rbsworldpay.com/wcc/purchase" name="BuyForm" method="POST">
<input type="hidden" name="instId" value="211616">
<input type="hidden" name="cartId" value="abc123">
<input type="hidden" name="currency" value="GBP">
<input type="hidden" name="amount" value="0">
<input type="hidden" name="desc" value="">
<input type="hidden" name="testMode" value="100">
<input type="submit" value="To Payment!">
</form>
How to I put this form on my page? The problem is I have a master page which wraps the content pages content in the ASP.net form, I can't nest the forms.
View 2 Replies
Mar 14, 2010
I have a gridview that displays some records....i have added a new column to it called Edit....now when i click the edit link it should take me to a new page where i can edit that particular record only.....how do i go about it? I am using forms and no inbuilt ASP.NET controls except gridview....so i need to write queries for the same.....plz post code if possible
View 14 Replies
May 11, 2010
My requirement was to share master files among diff projects i read this doc [URL] so i use this technique to share msster pages among my diff projects in a soln but i dnt know how to reference such shared master page as if i use such
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="../masterPages/masterInvGen.Master"
View 1 Replies
Mar 25, 2011
I have 2 asp.net pages. However, now I realized that I should had placed the content of the two pages in a
MultiView control with 2 tabs (each one getting the content of the pages that I had developed).
How can I do that? Should I place the hole content of the page in a View control inside the MultiView Control? this would be a lot of work =/
View 1 Replies
Oct 25, 2010
We would like to use a contentPlaceHolder in our pages to set titles. What we would like to do is have the masterpage check the contentPlaceHolder to see if it has content in it. This way we can set up an e-mailer that will tell us what pages that don't have page titles since we have a fairly large site. We also have nested masterpages.
View 1 Replies