Simple ContactBook in WPF

Sourabh Somani
11y
16.8k
0
4

Article

To develop a simple contact book in WPF use the following procedure.

1. Open Visual Studio 2010.

2. Go to "File" -> "New" -> "Project..." or press Ctrl+Shift+N.

3. Select "Template Visual C#" -> "Windows" and now select "WPF Application". Then provide any name and location to save this application.

4. Make the following form like this:

You can create this form using the following XAML code:

<Window x:Class="MyphoneBook.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="ADDRESS BOOK BY SOURABH SOMANI" Height="506" Width="763" ResizeMode="NoResize" WindowStartupLocation="CenterScreen" WindowStyle="None">
    <Grid>
        <Grid.Background>
            <LinearGradientBrush EndPoint="0.5,1" StartPoint="0.5,0">
                <GradientStop Color="#B4FFFFFF" Offset="0" />
                <GradientStop Color="Black" Offset="1" />
                <GradientStop Color="#B4FFFFFF" Offset="0.254" />
            </LinearGradientBrush>
        </Grid.Background>
        <TextBlock Height="23" HorizontalAlignment="Left" Margin="29,12,0,0" Name="textBlock1" Text="NAME:" VerticalAlignment="Top" />
        <TextBlock Height="23" HorizontalAlignment="Left" Margin="28,40,0,0" Name="textBlock2" Text="HOME:" VerticalAlignment="Top" />
        <TextBlock Height="23" HorizontalAlignment="Left" Margin="21,69,0,0" Name="textBlock3" Text="MOBILE:" VerticalAlignment="Top" />
        <TextBlock Height="23" HorizontalAlignment="Left" Margin="323,12,0,0" Name="textBlock4" Text="E-MAIL:" VerticalAlignment="Top" />
        <TextBlock Height="23" HorizontalAlignment="Left" Margin="311,42,0,0" Name="textBlock5" Text="ADDRESS:" VerticalAlignment="Top" />

5. Now open SQL Server Management Studio 2008 and create a database (for example I am creating it with the name "ADDRESS_BOOK").

6. Now create 2 tables in it.

(i) Provide the first name as "Address".

(ii) Provide the second name a "country".

7. Now insert the values of the country table using the "country.txt" given in the uploaded RAR File.

8. Now the next step is to return to Visual Studio and do the following:

a. First go to "<FileName>.xaml.cs"

b. Include the two namespaces as in "using System.Data;"and "using System.Data.SqlClient;"

c. Now define the following variables in the class:

SqlConnection con;

SqlCommand cmd;

DataTable dtForContry;

DataTable dtForGridView;

SqlDataAdapter adpt;

d. Now in the MainWindow() constructor define following:

  InitializeComponent();
            EditBtn.IsEnabled = false;
            textBox7.IsReadOnly = true;

            con=newSqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=ADDRESS_BOOK;Integrated Security=True");
            string qry ="select * from country";
            adpt = newSqlDataAdapter(qry, con);
            dtForContry = newDataTable();
            adpt.Fill(dtForContry);
            comboBox1.ItemsSource = dtForContry.DefaultView;
            comboBox1.DisplayMemberPath = dtForContry.Columns[2].ToString();
            comboBox1.SelectedValuePath = dtForContry.Columns[6].ToString();
            if (textBox6.Text ==string.Empty)
            {
                FillGrid(string.Empty);
            }
            else
            {
                FillGrid(textBox6.Text);
            }

e. Write Following code for the "New" button click event:

 textBox1.Text = textBox2.Text = textBox3.Text =
textBox4.Text = textBox5.Text=textBox7.Text = string.Empty;
            EditBtn.IsEnabled = false;
            SaveBtn.IsEnabled = true;

f. For the "Save" button write the following code:

 string qry = "insert
into Address(NAME,HOME,MOBILE,EMAIL,ADDRESS) VALUES('" +textBox1.Text + "','" 
+textBox2.Text + "','" +textBox7.Text + textBox3.Text + "', '"+ textBox4.Text + "','" +textBox5.Text + "')";
            con.Open();
            cmd = new SqlCommand(qry, con);
            if (cmd.ExecuteNonQuery() == 1)
            {
                MessageBox.Show("Successfully Save","Successful");
            }
            else
            {
                MessageBox.Show("Sorry Invalid Entry","Error In Saving",MessageBoxButton.OK,MessageBoxImage.Error);
            }
            con.Close();

g. For the ccombo-box selection event use the following code:

 textBox7.Text ="+"+comboBox1.SelectedValue.ToString()+" - ";

h: For the grid view selection change event use the following code:

 if (dataGrid1.SelectedIndex != -1)
            {
                int temp = dataGrid1.SelectedIndex;
                if (dataGrid1.SelectedIndex < dtForGridView.Rows.Count)
                {
                    textBox1.Text = dtForGridView.Rows[temp][1].ToString();
                    textBox2.Text = dtForGridView.Rows[temp][2].ToString();
                    textBox3.Text = dtForGridView.Rows[temp][3].ToString();
                    textBox4.Text = dtForGridView.Rows[temp][4].ToString();
                    textBox5.Text = dtForGridView.Rows[temp][5].ToString();
                    EditBtn.IsEnabled = true;
                    SaveBtn.IsEnabled = false;
            dataGrid1.SelectedIndex = -1;
                }
            }

I: For the Edit button click use the following code:

string qry = "update Address SET NAME='" + textBox1.Text + "',HOME='" + textBox2.Text + "',MOBILE='" +
textBox3.Text + "',EMAIL='" + textBox4.Text + "',ADDRESS='" + textBox5.Text + "'";
            con.Open();
            cmd = newSqlCommand(qry, con);
            if (cmd.ExecuteNonQuery() == 1)
            {
                MessageBox.Show("Successfully Save", "Successful");
            }
            else
            {
                MessageBox.Show("Sorry Invalid Entry", "Error In Saving",MessageBoxButton.OK,MessageBoxImage.Error);
            }
            con.Close();
            FillGrid(string.Empty);

After doing all that, your output will be as in the following:

Up Next

Ebook Download

View all

Printing in C# Made Easy

Read by 10.8k people

Download Now!

Learn

View all

sourabhsomani.com