I want to design a database of chemical material. As every body knows that the chemical material has more than 20 variety of features such as color, molecular weight,temperature,pressure,pH, etc. I learn that all of features was designed into description item in some database,but I think it is not an easy way to research. As a good SEO principle,I expect material can be searched by many items, could you tell me how i improve that design,
StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); lblChemicalFormula.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); HTMLWorker htmlparser = new HTMLWorker(document);
I've just finished my database design and now i'm going to start implementing it in SQL Server 2008. Since i'm creating an ASP.NET Web Application i would like to use Membership Provider to manage user access to the application. In other projects (more simpler) i used Membership but always with its default parameters.
In this recent application i need to use custom user data for it to work properly.
So, what i would like to know is, how can i use my 'Users' table in my DB with .NET Membership Provider?
how to design following small webproject and database .i am totally new in this area.
I need to quickly develop a system so that everyone can access the status of the job going online into the system
Activities
Move the job between work centers when it's completed.
Transfer button. So when design is done we should be able to click the transfer button and move the job from Design to Procurement
Here are the work centers.
plan cerement TST Shipped Each work center should have due dates User will have to update manually due date for each work center and this will be different for each job.
I have a ordinary Category/Product database relationship Design structure.
Now i wish to add a sub category to this architecture.
for example, Cloths Category needs to be sub divided - Women,Men,Children categories.Also what about other Ctegories such as: Car,this also has sub divisions: Model,Type.
My Products table contains ProductName field together with generic field for Size,Colour and Price fields.
How do you therefore incorporate this sub division into the existing Category/Product relationship model and is there a model example?
In my web application I want to log certain user interactions etc, like "User ABC joined Group XYZ" Therefore I want to set up a logging mechanism that logs into a Mssql database. I'm now trying to find a good database design to achieve flexibility.
First of all, I don't want to log strings like "User ABC joined Group XYZ". I'd like to separate the content "ABC" and "XYZ" from the template. So I'm looking for a templated logging database.
Something like this: table: UserLog
IDLog int primary key [code]......
I think this database structure would give me enough flexibility to add/remove/edit specific log types (like 'User ABC did something else'). For example I might want to add some information to a specific log entry for future entries. Therefore I create a new UserLogTemplate that references the same UserLogType. That is how I would achieve downward compatibility.
I am building a page that displays a product's details, with the information being called from an MSSQL database.I would like to be able to have a variable number of features listed for each product, so for example, Product A has a list of 3 features, Product B has a list of 7 features, Product C has 2 features listed etc.I would like to avoid having a lot of NULLS in my database, and would prefer not to restrict the number of possible features listed.Is there a common way to tackle this problem? Is it simply a case of setting up a table just to store features?
I'm in the process of re-writing an existing survey application that is currently using nested repeater controls to display questions and answers. The application was not designed with future enhancements in mind and its a pain any time a new question has to be added to the application. The repeaters currently contain questions, answers, and controls(texbox, radiobuttonlist,etc.)
Is the repeater the correct control to use for this type of application? What is the best way to design this type of application and table structure? Are there any new controls or features in VS2010? How to design this application the correct way and make it more flexible?
I'm looking to create a survey with a Radio Button List and a submit button and then I want to store the result in a database. Not sure how to do design the database columns or handle the click event to write the survey answer to a database.
for years now I have had a problem with trying to design the best database design for an internal email messaging system for a website.
I would have thought that this would be a fairly easy thing to think of at this point in my development history but it still eludes me to no end.
What irratates me even more is that I would think i could find something online giving more detail about it but i have yet to find the right search term to use
i am making an application which is like chain system..i mean one person can have multiple child.. then his child can have multiple child ..etc like chain system...i dont know to insert into database.. so that when i call any-node.. his child,, and their futher child will show...
The user enter the name,address,country,qualifiction,experience the user enter more than one qualification, and experience the add another button click will add another qualification, and experience...i am confused in designing the database how to design the database for this . i am design this tables .
If I want to be able to have a table Consultant, which is the user and their personal information, and I want this user to be able to select their proficiency in a number of Programs (software) on a scale from 0-5 (zero being no experience whatsoever), how do I do this best?
I mean I could have a Consultant table with a one-to-many relationship to a Program table, and then have all the limited Programs availalbe loaded by an XML file or something, and for each Consultant associate all the Programs and their Levels of proficiency. But that seems very wrong and inefficient.
It seems to me I should have a table with all the (limited number of) Programs, and then by some sort of association between the two by Ids. But I can't get my head around how to do this. I'm thinking many-to-many... But first, is this correct? Secondly, how do I do this in an Entity Framework Model? I usually create my database code first, i.e. create the EF model, and then generate database from model. Will I get a junction table where I can add the Level field, because basically a Consultant HAS A Program with a Level, or actually a list of Programs each with a Level.
I am in the process of redesigning our main product, a knowledge database system for clients to access clinical and specialist advice articles. There is a requirement to add "Social Networking" to this allowing users to connect and post remarks etc...
This is somewhat similar to the Facebook wall scenario - where Articles, Photos, Groups, Products, Events, ActivityFeed can all have comments. I am at a lose as to the database design I would need to implement this. All comments must allow for Moderation/Approval/Spam Reporting etc...
I originally thought a individual table for each Comments entity ex: ArticleComment, ProductComment would work as the comments themselves are not all directly related. Each table having the same exact columns. But this makes life abit awkward as then this creates a separation between something that for all purposes is the same i.e. They are all comments.
The other design idea was to have a single Comment table with an "arc" type relationship to related tables with FK references back to the source.
The other option was to have a single Comment table with an Object Type and XID but this breaks the rules of relation and does not all for referential integrity.
I am at a lose and don't know what to do. I have asked over at SQLCentral.com and all I have done is raised more questions than answers about what to do.
Design 1: This would require exact copies of this table for all the entities.
-- Photo Comments -- CREATE TABLE dbo.PhotoComment ( CommentID int IDENTITY(1,1) NOT NULL, PhotoID int NOT NULL, Body ntext NOT NULL, ReportedAsSpam bit NOT NULL CONSTRAINT [DF_PhotoComment_ReportedAsSpam] DEFAULT (0), IsSpam bit NOT NULL CONSTRAINT [DF_PhotoComment_IsSpam] DEFAULT (0), IsApproved bit NOT NULL CONSTRAINT [DF_PhotoComment_IsApproved] DEFAULT (1), CreatedDate datetime NOT NULL, CreatedBy uniqueidentifier NOT NULL, UpdatedDate datetime NOT NULL, UpdatedBy uniqueidentifier NOT NULL, IsDeleted bit NOT NULL CONSTRAINT [DF_PhotoComment_IsDeleted] DEFAULT (0), CONSTRAINT [PK_PhotoComment] PRIMARY KEY (CommentID), CONSTRAINT [FK_PhotoComment_PhotoID] FOREIGN KEY (PhotoID) REFERENCES dbo.Photo(PhotoID), CONSTRAINT [FK_PhotoComment_CreatedBy] FOREIGN KEY (CreatedBy) REFERENCES dbo.aspnet_Users(UserId), CONSTRAINT [FK_PhotoComment_UpdatedBy] FOREIGN KEY (UpdatedBy) REFERENCES dbo.aspnet_Users(UserId) )
Design 2: The "Arc" relationship
CREATE TABLE dbo.Comment ( CommentID int IDENTITY(1,1) NOT NULL, CommentType char(1) NOT NULL CHECK(CommentType IN ('A','I','E','G','U','P')), Body ntext NOT NULL, ReportedAsSpam bit NOT NULL CONSTRAINT [DF_Comment_ReportedAsSpam] DEFAULT (0), IsSpam bit NOT NULL CONSTRAINT [DF_Comment_IsSpam] DEFAULT (0), IsApproved bit NOT NULL CONSTRAINT [DF_Comment_IsApproved] DEFAULT (1), CreatedDate datetime NOT NULL, CreatedBy uniqueidentifier NOT NULL, UpdatedDate datetime NOT NULL, UpdatedBy uniqueidentifier NOT NULL, IsDeleted bit NOT NULL CONSTRAINT [DF_Comment_IsDeleted] DEFAULT (0), CONSTRAINT [PK_Comment] PRIMARY KEY (CommentID), CONSTRAINT [FK_Comment_CreatedBy] FOREIGN KEY (CreatedBy) REFERENCES dbo.aspnet_Users(UserId), CONSTRAINT [FK_Comment_UpdatedBy] FOREIGN KEY (UpdatedBy) REFERENCES dbo.aspnet_Users(UserId), CONSTRAINT [UC_Comment_CommentID_CommentType] UNIQUE (CommentID, CommentType) )
CREATE TABLE dbo.Comment ( CommentID int IDENTITY(1,1) NOT NULL, ObjectType char(1) NOT NULL, /* A = Article, P = Photo etc... */ XID int NOT NULL, /* Would be the ID of the main entity being queried. */ Body ntext NOT NULL, ReportedAsSpam bit NOT NULL CONSTRAINT [DF_Comment_ReportedAsSpam] DEFAULT (0), IsSpam bit NOT NULL CONSTRAINT [DF_Comment_IsSpam] DEFAULT (0), IsApproved bit NOT NULL CONSTRAINT [DF_Comment_IsApproved] DEFAULT (1), CreatedDate datetime NOT NULL, CreatedBy uniqueidentifier NOT NULL, UpdatedDate datetime NOT NULL, UpdatedBy uniqueidentifier NOT NULL, IsDeleted bit NOT NULL CONSTRAINT [DF_Comment_IsDeleted] DEFAULT (0), CONSTRAINT [PK_Comment] PRIMARY KEY (CommentID), CONSTRAINT [FK_Comment_CreatedBy] FOREIGN KEY (CreatedBy) REFERENCES dbo.aspnet_Users(UserId), CONSTRAINT [FK_Comment_UpdatedBy] FOREIGN KEY (UpdatedBy) REFERENCES dbo.aspnet_Users(UserId), CONSTRAINT [UC_Comment_CommentID_ObjectType_XID] UNIQUE (CommentID, ObjectType, XID) ) -- Ex: Get all comments for article ID 23. SELECT * FROM Comment Where ObjectType ='A' and XID = '23'
If I store the data every second, the database will grow rapidly. I need to have less detail of measurements of a few weeks/months back. An average would be enough. I have 5 sensors: wind speed, wind direction, temperature, light and rain. How would I design my database?
The database has been designed for a tradesman web site, i.e. Plumbers, Builders etc. The two main tables are tblCustomer and tblTrader which will stored data from two frontend web pages where the customer and trader can enter their personal details. After a customer enters their personal details (i.e. registers through the site) they will then be directed to a child page where they can progress to entering a specific job attached to a specific trade (i.e. Plumber) and trade type (i.e. Bathroom Installation), once a customer job has been entered I want these details to be emailed to all the trader_email addresses from tblTrader, from this email alert the traders will then enter the system and offer quotes to the customer through tblTraderQuote where the customer will then accept the best quote for them.
What I also want to implement is some sort of rating option that will allow the customer to rate their trader, either something like ebay's feedback or just a simple 1-5 rating option? How can I implement this into my database design or is this something that should be performed within the programming layer?
In our application, we store the most number of users online. We do this by tracking what page each user is on currently and upon login, delete users who have been inactive for X minutes and then take a count of the users online, overwriting the most number online if this is higher.
How can we change this to track the number of users online over a time period, so we can look at a line graph of the number of users online. I guess we'll need a cron to run every 1/2/5/10/20/30/60 minutes to track the number online? Then how would be store this data, the table would get very large. I would think the likes of Statcounter/Analytics would have a better way of storing this data.
I am working on a multi-lingual application Assume the following:
Database has 50 tables and application has to support 5 languages
Which is the best way to design the database:
1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.
everytime I modify an SQLdatasource using VS wizards, I have to dettach the mdf in VS's server exporer, then hit refresh in the browser, then get the applicaiton is offline error message please remove some pia file, but i usually just count to 12 and then hit refresh again and the page renders properlyhad scoured the forum on more than one ocasstiion, think it has something to do with the Admin rights within SQL, Ive tried the SQL server surface configuration tool, and add administrator stuff, but not sure if i should add (user to provision) something like the asp.net thing, or network services or ??also cant figure out where to view which administrators are actually on SQL server,
