MSSQL - Getting all dates between from date and to date.

declare @col nvarchar(max) 

declare @query nvarchar(max)

declare @StartDate as date 

declare @EndDate as date 

set @StartDate = '2014-06-01'

set @EndDate = '2014-06-18'

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL DROP TABLE #TempTable

create TABLE #TempTable 

( 

      Rep_Date date 

) 

 

while @StartDate <= @EndDate 

begin 

 insert into #TempTable (Rep_Date) values(@StartDate) 

 set @StartDate = DATEADD(dd,1,@StartDate) 

end 

  

select * from  #TempTable 

 

drop table #TempTable  

C#.NET - BackgroundWorker that accepts more than one argument.

Class MyClass
{
     private string m_Username = string.Empty;
     private int m_Targetnumber;

     public MyClass(){}

     public string Username
     {
         get { return m_Username; }
         set { m_Username = value; }
     }

     public int TargetNumber
     {
         get { return m_TargetNumber; }
         set { m_TargetNumber = value; }
     }
 }



// setup/init:

BackgroundWorker startCallWorker = new BackgroundWorker();
startCallWorker.DoWork += new DoWorkEventHandler(StartCallWorker_DoWork);
...

MyClass thisClass = new MyClass();
thisClass.Username = "abcd";
thisClass.TargetNumber = 1234;
startCallWorker.RunWorkerAsync(thisClass);


// the handler:
private void StartCallWorker_DoWork(object sender, DoWorkEventArgs e)
{
     MyClass args = (MyClass)e.Argument;
     string userName = args.Username;
     string targetNumber = args.TargetNumber;
}

MSSQL - Communicating one database to another using opendatasource

Communicating one database to another using opendatasource.

Example;

select UserId , Username , EmployeeId

from OPENDATASOURCE('SQLOLEDB', 'Data Source=172.166.10.116; User ID=sa;Password=12345678').hrms.dbo.employee_list  

C#.NET - Check decimal value in DataGridView Cell

Where to use?

Check decimal value in DataGridView Cell.

Step 1: Add DataGridViewTextBoxColumn column in DataGridView.

Step 2: Add EditingControlShowing events in DataGridView

Code:

private void dgvClientBilling_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)

{

            System.Windows.Forms.TextBox txt = (System.Windows.Forms.TextBox)e.Control;

            txt.KeyPress += new KeyPressEventHandler(txt_KeyPress);

}

public void txt_KeyPress(object sender, KeyPressEventArgs e)

        {

            try

            {

                if ((e.KeyChar < '0' || e.KeyChar > '9') && (e.KeyChar != '\b') && (e.KeyChar != '.'))

                {

                    e.Handled = true;

                }

                else

                {

                    e.Handled = false;

                }

                if (Char.IsControl(e.KeyChar))

                {

                    e.Handled = false;

                }

                else if (Char.IsNumber(e.KeyChar) || e.KeyChar == '.')

                {

                    TextBox tb = sender as TextBox;

                    int cursorPosLeft = tb.SelectionStart;

                    int cursorPosRight = tb.SelectionStart + tb.SelectionLength;

                    string result = tb.Text.Substring(0, cursorPosLeft) + e.KeyChar + tb.Text.Substring(cursorPosRight);

                    string[] parts = result.Split('.');

                    if (parts.Length > 1)

                    {

                        if (parts[1].Length > 2 || parts.Length > 2)

                        {

                            e.Handled = true;

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                ExceptionHandler.HandleException(ex.ToString());

            }

        }

C#.NET - ContextMenuStrip Enable / Disable while opening

Where to use?

When there is a need to enable/disable particular menu we can use this code.

Control: ContextMenuStrip ( Name : cmsQA)

Event: ( Opening)

Code :

private void cmsQA_Opening(object sender, CancelEventArgs e)

{

            try

            {

                e.Cancel = !(lsvFiles.SelectedItems.Count > 0);

                if (lsvFiles.SelectedItems.Count == 1)

                {

                    cmsAllocation.Items["tsmAssignFile"].Enabled = false;

                    cmsAllocation.Items["tsmUpload"].Enabled = false;

                    cmsAllocation.Items["tsmChangeTemplate"].Enabled = false;

                    cmsAllocation.Items["tsmDelete"].Enabled = false;

                    int iIndex = 5;

                    int[] iAssigneFileStatus = new int[] { 1, 5, 9 };

                    if (iAssigneFileStatus.Contains(iIndex))

                    {

                        cmsAllocation.Items["tsmAssignFile"].Enabled = true;

                    }

                }

            }

            catch (Exception ex)

            {

                ExceptionHandler.HandleException(ex.ToString());

            }

        }

C#.NET - Loading combo box in DataGridView

DataGridview:

Loading combo box in DataGridView.

Code:

private void LoadCapcityUtilizationReport()

{

try

{

int iClientId = 0;

            DataTable dtCapcity = clsCommon.oAdmin.dtGetCapcityUtilizationReport(dtpCapacityFromDate.Value, iClientId);

                if (dtCapcity != null)

                {

DataTable dtClient = clsCommon.oAdmin.GetActiveClientNames();

                    if (dtClient != null)

                    {

                        DataRow dr = dtClient.NewRow();

                        dr["ClientId"] = "0";

                        dr["ClientName"] = "--Select--";

                        dtClient.Rows.InsertAt(dr, 0);

                        dgvColClient.DataPropertyName = "ClientName";

                        dgvColClient.HeaderText = "Client";

                        dgvColClient.ValueMember = "ClientId";

                        dgvColClient.DisplayMember = "ClientName";

                        dgvColClient.DataSource = dtClient.DefaultView;

                        dgvColClient.DefaultCellStyle.NullValue = dtClient.Rows[0]["ClientName"].ToString();

                    }

                    dGvCapacity.DataSource = dtCapcity.DefaultView;

                    dGvCapacity.Refresh();

                }

            }

            catch (Exception ex)

            {

                ExceptionHandler.HandleException(ex.ToString());

            }

        }

MSSQL - Optional parameter for procedure

ALTER PROCEDURE [dbo].[MyProcName]

    @Parameter1 INT = 1,

    @Parameter2 VARCHAR (100) = 'StringValue',

    @Parameter3 VARCHAR (100) = NULL

AS

begin

      select @Parameter1,@Parameter2,@Parameter3

end