Search This Blog

Wednesday, March 19, 2014

DateDiff Visual Basic Example

VB.NET Functions > DateDiff

Returns a value specifying the number of time intervals 
between two dates.

Example:


Dim dt1 As Date = #3/1/2014#
Dim dt2 As Date = #4/1/2014#

MessageBox.Show("Day diff: " & DateDiff(DateInterval.Day, dt1, dt2) & " Week diff: " & DateDiff(DateInterval.Weekday, dt1, dt2))






Monday, March 17, 2014

C# Forms

C# > Forms

Contains classes for creating Windows-based applications using features available in the Microsoft Windows operating system.







Wednesday, March 12, 2014

MessageBox C# Example

C# > Forms > MessageBox

Examples:

A. Displays a message box with specified text.

    MessageBox.Show("Text message");

B. Displays a message box with specified text, caption, and buttons.

string message = "Do you want to close this windows?";
string caption = "Question";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
  this.Close();
}







Monday, March 10, 2014

AppActivate Visual Basic

VB.NET Functions > AppActivate

Activates an application that is already running.

Example:
Start and activate notepad

AppActivate(Shell("C:\Windows\System32\notepad.exe", AppWinStyle.NormalFocus))




CurDir Visual Basic

VB.NET Functions > CurDir 

Returns the current path.

Example:


MessageBox.Show(CurDir())







Thursday, March 6, 2014

C# Random Color

C# > Color > Random

Random rnd = new Random();


Color randomColor = Color.FromArgb(rnd.Next(255), rnd.Next(255), rnd.Next(255));





Change DataGridView column to Hyperlink Runtime

C# > DataGridViewDataGridViewLinkCell

Example: Change DataGridView column to Hyperlink Runtime


foreach (DataGridViewRow r in dgv.Rows)
{
DataGridViewLinkCell lc = new DataGridViewLinkCell();
       lc.Value = r.Cells[1].Value;
       dgv[1, r.Index] = lc;
}


private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
              return;
if (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex] is DataGridViewLinkCell)
       {
             string link = "http://www...";
             if(e.ColumnIndex == 1)
                System.Diagnostics.Process.Start(link  +                          dgv.Rows[e.RowIndex].Cells[4].Value as string);
       }

}