I own a business that has locations in multiple cities around the US. I want to create a system that generates each business dynamically from the database.
Example: www.mybusiness.com/california-location
My goal though - is to map the california-location to it's own domain --- i.e. www.californiabusiness.com
Is this possible? and how do i go about setting it up?
I own a business that has locations in multiple cities around the US. I want to create a system that generates each business dynamically from the database.
Example: www.mybusiness.com/california-location
My goal though - is to map the california-location to it's own domain --- i.e. www.californiabusiness.com
Is this possible? and how do i go about setting it up?
I am having an initial database with name as DB1, Now when each user registers for my site, a new database is created dynamically, so I need to increment the database name from DB1 to DB2, DB3 and so on.. and it should check the previous database name before creating a new database.
View 1 RepliesI'm currently facing a performance problem with creating POCO objects from my database. I'm using Entity Framework 4 as OR-Mapper. The whole application is a prototype for now. Let's assume I want to have some business objects like classes 'Printer' or 'Scanner'. Both classes inherit from a BaseClass called Product.
The business classes exist.
I try to use a more generic database approach. I don't want to create tables for "Printer" nor "Scanner". I want to have 3 tables: One called Product, and the other Property and PropertyValue (which stores all assigned values to a specific Product). In my business layer I do create a specific object like this:
public Printer GetPrinter(int IDProduct)
{
Printer item = new Printer();
// get the product object with EF
// get all PropertyValues
// (with Reflection) foreach property in item.GetType().GetProperties
// {
// property.SetValue("specific value")
// }
return item;
}
This is how the EF model looks like: Works fine so far. For now I'm doing performance tests for retrieving multiple sets. I've created a prototype and improved it several times to increase the performance. It is still far away from being usable. I takes 919ms to create 300 objects who only contain 3 properties. The reason for choosing such DB design is to have a generic database design. Adding new properties should only be done in the business model.
Am I just being too stupid to create a performant way of retrieving xx objects or is my approach totally wrong? As far as I understand OR-Mapper, they are basically doing the same?
My name is Christian, I developed a web application in VB.NET 2005 that calls a Microsoft Word Application, it works fine in my develop's machine but when I put all of the code in production's server I received the following error:System Error: Cannot create activex component. following I put the code. If somebody knows how to solve this,
Dim oWord As Microsoft.Office.Interop.Word.ApplicationDim oDoc
As Microsoft.Office.Interop.Word.DocumentDim oTable
As Microsoft.Office.Interop.Word.TableDim oPara0
As Microsoft.Office.Interop.Word.ParagraphDim oPara1
As Microsoft.Office.Interop.Word.ParagraphDim oPara2
As Microsoft.Office.Interop.Word.ParagraphDim oPara3
As Microsoft.Office.Interop.Word.Paragraph, oPara4
As Microsoft.Office.Interop.Word.Paragraph
oWord = CreateObject("Word.Application")
oWord.Visible = True
oDoc = oWord.Documents.Add
oPara0 = oDoc.Content.Paragraphs.Add
oPara0.Range.Text = "Hola"
oPara0.Range.InsertParagraphAfter()
I have the following code, i add code for required validator, but when you make selection from dropdown to create the table, the page generates an error. Should the logic be somewhere else to add it to the table? i mean, dont they have to be there so when you submit the form, it fires the validation?
[Code]...
can anyone tell me how to create a sitemap dynamically from a database
cuz I have tried all the static generaors without any good result
I want to create an install script for a simple little CMS I have created for myself... I want to pass the connection string and then create my tables.
I found the following example on MSDN:
[URL]
My question is how do I pass the username and password to the DB...
Is it possible to dynamically create a web page according to database definition and that page can post data back from dynamically created controls?
View 9 RepliesI am able to create database through script generated by SQL Server 2008 but unable to create tables from generated script. Please indicate if any step is missing.
************* Code *******************
[Code]....
****************** Contents of text file appended below ***********************
[Code]....
How to create dynamically html and store into database as path and html file in folder.
View 1 RepliesI don't want to use any asp.control to bind data so.
Is it possible to create dynamically customized table for database record.
I have created a setup application and i want to create my application as an installer application.
I did for testing and while running the setup file this give me the final response is "The installer was interrupted before setup1 could be completed. You need to restart the installer to try again".
I am getting this error on a website. does that mean the server is not competible with asp.net 3.5
Configuration Error
Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Unrecognized configuration section system.serviceModel.
Source Error: [Code]....
Line 236: </assemblyBinding>Line 237: </runtime>Line 238: <system.serviceModel>Line 239: <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />Line 240: </system.serviceModel>
Source File: D:Inetpubvhostsmuratmalli.comhttpdocsweb.config Line:
238
I have 5 link buttons in my asp page, i want to change the text property of the each of the link button to the data retrieved from my database table in th page load. To be more specific i want to display 5 latest film news headings in my home page and if the user clicks on a particular news heading i want to show that news details in a separate page with all the details related to that news.
View 1 Replies Can anyone tell me the differnce between
System.web.httpcontext.current.application["tag"]
or
System.Configuration.Appsettings["tag"]
I have developed an Asp.Net application with backend sqlserver 2008 database. Now i want to install the MSI file in client system along with database file. In client system i want to install the sqlserver with out any sql editor. i.e The sqlserver shouldn't use for development purpose. The sqlserver must acts just like engine between application and database file. In sqlserver which edition i have to install in client system to do the above things ?
View 2 RepliesI need to generate a table from a List(Of Students). My Student class has properties for AcademicYear, TeachingSet, Surname and Forenames, is sorted in that order and also properties for ID and start date. The table should nest TeachingSets within AcademicYears and then the students within the TeachingSets, as shown in the table I've mocked up at http://www.ifslearning.ac.uk/files/student-table.jpg
Using a repeater I get
08-10 students B74394 Mzejb Bsppn
08-10 students B74395 Lbuifsjof Bvti
08-10 students C68924 Epoob Cmpblf
08-10 students D41468 Ipxbse Dbwfz
But I need to have
08-10 students
- B74394 Mzejb Bsppn
- B74395 Lbuifsjof Bvti
- C68924 Epoob Cmpblf
- D41468 Ipxbse Dbwfz
How to create ssrs with parameter in asp.net with c# using sql ....
View 1 RepliesAs I am learning and working on Asp.Net MVC application, I want to know that what is the better place to write Business Logic and Data Access logic in MVC.Where should I write DataAccess and Business Logic among three layers (Model, View and Controller) ??Could anybody please tell me the correct way to write the code for this.Scenario: I want to retrieve all the employees where employee name like 'Mi%' ( I have SQL procedure to execute and retrieve the data.)PS: Want to know that where I should create instance of Business Logic class and where I should create instance of Data Access layers class?
View 3 RepliesI would like to find out if there is anyone who would know how to read from a database then returns the same number of records that a stored procedure returns and display those records on the webpage there after pass the ID of the record to a variable to another stored procedure that displays the data related to the record that was clicked, I tried doing this in a asp.net repeater but I can't seem to be able to reference the controls inside the repeater.
<Repeater HTML Code>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OpenLogs.aspx.cs" Inherits="OpenLogs" EnableEventValidation="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code]....
This question may have been asked before, but I'm looking for a different answer than what I've seen.
Our website is in ASP.NET and we use the model-view-presenter pattern to get business logic out of the markup codebehind.
Is there an accepted pattern for web services for getting business logic out of the codebehind? It seems like putting the logic in a 'presenter' is misleading since the calls don't really present anything to the user, and may not even send back data to the client.
As I began writing web applications with asp.net I started with small projects that used a Linq-To-SQL mapper for database access to a MSSQL Server. After gaining some expierence I switched into a classic 3 tier with Graphic Layer, Business Layer, Data Layer. The only function of the Data Layer was to provide methods insert/update/delete without any logic and logic the form of selection methods.
Over the time I realized that it would be better not to provide the database classes up to the GUI (took some time unfortunately). I switched into using Business classes in the BL that are used for all operations performed by the BL and display by the GUI in the form of getting List from the BL. A great advantage is that I can provide additional properties that are not represented by the database itself. However, I did that mapping inside the BL myself with methods that mapped the corresponding BL class to the database class.
I guess thats where O/R mapper come in handy? Until now I haven't realized their purpose, but I think I just found it. I've recently tried out using the new Entity Framework with .net framework 4, but I'm only using it like the Linq-To-SQL DataContext.
Is there a way to achieve the mapping automatically? If yes, is that something the new Entity Framework provides or do I need to look for a O/R Mapper like NHibernate?
I have an ASP.NET application with existing business classes and a database schema. (which I would like to keep) Currently I am using ADO.NET for the DAL, but I would like to switch to some advanced technology there for easier data retrieval.
Is EF applicable to my situation? Can I use it without splitting up my business classes and auto code generation? Can LINQ to SQL solve my problem better?
All I want to do is map my existing classes to the existing tables and dont have to handle details of the data retrieval myself.
Here is my connection string...?? I cannot for the life of me find out where I'm missing a >, or where there is an invalid < .. the debugger directs me here....
<connectionStrings>
<add name="dbnameremoved" providerName="System.Data.Sql.Client" connectionString="server=dbserverremoved;database=dbremoved;uid=username;pwd=password" />
</connectionStrings>