Search results for query: *

Hi All, I asked the below question in the asp.net forum but its been suggested this could be handled through IIS rather than through code. Could anyone advise please? I have a number of domain names pointing at the same website, for example: http://a.com http://www.a.com http://b.com...

Hello all, I have a number of domain names pointing at the same website, for example: http://a.com http://www.a.com http://b.com http://www.b.com Which is effectivly duplicate content from a search engine perspective, so what I want to do is 301 redirect all traffic to http://www.a.com, so a...

Hi All, I have just purchased a VPS running Windows 2008 R2 Web. I have 2 IP addresses with the server, I want to use the primary for web traffic (the server is going to host one website) and I want to restrict RDP traffic to the second IP address. Can anyone set me on the right course to do...

Hi all, I have a table of football results which in its most basic form contains columns for team, date and result (Win,Lose). Can anyone suggest a way to find the longest run of wins/losses for any team in the table without using a cursor? The longest run should be limited to a single team...

VS 2010, .NET 4.0, C# Hello All, I’m currently planning a new web app and intend to use entity framework for the first time. I have read a few articles that say that one ObjectContext instance should be created per HTTP request and I’m trying to find out how this can be implemented. I have...

Using VB.NET 2.0 with VS2005 Hi All, I have a sitemap driven menu on my website, I need tio be able to dynamically add the the url of each link item, so for example the element: <siteMapNode url="Test.aspx" title="Test" description="Test" /> ...needs be have its link converted to...

Hi All, I have a asp.net code behind page (2.0 vb.net) which adds to the cache in the the format System.Web.Caching.Cache.Add("mycache",....... I want to be able to access the cache from a separate class file like so Dim c = System.Web.Caching.Cache("mycache") but get the error "Cache is a...

Hi All, Im just just wondering which method is more efficent and the pros and cons of each of the following two: Pass-through query Select * from table1 Inner Join Openquery('links','Select * from table2') ls on table1.id = ls.id And Select * from table1 Inner Join Server.Database.dbo.table2...

Hi, Can anyone tell me which of the following is the best/most efficient way of performing a left outer join and what the differences are? SELECT a.a_name q.q_text FROM question q LEFT OUTER JOIN answer a ON a.q_ID = q.q_ID and a.a_valid = 1 SELECT a.a_name q.q_text FROM question q...

Hi, I have the following dynamic SQL query which inserts values in a WHILE loop using a cursor: select @sql = 'Insert into [' + @dwrm_ResponseDataTable + '] (dwr_UserID, dwr_UserEmail) values (''' + @UserID + ''',''' + @UserName + ''')' exec (@sql) This works, however if I extend it to...

Hi, I have the following SQL as part of a SP (SQL Server 2000): DECLARE @queid int SET @queid = 27 DECLARE @camid int SET @camid = 1 DECLARE @UserID UniqueIdentifier SET @UserID = 'abcdef' SELECT dbo.tblAnswerResponse.ars_text, dbo.tblResponse.res_id, dbo.tblQuestionAnswerType.qat_prefix...

Hi, I have the following page which all works as it should. Withing the rptQuestionAnswerType repeater I have a checkboxlist control (cbAnswer) which I need to reference (and check the nessesary values) via code. As its nested under a number of levels of repeater I am unsure how to do this...

Hi, Im using VS2005 with VB.NET 2.0 in an ASP.NET website. I have a gridview with a button: <asp:ButtonField Text="Sort Up" CommandName="SortUp" ButtonType="Image" HeaderText="Order" ImageUrl="~/images/Arrow.jpg" /> The button fires the rowcommand with the command name SortUp which is as...

Hi, I have a basic application that will run on a schedule and send alerts by email, it will then close automatically. After installing the application it runs/loads automatically. Is there a way to stop this from happening either in code of through the application settings? Im using VB.NET...

Hi, I have the following repeater and nested repeater: <asp:Repeater ID="Repeater1" runat="server"> <HeaderTemplate> <table border="1px" bordercolor="black" cellspacing="0px"> </HeaderTemplate>...

Hi All, I have the following trigger which sums the values in related records in Course Details then updates this value in Course Request. This works for Inserts and Deletes but I am unable to get it to work where a Course Detail record is simply updated set ANSI_NULLS ON set...

Hi, I have a detailsview with 3 rows (record id, name, details) plus the command row and the paging row. Using the ItemDeleted event I want to discover the record id of the record I'm deleteing... can anyone tell me how to do this? Im using asp.net with VB and VS 2005. Thanks In Advance!

Hi, Does anyone know of any good, FREE tools that allow you to script an entire SQL Server 2005 database (including views, stored procedures, triggers, data etc) to SQL Insert statements. I have found a few by searching the net but have not come across any that do everything. Thanks!

Hi All, I have a web based system running on an Access database. The system is a questionnaire which collects data and adds it to the db using while loops, as such the recordset is open for a period as the updates are performed. I'm getting the following errors: Update tblAnswer set...

Hello, I have the following grid view (using VS 2005 - VB.NET): <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="2" DataSourceID="SqlDataSourceAD" ForeColor="#333333" GridLines="None" AllowPaging="True"...