Search results for query: *

I want to write an algorithm that will search through a list of documents held in a database and pick out those documents that are duplicated once or more, and show the location of each copy of the document. Here's the process I normally follow for such things with a few hundred rows: 1...

Hmmm.... I can imagine the conversation: me: I want to reinstall SQL Server dba (looking worried): why? me: I want to set it so that people can only see the db's they've got permissions to work on dba: rearrange the following words - 'way', 'no' Maybe I'll have a go at setting this up on my...

I've installed SQL Server 2005 Management Studio Express on a colleagues PC and granted her access to only one database on one server. When she expands the server, she can see the full list of databases on that server (although if she tries to open any of the other databases that I haven't...

Sounds to me like the Integrated Windows Authentication is kicking in for both websites. I presume the prompts are system generated rather than asp.net controls that you have placed on the page. So if you disable IWA for the second website that the user is being redirected to then you should...

1. Can you make the default page on your main website (something like http://mysitename/default.aspx) run a script or assembly when you hit a submit button? I'm sure that you can achieve this just by modifying the .aspx page and adding a script to it but you'll need to check this out. If that's...

Firstly - have you checked out Integrated Windows Authentication within IIS - if you use this authentication mode then you will remove the need to have an input box, because IIS will just check the user credentials against a list and approve or deny access to the website without the user having...

In my experience connection strings do not require an iis reset to be recognised; some work I did this morning required me to point a web app away from localhost to a 2005 server and as soon as I saved the change to web.config and refreshed the web browser the change was picked up.

I noticed the following anomoly today when I was installing v1.1 of the .NET Framework onto a 64bit w2k3 server. 64bit w2k3 won't run 32bit applications using the framework by default so you have to run a script. The .net framework installation package actually tells you to do this - and the...

nnmmss72, I've just tried to compile your code (I had to take a few things out - what was Repeater1 supposed to be?). It ran fine the first time (i.e. it ended without throwing an exception). Then I tried changing myCommand.Connection.Close(); inside the BindPage method to...

Thanks for the effort - I solved this by: 1. Creating a variables of type System.XML.XmlDocument in the Biztalk orchestration (DocIn). 2. I set DocIn to the value of the Biztalk message, passed this into a method, used the method to query a database and append the XML and then returned the...

I've written a method which takes an XmlDocument passed from a Biztalk orchestration and then appends some information to the XmlDocument. I now want to save the changes that I have made to the document and send the modified document back to Biztalk. The document is in memory - I don't want to...

That's brilliant - just what I wanted. My SQL programming skills leave a lot to be desired.

So using the example from the thread you referenced: SELECT @result = @result + company_name + ', ' FROM companies WHERE 'your conditions here' SELECT @result = SUBSTRING(@result, 1, LEN(@result) - 1) SELECT @result What I can't get my head around is how to make this insert the correct...

Imagine I have the following table: |*******|*******|*********| | EmpID | Value | History | |*******|*******|*********| | 000001| 13.62 | | | 000001| 20.22 | | | 000001| 12.90 | | | 000004| 18.11 | | | 000004| 30.01 | | | 000004| 15.90 |...

I have some XML in the following format: <employee ID="000001" Initials="G" Surname="RUSEDSKI "> <summary batchnumber="00841" batchitem="01" claimmonth="1" claimyear="2007" Miles="154" amount="27.72" AuthStatus="Rejected" vmodifiedby="" vnotes=""/>...

Next question: I have some XML in this format <employee ID="000001" Initials="G" Surname="RUSEDSKI "> <summary batchnumber="00841" batchitem="01" claimmonth="1" claimyear="2007" Miles="154" amount="27.72" AuthStatus="Rejected" vmodifiedby="" vnotes=""/>...

Normally when you call a web service from an application you need to reference a .asmx file. If you create an XML webs service in Visual Studio 2005 this file gets created as part of the project.

Using the following XML file as an example: <?xml version='1.0'?> <Collection> <Book Id='1'> <Title>Principle of Relativity</Title> <Author>Albert Einstein</Author> <Genre>Physics</Genre> </Book> <Book Id='2'> <Title>Cosmos</Title> <Author>Carl...

So if I did something like: System.Net.WebProxy proxy = new System.Net.WebProxy("proxyname"); proxy.Credentials = new System.Net.NetworkCredential("username", "password", "domain"); System.Net.WebRequest.DefaultWebProxy = proxy; followed by my code to set up XmlTextReader...

I'm trying to write small asp.net app to pick up and display data from an RSS feed. I've used the code sample available on http://aspnet.4guysfromrolla.com/articles/031903-1.aspx and modified it into C#. When I run the app, I get the following (summarised) error message: Unable to connect to...