Forms Data Controls :: Binding A Gridview Nested List Control Based On Field Value?
Dec 10, 2010
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;
I have 2 fields in my gridview one called ScriptType the other BagNo, when a user click the edit button, I would like the BagNo filed to be disabled if the ScriptType field is = "TTA" and enabled otherwise. How can I do this?..something along these lines see below..I am using VB..
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()?
I have a list box in a list view control. I want to access the value of the listbox. I have fixed the height of the list box and the box has scroll bars. If i change the number using the scrollbar and then click on the number (turning it blue) everthing works fine. If I simply change the number using the scrollbar the system throws the error below. Can anyone tell me how to get this to work simply by using the scrollbar to select the number (without having to also click on the number itself) This is the error that is thrown
[FormatException: ??????????????????] Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +201 Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +66 [InvalidCastException: String "" ??? 'Integer' ??????????] This is the aspx listbox <td><asp:label id="Label1" runat="server" text='<%# eval("CustomerID") %>'></asp:label></td> <td><asp:label id="label2" runat="server" text='<%# eval("ProductID") %>'></asp:label></td> <td> <asp:ListBox ID="ListBox1" runat="server" Height="30px"> <asp:ListItem Value="0">0</asp:ListItem> <asp:ListItem Value="1">1</asp:ListItem> <asp:ListItem Value="2">2</asp:ListItem> <asp:ListItem Value="3">3</asp:ListItem> </asp:ListBox> </td> <td>$<asp:label id="label4" runat="server" text='<%# eval("OrderDate") %>'></asp:label></td> <td> <asp:Button ID="Button1" runat="server" Text="order" CommandName="cart" CommandArgument='<%# eval("CustomerID")%>'/></td> This is the vb page Partial Class Droplist Inherits System.Web.UI.Page Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then Dim db As New DataClassesDataContext ListView1.DataSource = db.Droplist1 ListView1.DataBind() End If End Sub Sub upload(ByVal sender As Object, ByVal e As ListViewCommandEventArgs) If e.CommandName = "cart" Then Dim q As ListBox = e.Item.FindControl("Listbox1") Dim ProductNumber As Integer = CType(q.SelectedValue, Integer) Label3.Text = ProductNumber End If End Sub End Class
I have a form in which I have a dropdown list and a list box.
This dropdownlist is populated by a column in thetable . This drop down list may have values ranging from 1 to 5.
This values in the dropdownlist are to be made the caption headings of the list view control.
For insance if there are three values in the dropdown there should be three columns in the list box with the heading as the values of the dropdownlist.for 5 it should be 5.
Also there are two additional columns which would be constant.
which doesn't work because of the final apostrophe in the notation i.e. %>' It truncates after the word e.g O'Neil Someone becomes O' which is incorrect.
This works like a charm: value='<%# DataBinder.Eval(Container.DataItem, "Name").ToString().Replace("'", "'")%>' which isn't good practice as I don't want to hardcode '
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?
Now i want to do search, sorting & Paging in the GridView with out Postback of the Page & with out hitting the DataBase when do Paging or searching in GridView.
I have a List<string> that I want to use as a datasource for the gridview, making the column a HyperlinkField type and passing the value clicked in the column in the url. My code:
The Listbox has a list of students. The Gridview has a list of classes offered during a period, such as:
Math Science English etc. When I click a student in the Listbox, I call a sproc via Linq, and get the ClassID and ClassTitle that student is registered for.
What I need to do is Highlight the record in the GridView that matches the ClassID or ClassTitle returned by the sproc.
Previously, I used a ListBox for the Class Offerings. This is easy with a Listbox using the FindByText method:
I have a web page that has a repeater bound to a data source. I beed to change a label inside the repeater based on the data that is in each repeater item. For instance, for the first item it might be one thing, and for the next item the label may be something else. I am currently doing some processing in the prerender event, but I don't know if I can or how to access the data source fields there. Where and how do I get access to the data in each item so I can change the label text?
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
I'm having trouble figuring out how to display a gridview based on the selection of a drop down list. I manually entered the drop down list items, but in the configure/choose data source I don't understand how you make a relationship between each list item and the corresponding database table you want to show.
I have created a gridview (this is a usercontrol) with another gridview (also a usercontrol) inside it. Now I would like to bind a checkboxlist to the inner gridview. This is my markup for the inner gridview user control
i want to see the sales in the grid view based on the month selected from drop down list. Ex: when I select June 2010 from the ddl box, the sales for that month are correctly displayed in the grid view. I go to page 4 to look at some sales there and then switch the month to August 2010 to see sales for that month instead. Here is the problem. When I switch the month, it show August 2010 sales, but stays in page 4 instead of going back/resetting back to page 1 of August 2010 sales.
How do I reset the grid view page back to the first page of August 2010 sales?
I am fairly new to ASP. If I have missed an imp. detail in this post, let me know and I will get that info. out there.
i have a parent gridview,It has child gridview in every row.The edit and delete event of this child is working is fine.When i add data to through child gridview with empty data template.i can 't find the value of the parent contril id.
gvProductFeatures is the chid gridview... protected void gvProductFeatures_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.Equals("EmptyAddNewFeature")) { GridView gv = (GridView)sender; if (gv != null) { // here i need find the appropriate control id from parent..how?? int intIndex = Convert.ToInt32(e.CommandArgument); Label lblEmptyGroupPK = (Label)gv.Controls[0].Controls[0].FindControl("lblEmptyGroupPK"); TextBox txtEmptyFeatures = (TextBox)gv.Controls[0].Controls[0].FindControl("txtEmptyFeatures"); } } } catch(Expection ex) { } }
I'm new to web dev and c# so please bare with me. I am trying to create a dynamic gridview in a web form for users to to answer questions with (code below).
The dificulty im having is that i am nesting a dropdwonlist in the gridview and want to be able to dynamically set the list values based on parameters (of the row they are on). These values are in the main dataset for the gridview as each row represents a questionid and question text and then a ddl for the criteria...
I just don't know how to set the values for the dropdown all the code so far is below... just need to be able to populate the dropdowns with the relevant values.
I have created a stored proc to return the different criteria based on the questionid and questionGroupid which is the dataset that populates the other fields in the gridview: dbo.usp_QuestionCriteria @QuestionGroupId, @QuestionId
I have added this as a tableadapter called criteriaTableAdapter in a xsd file as well using the wizard... not sure if this is the right option though or just use the same method as i have for the other stored procedure as in the code below:
[CODE
]using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Sql"].ConnectionString); con.Open(); SqlCommand com = new SqlCommand("usp_QuestionGroupDS", con); com.CommandType = CommandType.StoredProcedure; SqlDataAdapter ada = new SqlDataAdapter(com); DataSet ds = new DataSet(); ada.Fill(ds); for (int i = 0; i < ds.Tables.Count; i++) { if (ds.Tables[i].Rows.Count > 0) { GridView gvDynamicQuestion = new GridView(); gvDynamicQuestion.Width = Unit.Pixel(700); gvDynamicQuestion.BorderWidth = Unit.Pixel(0); gvDynamicQuestion.Caption = "<div id="nifty" class="QuestionGroup"> <b class="rtop"><b class="r1"></b><b class="r2"></b><b class="r3"></b><b class="r4"></b></b>" + ds.Tables[i].Rows[0]["Category"].ToString() + " Questions<b class="rbottom"><b class="r4"></b><b class="r3"></b><b class="r2"></b><b class="r1"></b></b></div>"; gvDynamicQuestion.AutoGenerateColumns = false; gvDynamicQuestion.ShowFooter = true; TemplateField tf = null; tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewTextTemplate("QuestionId", DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewTextTemplate("QuestionId", DataControlRowType.DataRow); tf.FooterTemplate = new DynamicGridViewTextTemplate(DataControlRowType.Footer, ds.Tables[i].Rows.Count); gvDynamicQuestion.Columns.Add(tf); tf = new TemplateField(); tf.HeaderTemplate = new DynamicGridViewTextTemplate("Question", DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewTextTemplate("Question", DataControlRowType.DataRow); gvDynamicQuestion.Columns.Add(tf); tf = new TemplateField(); tf.HeaderText = "Criteria"; tf.HeaderTemplate = new DynamicGridViewTextTemplate("Criteria", DataControlRowType.Header); tf.ItemTemplate = new DynamicGridViewDDLTemplate(); gvDynamicQuestion.Columns.Add(tf); ////tf = new TemplateField(); ////tf.HeaderText = "Criteria"; ////tf.ItemTemplate = new DynamicGridViewDDLTemplate(); ////gvDynamicQuestion.Columns.Add(tf); gvDynamicQuestion.DataSource = ds.Tables[i]; gvDynamicQuestion.DataBind(); phDynamicGridHolder.Controls.Add(gvDynamicQuestion); } } } protected void DynamicGrid_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Footer) { // } } } public class DynamicGridViewTextTemplate : ITemplate { string _ColName; DataControlRowType _rowType; int _Count; public DynamicGridViewTextTemplate(string ColName, DataControlRowType RowType) { _ColName = ColName; _rowType = RowType; } public DynamicGridViewTextTemplate(DataControlRowType RowType, int QuestionCount) { _rowType = RowType; _Count = QuestionCount; } public void InstantiateIn(System.Web.UI.Control container) { switch (_rowType) { case DataControlRowType.Header: Literal lc = new Literal(); lc.Text = "<b>" + _ColName + "</b>"; container.Controls.Add(lc); break; case DataControlRowType.DataRow: Label lbl = new Label(); lbl.DataBinding += new EventHandler(this.lbl_DataBind); container.Controls.Add(lbl); break; case DataControlRowType.Footer: Literal flc = new Literal(); flc.Text = "<b>Total No of Questions:" + _Count + "</b>"; container.Controls.Add(flc); break; default: break; } } private void lbl_DataBind(Object sender, EventArgs e) { Label lbl = (Label)sender; GridViewRow row = (GridViewRow)lbl.NamingContainer; lbl.Text =DataBinder.Eval(row.DataItem, _ColName).ToString(); } } public class DynamicGridViewDDLTemplate : ITemplate { // Implementation of ITemplate public void InstantiateIn(System.Web.UI.Control container) { // Create a DDL DropDownList ddl = new DropDownList(); //Attach method to delegate ddl.DataBinding += new System.EventHandler(this.ddl_DataBind); container.Controls.Add(ddl); } //Method that responds to the DataBinding event private void ddl_DataBind(object sender, System.EventArgs e) { //DropDownList ddl = (DropDownList)sender; //DataGridItem container = (DataGridItem)ddl.NamingContainer; //ddl.Data.Checked = [Data binding expression]; } }
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 have a 3 level deep nested gridview. The expansion/contraction of each record was originally done with javascript. There were html <div> tags around each gridview. Since these were HTML div tags I could give them IDs that were dynamically bound to record ID value within the database. I then had onclick buttons that passed in a bound record ID value that coresponded to the appropriate div tag that needed to be expanded (e.g. display: inline (show it) or if it is already inline then display: none).
This worked beautifuly. Unfortunatley I wanted to be able to do in-girdview editing of the child records. When expands a parent record and clicks to edit a child record the OnRowEdit event fires which automatically generates a postback and resets the variables within the JavaScript. THEREFORE THE ENTIRE GRIDVIEW STATE BECOMES CONTRACTED.
So finally I decided to change the div tags to <asp: Panel> and the onclick images to .net clickable images (all .net objects no framework). This works because the state is remembered within each postback. However, the problem I'm having is I can't dynamically bind ID's for panel since this is not allowed. HOW CAN I GIVE THE PANEL <% Bind("id") %>. THAT I CAN REFER TO SO I CAN OPEN THE APPROPRIATE PANEL.
I have a parent gridview control and a another gridvew control inside parent gridview.I want to access a column named type in parent gridview inside child gridview.And use the value of that column in a javascript function
I'm a bit of an ASP.NET newbie and I am creating a data table in memory and binding this to a gridview control. The code is as follows:
Dim DstBasket As New DataSet, TblBasket As New DataTable With TblBasket .Columns.Add("BskPrdCd", System.Type.GetType("System.String")) .Columns.Add("BskPrdDesc", System.Type.GetType("System.String")) .Columns.Add("BskQty", System.Type.GetType("System.Int16")) .LoadDataRow(Split("12345,Test product 1,1", ","), True) .LoadDataRow(Split("122,Test product 2,2", ","), True) .LoadDataRow(Split("123A,Test product 3,5", ","), True) .LoadDataRow(Split("44,Test product 4,1", ","), True) End With DstBasket.Tables.Add(TblBasket) With LfnGridView("GdvBasket") .DataSource = DstBasket .DataBind() End With
The data displays in the gridview control fine with both edit & delete options but when I attempt to delete, it has no effect. How do I force removal of the relevant row from both gridview and table? Most of the documentation I have unearthed shows how to achieve this when connected to a SQL table which is clearly not the case here.
For the solution, I cannot use any event handling methods, because my webapp is fully ajax based and no complete postback is possible. So here's the problem.I have a `List<WebPage>` that contains a list of Links `(List<Link>)` and I need for all the links to bind repetitive information such as page title, id, url. Here is my current repeater.
As per ListBox Items a data should show in GridView by using UP and Down arrow keys. I tried by using Oonselectedindexchanged but when a page loads from listbox the cursor become active to inactive.
