Hello I’m developing a website on tourism. It is public website where no authentication is required. I have around 200 topics which we need to cover. Instead of having 200 different html pages we were planning to have one single page which will display html content after fetching from database. We are planning to store all html for 200 topic in database table. We tested this approach with couple of topics and it is working fine. Here I have a concern where I need your opinion: Will above approach affect the google search engine to rate our different pages? Does this effect SEO activities… Please suggest…Because for each topic meta tags will also be in database tables. If your reply is yes please suggest some other alternative as we don’t want to maintain 200 different pages…….. PS: I had also posted the same question on Web Development forum, not sure who can reply in best way........... Thanks, Amit

Hello All I’m developing a website on tourism. It is public website where no authentication is required. I have around 200 topics which we need to cover. Instead of having 200 different html pages we were planning to have one single page which will display html content after fetching from database. We are planning to store all html for 200 topic in database table. We tested this approach with couple of topics and it is working fine. Here I have a concern where I need your opinion: Will above approach affect the google search engine to rate our different pages? Does this effect SEO activities… Please suggest…Because for each topic meta tags will also be in database tables. If your reply is yes please suggest some other alternative as we don’t want to maintain 200 different pages…….. Thanks, Amit

I have a sql where i need to add root node... Current SQL SELECT CategoryId,CategoryDesc FROM TB_CategoryMaster AS Category WHERE CategoryActive=0 ORDER BY CategoryDisplayOrder FOR XML AUTO, ELEMENTS, TYPE output : 1001Automobiles But i want 1001Automobiles any help?

I am using below sql SELECT CategoryId,CategoryDesc FROM TB_CategoryMaster AS Category WHERE CategoryActive=0 ORDER BY CategoryDisplayOrder FOR XML AUTO, ELEMENTS, TYPE and output comes like ... Buy * Sell instead of Buy & Sell... where * stands for amp How i can handle the same at sql end before sending to client end,,,, Thanks!!

search for sp_addtype

thanks!! I just read trigger syntax and would really appreciate if you could help me to understand difference between FOR|After clause....

Thanks and if i don't want to create views....Is there any Before trigger in SQL 2005.....

I want to restrict user for not adding the new record if table already contains active record. (means Active=0) CREATE TRIGGER TR_TB_QuizMaster ON TB_QuizMaster FOR INSERT AS DECLARE @iCount int BEGIN SELECT @iCount=COUNT(*) FROM TB_QuizMaster WHERE Active=0 Print @iCount IF (@iCount>=1) BEGIN Print 'Active record already exists. Only one active record can exisits' Rollback END ELSE print 'Inserted' END But this does not allow me to enter a new record unless i change it to IF (@iCount>=2). This is because it fires after insert.....Is there any way by which we can fire trigger BEFORE actual DML operation.... Please suggest Thanks!! -- modified at 6:49 Friday 21st September, 2007

I am using below sql SELECT CategoryId,CategoryDesc FROM TB_CategoryMaster AS Category WHERE CategoryActive=0 ORDER BY CategoryDisplayOrder FOR XML AUTO, ELEMENTS, TYPE and output comes like ... Buy * Sell instead of Buy and Sell... where * stands for amp How i can handle the same at sql end before sending to client end,,,, Thanks!!

Seema, No one can help you unless see your code....So please post your code!! In the meantime you can look into... <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %> Untitled Page

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click If Me.ChkName.Checked = True Then Response.Write("Selected") Else Response.Write("Not Selected") End If End Sub Thanks!! -- modified at 15:06 Wednesday 19th September, 2007 Amit Gugnani

I am using this Response.Write(CultureInfo.CurrentCulture.ThreeLetterISOLanguageName); and everytime is shows USA....I tried to change the settings from control panel-->regional and language options.... But no luck!! thanks

I am developing an home page which can be access from 5 countries. Based on user location (which i don't know it could be Country A, B, C , D or E) i need to change home page accordingly. By default we will have country A. My boss says try to explore culture...but i have no idea for the same...Could you please show some directon.... Thanks Thanks

Hello, In my internet site, i have to proivde search functionality within the website domain. Could you please give some light where should i look for related articles,sample code, ideas etc.... Thanks, Thanks

Hey Chris/Pete I think we all are missing my queries a) What is default type (ByVal/ByRef) in C# and Vb.Net? b) Which is a good practice if passing values to different components when they are on same machine and as well as on different machines..... Thanks Thanks

Thanks, but still i feel you missed to reply my queries...default type

A quick question: What is default type (ByVal/ByRef) in C# and Vb.Net? And which is a good practice if passing values to different components when they are on same machine and as well as on different machines.....Thanks!! Thanks. -- modified at 10:42 Monday 3rd September, 2007

As this forum is quite old but in case you need any help, let me know. We completed medium size internet projects where i troubleshoot all this.....

I have few basic queries...pLease help!! a) Can we have multiple Main methods in one class....? If yes how? b) Can i have Main Method which returns otherthan Int value ? Thanks!! Thanks!!

Hello, I am having 10-15 application objects in global.asax file and my site would be deployed with web farming with approx three-four web servers.... Now my questions: How application object would be treated under web farming....Will all the servers have the same copy of application object? Or...................????? Please advice Thanks!! Thanks!!

Hello, I have very basic questions: a) How data is trasnfered from client to server and vice versa on Internet.? Is it binary format or something else.... b) Where viewstate is stored? Is it on server memory? c) Type are stored in which namespaces? Is it system? Thanks!! Thanks!!