SQL Server :: 2008 Views And Table Joins - Retrieve Data At Once When The Page Loads
Mar 21, 2011
I have a web page with a GridView and a table outside the gridview to display more information of the record when it is selected (like record details). I'm using data of five tables for this particularly window. I use one table of the five to bind the gridview the other tables are for the details, but I use like 1 or 2 fields of those tables. I'm binding the page with web services. I need some advice on which is the better way for doing this to make a faster web page.
In sql server I made a view with the five tables (all the tables relations are working perfectly). In the web service I call the view; and in the web page I call the web service to bind the page. Everything is working. All I want to do is retrieve from the server all the necessary data only once when the page loads and bind the five tables data (like 18 fields total) in the gridview which I only show 12 fields the other 6 fields are hidden, those 6 are for the details which I get with jQuery (that's another topic). Bind everything only once and manage the data on client side. Everything is working perfectly. Here is my doubt.
How are the maximum table joins I can make? To retrieve the data via web and not get a server time out error. Which is a better way to make a faster page? Make 2 views one for the gridview and one for the details and put each view in a web service; or make one view with all the table joins and one web service. Right now all is working but I have to make other pages that use different tables and joins and I don't know if the server gets me the time out error when the page is fully working.
View 1 Replies
Similar Messages:
Mar 25, 2011
I have a web service with a dataset and I need to fill a gridview in my web page with data from multiple tables (like 4). How can I retrieve data from my 4 tables and construct a datatable with a table adapter in the dataset? I need to create this in the web service to bind the gridview in my page. In SQL I create a view with the joins of the 4 tables and added the view to the dataset. It works fine, but for other windows in my web page I need to use like 8 trough 10 tables (just to retrieve one field of each one) and I don't know if making that huge joins is the more efficient way to retrieve data from the server. There is another way to make joins? (Make separate queries for each table and create one table in memory) How?
View 2 Replies
Jan 29, 2011
Inner Join:- Returns a row when there is matching table in both tables. we can use comparison operator like =,<,>,<>
I created two tables
TableA
ID OID Type
1 1 A
2 6 B
3 7 C
4 10 D
TableB
ID Value
1 10
2 30
3 40
5 60
6 70
Basic Inner Join select Type From TableB as a inner join TableA as b on a.ID=b.OID Result Type
A
B
If i want only the type which has not match in tableB then i can use not in subquery i get the result if i m using select Type From TableB as a inner join TableA as b on a.ID<>b.OID then i get
Type
A
A
A
A
B
B
B
B
C
C
C
C
C
D
D
D
D
D
18 rows affetected i m suprise
View 3 Replies
Oct 30, 2012
how to give a multiple inner joins to the single table
View 1 Replies
Jul 21, 2010
[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 Replies
Dec 2, 2010
how to Export Sql Table into XML File into following Format. Eg
<App_Sports>
<Sport>
<SportcodeID>1</SportcodeID>
<Sporttitle>Action Sports</Sporttitle>
</Sport>
<Sport>
<SportcodeID>2</SportcodeID>
<Sporttitle>Adventure Racing</Sporttitle>
</Sport>
<Sport>
<SportcodeID>3</SportcodeID>
<Sporttitle>Aikido</Sporttitle>
</Sport>
<Sport>
<SportcodeID>4</SportcodeID>
<Sporttitle>American Football</Sporttitle>
</Sport>
</App_Sports>
View 4 Replies
Feb 17, 2011
i have a store procedure that load data in a table of SQL SERVER 2008 from an excel file.the issue is, that the excel file have a column of DATE type, and i want that the system interprets the format in it, no matter what comes in it.dd/MM/yyyy mm/dd/yyyyi have an argue about this with my parnerts, cause i think is imposible, if you don't have a format before the process runs.
View 3 Replies
Jan 24, 2011
I have made a mvc 2 asp.net application on a development server 2008 R2. The site works fine with IIS 7 and windows 2008 R2 on the development server... When I deploy the app to a remote accept. server, routing seems to be broken and only the master page with no contentplaceholders are rendered. I only see a empty Master page. It looks like the accountcontroller is not fired and no View is returned.
View 10 Replies
Apr 7, 2010
We have a site that upon every page load, it tries to contact a sql server on the local machine. It does not contact localhost, but the actual IP of the local machine. It fails, then contacts the correct DB server for membership information. In dev, apparently the server was contacting the local sqlexpress server, then contacting the correct DB as well. Only when we stopped the localmachine dev SQLExpress could we recreate the issue. We had removed entries in machine.config, and web.config to .sqlexpress, but the problem still persists.
View 1 Replies
Nov 4, 2010
How to inner join 2 table with primary key by no duplicate data in sqlserver 2008 ?
View 5 Replies
Feb 1, 2010
i have an aspx page which has a fileuploader and a button
initially i have to browse the file and after browsing the file i have to check the extension if the extension is xsl or xslx then only i have to enable the submit button
once the submit button is enabled i have to insert this data into the table
and i have to display the number of succesfully inserted rows and no of unsuccessfull insertions .
success and failure is dependent on the mismatch of the datatype between the excel sheet and the database column
i am coding in c# but am unable to upload.
View 2 Replies
Jun 13, 2010
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
View 2 Replies
Oct 7, 2010
i want to retrieve latest 10 values from my table,i use sql server 2000.. how can i query my database?
View 4 Replies
Feb 8, 2011
I have two sections of users data on my site, customers and employees, each one has a UserID that is FK to the UserID from aspnet_Users table.
I have a table that stores User messages
Looks Like This:
[URL]
It Has a FromUserID and ToUserID
Because Employees are Identified through EmployeeID and Customers are identified through CustomerID, I needed to use UserID's so Employees can leave messages for employees and Customers and Customers can leave messages to employees and other Customers 1-2 and 2-1
My Quandry is this, How Do I retrieve the information if the UserID might be a Customer or Might be an Employee, when the UserID could be from one of two tables
ie
How Would I Write?
SELECT wms.FromUserID, ed.FirstName, ed.LastName FROM ed INNER JOIN wms ON wms.FromUserID = ed.UserID
OR SELECT wms.FromUserID, cd.FirstName, cd.LastName FROM cd INNER JOIN wms ON wms.FromUserID = cd.UserID
How Do I Check to See? Do I Use IF EXISTS?
View 5 Replies
Jul 29, 2010
Is it possible to have ON and WHERE , both keyword using Joins in a single query
View 6 Replies
Sep 14, 2010
I have a select statement. I need to get a field value from the first statement. GOAL: Below is what I am trying to accomplish - the code below is not correct - Please modify the statement with the correct SQL Syntax. I want to query a table and based on the results I want to set the "If THE Else"statement to query then table with diffent inner joins.
SELECT * FROM CONTENTITEM CI
INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID
IF CI.FORMTYPE = 200 OR 300
SELECT * FROM CONTENTITEM CI
INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID
INNER JOIN CONTENTFORMFIELD CF ON CF.ITEMID = CI.ITEMID
WHERE CI.ITEMID = @ITEMID
ELSE
SELECT * FROM CONTENTITEM CI
INNER JOIN CONTENTCATEGORY CC ON CI.CATEGORYID = CC.CATEGORYID
WHERE CI.ITEMID = @ITEMID
View 10 Replies
Nov 15, 2010
One of my peer wrote a query based on multiple tables using joins. One of the table is in a different database The query was taking much time
1. Create an SP
2. Create a temp table and copy all records from the external db
3. Avoid using Left Join as much as possible and use Inner Join
4. Create and use indexes
5. Remove tables/columns that are not necessary
In this scenario, I would like to suggest to use Covering Index, but how can it be created for multiple tables and a temp table?
View 3 Replies
Aug 5, 2010
My page includes a button and a GridView bound to a LINQ data object which is bound to a table. when the page loads the gridview gets populated with the data and all work well. The button has an empty method, when I click the button I get en error message "Intenet explorer cannot display the web page" I put a break point at the begining of the method listed below but I get the error message before it gets there. If I remove the gridview than the button works well.
[Code]....
View 2 Replies
Nov 3, 2010
I've got a dropdownlist and a Gridview Based on the choice from the dropdownlist (which has a '--Select--' as the first item), the gridview is populated. If nothing is in the database when queried, I have a message for the emptydatatext property of the gridview. However, it comes up when the page first loads, since it's based on the ddl. How can I make it so that, when the page loads for the first time, the emptydatatext property is ignored?
View 3 Replies
Jan 16, 2011
I have two grids "grid1" and "grid2" and two updatePanels "up1" and "up2". Both the panels have UpdateMode = "Conditional" grid1 is nested in up1 and grid2 is nested in up2 [Code]....
In Code behind : [Code]....
I am using UpdatePanels, but still data will be fetched whenever page loads. How can I handle so the dat will be fetched on ony for the grid which is being updated
View 2 Replies
Oct 14, 2010
I do long and slow query to get data to my GridView and I got lot of data, but when I'm changing page it loads as slow as at the start, it loads full data again and again, how to load data once and use paging without data loading?
View 1 Replies
Apr 18, 2010
How to populate a DropDownList (using C#) inside a DataList while page loads.....yes we can do it by using DatasourceID propeerty in aspx page itself(as I've done here..), but how do I do using C# in code behind only?
<FooterTemplate>
<table>
<tr> [code]...
View 1 Replies
Feb 8, 2011
I store string using , (comma) now i want to retrieve data back from the comapre string in another with the price.
I store string like this a,b,c,d.
Now i want to retrive it like
name price
a 10
b 20
c 30
totla 60
using ms access databse and .net C#
View 3 Replies
Jul 29, 2010
I am using ASPNET2008 with VB Scripting and not C# Scripting I am encountering new problem.
On the WebFrm1, I just don't know how to write the coding to retrieve the CUSTOMERID data in order to retrieve the details from SQL SERVER table to fill the textbox controls.Here is the decription of the GRIDVIEW column
In the GRIDVIEW1 on the left edge one of the column is SELECT button which let the userclick on it to select the specific CUSTOMERID on the column next to it on the right.
Here are the coding from SOURCE
<asp:ButtonField ButtonType="Button" Text="Select" CommandName="SelectClick" DataTextField="CustomerID" >
</asp:ButtonField>
View 10 Replies
Mar 25, 2011
i got a Food table and a Notification table. each Food has an expiry date. I wish to put all foods which are going to expired into the notification table. since user can create new food anytime, how can i update the Notifcation table once got any new food (but with near expiry date) added? and how to make sure the Notification table retrieve the nearly-expired food everytime (mayb update once everyday??)
View 1 Replies
