.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Creating a form with an unknown number of rows

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :ASP.Net
Hi everyone, I'm pretty new at ASP .NET but not to ASP.  I've got a form I need to create where I don't know how many entries will be added.  It has the following format: "Age"             "Duration"      "Period of Duration"     "etc..." Last30Days 1-5 Months ago 6-11 Months ago Age Age Age etc. So the Age column always has the first 3 options and then an unknown number of Age values that can be inserted.  I've created a table that has the first four fields (Last30days, 1-5months, 6-11months, age)  and I was thinking I could just order by those 4 columns for display.  The problem I have is I'm not sure on how to proceed.  Does anyone have any good ideas on how to handle this situation?  Ideally data entry people could use the same form for both entering and displaying the data.  Thanks.

View Complete Post

More Related Resource Links

Help creating a unique form number in Infopath


I have read the other blog posts about this, and the other users seem to have some success, but I dont' understand HOW they got it to work.

This appears to be the solution, but its not working for me. It just seems to be giving me the time in HHMMSS when I do it: http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/a68b1129-deb3-41a9-a077-c3e8fc3ef86a/

I need to create a unique invoice number based on three parts: Salesperson's initials + date (represented as yymmdd) + a unique number (perhaps the time? but it has to be listed without any formatting, just HHMM)

Ultimately I want the form to have this number going ABYYMMDDHHMM 

Thanks so much

Restricting number of rows in a set

Hi All, Is it possible to restrict the number of rows which may come in a set in MDX ? WITH SET set1 AS Order ( { Filter ( [DimContract].[Contract Acc].[Contract Acc].MEMBERS , (NOT IsEmpty([Measures].[Consumption])) OR (NOT IsEmpty([Measures].[SampleSize])) ) } ,[Measures].[Consumption] ,ASC ) Say if i have a set like above , then can we restirct the number of contracts which may come in this set ?

Creating a "Save Button" in a browser based Form

I'm not sure if I'm missing something obvious, but I need to have the funtionality of the "Save Button", which is available and works on the tool bar, available in the form...and I can't seem figure out how to do it.I've found examples, in this forum, of how to use the "Submit Button" to act as the "Save Button", which did work for me, but only when specific basic criteria was met.The criteria that I now have is that I'm initiating a workflow to automatically start when a new item is created.  My workflow then moves the form to one of a few possible different form libraries, based on the logic in my workflow.  The different form libraries are to manage different teams of people that would have access to the Form and then that team would process the form accordingly.My specific situation: 1 - User opens a new form (works) 2 - User enters data and then submits the new form (works) 3 - Workflow is initiated and the form is moved to another form library to be worked on by a select group of people (works) 4 - The form is opened and reviewed and some changes are made to the form data by the select group of people (works) 5 - The form data in the form libary is updated (works, but only if the save button is pressed in the tool bar and then manually closes t

namespace of fields problem when creating form template from xml?

I created a form template from a predefined xml, where I do not have any namespace. Later I added more fields. The output xml of the form is for the fields from the xml they have not prefix, for those added later, they have prefix my. I already have them all done. How can I make them consistent to have prefix my? Is there any options in InfoPath to turn on or off the prefix my?   thanks,

ASP.NET Events and Pageload not firing when Datagrid containing large number of rows of data

Hi All, I have a datagrid in aspx page.Inside of datagrid i am using around 15 controls such as Button,dropdownlist and text box controls.Once the datagrid binds then the events in the aspx page not firing.Issue occured when the number of rowsgreater than 500.The number of rows less then its works fine.If anybody knows the solution please let me know."Platform i am working on ASP.NET1.1"Regards Hareesh

Creating a contact form in asp.net using vb.net (4.0)

I'm using MS VS 2010 and my controls have already been created on the aspx page. i just need a sample code to send  the email to my exchange server in VB.net side of things. thanks in advance.

GridView Pager not showing proper number of rows

I have created an out-of-the-box  (default everything) ASP.NET Dynamic Data Entities Web Site using VS2010, C# and the .NET Framework 4. Created an ADO.NET Entity Data Model based off a MS SQL 2008 R2 database and registered that EF data model for my dynamic data. Everything works great except for the one change I would like to make. By default, the GridViewPager.ascx file provides the values 5, 10, 15 and 20 in the dropdown for GridView's "Results per page" option. I would like to change that to 10, 20, 30 and 40 - with 40 being the default selected option. I went to the code behind file and modified it to have the values I am wanting. Those values now show in the dropdown, and work if I select them. Problem: when the page is first rendered only 10 rows will show. How can I change this? Any help would be greatly appreciated.   Thanks

pass number of rows of Gridview to a javascript function

using vb.net/asp.net 2005.I need to pass the number of rows of the Gridview to a javascript function does anyone know how to do this?  thanks

Creating views on a form does not allow Hyperlinks to be clicked.

I have successfully created an Info Path 2010 form which 5 views.  On each view it has a raft of information, on some of the views they are multiselect items to other sharepoint lists.  This is the basic make up of the form. The form is about Software Application information. Page 1 is General Information Page 2 Environment Page 3 Support This form is the form that opens for the SP list called Software Applications. When I open this list it shows the Software Application list as expected.  When I click on one of these applications it brings up the form mentioned.  The problem is, when the form loads it does not show the other views, so I am unable to change views.  If I am to change views I must first select EDIT and then the views are available.  The problems is when selecting the other views I can not select the hot links to the other items.  This is a major pain.  The only way I can see around this is only containing one view with the information broken up on one huge page. :(  Any ideas?

Max number of rows in a table

Hey I'm doing a bit of research on which database to use for a new project. And one of the factors I have to take into consideration, is that we will have some tables with a high amount of records. I originally intended to use mysql (because it's free), but I have found that it has a cap of 4.2 billion rows per table. And it is a possibility that we will exceed that number in a few of our tables. So far, from looking around here, and on the web, I've only be able to find, that is no such cap on tables in mssql, and that table sizes is only limited by available storage. The thing is, 99% of the info I found regarding tablesize limits in mysql, also stated that it was only limited by the storage size (4gb, not all available). I had to look very thouroughly to find that last 1% where someone mentioned the 4.2 bil. upper limit. I hope someone here can confirm that, there is indeed no limit on the number of records in a single table in mssql, no hidden cap, however unlikely to be an issue. I find, that there's a ton reasons to pick mssql over mysql. But this factor will be a big selling point, in convincing the higher-ups that mssql is the better choice for my project.

Drop DownList (Limit the number of rows)

Hi All, I have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.Please advise me on how to achieve this.Rg/-

Creating a Form say grid sort of a interface where in data values will be extracted from the table 4


how dis can be done help please with simple button click and changing the values it can be done but how to move columns with data in graceful manner the way we have in calendar control... 

creating new item in form library programmatically


Hi all,

I have a form library with infopath form published in it. I am trying to create a new item programmatically in it which will contain a instance of the published infopath form. But its suggesting me to use SPFileCollection.Add() for that.


Can anyone show me some light how I can meet my requirement?



how to generate a unique random number on a form submission?


I want to generate a unique random number everytime a user submits a form. As the form is submited the data of the form should be placed in a database and a unique random number should be generated so that the user can later use this unique random number to reterieve his details from the database that refer to his unique random id. The unique random number should be atleast 9 digits long. Please help me on this.

Problem with InfoPath 2007 Form opened with InfoPath 2010 - whole number integer not coming into dat


I found an issue when testing existing InfoPath 2007 forms via the Infopath 2010 Designer client.  Integer fields in the form template are publishing to a SharePoint Forms Library and show in the default view.  However, if that library is then used as a Data Connection in another or same form template those integer fields are not displaying or available for selection. 

This is not a problem using the InfoPath 2007 client.  It is not an option to convert the field to text as it could affect existing forms in existing libraries.  Also, existing integer fields are no longer appearing in previously defined SharePoint-based secondary data connections.  Only the ID field still appears.  But, those existing fields still work in the form and are selectable for functions, etc.

Is there a solution to this?

Thanks much!  Mike - www.ProgramNetInc.com


Restrict number of rows per page



As I deploy reports, based on the no of records in result set, I get a scroller on the right hand side. How can I disable the scroller? I guess I can disable the scroller by restricting the no of rows being displayed.. eg: show 10 records per page. Any idea how do I set no of rows per page?



Performance of a Stored procedure : Optimum number of rows to be handled in a batch


In a stored procedure is there anything called as optimum number of rows that need to be handled in a batch

as In, If there is a SP,

   that picks up data(via union operation) from various objects and puts them into a temp table after which the required data is moved to various tables,The above scenario is handled as a batch run where in 1 million rows are processed in a batch and the next 1 million rows in a next batch,so on and so forth.

   Is there any optimum number of rows that can be processed in the above case?

  When we increase rows processed per batch we have seen improvements in performance of the SP,but not sure when it will start deteriorating.




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend