Instead of binding my generic List, I would like to bind my LINQ collection instead. Only problem here is that the generic nature of the LINQ object means that DataSource cannot check and display the properties defined in MyDataStructure. How can I bind my LINQ query output to myRepeater?
I've got my repeater generating a list of links that need to appear in a certain order. Meaning I need my list to appear like so
-Item1 -Item4 -Item2 -Item5 -Item3
Every solution I've found involves knowing whats going to be in your list and setting classes where the list should break. My issue is that it could be anywhere from 1 to 18 items. So my question is, is there a good, simple way to vertically wrap a list that's being dynamically generated using an ASP.NET repeater control?
I've two SqlDataSources and two Repeaters, each repeater contains one hyperlink (i also tried using web server button and anchors). The hyperlinks fetch from the database some values and in the NavigationUrl property I use a string.Format method to create a parameterized url, to pass for the browser, then second repeater is populated according to the value passed in the url which is originally passed by the first repeater's hyperlink. this is my sample code : [URL]
I'm using a linq group by query (with two grouping parameters) and would like to use the resulting data in a nested repeater.
var dateGroups = from row in data.AsEnumerable() group row by new { StartDate = row["StartDate"], EndDate = row["EndDate"] }; "data" is a DataTable from an SqlDataAdapter-filled DataSet. "dateGroups" is used in the parent repeater, and I can access the group keys using Eval("key.StartDate") and Eval("key.EndDate").
Since dateGroups actually contains all the data rows grouped neatly by Start/End date, I'd like to access those rows to display the data in a child repeater. To what would I set the child repeater's DataSource? I have tried every expression in markup I could think of; I think the problem is that I'm trying to access an anonymous member (and I don't know how.) In case it doesn't turn out to be obvious, what would be the expression to access the elements in each iteration of the child repeater? Is there an expression that would let me set the DataSource in the markup, or will it have to be in the codebehind on some event in the parent repeater?
I've build a linq query.But i want a random selection so its not always ID : 1,2,3,4,5,6 How can i randomize this var? I like to bind it to a repeater.//TagCloud:
Random rand = new Random(); var tc1 = from i in JumpTide.cms.menu.GetMenuItems(32) select new
I am facing a big problem with simple linq query.. I am using EF 4.0..
I am trying to take all the records from a table using a linq query:
var result = context.tablename.select(x=>x);
This results in less rows than the normal sql query which is select * from tablename;
This table has more than 5 tables as child objects (foreign key relations: one to one and one to many etc)..
This result variable after executing that linq statement returns records with all child object values without doing a include statement.. I don't know is it a default behavior of EF 4.0 . I tried this statement in linqpad also..but there is no use... But interesting thing is if I do a join on the same table with another one table is working same is sql inner join and count is same..but I don't know why is it acting differently with that table only.. Is it doing inner joins with all child tables before returning the all records of that parent table?
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
I have a web app for our golf club. When I compute handicap index for each golfer, I have to select the most recent scores and then a subset of those scores depending on how many rounds of golf the golfer has played. All the scores are entered into a single SQL Express table called "Rounds". Verbally, this is what I'm trying to do:
1) select the twenty most recent golf scores (sort on date descending, "take(20)") [if less than 20 records, then select all available];
2) for this set of records, select the 10 lowest scores (or smaller number if golfer has less than 20 rounds);
3) compute the average round differential for the subset of records, etc. to calculate handicap index (this step is working ok...)
My current VB code has this LINQ query (which is flawed -- it selects the lowest handicap differential scores of ALL records for the filtered user):
[Code]....
How do I modify this query to accomplish items 1) & 2) above? It seems this should be simple, but my experience with queries is still limited.
List<string> EmailId= { ....} Now I have a db table Users. I need to select all users whose email exist in the above list. In sql we could write "where emailid in ('email1', email2' ,...)"
how to do this in linq to sqlquerable<Users> existingUsers = Users.getTable().where (u=>u.emailaddress in EmailId). I want to do some thing similar
I need to figure out how to express this in linq to sql:I have one or more records that contain what is essentially a wildcard sql parameter, like '100_-___-2', which should match 100[any 1 char]-[any 1 char][any 1 char][any 1 char]-2, for example. Each login will have one or more of these 'datamasks' associated with it.I need to write a query in linq to sql that does something like:
select * from something where fieldA = 'someValue' or fieldB = 'someValue'
so far, simple, but I also need to restrict the returned records to only those that match the user's 'datamasks'. I'm not sure exactly how to translate this to linq to sql... here is what a working query *without* the datamasks part looks like:
[Code]....
I need to tack on the datamasks part... can I do it right there in the same statement? or do I need to do a foreach loop on the datamasks records and append a new && condition for each one? hmmm... just thought of that as I was writing this.. I'll try that out. But I'm posting this anyway for more input... I guess that would look something like:
I actually need a little help here I'm using LINQ and displaying some data through a Repeater, with everything working fine. The scenario is: for example, user "Daniel" has 2 songs; on my Linqdatasource I'm selecting "songName" (name of the file name to put it on my mediaplayer, to populate the mediaurl) and the "plainName" (the name which the user inserted as the name of the song). So I'm just gathering 2 strings. My .aspx code:
[Code]....
I have a LINQ Table "Vote" (userID, songID, vote -> float)... and I want to rate each song (at the moment there are 2 songs... and the limit will be 3 per user), via the button "rateSong"... I'm not expecting you to give me the code to perform the specific rating, but how will I get to the specific button event? Is it in the Repeater1_ItemCommand?
[Code]....
I've searched for a few posts on this forum, but none of them helped
i my website i am using Repeater control which further contain checkboxlist control. Now my problem is that i have successfully bind "Parameter Type" in repeater control but when i am binding checkbox values, it does't appears in display
<asp:Repeater ID="Repeater1" runat="server"> <ItemTemplate> <h4> <%#Container.DataItem%></h4> <asp:CheckBoxList ID="chkParList" runat="server" RepeatDirection="Horizontal" DataTextField = > </asp:CheckBoxList> <br /><br /> </ItemTemplate> <SeparatorTemplate> <hr /> </SeparatorTemplate> </asp:Repeater> In *.cs file following are my code IMonitoringDataInfo objMonitoringDataInfo = new ChannelFactory<IMonitoringDataInfo>("MonitoringDataInfo").CreateChannel(); Collection<ParameterDetailDTO> clParameterDetailDTO = objMonitoringDataInfo.GetAllParameters(idList, out errorCode); var parameters = (from resx in clParameterDetailDTO select resx.ParameterType).Distinct(); Repeater1.DataSource = parameters.ToList(); Repeater1.DataBind(); counter = Repeater1.Items.Count; while (i < counter - 1) { foreach (var parType in parameters) { var items = from resx in clParameterDetailDTO where resx.ParameterType.ToLower().Contains(parType.ToLower()) select new { resx.ParameterName, resx.ParameterID }; ((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataSource = items; ((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataTextField = "ParameterName"; ((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataValueField = "ParameterID"; ((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataBind(); } i++; }
I need to use Union for below Linq queries. I could use Union it if it was simple "select new whith{" but Now that I Specified Class, I encounter Error using union
Table User (UserID, Username) Table Admin (AdminID, Username) Table PM (PMID, SenderID, Sendertype, RecipientID, RecipientType) Get all Information from PM if SenderType == 'A' join SenderID to Admin-Table, get Username if SenderType == 'U' join SenderID to User-Table, get Username if RecipientType == 'A' join RecipientID to Admin-Table, get Username if RecipientType == 'U' join RecipientID to User-Table, Get Username
I have a datakey that I'd like to query from my GridView instead of looping through all the rows and comparing the key of each row. So I was wondering if it was possible to just do a linq query on the gridview (not datatable) and filter with the datakey.
I need to filter LINQ query using comboboxes and textboxes. The problem is I can't manage to get the result and I always get the empty gridview (used for showing filtered data). Can anyone help me why am I getting no results at all? I've checked the debugger and the data sent to query is valid, although, I'm not sure about "string.Empty" value.
SELECT Sum(ABS([Minimum Installment])) AS SumOfMonthlyPayments FROM tblAccount INNER JOIN tblAccountOwner ON tblAccount.[Creditor Registry ID] = tblAccountOwner. [Creditor Registry ID] AND tblAccount.[Account No] = tblAccountOwner.[Account No] WHERE (tblAccountOwner.[Account Owner Registry ID] = 731752693037116688) AND (tblAccount.[Account Type] NOT IN ('CA00', 'CA01', 'CA03', 'CA04', 'CA02', 'PA00', 'PA01', 'PA02', 'PA03', 'PA04')) AND (DATEDIFF(mm, tblAccount.[State Change Date], GETDATE()) <= 4 OR tblAccount.[State Change Date] IS NULL) AND ((tblAccount.[Account Type] IN ('CL10','CL11','PL10','PL11')) OR CONTAINS(tblAccount.[Account Type], 'Mortgage')) AND (tblAccount.[Account Status ID] <> 999) [code]....
MGEntities db = new MGEntities(); [HttpPost] public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user MembershipCreateStatus createStatus = MembershipService.CreateUser(model.UserName, model.Password, model.Email); if (createStatus == MembershipCreateStatus.Success) { FormsService.SignIn(model.UserName, false /* createPersistentCookie */); MembershipUser myObject = Membership.GetUser(); Guid UserID = (Guid)myObject.ProviderUserKey; MyProfile profile = new MyProfile(); profile.Address = model.Address; profile.City = model.City; profile.Zip = model.Zip; profile.State = model.State; profile.UserId = UserID; Debug.Write(profile.State); db.aspnet_Profiles.Add(profile); return RedirectToAction("Index", "Home"); } else { ModelState.AddModelError("", AccountValidation.ErrorCodeToString(createStatus)); } }
This is my MyProfile Class:
namespace MatchGaming.Models { [Bind(Exclude = "ProfileId")] public class MyProfile { [Key] [ScaffoldColumn(false)] public int ProfileId { get; set; } public Guid UserId { get; set; } [DisplayName("Address")] public string Address { get; set; } [DisplayName("City")] public string City { get; set; } [DisplayName("Zip")] public string Zip { get; set; } [DisplayName("State")] public string State { get; set; } } }
After the linq query is executed, i check my database and nothing is added. I am using POCO for my entities. Here is my class:
namespace MatchGaming.Models { public class MGEntities : DbContext { public DbSet<MyProfile> aspnet_Profiles { get; set; } } }
SELECT COUNT(AdvisorID) AS AdvisorRegisterLast2Days FROM ob_Advisor WHERE CONVERT(varchar,CreationDate,101) BETWEEN CONVERT(varchar,DATEADD(day,-4,DATEADD(day,2,GETDATE())),101) AND CONVERT(varchar,GETDATE(),101)
