|
You'll find hosting 5 separate SQL Server databases pretty expensive. Unless the clients are going to want direct access to them themselves, there is no reason why you shouldn't be able to place all 5 within the same database, as long as you're careful to ensure that your host doesn't tie you down to a separate database for each domain - there is no (technical) reason they should. (Not even sure they can, come to think of it - it's just a matter of what connection string you use.) Create your table names in a manner to make it easy for you to distinguish which table belongs to which application/client (add an appropriate suffix to each, for example) and create separate users with appropriate priveleges for each application too.
There, I've just saved you 80% on your database hosting costs! I'll take 10% 
|
|
|
|
|
I mostly agree with using one DB and creating a different login/user for each client so that you can store all of your clients data in one DB, however consider this:
1) Backups - You may have to come up with a unique way of backing up a single client's data.
2) Performance - Each client will be sharing resources of the single DB, so you could get one client who "hogs" the DB and everyone suffers.
Just a thought.
|
|
|
|
|
Yes, but 1) is simple enough - you can backup (from) individual tables as easily as the whole database, and 2) well, I guess that depends on your clients, but unless one is pretty big (or gets a pretty impressive amount of hits or large data requests) they are unlikely to cause any noticeable difference to anyone else's response times. SQL Server can cope with (was designed to cope with) multiple users, and large amounts of data. And besides, unless you are going for a dedicated server (in which case this whole discussion is somewhat irrelevant) then you will be sharing your SQL Server instance with a lot of other users anyway, and it really won't make any difference whether you put all your data in one or more databases.
|
|
|
|
|
Thanks mate, sound advice!
"What is best in life: Crush your enemies, see them driven before you, and to hear the lamentation of the women!"
|
|
|
|
|
hi guys. i am working on url rewrite module that works fine on Visual Studio asp.net development server, but not on local IIS.
i will minimize my code. here is rewriter class:
public class UrlRewrite : IHttpModule
{
public void Init(HttpApplication context)
{
context.BeginRequest += new EventHandler(context_BeginRequest);
}
void context_BeginRequest(object sender, EventArgs e)
{
HttpApplication ha = sender as HttpApplication;
}
}
so question is: how can i access (request) at context_BeginRequest all elements in IIS like i can in VS development server?
|
|
|
|
|
Can anybody help me programatically to get the solution for converting any type of document to PDF format
we already tried through this coding:
public static void ConverWordToPDF(string Filepath, string Targetpath)
{
object Unknown = Type.Missing;
object Source = Filepath;
object Target = Targetpath;
ApplicationClass MSdoc = new ApplicationClass();
try
{
MSdoc.Visible = false;
MSdoc.Documents.Open(ref Source, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown);
MSdoc.Application.Visible = false;
MSdoc.WindowState = Microsoft.Office.Interop.Word.WdWindowState.wdWindowStateMinimize;
object format = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF;
MSdoc.ActiveDocument.SaveAs(ref Target, ref format,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown);
}
catch (Exception e)
{
log.Info("Converted Word to PDF", e);
}
finally
{
if (MSdoc != null)
{
MSdoc.Documents.Close(ref Unknown, ref Unknown, ref Unknown);
}
MSdoc.Quit(ref Unknown, ref Unknown, ref Unknown);
}
}
Normally in while runing this application in local its working fine in XP System:
while run through IIS i getting the following error:
System.Runtime.InteropServices.COMException (0x800A11FD):
===================
System.Runtime.InteropServices.COMException (0x800A11FD):
This method or property is not available because a document window is not active.
at Microsoft.Office.Interop.Word.Documents.Close(Object& SaveChanges,
Object& OriginalFormat, Object& RouteDocument)
Can anybody suggest me how to resolve it or any new solution for conversion process
Thanks
Regards
Hemananthan.S
===============
|
|
|
|
|
public static void ConverWordToPDF(string Filepath, string Targetpath)
{
object Unknown = Type.Missing;
object Source = Filepath;
object Target = Targetpath;
ApplicationClass MSdoc = new ApplicationClass();
try
{
MSdoc.Visible = false;
MSdoc.Documents.Open(ref Source, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown, ref Unknown, ref Unknown);
MSdoc.Application.Visible = false;
MSdoc.WindowState = Microsoft.Office.Interop.Word.WdWindowState.wdWindowStateMinimize;
object format = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF;
MSdoc.ActiveDocument.SaveAs(ref Target, ref format,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown, ref Unknown,
ref Unknown, ref Unknown);
}
catch (Exception e)
{
log.Info("Converted Word to PDF", e);
}
finally
{
if (MSdoc != null)
{
MSdoc.Documents.Close(ref Unknown, ref Unknown, ref Unknown);
}
MSdoc.Quit(ref Unknown, ref Unknown, ref Unknown);
}
}
It will help us to read the code properly.
|
|
|
|
|
If you want a solid solution, don't try to write it yourself because there is alot more involved in generating pdf documents in a reliable manner than just using a single method. Do a google search for pdf creator assembly modules. There are plenty of them out there and the cost is minimal and much less than the cost associated with developing one in house.
|
|
|
|
|
No one can help you with converting "any" type of document. That is an unrealistic requirement. Anyone who tells you they have something that can handle "any" format is lying.
One of the best resources I have found for finding code or products for dealing with PDFs is PDF Zone[^]
|
|
|
|
|
Hey,
I am inserting some text in texbox and there is range validation set as minimum as 10 and maximun as 100. But when i run the program, though i insert the text atleast or more than 10 characters, it is showing the error message of this range validation. So I am confused how to set range so that user has to input atleast 10 character minimum ?
suchita
|
|
|
|
|
please do not remove any messages, lots of people have read them already and may even be searching them; if you don't need the answer, edit to say "I don't need this anymore", maybe "my specs changed". And when you do get the answer somehow other than from replies, be so kind to post it in the same thread, so others can benefit.
|
|
|
|
|
|
If you want to set the maximum length of textbox you should use MaxLength property of textbox instead of a range validator. range validator just validates if the value entered is between minimum and maximum value specified.
|
|
|
|
|
Arun Jacob wrote: range validator just validates if the value entered is between minimum and maximum value specified.
Jacob,
I think she wants that only. She wants to sepcify the Mimimum and maximum length of a text box.
|
|
|
|
|
SayamiSuchi wrote: I am inserting some text in texbox and there is range validation set as minimum as 10 and maximun as 100
Is ir a MultilineText Box ? Could you please share us the code block for the seection ?
This should work
<asp:TextBox ID = "txtAge" runat = "server" />
<asp:RangeValidator ID = "RangeValidator1" runat = "server"
ControlToValidate = "txtAge" Type = "Integer"
ErrorMessage = "Age Range 19 to 30 " MaximumValue = "30" MinimumValue = "19" ValidationGroup="FormValidation" >
</asp:RangeValidator>
<asp:Button Text="text" id="button" runat="server" ValidationGroup="FormValidation" onclick="button_Click" />
This works perfect for me !
|
|
|
|
|
I used regularExpressionValidator and it worked . thanks all for your great ideas.
<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
ErrorMessage="Description shouldn't be less than 30 characters"
ControlToValidate="txtDescription" CssClass="valError" Display="Dynamic"
EnableClientScript="False" ForeColor="" ValidationExpression="(\s|.){30,1000}">!</asp:RegularExpressionValidator>
suchita
|
|
|
|
|
I have a sub domain on my website sub.mydomain.com where sub is a folder on my root but it is an independent website.
Do I have to place a separate web.config in that folder or it will use the web.config available on the root?
|
|
|
|
|
I think there should be only one web.config file..
suchita
|
|
|
|
|
We can use multiple config files if you have seperate setting for the sublevel application Otherwise it'll inherit the parent configuration.
|
|
|
|
|
SayamiSuchi wrote: I think there should be only one web.config file..
No, We can use multiple web.config in a application, but should be one in a folder.
Thanks !
|
|
|
|
|
|
i have doubt in using master page and panel..
which one is speed for execution ???
advantages and dis advantages???
Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
|
|
|
|
|
There is no comparison, they are two different objects for two different purposes.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
I am using gridview to show my data from the database. I have autoGeneratedColumns set to false but I do need the shorting properties by date. I set allowShorting to true. I have fields like date and FirstName. Is it possible that i can short either by date or FirstName both. Like whenever user select by date, it should be shorted by date and whenever user selects by FirstName, it should short accordingly. Can I be able to do that ?
suchita
|
|
|
|
|
The GridView class has a Sort method, so you can easily sort programmatically. What you need to do is choose a way for the user to request the different ways of sorting you want; maybe add a few buttons?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Green Alien | [Alien]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/alien.gif)
Indian CodeProject Members Meet 2010 - Nominate Now 
