I have a simple VB.NET 2008 app that users to edit fields in the database. Simple enough as a first "real" project in .NET, right?For one table, I am currently using a DataGridView so it can be edited straight up. However, instead of offering the user the entire table, I'd like to group the data by the 'CompanyNumber' column and use a navigator to page through. In other words, I'd like the DataGridView to show me all the lines related to one company, then click the "next" arrow to show the next company, etc.
Given a simple DTO (AccountExpiry) with properties of 'AccountNo' and 'ExpiryDate' and a List of same created thus: New AccountExpiry(123, New Date(2012, 4, 1)) New AccountExpiry(123, New Date(2012, 4, 2)) New AccountExpiry(123, New Date(2012, 4, 3)) New AccountExpiry(124, New Date(2012, 4, 2)) New AccountExpiry(124, New Date(2012, 4, 3)) New AccountExpiry(124, New Date(2012, 4, 4))
How do I use LINQ to retrieve the most recent entry per account. I have a feeling this will involve GroupBy and FirstOrDefault. It seems like... From Item In Source Group By Item.AccountNo Into Group Should return all of the data grouped appropriately, but It is unclear how I might apply .FirstOrDefault to each group.
I need to post some xml data to a different aspx page and redirect to the same page.I tried the following code it does post to the page sucessfully but i need to redirect to the same page with posted data
I am creating a notes software. This is just a simple application that will show the data from the database which are Notes_Title, Due_Date, Priority. I display the data with datagridview. I also added a checkbox for each row to the datagridview to mark as check if the Notes_title is already done. In displaying the data, I need to display only a 5 data in a row.So, I create a another CLASS that will only show 5 rows per page. But the PROBLEM is, if I mark the checkbox as check in the first page then if I turn it to the next page the checkbox in the first page that mark as check will be uncheck if I turn it back to the first page. The mark check in the checkbox will mark as uncheck if I turn the page. How can I make it mark as check even if I turn the pages? And How can I save the data row as done if I check
I have more than 30,000 rows in a table. It takes a lot of time to load all the data in the gridview. So I want to display 100 rows at a time. When I click next page button, another 100 rows should be displayed. When I click previous page button, previous 100 rows should be displayed. If I type page 5 in a text box, then I want to jump over to the 5th lot of rows.
I also want to display how many pages there will be. Can we implement this concept in vb.net [winform] gridview. I am using database PostgreSQL.
For some reason when the user click on the submit button and he re-fresh the page the same data get's uploaded again to my SQL Server 2005 database. I do not what this to happen... I am making use of a SQL Data Source!
My code
Try 'See if user typed the correct code. If Me.txtSecurity.Text = Session("Captcha") Then
I have a list of postcodes in a query (ThisInstructorsPostcodes) and another query that pulls back sales referrals (LastWeeksReferrals)I am using the below syntax to perform the linq equivalent of LEFT OUTER JOIN so I always get a postcode back, even if there were no referrals for it.
dim final = from tip in ThisInstructorsPostcodes _ group join lwr in LastWeeksReferrals on tip.PostcodeID equals lwr.PostcodeID Into lwrgrp = group _ from lwrgrpq in lwrgrp.DefaultIfEmpty _[code].....
The results I am getting are so close to what I need, but I am getting a bunch of InstructorReferrals objects in the lwrgrpq column and what I want to do is simple sum of the all the 'Referrals' integers in those InstructorReferrals objects.I thought this would work:
dim final = from tip in ThisInstructorsPostcodes _ group join lwr in LastWeeksReferrals on tip.PostcodeID equals lwr.PostcodeID Into lwrgrp = group _ from lwrgrpq in lwrgrp.DefaultIfEmpty _ select new with {tip.AreaDistrict, lwrgrpq.Sum(function(x) x.Referrals) }
...but it doesn't - fails with the error: Anonymous type member name can be inferred only from a simple or qualified name with no arguments.I have only used this linq query structure in order to mimic the outer join behaviour of sql, does anyone know how I can fix this so that my grouped items are not anonymous types?
I'm having trouble with a LINQ to SQL query getting the min value using Visual Basic. Here's the SQL:
SELECT RC.AssetID, MIN(RC.RecCode) AS RecCode, JA.EngineerNote from JobAssetRecCode RC JOIN JobAssets JA ON JA.AssetID = RC.AssetID AND JA.JobID = RC.JobID WHERE RC.InspState = 2 AND RC.RecCode > 0
I'm trying to create a program that displays a calculation based on which radio buttons a user clicks on. I'm not getting any errors during writing or run-time, however only one particular calculation ever gets displayed. I'm not sure why, but it's as if I've gotten the program stuck on the section below. The Calories Label only displays the number 12 regardless of anything else being enabled.
Dim Rooms As New Dictionary(Of Integer, Of Integer) Rooms(1) = 101, 102, 109, 110 Rooms(2) = 103, 104, 105 Rooms(3) = 106, 107
I want to know if i can obtain how many keys are in the dictionary For example, in this dictionary i have 3 keys, and if i use Rooms.Count it returns me 9 thats each pair of keys-values, but i want to obtain 3, each diferent value as key.
EDIT: Sintax error P.D: I cant use now because i have to use in a webservice filtered by IP, but VS2010 if i use count on the dictionary, tells me that will contain the number of the keys/value pairs.
I have this dictionary.. Dim Rooms As New Dictionary(Of Integer, Of Integer) Rooms(1) = 101, 102, 109, 110 Rooms(2) = 103, 104, 105 Rooms(3) = 106, 107
I want to know if I can obtain how many keys are in the dictionary. For example, in this dictionary i have 3 keys, and if I use Rooms.Count it returns me 9 that's each pair of keys-values, but I want to obtain 3, each different value as key. Syntax error. I cant use now because I have to use in a webservice filtered by IP, but VS2010 if I use count on the dictionary, tells me that will contain the number of the keys/value pairs.
I have 2 tables Markers and Clients. Within the Marketers table i have Team Leaders as well. I want to print a report that will display a Team Leader and the Marketer with all the Clients for that particular Marketer, and then do that for all the Marketers under that Team Leader.
I'm trying to do the following LINQ grouping, which works in the debugger (the results are populated in the GroupedOrders object. But VS 2008 gives me the following error at design time...
Name 'x' is not declared Dim GroupedOrders = (From m In thisConsultant.orders _ Group m By Key = m.commCode Into Group _
I found out how to keep track of the currently expanded grouped rows by using 2 events: - gridview.GroupRowExpanded - gridview.GroupRowCollapsed
Where I increase or decrement an integer that keeps track of how many group rows are currently expanded. I am now tackling the problem of what to do if the user expands or collapses all of the group rows. I currently know when this is done by checking the e.RowHandle. Any way to find the total number of groups rows currently in the GridView (something like rowcount for normal rows) so I know how many to set the tracking integer to.
For Example: If my current count is 2 and the total number of groups are 15 then when the Expand All is fired the current count is set to 15 rather than 3.
i have a Janus grid, which has two columns and the rows are organized in a hierarchical order i.e. parent and child rows. One of the columns in the grid is grouped (by dragging the column in the group by box above the grid). I have a cell-changed event that is fired when a cell content is changed. I do this in the cell-changed event:[code]If i change the value, in a parent row, of the grouped column then the child rows are set to Nothing. After the last line in the above snippet, child rows of row are set to Nothing. On the other hand, this problem does not occur if i change the value of the other column (which is not in the group by box). The problem occurs only if i group a column and change its value not otherwise.
What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
How to move to next page in datagridview.I have n number of pages.I enabled autopaging.Its showing ">" link.But when i am clicking it is not moving to next page.My grid is inside a update panel..
Suppose I have 40 datagirdview rows. I want to print 10 rows pr page example 10 rows 1st page 10 rows 2nd page 10 rows third page and 10 rows 4th page. How can I print and where I can put the code
Imports System.Data.SqlClient Imports System.Data Imports System.Collections.Generic Public Class PrintDGV Private Shared StrFormat As StringFormat ' Holds content of a TextBox Cell to write by DrawString [Code] .....
I wrote a page Page method in my aspx page. in web service method I need to call FindControl method return textbox and get text box value. But my findControl will take MasterPage object to iterate.
see my code
<script type = "text/javascript"> function ShowCurrentDateTime() { $.ajax({
[Code]....
How to pass Master Page object or Page to Page method?. So I can use in Sared method.
Is there any way I can access Textbox value directly in Page method? I need access couple of controls in Page Method.
HOW TO RUN THE JAVASCRIPT FUNCTION ON PAGE ONLOAD EVENT IN CONTENT PAGE OF MASTER PAGE.? means i have masterpage and the content page of master page namely default.aspx in vb.net.i wanna run javascript function in Default.aspx and i have called the function body onload in master page.when i run my website it shows the error "" Microsoft JScript Runtime Error : Object Expected ""