Single instance multiple database (i.e single iis instance but separate database for each customer) Is it best practice to follow Multi-tenant SQL Azure Federations Sample http://shard.codeplex.com Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

We are running payroll application in web forms . Now we are in the stage to move to SAAS model and to use azure. Searched in internet but could not find proper information to start. Is azure support multitenant by itself or we need to create in web application? We plan to create separate database for each tenent. Please Advice. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, We need to develop a system which requires approve and reject button in email. googled, but could not find proper method. Please suggest me, how to make approve button work in email. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Even in my Production server ..Officee is Installed. Thanks for your response Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I Am using Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application(); Microsoft.Office.Interop.Word.Document doc = new Microsoft.Office.Interop.Word.Document(); In Visual studio 2010(Framework 4.0) I created application which finds and replace text in word document. This works in my developement machine but in production I am getting below error Office is already installed in my machine. ERROR: Retrieving the COM class factory for component with CLSID {00020906-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {00020906-0000-0000-C000-000000000046} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)). Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

I found my answer http://stackoverflow.com/questions/2989194/select-range-by-string Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I am using below method to find the text in the word document and replace. word.Selection.Find.Execute(ref findText, ref matchCase, ref matchWholeWord, ref matchWildCards, ref matchSoundsLike, ref nmatchAllWordForms, ref forward, ref wrap, ref format, ref replaceWithtext, ref replace, ref matchkasdia, ref matchDiacrities, ref matchAlefHamza, ref matchcontrol); However we had a new requirement like searching the text which starts with # and end with # eg: #name# -- it will be in the word document In c# we need to get the value "name" How to achieve this.Please Advice. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I need to create a document management system. In this we need to generate multiple Appointment Letter to send Email to different customer, However i Will have only one appointment template(May be in MS Word, which is easy for editing). Some thing similar to mail merge but email address should come from sqlserver. I search around google and found VSTO will solve this. Please Advice me. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I am new to cloud computing. We have a requirement to migrate our asp.net application to SAAS -multi tenant application. i.e for each user if they register it should create seperate database. Please provide me very high level steps to start. checked with google but still not clear. Thanks in Advance.. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I have same table structure in Mysql and sqlserver. If there is change in Mysql table, then sqlserver table should get updated. Please suggest proper way to do. We dont have SSIS we only use ssms2005 express. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

This is the New Development for our product. our requirement is, DAL -- can be Ms Acccess or sql server [later may be cloud(azue db)] How can i swich between this db based on web.config so please suggest best method , I can check in BLL , Is this a right method? Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Refere this it may help u.. <%-- --%>

Project

Description

Amount

<%# DataBinder.Eval(Container.DataItem, "Project")%>

<%# DataBinder.Eval(Container.DataItem, "Trade")%>

<%# DataBinder.Eval(Container.DataItem, "Amount")%>

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I have a main report with selection formula i.e if i select employee it will show all the details of employee later i added subreport with leave information My requirement is .. if the user select the employee it should pass the employee name to the subreport stored procedure(c#) as parameter Please help me with this

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, table ----- NAme Age Total ---- --- ------ Ram 26 800 kumar 36 300 Sam 34 200 output should be ------ Name:Ram Age:26 Total:800 ;Name:Kumar Age:36 Total:300;Name..... Please help me with this .tried using COALESCE but I could not achieve..

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All string FilePath = strphysicalpath + @"Documents\TempReports"; DirectoryInfo di = new DirectoryInfo(FilePath); di.Attributes = FileAttributes.Normal; foreach (string fileName in System.IO.Directory.GetFiles(FilePath)) { System.IO.FileInfo fileInfo = new System.IO.FileInfo(fileName); fileInfo.Attributes = FileAttributes.Normal; } string[] filePaths = Directory.GetFiles(FilePath); foreach (string filePath in filePaths) { File.Delete(filePath); } I use this code to delete all my files in the Folder, but I am getting "Access to the path is denied" Please help.

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, Our Project is migrated form visual studio 2003 to 2005. we are using frameset for page layout.(header,footer,content) <script type="text/javascript" > document.write('<frameset rows="'+ val1 + ','+ val2 + '" border="0">') document.write('<frameset id="FrameName" cols="13%,87%" >') document.write('<frame name="main" id="idmain" onload="LoadXml();" src="right.aspx" scrolling="no" noresize>') document.write('<FRAME name="workarea" id="workarea" src="../main/home.aspx" scrolling="auto" noresize>') document.write('</frameset>') document.write('<frame src="bottom.aspx">') document.write('</frameset>') </script> We want to remove this and go for other good approach. We cannot use master page because each page i need to remove the html tag and add place holder. So with out avoiding this is there any good way to solve this? Will DIV solve this? or Any third pary tool solve this? Please Suggest?

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

No you cannot get it free..

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I need to create a .exe file from visual studio(Windows Application). I already have .exe file in bin folder...but I want to have exe file which should be deployed with release mode. note: i dont want setup.exe file i want only .exe meaning if I click the exe file it should execute immediately. Please Advice.

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, Is there any reporting Service which provide run time design. I am using Crystal report.

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com

Hi All, I have a dataset with table values in code behind, which I want to save all the rows to the database(sql server); i.e coping dataset to table(DB) Please help me with this, searched but could not get the proper solution.

Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com