ADO.NET :: Use The Item Description Look Up Table And Store The Item Description Id In The Items Table?
Dec 31, 2010
i have the following two questions:-
1. let say i have a table for ITEMS including (item id,item description id (FK to the ITEM Description tabe), item price,etc) and have ITEM Description look up table having (item descriptionid,item description),.
so what is better to use the ITEM DESCRIPTION look up table and store the item description id in the items table
or
to directly store the item description "Not the id" in the item table.
2. I am working on an MVC web application using LINQ, now if i want to modify the SQL server tables which i have created for example modify some of the foreign key properties will the effect be directly reflected on any new inserted or deleted records or i have to create a new LINQ to SQL class?
View 3 Replies
Similar Messages:
Apr 5, 2010
is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc? if so, how?
View 3 Replies
Jan 28, 2011
I have added a dropdown in a column of my gridview control and it is binded to a table. What I need is when the user selects an item from the dropdown, it updates the row with other info. They are selecting an item number and I need the item description and price to be filled in for two other columns in the row. How can I do this on an event?
View 4 Replies
Feb 7, 2010
I have a MVC dropdown list (Html.DropDownList) with list of Movies populated. I want to retrieve both Title(value field), Description(Text field) when I perform the form Submit. I can access the Title(value field), but I can't access the description. My code sample is below.
[Code]....
public string CinemaName { get; set; }
View 4 Replies
Jan 30, 2011
<asp:FormView ID="FormView1" runat="server" DataKeyNames="productnum"
DataSourceID="EDS_Product">
<ItemTemplate>
<div class="ContentHead"><%# Eval("name") %></div><br />
<table border="0">
<tr><td style="vertical-align: top;">
<img src='images/big/<%# Eval("image") %>' border="0" alt='<%# Eval("name") %>' /></td>
<td style="vertical-align: top"><%# Eval("description") %>
<br /><br /><br /></td></tr></table>
<span class="price"><b>Your Price:</b> <%# Eval("price", "{0:c}")%><br /><span class="number"><b>Number:</b> <%# Eval("number") %>
</span><br /><a href='AddToCart.aspx?productnum=<%# Eval("productnum") %>'>
<span class="ProductListItem"><b>Add To Cart<b></font></span></a>
</ItemTemplate>
</asp:FormView
this is from the product details page and the description goes in a straight line always - i want to make the description a box and have lenght of 30 characters every line -- i want to modify the description not to be in a straight line
View 3 Replies
Dec 15, 2010
I have a site where users can save images together with a couple of info fields about the image. The images are stored as binary data in the same table as the rest of the image info. So far pretty standard.
Now, the users should be able to upload a document, describing the image in more detail, along with the rest of the image and its' info. Size ~2MB per document.
My question is: Should I store this document (binary data) in the same table as the rest of the images or should I create a new table holding only the documents. There would of course be an id reference in the image table to the document in the document table.
I have a search function joining a couple of tables, including the image table, when searching for images. I need to know if there's a difference in efficiency between these two solutions. I always fetch the document data separately but if I don't win anything in having the documents in a separate table I'll just put it with the rest of the image info.
I'm asking this since I don't really know how SQL Server handle tables when joing and searching in them.
I have about 10´000 users with a maximum of 10 images per user. (ASP.NET - SQL Server) (I'm not asking if I should store documents in the database, but how ;)
Edit
Example 1:
columns in imageTable - id, title, dateAdded, image (binary data), document (binary data)
Searching for items from a specific user I would join the userTable and the imageTable and select title where image id equals user id.
So, will there be any difference in the performance if the document is in the imageTable or in an own table?
View 1 Replies
Feb 28, 2011
I have in my database the News Table which consist of => Id, Title, txt . I need to be able to get a description text from the whole text which exist in txt Field , but without any codes like <...> , just a pure text !! how can I do this?
View 3 Replies
Apr 8, 2010
I am trying to inject inside repeaters items, the problem is that the row is generated in a wrong location. If you try this simple example, you will see that the rown is generated under label '2' as it should be generated under label '1'. Why does it happen? And how to fix that?
protected void Page_Load(object sender, EventArgs e)
{
int [] array = {1,2,3,4,5};
rpt.DataSource = array;
rpt.DataBind();
}
protected string _extraRowHtml;
protected void rpt_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
int tmp = ((int)e.Item.DataItem);
_extraRowHtml = tmp == 1 ? "<tr><td class="topicsRow" colspan="100%"> Topics </td></tr>" : string.Empty; ;
}
}
<asp:Repeater ID="rpt" runat="server" onitemdatabound="rpt_ItemDataBound">
<HeaderTemplate>
<table cellpadding="0px" cellspacing="0">
</HeaderTemplate>
<ItemTemplate>
<tr style="height:50px">
<td>
<asp:HyperLink ID="lnkTitle" runat="server" Text='<%# Container.DataItem%>'/>
</td>
</tr>
<%# _extraRowHtml %>
</ItemTemplate>
<FooterTempl
</table>
</FooterTemplate>
</asp:Repeater>
View 2 Replies
Mar 31, 2011
I have a DropdownList.In this List i have some items like empid.I have four textboxes also.when i select the particular empid in the DropdownList,the remaining row values of the table in the oracle like empname,empbs,empdoj,emploc values should display in the textboxes.
View 2 Replies
Mar 11, 2010
I have a dataset with the following values:
NAME, NUMBER
Test3, 1
Test2, 2
Test3, 3
I am basically need the ability to do something like dataset.tables(0).row( ' here i would be like where item("NAME") = "Test2" ' ).Item("NUMBER")
View 2 Replies
Apr 27, 2010
I have a form free user feilds, some drop down which are populated by a database data and a button. I want to create a new line in a table when the user clicks on the button. the values for this new line will come from the Values (not visible content) of the drop box, the content of the text feild, the user ID that I should get from the connection and the current date... ie, I want do do a INSERT INTO table (userid, dropdown, text, date) values (how do I get the user ID from the session?, how do I get the value from the drop down?, how do I get the text from the text box?, how do I get the current date?)
View 6 Replies
Oct 26, 2010
I have written a function and want to add some description against each paratemeter it takes, how can i do this in vb.net?
[Code]....
View 2 Replies
May 27, 2010
How to replace cell value with their description. This is my grid
<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" GridLines="None">
<HeaderContextMenu EnableAutoScroll="True">
</HeaderContextMenu>
<MasterTableView AutoGenerateColumns="False" DataKeyNames="OrderID" DataSourceID="SqlDataSource1">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="OrderID" DataType="System.Int32" HeaderText="OrderID"
ReadOnly="True" SortExpression="OrderID" UniqueName="OrderID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CustomerID" HeaderText="CustomerID" SortExpression="CustomerID"
UniqueName="CustomerID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="OrderDate" DataType="System.DateTime" HeaderText="OrderDate"
SortExpression="OrderDate" UniqueName="OrderDate">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="RequiredDate" DataType="System.DateTime" HeaderText="RequiredDate"
SortExpression="RequiredDate" UniqueName="RequiredDate">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ShipName" HeaderText="ShipName" SortExpression="ShipName"
UniqueName="ShipName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ShipAddress" HeaderText="ShipAddress" SortExpression="ShipAddress"
UniqueName="ShipAddress">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ShipCity" HeaderText="ShipCity" SortExpression="ShipCity"
UniqueName="ShipCity">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ShipRegion" HeaderText="ShipRegion" SortExpression="ShipRegion"
UniqueName="ShipRegion">
</telerik:GridBoundColumn>
telerik:GridBoundColumn DataField="ShipPostalCode" HeaderText="ShipPostalCode" SortExpression="ShipPostalCode"
UniqueName="ShipPostalCode">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ShipCountry" HeaderText="ShipCountry" SortExpression="ShipCountry"
UniqueName="ShipCountry">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
This grid will load Orders table. How to replace CustomerID with CompanyName which is come from Customers table during run time?
View 2 Replies
Mar 3, 2010
i an sending the url with some inofmation say some thing like this:
"http://localhost:4622/Emp_ResumeResult.aspx?UId=109" now if any one types 110 in place of 109 the infomration of 110 is being displayed so how can i hide this information and how can in encript and decript this issue any url or code.
View 2 Replies
Dec 22, 2010
i am assigned to web part of some project.My duty is to create web form from xml.These xml comes from window part and tells which controls are include in my web form and their properties.My xml Format is like below.
<Object type="System.Windows.Forms.Form">
<Property name="Name">Form1</Property>
<Property name="Text">Option</Property>
[code]...
View 1 Replies
Oct 13, 2010
I need a brief description and concept that what is event mapping in Asp.Net?
If you have any useful link tell me. Write here if you know about this
View 3 Replies
Nov 9, 2010
Can anybody tell me the description about
"#region PageLoad"
which i absorbed in a code given to me....
View 3 Replies
Mar 14, 2010
I am migrating an ASP.NET Web Service toward WCF. The old Web Service endpoint had a nice extensive description page generated from the comment of the underlying class exposed as a service endpoint. In particular, all available web methods were listed.
Is there a way to emulate somehow this behavior with WCF? At least, how can I customize the HTML content of the WCF endpoint?
View 1 Replies
Mar 30, 2011
What is the best method to cache the following? I am creating an intranet web application template that will display the message, e.g., Good Morning, Justin Satyr! near the top of my master page header. Obviously, I will have to determine whether to show Morning, Afternoon or Evening. For clarity, my code is below:
string partOfDay;
var hours = DateTime.Now.Hour;
if (hours > 16)
{
partOfDay = "evening";
}
else if (hours > 11)
{
partOfDay = "afternoon";
}
else
{
partOfDay = "morning";
}
I do not want to re-determine this on each page load because that seems moderately redundant and because I have to poll a SQL server to retrieve the user's full name. What is the best way to cache this nformation? If I cache it for the length of the session, then if the user begins using the application at 11:00 AM and finishes at 3:00 PM, it will still say Good Morning. Is the best thing to do simply re-determine the M/A/E word each page load and cache the person's full name for the session? Or is there a better way?
View 3 Replies
Jul 30, 2010
I am facing the error: Connection refused, When i am browsing any web page on my local machine.I even tried to browse the web pages in my default web site, but facing the same error.My machine is having visual studio. net 2008 and 2005. the data base I am using is Sql server 2005.The OS is windows xp sp 3
View 1 Replies
Sep 8, 2010
i have a dropdownlist and i get the value from database and it's working good.. now i want to add description in the same drop down list..
View 5 Replies
Jan 26, 2011
I have created the folowing stored procedure and it is working fine... I have used OVER clause in the query written in the WITH block. Can some body provide description about working of OVER clause and why I need to use it with the ROW_NUMBER() function.
CREATE PROCEDURE SelectOrder
@PageIndex INT,
@PageSize INT
AS
BEGIN
WITH Order AS
(
SELECT ROW_NUMBER() OVER (ORDER BY OrderId DESC)
AS Row, *
FROM Orders
)
SELECT *
FROM Order
WHERE Row between (@PageIndex - 1) * @PageSize + 1 and @PageIndex*@PageSize
END
View 2 Replies
Mar 4, 2010
Not so much a "How to" of how to use the framework, but a good description of how the framework itself is put together?
web site? book? or just the source code? :-)
View 3 Replies
Aug 22, 2010
In ASP.NET you can set the Response.StatusCode to for example 404. Should the status line / description always be set? (to in this case "404 Page Not Found")
How do you get the description if you only have the code (404)? Is this somewhere in the framework or do you manually have to hardcode the descriptions?
View 3 Replies
Jul 10, 2010
I created one web user control with property named "ReadonlyField" with boolean datatype. I am able to use in my web pages and now i wanted to add a description to that property so that i dont need to explain each time to my team member what is that property's intention.
I got following snippet in c# but didnt find any equivalent in vb.net and also not sure whether it will work or not.
[Description("My Description")]
public int MyIntProperty
{
get {..}
set {..}
}
View 1 Replies
