How do I create 1 gridview for data found in 2 or more seperate tables? Is that even possible?
I have a Customers Table and a Business Owners Table... I need to get at the data from both?
I have a task to create grid view for 8 different tables. I am wondering if there is a better way to create those gridviews. The following features has to be in almost all 8 gridviews
1. Add / Edit / Delete / Sort
2. Some of the grid view has to contain a combo box when editing the row
3. A check box has to be in first column of the gridview
4. When editing the grid view, I need to have an edit form pop up
5. Confirm delete dialog box has to show before delete.It is not smart to create 8 grid views ( I am trying to avoid creating the grid manytimes)
i want to bind gridview from different tables and as shown in following format only
Column1
Column2
Column3
Column4
Column5
Column6
Column7
Column8
I have one gridview, a dropdown list where I can search the users table or a group name table, a textbox for inputting the search and a button to search.How could I overwrite the users table that is binded in the gridview when I search through the groupname table? Using C#.
View 2 RepliesI want to know the procedure of binding a gridview. but the condition is that thefre are three columns in this gridview. if I wud bind it from one table then it wud ok for me. but now I need to bind it from three different tables. onw column from one table, another from 2nd.. and so on.
View 5 RepliesI have a problem in getting my gridview to update. The datasource gets its data from 2 related tables using the following select statement:
SELECT StudentSubject.StudentID, Students.[1stName], Students.Surname, Students.Grade, StudentSubject.Subject, StudentSubject.GradeOverall, StudentSubject.ReportYear, StudentSubject.ReportSession, StudentSubject.Criteria1Grade, StudentSubject.Criteria2Grade,
StudentSubject.Criteria3Grade, StudentSubject.Criteria4Grade, StudentSubject.Criteria5Grade, StudentSubject.Criteria6Grade, StudentSubject.Criteria7Grade, StudentSubject.Criteria8Grade, StudentSubject.Criteria9Grade, StudentSubject.Criteria10Grade, StudentSubject.Comment
FROM (Students INNER JOIN StudentSubject ON Students.StudentID = StudentSubject.StudentID)
WHERE (StudentSubject.Subject = ?) AND (StudentSubject.ReportYear = ?) AND (Students.Grade = ?) AND (StudentSubject.ReportSession = ?)
The ? stem from combo box controls which I use to filter the results So far so good!
However, when I try to update the data in just one of the tables, nothing happens, no error, just no update. The update statement I'm using is:
UPDATE StudentSubject SET GradeOverall = ?, Criteria1Grade = ?, Criteria8Grade = ?, Criteria7Grade = ?, Criteria6Grade = ?, Criteria5Grade = ?, Criteria4Grade = ?, Criteria3Grade = ?, Criteria2Grade = ?, Criteria9Grade = ?, Criteria10Grade = ?, Comment =?
WHERE (StudentID = ?) AND (Subject = ?) AND (ReportYear = ?) AND (ReportSession = ?)
I've tried this with a similar setup with just on table and it works fine.
<asp:AccessDataSource ID="DSGrid" runat="server"
DataFile="D:RW docsVisual Studio 2008WebSitesFellbach ReportsApp_DataReports - Copy.mdb"
SelectCommand="SELECT StudentSubject.StudentID, Students.[1stName], Students.Surname, Students.Grade, StudentSubject.Subject, StudentSubject.GradeOverall, StudentSubject.ReportYear, StudentSubject.ReportSession, StudentSubject.Criteria1Grade, StudentSubject.Criteria2Grade,
StudentSubject.Criteria3Grade, StudentSubject.Criteria4Grade, StudentSubject.Criteria5Grade, StudentSubject.Criteria6Grade, StudentSubject.Criteria7Grade, StudentSubject.Criteria8Grade, StudentSubject.Criteria9Grade, StudentSubject.Criteria10Grade, StudentSubject.Comment
FROM (Students INNER JOIN StudentSubject ON Students.StudentID = StudentSubject.StudentID) WHERE (StudentSubject.Subject = ?) AND (StudentSubject.ReportYear = ?) AND (Students.Grade = ?) AND (StudentSubject.ReportSession = ?)"
UpdateCommand="UPDATE StudentSubject SET GradeOverall = ?, Criteria1Grade = ?, Criteria8Grade = ?, Criteria7Grade = ?, Criteria6Grade = ?, Criteria5Grade = ?, Criteria4Grade = ?, Criteria3Grade = ?, Criteria2Grade = ?, Criteria9Grade = ?,
Criteria10Grade = ?, Comment = ? WHERE (StudentID = ?) AND (Subject = ?) AND (ReportYear = ?) AND (ReportSession = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="ComboSubject" DefaultValue="German" Name="Subject" PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="ComboYear" DefaultValue="2010 - 2011" Name="ReportYear" PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="ComboGrade" DefaultValue="1a" Name="Grade" PropertyName="SelectedValue" Type="String"/>
<asp:ControlParameter ControlID="ComboSession" DefaultValue="November" Name="ReportSession" PropertyName="SelectedValue" Type="String"/>
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="DSGrid" runat="server"
I have parentGridView and childGridView. ChildGridView opens in ParentGridView cell. But it expands the cell and makes all the parents cells out of formatting look and feel.1 ) How can i use colspan property to expand the childGirdView? 2) i am using find control in codebehind, i dont want to disturb that hierarchy as well
View 4 RepliesHow do I display table database information from two or multiple databases tables where they are linked by one field? For instance, I have an Orders Table and Customer Table, and both are linked by OrderID, and I'd like to display all Orders and the corresponding Customer information.
View 8 Repliesi have this xml file which i read using the DataSet.ReadXml( path ) method . The tables created from the Xml file is Related in such a maner that each product has many options. Product is in one table and Options are in another.Now all i want to do is display the related tables in One Gridview. For your reference below is the products Xml file,
[Code]....
Now this is what i have done in the Code behind , have a look below
[Code]....
Now the Grid works Great if i want to Display Individual tables out from Dataset but not when they are related . Please do shine your Knowledge on what should be done to display Child ~ Master relationship. By the way , its a definite NO for someone who would show me that link from msdn about displaying XML data using Xmldatasource and gridview [That's a lousy way to display data]
I am new to Entity Framework and working my way through it little by little. I think I have it figured out on how to get data into and out of 1 table at a time now the challenge is 2 tables into a gridview.
I have a user table that has a list of threads that a user can mark to track. Easy enough. Assign the userid number & threadid to a table with a push button while the user is logged in and viewing any of the posts that are on that thread. The new challange is to get only the posts that the user has marked to track. SQL easy. Entity not sure what to do.
If I make a view or stored procedure and add it to the database that would be an extra step. To join the 2 tables as in sql Select posts from posts where track.userid = @userid join track on post.userid=track.userid Seems Entity was made to avoid this type of thing. Than once the data is gathered I need to bind it to a gridview()
I have a .NET 1 web app that is using a Oracle database, the web app has a page of table names that allows the users to select, there are 101 tables listed on the page. When the user clicks on a table name, it takes them to a page that shows user friendly column headers, the table data, etc. Is there a way to use one GridView to do this and show the user friendly column headers instead of creating 101 pages or 101 user controls and show that control based on the table passed into the page?
for example: the user clicks table 22, I want my gridview to look like this
Buyer's Name State City Zip Code Phone Number
if they click table 55 I want them to see this
Product Wholesale Price MSRP Sale Price On Sale (check box)
instead of showing the users
BuyersFullName BuyersState BuyersCity BuyersZipCode PhoneNumber, etc
and so I, I would like to use 1 gridview on one page if possible and build the grid on the "fly", We have the user friendly column headers in a table.
So my questions are:
is this possible, if so, what is the best approach in doing this
from a scalabilty level and maintenance level, would the 1 gridview be worth for all 101 (and growing tables), or would building a seperate user control for each table be better?
I have been trying to make this work for a while, but I have not been yet able to figure this put. I am using VS 2008 and mysql database. I wrote a query and checked to see if it works in database. It does.
I have a gridview, whose select command is that query. But for some reason, I just get all the rows from one table only. I rechecked my datasource and it is ok. I read on some discussions that it is NOT possible to have data from two tables in a gridview. Is that true? If that is not true, how can I have data from multiple tables in a gridview? Or any other web control for that matter.
In article Load on demand data in GridView you clearly described. but it's not enough when we comes to conditions.
Is it possible to load data on query method?I want to add some field from other table so how to use inner join in this...
Like I'm having a table with userid and want to get user full name from users table where userId = users.userId
I have several table (car,country,employee,language....) and StoredProcedure (Insert,Update,Delete,Select) for all.
Is it possible in one form ex. TEST.aspx and one grid load data for any table and call all storedProcedure for him.
One GridView for all....
Select work fine, but how adjust (insert,update,primary key) it is possible?
i have a problem in joining two tables the reason ismy first table persdata is having common field as pno (a single row in a particular person) and the second tables is also having pno(having muti entry for a person as this table is of qualification and a person may have more than 3 qualifications and their grading)sample persdata(table)pno name coy appt sample qual(table)pno qual grading recommendationi tried my best to do it and not able to proceedi want the output in a single row as in persdata to a gridview with all the qual combined in one coloumn and all the recommendations combined in one coloumn for a person.
View 1 RepliesI have two tables Emp,Dept
EMP DEPT
EmpNo(PKEY) Id(FKEY) to Empno
Fname Location
Lname Date
Mname
I want to display Gridview columns like this ....
E.Fname,E.Lname,D.date based on Id
(or)
Display E.Fname,E.Lnamebased ob Id
I have a gridview showing values from two tables accommodation and pic (left join on accommodation). If there is no pic uploaded I want to display the row without the pic. So in the gridview I first check to see if the picid is null, if it is i don't render any 'a href' code , if it's isn't i do.
The problem that i'm having is that instead of the image showing up in the gridview itemtemplate i get
','_blank','toolbar=no,menubar=no'))" >
Here is my .aspx code
SelectCommand="SELECT pic.picid, aspnet_Users.Username, accommodation.location, accommodation.type,accommodation.description, convert(varchar,accommodation.createdate,101) as createdate
I want make a search by which want find data and display in gridview.
View 1 RepliesI created 3 product table . A,B and c.
I show product of table in different gridview.
Now I am using one search box. but how to search product name with image in one query all of three table....
Simple how to search product from multiple table and show result...
I bound a List of a LINQ-Table to my gridview.
Now I will have a foraign key information in my gridview:
Table User : UserID, username ....
Table Adresses: AdressID, UserID, Adress ...
1 User has x adresses
Now I bound normaly over
(from a in dc.adresses select a).ToList()
the LINQ-Information to my Gridview by an ObjectDataSource.
There is now shown the UserID in ID. How to show there my Username insted?
ASP.Net, C#.Net 3.5
I have a Grid View and show data from my sql database table1 ,when click on link button then genrate a pop up box nd data show in any control like detail view bt col_id show in textbox .
I have two tables
table1,table2
firt table fields are id,name,add,status,
second table fields r id,name add,status ,new staus,
whn i click on link button data comes from table2 if exists this record otherwise comes from table1 .
how to compare id from both tables .
i have dataset with two data tables inside
dt1
dt2
i want to bind data from both data table t gridview
for this how can i make join between two data tables inside dataset and retreive data
i would like to find out how to go about displaying data from multiple database tables on the same page. What i mean is it would look like the feeds on the facebook home page where you can see the information like newply uploaded photo or a new post.
I have two tables, and i want to display any newly created row on my home page from either table in the same control. Currently, i have two gridviews, but i want the data from both tables be displayed together.
I have a listview that shows the user the details of the members who have sent friendship request. The table from which the data come has two fields namely, sender_id[id of the one who sends friendship request] and receiver_id[id of the one to whom the request is sent].
There will be two columns in the listview. The first would show the pic and the name of the user. The problem is that how am I going to show the pic and the name if the table from where the data come does not contain these info. I know that the sender_id can be used to fetch the pic and name of the sender, but how should it be done?
Earlier I would do something like <%#Eval("fieldName")%>. But in the above described scenario the field is not present in the current table but the other one.
here I can find some info on how to display data from my MSSQL database in something like old style tables (table,<tr>,<td>) becouse I used to done it like this in classic asp but i had a formula for calculating where to put tr or td and it becomed very confused, not to mention displaying gruped records like 10 on each page...I tried gridview in VisualStudio but I can not find any info how to use sql in it so I think it can not help me becouse it is to much predefined and I do not know where I can change code for it like what data source to use, sql and other important thing
View 3 Replies
