Friday, October 6, 2017

របៀប Select Crosstab Query on SQL Server

by Unknown  |  in Ms. SQL Server Trick at  9:32 AM

How to select data with cross-tab query with MS. Sql Server

របៀបច្រោះយកទិន្ន័យមកបង្ហាញតាមខែនីមួយៗ Cross-Tab Query ជាមួយ Ms. Sql Server

Read more »

Saturday, September 30, 2017

How to add pop up Calendar with JQuery on ASP.Net

by Unknown  |  in ASP.NET at  8:29 AM

How to add pop-up Calendar with JQuery on ASP.Net




1/ Source Code JQuery Calendar: Download JQuery Calendar

2/ Add 3 file to a folder on your project: 


3/ Add 3 link to header on Design view on ASP.Net



<head runat="server">
    <title>Report Current Stock Vs Target</title>
   <link href="jq/jquery-ui.css" rel="stylesheet" type="text/css" />
    <script src="jq/jquery-1.10.2.js" type="text/javascript"></script> 
    <script src="jq/jquery-ui.js" type="text/javascript"></script>  
</head>  


4/ Right Source Code on <script>....</script>

  <script>
              $(function () {
                  $("#datepickerFromDate").datepicker();
                  $("#datepickerToDate").datepicker();
              });
    </script>

5/ Call ID  #datepickerFromDate   and   #datepickerToDate to use on TextBox



    
   <asp:TextBox ID="datepickerFromDate" runat="server" Height="20px"                                                        Width="180px"></asp:TextBox>                                   

    <asp:TextBox ID="datepickerToDate" runat="server" Height="20px" 
             Width="180px"></asp:TextBox>                                  
                     

Friday, September 29, 2017

Select only Double Data to display [Ms-SQL Server]

by Unknown  |  in Ms. SQL Server Trick at  4:08 PM

How to select only Double Data to display on Ms. Sql Server


1/ Photo



2/ Coding


SELECT CustomerID,CustomerName,Phone
FROM dbo.tab_AR_Customer
WHERE CustomerID like'%KHV88%'
    AND Phone IN
   (SELECT Phone FROM dbo.tab_AR_Customer 
     WHERE CustomerID like'%KHV88%' and Phone<>'0' and Phone<>''
   GROUP BY Phone having count(Phone) > 1)
Order by Phone

Tuesday, September 26, 2017

របៀបកំណត់ Background Color, Font Name, Font Size, Alignment នៅលើ DataGridView [C#]

by Unknown  |  in C# Programming at  2:25 PM

របៀបកំណត់ Background Color, Font Name, Font Size និង កំណត់ Alignment នៅលើ DataGridView [C#]

Coding: 


 //*==== Set Background Color on header Column ===*//

  dgv.ColumnHeadersDefaultCellStyle.BackColor = Color.Gray;
  dgv.EnableHeadersVisualStyles = false;
  foreach (DataGridViewColumn col in dgv.Columns)
  {
   //*==== Set Font Name , Font Size, Aligment on DataGridView Column Hearder ====*//
        col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

        col.HeaderCell.Style.Font = new Font("Arial", 14F, FontStyle.Bold, GraphicsUnit.Pixel);
  }

របៀបដាក់លេខរៀងដោយស្វ័យប្រវិត្ត (Auto Number))នៅក្នុង DataGridView [C#]

by Unknown  |  in C# Programming at  2:05 PM

របៀបដាក់លេខរៀងដោយស្វ័យប្រវិត្ត (Auto Number))នៅក្នុង ​DataGridView [C#]



Coding: 

Note: DataGridView Name: dgv 
         DataTable Name: dt

                DataColumn No = new DataColumn("No", typeof(int));
                No.DefaultValue = false;
                dt.Columns.Add(No);
                No.SetOrdinal(0);
                dgv.DataSource = dt;
                foreach (DataGridViewRow r in dgv.Rows)
                {
                    //*=== auto number on column No ====*//
                    dgv.Rows[r.Index].Cells["No"].Value = (r.Index + 1).ToString();
                }

របៀបកំណត់ MIN Day និង Max Day តាមខែនីមួយៗ [C#]

by Unknown  |  in C# Programming at  1:42 PM

របៀបកំណត់ MIN Day និង Max Day តាមខែនីមួយៗ​ [C#]

របៀបកំណត់ MIN Day និង Max Day តាមខែនីមួយៗ​ នៅពេលដែលគេជ្រើសរើសយកតាមខែនីមួយៗ


Coding: 


private void cboPeriod_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                string year, month;
                cboPeriod.Tag = cboPeriod.SelectedValue.ToString();
                year = cboPeriod.Tag.ToString().Substring(0, 4);
                month = cboPeriod.Tag.ToString().Substring(4, 2);
                if (cboPeriod.Tag.ToString().Length <= 6)
                {
                    if (month == "01" || month == "03" || month == "05" || month == "07" || 
                        month == "08" || month == "10" || month == "12")
                    {
                        dtStartDate.Value = new DateTime(int.Parse(year), int.Parse(month), 1);
                        dtEndDate.Value = new DateTime(int.Parse(year), int.Parse(month), 31);
                    }
                    else if (month == "02")
                    {
                        dtStartDate.Value = new DateTime(int.Parse(year), int.Parse(month), 1);
                        dtEndDate.Value = new DateTime(int.Parse(year), int.Parse(month), 28);
                    }
                    else if (month == "04" || month == "06" || month == "09" || month == "11")
                    {
                        dtStartDate.Value = new DateTime(int.Parse(year), int.Parse(month), 1);
                        dtEndDate.Value = new DateTime(int.Parse(year), int.Parse(month), 30);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }  
        }
    }

របៀបប្តូរ Color នៅលើ Menu Strip នៅក្នុង MDI Form [C#]

by Unknown  |  in C# Programming at  9:43 AM

របៀបប្តូរ Color នៅលើ Menu Strip នៅក្នុង MDI Form [C#]

របៀបប្តូរ Background Color នៅលើ Menu, Sub Menu និង Border Color នៅលើ DropDownMenu

1/ Create Two Class


 Class 1: MyColors 

 private class MyColors : ProfessionalColorTable
        {
           //*** Select Color on Mouse Over on each Main Menu ***
            public override Color MenuItemSelectedGradientBegin
            {
                get { return Color.Orange; }
            }
            public override Color MenuItemSelectedGradientEnd
            {
                get { return Color.Yellow; }
            }
            //*** Set backgroud color on each selected Sub Menu Item ***
            public override Color MenuItemSelected
            {
                get { return Color.Gold; }   
                //get { return Color.Transparent; } 
                
            }
            //*** Set Border Color on Sub Menu Item ***
            public override Color MenuItemBorder
            {
                get { return Color.Green; }
            }
            //*** Set backgroud Color On Sub Menu Item to LightSeaGreen ***
            public override Color ToolStripDropDownBackground
            {
                get { return Color.LightSeaGreen; }
            }
            //*** Set lock backgroud color to Orange Yeallow when selected Main Menu ***
            public override Color MenuItemPressedGradientBegin
            {
                get {return Color.Orange;}
            }
            public override Color MenuItemPressedGradientEnd
            {
                get { return Color.Yellow; }
            }
            //==== Set backgroud Color on Sub Menu Item Image Backgroud ====
            public override Color ImageMarginGradientBegin
            {                
                //get { return Color.DeepSkyBlue; }
                 get { return Color.Gold; }
            }
            public override Color ImageMarginGradientMiddle
            {
                //get { return Color.Gold; }
                get { return Color.DarkCyan; }
               
            }
            public override Color ImageMarginGradientEnd
            {
                //get { return Color.DarkCyan; }
                //get { return Color.Gold; }
                get { return Color.DeepSkyBlue; }
              
            }
            
        }


 Class 2: MyRenderer 


 private class MyRenderer : ToolStripProfessionalRenderer
        {
            public MyRenderer() : base(new MyColors()) { }

            //protected override void OnRenderItemText(ToolStripItemTextRenderEventArgs e)
            //{
            //    // Here set e.TextFont, e.TextColor and so on, For example:
            //    if (e.Item.Selected && e.Item.OwnerItem != null)
            //    {
            //        //e.TextColor = Color.Green;
            //        e.TextFont = new Font(e.Item.Font, FontStyle.Regular);                    
            //        //e.TextFont = new System.Drawing.Font("Segoe UI", 11);
                    
            //    }
            //    base.OnRenderItemText(e);
            //}

        }


2/ Call  Class that we create to InitializeComponent();


public partial class frmMain : Form
    {
      
        public frmMain()
        {
            InitializeComponent();
           
            menuSO.Renderer = new MyRenderer();     

            menuSO.BackColor = Color.LightSeaGreen;
           
            statusStrip.BackColor = Color.LightSeaGreen;
                                   
            foreach (Control ctrl in this.Controls)
            {
                if (ctrl is MdiClient)
                {
                    ctrl.BackColor = Color.DimGray;
                }
            }          
        }
}

របៀប Select Max AutoNumber ដោយមានលក្ខ័ណច្រើនមកបង្ហាញក្នុង Row តែមួយ

by Unknown  |  in Ms. SQL Server Trick at  8:47 AM


របៀប​ Select Max AutoNumber  ដោយមានលក្ខ័ណច្រើនមកបង្ហាញក្នុង Row តែមួយ






-- 1 Create Temporary Table for store data --


      Create table #tbltmp(ProvinceCode nvarchar(10),CustomerID nvarchar(15),
                                      CustomerCode nvarchar(3),AutoNumber int)

 

-- 2 Select data from table for insert into Temporary Table -----


Insert Into #tbltmp

Select Province,CustomerID,
LEFT(CustomerID,3) AS 'CustomerCode',
MAX(CAST(SUBSTRING(CustomerID,6, LEN(CustomerID)) AS INT)) AS     
        AutoNumber 
From tab_Ar_Customer 
Where Active='Y' 
Group BY Province,CustomerID
Order By Province,CustomerID




-- 3 Select Max AutoNumber CustomerID by each ProvinceCode from table Temporary--



Select 
MAX(Case When ProvinceCode='BTM' Then AutoNumber End) AS BTM,
MAX(Case When ProvinceCode='BTB' Then AutoNumber End) AS BTB,
MAX(Case When ProvinceCode='KPC' Then AutoNumber End) AS KPC,
MAX(Case When ProvinceCode='KPCH' Then AutoNumber End) AS KPCH,
MAX(Case When ProvinceCode='KPSP' Then AutoNumber End) AS KPSP,
MAX(Case When ProvinceCode='KPT' Then AutoNumber End) AS KPT,
MAX(Case When ProvinceCode='KP' Then AutoNumber End) AS KP,
MAX(Case When ProvinceCode='KD' Then AutoNumber End) AS KD,
MAX(Case When ProvinceCode='KK' Then AutoNumber End) AS KK,
MAX(Case When ProvinceCode='KT' Then AutoNumber End) AS KT,
MAX(Case When ProvinceCode='M.KIRY' Then AutoNumber End) AS 'M.KIRY',
MAX(Case When ProvinceCode='PP' Then AutoNumber End) AS PP,
MAX(Case When ProvinceCode='PVH' Then AutoNumber End) AS PVH,
MAX(Case When ProvinceCode='PV' Then AutoNumber End) AS PV,
MAX(Case When ProvinceCode='PS' Then AutoNumber End) AS PS,
MAX(Case When ProvinceCode='RKR' Then AutoNumber End) AS RKR,
MAX(Case When ProvinceCode='SR' Then AutoNumber End) AS SR,
MAX(Case When ProvinceCode='SHN' Then AutoNumber End) AS SHN,
MAX(Case When ProvinceCode='ST-TR' Then AutoNumber End) AS 'ST-TR',
MAX(Case When ProvinceCode='SVR' Then AutoNumber End) AS SVR,
MAX(Case When ProvinceCode='TK' Then AutoNumber End) AS TK,
MAX(Case When ProvinceCode='Kep' Then AutoNumber End) AS Kep,
MAX(Case When ProvinceCode='PL' Then AutoNumber End) AS PL,
MAX(Case When ProvinceCode='ODMC' Then AutoNumber End) AS ODMC,
MAX(Case When ProvinceCode='TBK' Then AutoNumber End) AS TBK
From #tbltmp



4- Result:

Thursday, September 14, 2017

កម្មវិធី​ Microsoft Visual Studio Ultimate 2010 Full Setup

by Unknown  |  in កម្មវិធី Programming at  11:25 PM


កម្មវិធី Microsoft Visual Studio 2010 Ultimate គឺជាកម្មវិធីមួយដែលមានសារៈសំខាន់ខ្លាំងណាស់ សម្រាប់ អ្នកសរសេរកម្មវិធីនៅលើកុំព្យូទ័រ។ ហើយវាជាកម្មវិធីមួយដែលត្រូវបានបង្កើតឡើងដោយ ក្រុមហ៊ុន Microsoft ដែលវាបានផ្តល់នូវ Tools ជាច្រើនសម្រាប់យើងយកមក Design ទៅលើ Interface យ៉ាងស្រស់ស្អាត់ លើសពីនេះទៅទៀតយើងអាចយក លក្ខណៈ OOP មកប្រើទៀងផង។ ជាពិសេសលើសពីនេះទៅទៀតនោះ គឺយើងអាចយកវាទៅបង្កើតជា កម្មវិធីនៅលើកុំព្យូទ័រ បង្កើត ជាគេហទំព័រ និងកម្មវិធីនៅលើទូរស័ព្ទបានទៀតផង។

Read more »
Proudly Powered by Blogger.