Forms Data Controls :: Gridview Column With Data From Related Table In SQL Db?
Aug 18, 2010
I've got a gridview that is databound with LINQ in the code behind. One column shows the id from the table. I would like to show a more human friendly product name that is associated with that id number but is from another table. Thought I had it figured out by entering a Template field in the gridview tags (in the .aspx page) and an item template within that with
<ItemTemplate>
<%Eval(Products.productName")%></ItemTemplate>
but when I try to build it says this can only be done in the context of a databound control.
Can I add this column within the gridview tags or does it have to be done from the code behind?
View 3 Replies
Similar Messages:
Feb 23, 2011
I am using an ADO Entity Model for my ms-sql database.
My database has a Resellers table which has ResellerID (primary key, int) and Name columns along with other data.
I also have an Orders table which contains OrderID (primary key, int), OrderDate, ResellerID (foreign key to Resellers.ReselerID).
If I just do a query like:
[Code]....
I am able to reference order.Reseller.Name just fine with no problems.
However I have an EntityDataSource on my page as follows:
[Code]....
Notice the Include="Reseller" attribute in the datasource... I also have a GridView tied to that datasource as follows: I cut some of it off for breavity:
[Code]....
Now what I have listed above will run with no errors, but what I want to do is replace the column that displays "ResellerID" with the equivilant to order.Reseller.Name. In other words I want my grid to display the reseller's name rather than the numeric ID.
I have tried to change the DataField to "Reseller.Name" but that will generate the following error:
A field or property with the name 'Reseller.Name' was not found on the selected data source.
Is there anyway to do this without me writing a custom select statement in my code behind?
View 2 Replies
Jun 10, 2010
i have a GridView bound to a DataView. Some columns in the DataView's table are foreignkeys to related tables(f.e. Customer). I want to enable sorting for these columns too, but all i can do is sorting the foreignkey(fiCustomer) and not the CustomerName.
I have tried this without success(" Cannot find column ERP_Customer.CustomerName "):
<asp:TemplateField HeaderText="Customer" SortExpression="ERP_Customer.CustomerName" >
A tried also the DataViewManager, but i've a problem to detect the table to sort:
[code].....
I have to apply the sort on a distinct table of the DataViewManager, but this table would differ on the related tables.
I have bound the TemplateColumns in Codebehind in RowDataBound-Event f.e.:
Dim LblCustomer As Label = DirectCast(e.Row.FindControl("LblCustomer"), Label)
LblCustomer.Text = drCharge.ERP_CustomerRow.CustomerName 'drCharge inherits DataRow
What is the recommended way to sort a GridView on columns related to other tables? I could build a custom datatable with the customername instead of the foreignkey and bind this column to the TemplateField. But then my huge dataset in the model makes no sense anymore.
EDIT: I have a model with a Dataset. I'm binding one Datatable(ERP_Charge) from it to my GridView(actually i take a Dataview from that Table). In this Datatable are columns that are related to other Datatables in the Dataset(relations are defined). When i want to make the grid sortable its no problem on the columns that belong to ERP_Charge.
But the columns with foreign keys to other table could not be sorted because the Gridview shows f.e. not the CustomerID but the Customername. I get the Customername in RowDataBound. Normally i would join the tables and add a Datacolumn for the Customername.
View 1 Replies
Dec 18, 2010
I have created a gridView control and have successfully bound DataTable (dt) to it using
[Code]....
However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.
View 4 Replies
May 25, 2010
I have a gridview which I have databinded via the quick config facility, but I need to databind one column to a completely different sql table data field - how do I do this?
If I go into Gridview tasks and select the column and edit the data binding parameter but what is the format for a table outside the source definition for the the rest of the gridview?
View 4 Replies
Aug 30, 2010
i want show ten record from table in the gridview at 2 column in five row.
like this:
------------gridview-------------
record1 | record2
record3 | record4
record5 | record6
record7 | record8
record9 | record10
1 2 3 ...
-----------------------
View 6 Replies
Mar 30, 2010
I have a strongly typed view for Contacts table In my index page , i am accessing the tables as --- "foreach (var item in Model)"
This table has an association with Groups Table
How can i access Groups table data from view.
intellisense gives me possibility to write like "item.Groups.GroupTitle"
But it returns null(object not initiated) How to solve this?
View 3 Replies
Mar 26, 2016
i want to insert a gridview in table column on button click on web form..
View 1 Replies
May 7, 2015
How to merge Html table and Gridview Column together?
View 1 Replies
Jun 8, 2010
My dataset table data is from multiple tables (showing on a gridview),How to update the database tables using batch udpate on clicking submit, if the data is from a signle table, no problem, but I am not sure how to handle if the datais from mulitiple tables? If I have related tables, do I need put them in differet tables in the dataset?
View 6 Replies
Nov 24, 2010
I 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"
View 10 Replies
Jun 21, 2010
I have tried to query a table with an xml column by using XQuery and I can't get the Select to work.
All my knowledge/understanding of the subject comes from this MSDN article:
[URL]
so I am probably overlooking something minor:
I tried this query Select col1, Phone.Query('element CellPhone {I am not sure about what goes here} I tried {data('Phone/cellPhone} from aTable Where Phone.Exist('/Phone/cellPhone/text()[contains.,"412-8977"]') = 1 This syntax is definitely not fun.
View 2 Replies
May 7, 2015
I have a table with lots of fields. To display every record that has lots of columns on a web browser will inconveniently force the users to drag the scrollbar to the right.
Is it possible to divide each record to two or three inner rows in gridview?
e.g. My table has these fields: - UPC - Description - AdType_Week1 - AdType_Week2 - AdType_Week3 - AdType_Week4 - AdType_Week5 - Price_Week1 - Price_Week2 - Price_Week3 - Price_Week4 - Price_Week5 - OrderStatus_Week1 - OrderStatus_Week2 - OrderStatus_Week3 - OrderStatus_Week4 - OrderStatus_Week5
Instead of showing everything in one header like this:
UPC | Description | AdType_Week1 | AdType_Week2 | AdType_Week3 | AdType_Week4 | AdType_Week5 | Price_Week1 | Price_Week2 | Price_Week3 | Price_Week4 | Price_Week5 | OrderStatus_Week1 | OrderStatus_Week2 | OrderStatus_Week3 | OrderStatus_Week4 | OrderStatus_Week5
I would like to show it like this:
|-UPC-|-Description-|-AdType_Week1------|-AdType_Week2------|-AdType_Week3------|
01 banana type abc type def type feg
|-Price_Week1-------|-Price_Week2-------|-Price_Week3-------|
$97.51 $78.48 $41.45
[Code]....
View 1 Replies
May 7, 2015
[URL]
Further question:Is it also possible to edit both the parent fields and all levels of child fields?
View 1 Replies
Jan 6, 2011
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
View 2 Replies
Aug 11, 2010
I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
View 3 Replies
Mar 24, 2010
i 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]
View 2 Replies
Jun 9, 2010
I would like to display students and their grades with a GridView and LinqToSQL like this:
[Code]....
I found this topic but it doesn't answer my question: http://forums.asp.net/t/1557987.aspx
I have a many-to-many relationship between students and assignments called "grades".The grade for the assignment is stored in that table in a "gradeNumber" column.The many-to-many relationship seems to be a problem.I tried adding a TemplateField to my grid:
[Code]....
It doesn't work:
...student does not contain a property with the name grade.
It does work when I use class.name however to get a student's class he is in.In code students .grade[0].something works however My LINQ entities are extended with custom code to allow me to retrieve studentx.Assignments or assignmentx.Students.(I would also like to specify which assignments should be displayed in the grid.)
View 1 Replies
Oct 12, 2010
I have a gridview displaying "registrationtype id" (FK) from the registration table. I want it to display the related name instead of the id from the registartiontype table.
View 1 Replies
Jan 17, 2010
I am trying to looping thru a data table and update a column on each row. However after updating I am getting both before and after update records in the data table. Assuming there is only one column called "Qty" withing the data table and I want to double the value in the column. I use the following to perform updating but not getting my expected result.
[Code]....
View 1 Replies
Jan 16, 2011
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
View 4 Replies
Oct 12, 2010
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
View 4 Replies
Dec 12, 2010
almost typical master-detail scenario except the 'detail' data I want to display below the gridview will be coming from both the table that is bound to the gridview (master) and a related table.
simplified example: tableMain with field1, field2, field3 bound to master gridview. I need to select a row from the master gridview and have a form display below with field4 and field5 from tableMain, as well as all fields of tableDetail where field1 of tableMain equals field1 of tableDetail.
Is this what a 'formview' control is for? or do I just arrange my own controls to accommodate the data? Would a formview work considering my source will be partially from both the main table and the detail table? This is one of the scenarios were I know I could come up with something using none of the databound controls (except the master gridview), but I want to use the controls provided when it makes sense to do so, and utilize their benefits etc...
View 6 Replies
Jan 24, 2016
How to handle this error
"An explicit value for the identity column in table 'UserActivation' can only be specified when a column list is used and IDENTITY_INSERT is ON."
View 1 Replies
Oct 29, 2010
[Code]....
Main Gridview[Code]....
View 3 Replies
