I have a series of SQL database tables but would like to be able to have a table entry that can support a list of primary key's for another table - how I can do this?
View 1 RepliesI am trying to achieve a list view with this structure.I have many categories with many products
<table>
<tr>
<td colspan="3"><h2>Cat1</h2></td>[code]...
As you see the <td> for products must always be no more than 3 columns. but if there are 8 products then there will be 3 rows (2 full rows and one row with only 2 products) So far I have this:
<asp:ListView ID="lvProducts" runat="server">
<LayoutTemplate>
<table cellpadding="0" cellspacing="0" border="0" width="800"> [code]...
it doesn't work .
I have a database that a website uses. It is working fine but I went into enterprise manager and I can't see it in the list of databases. When I try to attach the mdf file I get this error.TITLE: Microsoft SQL Server Management Studio
View 3 RepliesI have inherited a piece of code that is a bit of a pig. It uses a cursor to loop through a list of stores and count customers. I would like to change this to use a CTE, but am not sure how to configure it.The basic functionality of the SP is:Declare variablesSet up start and end datesDeclare CursorGet a list of stores to checkOpen the CursorWhile... Loops through the stores Insert a new record into the Destination Table Count up the new customers for this store Count up the returning customers to the store Update the new record with the totalsLoopThe code:
[Code]....
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="NameSource"
DataTextField="Choice" DataValueField="Appliers" AutoPostBack="True">
</asp:DropDownList>
I want to insert into database with the following code. I want the Appliers instead of Choice to be inserted. Now this code insert the Choice field only
how can I insert a list (of int) to table?
View 1 Repliesi have a small app. the database has two tables. Category(CategoryId, Category), Quote(Id, CategoryId, Quote) these two tables are related via FK (CategoryId). In my page i have a simple drop down list, button and lable. user selects a value from drop down list like 'politics', 'comedy', 'famous' etc and then they hit the generate quote which should fetch a quote from the quotes table by passing a value like 'politics'.
however, i need to pass an int value (ID) from my drop down since that is the value which will fetch corresponding quote using my SP but (1) how do i pass a drop down value's ID and (2) is the SP below correctly done?
SP code:
ALTER PROCEDURE [dbo].[GetQuote] (@CategoryId VARCHAR(2))
I want to know what the easiest way is to copy one database structure to another blank database. I want tables, stored procedures and functions copied over but none of the data within the tables. I can export it...but then all the data also gets carried over, which I don't know. What would be the best way to carry this out?
View 2 RepliesI have a table named Transactions in which there are Four Coulmns
ID, TransactionsID, LablelName , Data
In Current scenario all the Data is containing in the above table for example
ID, TransactionsID, LablelName , Data
1, 1, CustomerID, 1
2, 1, CustomerName, John Smith
and so on ...
Columns are only four and data is increasing in Row Format.
Clear me advantages and disadvantages
is this datastructure entry or logic is correct or what are the drawbacks of using this technique?
In the user form, the user has a chekboxList, and he can select more than one item.
how can I store those selected items in database, and how then I can retrieve them.
"
Is it true to make a separate column for each item, and then if selected, then that cloumn will have "1" and "0" for non selected.
"
Only that idea occurred to my mind, and I think that I can find better it.
I have one table in database in which millions or records exest already. I can't change the structure of table. And i have to create 4 store procedure each of them will fetch 100 records from this table. And they will keep going on. But condition is that they should not fetch same row. how can all store procedure fetch uniqe data from table.
View 4 RepliesI build a webpage to edit the data entry, all the textbox wroks fine. However when I update the value originally took in using dropdown list , I get error and couldn't get correct update.
View 2 Repliesi have a table with parent-child relationship wherein each child in turn can have multiple associated children. i want to display data in an hierarchical way with collapse and expand features.i dont want to use 'listview inside a listview inside a listview' approach. and yes i have googled it but cudnot find anything useful for my scenario. has someone successfully tried implementing this ?
View 4 RepliesLooping Through Checkbox List and adding selected items to MS SQL DatabaseI don't want to store it using comma deliminator.I will need to do a search on analyze which users have what music in common.The image above is from a tbl_lookup_music table I created. MusicID, MusicNow how should I build the logicIF we have a user that has a tbl_profile table. And listens to many different types of music. How should We store the data.------------------------------------------------------------------------------------------CREATE TABLE [dbo].[tbl_lookup_music]( [MusicID] [int] IDENTITY(1,1) NOT NULL, [Music] [nvarchar](64) NOT NULL, ---- Type of music. CONSTRAINT [PK_tbl_lookup_music] PRIMARY KEY CLUSTERED ( [MusicID] ASC )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY----------------------------------------------------------------------------------------------CREATE TABLE [dbo].[tbl_Profile_Music]( [ProfileMusicID] [int] IDENTITY(1,1) NOT NULL, [ProfileID] [int] NOT NULL, [MusicID] [int] NOT NULL,PRIMARY KEY CLUSTERED ( [ProfileMusicID] ASC)WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOHow should I setup this table.
View 4 RepliesI want to pass the Array ( object[]) or Structure data type value to the store procedure through
ibatis .net. I can do same by commandtext using SQLDBType.Structure. I am using Table value function in sql server 2008 and .Net 2010.
[URL]
i added a collection of data into a list box. i have another group of data with a group name.i want to add this group in to that same list box as a tree structure.
the sample list box is shown below.
item1
item2
item3
-group name
group item1
gruop item 2
gruop item 3
item 4
item 5
is there any way to do this. when clicking on the group name it must be expanded within the list box and i want to manage all these elements with an index.
i want to copy the structure (with the documents) from our vss server to an webserver. Therefore i want to create an application which is on this webserver. i want to use asp.net.
i don't know what exactly i need therefore :> I have to build somekind of connection? then go throw the structure and copy it somehow :> ?
important: i want to copy the documents with the right creation date ( it changes when i just copy the doc.)
are there APIs for asp.net <-> vss?
I want to create web application. I use SqlServer 2008 and asp.net (framework 3.5 sp1).
In my task, user can create database arbitrary structure. and i must write system that generate web site by template. is it possible?
i have one database named as sampleDB its having more than 100 tables. this database running on production. here we have one requirement need to add companyid feild all the tables in our sampleDb. is it possible to write query to alter all the table.
View 3 RepliesI am saving relative path of files in my DB as string. I want to create a treeview from this input. There can be multiple folders for a file path.
View 1 RepliesI have an SQL 2008 DB and I need to transfer the structure and the data to an off site, off network database. I need to somehow create a physical file that represents the structure and data within the db that can be loaded in another instance of SQL Server 2008.
View 1 RepliesI´m about to program a common application/website scenario. It contains pages which are presented to users, and some business logic behind, with a database connection class.
My questions are:
Q1: Should the database class be singleton? If so, why? Because does it even matter when every single user is in their own process on the server, and therefore each user has their "own" singleton database instance?
Q2: How would you normally direct users around the site? Would the Default.aspx page create instances of the required classes? And when the user is directed to a new page, how would you normally refer to these instances?
Q3: What kind of general information do you save in the Session variable? Is it a big no-no to save class instances?
In my form there are about 6 parameters and two of them have multiple values, upto 6. I'm imposed by the restrictions that I can't change the table structure. The table have 8 fields one for ID as primary key, one for foreign key and other to store data. The two fields which have multiple values are color and size. A size may have different colors and vice versa.
The programmer which have developed the site earlier used a stored procedure to store the data in database. And he implemented the above scenario one by one for each color/size. Now I have to put all in one.
How can I do this. As I can't change the table structure at current moment as this will disturb the whole E-commerce site.
In classic ASP I would write some logic to get a nice menu on the site, but now with the Menu-control, it's as easy as it gets.. Maybe to easy. I can't quite figure out how I would do this.. I have a multilevel navigation structure (from a database) that I want to put into the Menu-control, but I don't know which approach is the best/easiest way for me..
I'm all into performance, usability and all that.. The only thing I have really decided is that I want to use the Menu-control, I haven't decided what datasource I should use or how to style the individual links my way The data is coming from a database and is not supposed to be changed very often (maybe once or twice every month).. Thought of making an XML-sitemap, but also of making some sort of SQL-hookup.. I'm leaning towards the XML-sitemap because it wouldn't take long to generate the XML every time the navigation changes and that won't happen very often. The next issue is styling, how to do that? I have the neccesary css ready for the individual links, but I'm still unsure of how to get it to the Menu-control.. The css I have looks like below and in its current form is intended just for the anchors
[Code]....
I have a SQL Datasource populating a Drop Down List with Company Names. The Select Statement the Datasource uses selects Company ID and Company Name.When a company is selected from the list, there is a button on the page to continue processing with the selected company. On the press of the button, I want to set a session variable for the Company ID of the Company selected. This Company ID is obviously held in the Datasouce. Any idea how I get at the Company ID.My code will look like the following:Session.AddsessCompanyID", ????????????)where ?????????? represents the source of the Company ID.
View 5 Replies