客户管理系统 [英] Customer Management System

问题描述

您好，我要建立一个我称之为的客户管理系统.
非常感谢您的帮助.

计划是创建一个Web应用程序，一个人(企业主或自雇人员)将在该Web应用程序上登录，并能够创建，编辑或删除客户，创建报告，打印报告和电子邮件发票.没问题，我知道该怎么做.

我的问题是:什么是管理每个帐户的最佳方法?
A).-如果要对所有用户使用一个数据库，或者
B).-为每个数据库分配一个数据库

我完全不知道其他系统是如何做到的.

我想为每个数据库分配一个数据库，但是如何为某些SqlDataSource对象提供连接字符串，这些对象将被硬编码到用于填充GridViews的某些页面中.
请在这里帮助我.告诉我如何执行此操作或为我指明正确的方向.

谢谢.

Hello I am about to build a CUSTOMER MANAGEMENT SYSTEM as I call it.
I would greately a appreciate your help.

The plan is to create a web application where a person (business owner or self employed person) would log in and would be able to create, edit or delete customers, create reports, print reports and email invoices. No problem, I know how to do this.

My question is: What is the best way to manage each account.
A).- If to use one database for all users, or
B).- Assign to each one a database

I am totally ignorant about how other systems do it.

I would like to assign each a database, but how to supply a connection string to some of the SqlDataSource objects which would be hard-coded in to some of pages to be used to populate GridViews.

Please help me out here. Tell me how to do this or point me in the right direction.

Thanks.

推荐答案

首先，您不应对任何内容进行硬编码.

您可以使用一个或多个数据库来完成此操作，这实际上取决于您的使用情况，安全性要求，性能以及其他因素.通常，每个客户都会有一个单独的数据库来确保安全性.连接字符串可以存储在中央数据库中，这样仅显示一个连接字符串.

First of all you shouldn''t hard code anything.

You can do it with either one database or multiple, it really depends on your usage, security requirements, performance, plus other factors. Typically each customer would have a seperate database for security. Connection strings could stored in a central database, that way only one connection string is exposed.

您可以为每个帐户使用单独的数据库.这样就不会有性能问题.在这种情况下，您必须动态管理连接字符串.您可以使虚拟目录和数据库名称保持相同，因此可以从VD名称构建连接字符串.另外，您还必须从后面的代码中分配SQLDataSource并使用动态连接字符串.

希望这会有所帮助:)

谢谢
Vinod

Hi,

You can use separate database for each account. So there will be no performance issue. You have to manage you connectionstring dynamically in this case. You can keep you virtual directory and database name same, so you can build your connectionstring from the VD name. Also you have to assign SQLDataSource from the code behind and use dynamic connectionstring.

Hope this will help :)

Thanks
Vinod

这篇关于客户管理系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！