WinForm DateTimePicker CRUD Operations With SQLServer Part 4 in Hindi

DateTimePicker

CRUD Operations Series

• Part 1 TextBox control
• Part 2 CheckBox control
• Part 3 RadioButton control
• Part 4 DateTimePicker control
• Part 5 ComboBox control
• Part 6 PictureBox control
• Part 7 TabControl control

CODE:

Use dbABC;
Go
ALTER TABLE tbl_Employee
ADD DOB DATETIME null, TOB DATETIME null

CODE:

Use dbABC;
Go
ALTER PROCEDURE [dbo].[usp_AddEmployee]
(
@FirstName 	NVARCHAR(50),
@LastName 	NVARCHAR(50),
@Email		NVARCHAR(50),
@IsVB		BIT,
@IsJava		BIT,
@IsCSharp	BIT,
@Gender		INT,
@Dob		DATETIME = null ,
@Tob		DATETIME = null
)
As
BEGIN
INSERT INTO [dbo].[tbl_Employee]([FirstName],[LastName],[Email],[IsVB],[IsJava],

[IsCSharp],[Gender],[DOB],[TOB])
VALUES (@FirstName, @LastName , @Email, @IsVB, @IsJava, @IsCSharp, @Gender, @Dob, 

@Tob)
END

SET THE PROPERTIES OF DateTimePicker

CODE:

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

namespace ABCWF
{
    public partial class EmployeeForm : Form
    {
        public EmployeeForm()
        {
            InitializeComponent();
        }

        private void SubmitButton_Click(object sender, EventArgs e)
        {
            InsertIntoDatabase();
        }

        private void InsertIntoDatabase()
        {
            try
            {
                string connString = ConfigurationManager.ConnectionStrings["abccs"].ConnectionString;
                using (SqlConnection conn = new SqlConnection(connString))
                {
                    using (SqlCommand command = new SqlCommand())
                    {
                        command.Connection = conn;
                        command.CommandType = CommandType.StoredProcedure;
                        command.CommandText = "usp_AddEmployee";
                        command.Parameters.AddWithValue("@FirstName", FirstNameTextBox.Text);
                        command.Parameters.AddWithValue("@LastName", LastNameTextBox.Text);
                        command.Parameters.AddWithValue("@Email", EmailTextBox.Text);
                        command.Parameters.AddWithValue("@IsVB", IsVBCheckBox.Checked);
                        command.Parameters.AddWithValue("@IsJava", IsJavaCheckBox.Checked);
                        command.Parameters.AddWithValue("@IsCSharp", IsCSharpCheckBox.Checked);
                        command.Parameters.AddWithValue("@Gender", GetGenderValue());
                        command.Parameters.AddWithValue("@Dob",
                        (DOBDateTimePicker.Text.Trim() == string.Empty) ? (DateTime?)null : DOBDateTimePicker.Value.Date);
                        command.Parameters.AddWithValue("@Tob", (TimeDateTimePicker.Text.Trim() == string.Empty) ? (TimeSpan?)null : TimeDateTimePicker.Value.TimeOfDay);
                        //Execute the insert query
                        conn.Open();
                        command.ExecuteNonQuery();
                        MessageBox.Show("Record inserted successfully.", "Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Insertion Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        enum Sex
        {
            OtherSex = 0,
            Male = 1,
            Female = 2
        }
        private int GetGenderValue()
        {
            if (MaleRadioButton.Checked)
            {
                return (int)Sex.Male;
            }
            if (FemaleRadioButton.Checked)
            {
                return (int)Sex.Female;
            }
            return (int)Sex.OtherSex;
        }

        private void DOBDateTimePicker_ValueChanged(object sender, EventArgs e)
        {
            DOBDateTimePicker.CustomFormat = "dd/MM/yyyy";
        }

        private void TimeDateTimePicker_ValueChanged_1(object sender, EventArgs e)
        {
            DateTimePicker dtp = (DateTimePicker)sender;
            dtp.CustomFormat = "HH:mm";
        }
    }
}

OUTPUT IN DATABASE

© अजीत कुमार, सर्वाधिकार सुरक्षित।

इस आलेख को उद्धृत करते हुए इस लेख के लिंक का भी विवरण दें। इस आलेख को कॉपीराइट सूचना के साथ यथावत साझा करने की अनुमति है। कृपया इसे ऐसे स्थान पर साझा न करें जहाँ इसे देखने के लिए शुल्क देना पडे।