SQL Server :: Need To Make General Table
Jan 28, 2011
I'm making a visitor management application and I made three tables namely tblStudent,tblEmployee and tblVolunteer in SQL.I made a table according to the categories of a visitor.Do I still need to make a tblVisitor that would be the "general" table for the three tables made?I'm really confused whether it's needed or not to make a table to join similar attributes of student,employee and volunteer.
View 2 Replies
Similar Messages:
Oct 29, 2010
Order Table
Order No Date Product Qty Customer
A101 10-Oct-2010 Mac Book 10 John
A102 10-Oct-2010 I-Phone 25 Smith
A103 10-Oct-2010 I-Pad 40 Kallis
Here Order No is primary key
Order Detail Table
Order No Date Product Qty Customer Batch No
A101 10-Oct-2010 Mac Book 03 John B01
A102 10-Oct-2010 I-Phone 05 Smith B02
A103 10-Oct-2010 I-Pad 10 Kallis B03
A101 10-Oct-2010 Mac Book 02 John B04
A102 10-Oct-2010 I-Phone 07 Smith B05
A103 10-Oct-2010 I-Pad 15 Kallis B06
Here Batch No is primary key
The above table is just a sample table.
I have more than 1000 Order in my table. And for each Order there are at least 12 Order Detail is available in my Order Detail Table. It uses to take long time on loading the report for the first time. So, I thought to select Top 20 records from Order table. I have used the below query in crystal report command
Select Top 20 O.OrderNo, O.Product, O.Date, O.Qty,OD.Unit,OD.Rate from Order O
inner join Order Detail OD on O.OrderNo = OD.OrderNo
1. After execution of above query, I would like to know whether all the records from Order Detail Table will be checked during execution (OR) only matching Top 20 records of Order Table will be checked in Order Detail Table and executed?
2. How to use stored procedure in Crystal Report command?
3. What are the steps I need to take, to load Crystal report fast during first time page load?
View 1 Replies
Dec 17, 2010
i have a table in my database.i want to assign a unique id (primary) automatically when each data is submitted.how to set this one is sql server 2008? i tried but couldnt do it.
View 10 Replies
Mar 10, 2011
I tried nested ListViews but can get the display wanted.In my database I have a Category Table and a Product table.They share the CG_ID value.I want to make a stored procedure that will use two select statements to produce a single table.that can be used as a ListView DataSource.
[code]...
View 18 Replies
Sep 20, 2010
we have a web application that one company prepared for us. this application read connection string from registery key in hkey_local_machine and connect to sql server 2005 database. It worked correctly in windows server 2003. we changed our Server'OS to windows server 2008. but we have a problem to login. after try to login we see this error: Server Error in '/dabir' Application. Login failed for user ''. The user is not associated with a trusted SQL Server connection. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Source Error:
[Code]....
Stack Trace:
[Code]....
View 4 Replies
Nov 25, 2010
I 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)
View 7 Replies
Dec 10, 2010
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.
View 2 Replies
Nov 27, 2010
does windows azure automatically scale up(by providing more instances), or I need to change this?
the extra small instance costs 0.05$/hour. According to Azure SLA I need to use at least 2 instances. This means 2 * $0.05*24*30=$72/month minimum. I can get on premise asp.net hosting for $5/month. Is there any offer I don't know about so I can build from the start on Azure architecture, or should I just switch to azure when I need more scaling and other servies that Azure offers because the difference in price is too high for me.
View 3 Replies
Mar 15, 2011
i'm a new programmer, hope it's ok to ask this kind of general problem.
i don't know what it the general or better/best way to write a report?
it's a report of a financial system. lots of names, momey, amount, price, date, sum total... etc
like, [URL] (this is not mine, i just google "report")
i know i can use gridview/repeater... . use control and write sql command in it.
few days ago i heard some people will finish a report just in a store procudure! it looks better!
it doesn't include sql commands in .cs/.aspx file. i can separate sql command from c# codes! (finally!....)
so. question is, is this the best/better or most general way to write a report?
use store procedure? use sql user defined funcation? ....or ??
View 2 Replies
Dec 21, 2010
I am using master page with content pages. I want to write a genral method to clear textboxes and for dropdownlist set index to 0. Please guide on this.
View 1 Replies
Dec 6, 2010
I'm searching for some extension methods that helps programming in ASP.NET. Some functions to work on controls, validators, AJAX or programing in C# in general.It could be methods library or your own methods.Do you know any source of those methods (other than CodePlex - that is good source of generic extensions) especially for ASP.NET?
View 1 Replies
Feb 17, 2011
I am converting a VB function into c#. I have this in VB: Dim Ret(2)
Whats the best alternative to convert this in c#?
View 4 Replies
Jun 18, 2010
or developing mobile web application based on the targetting mobile devices we can develop that in asp.net using asp.net controls but still so much of application they are using mobile controls in there project. mobile controls are not that much flexible but still why there are using? Is there any specific reason to use mobile controls in the project?
View 2 Replies
Feb 28, 2011
I have several nested table in my asp page. Each row contains textbox or label. I would like to have some spacing between the table's rows but I cannot make it. I try to use cellpadding in each table but it doesn't make any difference. What is the best way of cell spacing in nested tables?
View 2 Replies
May 18, 2010
i have some web site with one page call genPage.aspx for all regular site pages, the title and the content of the page is changing by the pageId on the url (queryString). All the page looks the same (title, content and images and the same structure)im want to add contact form to the page with the pageId=7 only and dont have idea how to do this. (i know in classic asp it was : <if pageId = 7> html code and then <end if> but in asp.net i cant find the way. [Code]....
View 3 Replies
Aug 19, 2010
I have a web app that presents a list of statements pulled from the db to be ranked from "Never" to "Always" using a radioButtonList.
Some of the assessments have up to 100 statements, so I'm thinking that a ListView with paging and a RequiredFieldValidator for the radioButtonList would keep the presentation manageable.
I would like to submit the data after all of the pages are complete but I think that would require customization, or is my approach wrong?
View 4 Replies
Jun 7, 2010
how can i make using javascript a table row visible or invisible when checkbox is checked? also i need table row runat="server" so when postback page it will not loose table row state.
View 9 Replies
Nov 9, 2010
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?
View 1 Replies
Jan 3, 2010
i have to make a three primary key in one table
View 2 Replies
Apr 19, 2010
I have a web service that I developed on my local machine using the Enterprise Library for database access and exception logging. This all works fine on my machine but not on my server. I get the following error and i do not know why. Tracing to LogSource 'General' failed. Processing for other sources will continue. See summary information below for more information. Should this problem persist, stop the service and check the configuration file(s) for possible error(s) in the configuration of the categories and sinks. I do not see any errors in the configuration. I can get it to log to a flat file but not to the event log or an email it is to send. This is on a Windows Server 2008. Is there any special permissions I need to set? I hope this is the correct place to post a message such as this, if not let me know where to post it to.
View 2 Replies
Jan 25, 2011
Is there a more general descripton of the sequence of events for a page loading
[Code]....
View 2 Replies
Nov 26, 2010
any plugin references for drawing flowchart or in general uml drawings with jquery ?
View 3 Replies
May 15, 2010
I am a newbie to ASP.NET (but not to C#)I have a project I am developing that may seem unconventional at this point but it is a project that I hope to eventually expand and provide a new type of service on the internet. Currently the project makes use of an Excel spreadsheet that is generated by another application I wrote. Basically the spreadsheet is an index to a specific type of file that exists on a host computer and the files are directly linked from within the excel document. When the link is clicked it opens the file using the operating system default program which then processes the file (this takes some time).
This is fine and dandy but when I click on another file, the default program immediately stops processing one file and opens the latest submission and thus interrupting the previous job. To prevent this I am now writing a queuing application. Here is where ASP.NET comes in. I do not want the link to open the queuing application with the file to add into the queue as a parameter because that pops one or more nnoying/scary "you are opening an executable" dialogs and because I want to be able to access the queuing service from a remote computer, and possibily in the future over the web. Instead I am trying to use an ASP.NET service application that will accept the name of a file as a parameter, access the external queue class (defined in an external dll of which only one universal instance is allowed), and add the request to the queue. Whether or not the table is an excel table or on a web page, using a form in this instance is tedious, not only for me but for a user. I want the user to be able to simply click on an html link and have the file be queued without anything except maybe a confirmation page pop up saying that the file has been queued and it will take x amount of time before the file is finished processing.
My problem is I cannot for the life of me find a way to do this. I have searched the interenet for over a week now looking for a way to call a "WebMethod" using a link and I am getting the impression that it cannot be done. Even when I use a form and try to have the form pass a string (representing the file name) as its "action" it comes up with an application error saying that I am missing the parameter I am trying to pass. Here are some examples of what I have tried:Here an example method I would try to access:
[Code]....
Here is an example of how I tried to access directly by way of a link (which results in an application error: InvalidOperationException)"
[Code]....
View 3 Replies
Apr 27, 2010
I'm trying to use ADO .NET to select data from this table in excel. I'm not sure at this point if I need to modify the table to make it more easy to select data from it. Here's what the excel table looks like
I guess I don't know where to really start. I'm pretty much trying to grab the numbers in the middle(design pressure) based on Mull length in inches and opening width. so the user will input the height and width of window. then if it's going into concrete or wood.. if it;s wood then in the clip to opening row if he uses (2)A or 3(b) he will have a DEsign pressure of 170 if mull length is 42 and opening width is 70. in the same 70 column if he uses (3)a 0r 3(b) his DP will be also 170 in this case.. So I will have a user interface and ask the user for a width of window and height of window which will be the Mull Length and what substrate(wood or concrete) based on that I want to display if u use this amount of screws A or B u will get this DP.
View 2 Replies
Mar 29, 2011
I'm working on a ASP.Net web page with two tables positioned in the center of the page with one on top of the other. The table on top contains input fields that are dynamically generated by the code-behind, so the number of input fields varies. The table on the bottom contains content that is constant and doesn't change. The layout of the page is fixed and must remain so. My question is, how do I make the bottom table dynamically adjust vertically so that it doesn't overlap with the fields from the top table. The general HTML layout of the page is something like the following:
[code]...
I'm thinking I could wrap the bottom table in a div, but I'm not sure what specific styling will achieve the desired effect. I basically want to maintain the fixed positioning horizontally, but have the vertical alignment adjust to prevent overlap with the top.
UPDATE:
Here is a screen cap that shows the two tables overlapping. The buttons you see are in the bottom table, the fields are supposed to be on the top, all elements are positioned absolutely in the center of the browser screen.
UPDATE 2:
I updated the HTML sample above with the styles that are currently in use.
View 2 Replies