SQL Server :: Creating Versions Of Content And Manging?
Feb 25, 2011
Im wring a mini cms knowledge base type solution, there is a requirement to create versions of a document so that we are able to revert if neccessary. Ive never done this and although i think im along the write track on the design id like some and advice from anyone who has experience of doing this.
Im using vb.net sql 2005, .net 3.5 and ajax.
Ive created a table with the following which will contains the process details
tempID pk
processID varchar(20)
processVersion int
title
desciption
the processID will be generated by the app, based on a random number generator the version will be set by 1 on the first time page is created. If each time an already existing piece of content is updated i would select the original data, copy it to a new row, creating a new tempID but keeping the same processID, and then incrementing the process version by 1. Where it gets alittle complicated, is that i have another 2 table 1 which contains snippets of content, and 2 which can be relates the process to the snippet, snippets are resusable so can be added to multiple processes, again it must provide versioning of each snippet. table 1 uses the same idea as the process table above
table1
tempID pk
snippetID
snippetVersion
title
content
table2
tempID
snippetID
snippetVersion
processID
ProcessVersio
Is this along the right lines?
View 3 Replies
Similar Messages:
Jul 5, 2010
My new assignment at work is to create a second version of our existing web application. Currently, our application supports only full time brokers, but now we our launching a second site specifically for part time brokers.
The new site will be almost identical to our existing site with the following exceptions:
It will have it's own branding. A couple of the user controls used for displaying information will be different (but none of the pages will be different). Our existing users should not have access to the new site and vice versa. It needs to be easy to test both versions of the website from within Visual Studio easily. We want to reuse as much our existing code as possible. I have 2 weeks to do this. I'm hoping that this is a common scenario and someone out there has some advice for how to accomplish this.
View 4 Replies
May 17, 2010
how to detect the framework versions installed on a server without access to remote desktop or registry? Our server is hosted by Go Daddy and we have limited access, so I wondered if there was a way programatically (in VB if possible)to see the highest or all framework versions installed on the server.
View 3 Replies
Jul 29, 2010
I am using the below code to create file after reading the body
from the database. body contains the content of the document in MIME format.
string dataDir = "D:\Temp_Attachment\";
string strXml = System.Text.Encoding.UTF8.GetString(System.Convert.FromBase64String(body));
Stream wordFile =
new
FileStream(Path.Combine(dataDir, filename),
FileMode.Create);
StreamWriter xmlWriter =
new
StreamWriter(wordFile,
Encoding.Default);
xmlWriter.Write(strXml);
xmlWriter.Close();
wordFile.Close();
The problem i'm facing is that above code works for text files.
When I'm creating image files or pdf files, those files give an error on opening.
View 6 Replies
Apr 13, 2010
I am searching the internet for possible solution for my problem, I have a page that sets the master page at runtime, my problem is how to create a content (asp:Content) control for each of contentplaceholder (that exists at design-time) in each masterpage?? I am looking at AddContentTemplate, but seems not working...
View 2 Replies
Jan 7, 2011
i am working on a project in which i have to create newsletters. We wish to give user functionality of editing the complete layout ( drag and drop if possible) I am able to achieve drag and drop with web parts but can't customise them much like adding richtext box and saving multiple copies of same page with different layouts. I then wish to enable user to send the html only part of page which contains dynamic layout.
View 1 Replies
Mar 31, 2011
I've got a master page and a content page. How can I add controls to the master page's content placeholders programattically?
View 2 Replies
Jul 28, 2010
Im using vb.net, sql2005, ajax, .net3.5. Ok first off, yes i know there are some great CMS applications available already, dot.net nuke, kentico, umbraco, etc etc. However my problem is that i cant bring an external open source app into our organisation but i could develop one.
Im doing this to allow us to move all our HTML content, (Static pages) into a system that provides some sort of basic workflow and content management, im confident on doing this, my problem however is that ive been asked to store the data in XML.
Whilst i know that i can store the XML inside my database, and then read it out and transform im not sure how to do this when it comes to how authors create the pages - What i mean is normally i would give the author an HTML editor to add content, but this isnt going to work if im writing to XML, and also, what happens if they add an table inside the HTML editor
Has anyone every seen this done, is it even possible, or should we just look to use HTML stored inside the DB?
View 1 Replies
Feb 2, 2010
I'm working on master pages. And I would like to create tabs much like firefox tabs sharing sessions which need to navigate on different pages.I tried many solution but all comes into vain.
View 3 Replies
Jan 4, 2011
I am working on a medium size web site and I am kind of stuck. I need to do the following
1- admin user fill a form and submit (Done)
2- the system create new page storing the info provided in step 1
how can I do that? I need a page to be created I don't want to read the data from data base and display it on a template
View 1 Replies
Mar 15, 2011
I want to bind data from SQL server to a dropdownlist. I have found out how to bind the content very simple: I have an array named mat, which I fill with data from this db-call: vb Code:
mat = GetData(clsDbInfo1.GetMaterialer(Session("language"), Session("sId")).Tables(0), Session("language"))
and then I bind the data to the droplist here:
vb Code:
For Each itemMat In mat lstMat.Items.Add(itemMat) Next
But here is my question: How do I bind value content to the dropdownlist just like:
vb Code:
Dim lst0 As New ListItem("Test0", 0) lstMat.Items.Add(lst0)Dim lst1 As New ListItem("Test1", 1) lstMat.Items.Add(lst1)
How do I do that? I have an array including the value content named matId, I want to add the content in the For-Each loop, is that possible??
View 1 Replies
Oct 20, 2010
After I imported a VS 2008 web project to VS 2010, I can't view aspx pages that have master pages in design mode. The page design mode displays "error creating control - contentplacehoder1 object reference not set to an instance of an object." The project builds and runs fine though. I have only one master page that all other aspx pages reference and I don't have any nested master pages.
View 2 Replies
Mar 22, 2010
I'm using this Ajax script [URL] to load content from an aspx page on another server than the page calling the content. So far I've learned that this is a no go. The problem seems to be that when using an absolute link to content the script fails as apposed to using a relative link.
I've searched the web for about 10 hours now, and I still haven't found what I'm looking for.
View 2 Replies
Dec 10, 2010
We had a website deployed on IIS server remotely say www.liveserver.com.
We recently decided to make a copy of the website internal to the organisation so we brought a server and copied all the code from live server and configured it and say it is http//archives-testserver.com
Everything seems to work fine but while navigating and clicking on certain module links within http//archives-testserver.com......the domain name is getting rewritten to www.liveserver.com and user is made to navigate on the live site. I wonder where this
configuration is with in IIS...
I looked under properties under website identification and everything is referring it as http://arhives-testserver.com. also thr is a file called securityRedirect.inc and ifor handling errors and all the references have been changed and couldn't find anything in web.config. where else to look for probable reference to live site?
View 3 Replies
Sep 20, 2010
I maintain a web application that is painful to upgrade. It's not painful because the code is bad, but because there are a lot of devices connected to this application via the web and getting them to update their clients is a lot like moving concrete.
So I had an idea that I could simply present a different version of the application to different customers. The session stores the client information. So what I'd ultimately like to do is peak at that session and then use that to present the "correct" version of my app to them.
Physically the apps are stored in a manner like such:
C:Program FilesCompanyProgramVersionWebWebApp
So you can see that I could have multiple versions installed at once. Basically if customer A goes to the site they get presented with C:Program FilesCompanyProgram1.0.0.0WebWebAppfoo.aspx And if customer B visits the site, they get to see C:Program FilesCompanyProgram2.0.0.0WebWebAppfoo.aspx.
I initially thought of using the IIS rewrite module, but I really don't want to redirect them. I want this to be seamless. how this can be implemented?
update:
After further research, I thought it would be clever to use the Global.asax.cs to accomplish my goal. So in the Application_BeginRequest event handler, I wrote the following:
[code]...
By the way, /art/ is a virtual directory that I grafted into this directory via IIS. This would be similar to how I would set it up in production. Anyway, I get the following error when I try this.
The virtual path '/art/test.html' maps to another application, which is not allowed.
So how do I do this then? Is there an "allowed" strategy for accomplishing this? Doing it through the Global.asax.cs would be ideal since I could use the HTTP Context to "know" which customer is connecting to the app.
View 1 Replies
Nov 7, 2010
I have an asp.net mvc2 project that will be deployed on several servers. Some may run on IIS6, IIS7 (Classic), or IIS7 (Integrated).read this article on how to deploy to these servers, but I was wondering if my routing can be set up in such a way that it can handle any version of IIS. That way, I only need to use the same routing in my global.asax. This is my routing right now.
[Code]....
I decided to use the option of handling the aspx extension so I don't need to do anything anymore to the IIS settings. Unfortunately, I can't test it right now because my IIS isn't functioning right (dunno why). So, I'd really appreciate some help on this one.
View 5 Replies
Dec 19, 2010
i'm programming an application where an action is done if i access with a version equal or higher than other and another action if i access with a lower version; but the problem is that the lines to indicate the versions doesn´t work. The code is the following:
[Code]....
As you can see, an action should be done if the version is the 9.0 or higher and other if it is lower, but these lines doesn't work and only works the detection of the web browsers (no the versions of them, action that doesn't works).
View 2 Replies
Nov 11, 2010
sorry for buther I'm a newbie in ASP.NEt MVC and I have some issue deploying my application on IIS, that use a logo image within my main master page declared as
<img src="../../Content/logo.bmp" alt="logo" />
When I use the internal visual studio web server work well but not on my other IIS Server.
What's the mean of ../../Content ? Is this directory deployed with particular rules?
View 2 Replies
Jul 28, 2010
I built an assembly, and that assembly refereces a DLL in my bin folder (lets call it Bob.dll). so multiple users may have different versions of Bob.dll...but by and large they all function the same.
However when my assembly gets dumped into the bin folder, it wants the version it was compiled against.
Is there a way to compile a reference such that it'll just be happy with ANY version?
I know it can be done with assembly binding in the webconfig, but I dont want users to have to do that.
View 3 Replies
May 3, 2010
My web page is still displaying a previously cached versions of the page. I have this in the page_load event:
Response.Clear();
Response.Buffer = true;
Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);
Response.Expires = -1;
Response.CacheControl = "no-cache";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
I have this in the Page_Init:
protected void Page_Init(object Sender, EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetExpires(DateTime.Now.AddDays(-1));
}
View 2 Replies
Dec 11, 2010
I'm working with an MVC2 app that had migrated from an MVC1 app quite a while ago. Things have been working - i've been able to compile and deploy a number of iterations without any problems ..
I've noticed that the version info - that bit in the footer of runtime errors - i've received during the normal course of development reads:
Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955 despite the fact that the project's Properties | Application tab shows the target framework to be .net 3.5. I _think 3.5 is required for mvc2 apps, isn't it?
Shouldn't I expect to see runtime error pages pointing to version info at the 3.5 version?
UPDATE: As that this isn't a simple matter of a framework mismatch, here's the error - but given other factors, I'll assume I need to repair/refresh the workstation's framework installs. The same code works on another ws.
[code].....
View 1 Replies
Apr 14, 2010
I have an ASP.Net web site (ASPX and ASMX pages) with a single web.config file. We have a development version and a production version. Over time, the web.config files for development and production have diverged substantially. What is the best practice for keeping both versions of web.config in source control (we use Tortoise SVN but I don't think that matters)?
It seems like I could add the production web.config file with a name like "web.config.prod", and then when we turnover all the files we would just add the step of deleting the existing web.config and renaming web.config.prod to web.config. This seems hackish, although I'm sure it would work. Is there not some mechanism for dealing with this built in to Visual Studio? It seems like this would be a common issue, but I haven't found any questions (with answers) about this.
View 3 Replies
Nov 30, 2010
I am setting up a new website on new web servers that are running IIS 7.5, which is new to me. I have ran into a problem when deploying an ASP.NET app that is using the 4.0 framework. I get error messages about conflicts with the web.config file associated with the Default Web Site. The asp.net app defined in the default website is using the 2.0 framework currently. My 4.0 framework app is defined as an application under the default website. Both are using different Application Pools. I tried adding this to my 4.0 apps config file
<location path="." inheritInChildApplications="false">
How do I get around this web.config conflict issue? Update for error message: There is a duplicate 'system.web.extensions/scripting/scriptResourceHandler' section defined. The config file for the 4.0 app does not even have this section. The default website app does have this.
View 2 Replies
May 31, 2010
I'm implementing version control system using WCF service and client application. I can not figure out, how to store files on the server side to easily access different versions.
View 6 Replies
Jan 11, 2011
I have a single project website and I would like to create different versions of it to be hosted on different web servers. I do not know if I need to have different versions of the web pages placed in different projects within a single solution or if I need to put different versions in a single project within multiple solutions. I need to be able to build and publish each version separately as an independent website for uploading into a different server. What should I do?
View 4 Replies