Databases :: Get A List Of Categories From One Table To Show In Another Table?
Jan 21, 2010
I am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
(Using SQL Server 2008 and ASP.NET MVC2)I have a simple business table and a category table. I have a 3rd table to map business to category, a many-to-many relationship. the Map table contains a BusinessID and CategoryID. I'm lost as to how I can load the categories into my Business View Model using the entities model.Without incorporating categories, my code looks like this:
[Code]....
with Business View Model defined as:
[Code]....
but if i want to populate the Categories with the mapped categories, how would one do that?
i posted a question yesterday but it got taken off by moderator mbanavige with the reason indicating it was a duplicate post. i know for sure it was the first time i was asking that question. i will have to ask it again NOW because it was deleted. hope THIS one does not duplicate the one i made yesterday. so here goes:
I need to query a products table based on categories selected by the user. The selection of the categories is a checkbox list, and user can select any number of categories (including none at all). I only know how to compare one parameter at a time. Like this:
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
I'm working on locking down some MySQL user accounts. At the moment I typically grant my user accounts execute privileges over the required stored procedures within a schema.Now I'm looking at the proc table in the mysql schema. The common wisdom that's quoted many times on various websites says "Stored procedures require the presence of the proc table in the mysql schema".By granting select access over the proc table stored procedures will work. But if I removed the above select privilege and grant the user execute privilege over the entire mysql schema the procedure will also work.
Does anyone have any ideas about the security issues by choosing one of the above over another?I would prefer to lock the proc table down all together so the user cannot see it cannot select from it.
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?
I am using PL/SQL Developer. I have a Table "C_PARTY_HXRF". Now I want see the Column Names and the corresponding Data types of this Table. Which Command should I Use?
I have this table called "students", with the columns :Name, ID, Faculty.
I want to display the info in my .aspx page in such fashion that the columns will appear on the left, the ID on the top, and the data populated properly.
So, basially, should look something like this:
ID 123 234 345 456 567 234 135 135 Name John Erick... Faculty CS BIo ...
I'm not so familiar with stored procedures but I'm interesting in moving most of my web selects to stored procedures. I'm working with .net based website and all my data access is something like this:
[Code]....
But now I want to improve some process and make tunings. For that I want to use stored procedures, so instead of the "SELECT ...." sentence I'll put stored procedure name. My problem is how to return a table from one.
now the system always prompts a error message about insert duplicate key into Sybase database.how can i prompt a message box instead of this error message when i insert duplicate key into sybase database table. any code can check what type of error then prompt different alert message.
how can i create a backup table for my MySql base table.my base table name is FAB when ever user store the data into FAB table same records should be stored into back-up table automatically.how can i acheive this.i am really thank full to you if any one provide me solution.
I have applied audit trail to my webform/table its working fine.I am able to maintain the History(action,action_date) of the MySql database table from ASP.net but I want to save user name i.e action_by too so i will have history of who changed the data and when, how can i acheive to save username in history table.i have login webform in my application. History MySql Table.
My site extracts data from a MS SQL db and then connects to a mySql db which it writes the data to. My site is working properly when connecting to a db in cPanel at a remote website.
However, I have a mysql db also hosted on my site, and I'm connecting to it ok, but the loop is failing. There are 2 tables, one stores the category, and the other stores link data.
For each category
write to the category table for each link in this category write to the link table next next
The tables are being created, and the very first category is written to the table, but then nothing gets written to the link table.
How can I make this generate an error message? My webhost doesn't know what to do about it and they just want to see an error message.
I tried this once already, and neither of my lines worked:
We already have a complete Oracle database system where we have there as well a table (Oracle table name : "LTR_USERS") for usernames, passwords, emails, etc...
Now, we want to create an ASP.NET 4.0 website and we want to use the built in Login control (no need for the register / create user controls). However, we want this Login control to use that Oracle table ("LTR_USERS") to look for the username and password. How to do that?
i want to create a table for storing email like hotmail
I have 2 idea:
1-create table for for all user(user 1 has its table and user 2 also has its table)
2-create one table for all user and stor the email text in the field that used for email text and seperate the text by character like(, or - or ........)
I'd like to have to two tables Countries and states and make it so that any MySql user can access them for the purpose of building databiund drop down lists. What permissions do I need to assign the tables or what's the best way to do this?
On one of our tables, a default clustered index is defined on the primary key by sql server 2005. The table also contains forign key columns and has got over 2 million rows. There are very frequent INSERT, UPDATE and DELETE functions on this table. Recently some of the SELECT queries which primary operate on the forign keys have become very slow (resulting in application timeout). To fix the problem, I defined an index on one of the primary keys which gave me very quick results. I don't know much about indexes.
1. Since I defined a new index (on the forign key) in addition to the existing default index, what kind of index (clustered or non-clustered) have I defined?
2. What performance impact does it have on the rest of the system? Is it going to break something else?
3. I read about fill factor. What is this and how does it effect the system?
4. Is the new index physically going to make any changes?
5. In case I delete this index later on, will the database return to the existing state or it will be a different state from now?
