database amount show on label

Hello Ganesh,

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

namespace YourNamespace
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // Connection string to your SQL Server database
            string connectionString = @"Data Source=xyz;Initial Catalog=YourDatabaseName;User ID=sa; Password=YourPassword";

            // SQL query to sum the values of a column salary from Employee table
            string query = "SELECT SUM(Salary) FROM Employee";

            // Create a new SqlConnection using the connection string
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // Open the connection
                connection.Open();
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    object result = command.ExecuteScalar();
                    if (result != null && result != DBNull.Value)
                    {
                       YourlabelName.Text = "Sum: " + Convert.ToString(result);
                    }
                    else
                    {
                      
                        YourlabelName.Text = "No data found";
                    }
                }
            }
        }
    }
}