I have an asp.net page that dumps html data into an Excel file by changing the contentType header to ms/excel. Unfortunately all the £ signs in my text come out as £.
Does anyone have any ideas on how to stop this?
Cheers
I normally use IIS 5 , but I have had to install my .net application on an IIS6 server. I have managed to get it working but none of my client side validators seem to work.
Does anyone have any idea why?
I have a table with three fields An ID field, a parent ID field and a title field. The table stores the staff hierarchy. So the values are like
1|null| Director
2|1| First Sub Director
3|2| Second Sub Director
4|1| First sub director PA
And so on.
I need to convert this flat table into a...
Hello,
I have created a class for storing and changing data; it is similar in design to a shopping basket. Most of my users are read-only and will therefore not need to use this class, so it is only users who have logged in (about 20%). Each logged in user will need to insatiate one. I have a...
I have just spent two days setting up role based security in for my site and it works, but I have a small problem.
In my system I have four levels of user and I am handling the permissions through the web.config file. When a user logs in and then tries to load a page they don't have the right...
What is the most efficient way to load an XML document from a string?
The only way I can find is by using the loadXML() method of the XmlDocument(), is there a better way?
Thanks for any help.
Just a quick and simple question, but I cannot find the answer.
I have an empty list box web control on an aspx page. I use javascript on the client side to add items to it but when I post back to the server I cannot see them and items .count is returning 0 .
What am I doing wrong?
Cheers for...
Hello.
I am writing a piece of server side code that uses Regular expressions (groan). I have been trying to get it right for days now.
I receive Input in the form of strings formatted as such "0.0" , "0.0.0" ,"0.0.0.0"
I need an expression that will be true for the first("0.0") but not any...
Hello,
It has been a while since I last dealt with access so I expect this will have a quite simple answer.
The system is in 2K and I have a databound continuous subform. The subform has a combo box which lists our products (we only have about nine). The combo box is based on a select query...
I I have a Treeview on a webform. The tree view is based on XML coming from SQL server 2000 and is passed through a style sheet to put it in the right format. The problem is the XML returned is bulky and time is taken up by the stylesheet’s transformation. The page takes an age to load. What I...
Can SQL server 2000 Write an XML file to an IIS server?
I have a vast amount of data that can change quite often, but everyone needs access to it. I can get XML output from SQL server and I can write the file with asp.net. The problem im having is detecting when the data has changed so that the...
Hi,
I have taken great time to create a Stored Procedure in SQL server 2000 that returns the data as XML. When I write the XML out however it is being encapsulated with <Table> and <XML_some Hex stuff> tags. What am I doing wrong?
I am new to both XML and asp/ado.net
Thanks for any help
I am new to SQl server 2K's XML functions. But I have a Flat data table that I need to put into a structure. I have an XML Explicit working, but the data is still flat. Is it possible to do this or does the hierarchy need to already exist?
I have a SQL database with one table. I need to take this information and place it into a hierarchy. I am new to SQL server 2000’s XML functions and relatively new to XSLT. I do not know which technology is should use.
The situation is as follows.
The One table handles a case. For example...
A month or so ago I set up and configured a replication between two databases on the same server. It worked fine for weeks/months. However, I went in to check it and for the past week or two, it has been failing with the message “ An exception occurred in the Distribution subsystem”. Many...
Hello,
I am sorry for this simple question, but I am new to asp.net. I have a webform that displays one record at a time. I am converting an access front end to the web. Records are navigated by a tree. What I am trying to do is allow a user to update the record by clicking a button. As the...
A month or so ago I set up and configured a replication between two databases on the same server. It worked fine for weeks/months. However, I went in to check it and for the past week or two, it has been failing with the message “ An exception occurred in the Distribution subsystem”. Many...
I am using a treeview on an asp.net page. I have set the post back to false and control the tree using client side script, queuing events and the submitting. My code works fine for handling the onExpand events but I am at the stage now where need to detect the onselectedindexchange event. I can...
Im trying to set up my first replication using snapshot publication and a pull subscription. I can get the data to move across, but when I have the primary and foreign keys attached to the subscription table the replication fails.
How do I work around this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.