SQL Server :: Shredding Multiple Valued Element In Relational Database?
Nov 19, 2010I have the following XML:
<IncidentEntity>
Similar Messages:
C# - Mysql Database Relational Options
Mar 15, 2011I have two tables one called Login and one called User there is a one to one relationship from the user table to the login table:
Login:
=-=-=-=-
LoginID (Primary, Not Null, Auto Inc)
UserID (Primary)
Username (not null)
Password (not null)
[code]...
Architecture :: How To Represent Scenario In A Relational Database
May 26, 2010i'm new with design patterns and i'm not sure if in this situation i can use a composite pattern.
The scenario is a web application for an address book : the address book cointains AddressBoookItem, generalization for Contact and ContactGroup. The last one is the composite object containing a collection of AddressBoookItem.
With these scenario i'm sure that this is a composite pattern, but what is confusing me is that a contact may belong to many contactgroup. Does this request change the situation? Till now i thought that between the Leaf object and the Composite (in the composite pattern) there was a 1-to-m relationship (a composite may contains many leaf but a leaf is contained in only one composite object). Can i still use the composite pattern ? And, the last question,
How could i represent my scenario in a relational database? One table for the entire hierarchy or two table (Contact and ContactGroup) with a m:n relationship between them ?
Documentation For Retrieving Localized Relational Data From Database
Apr 20, 2010I have successfully used resources to translate my UI and I am now moving on to allowing the ability for the admin to translate database content.I'm looking for video tutorials / docs on database structure for localised info and how to retrieve localised data using stored procedures based on the selected culture.
View 3 RepliesWeb Forms :: Wizard Server Control And Relational Data?
Jan 17, 2010I am building a web based insurance application with VS 2008. Using the web wizard to enter newly created policy data and related information.My question is how to handles relational data in the wizard and saving that back to the database.A general idea of the setupEach policy can have multiple policy periodsEach policy period can have multiple sections and multiple policy feesSO The new wizard allows for a single policy entry, then we move to enter the policy periods. Which can be one or many per new policy, then we move to the sections and fees which can be ne or many per policy period.Each part is a step on the wizard. Policy, Period, Sections, Fees.The multiple entries are handled with an aspxgridview.NO problem in entering the data and completing the wizard, except when it comes to actually saving the data.Saving the policy and policy period information is easy because I can get the policyID value and assign that to each policy period.Problem comes in when I save the period child info. Because I can have multiple periods, I can't determine which child data (Sections and Fees) belong to which period so as to get the period ID.What process would you suggest, and how can I achieve this.I have thought of only allowing period entry per new policy. This will certainly solve the problem in a way, but does not conform to business rules.
View 1 RepliesSQL Server :: Using Dynamic SQL Within A Table-valued Function?
Jan 27, 2011I am trying to develop a function that returns a table. I have written: -
[code]...
I am using SQL Server 2008 V2 Express, but my production database is SQL 2005 so solutions will need to be compatible with that.
SQL Server :: How To Use Case Statement In Scalar Valued Function In Sql
Feb 21, 2011i want to get one value from function using case statement,i tried it but not work
CREATE FUNCTION [FATMS].[fnReturnByPeriod]
(
@Period INT
) [code]....
DataSource Controls :: SQL Server Table-valued Function Vs View?
Jul 9, 2010I would like to know which one is better, table-valued function or View, in terms of perfomance.Earlier I have created view which is performing cross join (which takes time) and 2/3 Left outer join and it's taking time. To reduce execution time I have created table-valued function with parameter to reduce cross join execution time and it returns the same result as view.Just give me an idea about table-valued function and View, in terms of perfomance. Which one is better?
View 1 RepliesSQL Server :: To Pass A Table Type Variable To A Table-Valued UDF In SQL Server 2005?
Nov 25, 2010I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
Multiple Paths In Location Element Of Web.config?
Dec 20, 2010How to specify multiple paths in one location element in web.config:, a
<location path="Images">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>
We would like to add styles and images to location, e.g. location path="images, styles". Is it possible to put multiple paths in location element (and how)?
SQL Server :: Query To Select Data From Multiple Tables And A Different Database?
Dec 1, 2010Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.
My current statement is as follows (there are alot more fields but I have shortened it ):
SELECT server.dbo.SRFILE.SR_GROUP, server.dbo.SRFILE.SROWNERSHIP, server.dbo.SRFILE.SRCONMAE, BSFLBWF_1.Incidentx,
BSFLBWF_1.Severityx FROM server.dbo.SRFILE INNER JOIN
BSFLBWF AS BSFLBWF_1 ON BSFLBWF_1.Incidentx = server.dbo.SRFILE.SRONUMBER
WHERE (BSFLBWF_1.Closex IS NULL).........
DataSource Controls :: Relational Field Not Updating On Update?
Mar 1, 2010I have detailsview with a SQLDataSource to 1 table (City) and am referencing another table (Unit) for one if it's fields.
[code]....
I changed the Unit Code (City Table) field into a template field and am using a dropdownlist item to reference the Unit Name from the (Unit Table) with the CityTable.Unit Code = UnitTable.Unit Code. However when I go into the update and change the dropdownlist item to another Unit Name it is keeping the original Unit Code value or it might even be selecting the first value from the dropdownlist item.
Inserting Records From Multiple Computers In The Same Database At The Same Time In SQL Server 2005?
Nov 12, 2010I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesSQL Find The Element ID And Update Database - Get The ID Of The Div
Oct 12, 2010Basically I've got an update query that runs when you click a submit button. I have an asp:Repeater in my page with a layer inside like this
<asp:Repeater id="dgBookings" runat="server" OnItemDataBound="ItemDB">
<itemtemplate>
<div class="bookingscontent">
<div class="bookingdetails" id="<%# DataBinder.Eval(Container.DataItem, "booking_ref") %>">
<p class="infotext"><%# DataBinder.Eval(Container.DataItem, "adults") %> <asp:LinkButton OnClick="EditDetails" Text="Edit..." runat="server"></asp:LinkButton></p>
<p class="infotext"><asp:LinkButton OnClick="SubmitDetails" Text="Submit..." runat="server"></asp:LinkButton></p>
</div>
</div>
</itemtemplate>
<asp:Repeater>
And it outputs HTML like this
<div class="bookingscontent">
<div class="bookingdetails" id="AL05720">
<p class="infotext">2</p>
<p class="infotext"> <a href="javascript:__doPostBack('dgBookings$ctl00$ctl08','')">Submit...</a></span> <a class="EditAdults" href="#" onclick="return false">Edit...</a></p>
</div>
</div>
<div class="bookingscontent">
<div class="bookingdetails" id="BD45670">
<p class="infotext">4</p>
<p class="infotext"> <a href="javascript:__doPostBack('dgBookings$ctl00$ctl08','')">Submit...</a></span> <a class="EditAdults" href="#" onclick="return false">Edit...</a></p>
</div>
</div>
Basically I need to get the ID of the div where the person has clicked submit and I can't figure out how. I want to put that ID into a string or a session so it can be used in SubmitDetails Sub
Web Forms :: Read XML By Using Element Name And Save To Table In SQL Database
Feb 25, 2016How to read xml by using element name in xml so that we could store resultant data into sql table in database using C#..??
View 1 RepliesCan ObjectDataSource Use Table-valued Parameters
Oct 15, 2010If an ASP.NET web page uses an ObjectDataSource, can you configure it to use a stored procedure that uses table-value parameters?
User-defined type:
CREATE TYPE [dbo].[integer_list_tbltype] AS TABLE
(
[n] [int] NOT NULL,
PRIMARY KEY CLUSTERED
)
Stored procedure:
CREATE PROCEDURE [dbo].[GeneralReport]
@intList integer_list_tbltype READONLY
AS
BEGIN
SELECT * FROM ...
END
ASP.NET
<asp:ObjectDataSource ID="GeneralDataSource" runat="server"
SelectMethod="GetDataByRange"
TypeName="MyProject.GeneralDataSetTableAdapters.GeneralViewTableAdapter"
>
<SelectParameters>
<asp:Parameter Name="intList" />
</SelectParameters>
</asp:ObjectDataSource>
I've tried hooking into the ObjectDataSource's Selecting event like this:
[code]....
be set for UDT parameters." being thrown
Web Forms :: Getting Selected Valued In CheckBoxList?
Mar 7, 2014I Bind CheckBox List With Employee through Database
I Want To get Selected Item valued hence
i write a code behind button click
foreach (ListItem item in cblEmployee.Items)
{
if (item.Selected)
{
string id = item.Value;
}
}
but instead of check we get Selected Property False and execution does not go in if Condition
What Is Difference Between Web.config Assemblies Element And Project File Reference Element
Sep 29, 2010I'm looking at an asp.net application, i notice that there are assemblies defined into two places. In web.config there is configuration/system.web/compilation/assemblies/add elements. In the project file there are references setup under the Project/ItemGroup/Reference elements.
I was wondering, what is the difference between assemblies/references added in either location?
Data Controls :: How To Check If XML Element Name Is Equal To Database Field Name
Nov 25, 2013I have to check if XML Element name is equal to db table column name in c#.net
Iam using data access layer for sql commands.
Ex,
if XML Element name is Userid the same name must be exist in the db table column name(Uerid)
if the column does not exist in the table the value should not be stored.
Web Forms :: Retrieve Values From The Form Object Using The Id Element Instead Of The Name Element?
Feb 19, 2010Is there a way to retrieve values from the form object using the id element instead of the name element?
View 3 RepliesHow To Give Border Line To Single Td Element In The Table Tr Element
Jan 7, 2011I have a table in ASP.Net like this.
[code]....
I want to give border line to first td element which contains the colspan and rowspan. Not to the entire row.
AJAX :: Element 'ToolkitScriptManager' Is Not A Known Element - For Network Drive Websites
Feb 2, 2011I have noticed that when I create a website in a network drive and use the Ajax toolkit I get :
Element 'ToolkitScriptManager' is not a known element
I also noticed that after adding the ToolkitScriptManager it doesn't add the ID in the source code, it looks like this:
<asp:ToolkitScriptManager runat="server"></asp:ToolkisScriptManager>
Is missing the ID="ToolkitScriptManager1" part.
This doesn't happen when I create the site in my local drive. Is there a workaround to this. Even if I add the missing parts, I keep getting the same error.
DataSource Controls :: Using Table-valued Parameters?
May 19, 2010This is my first attempt in using table valued parameters in my stored procedures. Please find the scripts down below. The idea is very simple. I'm trying to insert a new product into Products table and if the product has attributes, I'll insert them into ProductAttributes table which is where I use table-values parameters.
I was able to test the stored procedure manually. It's working fine. So the error must be in the C# code but there's not much to it.
Here's the DAL code in C# that calls the stored procedure:
[Code]....
Just in case you need it, here's what my Product object looks like:
[Code]....
And the ProductAttribute object is even simpler:
[Code]....
Here's the SQL scripts to create the tables, stored procedure and user defined table type:
[Code]....
ADO.NET :: SQL Table Valued Parameter And Linq In Framework 4.0?
Jan 21, 2011know if the followin is supported in .net framework 4.0?I have a sql stored procedure with one of its parameter as Hierarchy data type( i suppose its a table valued parameter).. trying to drag this stored procedure onto my linq design studio is not being allowed?
View 1 RepliesJQuery :: Find Dom Element Starting From Found Element In Same TR
Dec 13, 2010I would like to select an element that is in the same TR as another element I found with a selector. The selector itself: $("input[name='sMessageValue']","#messageTable") Now I have this element and got its value I would like to find a checkbox located in the same TR, i tried this as starting point : $(this).(':parent').val(). But seems not the right thing to do.
View 9 Replies