I am using vb.net in a project and in one of my forms i added a datagridview(i am using Access database bytheway). In this datagridview i have 3 columns from the same data table(name, surname,telephone). My question is : "How can i give the telephone number in telephone(textbox) cell and view as result the name and surname in each of the cells? "
View 6 RepliesI want to format a textbox in my form for a phone number. I would like to have the () and - be shown in the box always even if nothing has been typed in, and when you type in the phone number, it is inserted in and ends up with the () and - in the right place.
View 3 RepliesI want VB.NET regular expression for below format 7966-591739 I mean user must have to enter 4 numeric characters first then "-" and then 6 numeric characters after that optional for numeric as well as for characters. In my case user can also enter
[Code]...
The system we have in place at work for call centre agents to input telephone numbers doesn't validate their input, so, in a lot of cases, we have junk data being entered (0000000000 as a phone number generally). I've been taked with fixing this, but I'm not sure how to stop the agents entering junk like this.
[Code]...
I am trying to make telephone number word generator, user enters phone number 7 digits between 2 to 9 and then it generates all possible word combinations,it should be 3 ^ 7 = 2187
View 8 RepliesUse the correspondence between digits and letters to develop seven-letter words that correspond to their phone numbers.- develop the seve-letter word that correspondsto exactly one seven-digit telephone number. Every seven-letter phone number corresponds to many different seven-letter combinations. Mostrepresent unrecognizablejuxatapositions of letters.Write an application that allows the user to enter a seven digit number in a textBox and diplays every possible seven-letterword combination corresponding to that number ina multiple line scrollable TextBox whenthe user clicks the Gernerate Words Button. There are 2,187 (3^7) such combinations. Avoid phone numbers with the digits 0 and 1.
View 14 RepliesWrite a Windows application that allows the user to enter a seven-letter combination corresponding to that number in a multiple line TextBox when the user clicks the Generate Words button. Avoid phone numbers with the digits 0 & 1. How to write a if or for loop to generate words.
Public Class Form1
Dim digits As Integer() = New Integer(6) {}
Dim letters As String(,) = New String(,) {{" ", " ", " "}, _
{" ", " ", " "}, {"A", "B", "C"}, {"D", "E", "F"}, _
{"G", "H", "I"}, {"J", "K", "L"}, {"M", "N", "O"}, _
{"P", "R", "S"}, {"T", "U", "V"}, {"W", "X", "Y"}}
[Code] .....
I have a problem in putting the telephone number using the datagridview. I have build 2 forms which is form1 and form2. In the form1 there are 2 textbox and a 'To' button whereas in the form2, there is a datagridview which display the telephones numbers and a button. When run the application, the user need to get the telephone numbers from the database so that is why when clicked on the 'To' button, it will go to the form2 which is the datagridview. After selecting the telephone numbers and click on the button at the form2, the telephone numbers will be display at the form1 first textbox. But the problem is that, I grab the telephone number which has been display in the form1 first textbox to the second textbox in the form1. I could not get the telephone numbers.
View 1 RepliesI need to do a check on telephone numbers entered into a textbox.I know the regular expression for an email address but not to check a telephone number like such (000)000-0000
View 1 RepliesI need to create a telephone directory with search option(textbox). I use sql db as backend and vb.net for frontend. In this the user must search for a particular name using the textbox and the results have to be displayed in the gridview. how to do this?
View 1 RepliesSo I'm passing a masked telephone number in the form of (999)999-9999 to a Function that 'strips' the numbers out and puts them into a string that I then use in an Update SQL statement. So far I have the code below that of course doesn't do anything:
Function StripPhone(ByVal sPhone as String) as String
Dim i as Integer
Dim sStripped as String
[code]....
I have a problem on getting both the names and the telephone numbers into the textbox.I have 2 textbox, a 'To' button and another button in the form1 while I have a datagridview which display the details of the customers and a button which for after selecting the selected details. When the application is run, I click on the 'To' button and it will link to the form2 which is the datagridview that display the details of the customers. After selected the details, it will click on the button on form2 and it will go to first textbox of the form1, it will display the telephone numbers. after that when I click on the other button, it will extract the string from the first textbox. But the problem is it get only the telephone numbers. why is that so? I want to get both the telephone numbers and names.
Here is the code in the form2:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load[CODE].....
It doesn't look like much is out there after searching but I was wondering if anyone has seen any vb.net projects to create a simple outgoing telephone dialer? Maybe something that can talk to a PC modem?
I'm not sure but was even wondering if this is something that can be done in a procedure? Doesn't look like there are any features that lend itself to it.
I thought also, I may do something with an RS232 stream and then use an external hardware dialer.....if I did that, I'm sure I could do the code in a Sub.
I want regular expression validator for my telephone field in VB.net. Telephone format should be (+)xx-(0)xxxx-xxxxxx ext xxxx (Optional) example my number would appear as 44-7966-591739 Screen would be formatted to show +44-(0)7966-591739 ext?
View 3 RepliesIs someone can give me an example in code making in searching for telephone numbers. Im just a begginer with just a little knowledge in coding. Any simple example that can give me hints on how to start a code in searching of telephone numbers.
View 1 RepliesI am working in excel trying to setup a function involving multiplying a cell by a set number and then having the result round to the nearest 10. Here's the beginning of my function statement fx=e3*1.026. say the result is 8654, I need it to round to 8650. Also if it comes back 8655, I need it to round to 8660. I have about 2,000 records I need to do this to so I was hoping that one formula or statement could be used for all my data.
View 2 RepliesI have set up text boxes for user to pick a number 1-20 and to enter a word as well. Then, press submit button. What's supposed to display in result textbox is the word that many number of times. For example if the number is 5 and the word is hello, then "hellohellohellohellohello" should appear. I don't know how to complete my For...Next function to append the word to the result.
Public Class Ch6ex1
Private Sub btnsubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsubmit.Click
[CODE].....................
In one grid each cell have childgrids and that child grid each cell contains 7 colmns and that 7 columns bind data from database but the cell spacing is not equal. [code]...
View 2 RepliesI have a VB.NET website and I am organizing some data in excel file. I need to merge cells which have same data in excel but everytime I try to this operation, program stops and shows this notification: I don't want to see it and I want program to continue without asking. Is it possible,
View 2 RepliesIm trying to colour cells in a datagrid depending on the value of the cell. Ive got a situation where I the 1st time the grid id displayed the coluring doesnt work, but then if I refresh the grid the colouring does work.
[Code]...
I have a form where a number of textboxes are programmatically created within a flowLayoutPanel and named by adding together 2 strings.
With the click of another button i hope to have all the values entered into these text boxes stored in a text file. However, i cant seem to find a way to add strings together to allow me to retrieve the values entered within the text boxes created.
Below is the code i have so far: BTW FLP is my flow layout panel and c is my calculated nmber of textboxes that are created.
Private Sub createTB(ByVal c As Integer)
Dim x1 As Integer = 1
Dim y As Integer = 2
[Code]....
How can we disable a cell of datagrid in vb.net and how to show date in datagrid cell in vb.net
View 3 Replies1. How can we disable the cells of a datagrid???2. How can we show date in a cell of datagrid???I have used this peace of code on for load event
View 6 RepliesI'm extracting data form a mysql using a huge query made up of three unions to searc on different tables for a telephone number. e.g. contacts, leads, etc.Iy workd perfectly in a sql tool and is well tested.When I run the query in visual studio, I get a result, two columns contaon the same image you get when a webpage image link is boken. These columns should contain a mobile phone number and an ID.Both are stored on mysql as varchars.No data is presented for these columns even though it exists with gaps
View 3 Repliesi wrote some code that is suppose to get the prime number from the user and give its factors but there's some error
Dim t As Double
Dim n As Double
Dim ans As Double
Dim exp1 As Double
[code].....
I was before knew how to code that it will give me a random number! Also i know it was 2 ways i could make it. A range from like 0 to 100 if i want that. And then it draws a random number from that! And i knew another there i could type in the numbers and it draws a random from there.
View 3 RepliesWith an excel file opened, i'm trying to:
Select a Range of Non-Contiguous Cells within a Column, then return the address of the last active cell.
Below, is what I have so far: Note the section maked:
' I can't get the next bit to work: '
To make it work, so far :(
1. Create a new Project using VS-2010.
2. By default, the form should be displayed as "Form1.vb".
3. Add a Label (No need to name or set anything).
4. Add two buttons (Again, No need to name or set anything).
5. Double click on the Form...
6. With the form code displayed, Select all, then paste the following.
'Option Strict Off
'Option Explicit On
Imports System.IO
[Code].....
i want to know that how can we add two cells of a datagrid view.I have 5 cells, quantity,rate,discount,tax and Total amount.I want to show the total amount in "Total Amount" cell.
View 3 RepliesHey everyone, i am in the process of making a replica deal or no deal game.It will have 20 cases, and have done half of the program i am up to programming the game stage I am a little confusd on how to make the program give a bank offer after x number of clicks?
View 8 RepliesI have a DataGridView with several columns. One column is a TextBox column named "Status". This column can only show one of three values: 'Final', 'Ready', or 'No Reportable'. I want to have some code that would turn the TextBox cell into a ComboBox cell when the user left-clicks on the cell to allow the user to choose one of these three options. When the user clicks elsewhere or the cell loses focus I want the cell to change back to a TextBox cell.
Here is what I have so far, but the code throws an exception indicated below Plus, I don't think the code would remove the combobox when the cell loses focus.
Exception: "Provided cell does not belong to this DataGridView control."
Private Sub dgvCalculatedResults_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles dgvCalculatedResults.MouseDown
Dim ht As DataGridView.HitTestInfo = Me.dgvCalculatedResults.HitTest(e.X, e.Y)
[Code].....