VS 2010 - Managing Multiple Databases With Single Project
May 19, 2012I am making project on hospital management which will contain different databases for different hospitals. how can i manage this thing with single asp.net project?
View 4 RepliesI am making project on hospital management which will contain different databases for different hospitals. how can i manage this thing with single asp.net project?
View 4 Repliesif we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ?
Example:
[code].....
I have a query which gets values from two tables which are in different databases.How can I write a SINGLE Connection String which connects to two databases? By the way I am using SQL Server Database
View 7 RepliesI'm currently working on an C#/ASP.NET project that will host several differents e-commerce websites, all running in the same application.I use LinqToSql (moving to PLINQO soon) to access my database. The database contains both informations on the website structure (pages, ...) and the products/orders/users data.
My question is, should I use only one database for all the websites, or sould I create a new database (same model) for every new website?I'm now using a single database (with SiteIDs in some tables) but I have a big security concern, I can't just backup/restore the database for ONE website if something goes wrong (e.g. somebody erase all the products on ONE website) and it's an important requirment of the application.
So I was wondering what are the good practices in that case? Is there big cons if splitting dbs?(I would have to make changes to several database instead of one in case of structural changes, but i guess i can make a db version/update system).How the existing CRMs are dealing with that?Is it a performance problem if a database server host a lot of different DataBases? A complex backup/restore tool would be better?
Subquestion:To make a website replication easy, I can also split the pure CMS data (Pages, Texts, ...) in one DB and the e-commerce data (products/categories/orders in another). It can be achieved by some select/insert functions but it would be easier by just copying a database of course.
My website uses a single project solution. Each web page file consists of C# code along with the markup. I now have to separate the code from each page into code-behind files that must be combined with many different versions of the markup. I assume this means that I will need a solution with a common project of code-behind files that is merged with a project of each version of the markup files in order to create different websites. I need to know how to organize the solution for debugging and building each website and where to place each file.
View 1 RepliesI need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.
View 2 Repliesi have two applications hosted on two different domains and both use a single login info so my question is how can i use / share same session across two application.
View 8 RepliesWhen I turn on Code Coverage in my test settings, on a project that references the Unity DI container I get the following error:
Cannot initialize the ASP.NET project'{Project Name}'.
The event log specifies the following reason:
Could not load file or assembly 'Microsoft.Practices.Unity, Version=2.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name signature could not be verified.
I am part of a development team building a new ASP.NET 3.5 web application. Two of us are C# coders, and the other is a VB.NET coder.
I know that we can mix languages on a per-project basis, and one can build classes in one language that inherit from classes written in the other language in a different project (which we are already doing), but I can see us getting into a situation where we might well end up with cyclic dependencies between our various project DLLs.
Other than simply having a high number of projects (more seperation of concerns into more libraries), how have you managed this situation on your own projects?
Note - I believe this question to be different enough from the only similar match I could find (this one) on the basis that we are not wanting to use different languages in order to take advantage of their specific features per se, but rather to make use of what developer resource is available to us (i.e. one dev just happens to be VB.NET only).
A friend and I manage a large website for a company. The site is build using Visual Studio 2005 and is a series of nested web applications run inside a master application employing nested master pages. Currently we have to manually move files around folders and FTP them to various servers and I am looking for a way to be able to manage the deployment end of the site in a more automated fashion. I'd like to be able to work on my local version of a project and once I'm done be able to hit one button and publish the site to our internal testing server and then when testing is complete hit another button to deploy it to the live web servers. Right now we have to manually navigate the windows folders and copy pages, css files, images, swfs, etc and FTP them manually. The driver for this is that we have a new junior develop starting and want to remove the manual aspect in advance of him starting.
View 1 Replieshave a question related to sitemap ........i have a pool of websites which are same in function but different in css and format ..every site in that pool different from each other in terms of information so each site in the pool would have different sitemap.xml but the problem is how would i know that the Google crawler or other search engine crawlers are picking the right sitemap ... ?is there any place where i can identify that sitemap-abc.xml belongs to abc site and sitemap-xyz.xml belongs to xyz site ? ll the xml are put in one folder only difference in between them is there names ..
View 1 RepliesI am sorry if this is been discussed earlier. I am having a problem maintaining the session when someone uses the same browser with multiple tab, the results gets messed up. A perfect example would be, [URL] if you open IE (or any other browser) and open two tabs and search for two different air travel itinerary and the results will completely overlapped (real mess). I know the cause for this problem (both tabs uses the same session). I would appreciate if somebody have any solution for this. I am using ASP.NET 3.5/VS 2008/VB.NETI will not be able to use Viewstate since I use a master page and pre-init event where view state is not available.
View 2 RepliesI have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.
While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.
I have downloaded a project from the internet called the SMS Source example. I wanted to open this project in VS2010, so a conversion wizard has popped up prompting for the conversion. But it has errors in converting.
Error msg:
Conversion Report - SMSSend.csproj:
Error converting project file. MSB0001: Internal MSBuild Error: Missing resource 'MissingAttribute'
I recently updated my VS2010 website project from .NET 3.5 to 4.0. Everything was working fine in the website project. Today I decided to migrate the website to a web application project as I have learned this is the best way to work in .NET. I split out all my class files into a separate class library and copied all my other content into my new project. Then I updated all the references and web.config.
When I build the class library, everything works great. The problem is happening when I try to build/debug the web application project. It is acting like all the controls are missing and it is also throwing a bunch of compile errors about the public properties I have in my master pages.
Control errors: "The name 'INSERT CONTROL NAME HERE' does not exist in the current context"
Master page errors:'System.Web.UI.MasterPage' does not contain a definition....
It is giving these errors for every single control and master page property in my entire solution.I notice when I add a new web.form to this project, it also adds a filename.aspx.designer.cs file in addition to the .aspx and .aspx.cs file. My existing files do not have these extra files since they were created in a different .NET version.
UPDATE: It seems I was missing the step where I need to right click on the new application folder and select "Convert to web application". I just did that and it seems to be a little bit better...
Now it is choking on Literals that are inside single quotes:
<div class='<asp:Literal ID="CssClassLiteral" runat="server"></asp:Literal>'>
It doesn't see this literal when it does the conversion... Is the above valid code or should I implement that functionality another way?
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 Repliesbelow written question :
1.) What is the name of the OS process in which App Domain resides.
2.)if suppose There are Three Windows application hosted on a same envoirment and two instance is working for each application at a Time, means now total instance are six .what will happen among the below written cases :
a.) There will be six different app domain in a single OS process
b.) There will three app domain(one for each application) in a single OS process and some Parallel thread will be executed in each app domain for another instance.
c.) There will be Three OS process corresponding to each application.
3.) If eveything will remain same except there are three web application in place of windows in point 2, will there be any change in functioning.
I have a question in gridview, I want to combine my two or more records into a single cell with two rowsfor Example i have a ID, Name, Year Start, and Year End for Column name in database and i want call it into my gridview that the Year Start and Year End will combine to Year like:
In Database
ID Name Year Start Year End
1 Yourname 2010 2015
In Gridview:
ID Name Year
1 Yourname 2010 2015
in a year column i want it to two row..
I want to bind three column with one row in gridview in asp.net with c#,
i want like this,
Name | Info
----------------------
name | lastname
| phone number
| address
I get this by default
name | last name | phone number | address
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
i am developed on simple user registeration application in that i gave address field .when i am trying to enter something like this (1st main,b'lore) but wont take while inserting.
my query is
sqlcommand cmd=new sqlcommand("insert into registeration_form(name,address)values('"+txtname.text+"','"+txt_address+"')",con);
how can i pass the quotes also to my query if any one know reply me.
There is one oracle 11g server, I want to create connection from my .Net project. tell me the steps which I need to follow for create connection.
View 2 RepliesI've only worked with web services a little bit. I am working on a project now using another developer's code as a template. It is code for a single sign on (SSO).
Here is a code excerpt:
Code:
namespace xxxxxxxSSO {
/// <summary>
/// Summary description for xxxx
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[Code] ....
Also let me say, I have been coding in VB6/VB.NET for the past six years and am learning C# (that is what the other developer's code is written in).
setAppCredentials() is the beginning of a lot of sub-calls and I have gotten that all to work when I was running the service from within its own Visual Studio project.
Where I am having the problem is setting credentialHeader.Username and credentialHeader.Password. credentialHeader is nothing when I call validateCredentials().
I didn't see how I had these exposed to me in order to set them. So the developer said Create a client that consumes that service and set the values there and call your method.. But I still don't see how it's exposed to my consumer. I have this line of code in the consumer
Code : Dim myWebService As New localhost.xxxMemberService
(Back to VB!,) but I still don't see credentialHeader exposed.
The only other thing I see in the webservice code that might be relevant is this:
Code:
/// <remarks/>
[System.CodeDom.Compiler.GeneratedCodeAttribute("System.Xml", "4.0.30319.1")]
[System.SerializableAttribute()]
[System.Diagnostics.DebuggerStepThroughAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[Code] ....
which is in a file called referenes.cs.
Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesI faced the following problem. Once I have completed my whole application it genereate dll file for each aspx file in bin folder. Now in published state the application faced some run time error in specific page. now I want to only republished that page generating error. while Visual Studio don't let me compile the individual page. can some one guide me in this regards.
View 1 Replies