We have a pretty big database with hundreeds of procedures, triggers, functions, views, etc. Now we are in the process of moving from VSS where SQL Objects were not added to the TFS. Is there an efficient way to add all the SQL Server objects to the TFS?
View 1 Replies
I have the following tables:
Campaigns (CampaignId, CampaignName, etc)
Urls(UrlId, CampaignId, UrlText)
I have a relationship setup between Campaigns table and Urls (FK_Url_Campaign) everything works fine when I try to add a new campaign but when I try to insert a new Url I get:
Entities in 'DatabaseEntity.Url' participate in the 'FK_Url_Campaign' relationship. 0 related 'Campaign' were found. 1 'Campaign' is expected.
This is my code:
// INSERT
public int Insert()
{
Url dbUrl = new Url();
dbUrl.CampaignId = (int)CampaignId;
dbUrl.Url1 = (string)Url;
context.AddToUrl(dbUrl);
context.SaveChanges();
return (int)dbUrl.UrlId;
}
Pretty much i want update/add new campaign and then I call Insert for Url. how would i go about doing this?
I'm trying to add Div Objects to an array and trying to access them later when I call my loadViews function. All of my alerts fire, in the proper order, but the array m_Divs is always of length 0.
I'm re-registering the script each time on Page_Load, due to it throwing an "Error: Object expected" after each page_load when trying to call the javascript if I don't.
.JS file.
[Code]....
As you will gather from this post I am new to visual studio
When in design view multiple objects being dragged onto a <p> placeholder will only display one on top of the other.
How can I get them to display side by side.
have some Objects, lets say Employee and Role defined as below and I have defined relationships in my database that gives me a list of objects say employees and thanks to my framework each employee object also has a Role object linked via the RoleIDID, UserName, Password, Email, RoleIDRoleID, RoleNameSo in code I can do something like this
Employee emp = dataService_GetEmployeeByID(1);
string RoleName = emp.Role.RoleName;
Now here is my problemI can bind any object in a repeater and it works fine for the first level in my relationship
For instance <%# Eval("UserName") %>
But I need to be able to show the details for my child objects as well (Role) so something like this (which does not work)
<%# Eval("Role.RoleName") %>
I know how to bind a simple objects to a dropdown list. However I am having problems binding my objects which contains sub objects to the control.i.e. with simple object i just do ddl.DataValueField = "myproperty"
with my objects they contains sub objects which i want to bind. I have tried ddl.DataValueField = "sub-object.myproperty" which doesnt work.
firstly a static class only ever exists once and is not an instance. Any static members (ie static int NoOfPeople;) is stored in one place and is shared between all sessions (like the old global variables).
Now static methods is where i'm not 100% sure. If I have a static method that doesn't use any other static members could this cause inconstant results, example (this is a fairly pointless method but just a quick example of the top of my head)
[Code]....
So in this example if two sessions (or threads) were to call this at the same time - would they both get back the expected results, because the method only uses private data (a, b and totalToReturn).Im sure this sounds a little simple but I will be using static methods to build user objects and various other objects that there will have to be a 100% garentee that the objects will not get mixed up between sessions and the wrong things return to the user.
I am loading in my page a html code that have server an client objects. View sample:
<b>prueba imagen</b>
<img alt="hola mundo" src="_img/personalcarta/img_off.png" />
<asp:ImageButton ID="Img4_izq" class="Imagen" Width="95px" Height="95px" runat="server" ImageUrl="~/_img/personalcarta/img_off.png" OnClick="Img_Click" />
the problem is only load me the client objects. How Can I do it for load server objects since an html code?
I have to find a design decision for the following task: I have a SQL Server database and it contains a table of orders. PDF documents will be uploaded by users through a simple file upload from a web page and assigned to an order. There is not more than one document per order (perhaps no document, never more than one). For this purpose a user opens a web page, enters an order number, gets the order displayed and clicks on an upload button. So I know to which order the uploaded document belongs to.
Now I am considering two options to store the documents on the web server:
1) Extend my table of orders by a varbinary(MAX) column and store the PDF document directly into that binary field.
2) Save the PDF file in a specific folder on disk and give it a unique name related to the order (for instance my order number which is a primary key in the database, or a GUID which I could store in an additional column of the order table). Perhaps I have to store the files in subfolders, one per month, and store the subfolder name into the order row in the database, to avoid getting too many thousand files in one folder.
After the PDF files are stored they can be downloaded and viewed via browser after entering the related order number.
I'm tending towards option (1) because the data management seems easier to me having all relevant data in one database. But I am a bit afraid that I could encounter performance issues over time since my database size will grow much faster than with solution (2). Around 90% or even 95% of the total database size would be made up only by those stored PDF files.
Here is some additional information:
The PDF files will have a size of around 100 Kilobyte each
Around 1500 orders/PDF files per month
Windows Server 2008 R2 / IIS 7.5
SQL Server 2008 SP1 Express
Not quite sure about the hardware, I believe one QuadCore Proc. and 4 GB RAM
Application is written in ASP.NET Webforms 3.5 SP1
(I am aware that I will reach the 4GB-limit of the SQL Server Express edition after around 2 years with the numbers above. But we can disregard this here, either removing old data from the database or upgrading to a full license will be a possible option.)
My question is: What are the Pro and Contras of the options and what would you recommend? Perhaps someone had a similar task and can report about his experience.
I have problem in maintaining the application objects in the server when it is deployed in the web farm.In our application i'm storing the sessionID and and the column value ( "tvktnx55vl5mzr453dmaehit " + "A101" ) in arraylist and storing it in application object. when i test this it is ok. but when we deploy it we have one issue that is we cannot share the application object in web farm.
View 1 RepliesI have this object in my server side:
[Code]....
Now I do this on the client side, to send a typed object to the server:
[Code]....
and actually it works. The problem is that I cannot find the way to stablish this property: "public ThingDetails[] details;"
I have recently updated from web developer 2008 express to 2010 and notice that the drop down for server objects & events that is included in the 2008 edition does not seem to exist in this edition. I have tried all the settings and switched on Experts settings and imported all the expert settings but to no avail.Is there a different way to select events in 2010 version (I was using it to import procedures mainly for validation).
View 2 RepliesI'm working on a project in which we have a database, data layer (entity framework), business layer and web/UI layer.I want to use ASP.NET Dynamic Data for the web layer, but don't want it to access the data layer or database, as I want it to be purely running off business logic, and not directly accessing the data.However, it appears that Dynamic Data only allows Linq-to-SQL or entity framework data sources to be used.Has anyone used it with business-layer objects instead?
View 1 RepliesI have just run into a situation with a FormView control where any markup that is not given an ID and runat=server attribute is NOT rendered to the browser.
In other words, all of the extranneous markup (h#, fieldsets, legends, divs, labels, etc.) that are in my Edit Template DO NOT render to the browser at run-time. However, if I add an ID to any of those items and add runat="server" then they are rendered.
Has anybody every seen anything like this? Does anybody know what could possibly cause this?
Lets say I am doing a shoping cart. I authenticate the user with a session variable.For example:
If(Request.IsAuthenticated)
// Here I want to add to the shoping cart.
// Can I do the following
Session["Cart"] = "Washing Machine";
Now will this Session["Cart"] value which is washing machine here be unique to diff customers?
I hosted my application in production. Within 5 to 6 hours the application pool spikes and uses more memory?
What application objects or system objects are stored in the application pool?
Using in-line code in VS 2010 RC and I can't get the "server objects and Events" drop down to show up.
Not sure if this is a bug or what...in VS 2005 / 2008 it would just appear at the top of in-line code files. I've checked the options/settings menus and haven't found any way to enable it.
In VS2008 source view, the left side object dropdown is missing "Server Objects & Events", and "Server Code". I would like to know how to enable these to be visible.
The controls on the page do contain runat="server".
when make buakup to my data base and open the database digram this error appear : Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
View 1 RepliesI have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
Adding runat="server" is not rendering my server tags <%...%>
I have a masterpage with a few <li> for menu and since I have to set class=selected for the current page, I am using a little server tag to find the url and assign the particular class.
I have total of 10 <li> and not all menu is available to all types of user, I need to toggle few of the <li> if the user is not admin, so I have runat="server" added to them so I can set their visible=false through c#
Here is how it is at a glance:
<li runat="server" id="liBlog" class='<%= Request.Url.AbsoluteUri.EndsWith("/Blog") ? "selected" : "" %>'><a href="/Blog">Group Blog</a></li>
<li runat="server" id="liPoll" class='<%= Request.Url.AbsoluteUri.EndsWith("/Poll") ? "selected" : "" %>'><a href="/Poll">Poll</a></li>
<li id="liInvite" class='<%= Request.Url.AbsoluteUri.EndsWith("/Invite") ? "selected" : "" %>'><a href="/Invite">Invite</a></li>
<li id="liFavourite" class='<%= Request.Url.AbsoluteUri.Contains("/Favourite") ? "selected" : "" %>'><a href="/Favourite">My Favourites</a></li>
The <li> without runat="server" works fine, when on correct page the source code shows class="selected" or class="" as appropriate, the other <li> used to work fine too, until I decided to add the runat="server".
Once I added that runat="server", the whole block of class="" is being sent out to the html page, its not processing the server tags at all! I right click on the html and look at the source, it's being rendered as:
<li id="ctl00_ctl00_ContentPlaceHolder1_liBlog" class="<%= Request.Url.AbsoluteUri.EndsWith("/Blog") ? "selected" : "" %>"><a href="/Blog">Group Blog</a></li>
It's pouring out my server tags into the source code!
Why is this behaviour seen? How can I avoid it?
I am struggling to find out the problem with something. Basically on this page:
[URL]
If you look at the nursery diary tab, will see an article, the first article is named "Test article for archives 1". Now the date should be 01 April 2010, but instead its showing as 04 Jan 2010.
I don't understand why. I have been looking at my insert statement and when i insert in the admin section i have a AJax date extender. And it populates the text box like so '01/04/2010'
But then when i check in my database i notice it has been added as '04/01/2010'.
What does this mean?
My insert statement is like this:
<snip>
The insert works perfectly, but the date format is inserted wrong.
I've a scenerio where i've to create a primary key with prefix Rad####. For example Rad0001. How to do that.
View 2 RepliesI have currently have Microsoft Visual Web Developer 2008 Express Edition and SQL Server 2008 R2 installed on my PC but I am having problems finding out where I enter my data to populate tables held in my db.
On the SQL 2005 version their was a option to open the specified table and add in information.
I've looked at both 2008 programmes and it's not obvious to me on how I would do this.
auton=createsid(num)
INSERT INTO Store_Information (sid,store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
in the baove i need to add the SID which is a no obtained from incrmenated function, how do i add itautono will contain the incremnet value which i need to add to sid column
