Point Readiness - Simple Reads

passing linq ersult

2013-12-30T08:29:00.002-08:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApplication5
{
class Program
{
static void Main(string[] args)
{

emp[] my_list = new emp[] { new emp(){ Emp_ID=1, Emp_Nam="mohamed", Emp_Mail="mo@hotmail.com" }, new emp(){ Emp_ID= 2 , Emp_Nam="ali" , Emp_Mail="ali@mail.com" } };

IEnumerable<emp> My_Result = from i in my_list
where i.Emp_ID == 1
select i;

action(My_Result);

}

static void action(IEnumerable<emp> items_result)
{
foreach (var x in items_result)
{
Console.WriteLine(x.Emp_ID);
Console.WriteLine(x.Emp_Nam);
Console.WriteLine(x.Emp_Mail);
}
}

}

class emp
{

public int Emp_ID { set; get; }
public string Emp_Nam { set; get; }
public string Emp_Mail { set; get; }

}

}

easy steps to install Visual Studio 2012

2013-02-15T13:48:00.000-08:00

and then enjoy !!

windows 8 enterprise step by step installation

2012-08-24T23:25:00.001-07:00

Simple steps to install windows 8 enterprise

it's not need to comment !

simple tour inside windows !

start screen

size of installed windows

start screen metro style

applications screen

if you need to play music

what about weather now !

it's not all about windows, try it now click here

C# Try catch .

2012-07-10T04:39:00.003-07:00

n If you need handling errors in your program use try/catch block .

n try/catch block can control the errors without exit program .

n try/catch block consists of two part

o Try Block : put all your code in this block .

o Catch Block : write code that will handling the error when it's occurred .

§ you can use type of Catch to control specific error.

· ArithmeticException : this catch specialized in numerical errors

· IndexOutOfRangeException : this catch specialized errors that occurred when an index is outside the boundary of an array .

§ You can have multi catch in your code each one specialized in specific error . in this case one block of catch can be occurred .

Example 1:

public void action()

{

try

{

int x = 5;

int y = 0;

int z = x / y;

}

catch

{

Console.WriteLine("an error occurred");

}

try

{

int x = 5;

int y = 0;

int z = x / y;

}

catch(ArithmeticException ex)

{

Console.WriteLine("your error is :");

Console.WriteLine(ex.Message);

}

Example 2 :

try

{

int[] x = new int[2];

x[0] = 85;

x[1] = 44;

x[2] = 33;

Console.WriteLine(x[2]);

}

catch(IndexOutOfRangeException e)

{

Console.WriteLine("your error is :");

Console.WriteLine(e.Message);

}

Example 3 :

public void action()

{

try

{

// write your code here

}

catch (IndexOutOfRangeException err)

{

Console.WriteLine("your error is :");

Console.WriteLine(err.Message);

}

catch (ArithmeticException ex)

{

Console.WriteLine("your error is :");

Console.WriteLine(ex.Message);

}

catch

{

Console.WriteLine("an error occurred");

}

Using StringBuilder

2012-05-15T15:38:00.000-07:00

Example 1

StringBuilder My_StringBuilder = new StringBuilder();

for (int x = 0; x < 10; x ++ )

{

My_StringBuilder.Append(x);

}

MessageBox.Show(My_StringBuilder.ToString());

Example 2

StringBuilder My_StringBuilder = new StringBuilder();

for (int x = 0; x < 10; x ++ )

{

My_StringBuilder.Append(x).Append(", ");

}

MessageBox.Show(My_StringBuilder.ToString());

Example 3

StringBuilder My_StringBuilder = new StringBuilder();

My_StringBuilder.AppendLine("list of Categories:");

My_StringBuilder.AppendLine("-------------------");

My_StringBuilder.Append("1-Category1").AppendLine();

My_StringBuilder.Append("2-Category2").AppendLine();

My_StringBuilder.Append("3-Category3").AppendLine();

MessageBox.Show(My_StringBuilder.ToString());

Example 4

StringBuilder My_StringBuilder = new StringBuilder("my string in my code");

My_StringBuilder.Replace("my", "your");

MessageBox.Show(My_StringBuilder.ToString());

Example 5

StringBuilder My_StringBuilder = new StringBuilder("my string in my code");

My_StringBuilder.Remove(9, 11);

MessageBox.Show(My_StringBuilder.ToString());

Working with LINQ

2012-05-12T05:11:00.000-07:00

Working with LINQ (1)

Write the following code inside button in windows form .

string[] names = { "Burke", "Connor", "Frank",

"Everett", "Albert", "George",

"Harris", "David" };

IEnumerable<string> query = from s in names

where s.Length == 5

orderby s

select s.ToUpper();

foreach (string item in query)

MessageBox.Show(item);

Working with LINQ (2)

Step 1 : Create database

create database HRDB

Step 2 : creating the following table

create table People (

Name nvarchar(32) primary key not null,

Age int not null,

CanCode bit not null

)

Step 3 : Add the following data into People table

Step 4 : Add the following two lines above class form .

using System.Data.Linq;

using System.Data.Linq.Mapping;

Step 5 : Write the following block of code into project

[Table(Name = "People")]

public class Person

{

[Column(DbType = "nvarchar(32) not null")]

public string Name;

[Column]

public int Age;

[Column]

public bool CanCode;

}

Step 6 : Design form .

Step 7 : inside Show Data button, write the following code .

DataContext context = new DataContext(

"Data Source=.;Initial Catalog=HRDB;Integrated Security=True");

Table<Person> custs = context.GetTable<Person>();

var query = from c in custs

select new

{

c.Name,

c.Age

};

foreach (var item in query)

{

listBox1.Items.Add(item.Name + "-" + item.Age);

}

Project Layers

2012-05-12T05:04:00.000-07:00

Any project should consist of three layer, Dataabase, Classes and forms layer. Each one of these layer contain objects that need to create and develop.

Application Life cycle developing components

Database Layer, Contains objects such as Database files, tables, View, Functions and Stored procedures. Programmer will create and develop each of these objects.

Database Layer Components.

1-DatabaseFiles: that will store all objects of the project.

2- Tables: tables created to storing row data and normalize it.

3-Stored Procedures: SPs or Stored Procedures keeps the actions that needed to be fired when project want.

4- Functions: Keeps all answers for all questions needed to be answered for project.

5- Views: project needs Views for displaying Reports.

After finishing Database layer, programmer needs to call these objects from application. To do that, programmer need to developing Classes Layer.

Classes Layer, created in the application development environment by Classes files. Each of class refer to one object in the database Layer.

For example, Emp_Tbl is a table object in the database layer. For manipulate with this object its need to create Class with name Cls_Emp, and so on with all tables in the database.

Classes Layer Components.

Create Class file for each table in the Database. Each class will contain blocks of code that will work with Store Procedures and Functions that associated with specific table.

ID	Database Layer		Classes Layer
ID	Table Name	Associated Objects (Store Procedures, Functions)	Blocks of code in Class (Methods)	Class Name
1	Dep_Tbl	Dep_Insert_SP	Dep_Insert	Cls_Dep
		Dep_Update_SP	Dep_Update
		Dep_Delete_SP	Dep_Delete
		Dep_SelectALL_Fun	Dep_SelectALL
		Dep_GetInfo_Fun	Dep_GetInfo
		Dep_GetMax_Fun	Dep_GetMax
2	…	…	…	…

On the other hand, Working with Forms layer need first finish the previous layer in order to avoid errors, change Requests issues and Work around.

Forms Layer, means Working with User interface of the project and how to let the application interface to communicate with database layer throw classes layer. Forms layer contains a set of files. Each file consists of set of controls that will display for user to let him interacting with data of project.

Forms layer Components.

One or more classes in the class's layer will be act with one form in the forms layer.

ID	Table Name	Class Name	From Name	Form Search
1	Dep_Tbl	Cls_Dep	Frm_Dep	Frm_Dep_Search
2	…	…	…	…

Microsoft Day Presentation.

2012-03-23T17:17:00.001-07:00

I prepare This presentation for new products of Microsoft. in fact it's a fast show, but it's important to know that is new about new products, and that is new trend of Microsoft in the near future about describing life !

i will let you now with Microsoft, Microsoft can show and describe it self :)

delegate in C#

2012-03-23T16:48:00.002-07:00

delegate void MyDelegate(string s);

class MyClass
{
public static void Hello(string s)
{
Console.WriteLine(" Hello, {0}!", s);
}

public static void Goodbye(string s)
{
Console.WriteLine(" Goodbye, {0}!", s);
}

public static void Main()
{
MyDelegate a, b, c, d;

// Create the delegate object a that references
// the method Hello:
a = new MyDelegate(Hello);
// Create the delegate object b that references
// the method Goodbye:
b = new MyDelegate(Goodbye);
// The two delegates, a and b, are composed to form c:
c = a + b;
// Remove a from the composed delegate, leaving d,
// which calls only the method Goodbye:
d = c - a;

Console.WriteLine("Invoking delegate a:");
a("A");
Console.WriteLine("Invoking delegate b:");
b("B");
Console.WriteLine("Invoking delegate c:");
c("C");
Console.WriteLine("Invoking delegate d:");
d("D");
}
}

Sending E-Mail by C#.NET, Simple steps

2011-09-11T03:46:00.000-07:00

Step 1 : Design Preparation.

we need the following design in windows application project.

the above forms for SMTP Configuration form and Sending Mail form.

Step 2 : Add the SMTP configuration class

add the following class in you project in order to make a SMTP configuration for your mail that we need to send.

public class cls_smtpConfiguration

{

public static string host;

public static int port;

public static int timeout;

public static bool enable_ssl;

public static string username_account;

public static string password_account;

}

this class has a values from SMTP Configuration form and will get it for Sending Mail form.

Step 3 : In the SMTP Configuration form
Add the following code in the button Save Setting in the SMTP Configuration form

cls_smtpConfiguration.host = textBox1.Text;
cls_smtpConfiguration.port = Convert.ToInt32(textBox2.Text);
cls_smtpConfiguration.timeout = Convert.ToInt32(textBox4.Text);
if (radioButton1.Checked == true)
{
cls_smtpConfiguration.enable_ssl = true;
}
else
{
cls_smtpConfiguration.enable_ssl = false;
}
cls_smtpConfiguration.username_account = textBox6.Text;
cls_smtpConfiguration.password_account = textBox5.Text;
this.Close();

The above code try to setting values from controls of form to members of cls_smtpConfiguration Class

Step 4 : In the Sending Mail form
follow the following steps under the Send mail button

Define the following line

System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();

System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient(cls_smtpConfiguration.host, cls_smtpConfiguration.port);

System.Net.Mail.Attachment attach;

message object : for setting values (from, to, body ....)

smtp object : for setting smtp configuration about from mail

attach object : for setting the attachement files that is required to be attached with mail .

Try to validate [mail from] and [mail to]

if (ValidateEmail(textBox2.Text) == true) { message.To.Add(textBox2.Text); }

else { MessageBox.Show("not valid mail");return; }

if (ValidateEmail(textBox1.Text) == true) {message.From = new System.Net.Mail.MailAddress(textBox1.Text); } else { MessageBox.Show("not valid mail"); return; }

Setting the following values

message.Subject = textBox3.Text;
message.Body = richTextBox1.Text;
smtp.Timeout = cls_smtpConfiguration.timeout;
smtp.EnableSsl = cls_smtpConfiguration.enable_ssl;
smtp.Credentials = new System.Net.NetworkCredential(cls_smtpConfiguration.username_account, cls_smtpConfiguration.password_account);

the following code for setting [attach] object all attachement that is exist in listbox1

if (listBox1.Items.Count > 0) { for (int i = 0; i < listBox1.Items.Count; i++) { attach = new System.Net.Mail.Attachment(listBox1.Items[i].ToString()); message.Attachments.Add(attach); } }

Final Step, sending mail

smtp.Send(message);

MessageBox.Show("message sended !!");

follow the following steps under the SMTP configure button

Form2 x = new Form2();
x.ShowDialog();

follow the following steps under the Select button

OpenFileDialog x = new OpenFileDialog();
x.ShowDialog();
listBox1.Items.Add(x.FileName);

How to validate E-mail by C#, Simple Steps

2011-09-11T02:23:00.000-07:00

Step 1: type the following reference in above your class form

using System.Text.RegularExpressions;

Step 2: Insert the following method in your application.

public bool ValidateEmail(string sEmail)
{
Regex exp = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
Match m = exp.Match(sEmail);
if (m.Success && m.Value.Equals(sEmail))
{
return true;
}
else
{
return false;
}
}

Step 3 : Call above method in any pace you want .

if (ValidateEmail(textBox2.Text) == true)
{
MessageBox.Show("valid mail");
}
else { MessageBox.Show("not valid mail"); }

How Row Verioning Works

2011-06-04T09:41:00.000-07:00

How MARS works

2011-06-04T09:36:00.000-07:00

VB.NET - ListView Class

2011-02-26T02:07:00.000-08:00

This example requires that you have added the code to a Form and call the method created in the example from the constructor or another method on the form. The example also requires that images named MySmallImage1, MySmallImage2, MyLargeImage1, and MyLargeImage2 are located in the root directory of drive C.

for more details : http://msdn.microsoft.com/en-us/library/system.windows.forms.listview.aspx

Private Sub CreateMyListView()

' Create a new ListView control.

Dim listView1 As New ListView()

listView1.Bounds = New Rectangle(New Point(10, 10), New Size(300, 200))

            ' Set the view to show details.
            listView1.View = View.Details
            ' Allow the user to edit item text.
            listView1.LabelEdit = True
            ' Allow the user to rearrange columns.
            listView1.AllowColumnReorder = True
            ' Display check boxes.
            listView1.CheckBoxes = True
            ' Select the item and subitems when selection is made.
            listView1.FullRowSelect = True
            ' Display grid lines.
            listView1.GridLines = True
            ' Sort the items in the list in ascending order.
            listView1.Sorting = SortOrder.Ascending
            ' Create three items and three sets of subitems for each item.
            Dim item1 As New ListViewItem("item1", 0)
            ' Place a check mark next to the item.
            item1.Checked = True
            item1.SubItems.Add("1")
            item1.SubItems.Add("2")
            item1.SubItems.Add("3")
            Dim item2 As New ListViewItem("item2", 1)
            item2.SubItems.Add("4")
            item2.SubItems.Add("5")
            item2.SubItems.Add("6")
            Dim item3 As New ListViewItem("item3", 0)
            ' Place a check mark next to the item.
            item3.Checked = True
            item3.SubItems.Add("7")
            item3.SubItems.Add("8")
            item3.SubItems.Add("9")
            ' Create columns for the items and subitems.
            ' Width of -2 indicates auto-size.
            listView1.Columns.Add("Item Column", -2, HorizontalAlignment.Left)
            listView1.Columns.Add("Column 2", -2, HorizontalAlignment.Left)
            listView1.Columns.Add("Column 3", -2, HorizontalAlignment.Left)
            listView1.Columns.Add("Column 4", -2, HorizontalAlignment.Center)
            'Add the items to the ListView.
            listView1.Items.AddRange(New ListViewItem() {item1, item2, item3})
            ' Create two ImageList objects.
            Dim imageListSmall As New ImageList()
            Dim imageListLarge As New ImageList()
            ' Initialize the ImageList objects with bitmaps.
            imageListSmall.Images.Add(Bitmap.FromFile("C:\MySmallImage1.bmp"))
            imageListSmall.Images.Add(Bitmap.FromFile("C:\MySmallImage2.bmp"))
            imageListLarge.Images.Add(Bitmap.FromFile("C:\MyLargeImage1.bmp"))
            imageListLarge.Images.Add(Bitmap.FromFile("C:\MyLargeImage2.bmp"))
            'Assign the ImageList objects to the ListView.
            listView1.LargeImageList = imageListLarge
            listView1.SmallImageList = imageListSmall
            ' Add the ListView to the control collection.
            Me.Controls.Add(listView1)
        End Sub 'CreateMyListView

Like Operator - VB.NET

2011-02-18T15:06:00.000-08:00

This example uses the Like operator to compare a string to a pattern. The result is a Boolean value representing whether the string fits the pattern.

Dim myCheck As Boolean
myCheck = "F" Like "F"   ' Does "F" match "F"? Returns True.
myCheck = "F" Like "f"   ' Does "F" match "f"? Returns False.
myCheck = "F" Like "FFF"   ' Does "F" match "FFF"? Returns False.
myCheck = "aBBBa" Like "a*a"   ' Does "aBBBa" have a "a" at the
   ' beginning, an "a" at the end, and any number of characters in
   ' between? Returns True.
myCheck = "F" Like "[A-Z]"   ' Does "F" occur in the set of
   ' characters from A to Z? Returns True.
myCheck = "F" Like "[!A-Z]"     ' Does "F" NOT occur in the set of
   ' characters from A to Z? Returns False.
myCheck = "a2a" Like "a#a"     ' Does "a2a" begin and end with an
   ' "a" and have any single-digit number inbetween? Returns True.
myCheck = "aM5b" Like "a[L-P]#[!c-e]" ' Does "aM5b" fit the following
   ' pattern: Begins with "a", has and character from the set L through
   ' P, followed byb any single-digit number, and finally contains any
   ' character excluded from the character set c through e. Returns True.
myCheck = "BAT123khg" Like "B?T*" ' Does "BAT123khg" fit the
   ' following pattern: Begins with "B", followed by any single
   ' character, followed by a "T" and finally zero or more characters
   ' of any type. Returns True.
myCheck = "CAT123khg" Like "B?T*" ' Does "CAT123khg" fit the
   ' following pattern: Begins with "B", followed by any single
   ' character, followed by a "T" and finally zero or more characters
   ' of any type. Returns False.

------------------------------------------
from : http://msdn.microsoft.com/en-us/library/swf8kaxw(v=vs.71).aspx