방법: MaskedTextBox 컨트롤에 데이터 바인딩

아티클
05/04/2023

다른 Windows Forms 컨트롤에 바인딩하는 것처럼 MaskedTextBox 컨트롤에 데이터를 바인딩할 수 있습니다. 그러나 데이터베이스의 데이터 형식이 마스크 정의에서 요구되는 형식과 일치하지 않는 경우 데이터를 다시 포맷해야 합니다. 다음 프로시저에서는 Binding 클래스의 Format 및 Parse 이벤트를 사용하여 개별 전화번호와 내선번호 데이터베이스 필드를 단일 편집 가능한 필드로 표시하여 이를 수행하는 방법을 보여 줍니다.

다음 프로시저에서는 Northwind 샘플 데이터베이스가 설치된 SQL Server 데이터베이스에 액세스할 수 있어야 합니다.

MaskedTextBox 컨트롤에 데이터를 바인딩하려면

새 Windows Forms 프로젝트를 만듭니다.
두 개의 TextBox 컨트롤을 양식으로 끌어다 놓고 이름을 FirstName 및 LastName으로 지정합니다.
MaskedTextBox 컨트롤을 양식으로 끌어다 놓고 이름을 PhoneMask로 지정합니다.
PhoneMask의 Mask 속성을 (000) 000-0000 x9999로 설정합니다.

양식에 다음 네임스페이스 가져오기를 추가합니다.

using System.Data.SqlClient;

Imports System.Data.SqlClient

양식을 마우스 오른쪽 단추로 클릭하고 코드 보기를 선택합니다. 양식 클래스의 아무 곳에나 이 코드를 배치합니다.

Binding currentBinding, phoneBinding;  
DataSet employeesTable = new DataSet();  
SqlConnection sc;  
SqlDataAdapter dataConnect;  

private void Form1_Load(object sender, EventArgs e)  
{  
    DoMaskBinding();  
}  

private void DoMaskBinding()  
{  
    try  
    {  
        sc = new SqlConnection("Data Source=CLIENTUE;Initial Catalog=NORTHWIND;Integrated Security=SSPI");  
        sc.Open();  
    }  
    catch (Exception ex)  
    {  
        MessageBox.Show(ex.Message);  
        return;  
    }  

    dataConnect = new SqlDataAdapter("SELECT * FROM Employees", sc);  
    dataConnect.Fill(employeesTable, "Employees");  

    // Now bind MaskedTextBox to appropriate field. Note that we must create the Binding objects  
    // before adding them to the control - otherwise, we won't get a Format event on the
    // initial load.
    try  
    {  
        currentBinding = new Binding("Text", employeesTable, "Employees.FirstName");  
        firstName.DataBindings.Add(currentBinding);  

        currentBinding = new Binding("Text", employeesTable, "Employees.LastName");  
        lastName.DataBindings.Add(currentBinding);  

        phoneBinding =new Binding("Text", employeesTable, "Employees.HomePhone");  
        // We must add the event handlers before we bind, or the Format event will not get called  
        // for the first record.  
        phoneBinding.Format += new ConvertEventHandler(phoneBinding_Format);  
        phoneBinding.Parse += new ConvertEventHandler(phoneBinding_Parse);  
        phoneMask.DataBindings.Add(phoneBinding);  
    }  
    catch (Exception ex)  
    {  
        MessageBox.Show(ex.Message);  
        return;  
    }  
}

Dim WithEvents CurrentBinding, PhoneBinding As Binding  
Dim EmployeesTable As New DataSet()  
Dim sc As SqlConnection  
Dim DataConnect As SqlDataAdapter  

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load  
    DoMaskedBinding()  
End Sub  

Private Sub DoMaskedBinding()  
    Try  
        sc = New SqlConnection("Data Source=SERVERNAME;Initial Catalog=NORTHWIND;Integrated Security=SSPI")  
        sc.Open()  
    Catch ex As Exception  
        MessageBox.Show(ex.Message)  
        Exit Sub  
    End Try  

    DataConnect = New SqlDataAdapter("SELECT * FROM Employees", sc)  
    DataConnect.Fill(EmployeesTable, "Employees")  

    ' Now bind MaskedTextBox to appropriate field. Note that we must create the Binding objects  
    ' before adding them to the control - otherwise, we won't get a Format event on the
    ' initial load.  
    Try  
        CurrentBinding = New Binding("Text", EmployeesTable, "Employees.FirstName")  
        firstName.DataBindings.Add(CurrentBinding)  
        CurrentBinding = New Binding("Text", EmployeesTable, "Employees.LastName")  
        lastName.DataBindings.Add(CurrentBinding)  
        PhoneBinding = New Binding("Text", EmployeesTable, "Employees.HomePhone")  
        PhoneMask.DataBindings.Add(PhoneBinding)  
    Catch ex As Exception  
        MessageBox.Show(ex.Message)  
        Application.Exit()  
    End Try  
End Sub

Format 및 Parse 이벤트에 대한 이벤트 처리기를 추가하여 PhoneNumber 및 Extension 필드를 결합하고, 바운딩된 DataSet에서 구분합니다.

private void phoneBinding_Format(Object sender, ConvertEventArgs e)  
{  
    String ext;  

    DataRowView currentRow = (DataRowView)BindingContext[employeesTable, "Employees"].Current;  
    if (currentRow["Extension"] == null)
    {  
        ext = "";  
    } else
    {  
        ext = currentRow["Extension"].ToString();  
    }  

    e.Value = e.Value.ToString().Trim() + " x" + ext;  
}  

private void phoneBinding_Parse(Object sender, ConvertEventArgs e)  
{  
    String phoneNumberAndExt = e.Value.ToString();  

    int extIndex = phoneNumberAndExt.IndexOf("x");  
    String ext = phoneNumberAndExt.Substring(extIndex).Trim();  
    String phoneNumber = phoneNumberAndExt.Substring(0, extIndex).Trim();  

    //Get the current binding object, and set the new extension manually.
    DataRowView currentRow = (DataRowView)BindingContext[employeesTable, "Employees"].Current;  
    // Remove the "x" from the extension.  
    currentRow["Extension"] = ext.Substring(1);  

    //Return the phone number.  
    e.Value = phoneNumber;  
}

Private Sub PhoneBinding_Format(ByVal sender As Object, ByVal e As ConvertEventArgs) Handles PhoneBinding.Format  
    Dim Ext As String  

    Dim CurrentRow As DataRowView = CType(Me.BindingContext(EmployeesTable, "Employees").Current, DataRowView)  
    If (CurrentRow("Extension") Is Nothing) Then  
        Ext = ""  
    Else  
        Ext = CurrentRow("Extension").ToString()  
    End If  

    e.Value = e.Value.ToString().Trim() & " x" & Ext  
End Sub  

Private Sub PhoneBinding_Parse(ByVal sender As Object, ByVal e As ConvertEventArgs) Handles PhoneBinding.Parse  
    Dim PhoneNumberAndExt As String = e.Value.ToString()  

    Dim ExtIndex As Integer = PhoneNumberAndExt.IndexOf("x")  
    Dim Ext As String = PhoneNumberAndExt.Substring(ExtIndex).Trim()  
    Dim PhoneNumber As String = PhoneNumberAndExt.Substring(0, ExtIndex).Trim()  

    ' Get the current binding object, and set the new extension manually.
    Dim CurrentRow As DataRowView = CType(Me.BindingContext(EmployeesTable, "Employees").Current, DataRowView)  
    ' Remove the "x" from the extension.  
    CurrentRow("Extension") = CObj(Ext.Substring(1))  

    ' Return the phone number.  
    e.Value = PhoneNumber  
End Sub

두 개의 Button 컨트롤을 양식에 추가합니다. previousButton 및 nextButton의 이름을 지정합니다. 각 단추를 두 번 클릭하여 Click 이벤트 처리기를 추가하고 다음 코드 예제와 같이 이벤트 처리기를 채웁니다.

private void previousButton_Click(object sender, EventArgs e)  
{  
    BindingContext[employeesTable, "Employees"].Position = BindingContext[employeesTable, "Employees"].Position - 1;  
}  

private void nextButton_Click(object sender, EventArgs e)  
{  
    BindingContext[employeesTable, "Employees"].Position = BindingContext[employeesTable, "Employees"].Position + 1;  
}

Private Sub PreviousButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PreviousButton.Click  
    Me.BindingContext(EmployeesTable, "Employees").Position = Me.BindingContext(EmployeesTable, "Employees").Position - 1  
End Sub  

Private Sub NextButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NextButton.Click  
    Me.BindingContext(EmployeesTable, "Employees").Position = Me.BindingContext(EmployeesTable, "Employees").Position + 1  
End Sub

예제를 실행합니다. 데이터를 편집하고 이전 및 다음 단추를 사용하여 데이터가 DataSet에 맞게 제대로 유지되는지 확인합니다.

예제

다음 코드 예제는 이전 프로시저를 완료한 결과로 나온 전체 코드 목록입니다.

#pragma region Using directives

#using <System.dll>
#using <System.Data.dll>
#using <System.Drawing.dll>
#using <System.Windows.Forms.dll>
#using <System.Xml.dll>
#using <System.EnterpriseServices.dll>
#using <System.Transactions.dll>

using namespace System;
using namespace System::Collections::Generic;
using namespace System::ComponentModel;
using namespace System::Data;
using namespace System::Drawing;
using namespace System::Windows::Forms;
using namespace System::Data::SqlClient;

#pragma endregion

namespace MaskedTextBoxDataCSharp
{
    public ref class Form1 : public Form
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
    private:
        System::ComponentModel::IContainer^ components;

    public:
        Form1()
        {
            InitializeComponent();
        }

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
    protected:
        ~Form1()
        {
            if (components != nullptr)
            {
                delete components;
            }
        }



#pragma region Windows Form Designer generated code

               /// <summary>
               /// Required method for Designer support - do not modify
               /// the contents of this method with the code editor.
               /// </summary>
    private:
        void InitializeComponent()
        {
            employeesTable = gcnew DataSet();
            components = nullptr;
            this->firstName = gcnew System::Windows::Forms::TextBox();
            this->lastName = gcnew System::Windows::Forms::TextBox();
            this->phoneMask = gcnew System::Windows::Forms::MaskedTextBox();
            this->previousButton = gcnew System::Windows::Forms::Button();
            this->nextButton = gcnew System::Windows::Forms::Button();
            this->SuspendLayout();
            //
            // firstName
            //
            this->firstName->Location = System::Drawing::Point(13, 14);
            this->firstName->Name = "firstName";
            this->firstName->Size = System::Drawing::Size(184, 20);
            this->firstName->TabIndex = 0;
            //
            // lastName
            //
            this->lastName->Location = System::Drawing::Point(204, 14);
            this->lastName->Name = "lastName";
            this->lastName->Size = System::Drawing::Size(184, 20);
            this->lastName->TabIndex = 1;
            //
            // phoneMask
            //
            this->phoneMask->Location = System::Drawing::Point(441, 14);
            this->phoneMask->Mask = "(009) 000-0000 x9999";
            this->phoneMask->Name = "phoneMask";
            this->phoneMask->Size = System::Drawing::Size(169, 20);
            this->phoneMask->TabIndex = 2;
            //
            // previousButton
            //
            this->previousButton->Location = System::Drawing::Point(630, 14);
            this->previousButton->Name = "previousButton";
            this->previousButton->TabIndex = 3;
            this->previousButton->Text = "Previous";
            this->previousButton->Click += gcnew System::EventHandler(this,&Form1::previousButton_Click);
            //
            // nextButton
            //
            this->nextButton->Location = System::Drawing::Point(723, 14);
            this->nextButton->Name = "nextButton";
            this->nextButton->TabIndex = 4;
            this->nextButton->Text = "Next";
            this->nextButton->Click += gcnew System::EventHandler(this,&Form1::nextButton_Click);
            //
            // Form1
            //
            this->AutoScaleBaseSize = System::Drawing::Size(5, 13);
            this->ClientSize = System::Drawing::Size(887, 46);
            this->Controls->Add(this->nextButton);
            this->Controls->Add(this->previousButton);
            this->Controls->Add(this->phoneMask);
            this->Controls->Add(this->lastName);
            this->Controls->Add(this->firstName);
            this->Name = "Form1";
            this->Text = "Form1";
            this->Load += gcnew System::EventHandler(this,&Form1::Form1_Load);
            this->ResumeLayout(false);
            this->PerformLayout();
        }

#pragma endregion

    private:
        System::Windows::Forms::TextBox^ firstName;
        System::Windows::Forms::TextBox^ lastName;
        System::Windows::Forms::MaskedTextBox^ phoneMask;
        System::Windows::Forms::Button^ previousButton;
        System::Windows::Forms::Button^ nextButton;

    private:
        Binding^ currentBinding;
        Binding^ phoneBinding;
        DataSet^ employeesTable;
        SqlConnection^ sc;
        SqlDataAdapter^ dataConnect;

    private:
        void Form1_Load(Object^ sender, EventArgs^ e)
        {
            DoMaskBinding();
        }

    private:
        void DoMaskBinding()
        {
            try
            {
                sc = gcnew SqlConnection("Data Source=localhost;" +
                    "Initial Catalog=NORTHWIND;Integrated Security=SSPI");
                sc->Open();
            }
            catch (Exception^ ex)
            {
                MessageBox::Show(ex->Message);
                return;
            }

            dataConnect = gcnew SqlDataAdapter("SELECT * FROM Employees", sc);
            dataConnect->Fill(employeesTable, "Employees");


            // Now bind MaskedTextBox to appropriate field. Note that we must
            // create the Binding objects before adding them to the control -
            // otherwise, we won't get a Format event on the initial load.
            try
            {
                currentBinding = gcnew Binding("Text", employeesTable,
                    "Employees.FirstName");
                firstName->DataBindings->Add(currentBinding);

                currentBinding = gcnew Binding("Text", employeesTable,
                    "Employees.LastName");
                lastName->DataBindings->Add(currentBinding);

                phoneBinding = gcnew Binding("Text", employeesTable, 
                    "Employees.HomePhone");
                // We must add the event handlers before we bind, or the
                // Format event will not get called for the first record.
                phoneBinding->Format += gcnew
                    ConvertEventHandler(this, &Form1::phoneBinding_Format);
                phoneBinding->Parse += gcnew
                    ConvertEventHandler(this, &Form1::phoneBinding_Parse);
                phoneMask->DataBindings->Add(phoneBinding);
            }
            catch (Exception^ ex)
            {
                MessageBox::Show(ex->Message);
                return;
            }
        }

    private:
        void phoneBinding_Format(Object^ sender, ConvertEventArgs^ e)
        {
            String^ ext;

            DataRowView^ currentRow = (DataRowView^) BindingContext[
                employeesTable, "Employees"]->Current;
                if (currentRow["Extension"] == nullptr)
                {
                    ext = "";
                }
                else
                {
                    ext = currentRow["Extension"]->ToString();
                }

                e->Value = e->Value->ToString()->Trim() + " x" + ext;
        }

    private:
        void phoneBinding_Parse(Object^ sender, ConvertEventArgs^ e)
        {
            String^ phoneNumberAndExt = e->Value->ToString();

            int extIndex = phoneNumberAndExt->IndexOf("x");
            String^ ext = phoneNumberAndExt->Substring(extIndex)->Trim();
            String^ phoneNumber = 
                phoneNumberAndExt->Substring(0, extIndex)->Trim();

            //Get the current binding object, and set the new extension 
            //manually.
            DataRowView^ currentRow = 
                (DataRowView^ ) BindingContext[employeesTable,
                "Employees"]->Current;
            // Remove the "x" from the extension.
            currentRow["Extension"] = ext->Substring(1);

            //Return the phone number.
            e->Value = phoneNumber;
        }

    private:
        void previousButton_Click(Object^ sender, EventArgs^ e)
        {
            BindingContext[employeesTable, "Employees"]->Position =
                BindingContext[employeesTable, "Employees"]->Position - 1;
        }

    private:
        void nextButton_Click(Object^ sender, EventArgs^ e)
        {
            BindingContext[employeesTable, "Employees"]->Position =
                BindingContext[employeesTable, "Employees"]->Position + 1;
        }
    };
}

[STAThread]
int main()
{
    Application::EnableVisualStyles();
    Application::Run(gcnew MaskedTextBoxDataCSharp::Form1());
}

#region Using directives

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using System.Data.SqlClient;

#endregion

namespace MaskedTextBoxDataCSharp
{
    partial class Form1 : Form
    {
        Binding currentBinding, phoneBinding;
        DataSet employeesTable = new DataSet();
        SqlConnection sc;
        SqlDataAdapter dataConnect;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            DoMaskBinding();
        }

        private void DoMaskBinding()
        {
            try
            {
                sc = new SqlConnection("Data Source=localhost;Initial Catalog=NORTHWIND;Integrated Security=SSPI");
                sc.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }

            dataConnect = new SqlDataAdapter("SELECT * FROM Employees", sc);
            dataConnect.Fill(employeesTable, "Employees");

            // Now bind MaskedTextBox to appropriate field. Note that we must create the Binding objects
            // before adding them to the control - otherwise, we won't get a Format event on the
            // initial load.
            try
            {
                currentBinding = new Binding("Text", employeesTable, "Employees.FirstName");
                firstName.DataBindings.Add(currentBinding);

                currentBinding = new Binding("Text", employeesTable, "Employees.LastName");
                lastName.DataBindings.Add(currentBinding);

                phoneBinding =new Binding("Text", employeesTable, "Employees.HomePhone");
                // We must add the event handlers before we bind, or the Format event will not get called
                // for the first record.
                phoneBinding.Format += new ConvertEventHandler(phoneBinding_Format);
                phoneBinding.Parse += new ConvertEventHandler(phoneBinding_Parse);
                phoneMask.DataBindings.Add(phoneBinding);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void phoneBinding_Format(Object sender, ConvertEventArgs e)
        {
            String ext;

            DataRowView currentRow = (DataRowView)BindingContext[employeesTable, "Employees"].Current;
            if (currentRow["Extension"] == null)
            {
                ext = "";
            } else
            {
                ext = currentRow["Extension"].ToString();
            }

            e.Value = e.Value.ToString().Trim() + " x" + ext;
        }

        private void phoneBinding_Parse(Object sender, ConvertEventArgs e)
        {
            String phoneNumberAndExt = e.Value.ToString();

            int extIndex = phoneNumberAndExt.IndexOf("x");
            String ext = phoneNumberAndExt.Substring(extIndex).Trim();
            String phoneNumber = phoneNumberAndExt.Substring(0, extIndex).Trim();

            //Get the current binding object, and set the new extension manually.
            DataRowView currentRow = (DataRowView)BindingContext[employeesTable, "Employees"].Current;
            // Remove the "x" from the extension.
            currentRow["Extension"] = ext.Substring(1);

            //Return the phone number.
            e.Value = phoneNumber;
        }

        private void previousButton_Click(object sender, EventArgs e)
        {
            BindingContext[employeesTable, "Employees"].Position = BindingContext[employeesTable, "Employees"].Position - 1;
        }

        private void nextButton_Click(object sender, EventArgs e)
        {
            BindingContext[employeesTable, "Employees"].Position = BindingContext[employeesTable, "Employees"].Position + 1;
        }
    }
}

Imports System.Data.SqlClient

Public Class Form1
    Dim WithEvents CurrentBinding, PhoneBinding As Binding
    Dim EmployeesTable As New DataSet()
    Dim sc As SqlConnection
    Dim DataConnect As SqlDataAdapter

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        DoMaskedBinding()
    End Sub

    Private Sub DoMaskedBinding()
        Try
            sc = New SqlConnection("Data Source=localhost;Initial Catalog=NORTHWIND;Integrated Security=SSPI")
            sc.Open()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
            Application.Exit()
        End Try

        DataConnect = New SqlDataAdapter("SELECT * FROM Employees", sc)
        DataConnect.Fill(EmployeesTable, "Employees")

        ' Now bind MaskedTextBox to appropriate field. Note that we must create the Binding objects
        ' before adding them to the control - otherwise, we won't get a Format event on the 
        ' initial load. 
        Try
            CurrentBinding = New Binding("Text", EmployeesTable, "Employees.FirstName")
            firstName.DataBindings.Add(CurrentBinding)
            CurrentBinding = New Binding("Text", EmployeesTable, "Employees.LastName")
            lastName.DataBindings.Add(CurrentBinding)
            PhoneBinding = New Binding("Text", EmployeesTable, "Employees.HomePhone")
            PhoneMask.DataBindings.Add(PhoneBinding)
        Catch ex As Exception
            MessageBox.Show(ex.Message)
            Application.Exit()
        End Try
    End Sub

    Private Sub PhoneBinding_Format(ByVal sender As Object, ByVal e As ConvertEventArgs) Handles PhoneBinding.Format
        Dim Ext As String

        Dim CurrentRow As DataRowView = CType(Me.BindingContext(EmployeesTable, "Employees").Current, DataRowView)
        If (CurrentRow("Extension") Is Nothing) Then
            Ext = ""
        Else
            Ext = CurrentRow("Extension").ToString()
        End If

        e.Value = e.Value.ToString().Trim() & " x" & Ext
    End Sub

    Private Sub PhoneBinding_Parse(ByVal sender As Object, ByVal e As ConvertEventArgs) Handles PhoneBinding.Parse
        Dim PhoneNumberAndExt As String = e.Value.ToString()

        Dim ExtIndex As Integer = PhoneNumberAndExt.IndexOf("x")
        Dim Ext As String = PhoneNumberAndExt.Substring(ExtIndex).Trim()
        Dim PhoneNumber As String = PhoneNumberAndExt.Substring(0, ExtIndex).Trim()

        ' Get the current binding object, and set the new extension manually. 
        Dim CurrentRow As DataRowView = CType(Me.BindingContext(EmployeesTable, "Employees").Current, DataRowView)
        ' Remove the "x" from the extension.
        CurrentRow("Extension") = CObj(Ext.Substring(1))

        ' Return the phone number.
        e.Value = PhoneNumber
    End Sub

    Private Sub NextButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NextButton.Click
        Me.BindingContext(EmployeesTable, "Employees").Position = Me.BindingContext(EmployeesTable, "Employees").Position + 1
    End Sub

    Private Sub PreviousButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PreviousButton.Click
        Me.BindingContext(EmployeesTable, "Employees").Position = Me.BindingContext(EmployeesTable, "Employees").Position - 1
    End Sub
End Class

코드 컴파일

Visual C# 또는 Visual Basic 프로젝트를 만듭니다.
이전 프로시저에서 설명한 대로 양식에 TextBox 및 MaskedTextBox 컨트롤을 추가합니다.
프로젝트의 기본 양식에 대한 소스 코드 파일을 엽니다.
이 파일의 소스 코드를 이전 “코드” 섹션에 나열된 코드로 바꿉니다.
애플리케이션을 컴파일합니다.

참고 항목

연습: MaskedTextBox 컨트롤 사용

다음을 통해 공유

방법: MaskedTextBox 컨트롤에 데이터 바인딩

MaskedTextBox 컨트롤에 데이터를 바인딩하려면

예제

코드 컴파일

참고 항목

피드백

추가 리소스