I 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?
I 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'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.
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.
How 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.
I 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.
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.
I am really having a problem with trying to get my datagrid to update my data base.
I have tried 2 different sets of codes, but when ever I enter the new data to be updated and click update, the datagrid will just return to the orginal datas. There is no updating done. I really am very new to this. Please advice what are the problems in my code that I must change. Code:
Im trying to get a drop-down box that when a value inside it is selected, it updates a data grid below.
I am making a world cup fantasy football league between a few buddies and i want for each person to view points stats etc on a web page which connects to a database.
On one of these pages which i want help with has a list of Managers, and when a manager is selected it will show in a data grid their chosen squad of players.
I can get a page to select each teams squad, but at the moment i only know how to do that as a set of unique pages for each team which would be time consuming to do. Therefore a drop-down list of the team names would be a lot easier if it could update the page when a value is selected. Code:
I am using a datagrid in my asp.net web app to show a user list. I put a pushbutton (could be linkbutton as well) for each row in the grid. I would like to have a javascript function linked to each button, so when user clicks the button, another pupup window shows up to show an image of the selected user in the list. I am looking for a way to add client side javascript function to each button and passing the each user's key to the function.
I am using a datagrid to display info on my page. Originally, I had the headers linked to a style sheet so that I can control the look of the headers from the CSS file. However, once I set the SortCommand property in the header, it seems that the style of the header changes. My font is now different and underlined. How can I control which style my sortable heading is using?
i have a project i am currently working on, basically what i am doing is i have an excel spreadsheet with 2 fields a number that coordinates with another field which is a url, currently i have to copy paste the url in my browser to get what i want, which is a picture, each url is a picture and picture only, what im trying to do is create an asp web app that i can use that spreadsheet connect using asp and automatically download every url in the spreadsheet to a directory, while also renaming all the pics as the first field.jpg,so basically an asp downloader that downloads contents of url and renames it a certain number
I've an asp page which brings back a query and displays it in a table. The query takes around 30 seconds. Once the page displays they will have an option to send it to excel.
From the examples I've seen they all require the query to be re-ran again in asp (i.e. server side scripting) and as it takes 30 seconds to start with I want to try and take out the repeat of the query. Does anyone know of any way you can do this in asp by passing the already executed table to asp or via any other method?
I want to access the data contained in the MS excel by giving a field value that has to be got from one HTML file including a textbox and one button -SUBMIT to submit the required field value. Finally i want to display the details of that particular field value which is recieved from the first file in HTML. Is it possible ?
I have an ASP file which is opened in MS Excel. I have used the "formatNumber" function to set the number of decimals for variables which are displayed. however Excel cuts off any zeros at the end. e.g 4.650 displays as 4.65
the number of decimals I want to display to varies across the page, e.g. I cant say "display the whole with 3 decimal places" Is there any code I can put in my ASP page to stop Excel truncating zeros at the end?
i have a Print button to allow user to save reservation detail in ms excel. currently, when user clicks Print, a Save menu which allow user to open and save will appear. how can i skip this window? i want my system automatically open ms excel and at the same time open the Print window in ms excel and user also cannot modify any detail in ms excel. is it posible to that?
I'm working on some reports, and have added the ability to "download" the reports to excel. Not a big deal, fairly straight forward. However, PHB wants to be able to create some pivot tables from said reports (again.. no biggie) and when he goes to save the file, Excel wants to save the file as a web page instead of and Excel spreadsheet.
Now.. I know the simple thing here is to just pick Excel from the drop down box in the save as dialog.. but.. PHB would "prefer" to not have to do that.
Has anyone been able to jump this hurdle before? My good friend google hasn't turned anything up. My preference is to give PHB the middle finger.. but alas.. the paycheck is keeping me from doing that.
I have an asp, sql business application. Want to give export option of all reports to excel and pdf. Can I get that code which can embedd in the asp pages to create this function?
I need on-site manager's to be able to view a list of records on our website (which they already can do). They need to be able to select any/all fields and then export these items to an excel spreadsheet. The spreadsheet will have dynamically created columns/rows to append and life is good.
What's the best way to go about this? I've used DTS to do this before, but it's been a long time and I can't remember if there's a way to handle this kind of stuff on a dynamic basis.
I guess my real question is: Is there a way to do this via ASP or should I stick with a more SQL based approach?
Is it possible to copy all info on a page into excel so that it can be sorted?? I know how to get the page to load automatically into excel, using the -: Code:
however I lose some functionality if I do this, i know i could add a button that just re-runs the pages to load the info into excel, however some of the pages may take a while and I want to reduce time and load on the server. So I justed would like to know if it is possible using a script of somesort so that clicking a button will copy the whole page and then paste it into excel??
I need to write an ASP page that will allow users to upload an Excel file, the contents of which should then be imported into an SQL database. Problem I am facing is how to do this efficiently. So far I have a page that will accept an upload, then display the data from the Excel file, my first thought was to loop each row, then run an update/insert based on the data found...Obviously this is not going to be very efficient, I'd exepect time outs often Has anyone got any ideas to get round this?
