C# Displaying SQL Server Data in a DataGridView: A Step-by-Step Guide

In this tutorial, we will delve into the world of database programming with C#. Specifically, we will learn how to retrieve data from an SQL Server database and display it in a DataGridView. This is a powerful technique that can greatly enhance the user experience of your Windows Forms applications.

What is DataGridView?

DataGridView is a versatile control in Windows Forms applications that allows you to display and manipulate tabular data. It’s highly customizable and can be used to display data from various sources, including databases.

Our Application

Our application consists of a single method, ViewGridView, which retrieves data from an SQL Server database and displays it in a DataGridView. The goal is to display the data in a way that’s easy to read and understand.

The Code

The core of our application lies in the ViewGridView method. Here’s what it looks like:

string connectionString = "Data Source=VICH-PC\\SQLEXPRESS01;Initial Catalog=ShaneCambodiaDB;User Id=Vich;Password=123456789;";

private void ViewGridView()
{
    string query = "Select * From EmployeeInfo";

    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        SqlDataAdapter dataAdapter = new SqlDataAdapter(query, conn);
        
        DataTable dt = new DataTable();
        dataAdapter.Fill(dt);

        GridView.DataSource = dt;

        foreach (DataGridViewColumn col in GridView.Columns)
        {
            col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
            col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
        }
    }
}

This method first establishes a connection to the SQL Server database using a connection string. It then creates a new SqlDataAdapter with a SQL query and the connection object. The SqlDataAdapter fills a DataTable with the results of the query. This DataTable is then set as the DataSource for the DataGridView.

Finally, the method iterates over each column in the DataGridView and sets the alignment of the header cell and default cell style to DataGridViewContentAlignment.MiddleCenter. This centers the text in each cell, making the data easier to read.

Conclusion

And that’s it! With this setup, you can easily retrieve data from an SQL Server database and display it in a DataGridView. This technique can be extended to manage as many tables as you need in your application. It’s a simple yet powerful way to enhance the user experience of your Windows Forms applications.

I hope this helps! Let me know if you need any further assistance. Happy coding! 🚀

Dynamic Form Navigation in C#: A Step-by-Step Guide

In this tutorial, we will delve into the world of dynamic form navigation in C#. Specifically, we will learn how to display different forms within a single panel on the home form. This is a powerful technique that can greatly enhance the user experience of your Windows Forms applications.

What is Dynamic Form Navigation?

Dynamic form navigation is a method of managing multiple forms in a single application. Instead of opening each form in a new window, we can display them within a panel on the home form. This makes for a smoother, more integrated user experience.

Our Application

Our application consists of two forms: the Home form and the Employee form. The goal is to display the Employee form within a panel on the Home form when a button is clicked.

The Code

The core of our dynamic form navigation lies in two pieces of code: the formmenu method and the btEmployee_Click event.

The formmenu Method

The formmenu method is responsible for managing the forms within our panel, named pannelConnector. Here’s what it looks like:

private void formmenu(object allform)
{
    if (this.pannelConnector.Controls.Count > 0)
        this.pannelConnector.Controls.RemoveAt(0);
    Form fs = allform as Form;
    fs.TopLevel = false;
    fs.Dock = DockStyle.Fill;
    fs.FormBorderStyle = FormBorderStyle.None;
    this.pannelConnector.Controls.Add(fs);
    this.pannelConnector.Tag = fs;
    fs.Show();
}

This method first checks if there are any controls in our panel. If there are, it removes the first one. Then, it sets some properties for our form, adds it to the panel, and finally shows the form.

The btEmployee_Click Event

The btEmployee_Click event is triggered when our Employee button is clicked. It changes the text of a label, lbShow, to “Employee Information”, and then calls the formmenu method with a new instance of the Employee form. Here’s the code:

private void btEmployee_Click(object sender, EventArgs e)
{
    formmenu(new Employee());
}

Watch Tutorial on YouTube

Conclusion

And that’s it! With this setup, you can easily navigate between different forms within a single panel. This technique can be extended to manage as many forms as you need in your application. It’s a simple yet powerful way to enhance the user experience of your Windows Forms applications.

I hope this helps! Let me know if you need any further assistance. Happy coding! 🚀

How to Rename All Files in a Directory Using a Batch Script

Organizing files can be a tedious task, especially when dealing with a large number of files. Fortunately, batch scripts offer a quick and efficient solution. In this article, we'll explore how to rename all files in a directory sequentially using a simple batch script.

What is a Batch Script?

A batch script is a text file containing a series of commands that are executed by the command interpreter on Windows operating systems. Batch scripts are incredibly useful for automating repetitive tasks, such as renaming files.

Renaming All Files Sequentially

Let's say you have a directory full of files that you want to rename. You want the new names to be sequential numbers, starting from 0. Here's how you can do it with a batch script:

@echo off
setlocal EnableDelayedExpansion
set i=0
for %%A in (*) do (
    ren "%%A" "!i!%%~xA"
    set /a i+=1
)

This script will rename all files in the current directory to numbers from 0 to 9, preserving their original file extensions.

How Does the Script Work?

Here's a breakdown of what each line in the script does:

• @echo off: This line prevents the commands in the script from being printed to the console.
• setlocal EnableDelayedExpansion: This line enables the use of delayed variable expansion, which allows us to use the !i! syntax to access the value of i inside the loop.
• set i=0: This line initializes the variable i to 0.
• for %%A in (*) do: This line starts a loop that iterates over all files in the current directory.
• ren "%%A" "!i!%%~xA": This line renames the current file (%%A) to the current value of i, followed by the original file extension (%%~xA).
• set /a i+=1: This line increments i by 1.

Running the Script

To run this script, save it as a .bat file in the same directory as your images, then double-click the .bat file to execute it.

Important Notes

Please make sure to backup your files before running this script as it will overwrite existing files without warning. Also, this script assumes that there are exactly 10 files in the directory. If there are more or less, you may need to adjust the script accordingly.

Moreover, be aware that this will rename all files in the directory, not just image files. If you want to rename files of a specific type, you can replace (*) with (*.filetype), where filetype is the extension of the files you want to rename.

How to Change Windows 10 Single Language To Windows 10 Pro (Chinese to English)

1.Go to check what version of windows 10

2.Go to search type Command Prompt or CMD and run it as Administrator

3.Then Type : Dism /Online /Get-TargetEditions

4.Enter : sc config LicenseManager start= auto & net start LicenseManager

5.  Enter : sc config wuauserv start= auto & net start wuauserv

6.Enter : changepk.exe /productkey VK7JG-NPHTM-C97JM-9MPGT-3V66T ( Key Free Upgrade OS Home Single Language) or slmgr /ipk VK7JG-NPHTM-C97JM-9MPGT-3V66T ( Key Free Upgrade OS Window 10 Home Single Language To Pro)

After restart windows will change from Windows 10 Home Single Language to Windows 10 Pro.

Login Form With Remember - Biometric Attendance USB System C#|VS2022|SQL2022

To create a new SQL Server database and table on a server named Vich-PC\SQLEXPESS, you can use the following SQL commands:

CREATE DATABASE SimpleReportAttendance;
GO

USE SimpleReportAttendance;
GO

CREATE TABLE Login (
    -- Add your column definitions here
);
GO

This title refers to a login form that includes a “Remember Me” feature, which allows users to save their login credentials for future use. The form is part of a biometric attendance system that uses a USB device to record employee attendance. The system is developed using C# programming language in Visual Studio 2022 and uses SQL Server 2022 for data storage and management.

This code appears to be part of a login form for a biometric attendance system. It contains three event handlers for the btLogin button click, the cbRemember checkbox checked change, and the Login form load events.

The btLogin_Click event handler is executed when the user clicks on the btLogin button. It attempts to establish a connection to a SQL Server database using a connection string. Then it creates a SqlDataAdapter object with a SQL query that selects the count of rows from the Login table where the Username and Password columns match the text entered by the user in the txtUsername and txtPassword text boxes. The results of this query are stored in a DataTable object. If the count of rows returned by the query is 1, then the login is successful and the current form is hidden while a new instance of the Main form is shown. Otherwise, a message box is displayed to inform the user that their username or password is invalid.

The cbRemember_CheckedChanged event handler is executed when the user checks or unchecks the cbRemember checkbox. If the checkbox is checked, then the text entered by the user in the txtUsername and txtPassword text boxes is saved to the application’s settings. If it’s unchecked, then these settings are cleared.

The Login_Load event handler is executed when the login form is loaded. It checks if there are saved values for the username and password in the application’s settings. If there are, then these values are used to populate the text in the txtUsername and txtPassword text boxes.

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

namespace BiometricRecordUSBReport
{
    public partial class Login : Form
    {
        public Login()
        {
            InitializeComponent();
        }

        private void btLogin_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection con = new SqlConnection(@"Data Source=VICH-PC\SQLEXPRESS;Initial Catalog=BiometricUSB;Integrated Security=true");
                SqlDataAdapter sda = new SqlDataAdapter("Select Count(*) From Login Where Username='" + txtUsername.Text + "'And Password='" + txtPassword.Text + "'", con);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                if (dt.Rows[0][0].ToString() == "1")
                {
                    this.Hide();
                    Main ss = new Main();
                    ss.Show();
                }
                else
                {
                    MessageBox.Show("Invalid username or password");
                }
            }catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

        }

        private void cbRemember_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                if (cbRemember.Checked)
                {
                    Properties.Settings.Default.Username = txtUsername.Text;
                    Properties.Settings.Default.Password = txtPassword.Text;
                    Properties.Settings.Default.Save();
                }
                else
                {
                    Properties.Settings.Default.Username = "";
                    Properties.Settings.Default.Password = "";
                    Properties.Settings.Default.Save();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }

        private void Login_Load(object sender, EventArgs e)
        {
            if (Properties.Settings.Default.Username != String.Empty)
            {
                txtUsername.Text = Properties.Settings.Default.Username;
                txtPassword.Text = Properties.Settings.Default.Password;
            }
        }
    }
}

This is video tutorial on YouTube : 

How To Fix Tiny Khmer Font In Telegram New Method 2023

The default Khmer font on Telegram for computers is small. To solve this problem, you need to change the default font of Microsoft Windows by updating the registry.

*Method 1* 

Download this font !KhmerOSBattambang.ttf or !KhmerOSSiemreap.ttf install it then restart your Computer or Telegram.

*Method 2* 

Step 1: Press Win+R to open Run and then type Regedit.

Step 2: Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\FontSubstitutes.

Step 3: Then change MS Shell Dlg2 to Khmer Font that you want to put and click Ok to finish.

Step 4: Restart Telegram and you will see Khmer font bigger than before.

C# Classic Login Form With Admin and User Windows Application | School Management System

This is a free project that I create for people that first with c# language with source code it have SQL Server and Visual Studio project (2015).

Requirement 

• Sql Sever 2014 Management Studio Installed
• Microsoft Visual Studio Professionals 2015
• C# Languages

Source Code 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace SMS_Management_System
{
    public partial class Frm_Security : Form
    {
        public Frm_Security()
        {
            InitializeComponent();
        }

        private void btclose_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void btlogin_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=SONYVAIO\SQLEXPRESS;Initial Catalog=SMSManagement;Integrated Security=true;");
            SqlCommand cmd = new SqlCommand("SELECT * FROM tbllogin WHERE ln_user='" + txtuser.Text + "'and ln_pass = '" + txtpass.Text + "'", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            string cmdItem = cbtype.SelectedItem.ToString();
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i]["ln_usertype"].ToString() == cmdItem)
                    {
                        MessageBox.Show("You are login as " + dt.Rows[i][5]);
                        if(cbtype.SelectedIndex == 0)
                        {
                            Frm_Home home = new Frm_Home();
                            home.Show();
                            this.Hide();
                        }else
                        {
                            Frm_Home_User home2 = new Frm_Home_User();
                            home2.Hide();
                            home2.Show();
                            
                        }
                    }
                }
            }else
            {
                MessageBox.Show("Error");
            }
        }
    }
} 


Download Project C# School Management System

Khmer Font Tacteing Free Download

នេះគឺជា Font Tacteing សម្រាប់អោយបងប្អូនទាំងអស់គ្នាធ្វើការទាញយក សម្រាប់យកទៅធ្វើឯកសារផ្សេងៗ។

This is Font Tacteing for all of you to download for various documents.

ចុចប៊ូតុងខាងក្រោយសម្រាប់ធ្វើការទាញយក

How To Find FREQUENCY,MEAN,MODE,MEDIAN...in EXCEL

    This video will show you How To Find FREQUENCY,MEAN,MODE,MEDIAN

in EXCEL

Video Tutorials