I have a dynamically created dropdownlist I'm databinding. Everything seems fine until I trigger the ondatabinging to change the text of the item bound. How can I access the source data from here?
View 2 RepliesI have a dropdownlist control in an edititemtemplate for a details view defined like this:
<asp:TemplateField HeaderText="Primary Use">
<EditItemTemplate>
<asp:DropDownList ID="ddlPrimaryUseEdit" runat="server" OnDataBinding="DropDownList_DataBinding"
[code]...
I have a datasource definded as a query to my database that has a column named "PrimaryUse". Sometimes there can be a value in the PrimaryUse column that isn't listed as one of the dropdownlist items and so my application crashes when trying to bind the dropdownlist's selectedvalue to that field. I'm trying to create code in the edititemtemplate's OnDataBinding event that will check if the value being returned from the datasource is a valid value listed as an item in the dropdownlist options. My problem is that I'm not sure how to get the datasources fieldvalue for that column in the behind code. Is this possible? Is so, can some one give me an example or point me in the direction on how to do this?So, in the OnDataBinding event for the edititemtemplate listed above, I would like to do the something like the following (psuedo code):
if datasource.datafieldvalue("PrimaryUse") is in dropdownlist.Items then Valid
else set dropdownlist.Selectedvalue = "Default"
I have a basic DropDownList bound to a ObjectDataSource:
<asp:DropDownList ID="DropDownList1" runat="server"
AutoPostBack="True" DataSourceID="objDataSource1"
DataTextField="FieldName" DataValueField="FieldID" />
The DataTable from which it receives the DataTextField and DataValueField values also returns some other interesting information about the records. Say Active = Y/N for simplicity's sake.
What I'd like to do is to set the background-color property of the DropDownList Item based on that Active field in the DataSource results. Further, I'd like to do this "in the same pass" as when the DropDownList is bound to the data. So my guess is that it has to happen during OnDataBound.
I could go back and loop through the DropDownList items later. But it would involve embedding loops and re-visiting the DataTable rows and it just seems inefficient
int row;
for (row = 0; row < DropDownList1.Items.Count - 1; row++)
{
[[if this row = that data row]]
DropDownList1.Items[row].[[DoStuffHere, etc.]]
}
I have a repeater that dynamically generates the sum of integers upon a button click (a random number gets stored in an sql database). The sum works fine and I get the appropriate output, however I would like to grab the sum and put it back into my C# code so that I can perform operations with it (it's the accumalated score of a game of blackjack so want to check if they are bust etc.) Here is my code:
<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1" >
<ItemTemplate>
<label runat="server" > <%# DataBinder.Eval(Container.DataItem,"a") %> </label>
</ItemTemplate>
</asp:Repeater>
How do i grab the DataItem "a" and put it back into my code?
Am using datalist to create a kinsd of message board, in the back end am having two tables one for the parent comment , and other for the child comments
The data source is extracted by LINQ to SQL with the load option , so I get everthing when I debug on the code behind , and I can see all the fields each parent comment and the child comments.
the problem is with binding the data on the disply for example all the parent table fildes can be rendred without any problems:
<%# DataBinder.Eval(Container.DataItem, "comment1Parent") %>; "showing me the orginal post"
Problem here:
<%# DataBinder.Eval(Container.DataItem, "Childcomment") %> is not rendred and I got this error msg:
DataBinding: 'DataAccessLayer.Comment' does not contain a property with the name 'childComment'.
In the debug I navigate to the childComment and this is its HTML visualisar:
new System.Linq.SystemCore_EnumerableDebugView<DataAccessLayer.Comment>(((ASP.usercontrols_comments_ascx)this).Comments)).Items[0]._comments_Replies.entities.items[0].childComment
I tried
<%# DataBinder.Eval(Container.DataItem, "_comments_Replies.childcomment")
Same as above error came to me.
I have a Gridview on my page and I have addedd some checkboxes to it using a template, I have some code that cycles through each row of the Gridview and checks if the checkboxes are checked, but I don't know how to access the data in the Gridview, the code I have so far is:
Protected Sub cmdGenerate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdGenerate.Click
For Each row In GridView1.Rows
Dim cb As CheckBox = row.FindControl("chkSelUser") [code].....
I have GridView control with a checkbox in one of the columns. When I click a button to submit, I want to see if the checkbox is selected, but when I do, it only gets "Yes" for Label but false fo Checked. I know I am accessing the column because I get the Label. Wha tam I missing?
<asp:TemplateField HeaderText="OverRide">
<ItemTemplate>
<asp:CheckBox ID="OverRide" runat="server" Text="Yes" />
</ItemTemplate>
</asp:TemplateField>
//Code Behind
//Where i = the row
CheckBox cb2 = ( CheckBox )GridView2.Rows[j].Cells[7].FindControl("OverRide");
If am trying to change the background color of a Label in C# code behind based on the value of a check box in a DetailsView.
if ( DetailsView5.Rows[0].Cells[5].Text == "1" ) "red"; )
{ Label5.BackColor = }
From what I understand within the Gridview Object you can have many datakeynames.
I have the field like this DataKeyNames = "id1, id2"
However, i don't know how to access the DataKeyNames individualy. For example. How do you access the first ID for the for a given row or the 2nd ID for a given row????
I currentlly am trying to get a bit value from a specific cell, i can get a text value from text cell but i cant seem to fiqure out how to access the bit value. This is on a dgvRowCommand event so im using datakeys to access the row and a column index for the coloumn like so.
lblFolderRead.Text = dgvCollabFolder.Rows[currentIndex].Cells[1].Text;
This works if im trying to get a text value but obviously a bit value isnt text and thus does not return anything, How would i access a bit value in the manner above, or if it is not possible that way what other alterntives are there?
I have a page that will generate upto 10 copies of some web controlls, depending on how many the user wants, but I am not sure on how to access the data the user enters into it. The code I have is:
[Code]....
As you can see I want to access the vale to add to the list but not sure. I tried tbGameNamei.Vaue but VS has a kanipshat about it.
I have gridview, and in this gridview, I insert a new row dynamically depending upon a value from the database all the way down the table. Even though this is all working well, I need to access a number of controls that I added to the inserted row. Namely, a checkbox and label. When I try to access these controls, I am getting an error message - object not set to reference. Then I tried saying "Gridview1.Rows[rowIndexVal].Cells[1].Text = myTextVal", but what this does is to insert the value on a different row.
Therefore, I have two problems, which I am really desparate to try and solve:How do I access the correct row and control that I have added to my inserted row, andBecause I have a checkbox control on my inserted row, which has an event associated with it, how do I get the selected row the user clicked. When I try doing this using FindControl, I always get a row index of zero.I am using Table object and TableCell to add a new row dynamically to the gridview, and then using ColumnSpan to make it fit the number of columns in the gridview.
Accessing GridView Element of specific row?
GridView1.DataSource = newDs;
I have added a table to my FormView Edit template for structure and a button that pops up a form for information.
When the button is clicked I want a check box in neighboring cell to become checked. But I am having problems in the VB code behind, establishing the name of the check box to change its state. Its something like this....
FormView1.ItemTemplate.(CheckBox1.Checked = True)
I have taken checkbox inside gridview. And also one linkbutton. When i click on linkbutton to check whether this checkbox is checked or not.
I have some code snippest.
[Code]....
I have a Gridview X in which there are 6 columns(5 template columns that are text boxes and 1 bound field). The user has the option of changing the value in the text boxes annd saving them. There is one more GridView Y that displays DB values(all 6 columns are bound fields). Initially X will show the values that being shown in Y, and when user changes the values in Y,he should be able to save it. If we are trying this using OnTextChanged event of asp:Textbox, there is a postback everytime the user makes a change in any of the textboxes. Instead i want it such a way that all the changed values should get concatenated together and should be sent to the DB.
View 4 RepliesIn a page, there is a lable called lblTotal and a gridview with 3 columns; Name, Percentage and Amount.
Name and Percent are values that come from a database. Next I need the caluclate the Amount field. The Amount field should be set by taking the Percentage column value in each row, against the value in lblTotal and displayed in the Amount column
So for example
If the value in lblTotal is £200 and the dataset in my gridview looks like this...
Name......Percent......Amount
John......20%..........
Dave......60%..........
Mark......20%..........
Then the result would be this
Name......Percent......Amount
John......20%..........£40
Dave......60%..........£120
Mark......20%..........£40
So I guess I would need to do this using OnRowCreated and do a find control maybe?
Actually I and doing my college Project and I have some Problem.I have 3 sections in my web page:1. The Search Part, which search a product by its name or Id.2. Result Part, which is a grid view showing Product ID,Product name ,its stock and Price.3. Billing Part, where The bill will be created which contains Sr.no. ,Product Id, Product name, Qty,Price,Total Price as attributes.Now I want that if any one search the product then result is shown in result part and then from the list of the products i click a product and add it in the bill list.But I am not able to understand here how to access a data from the grid view i.e. accessing Product Id,Product name, Price and add it to bill.
View 5 RepliesI have a datalist and I am filling it using a dataadapter, dataset. So in my .ascx page, I have
<asp:datalist runat="server" id="dlProducts" repeatcolumns="2" repeatdirection="horizontal">
<itemtemplate>
<table border="0">
<tr><td><%# Eval("Item_Name") %></td></tr>
<tr><td>I have to add a picture here</td><td><%# Eval("First_Name") %></td></tr>
</table>
</itemtemplate>
</asp:datalist>
In the area where I have put a statement like "I have to add a picture here", I have write a big case statement. Like:
Case: 6 // show a picture from file1
case: 7 // show a picture from file2
Case 8: //show a picture from file3
So How do I do this here? Because I dont know how to access the datalist values from code behind.
Here is my code behind:
SQLString = "SELECT First_Name, Picture, item_name, item_id from table1 where item_id = " + request.querystring["iid"];
dataadapter daItems = new dataadapter(SQLString, "connection_name");
dataset dsItems = new dataset();
daItems.fill(dsItems);
dlProducts.datasource = dsItems();
//So at this point how do I populate the picture in the <TD> tag I mentioned earlier?
I have a repeater such as this structure
[Code]....
With the code behind that does this
[Code]....
When I click the add to cart button nothing happens.
In my application Iam using GridView, in this there are fields (Quantity, Price, Amount) the user can enter Quantity Field value which is a template field (textbox). Iam calculating Amount(Quantity * Price) using Javascript and assigning to the Amount Column cells as below
Gridviewcell.innerText=Quanity * price.
and when user clicks on the Save button I want to add these details of Gridview to the database.
when I try to access the values of the gridview using below code
For i=0 to GridView.rows.count-1
GridView.Rows(i).Cells(2).toString ( for Example)
Next i
It is not displaying the changed value instead it is displaying the default value before calculating the amount.
Before implementing the Javascript part, I had done this in the code behind and it was working fine... Now I just dont want the page to get load so I used javascript.
able to access the value of Gridview cells which are assigned using Javascript.
I've been playing with a certain detailsview for most of last week. This particular control is located within a panel that is hidden until a user clicks a linkbutton on a gridview. Then the panel's visible property is set to true and the detailsview is populated based on the commandargument passed through the link button. What I've discovered is that with each postback, the datakey or control parameter, still not sure which or if both, is lost. I've discovered a lot about ViewState and how controls work and am a bit surprised that something as common as using a detailsview within a gridview wouldn't be handled better than it is now. I have been able to get the proper information to build a correct select statement when the user decides to edit a record. I am now working on an update statement, but for some reason while I have the right key to update the right record, I am unable to access the user-generated data that was entered in the details view.
For instance, I select record with ID of 1 in the gridview. It pulls up the detailsview and I can view it. I then click edit. The correct record is still there. (It was previously going to default). When I enter new text in a textbox and click update, the app still knows I am working with record #1 but doesn't seem to be able to find the textbox control. I have currently hard-coded a value into the field just to see if I could actually get the record to update and it did. I am using an OnInit to cause the sub to run and think this might be the problem. However, I have been unable to find a better way around this.
Here is the sub that executes on the OnInit() of the detailsview:
Protected Sub notes_binding()
If notesDetail.CurrentMode = DetailsViewMode.Edit Then
sqlNotesUpdate.UpdateCommand = "UPDATE [Oilchange_Notes] SET [notes] = '" & CType(notesDetail.FindControl("notes"), Textbox).Text & "' WHERE [vehicle_id] = " & Session("unitNumVal")
sqlNotesUpdate.UpdateCommandType = SqlDataSourceCommandType.Text
sqlNotesUpdate.Update()
End If
sqlNotesUpdate.SelectCommand = "SELECT * FROM [Oilchange_Notes] WHERE ([vehicle_id] = " & Session("unitNumVal") & ")"
End Sub
And this is the error I get: Object reference not set to an instance of an object. If I'm correct about why it's not pulling the actual value or even acknowledging the control exists and is actually 'notes' (it is), then at would point would be the best to place this code?
I'm trying the following code to access the value of a ListBox nested in a ListView.
View 3 RepliesI have the following html in my gridview in an item template :
<a
href="<%#Container.DataItem("ReciprocalURL")%>"
target="_blank"
title='<%#Container.DataItem("ReciprocalURL")%>'
id="recip">
So I thought that you could use id="name" and access this just like an ASP control such as <ASP:Checkbox
or <ASP:Label etc. My code continues to caugh and state object not set to an instance of an object when I uncheck my checkbox
Line 741: ElseIf Not Me.CheckBox1.Checked Then
Line 742: Dim row As GridViewRow = gvLink.SelectedRow
Line 743: Dim recip As HtmlAnchor = TryCast(row.FindControl("recip"), HtmlAnchor)
Line 744: Response.Write(recip)
Line 745:
[Code]....
I'm currently running with this.
[Code]....
Works find on initial page load, but gives me "Object variable or With block variable not set."
on this like "ColourHex = e.Item.DataItem("ColourHex")" on postback?