.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

How to display Multiple TextBoxes ?

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :ASP.Net

Hi everyone,

How can I display a list of TextBoxes with values from the MS SQL Server 2008 database ?

The code below only display one TextBox, even there is 5 items in the database. How can I

make my code to display 5 TextBoxes with values ?

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">

  <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>    
    <script type="text/javascript">

        function getUrlVars() {
            var vars = [], hash;
            var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
            for (var i = 0; i < hashes.length; i++) {
                hash = hashes[i].split('=');
                vars[hash[0]] = hash[1];
            return vars;

        var CategoryId = getUrlVars()["CategoryId"];

        var Sotring = getUrlVars()["Sorting"];

        $(document).ready(function () {
            //$('.getUsers').click(function () {
                type: "POST",

                data: "{ CategoryId: '" + Cate

View Complete Post

More Related Resource Links

Autocomplete display multiple columns


 Hi --

I have an autocomplete extender working great returning one column and I can also retrieve multiple columns just fine from my stored procedure, but here's what I really need to do:

1. Format the data in the autocomplete extender in the following format:

Location Number
City, State, Zip

2. When the user makes a selection I want only the Location Number to populate the textbox.

I've looked quite a bit on this site and others on how to do #2 and I can't seem to find exactly how this should be done. Is there some javascript that needs to be involved in order accomplish this?

If anyone has done this I would really appreciate an example.




display products with textboxes

Hi I need to display a list of products 1 below each other with a textbox, i will also need a checkbox that will hold the prodID. so i was thinking i need to do a loop but i am not sure how to do it. It needs to be like this [checkbox(which will contain the prodID)]             prodName              Qty                               [textbox1]                        [textbox2]     so for each product in my products table i want to display it like above, now this is for a stock take module so the client will enter his values for each product in textbox1, when the client clicks the submit button, i will need to loop through the above products and calculate the difference if any so it will be (QTY - TEXTBOX1), if there is a difference the check the checkbox and display the difference in TEXTBOX2. so if the QTY = 10 and the client entered 8 in textbox1 then textbox2 should show you 2 and the checkbox should be checked. then the client will click the update button a

Display records in multiple columns in asp.net mvc

 Hello,i'm newbie to asp.net mvc. i use mvc 1.0 since my host supports that.i have a piece of code in my view like this and i want to change it in order to be able to show records in 4 columns.What should i do?<table>            <% foreach (var item in Model) { %>                     <tr>                                  <td>    <%=Html.ActionLink(item.CategoryName + "(" + item.NumberOfWebsitesInCategory + ")", "SubCategory", new { CatID = item.CategoryID }, new {style="text-decoration:none;" })%>                         </td>                    </tr>        <% } %>    </table>

how to display multiple calendar list data in single calendar view

Hi, Normally, we can used to extend the ListViewWebPart's ViewType property to display a particular calendar list items in Calendar View in our custom webpart. Is it any way to display multiple calendar list data in a single calendar view ?? or please provide some pointers related to this issue. Any help is much appreciated.    

Using a List View web part to display documents from multiple document libraries from different site

Hi there, I am trying to have one web part display documents (or list items) from different document libraries (or different lists) from different site collections. I have achieved this under a single site collection using Data View Web Part (using SPD). I have also achieved displaying a single document library (or a list) from a different site collection by using List View Web Part. but I am not sure how to get my head around displaying documents or list items from different document libraries or lists across site collections. I have thought of using SPSiteDataQuery or ListViewByQuery, but they all seem to focus one site collection at a time. If any of you have done this before, please share your best practice on this one with me. Much appreciated. Clark

How to return looped procedure results so that they display as multiple rows of a single output inst


I understand that the below fragment will return a separate 1-row results set for each successful loop (also unnecessarily repeating the column header each time). How can I alter my procedure so that each value returned by the loop is appended underneath the previous value as multiple rows of a single results set? Do I have to store each return value in a temp table or someother storage object? It would be nice to just be able to spit them out row by row as each loop returned. Possible? Easy? Hard? I really appreciate the help I've received here so far.

SELECT (whatever)

OPEN techCursor;
FETCH NEXT FROM techCursor INTO @techNumLoop;
EXECUTE pr_FindExpenses4Tech @techNumLoop, @itemCount OUTPUT
SELECT @itemCount Item_Count

How to add multiple textboxes at runtime and maintain them after postback?


I'm trying to make a form that could have one or multiple textboxes. I have a textbox and a button to add  additional textboxes. 

I have no problem adding a second textbox inside a panel but I want to be able to keep adding more textboxes every time the link button is clicked and later reference those boxes to be saved. I would also like to maintain the value of the textboxes there. They are not saved to the database until all the necesary texboxes have been added.

I added the textbox using:

private void button1_Click(Object sender, System.EventArgs e)

TextBox textbox1 = new TextBox();



that works fine, but when i click the button again it doesn't add an additional  textbox which is what i need.

any suggestions?

thank you

Validation for Multiple Textboxes



I have created a table with 50 textboxes , i would like to have a custom validator which validates all the textboxes with the same validation rule  in the table and displays an error message in the label. Please help me on this issue.

Thanks in Advance

empty multiple textboxes


i have 5-6 textboxes in a panel. i want to make all textboxes empty on a button click. what to do? 

Resolve AD names to Display names in SharepointDesigner Workflow emails for multiple user field



Is there a way I can resolve multiple users in a "People and Group" field to thier display name rather than Ad name in sharepoint when doing a designer workflow . The workflows job is send the mail to the business owners and request request that a certain permission be granted to User A, UserB, User C,...and so on.

SPD activities Linktitle action to my understanding only resolves a single user.





Display "allow multiple selection" column data as multiple items


I have a list that contains secretary assignments. There is only 2 columns. The secretary column is person/group lookup column and the attorneys column is also a person/group lookup column but "allow multiple selections". Here is a sample of item:

Secretary: Lisa White

Attorney: Joe Smith; John Fox; Michael Wrox.

I would like to create a view that display as

Attorney            Secretary

Joe Smith          Lisa White

John Fox           Lisa While

Michael Wrox    Lisa While

I know the out of box view will not let me do that . I just wonder if there is a work-around solution. Many thanks.


Display an SSRS Report in multiple (user's) regional settings



I have an SSRS Report that I've developed that returns date values. I have users that will access this report globally, and I would prefer that the report return these dates in the format tied to their regional settings.

I have set the RDL Language property to the expression =User!Language. this works on my local development environment.

Then I published to my ReportServer (MOSS 2007). Now no matter what regional settings my PC is tied to, both the report paramters and date format display in whatever Regional setting my SharePoint site is set to.

Is there a way that I can dynamically display the report using the User's regional settings?


How to display reports from multiple lists in SQL Server Reporting Services Report Viewer


Hi All,

  I want to generate report through SSRS from more than one sharepoint lists. To generate report from one list i am using below query:

   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
   <ElementPath IgnoreNamespaces="True">*</ElementPath>

Please suggest me a query to get results from more than one list like we use joins for SQL tables.

Thanks in advance,

Saurabh Kumar Singh

Mail: saurabhsinghmca@gmail.com

SSMS 2008 - Is there a better way to display/group tables in multiple scheams under single database


In SQL server 2008 we have 30 users schemas setup under a single database (say "UserDB")

Each user is set up with access to his/her own schema

So when you login to server and drill down to Databases >>UserDb >> Tables,  you will see the tables that belong to your schema


Now I have to give cross Schema access. User 1 wants to see User 2's schema tables.

User 1 tables shows up as user1.table1 and user 2 tables show up as user2.table2


Question is: Instead of listing ALL the tables, differentiated by prefix, is there a way to show them like windows folders.

InfoPath 2007 display date for multiple time zones



We have an InfoPath 2007 form integrated with SharePoint 2007 and uses Web Service as Data Sources. The end users are located in multiple time zones in US and Australia. The server is located in US Eastern time zone. We would like the form to display user's local date and time.

The return of web service shows correct local date and time, except the time zone keeps at -04:00. For example during the one hour after midnight Eastern Time, the web services return:

Eastern: 2011-04-13T00:04:03.793537-04:00

Central: 2011-04-12T23:04:15.5734594-04:00

Mountain: 2011-04-12T22:04:24.3693642-04:00

Eastern Australia: 2011-04-13T15:04:18.8366836-04:00

When I preview the form it shows correct date, but after uploading it to SharePoint and view in web browser, the date is off by one day (either ahead or behind).

My looked at this post http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/677c03e4-8d71-43b3-aff9-1b6662a2528a but I don't get how it display different dates in different timezones by using UTC.

How can I make sure the form ignores the server time or the time zone indicated in the web service return, and just display the date as it is?



Display / Show Multiple Web Parts


Currently i trying to do display / hide multiple web parts (content query) based on user click. I have created 5 content query, on default it will show only 1 web part and others web part will be "hidden". When user click another selection, it will show the correct web part information and hide others. I will really appreciate if anyone could give me the idea, guideline to perform this task.

Roughly i have an idea which is using getElementByID to control the webpart ID however i did not try it yet . I also go through below link however i still cant understand well how it works. Thank you.

Ref: Show/Hide Multiple Web Parts by Bryon Wyle



How to change default category for the Text Box Property NUMBER across multiple textboxes


I'm using SSRS R8 and have several reports with numerous NUMERIC textboxes.  The default NUMBER category that SSRS applies is "Default", which applies no formating to the number values shown in the textbox.  When the report executes, it displays these values with 4 decimal places (e.g. 123.1234).  The customer requires 2 decimal places (e.g. 123.12). 

This can be easily fixed by changing the category for the NUMBER Text Box Property from "Default" to "Number", with "Decimal Places" set to 2.

The trouble with doing it this way is that each report has over a hundred such textboxes (there are 15 such reports), and to change each textbox individually would be timeconsuming and error prone.  The intuitive way to do this would be to select multiple textboxes that I want to set the NUMBER category for, right click, select Text Box Properties, and set the NUMBER category accordingly.  However when I right click the multi-selected text boxes, I see the Text Box Properties option greyed out.

Is there a different way to do this?

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