I have a question on Scott's article about binding scalar values to data controls: [URL]
On the seconde example (the one using templates), how would I access the scalar value in the controls OnItemDataBound event? e.Item.DataItem seems to be null....
i have two tables in my database, product(productid as pk) and productdetails(productid as fk), in a relationship.i have dropdownlist which on pageload displays data from my product table, showing all product name. AutoPostBack enabled. Its working fine.i have a gridview which should display the productdetails data when i select a value from my dropdown list.i have written the code for the gridview on the selected_index_change event of the drop down list, please correct me this is wrong;here is the code;
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles
DropDownList1.SelectedIndexChanged
Dim ConString As String [code]...
so when i select the value in the dropdownlist i get this error .Must declare the scalar variable "@ProductID".
I have 3 nested repeaters for a dropdown js menu.
<asp:Repeater ID="Repeater1" OnItemDataBound="rpaltmenu" runat="server">
<ItemTemplate>
<li>
<a href="<%--<%#"sirt.aspx?anamenuid="+Eval("menuid") %>--%>"><div align="center"><img border="0" src="<%#Eval("ikon") %>"><br /><%#Eval("menuadi").ToString() %></div></a>
<ul>......
code is ok but works only one time and my last menu items are being loaded only for one time.The first items are ok but after that it is not working.
I have added a event for my datalist present inside a update panel as
[Code]....
When the UpdatePanel is updated for the first time, the function 'DataList1_ItemDataBound' is called.But, when the updatepanel is refreshed for the second time, the debugger doesn't reach the same event at all. thus keeping all the data inside the datalist same.
I have a master page with a user control consisting of a repeater with a SiteMapDataSource. However when doing a post back on a page using the master page, the onitemdatabound event of the repeater in the user control does not fire.
[Code]....
I try to show three image with title through Datalist control. i got all images from database and i binded with datalist control.
below is my aspx design. i need to check the image option wether it is 1 or 2. if imgoption is equals 1 then i need to Resize the im1 width to 450 and also want hide img2 and img3.
is it possible to resize img through itemdatabound.
[Code]....
I have a problem with my first ASP.NET webpage. Im using ASP.NET 3.5 with VisualStudio 2008 and LINQ to SQL.
To easier communication we take a example from northwind data base. I want to list all the Orders and for each order I want to list all its OrderDetails. I have created a listview (lvOrders) with a LinqDataSource (Order table). Now I have create a new nested listview, for the order details, but I dont know how to load the orderdetails in this nested listview. I have tried to load the orderdetails in the OnItemDataBound of the first listview (lvOrders), but I miss functionatilly like DELETE command on the nested listview (to delete a orderdetail) This is my code:
[Code]....
On code behind:
[Code]....
Im thinking on some like a unique linqdatasource, returning a new Order entity (modified) with one field that is a list of orderdetails... this would work?
[Code]...
This is my Repeater with event OnItemDataBound to resize image.Actually, sub resizeimage is get image url from Label "Imgurl" to get width and height of image. Then set new width and height to asp:Image "Img" to make a thumbnail.
Its work fine with localhost in IE8 but when i upload to hostserver and it popup an error:Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
Timestamp: Thu, 8 Apr 2010 11:15:01 UTC
[code]...
I read some site to get some solution but only i get is put the script inside html tag to avoid this error.
I need to modify the value of results returned by a Objectdatasource, before binding to the GridView.
More specifically, I need to use Page.ResolveClientUrl() before binding the
RelativePath to the Img Tag-
<ItemTemplate>
<img src='<%#Eval("RelativePath") %>' width="100" height="100" alt='<%#Eval("Name")%>' />
</ItemTemplate>
I have a repeater control populated with data binding expressions like in the expression below...
[Code]....
I want to be able to redirect a user to default link if the LinkURL value is empty, that is for each data item, there will be a check if the LinkURL field contains a value. If not, a default value will be supplied.
I have a grid which is binding to a objectdatasource and when it is in edit mode, i am displaying a form template and wanted to bind all the values. I have one field called ApprovedCode. In the edit mode, i am displaying all the codes drop down list box and making a bind on the selectedvalue and i dont know how to handle when it is empty. When it is empty i wanted to display "Select..."
I followed this forum post but i am getting error
[URL]
This is my code
[Code]....
This is the error message that i am receiving
"ddlApprCode' has a selectedvalue which is invalid because it does not exist in the list of items
I add one or more textbox controls to a repeater itemtemplate during OnItemDataBound.
The textbox controls are instantiated and then added to a placeholder.
My problem is getting the user entered values from those dynamically added textboxes. They do not seem to exist in the repeater items collection.
[Code]....
[Code]....
I want to dynamically bind dataset values into datagrid's header datafield.
Is it possible? To be more clear, when you click on datagrid's (Collection) from properties window, you get selected columns created from Bound column. So in those columns I want to dynamically display dataset's table values in those columns.
i.e like ds.Tables[0].Rows[0][0].
Is it possible to do it in Datagrid ItemDataBound function like,
e.Item.Cells[1].Text = ds.Tables[0].Rows[0][0]
or something like this? I know the above code is wrong and wont work since I tried it out and while building it throwed error saying, Cannot implicitly convert type 'object' to 'string'.
[Code]....
here the method OnItemDataBound , look at how it work
[Code]....
problem is the e.Item always get one and only one last item . turn out my listview display many rows but with a consistent content of the last user (in the database record) . How can i resolve this ?? any creative method are accepted , i'm just want to finish this project
I am trying to bind upto 3 values to a HyperLink control in a DetailView control to create a query string but it does not seem to work.
Following is my code for the HyperLink:
[Code]....
The parameters UserName, FirstName and LastName are column names from the sqldatasource.
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
I am getting int values from the stored procedure. But when i bind this datasource with the gridview i am seeing the values being converted into float. i am using Text='<% # Bind("Quantity") %' I wanna that to be displayed as int, with out zero'seg: let the value be 233, when i bind that its getting displayed as 233.00
View 1 RepliesI have a classic ObjectDataSource and a ListView in my page. The List view just displays some data and when switched to edit template it allows the user to change the values. I want the user to edit just some values -- so I bind just these ones in the edit template.
The problem is that the other values suddenly turn to nulls or 0. I tried to bind all of the values at once and it works fine, but I cannot understand why the old/original values just disappear. Is there any way how to bind the old values?
I am trying to bind datetimes from a database to a Calendar in a TemplateField in a GridView using C# (following the tutorial at [URL]). The datetime is nullable in the database and this apparently kills the Calendar (one entry is null). How do you modify the SelectedDate and VisibleDate to check for null values? Do you have to create a custom binding? If so, how?
View 5 Repliesi am calling a scalar function from a stored procedure. Does using user defined scalar finction has a negative impact on performance.
View 1 RepliesI have a repeater that I have bound to a sql reader via my code behind page.
However I can't figure out how to populate the controls in my repeater in my code behind code.
At the moment I am having to specify the database field e.g productprice with the control in the .aspx page like this
<asp:Label ID="LabelUnitPrice" runat="server" Text='<%# Eval("productprice") %>'></asp:Label>
I would rather specify fields in my code behind than embedding them in the .aspx page.
I also have a subtotal label control in my repeater that I would like to populate its text property by mutiplying two of the database values e.g productprice * unitprice shown in my repeater.
I need to do this in code behind, looping through the repeater. Any idea of how I can do this in C#?
I am using Asp.net 3.5 listview control. In item_updating event I am using this code...
dim country as string = Dim country As String = e.NewValues("country_name").ToString.Replace(" ", "")
It's updating record correctly. for example if I update USA to USA 1 1 then it's updating like as it. But I want it to be USA11
I can't figure out whats wrong with my contact page. I am getting this error when executing. It complied fine, I see the page as it suppose to. Then I enter all my contact information and click submit I am getting this error. Can someone guide me. Here is the error msg
must declare the scalar variable @txtSubject Here is the part of relevant code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim ContactDataSource As New SqlDataSource()
ContactDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString1").ToString()
ContactDataSource.InsertCommandType = SqlDataSourceCommandType.Text
ContactDataSource.InsertCommand = "INSERT INTO Enquery (EnqSubject,EnqFirstname, EnqLastname,EnqContactNumber,EnqEmail,EnqMsg,EnqDateTimeStamp,EnqIPAddress) values (@txtSubject, @txtFirstname, @txtLastname,@txtPhone,@txtEmail,@txtMsg, @txtDateTimeStamp,@txtIpAddress)"
[Code]....
I'm getting "Must declare the scalar variable "@ShowTypes"." when I try to run the code below.
[Code]....
I am using VS 2005.I have 5 tables depending on their values ,I need to draw a bar chart.
View 1 Replies