Saturday, November 5, 2016

Console CRUD Application in C# and Microsoft Access

One of my friend and fellow software engineer named Mr. Alfel Benvic G. Go write and share to us this creation of a CRUD database application using Console in C# and Microsoft Access I am very grateful and thankful because he share his talent with this program.

Add me at Facebook my address is jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My mobile number here in the Philippines is 09173084360.




Sample Program Output


DOWNLOAD SOURCE CODE HERE


Posted by at No comments:
Labels: , , ,

Address Book in C# and Microsoft SQL Server

In this article I would like to share with you a sample program that shows how to create a CRUD application in C# and Microsoft SQL Server I called this program Address Book that save, update, delete and view user records using data view grid. I hope you will find my work useful I work hard in this sample program this is my first time to create my own database application using C# and Microsoft SQL Server 2008 R2.  I am using Visual Studio 2012 in this application. Thank you.

Add me at Facebook my address is jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My mobile number here in the Philippines is 09173084360.













Sample Program Output and Procedures To Follow


Program Listing

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace addressbook
{
    public partial class Form1 : Form
    {
        SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=user;Integrated Security=true;");
        SqlCommand cmd;
        SqlDataAdapter adapt;
      
        int ID = 0;

        public Form1()
        {
            InitializeComponent();
            DisplayData();

        }

        private void DisplayData()
        {
            con.Open();
            DataTable dt = new DataTable();
            adapt = new SqlDataAdapter("SELECT * FROM tbl_users", con);
            adapt.Fill(dt);
            dataGridView1.DataSource = dt;
            con.Close();
        }

        private void ClearData()
        {
            txt_lastname.Text = "";
            txt_firstname.Text = "";
            txt_home.Text = "";
            txt_mobile.Text = "";
            txt_telephone.Text = "";
            txt_email.Text = "";
            ID = 0;
        }


      
        private void btn_quit_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Do you want to exit?", "My Application",
        MessageBoxButtons.YesNo, MessageBoxIcon.Question)
        == DialogResult.Yes)
            {
                Application.Exit();
            }
            else
            {
                txt_lastname.Focus();
            }
        }

        private void btn_about_Click(object sender, EventArgs e)
        {
            MessageBox.Show("Written By: Mr. Jake R. Pomperada, MAED-IT      2016",
            "About This Program", MessageBoxButtons.OK,
          MessageBoxIcon.Information);
            txt_lastname.Focus();
        }

        private void btn_save_Click(object sender, EventArgs e)
        {
            if (txt_lastname.Text != "" && txt_firstname.Text != "" 
                && txt_home.Text != "" && txt_mobile.Text != "" 
                && txt_telephone.Text != "" && txt_email.Text != "")
              {
                cmd = new SqlCommand("INSERT INTO tbl_users(lastname,firstname,address,mobile,telephone,email) VALUES(@lastname,@firstname,@address,@mobile,@telephone,@email)", con);
                con.Open();
                cmd.Parameters.AddWithValue("@lastname", txt_lastname.Text.ToUpper());
                cmd.Parameters.AddWithValue("@firstname", txt_firstname.Text.ToUpper());
                cmd.Parameters.AddWithValue("@address", txt_home.Text.ToUpper());
                cmd.Parameters.AddWithValue("@mobile", txt_mobile.Text.ToUpper());
                cmd.Parameters.AddWithValue("@telephone", txt_telephone.Text.ToUpper());
                cmd.Parameters.AddWithValue("@email", txt_email.Text.ToLower());
                cmd.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Record Inserted Successfully");
                DisplayData();
                ClearData();
            }
            else
            {
                MessageBox.Show("Please Provide Details!");
            }
        }

        private void btn_update_Click(object sender, EventArgs e)
        {
            if (txt_lastname.Text != "" && txt_firstname.Text != ""
                           && txt_home.Text != "" && txt_mobile.Text != ""
                           && txt_telephone.Text != "" && txt_email.Text != "")
            {
                cmd = new SqlCommand("UPDATE tbl_users SET lastname=@lastname, firstname=@firstname,address=@address,mobile=@mobile,telephone=@telephone,email=@email WHERE id=@id", con);
                con.Open();
                cmd.Parameters.AddWithValue("@id", ID);
                cmd.Parameters.AddWithValue("@lastname", txt_lastname.Text.ToUpper());
                cmd.Parameters.AddWithValue("@firstname", txt_firstname.Text.ToUpper());
                cmd.Parameters.AddWithValue("@address", txt_home.Text.ToUpper());
                cmd.Parameters.AddWithValue("@mobile", txt_mobile.Text.ToUpper());
                cmd.Parameters.AddWithValue("@telephone", txt_telephone.Text.ToUpper());
                cmd.Parameters.AddWithValue("@email", txt_email.Text.ToLower());
                cmd.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Record Updated Successfully");
                DisplayData();
                ClearData();
            }
            else
            {
                MessageBox.Show("Please Provide Details!");
            }
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            ID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
            txt_lastname.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
            txt_firstname.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
            txt_home.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
            txt_mobile.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
            txt_telephone.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
            txt_email.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();   
        }

        private void btn_new_Click(object sender, EventArgs e)
        {
            txt_lastname.Text = "";
            txt_firstname.Text = "";
            txt_home.Text = "";
            txt_mobile.Text = "";
            txt_telephone.Text = "";
            txt_email.Text = "";
            txt_lastname.Focus();
        }

        private void btn_delete_Click(object sender, EventArgs e)
        {
            if (ID != 0)
            {
                cmd = new SqlCommand("DELETE tbl_users WHERE id=@id", con);
                con.Open();
                cmd.Parameters.AddWithValue("@id", ID);
                cmd.ExecuteNonQuery();
                con.Close();
                MessageBox.Show("Record Deleted Successfully!");
                DisplayData();
                ClearData();
            }
            else
            {
                MessageBox.Show("Please Select Record to Delete");
            }
        }
    }
}


SQL Dumb File

USE [user]
GO
/****** Object:  Table [dbo].[tbl_users]    Script Date: 11/05/2016 15:49:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_users](
[id] [int] IDENTITY(1,1) NOT NULL,
[lastname] [nchar](100) NULL,
[firstname] [nchar](100) NULL,
[address] [nchar](200) NULL,
[mobile] [nchar](15) NULL,
[telephone] [nchar](15) NULL,
[email] [nchar](100) NULL,
 CONSTRAINT [PK_tbl_users] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[tbl_users] ON
INSERT [dbo].[tbl_users] ([id], [lastname], [firstname], [address], [mobile], [telephone], [email]) VALUES (4, N'POMPERADA                                                                                           ', N'JACOB                                                                                               ', N'ERORECO SUBD, BACOLOD CITY                                                                                                                                                                              ', N'09173084360    ', N'4335675        ', N'jacob_pomperada@gmail.com                                                                           ')
INSERT [dbo].[tbl_users] ([id], [lastname], [firstname], [address], [mobile], [telephone], [email]) VALUES (5, N'BRYANT                                                                                              ', N'KOBE                                                                                                ', N'LOS ANGELES CALIFORNIA, USA                                                                                                                                                                             ', N'1234567890     ', N'4563423        ', N'kobe@la_lakers.com                                                                                  ')
INSERT [dbo].[tbl_users] ([id], [lastname], [firstname], [address], [mobile], [telephone], [email]) VALUES (6, N'POMPERADA                                                                                           ', N'ALLIE                                                                                               ', N'BACOLOD CITY                                                                                                                                                                                            ', N'0912345623     ', N'4335675        ', N'allie_pomperada@yahoo.com.ph                                                                        ')
INSERT [dbo].[tbl_users] ([id], [lastname], [firstname], [address], [mobile], [telephone], [email]) VALUES (7, N'POMPERADA                                                                                           ', N'JULIANNA RAE                                                                                        ', N'BACOLOD CITY, NEGROS OCCIDENTAL                                                                                                                                                                         ', N'121212121212   ', N'4335081        ', N'iya_pomperada@gmail.com                                                                             ')
INSERT [dbo].[tbl_users] ([id], [lastname], [firstname], [address], [mobile], [telephone], [email]) VALUES (8, N'GATES                                                                                               ', N'BILL                                                                                                ', N'ONE MICROSOFT WAY, USA                                                                                                                                                                                  ', N'1212123434343  ', N'34343434       ', N'bill_gates@microsoft.com                                                                            ')
INSERT [dbo].[tbl_users] ([id], [lastname], [firstname], [address], [mobile], [telephone], [email]) VALUES (10, N'POMPERADA                                                                                           ', N'JAKE                                                                                                ', N'ALIJIS BACOLOD CITY                                                                                                                                                                                     ', N'09173084360    ', N'4335675        ', N'jakerpomperada@yahoo.com                                                                            ')
SET IDENTITY_INSERT [dbo].[tbl_users] OFF


Posted by at No comments:
Labels: , , ,

Friday, November 4, 2016

Student Grade Solver Using Two Dimensional Array in C++

Here is a simple program that I wrote using C++ that will compute and evaluate the grades of the students using two dimensional array in C++ as our data structure. I hope you will find my work useful I am using Dev C++ as my C++ compiler and CodeBlocks as my C++ text editor in writing this program. Thank you.

Add me at Facebook my address is jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My mobile number here in the Philippines is 09173084360.



Program Listing

#include <iostream>
#include <iomanip>

using namespace std;

main() {
     int grades[5][1],pass=0,failed=0,out_range=0;
     int row=0, col=0;
     string remarks;
     char letter_grade;

     cout << "\t Grades Evaluator Version 1.0";
     cout << "\n\n Created By: Mr. Jake Rodriguez Pomperada,MAED-IT";
     cout << "\n\n";
     
     for ( row=0; row < 5; row++) {
       for  (col=0; col < 1; col++) {
         cout << "Enter grade : " ;
         cin >> grades[row][col];
     }
}
    
  // Code to check for remarks
cout <<"\n" << setw(5) << "GRADES" <<
               setw(7) << " EQUIV " <<
               setw(10) << "REMARKS";
    cout << "\n\n";

     for ( row=0; row < 5; row++) {
       for (col=0; col < 1; col++) {

         if (grades[row][col] >= 75) {
             remarks = "PASSED";
             pass++;
         }
         else if (grades[row][col] < 50)
         {
           remarks= " Error Out of Range ";
           out_range++;
         }

         else  if (grades[row][col] < 75){
                 remarks = "FAILED";
                 failed++;
         }
 


  // Letter Grade Equivalent

     if (grades[row][col] >= 90 &&  grades[row][col] <= 100  ) {
           letter_grade = 'A';
         }
         else if (grades[row][col] >= 80 && grades[row][col] <= 89  ) {
           letter_grade = 'B';
         }
         else if (grades[row][col] >= 70 && grades[row][col] <= 79  ) {
           letter_grade = 'C';
         }
         else if (grades[row][col] >= 60 && grades[row][col] <= 69  ) {
           letter_grade = 'D';
         }
        else if (grades[row][col] >= 50 && grades[row][col] <= 59  ) {
           letter_grade = 'F';
         }
        else if (grades[row][col] < 50) {
            letter_grade = 'X';

         }

        cout <<"\n" << setw(5) << grades[row][col]
              << setw(6) << letter_grade << setw(12)
              << remarks;  
     } 
 }
      

     cout << "\n\n";
     cout << "\nNumber of Passed Grades " << pass << ".";
     cout << "\nNumber of Failed Grades " << failed << ".";
     cout << "\nNumber of Out of Range Grades "<< out_range << ".";
     cout << "\n\n";
     system("PAUSE"); 
 
}

Posted by at No comments:
Labels:

Highest and Lowest Numbers Using Two Dimensional Array in C++

This sample program that I wrote a long time ago will ask the user to give a series of numbers and then our program will check which of the given number by our user is the highest and lowest using two dimensional array in C++ programming language. I hope you will find my work useful. Thank you.

Add me at Facebook my address is jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My mobile number here in the Philippines is 09173084360.


Program Listing

/* Checks Highest and Lowest From 10 numbers*/
// Date Modified : November 29, 2009
// Sunday

// Created By: Mr. Jake Rodriguez Pomperada, MAED-Instructioanl Technology
// Email Address : jakerpomperada@yahoo.com

#include <iostream>
#include <cctype>

using namespace std;

 main()
{
char reply;

do {
int values[5][2],high=0,low=0, sum=0;

cout<<"\n\n";
cout<<"\t\tHighest and Lowest Number Checker 3.0";
cout<<"\n\n\t      Created By: Mr. Jake R. Pomperada,MAED-IT";
cout<<"\n\n";


       for (int row=0; row <5; row++) {
         for ( int col=0; col <2; col++) {
{

cout<<"Enter a value : ";

cin>>values[row] [col];
     sum+=values[row][col];
}
     }

high=values[0][0];
  for (int row=0; row <5; row++) {
         for ( int col=0; col <2; col++) {

if(high<values[row][col])
{
high=values[row][col];
}
}
  }
low=high;

for (int row=0; row <5; row++) {
         for (int col=0; col <2; col++) {

if(low>values[row][col])
{
low=values[row][col];
}
}

     }


} // check for highest value
cout<<"\nThe highest number is = "<<high;
cout<<"\n";
cout<<"The lowest number is = "<<low;
cout<<"\n";
cout<<"The Total Sum of Values is = "<<sum;
cout<<"\n\n";
cout<<"Do You want to Continue y/n :=> ";
cin>>reply;

} while (toupper(reply) == 'Y');
if (toupper(reply)== 'N')
{
      cout << "\n\n";
      cout << "\t Thank You for Using This Program";
      cout << "\n\n";
}
 system("PAUSE");
}

Posted by at No comments:
Labels:

Product Price Solver Using Two Dimensional Array

This simple program will solve the price of a certain product using two dimensional array as our data structure in C++. I hope you will find my work useful in learning C++ programming. Thank you.

Add me at Facebook my address is jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My mobile number here in the Philippines is 09173084360.


Program Listing

#include <iostream>

using namespace std;

main() {
    string product[4] = {"Nido","Bear Brand",
                       "Anchor Milk", "Milo"};
    int price[4][1];
    int solve=0;
    int add=0,change=0, pay=0;
    cout << "Product Price Solver";
     cout << "\n\n";
     for (int a=0; a<4; a++) {
       for (int b=0; b<1; b++)
       {

        cout << "Enter " <<product[a]
         << " price : ";
        cin >> price[a][b];
        add+=price[a][b];
       }
     solve= add;
     }
    cout << "\n\n";
    cout << "Total Amount Cost :=>" << solve;
    cout << "\n\n";
    cout << "Amount Payed : ";
    cin >> pay;
    change = (pay-solve);
    cout << "Your change is P " << change
        << ".";
    cout << "\n\n";
    system("pause");
 }

Posted by at No comments:
Labels:

Running Sum Using Two Dimensional Array in C++

A very simple program that I wrote using C++ that shows how to use two dimensional array. What the program does it accept a series of number provided by the user and then it sum up the values dynamically. The program code is very easy to understand and very short. I hope you will find my work useful. Thank you.

Add me at Facebook my address is jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com. 

My mobile number here in the Philippines is 09173084360.



Program Listing

#include <cstdlib>
#include <iostream>

using namespace std;

int main(int argc, char *argv[])
{
    int values[3][2], running_sum=0;
    
     cout << "\t\t RUNNING SUM VERSION 1.0";
     cout << "\n";
     cout << "\tCreated By: Mr. Jake R. Pomperada, MAED-IT"; 
          cout << "\n";
      for (int row=0; row< 3; row++) {
           for (int col=0; col< 2; col++) {

            cout << "\nEnter a Number :=> ";
            cin >> values[row][col];
          
            running_sum+=values[row][col];
            cout << "\nThe running sum is " <<       
                    running_sum << ".";
             }
             }
         cout << "\n\n";                     
    system("PAUSE");
    return EXIT_SUCCESS;
}

Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)