Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. mask in column of datagrid

mask in column of datagrid

Scheduled Pinned Locked Moved Visual Basic
csharpquestionlearning
6 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    B Offline
    Britnt7
    wrote on last edited by
    #1

    Is it possible to mask a column in a datagrid using VB.Net? I am getting either a 0 or a ten digit number. I would like to display the ten digit number as a phone number in the datagrid (ex:123-456-7899). Is this possible?:doh: Thanks in advance, Beginner in VB.Net

    D 1 Reply Last reply
    0
    • B Britnt7

      Is it possible to mask a column in a datagrid using VB.Net? I am getting either a 0 or a ten digit number. I would like to display the ten digit number as a phone number in the datagrid (ex:123-456-7899). Is this possible?:doh: Thanks in advance, Beginner in VB.Net

      D Offline
      D Offline
      Desi Bravo
      wrote on last edited by
      #2

      what do you mean by mask a column in database? As far that I know you create your own MS Access database before you use the VB.Net to generate a dataset. I believe that you can mask any column, if not all in the MS Access. I not sure what you really mean. Could you elaborate more about masking. bravo659

      B 1 Reply Last reply
      0
      • D Desi Bravo

        what do you mean by mask a column in database? As far that I know you create your own MS Access database before you use the VB.Net to generate a dataset. I believe that you can mask any column, if not all in the MS Access. I not sure what you really mean. Could you elaborate more about masking. bravo659

        B Offline
        B Offline
        Britnt7
        wrote on last edited by
        #3

        Well my MS Access database has one column that is NUMERIC and can only contain NUMERIC figures. For example, 5623659899 can't be 562-365-9899. There for I don't know how to take the 10 digit number and display it in a datagrid using the "-" to make it look like a telephone number. I'm not sure how to do this myself. If you want too, I can send you the project for you to look at. Just let me know. DataGrid1 should produce Last Phone Red 123-456-7895 instead of --->1234567895 Blue 456-895-5698 --->4568955698 Yellow 458-652-1452 --->4586521452 Green 562-123-0258 --->5621230258 Please let me know if you want me to send you the project or if you are still unclear as to what I am trying to do. Thanks,:) Beginner in VB.Net

        D 2 Replies Last reply
        0
        • B Britnt7

          Well my MS Access database has one column that is NUMERIC and can only contain NUMERIC figures. For example, 5623659899 can't be 562-365-9899. There for I don't know how to take the 10 digit number and display it in a datagrid using the "-" to make it look like a telephone number. I'm not sure how to do this myself. If you want too, I can send you the project for you to look at. Just let me know. DataGrid1 should produce Last Phone Red 123-456-7895 instead of --->1234567895 Blue 456-895-5698 --->4568955698 Yellow 458-652-1452 --->4586521452 Green 562-123-0258 --->5621230258 Please let me know if you want me to send you the project or if you are still unclear as to what I am trying to do. Thanks,:) Beginner in VB.Net

          D Offline
          D Offline
          Desi Bravo
          wrote on last edited by
          #4

          Yeah send me the application that you created and let me evaluate what you have done and I will tell you the next step to take to get the phone numbers with its format. bravo659

          1 Reply Last reply
          0
          • B Britnt7

            Well my MS Access database has one column that is NUMERIC and can only contain NUMERIC figures. For example, 5623659899 can't be 562-365-9899. There for I don't know how to take the 10 digit number and display it in a datagrid using the "-" to make it look like a telephone number. I'm not sure how to do this myself. If you want too, I can send you the project for you to look at. Just let me know. DataGrid1 should produce Last Phone Red 123-456-7895 instead of --->1234567895 Blue 456-895-5698 --->4568955698 Yellow 458-652-1452 --->4586521452 Green 562-123-0258 --->5621230258 Please let me know if you want me to send you the project or if you are still unclear as to what I am trying to do. Thanks,:) Beginner in VB.Net

            D Offline
            D Offline
            Desi Bravo
            wrote on last edited by
            #5

            Wondering if you already received my email with explanation in how to mask your application? bravo659

            B 1 Reply Last reply
            0
            • D Desi Bravo

              Wondering if you already received my email with explanation in how to mask your application? bravo659

              B Offline
              B Offline
              Britnt7
              wrote on last edited by
              #6

              Yes I did. I was able to use the imput mask in the access database and it worked when you opened access. When I pulled that column into a datagrid it didn't bring the mask with it. So it still displayed 1234567895 instead of 123-456-7895? Is there something special that I have to do in .Net to display the input mask as well?:doh: Thanks:cool: Tim

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups