I have a drop down list (ddlFilterBuildings) which contains a list of buildings to choose from.I have an EntityDataSource and a Sub that triggers on QueryCreated. It is as follows:
Protected Sub EntityDataSource1_QueryCreated(sender As Object, e As QueryCreatedEventArgs)
Dim residents = e.Query.Cast(Of Resident)()
e.Query = From p In residents _
[code].....
Is it possible to change the data source of a dropdown list in a gridview from another dropdown list selected index changed method in the same gridview
View 2 RepliesAutopostback works but when one dropdownlist is selected the page refreshes. When the user select one dropdownlist, another dropdownlist will then populate if not its empty. After submitting the form, selecting dropdownlist will remove all the validation message. What i want to achieve is to have javascript to manually postback instead of using autopostback so that the validation message will still remain after selecting from dropdownlist but
View 1 RepliesI have a .NET4 web application using the Entity Framework
In one of my pages I have a gridview bound to an entity data source. Within the Gridview definition [code]...
I'm trying to grab the values that have changed using the GridView_RowUpdating event.
Here is my code:
Dim newValues As String = ""
Dim oldValues As String = ""
Dim i As Integer
Dim j As Integer
[Code] .....
Weird thing is, it seems to pull OldValues fine, but when I try to pull the NewValues I get an "Index was out of range." Checking around I see that this sometimes occur if you have non-BoundFields in your Gridview, but all of my fields are bound!
I have an ASP.net web page with VB code behind linking to an MS SQL DB. On the web page I have 4 DropDownLists and 1 GridView. Each DDL is populated with a SELECT DISTINCT query on 4 corresponding columns from 1 table in the DB. What I would like to be able to do is: when any of the DDLs have their selected item changed the other DDLs are updated. Crude example:
[Code]...
I have this simple code,
Protected Sub grdSearch_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles grdSearch.SelectedIndexChanged
TimeOff.Where = "UserName=""" & grdSearch.SelectedValue & """"
End Sub
Doing so causes this error, 'UserName' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly. Near simple identifier, line 6, column 1.
The datasource works fine before the where property is set.Update: I found the issue but I still don't get it.Adding it. in the where clause solves the issue. Like this,
TimeOff.Where = "it.UserName=""" & grdSearch.SelectedValue & """"
I am using an EntityDataSource with a FormView on VB.NET application. The FormView contains an AjaxControlToolKit TabContains with multiple tabs. Due to the fact that each tab is a naming container, Bind doesn't work properly for updating values (as discovered from reading other posts on stackoverflow). I instead have to declare UpdateParameters on my EntityDataSource.
Example markup is as follows:
<asp:FormView ID="fv" runat="server" DataSourceID="eds" DataKeyNames="ID">
<EditItemTemplate>
<asp:TabContainer ID="tc" runat="server">
<asp:TabPanel ID="tp" runat="server" HeaderText="Tab 1">
<ContentTemplate>
[Code].....
This works great, until a customer is edited and their name is set to nothing (assuming in this case, a null name is allowed). The Name UpdateParameter is set to Null but the ObjectStateEntry is not set to modified for Null properties, even if previously the Entity had a value specified. As long as the name is changed to something other than Null, everything is updated correctly. I found a workaround by putting the following code in the Updating event of the EntityDataSource.
Dim ose As ObjectStateEntry = context.ObjectStateManager.GetObjectStateEntry(action)
For Each p As Parameter In eds.UpdateParameters
ose.SetModifiedProperty(p.Name)
Next
This makes sure that each property in the UpdateParameters has its state set to modified. It works, but it seems like a hack and I can see it causing problems down the road. Is there anything else I could do?
