I have spent the past several weeks building an ASP.NET 2.0 Application that has a Users.xml file where all user information is stored. I am now designing the administrator tools and want to be able to sort through the records in the XML file. Essentially, I want to be able to build this:
It seems that every example i hit is a sqlserver example and there doesn't seem to be very good sorting capabilities for XML. is this true? how do i acheive the above link? I would really appreciate any code examples or code links if you know/have them.
need to enter many entries at a time related to my production. Like operatorID,operationNO,qty,nohours bla bla I already designed page. But its used to enter one record at a time. I want to allow user to enter all operators details for a specific date at a time. I tried using ADO Connection and ADO recordset. When set the properties, its displaying error. Its not connecting to database. How can i use this? or is there any tool having this feature for free? I am using access database. I want to use this in my LAN only.
I need to display data from a sql server 2000 db on an asp web page and I need a vertical split. Does anyone have any solutions? I really can't afford to spend much/any money so freeware/shareware or coding suggestions is what I am interested in.
This seems a very complicated task, so I welcome any input. My boss wants a data grid or matrix of the top 6 orders with ordered items, and products, for a particular customer and he wants to see it like this:
products down the left side orders across the top number of items under the respective order number column across from the corresponding product.
I hope that makes sense. I have three tables. Products, Orders, Orderitems. I don't even know where to start. Many thanks in advance for any input offered.
i have this event sign-up program that displays events from access databases and allows a user to click on a sign-up button to sign up for these events. currently when viewing an individual summary, the users see a listing of events they've signed up for, but it's been suggested to create a grid schedule for a better visual.
these events cover a 9 day period (Friday through Saturday) and i was wondering if there's a relatively easy way to create a grid schedule for the users?
I have an ASP page which hosts a VS flexgrid control. I use a Menu.js file which will dispay the menu on each page of the application.
But in some of the pages the sub menu goes inside the flexgrid. I tried putting the z-index property for the div which holds the Flexgrid but it didn't work. Is there any workaround for this.
I'd like to know whether its possible to hide the pagerstyle of a grid.In a webpage i hav a grid with paging that is supposed to be printed,so in a button click i'm calling a javascript to extract the grid <divto open it in a new window..in the same button click the pagerstyle should be set to false..Is there any way to do that?..
I have created a website using dreamweaver mx 2004 and access 2000 for the database. i want to display the results of a recordset in a grid with a different record in each grid. the grid will be fixed in width and the cells will be fixed in width and height but if more cells are required (eg more records to display) then they will be added to the bottom of the grid. at the minute its not working. This is a screenshot of what im sort of after.
I have a database of UK postcodes with corresponding OS Grid references (easting and northing) but I need to convert these to longitude and latitude so that I can plot my postcodes on a Google Map.Does anyone know of a function which can do this?
I'm building a 'spot the ball' gaming site where people choose a point on an image closest to where the ball should be. This works in Flash by assigning co-ordinates to that point.
However, I need to do a database look-up when the competition is over, to see who has the closest point. I'm hoping to build an ASP application that will enable the administrator to enter the correct co-ordinates, then click a button to find the closest entry in the database. I can't think of an accurate automated way to do this. Has anyone built anything similar? What would be the best way to achieve this?
Using ADO/ASP, I want to retrieve a list of pics from my db (which will be dynamic number of pics as a user will be uploading anything from 1 to 12 pics) and put them in a grid (table) of say 3 x 4 cells.
I think this is easy to do if the user has uploaded 12 pics, as the recordset's recursive loop will create the table for me, but my problem is that what if they only upload 4, 5 or 7. How do I list these pics in my grid, but get the ASP to neatly finish off the 3 x 4 grid? If I just leave it to my recordset of say 7 recs then my 3 x 4 table is going to disjointed and unfinished.
I have the following piece of code:If RS.EOF or RS.BOF Then Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match" Response.Write "<BR>" Response.Write " or you have not registerd yet, please register" Response.Write <a href="default.asp">Clik here Response.End Here, I need to build the line (Response.Write <a href="default.asp">Clik here) dynamically, so that the html output from asp page gives us <a href="default.asp">Clik here
I have a situation where I have to update a single table with information from a bunch of fields. So I can explain better this is a sample table with some data... Code:
I am having trouble with structuring my query for searching using "LIKE". I return no records with my current SQL statement. Here is the string I am sending through ASP using VBScript as my language.
Other piece: strClass = Request("SiteLOCCode")
String from ASP page: "SELECT * FROM LDSWSNames WHERE WSName LIKE '" & strClass & "' "
Output string from ASP: SELECT * FROM LDSWSNames WHERE WSName LIKE 'KYLEXAD01'
I am creating a search page and need help writing the code to build the sql string.
I have 3 fields on the main page which a user can choose to enter search terms in any of the 3 fields. My question is how do I write the logic so it only includes the fields in the search criteria where the user has entered anything.
Fields are
Production No Production Title Synopsis
The user may enter any, all or some of the search teams in the fields.
On the search page I am using lots of if conditions to build my sql string like
strSQL = "Select * from Productions where "
now after where there are lots of permutations and combination like production no could be empty or it could be filled in and the other fields might be empty or filled in as well.
Does someone has a simple logic to build the correct sql String?
I'm about to start building a website which has a MS SQL back-end database. The host annoyingly won't allow me to connect to the database through Enterprise Manager, so he's advised that the database be created entirely though scripts.
I'm not particuarly good with T-SQL, so is there a tool I can use to generate the scripts from a database I have built? Can Enterprise Manager output the source code to build a database once it has been built? Could I set up and test the database on a different MS SQL server, then export the entire script and contents into a SQL query which could then be run through an ASP script to build the same database on a different server?
Basically I need to create a recruitment website whereby the recruitment company can post up new jobs and create new categories. On the home page it must display all the categories in boxes with each job that relates to that particular category displayed underneath it. For example: Code:
I'm trying to build a details page that is reachable when a user clicks on the ID of a query that's returned multiple rows of data. The first piece of code is the querytest.asp page, and the second is the details.asp page. However, how do I get the user_id passed to the details page? Code:
I'm interested in building a graphical timeline for a series of tasks that are stored in a SQL Server 2000 database. The tasks reside within a table. We also have a table to track the history and date of status changes. Some of the status flags are as follows:
1 - In Progress. 2 - Awaiting Info. 3 - On review server.
For each task, using ASP or ASP.Net, I would like to be able to display a graphical timeline for each task, with the status changes denoted for a given date range.
Does anyone have any ideas on the best approach for this task?
I need to build an UPDATE statement that copies the values of roughly 40 fields from a table that stores standard or default values into a table of specific contracts. There are 8 or so fields in the source table that are not in the destination table. The remaining field names are identical in both tables.
How do I create a recordset of the field names I am interested in so that I can loop through it to build my UPDATE statement?