I am not sure if this is possible but is there a way to change the color of a datagrid cell when a condition is met? For example, let's say if percent_changed >10 then change cell color to orange if percent_changed >25 then change cell color to red.
View RepliesI am looking for a way to display a colour selector so that a user can choose a colour.
Exactly like the font colour selector in this text editor. Where the user would click the dropdown box
and see the colours. There may be multiple ones on a page, and I want to store the value to use after
I have problem to change colour of a product taken from the database. For your info, currently i'm doing my post graduate project on Online Shopping. One of the features that i must include in the project is changing colour of a selected product. The product has the motive on it and i have to change colour for both - the background and the motive of the product. i have tried many coding but it does not work. Can somebody please help me....?
View Replies View RelatedI'm trying to change the colour of the session("name") variable below, but not having any luck. I need the name to be a different colour than the "logged in as". Any suggestions? Code:
View Replies View RelatedI have a form which I'm trying to get the writing to change colour after 48 hours and then 336 hours. Fields that need to change:
InstallationDate - compare the SignedDate with the InstallationDate. If the InstallationDate is older than 48 hours then the text needs to change to red. InstallComplete - compare the SignedDate with the InstallComplete field. If the InstallComplete field is still not filled [null] after 48 hours of the signed date then the text needs to change to red.
I want to change the font colour to red if a recordset value is 'high' but i dont know where to put the font tags, Heres what i got so far:
<td width="13%" align="center"><% if rs("priority") = "High" then response.write rs("priority")
else response.write rs("priority") %></td>
But where would i put the font tag and the colour, so it coloured the priorities marked as high red?
What I would like is during the time the event actually occurs I want the field in the table to change colour and return to it's original colour when the time to expires.
I've written some ASP to do this, and it half works, but instead of colouring one event, it colours everything (because I use a repeat region i think). Code:
What I would like is shown in the script below:
response.write rsuser("event_Day") & " "
response.write rsuser("event_Date") & " "
response.write rsuser("event_Month") & " " & " "
response.write rsuser("event_Year") & " " & " "
<font color="#990000">response.write rsuser("event_SoldOut")</font>
rsuser.movenext
I would like for the 5th response.write to be in a different font colour, but its not allowing me to do this.
I have to upload one excel file. In that excel file I need to check the availability of data in particular cells and also the worksheet name. If the data is not available at particular cell, say for eg: $F1, an error should be thrown to user saying that the data is manadatory. How to do that? How to read the particular cell in ASP? If anybody knows the code, please send the same.
View Replies View RelatedI have been toying with various resources I have found on here and the web - but would like to know specifically how to get the contents of an excel cell on a particular sheet using .asp?.
View Replies View RelatedI am displaying Amount in DataGrid in a column called Total. I want to calculate Grand Total and display it in a text box how do i loop through DataGrid to Claculate the
Grand Total.
I have a website that uses a database and ASP to create the pages from this database. Currently I have an application written that connects to the remote database and allows me to add/change/delete records from the various tables.
I want to get rid of my stand alone application and integrate this ability into the website itself. i.e. Have the browser login and then be able to operate on the tables using some sort of DataGrid like component. There seems to be a lot out there for .NET but I was wondering if there was something available for "classic" ASP?
I am working on a asp.net application that retrieves data from a access database. I have three related tables (Customers, Orders, Payment). I am using a ddl to provide a list of customers that when clicked on populates some textboxes with customer data.
i would like to populate a datagrid with order and payment information that relates to the specific customer clicked on in the ddl. Does anyone know how I might accomplish this?
I am displaying the table using ASPGRID.In Edit mode,the column2 displays an array of values.On selection of a value from Column2 the column3 value should be automatically populated based on the Column2 value.
The cell change event of column2 should be captured and display the column3 values based on the column2 value. Is there any way to track the cell change?
Is it possible to set a cell property in Excel from an ASP page. We have numerical data that is taken from a database and then displayed in Excel. I would like ideally all the data to be set at 2 decimal places, is there anyway of setting this from the ASP page?
View Replies View RelatedI have a table with coloured cells. I want to print out the table via IE with the coloured cells. But the outcome of the table does not have the cells coloured.
Are there ways to force out the colouring of the cells in the print outs?Either via php/asp/css or any means.
I'm having trouble with using massege in my program. This is supposed to select one radiobutton from a radiobuttonlist. but when I try this I get errors
The type or namespace name 'Message' could not be found (are you missing a using directive or an assembly reference?) Code:
I was wondering, is it possible to make a datagrid using classic ASP? I know that ASP.net is a much simpler method of creating one but my website is not based on ASP.net, it's based on classic ASP.
So I can't use .net. Or can I? Well I'm not sure if ASP can do this but I know that using loops and stuff like that, I can create something like it.
Can any one give some idea/code in exporting the contents of the datagrid in to a PDF format in web application?
I have to export contents without using any third party component or crystal reports.
I have a datagrid on my form which is bound to the table data returned from a function module in SAP. What I want to do is be able to get the data in the nth row mth column of the datagrid. Can anybody help on this.
View Replies View RelatedHow to upload Images to SQL Server database using ASP.NET tools. Also how to retrieve those saved images from SQL Server and display them onto DataGrid.
View Replies View RelatedI have a datagrid with a column for editing the data inside. On the page I have a button that runs Client-Side VBSCRIPT to export the datagrid to Excel. (We don't have Excel on the server, so it has to run client-side).
I used the outerHTML function and the datagrid goes right into Excel but the only problem is the "Edit" buttons show up. One for each row. I thought maybe they were just in that column-- but they aren't-- i can delete all columns and they remain.
I have tried to find a way to hide that column before the export using client-script but have found nothing. Anyone have any good suggestions? Either on hiding the column, or removing the buttons in Excel?
My asp page pulls from the database into a table for example
Name ITEM1 ITEM2 ITEM3
AName AITEM ANOTHER SOMETHING
What i want to do is create a mouseover based on what that content is, rather like when you hold your mouse over a image and view what the alt tage says i want it to display a short description of what the item means: I.E
Name ITEM1 ITEM2 ITEM3
AName AITEM ANOTHER SOMETHING <---- users mouseover "Something = Something that has a description"
This has to be dynamic based on the value in the table cell
Anyone have any ideas?
I came across a problem when importing my data results into Excel. The whole table outputs perfectly but a particular field which is generally large (13 characters long) presents as some random integer which shouldn't be the case. I click on Tools -> Format Cells and change its value to number and to 0 decimal places and great it works.
Am I able to do this before I get into Excel? Or would this always have to be done by the user?
Is anyone aware of a 255 character limit when reading data from a particular Excel cell? I'm experiencing when pulling straight text from an Excel spreadsheet, which otherwise works fine. Right at 255 characters, the data is truncated and I only see that bit of information.I've searched Google and came up with a few registry modifications, neither of which fixed the issue. Has anyone else ran into this?
View Replies View RelatedI have a basic page for which I have included some of the code for at the
end of this message. It may not run correctly as I have cropped out a lot
of code.
I am trying to handle the click event for a cell. From the code you should
be able to see that I am handling the mouse over event and would like to
link to another page via the cell click.
I addition, but not too important at the moment, I would like to pass a
string or two across to the called page. For example link to the next page
and within that page identify which cell was clicked and possible pass a
string for the image used in the clicked cell. Code:
What ASP code can I use, for an ASP-generated spreadsheet, to force a cell to wrap if the content is longer than the width I have specified for that cell?
View Replies View RelatedI have a situation where I need to send a text message to a cell phone. Any ideas?
View Replies View RelatedIm trying to read an Excel file using OLE DB. I have around 500 characters in one cell. But the program is reading only 255 characters. How do i make my program to read all characters?
View Replies View RelatedI have a dynamic datagrid on web application, initially it will populate with search result data. in the first or last column will be a edit button to each row, when the user click this edit, it will allow user to see the column of the row shown as dropdownlist, textbook as defined in the datagrid(or TemplateColumn), after the user make their selection on those fields, the value will be valided and save to database.
My question is when come to make choice to populate the DataGrid, I have concern regarding when to load the Grid(further the Dropdownlist for example). do this inner controls populate with data when the user clicked edit, or do they populate with data when the grid was loaded with the search results? Which one would be more efficient in this case? I intend to hold the Population to the DropDownList until user clicked the row, but would wonder if this approach would work or not? how/when to add the value to the DropDownList.Item.collection?
I have a DataGrid which has checkbox columns. The data source is a run-time created data set that I store in a session so I can rebind it during postbacks. I don't have a database or xml file, etc.
I am wondering if it's possible to edit a dataset directly? So when I click on a checkbox it will change the value in the dataset and store it back into session? If this is not possible how can I use arrays or vectors to temporary store my checkbox statuses? I guess it's not possible to have one DataGrid have more than one datasource.
We have a Datagrid and we are using third party tool treeview control. it's like we have to add treeview control in the datagrid dynamically, such that each cell will have a tree structure then we have to populate the data from the database according to the id.
View Replies View Relatedi need to include check box in datagrid and delete the selected record from the datagrid and delete the selected records from the data grid.
View Replies View Related