HOST_NAME SQL Server Example

SQL Server > Built-In Functions > HOST_NAME


Represents the workstation name, name of computer connected to SQL Server.

SELECT HOST_NAME()

LINQ DataTable compare date VB.NET

VB.NET > Data > DataTable > Filter with LINQ

LINQ DataTable compare date VB.NET example

   Dim dt As DataTable = New DataTable("table")

        dt.Columns.Add("id", Type.GetType("System.Int32"))
        dt.Columns.Add("name", Type.GetType("System.String"))
        dt.Columns.Add("date_of_birth", Type.GetType("System.DateTime"))
 

        Dim dr As DataRow = dt.NewRow()

        dr("id") = 1
        dr("name") = "john"
        dr("date_of_birth") = #1/1/2000#
        dt.Rows.Add(dr)

        dr = dt.NewRow()

        dr("id") = 2
        dr("name") = "dan"
        dr("date_of_birth") = #9/11/1973#
        dt.Rows.Add(dr)

        Dim filteredTable As DataTable = (From n In dt.AsEnumerable()

                            Where n.Field(Of Date)("date_of_birth") = #9/11/1973#
                    Select n).CopyToDataTable()

DateAdd VB.NET Example

VB.NET > Functions > DateAdd

DateAdd: add or subtract a specified time interval from a date.

Example:

Label1.Text = Date.Now
Label2.Text = DateAdd(DateInterval.Day, 1, Date.Now)
Label3.Text = DateAdd(DateInterval.Month, 1, Date.Now)
Label4.Text = DateAdd(DateInterval.Year, 1, Date.Now)

LINQ FirstOrDefault C# Example

C# > LINQ > FirstOrDefault

Returns the first element of the sequence that satisfies a condition or a default value if no such element is found.

Example

string[] cars = { "audi", "ford", "mercedes", "dacia" };
string car = cars.FirstOrDefault(c => c == "ford"); //ford
car = cars.FirstOrDefault(c => c == "ford1"); //null

          

  

Single LINQ C# Example

C# > LINQ > Single

Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.

Example

            string[] cars = { "audi", "ford", "mercedes", "dacia" };
            try
            {
                string car = cars.Single(c => c == "ford");
            }
            catch (System.InvalidOperationException)
            {
                MessageBox.Show ("Car not found!");
            }

How To Programmatically Change Printer Settings for Internet Explorer and WebBrowser Control in C#

C# > Forms >  WebBrowser > ShowPrintPreviewDialog

How To Programmatically Change Printer Settings for Internet Explorer and WebBrowser Control in C#

Example:

Change margin right property.

string strKey = "Software\\Microsoft\\Internet Explorer\\PageSetup";

bool boolWritable = true;
string strName = "margin_right";
object oValue = "0";
RegistryKey oKey = Registry.CurrentUser.OpenSubKey(strKey, boolWritable);
oKey.SetValue(strName, oValue);
oKey.Close();

webBrowser1.ShowPrintPreviewDialog();

 

 

ROW_NUMBER SQL Server Example

SQL Server > Built-in Functions >  ROW_NUMBER

Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

Example:

CREATE TABLE #LocalTempTable(

       ID            int,
       Name   varchar(50),
       Salary int,
       DeptId int)

insert into #LocalTempTable(Id, Name, Salary, DeptId) values (1,'p1',100,1),  (2,'p2',200,1) ,  (3,'p2', 500,2)

SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) AS Row,

    Name, Salary
FROM
       #LocalTempTable;

-- specify number of rows

WITH tbl AS
(
    SELECT Id, Name,
    ROW_NUMBER() OVER (ORDER BY Salary) AS RowNumber
    FROM #LocalTempTable
)

SELECT Id, Name, RowNumber 
FROM tbl
WHERE RowNumber BETWEEN 1 AND 2;

drop table #LocalTempTable

CapsLock pressed C# example

C# > Controls > > IsKeyLocked

IsKeyLocked check if CAPS LOCK, NUM LOCK, or SCROLL LOCK key is are pressed.

Example:

public static bool CapsLockActive()

{
     return Control.IsKeyLocked(Keys.CapsLock);
}




 

What is ASP.NET

ASP.NET is a unified Web development model that includes the services necessary for you to build enterprise-class Web applications.

• System.Web

Get file name C# Example

C# > Files > GetFileName

Returns the file name and extension of the specified path string.

Example:

Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();

dlg.FileName = "Document";
dlg.DefaultExt = ".doc";
Nullable<bool> result = dlg.ShowDialog();
if (result == true)
{
     string filename = dlg.FileName;
     filename  = System.IO.Path.GetFileName(filename);
}

Autosize Control sized based on its text C# CilentSize

C# > Controls > ClientSize

ClientSize gets or sets the height and width of the client area of the control.

Example:
Autosize TextBox width and height  based on its text.

C# Code:

 private void AutoSizeControl(Control control)

        {
            Graphics g = control.CreateGraphics();
            Size size = g.MeasureString(control.Text, control.Font).ToSize();
            control.ClientSize = new Size(size.Width+10 ,size.Height);
            g.Dispose();
        }
        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            AutoSizeControl(textBox1); 
        }

C# Control Class

C# > Control class




Control is the base class for controls. 
Controls are components with visual representation.

• Location and Size
• ClientSize
• IsKeyLocked 

Int, bigint, smallint, and tinyint SQL Server

SQL Server > Data Types > Int, bigint, smallint, and tinyint

These type are exact number data types and use integer data.
The bigint data type is used when integer values exceed the range.

bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
int	-2,147,483,648 to 2,147,483,647
smallint	-32,768 to 32,767
tinyint	0 to 255

Example:

Use int type for primary key in a table

CREATE TABLE [dbo].[Table] (        [Id] INT NOT NULL PRIMARY KEY )

Decimal and numeric types SQL Server example

SQL Server > Data Types > decimal and numeric

Numeric is functionally equivalent to decimal.
They have fixed precision and scale.

precision: maximum total number of decimal digits (for both left and right)

scale: number of decimal digits that will be stored to the right of the decimal point.
Example:

declare @num numeric(20,5)
set @num = 1333.2
print @num

declare @num1 numeric(20,0)
set @num1 = 1333.2
print @num1

Result:
1333.20000
1333 

RadGrid for ASP.NET AJAX

Telerik > RadGrid

RadGrid for ASP.NET AJAX is a control for data, paging, sorting, filtering and data editing to grouping and displaying hierarchical data.

• GridHyperlinkColumn
• GridBoundColumn

RadPivotGrid ASP.NET example

Telerik > ASP.NET > RadPivotGrid

RadPivotGrid is a control used to aggregate records in a concise tabular format.

Example:

<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" DataSourceID="LinqDataSource1" AllowPaging="true" AllowFiltering="false" ShowFilterHeaderZone="false">

  <ClientSettings Scrolling-AllowVerticalScroll="true">
  </ClientSettings>
  <Fields>
         <telerik:PivotGridColumnField DataField="City">
     </telerik:PivotGridColumnField>
      <telerik:PivotGridColumnField DataField="Month">
      </telerik:PivotGridColumnField>
       <telerik:PivotGridRowField DataField="ProductName">
       </telerik:PivotGridRowField>
      <telerik:PivotGridAggregateField DataField="Quantity" Aggregate="Sum">
    </telerik:PivotGridAggregateField>
    </Fields>
</telerik:RadPivotGrid>


Creates directory C# example

C# > Files > Directory > CreateDirectory

Creates directory  in the specified path.

Example:

 

string dir = @"c:\dir1";

try
{
            if (!Directory.Exists(dir))
      {
              DirectoryInfo di = Directory.CreateDirectory(dir);
      }
}
catch (Exception ex)
{
       MessageBox.Show(ex.ToString());
}
finally {}