I ran into this kind of situation many times without a nice solution. Binding a data source to a gridview and one of the column require nested query. Is it possible to have a callback function other than Eval()?
something like CallbackFunc(Eval("SomeField"));
I need to bind a List control based on the Gridview Row's datakeyName value while the Gridview control is being loaded into the page. I tried the following but it does not work.The BulletedList control is nested inside a Gridview Control and they both bound to an ObjectDataSource control. In my code, I passed teh UserID into the UserID parameter and call the Select() method but still does not work. Basically, I want to list of a user's hobbies, therefore the hobbies control are driven by the userID. tell me how can I get it to work?
protected void UserGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
int UserID;
[code]...
I have a gridview that I want to bind the results of a query to it once a user selects a value from a drop down list.
The query selects the same row from the same table but selects different fields based on the drop down list value selected
I get to the query selection but it does not refresh that page with the populated gridview.
Here's the code behind code
protected void ddlQuantity_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection connection = null;
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["PSI_DB_1ConnectionString"].ConnectionString.ToString());
connection.Open();
String nEstno = Request.QueryString["id"];
int id = Convert.ToInt32(Request.QueryString["id"]);
string SQLquery = "";
switch (int.Parse(ddlQuantity.Text))
{
case 1:
SQLquery = "Select Quan1"etc...;
break;
case 2:
SQLquery = "Select Quan2"etc...;
break;
case 3:
SQLquery = "Select Quan3"etc...;
break;
case 4:
SQLquery = "Select Quan4"etc...;
break;
case 5:
SQLquery = "Select Quan5"etc...;
break;
}
SqlCommand Cmd = new SqlCommand(SQLquery, connection);
SqlDataReader Dr = Cmd.ExecuteReader();
if (Dr.HasRows)
{
gvEstQty.DataBind();
}
Cmd.Dispose();
connection.Close();
connection.Dispose();
}
I have a label in a gridview where the text is set to <%Bind("lname")%> . I want to make it say thiis <%Bind("lname" + "fname")%>. I've been having a hard time making .net do this. I also want to add a "," or some other unrelated caracter?
View 2 Repliesi need to get data-bound items from outer listview to display in inner Listview, in this scenario:
[code]....
Where the higlighted text mean the title for outer datasource.
I am using Eval inside a datalist to populate a hyperlink within the datalist with a navigateURL value and I am using it as follows:
<asp:HyperLink ID="HyperLink_FullStory" runat="server" Text="Full Story" NavigateUrl='<%#Eval("LinkAddress")%>'></asp:HyperLink>
The issue I am facing is that the current page URL is getting appended to the 'LinkAddress'(the URL being fetched from the database) and thus,the final URL formed is not a valid one.Can someone suggest how do I remove the current page URL? Is there any way it can be done without writing code in the code behind page?
I'm trying to create a nested gridview, but I'm stuck at the editing/deleting part of the nested gridview. (Below is my code).The nested gridviews are filling out nice, I've set the DeleteParameter in the SQLDataSource, but I'm still getting this error when trying to delete a criteria: 'The Gridview 'gvCriteria' fired event RowDeleting which wasn't handled.'I've tried to create a method 'gvCriteria_RowDeleting', but that didn't seem to work out.Someone who can give me a piece of advice? Would it be possible to fill the gridview without using gvDomain_rowDataBound? Dries
[Code]....
[Code]....
And the C# behind:
[Code]....
In Nested Grid, we get a '+' sign. The problem is that '+' sign appears all times, even if there are no child records for that row. 1. Can we enable/disable OR Hide/Unhide '+' sign. depending on if child rows exits.2. OR alteast we can put some bgcolor indicating to user that this record do have child rows. Without any indicator user may feel quite annoying to click on '+' sign and nothing happens.
View 1 RepliesI am using a nested listview to display a seperate grid for each group of data returned from my db query. To get this working, I have adapted a piece of code to group the data prior to it being bound:
[Code]....
I am then using the following html markup:
[Code]....
[Code]....
This works as I want it to however some of the fields within the nested table need to be formatted as currency so I am trying to use Eval and {0:c} to do this however the moment I use Eval, the data items cannot be found
DataBinding: 'System.Data.DataRow' does not contain a property with the name '0'.
Is there a better, cleaner way to do this in ASP.NET 2.0?
An ASP.NET 2.0 page displays a datalist of records. Each record can have many dates, so the dates are in a nested gridview (I chose a gridview over a datalist here because we want to be able to delete a date and this is easier done in a gridview). The parent record can never be deleted.
The display works fine: the nested gridview gets its datasource during the parent datalist's OnItemDataBound event.
The problem: the nested gridview's delete function. The date gets deleted without a problem (handled in the OnRowDeleting event), but somehow the redisplay is untying all the other nested gridviews from their datasources. The delete does not appear to cause a page postback, so I don't know how the other nested gridviews are losing their datasources.
I want to bind two column on single level in GridView
I m using this code
<asp:Label ID="Label1" runat="server" Text='<%# Eval("lChannelName")+ " " +Eval("lTransformData") %>' >
</asp:Label>
But i want to bind First column at Left hand side and second column from right hand side
I have a conditional Eval statement in a Gridview that returns a boolean result to display an image if two datafields(strings) are identical:
Visible='<%# Eval("customerA").Equals(Eval("customerB")) %>'
Works great except I don't want the image to display if both datafields are empty. How can I add that logic into this Eval stmt?
I am using Footer template in gridview for first time..
I am unable to show anything in the footer template with eval() method...
Here is some of my code in the gridview..
<asp:CommandField ShowSelectButton="True" FooterText="Amount" />
<asp:TemplateField HeaderText="ColorCode">
<ItemTemplate>
<asp:Label ID="lblColorCode" runat="server"><%# Eval("ColorCode")%> </asp:Label>
</ItemTemplate>
<FooterTemplate>
<%# Eval("Total")%>
</FooterTemplate>
</asp:TemplateField>
I have a GridView, with a DropDownList as one of the Columns. I can get the SelectedIndexChanged method to trigger - but I cannot figure out how to get other Data regarding which row this triggered on i.e. if I could get the value in the ID column (DocID below), that would be great. My code is a bit too long, so I am just posting snippets. In the *.aspx file I have:
[Code]....
In the *.aspx.cs File:
[Code]....
I am wondering if I can get the DocID from within StatusDropDownList_SelectedIndexChanged - so that I can make appropriate changes to the Database. For e.g. in the RowDataBound event, which I had a GridViewRowEventArgs e, I could easily do e.Row.DataItem - to get the DataItem, I am wondering if I get/do something similar in the SelectedIndexChanged method. (I would prefer this be not the GridView Row Index i.e. I would prefer the DataItem if possible.)
I am having my first go at a nested gridview within a gridview. I have successfully loaded the data and it displays fine. Within the child gridview I have two textboxes that the customer can change. I also have an Save button. When the customer selects the save button the RowCommand for the child grid executes as it should. However I am unable to figure out how to access the two textboxes.
In the past I have got the row index from e.CommandArgument, established the correct GridViewRow using the gridview ID and the row index, and then used findcontrol to get the textbox
int index =
Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvGridView.Rows[index];
TextBox txtName = row.FindControl("txtName")
as TextBox;
But when working within the Child GridView RowCommand event I am unable to figure out how to gain access to the textbox. The child gridview is not recognized.
I am tring to set the selected value of a dropdown inside a gridview like this:
[Code]....
And I get error:
[Code]....
I have a page where there are two nested gridview, I have a column in the child gridview that uses a function to display the data.This function uses the id of the id of the father and son as parameters. I tried the code below, but does not work ...
[i]
<asp:GridView ID="gvParent" runat="server" AutoGenerateColumns="False" OnPageIndexChanging="gvParent_PageIndexChanging" AllowPaging="true" OnRowDataBound="gvParent_RowDataBound">
<Columns>
<asp:BoundField DataField="ParentId" HeaderText="ParentId"></asp:BoundField>
<asp:TemplateField HeaderText="Childrens">
<ItemTemplate>
<asp:GridView runat="server" ID="gvChildren" AutoGenerateColumns="false" OnRowDataBound="gvChildren_RowDataBound">
<Columns>
<asp:BoundField DataField="ChildId" HeaderText="ChildId"></asp:BoundField>
<asp:TemplateField HeaderText="MyFun">
<ItemTemplate>
[b]<%#MyFun(Eval("ParentId"),Eval("ChildId"))%>[/b]
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>[/i][Edit by="mtugnoli" on="18 gennaio 2011 16.29"][/Edit]
fetch data from Nested gridview checkbox on Click button event which is present outside the gridview. I did try by creating an object of child gridview on button1_click but cannot fill the value from Gridview2 into my int i. Below mentioned is the Code i am using. The database I am using is Oracle. ==== Code =====
protected void Button1_Click(object sender, EventArgs e)
{
OracleConnection con = new OracleConnection();
[code]...
regarding getting data from XML file and binding gridview with data .
View 6 RepliesIn nested gridview, i am finding some problem, i want to show child Grid headers in Parent Gridview. Can anyone tell me that how it is possible? Its very urgent. Waiting for quick response.
View 1 RepliesI'm trying to implement a recipe search page that allows users to specify search criteria by selecting checkboxes that match desired recipe attributes. All the data is stored in a database uing tables with 1 - many relationships. Each recipe can have multiple attributes from any of 5 attribute tables. I want to find all the recipes that match the user-selected criteria and display them in a grid. For example, the user may want a breakfast (attribute 1) recipe that is made with fruit and milk (attributes 2 and 3), is low-fat and high fiber (attributes 4 and 5), and takes less than 15 minutes to prepare (attribute 6). The query for this example might look something like:
SELECT distinct recipes.name, recipes.difficulty, recipes.preptime, recipes.cooktime
FROM recipes, recipeMeals, recipeDishes, recipeFoodGrps, recipeNutrients, recipeFixTimes
WHERE recipes.id = recipeMeals.recipeId and recipes.id = recipeDishes.recipeId and recipes.id = recipeFoodGrps.recipeId and recipes.id = recipeNutrients.recipeId and recipes.id = recipeFixTimes.recipeId and recipeMeals.mealId in (1) and
recipeDishes.dishId in (5) and recipeFoodGrps.fdGrpId in (1, 6) and recipeNutrients.nutrAttsId in (2, 3) and recipeFixTimes.fixTimeId in (1)
I' can generate the SQL but can't figure out how to bind it to a grid control. No could I see how to get any of the data controls to build the query for me. Is there a way to say "execute this query and display the results in a GridView"?
<asp:TemplateField HeaderText="Is Activate ?">
<ItemTemplate>
<a href="#" onclick='fnViewRemarksTest(<%#DataBinder.Eval(Container.DataItem,"CustomerId")%>)'><%#Eval("IsActivated ")%></h3></a>
</ItemTemplate>
</asp:TemplateField>
Is Activated is a boolean data type column in Sql.
I want to Show that, when IsActivated is true text will be "User Is Active" and when false , the text will be "User Is not activate" ...
I have designed a collapsible nested gridview project using this article as a reference Collapsible Nested GridView with Paging using ASP.Net. I am trying to modify the code to collapse a gridview when another gridview is expanded so that only one nested gridview will be open at a time.
View 1 Repliesnot quit sure where I've go wrong with this but hopefully someone might have an idea why this isn't working:
This what I thought would work:
[code]....
But it's not! what I get for the OnClientClick attribute is: "DeleteRowKey=<%# dataBinder.Eval(Container.dataItem, "idx_mstrWord") %> "
I've tried several variations (EVAL, BIND, specifying the container and not specifying the container),
none of which gives the expected results; OnClientClick="DeleteKeyRow=12345"
If I add a label and set the text to: <%# dataBinder.Eval(Container.dataItem, "idx_mstrWord") %> I get a number which is what I should but if I try to get it to embed it so my cleint script can work with the data all I get is binding command.
What am I doing wrong? I really don't want to have to kludge around with some hidden field and then have to search through the grid to get at this data key. I need this key on the client side in order to provide additional details in my confirmation popup modal.
I have a Data Table which Populate from the Stored Procedure which is below
[Code]....
and iam binding the Gridview with Data Table it is working .Now i have to make some thing visible and Invisible based upon some Value like below
Datatable dtTable = (Viewstate)["StatusData"]; // Same Data Table which is Data Source of Gridview Control
[Code]....
Where Status.Open is an integer Enum value like Open = 1 and Close = 2 .row["Status"] is the Text Open and i want to compare with integer valueHow i compare the Values ? i have to use the same Data table or not?