Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms help (VB.NET 2003)

    Can someone please point me to a tutorial or an article (or keywords) on setting up a multi-row display form in vb.net? Every time I try to find something, it's already upgraded to 2005 (thank you Microsoft), and doesn't apply to 2003. The only reference book I have is too old as the examples don't work (it was based on the first vb.net version).

    This is an example of what the users want to see:

    Partner PO Number PO Date.....Status(dropdown box))
    MMOUSE 111111 12/1/05 (open, released, shipped, backorder...)
    GOOFTP 222222 12/15/05
    ZAPHOD 122424 12/13/05
    ..............
    The data will be contained in a sql table (as soon as I redirect it) and after the user updates the status, the information needs to go to another table and/or needs to be loaded to a text file to be used for a transmission. Now I can do everything but set up the <img src=/w3timages/censored.gif alt=censored border=0> form.
    Carpy Diem, it&#39;s .

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Forms help (VB.NET 2003)

    What do you mean by multirow? If you want multiple records, use a datagrid and bind it to the dataset. If you just want multiple fields in the same record, you can bind the form to a dataset and then bind each control to a field in the dataset. If I didn't understand your question, please post back with more details.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Charlotte,

    I got the datagrid to work (dummy me!) but it needs to do more than just display the records. How do I restrict the fields so that the users can only update certain information and include a drop-down box? I'm looking for something similar to continuous forms in Access.
    Carpy Diem, it&#39;s .

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Forms help (VB.NET 2003)

    You will have to do that in code behind the form, addressing the properties of the datagrid there. I don't work with the datagrid because my company uses 3rd party controls which have much richer properties and methods, so maybe someone else can jump in on that question.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Peggy,

    Datagrids should do everything you need. You will need to spend some time researching the datagrid functionality in the helpfiles as well as on the internet. There are many sites that have tutorials on customizing the datagrid to function in the way you've described.

    Hope this helps!

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Mark,
    Sorry to be a pest, but I cannot get any of the datagrid examples to work after combing the .net. Do you have a "for instance" web site example that I could look at? I think I'm just missing one little thing, but I can't figure out what it is.

    I'm trying now to do an aspx form in VB.NET 2003. I can get the datagrid set up, get a drop-down box on the grid, reference the child table, but when I display the aspx form, it looks awful, ignoring my column set up and absolutely refusing to "play nice."
    Carpy Diem, it&#39;s .

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Are you having problems getting the data to bind or are you having formatting issues?

    If the former, don't forget to bind the data. If the later, there are a number of things that can be the cause.

    Here's an article from 4GuysFromRolla that should give you all you need and more!

  8. #8
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Mark,

    The article is helpful, and the Web site is good. I am new to .NET and am just starting to gather resources.

    Carla

  9. #9
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Mark,

    I was attempting to use the WebForms Datagrid thingie from the Toolbox, and pulling in the connections from the Server Explorer. The article series basically does the same thing (and a tad bit better) but it's like looking at the VBA code behind the Access form. I also have to show other people what I did so I was hoping the drag-n-drop version would work.

    Tthanks for the link! <img src=/S/joy.gif border=0 alt=joy width=23 height=23>
    Carpy Diem, it&#39;s .

  10. #10
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Hi Peggy,

    Unfortunately, when you step (or jump) into the world of ASP.NET, you're entering a world where drag-n-drop programming is more of a convenience than a complete solution. In ASP.NET, there will almost always be a need for writing code by hand, even in simple situations.

    However, don't worry - almost anything you need to accomplish has already been accomplished and documented by someone else out there. There are abundant resources on the web and print. You'll also find that the Object Browser, Intellisense, and built-in helpfiles are extremely helpful!

  11. #11
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Mark,

    Okay, so I went about halfway through the article series and then glombed upon a sample setup. Tweaking away, I was able to figure out what I did wrong so...

    Yippee! I did it! I finally got the stinkin' form to work! Now all I have to do is pretty it up and figure out how to give the form permission to update a database residing in another folder (guess I'll have to ask the sysadmin).

    Thanks soooooo much! <img src=/S/joy.gif border=0 alt=joy width=23 height=23>
    Carpy Diem, it&#39;s .

  12. #12
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms help (VB.NET 2003)

    Great, Peggy - thanks for the update. Glad you got it working!!

    If you're using an Access database, just be sure that the user account that the web folder is running under has write permissions to the folder where the Access database resides. If the directory is set to Anonymous in IIS, the anonymous user is defaulted to IUSR_<MachineName>. Otherwise, you'll need to check the setting to verify which user needs the permissions.

    If you're using SQL Server, the concepts are similar, but it's based on user accounts and not folder permissions.

    Good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •