Im trying to create LinqDataSource that will represent data from dynamically created String list and then use it as a datasource to my GridView.
List<string> users = RetreiveUsers();
LinqDataSource ds = new LinqDataSource();
I have a FormView bound to LinqDataSource, that is intended to allow editing of a single product's details, that is selected from a GridView. The LDS has a Where parameter set to point to the GridView control (i.e. a ControlParameter).
View 1 RepliesThis was a pretty disappointing moment - when databinding, using Eval("Contact.LastName") would work. It nicely evaluates the related Linq object's member LastName. If the "Contact" object is null, no error is thrown... instead the field is simply null.
However, the same does not hold for sorting - if there exists a null entry (this object does not have a Contact) then the LinqDataSource throws a NullReferenceException. This means that, if you ever have nulls on your foreign-key objects, you can't use sorting headers in the ListView.
This makes the feature moderately useless - I have to roll my own properties for every single field I'd ever want to sort on. That's insane.
Im using LinqDataSource like that:
<asp:LinqDataSource ID="LinqDataSource3" runat="server" OnSelecting="LinqDataSource3_OnSelecting">
</asp:LinqDataSource>
And I have ASPxGridView
<dxwgv:ASPxGridView ID="ASPxGridView2" ClientInstanceName="ASPxGridView2Client"
runat="server" AutoGenerateColumns="False"
DataSourceID="LinqDataSource3">
</dxwgv:ASPxGridView>
In this way Im able to add columns dynamically while handling onSelecting event:
protected void LinqDataSource3_OnSelecting(object sender, LinqDataSourceSelectEventArgs e)
{
MyModelDataContext context = new MyModelDataContext();
ASPxGridView grid = ASPxPageControl1.TabPages[3].FindControl("ASPxGridView2") as ASPxGridView;
if(grid.Columns.Count == 0){
GridViewDataTextColumn txtColumn1 = new GridViewDataTextColumn();
GridViewDataTextColumn txtColumn2 = new GridViewDataTextColumn();
txtColumn1.FieldName = "UserId";
txtColumn2.FieldName = "FirstName";
grid.Columns.Add(txtColumn1);
grid.Columns.Add(txtColumn2);
}
e.Result = from u in context.Users select new { UserId = u.UserId, FirstName = u.FirstName };
}
It is all made simply to test cause my idea is to have solution that makes it possible to use inqDataSource as a datasource for de ASPxGridView but join 2 or 3 tables and show results in this grid.
What I want to ask is if its good solution or is there any other better way to present some views made from couple of tables by join?
Second question is that I have Users and Group and I would like to have one table in which I would have two columns Name and Type For groups type would by group and for users type would be user. I dont have such a table in my database Is it possible to create specific class. Create List of objects of that class and fill it using linq query and the use it as linq data source for that grid ?
clas would be:
pseudocode:
Class MyClass {
string Type;
string Name;
}
or is there any other way to create such a table ?
AllowSorting="True" AutoGenerateColumns="False" DataSourceID="LinqDataSource1">
SortExpression="UserName" />
SortExpression="FullName" />
SortExpression="Email" />
SortExpression="LastLoginDate" DataFormatString="{0:dd MMMM yyyy}"/>
<asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="MyDataContextDataContext" onselecting="LinqDataSource_Selecting">
<WhereParameters>
<asp:Parameter Name="Subject" />
</WhereParameters>
</asp:LinqDataSource>
public void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
this.LinqDataSource1.WhereParameters["Subject"].DefaultValue = this.txtSubject.Text;
e.Result = reporterRepo.GetInquiries();
In my "selecting" statement I need to add two dynamic parameters when using the LinqDataSource's WhereParameters collection:
e.WhereParameters.Add(param, True)
However, the system adds these parameters as AND, but I want to perform an OR where either parameter 1 OR parameter 2 is true.
I have two drop down list on a page. The first one list projects and the second list users. The userlist is populated with an object datasourse that pulls a list of users for the selected Project.Whenever the Project list selection changes the second ddl Userlist always reverts to the first person in the list instead the person that was selected before a new Project was chosen.
View 1 RepliesHow to bound countries list using DropDown list in VB ASP.Net?
View 9 RepliesHow I can bind texbox to one property from linqdatasource?
I mean something like databinding contols in c# app
what is the easiest way to develop data driven page titles?
e.g. say a user is viewing a record called "Football" with an ID of 1 = then in the page title, the title "Football" would appear
As a workaround for the fact that asp:Checkboxes don't have values, I am attempting to dynamically create the ID's of checkboxes in a DataList so that it inserts the primary keys into the control ID. This is surprisingly difficult.
I have placed a PlaceHolder in my DataList ItemTemplate, then in the ItemCreated I create the checkboxes using string.Format("Checkbox{0}", DataBinder(e.Item.DataItem, "ID")). The problem is that this only works in a non-postback condition, as on postback the DataItem is null. And of course ItemDataBound isn't called on PostBack so that won't work either.
I can't seem to find a good way to handle this short of if (IsPostback) dataList.Bind(), which i don't think is a good way to do it.
Can anyone provide me with any alternatives here?
DLRepository is a class with method getDLandRules. I am binding the gridview with the list that is returned by method. Now I would like to iterate through the list and add 1 more column to each row that is returned. currently, I am getting an error
GridView1.Rows[row].Cells[7].Text 'GridView1.Rows[row].Cells[7]' threw an exception of type 'System.ArgumentOutOfRangeException' strin
I have a repeater that has an OnItemDataBound event on it. For some reason the repeater has three items being bound to it. But then I try the below it only writes '2' at the top of the page. The repeater itself does show the three items but this loop in the ondatabound event doesnt see the last item. Why?
protected void colourRepeater_ItemBound(object sender, RepeaterItemEventArgs e)
{
int count = 0;
foreach (RepeaterItem item in rptAssoicatedProducts.Items)
{
count++;
}
Response.Write(count.ToString());
}
how to use FilterExpression with an object datasource when it is bound using a selectmethod that returns a list of entity objects?
I get the following error when I attempt it.
The data source 'testODS' only supports filtering when the SelectMethod returns a DataSet or a DataTable
I have a databound FormView with a dropdown list of categories. All works as expected, but I want to provide the facility for the user to add a new category to the list and I can't find an elegant way to do it. My current approach is to have a simple modal popup (Ajax toolkit) with a FormView (bound to the Categories table). That successfully inserts the new row, but it doesn't show in the dropdown so it can't be selected. I can force a refresh by calling formview.DataBind() in a suitable event handler, but that of course moves the formview off the selected record and loses any changes the user may have made.
Is there a convenient way (perhaps using AJAX, avoiding a postback entirely) to update the Categories table and refresh the dropdown without moving off of the current FormView's record? I feel sure this
must be a frequent and basic requirement, but I've not found any mention of how to implement it.
[ASP.Net 4.0, by the way]
I have this grid view
[Code]....
The first page show up just fine, when i try to go to the second page of the GV i get this errorThe GridView 'GVCreditMemos' fired event PageIndexChanging which wasn't handled.
I have a generic list of a custom type. The custom type has a string and double.I'm binding the list to a gridview and it outputs everything fine.I'm trying to format the double column into a currency format. It is in a template field as I'm calculating a running total. I pass the value to a function that returns a double and adds the current value to a running total which I will show in the footer.
The format is not changing to currency as expected when using String.Format("{0:c}", GetTotal(Convert.ToDouble(Eval("Amount"))))
How can I bind a datalist control with a list of objects. I have a list of objects that contain a name, desc, and url for menu commands that I am trying to show in a DataList. I am getting the list from a WCF service so I have a list called something like menuList which consists of a List<MenuCommands>. I then do a menuDataList.DataSource = menuList and then a menuList.DataBind but nothing is happening. What am I missing here? I need to use a DataList because I need the commands to be selectable.
View 11 Repliesconsider the following scenario. I have 2 tables namely mtblExp and mtblRevenue. the tables are given below
mtblExp
Cost_Code month Expenditure
C001 April 2010 100
C002 May 2010 200
C003 June 2010 500
C001 July 2010 600
mtblRev
Cost_Code month Revenue
C002 Jan 2010 200
C001 April 2010 500
C005 July 2010 600
C002 Nov 2010 100
Now when a user select the month range from Jan 2010 to Nov 2010, a dropdown list should be bound with C001, C002, C003, C005.Can anyone sugest an Sql query for this..the query that i am using is given below
[Code]....
this is working...but i am not sure if this is the right way.
I've tried to wrap up my problem with a complete example below - the original problem is part of a jQuery plug-in that I'm writing to extend the behaviour of an ASP.NET ajax application I already have.
The aspx page below has one drop down list which is marked for auto post back. I've also bound a change event using jquery (which ultimately I will swap for a .live() event to maintain the binding after the update panel refresh.) The problem is, when the jQuery event is bound I see two ajax begin requests and page_loads fire but only one ddlTest_OnselectedIndexChanged event. One of the page loads is malformed too - the content-length states it's about 300 bytes long whilst the totalBytes is 0 and form data empty. This does not happen if I bind to the click event of a button.
why the erroneous page_load event is firing ?
[code]....
how to make Dynamic Scrolling list in asp.net ? i have a text file that contain sentences, and i want to show those sentences in dynamic scrolling list in my webform (like news)
View 1 RepliesI am new to using Ajax Control toolkit. I need to create a dynamic cascading dropdowns in which the no of dropdowns will be programatically decided. Also the last dropdown can be replaced with a listbox as well. how i can leverage the Ajax toolkit's cascading dropdown.
View 2 RepliesI want to create a drop down menu in ASP.NET such as this website [URL] when I click on the button or the object I get other links to other pages that I specify by myself. Can anyone show us steps or guide me?
View 1 Repliesi am working on a dynamic tree menu with nested <ul><li>-Lists.
when building the nested list every <li> element should contain a <div> with a small icon and a css-style behind.
here is my code:
[Code]....
this way the result in the browser shows the name of every "aNavItem" but there are no icons. if i put the line to set the inner text of the div BEFORE adding the "imgMove" to it both things are shown - the name of the element and on the right the icon
the problem is that i want the icon to be on the left and then the text, but there is no icon at all with the code above (it looks like the setting of the inner text overwrites the already added image-control in the div-tag)
Im creating a checkbox dynamically like so:
[Code]....
How can I add an onclick attribute to a particular list item?