w3mentor

Displaying Content of a Text File in PHP

madhu — Sat, 17 Jul 2010 20:20:43 +0000

<?php $file='info.txt'; $fobj=fopen($file,"r"); $text=fread($fobj, filesize($file)); echo("<h2><font color='blue'>Displaying Content of a Text File</font><h2>"); echo("<br>"); echo("<font size=3>"); echo($text); echo("</font>"); fclose($fobj); ?>

Creating Constructors with Classes in PHP

madhu — Sat, 17 Jul 2010 20:18:31 +0000

<?php class student { var $name; var $age; var $grade; function student($n,$a,$g) { $this->name=$n; $this->age=$a; $this->grade=$g; } function display_info() { echo("<p>Name [...]

Example process of creating classes and objects in PHP

madhu — Sat, 17 Jul 2010 20:14:59 +0000

<?php class emp { var $name; var $address; var $dept; function assign_info($n,$a,$d) { $this->name=$n; $this->state=$a; $this->dept=$d; } function display_info() { echo("<p>Employee [...]

Using Custom Error Handler in PHP

madhu — Sat, 17 Jul 2010 20:10:03 +0000

<?php error_reporting(E_ALL); function ErrHandler($errorno, $errorstr, $errorfile, $errorline) { $display = true; $notify = false; $halt_script = false; $error_msg = "<br>The $errorno error is occurring at $errorline in $errorfile<br>"; switch($errorno) { case E_USER_NOTICE: [...]

Generating Errors Using the trigger_error() Function in PHP

madhu — Sat, 17 Jul 2010 20:08:42 +0000

The assert() function checks whether the divisor is zero or not. The error_log() function sends the message, Cannot perform division by zero, to the log file specified by the second parameter when the divisor is zero.<?php // set the error reporting level for this script error_reporting(E_USER_ERROR); if (assert($divisor == 0)) { error_log("Cannot perform division by zero", 3, "var/www/html/PHP_XML/error.log"); [...]

Using Nested Functions in PHP

madhu — Sat, 17 Jul 2010 20:06:42 +0000

<?php function msg() { echo("<center><h2>Displaying even numbers</h2></center><p><p>"); function displayeven() { $ctr=0; echo("<font size=4>"); for($i=2;$i<=100;$i+=2) { echo("$i    "); [...]

Example of User-Defined Function in PHP

madhu — Sat, 17 Jul 2010 20:03:14 +0000

<?php echo("<center><h2>Displaying even numbers</h2></center><p><p>"); function displayeven() { $ctr=0; echo("<font size=4>"); for($i=2;$i<=100;$i+=2) { echo("$i    "); $ctr++; if($ctr%10==0) { echo("<p>"); [...]

Using the for Loop in PHP

madhu — Sat, 17 Jul 2010 20:02:00 +0000

<?php echo("Prime Numbers between 1 and 30<p>"); //For loop from 1 to 30 for($var=1;$var<30;$var++) { $ctr=0; for($k=2;$k<=$var/2;$k++) { $d=$var%$k; if ($d == 0) { $ctr=1; [...]

Using the while Loop in PHP

madhu — Sat, 17 Jul 2010 20:00:43 +0000

<?php $a=2; echo("<p>Even Numbers from 2 to 30<p>"); while ($a <=30) { echo("$a <br>"); $a=$a+2; } ?>

Using the switch case Conditional Statement in PHP

madhu — Sat, 17 Jul 2010 19:59:27 +0000

<?php //Initializing variables $a = 10; $b = 5; echo("1. Addition <br>"); echo("2. Subtraction <br>"); echo("3. Multiplication <br>"); echo("4. Division <br>"); $ch=3; switch ($ch) { case 1: $d=$a+$b; echo("The sum of the two numbers is $d"); break; case 2: $d=$a-$b; echo("The difference of the two numbers is $d"); [...]

Find maximum of three numbers using IF ELSE in PHP

madhu — Sat, 17 Jul 2010 19:55:11 +0000

<?php $x=10; $y=20; $z=30; if($x > $y) { if($x > $z) { echo("The maximum number is "); echo("$x<p>"); } else { echo("The maximum number is "); echo("$z<p>"); } } else { [...]

Example of IN and NOT IN SQL Queries

madhu — Sat, 17 Jul 2010 15:29:28 +0000

SELECT id FROM stats WHERE position IN ('Manager', 'Staff') SELECT ownerid, 'is in both orders & antiques' FROM orders, antiques WHERE ownerid = buyerid UNION SELECT buyerid, 'is in antiques only' FROM antiques WHERE buyerid NOT IN (SELECT ownerid FROM orders)

what are DDL, DML and DQL?

madhu — Sat, 17 Jul 2010 13:51:11 +0000

DDL (Data Definition Language) refers to the CREATE, ALTER and DROP TABLE statements DML (Data Manipulation Language) refers to the INSERT, UPDATE and DELETE statements DQL (Data Query Language) refers to the SELECT statements DCL (Data Control Language) refers to the GRANT and REVOKE statements

How to fix SQL Network Interfaces, error: 26

madhu — Tue, 13 Jul 2010 19:21:17 +0000

You may get the following error when you have developed an application, and then you move your site to another server (like your web host’s server): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default [...]

What is a mnemonic?

madhu — Fri, 09 Jul 2010 20:27:44 +0000

What is a mnemonic? It is very difficult to understand a program if it is written in either binary or hex code. Thus the manufacturers have devised a symbolic code for each instruction, called a mnemonic.

What are the different jobs that the CPU is expected to do at any given point of time?

madhu — Fri, 09 Jul 2010 20:26:51 +0000

What are the different jobs that the CPU is expected to do at any given point of time? The CPU may perform a memory read or write operation, an I/O read or write operation or an internal activity.

How does the microprocessor communicate with the memory and input/output devices?

madhu — Fri, 09 Jul 2010 20:26:17 +0000

How does the microprocessor communicate with the memory and input/output devices? The microprocessor communicates with the memory and the Input/Output devices via the three buses, viz., data bus, address bus and control bus.

What are the three main units of a digital computer?

madhu — Fri, 09 Jul 2010 20:25:51 +0000

What are the three main units of a digital computer? The three main units of a digital computer are: the central processing unit (CPU), the memory unit and the input/output devices.

What is the technology used in microprocessors?

madhu — Fri, 09 Jul 2010 20:25:25 +0000

What is the technology used in microprocessors? NMOS technology is used in microprocessors.

What is a microprocessor?

madhu — Fri, 09 Jul 2010 20:25:06 +0000

What is a microprocessor? A microprocessor may be thought of as a silicon chip around which a microcomputer is built.

When was the first microprocessor developed?

madhu — Fri, 09 Jul 2010 20:24:44 +0000

When was the first microprocessor developed? The first microprocessor was developed by BUSICOM of Japan and INTEL of USA in the year 1971.

What is meant by distributed processing?

madhu — Fri, 09 Jul 2010 20:24:24 +0000

What is meant by distributed processing? Distributed processing involves the use of several microprocessors in a single computer system. For example, for such a system, the first microprocessor may control keyboard activities, the second controls storage devices like disk drives, the third controls input/output operations, while the fourth may act as the main system processor.

On which model is based the basic architecture of a digital computer?

madhu — Fri, 09 Jul 2010 20:23:59 +0000

On which model is based the basic architecture of a digital computer? The basic architecture of a digital computer is based on Von Neumann model.

Send a webrequest and display webresponse along with headers in C#

madhu — Thu, 08 Jul 2010 20:47:46 +0000

<%@ Import Namespace="System.IO" %> <%@ Import Namespace="System.Net" %> <script language="C#" runat="server"> void btnSubmit_OnClick(Object source, EventArgs e) { // Create a WebRequest WebRequest wrRequest; wrRequest = WebRequestFactory.Create(txtURL.Text); // Get the Response from the Request WebResponse wrResponse = wrRequest.GetResponse(); // Display the Request headers lblHTML.Text = "<b>Request Header Information:</b><br>"; foreach (String strHeader in wrRequest.Headers) lblHTML.Text += [...]

Sending Mail Using SMTP in C# .NET

madhu — Wed, 07 Jul 2010 16:13:57 +0000

In .Net, sending mail via SMTP is quite simple because all the references that you need to send mail have been incorporated by the IDE and a simple function would look as below:/// <summary> /// /// </summary> [...]

Force send receive action in C# Outlook Interop

madhu — Wed, 07 Jul 2010 16:12:07 +0000

//outlook functionality of send and receive .* enable send then disable * public void fnSendRecieve() { try { [...]

Read mail from a public folder using Outlook Interop in C#

madhu — Wed, 07 Jul 2010 16:10:09 +0000

public void fnReadMail() { try { [...]

Sending mail Using OutLook in C# ASP.NET

madhu — Wed, 07 Jul 2010 16:08:49 +0000

When you want to send e-mails in c# from .NET framework you have to import references that will enable your solution to communicate with outlook. You must have installed Microsoft office for you to import this references which is: Microsoft interop for outlook Depending on the version of outlook you have, for office 2003 the version [...]

Generate country list using CultureInfo class in C#

madhu — Wed, 07 Jul 2010 16:04:36 +0000

/// <summary> /// method for generating a country list, say for populating /// a ComboBox, with country options. We return the /// values in a Generic [...]

Check if the value is of type decimal in C#

madhu — Wed, 07 Jul 2010 16:03:45 +0000

public static bool validateDecimal(string ParNumber) { try { decimal result; [...]

Check if field is mandatory field in C# ASP.NET

madhu — Wed, 07 Jul 2010 16:03:19 +0000

The function expects you pass a string value and the column of a table to validate.private static bool IsMandatory(string text,string column) { try [...]

Check if date is valid (future date) in C#

madhu — Wed, 07 Jul 2010 16:02:22 +0000

public static bool validateDateNotFuture(string ParDate) { try { [...]

Regex to check for valid telephone number

madhu — Wed, 07 Jul 2010 16:01:46 +0000

public static bool validateTelePhone(string ParNumber) { if (!Regex.Match(ParNumber, @"^[1-9]\d{3}-[1-9]\d{3}-\d{4}$").Success) { return [...]

Check for valid percentage in C# .NET

madhu — Wed, 07 Jul 2010 15:59:26 +0000

public static bool validatePercentage(string ParNumber) { try { Convert.ToDecimal(ParNumber); [...]

Check for number in C#

madhu — Wed, 07 Jul 2010 15:58:53 +0000

public static bool validateNumber(string ParNumber) { try { Convert.ToInt32(ParNumber); [...]

Check if value is Money

madhu — Wed, 07 Jul 2010 15:58:23 +0000

public static bool validateMoney(string ParMoney) { try { Convert.ToDouble(ParMoney); [...]

Check if the value is of type Datetime

madhu — Wed, 07 Jul 2010 15:57:59 +0000

public static bool validateDate(string ParDate) { try { Convert.ToDateTime(ParDate); [...]

Computation of hashes

madhu — Wed, 07 Jul 2010 15:51:32 +0000

Generating hashing for files or keys is often used in programming to identify files, tables or other data collection types. There are different ways of doing this and some are efficient meaning the method of hashing is reliable unlike others which may generate similar keys for different types of bytes./// <summary> /// [...]

Of Type example in C# LINQ

madhu — Tue, 06 Jul 2010 19:18:01 +0000

The default OfType operator filters a collection of multiple object types that implements IEnumerable to return only the type of object specified by OfType ’ s argument. The following example filters an ArrayList of Product and Customer objects to return only Customer objects.ArrayList MixedArray = new ArrayList(); foreach (var p in ProductList) MixedArray.Add(p); foreach (var c in CustomerList) MixedArray.Add(c); var [...]

Making REST requests from PHP

madhu — Tue, 06 Jul 2010 19:14:31 +0000

The most simplest way is to use$data = json_decode( file_get_contents(“http://www.w3mentor.com/service.json”) );This example won’t work on servers that explicitly disable the URL opening behavior, mostly seen in shared hosting environment.

Cast an ArrayList to an IEnumerable object

madhu — Tue, 06 Jul 2010 19:05:58 +0000

The following examples generate an ArrayList containing Customer elements and cast the ArrayList to an IEnumerable object:ArrayList CustomersArray = new ArrayList(); foreach (var c in CustomerList) CustomersArray.Add(c); var query22 = from c in CustomersArray.Cast < Customer > () where c.Country == “USA” orderby c.CompanyName select new { c.CustomerID, c.CompanyName }; foreach (var c in query22) sbResult.Append(String.Format(“CustomerID = {0}, CompanyName = {0}\r\n”, c.CustomerID, c.CompanyName));

Left outer join example in LINQ C#

madhu — Tue, 06 Jul 2010 19:01:25 +0000

The following examples implement a left outer join of Customer with Order objects with default values supplied to display Customer objects that don’ t have corresponding Order objects.// Populate the default order instance Order emptyOrder = new Order { OrderID = 0, CustomerID = “XXXXX”, EmployeeID = 0, OrderDate = DateTime.Parse(“1/1/1900”), RequiredDate = DateTime.Parse(“1/1/1900”), ShipVia = 0, Freight [...]

Sort on multiple criteria with orderby using LINQ C#

madhu — Tue, 06 Jul 2010 14:53:50 +0000

using System; using System.Linq; class Account { public string FirstName { get; private set; } public string LastName { get; private set; } public double Balance { get; private set; } public string AccountNumber { get; private set; } public Account(string fn, [...]

Use orderby to retrieve the values in an int array in ascending order in LINQ

madhu — Tue, 06 Jul 2010 14:39:27 +0000

using System; using System.Linq; class OrderbyDemo { static void Main() { int[] nums = { 10, -19, 4, 7, 2, -5, 0 }; // Create a query that obtains the values in sorted order. [...]

LINQ where clause with substrings

madhu — Tue, 06 Jul 2010 14:35:46 +0000

using System; using System.Linq; class WhereDemo2 { static void Main() { string[] strs = { ".com", ".net", "someNameA.com", "someNameB.net", "test", ".network", "someNameC.net", "someNameD.com" }; // Create a query that obtains Internet addresses that [...]

Use multiple where clauses in LINQ C#

madhu — Tue, 06 Jul 2010 14:34:01 +0000

using System; using System.Linq; class TwoWheres { static void Main() { int[] nums = { 1, -2, 3, -3, 0, -8, 12, 19, 6, 9, 10 }; // Create a query that obtains positive values less than 10. var posNums = from n in nums [...]

Example of using Javascriptresult in MVC

madhu — Fri, 02 Jul 2010 20:00:22 +0000

The JavaScriptResult is used to execute JavaScript code on the client sent from the server.public ActionResult DoSomething() { script s = “$(‘#some-div’).html(‘Updated!’);”; return JavaScript(s); }Call using<%: Ajax.ActionLink(“click”, “DoSomething”, new AjaxOptions()) %> <div id=”some-div”></div>

ActionResult Types in ASP.NET MVC

madhu — Fri, 02 Jul 2010 19:58:53 +0000

EmptyResult Represents a null or empty response It doesn’t do anything ContentResult Writes the specified content directly to the response as text JsonResult Serializes the objects it is given into JSON and writes the JSON to the response RedirectResult Redirects the user to the given URL RedirectToRouteResult Redirects the user to a URL specified via Routing parameters ViewResult Calls into a [...]

Passing multiple parameters to action in MVC

madhu — Fri, 02 Jul 2010 19:52:49 +0000

For example, suppose that you have an action method that calculates the distance between two points:public void Distance(int x1, int y1, int x2, int y2) { double xSquared = Math.Pow(x2 - x1, 2); double ySquared = Math.Pow(y2 - y1, 2); Response.Write(Math.Sqrt(xSquared + ySquared)); }Using only the default route, the request would need to look like this: /simple/distance?x2=1&y2=2&x1=0&y1=0 We can improve on this [...]

Passing parameters to actions in ASP.NET MVC

madhu — Fri, 02 Jul 2010 19:49:23 +0000

You can pass in parameters to an action method by name via the query string. You can also pass in parameters via the URL segments, discoverable by position as defined in your routes.public class SimpleController : Controller { public void Goodbye(string name) { Response.Write(“Goodbye” + HttpUtility.HtmlEncode(name)); } }Invoke using /simple/goodbye?name=World or /simple/goodbye/world

Example of a simple controller

madhu — Fri, 02 Jul 2010 19:44:28 +0000

All public methods of a class that derive from Controller become action methods, which are callable via an HTTP request. The Hello action is invoked by going to http://localhost:port/simple/hellousing System; using System.Web; using System.Web.Mvc; public class SimpleController : Controller { public void Hello() { Response.Write(“<h1>Hello World!</h1>”); } }

Example of using AuthorizeAttribute with roles in MVC

madhu — Thu, 01 Jul 2010 20:39:44 +0000

The admin Controller is restricted to members of the Admins and SuperAdmins roles.[Authorize(Roles=”Admins, SuperAdmins”)] public class AdminController { //Only admins should see this. public ActionResult Index() { return View(); } //Only admins should see this. [...]

How does the AuthorizeAttribute work in ASP.NET MVC

madhu — Thu, 01 Jul 2010 20:36:52 +0000

The AuthorizeAttribute is the default Authorization fi lter included with ASP.NET MVC. We can use it to restrict access to an action method. Applying this attribute to a Controller is shorthand for applying it to every action method. When applying this attribute, we can specify a comma-delimited list of Roles or Users. If you specify a [...]

Four Action filters in ASP.NET MVC

madhu — Thu, 01 Jul 2010 20:33:48 +0000

Authorize: This filter is used to restrict access to a Controller or Controller action. HandleError: This filter is used to specify an action that will handle an exception that is thrown from inside an action method. OutputCache: This filter is used to provide output caching for action methods. RequireHttps: This filter, newly included in ASP.NET MVC 2, prevents [...]

Display HTML attributes with HTML.Textbox helper

madhu — Thu, 01 Jul 2010 20:12:50 +0000

To display HTML attributes,we should call an overload of the textbox helper that supplies an explicit value. If you want to use View data lookup in these cases, just pass in null to the TextBox helper.<%: Html.TextBoxFor(m => m.Name, "w3mentor" , new {@class=”mycssclass”}) %>Output:<input class=”mycssclass” id=”Name” name=”Name” type=”text” value=”w3mentor” />

Display explicit value in text box using Html.TextBox helper in ASP.NET MVC

madhu — Thu, 01 Jul 2010 19:55:03 +0000

The TextBox helper allows us to supply an explicit value and avoid View data lookup.<%: Html.TextBox(“Name”, “w3mentor”) %>Produces:<input id=”Name” name=”Name” type=”text” value=”w3mentor” />

Html.TextBox Helper in ASP.NET MVC

admin — Thu, 01 Jul 2010 19:50:52 +0000

The TextBox helper renders an input tag with the type attribute set to text. It is the most commonly used to accept free-form input from a user. Example:<%: Html.TextBox(“name”) %>Ouput:<input id=”name” name=”name” type=”text” value=”“ />Set the value in the controller:public ActionResult Edit(int id) { var product = new Product {Name = “ASP.NET MVC”} ViewData[“Name”] = product.Name; return View(); }Display in [...]

Difference between HttpUtility.HtmlEncode method and Html.Encode method

madhu — Thu, 01 Jul 2010 16:47:50 +0000

Html.Encode can accept an object where as HttpUtility.HtmlEncode method cannot accept an object. Also when an object is passed to Html.Encode, it is converted to a string using CultureInfo.CurrentCulture before being encoded.

Return a Model in the View method in ASP.NET MVC

madhu — Thu, 01 Jul 2010 16:35:44 +0000

In the Controller method, you can specify the Model via an overload of the View method whereby you pass in the Model.public ActionResult List() { var products = new List<Product>(); for(int i = 0; i < 10; i++) { [...]

Strongly typed views in ASP.NET MVC

madhu — Thu, 01 Jul 2010 15:32:07 +0000

Suppose that you have a list of Product instances you wish to display in a View. One means of doing this is to simply add the products to the View Data dictionary and iterate them over the View.public ActionResult List() { var products = new List<Product>(); for(int i = 0; [...]

Specify a View in a completely different directory structure to be rendered

madhu — Thu, 01 Jul 2010 15:20:15 +0000

You can use the tilde syntax to provide the full path to the View like so:public ActionResult Index() { ViewData[“Message”] = “Welcome to ASP.NET MVC!”; return View(“~/Some/Other/View.aspx”); }

How to make an action to render a different View in ASP.NET MVC

madhu — Thu, 01 Jul 2010 15:15:27 +0000

Suppose that you want the Index action to render a different View. You could supply a different View name like so:public ActionResult Index() { ViewData[“Message”] = “Welcome to ASP.NET MVC!”; return View(“NotIndex”); }

Intersect operator in C# LINQ

madhu — Wed, 30 Jun 2010 15:43:02 +0000

The Intersect SQO returns a sequence of elements that the first and second sequences contain; its method signature is the same as Union’s except for the method name.var query19 = (from p in ProductList where p.CategoryID == 1 || p.CategoryID == 2 select p) .Intersect(from p in ProductList where p.CategoryID == 2 || p.CategoryID == 3 select p) .OrderBy(p = > [...]

Union operator in C# LINQ

madhu — Wed, 30 Jun 2010 15:30:35 +0000

The Union SQO combines two sequences of the same structure into one without regard to matching values.var query18 = (from c in CustomerList join s in SupplierList on c.City equals s.City select new { c.City, c.CompanyName, Type = “Customer” }) .Union(from c in CustomerList join s in SupplierList on c.City equals s.City select new { s.City, s.CompanyName, Type = “Supplier” [...]

Distinct Set Operator in C# LINQ

madhu — Wed, 30 Jun 2010 15:25:49 +0000

The Distinct SQO removes elements with duplicate values from a sequence. The following example returns a list of unique country names from the CustomerList collection’s Country field.var query17 = (from c in CustomerList orderby c.Country [...]

Example of GroupBy with Query Expression Syntax in C# LINQ

madhu — Wed, 30 Jun 2010 15:14:55 +0000

var query16 = from c in CustomerList orderby c.Country, c.CustomerID group c by c.Country into g select new { Country = g.Key, Group = g }; foreach (var g in query16) { sbResult.Append(g.Group + [...]

Example of GroupBy with Method Call Syntax in C# LINQ

madhu — Wed, 30 Jun 2010 15:12:11 +0000

var query15 = CustomerList.GroupBy(c = > c.Country); query15 = CustomerList.OrderBy(c = > c.Country) .ThenBy(c = > c.CustomerID) .GroupBy(c = > c.Country); foreach (var g in query15) { [...]

OrderBy using CurrentCultureIgnoreCase in C# LINQ

madhu — Wed, 30 Jun 2010 14:56:00 +0000

var query14 = ProductList.Where(p = > p.Category.CategoryName == “Beverages”) .OrderBy(p = > p.ProductName, StringComparer.CurrentCultureIgnoreCase); foreach (var p in query14) [...]

ThenBy and ThenByDescending example in LINQ

madhu — Wed, 30 Jun 2010 14:54:27 +0000

var query13 = ProductList.OrderBy(p = > p.CategoryID) .ThenByDescending(p = > p.UnitPrice) .ThenBy(p = > p.ProductName); query13 = from p in [...]

Concat operator example in C# LINQ

madhu — Wed, 30 Jun 2010 14:22:44 +0000

var Query12 = CustomerList.Where(c = > c.Country == “USA”) .Concat(CustomerList.Where(c = > c.Country == “Canada”) .Concat(CustomerList.Where(c = [...]

Examples of a left outer join in LINQ

madhu — Wed, 30 Jun 2010 14:20:51 +0000

The following examples implement a left outer join of Customer with Order objects with default values supplied to display Customer objects that don ’ t have corresponding Order objects:Order emptyOrder = new Order { OrderID = 0, CustomerID = “XXXXX”, EmployeeID = 0, OrderDate = DateTime.Parse(“1/1/1900”), RequiredDate = DateTime.Parse(“1/1/1900”), ShipVia = 0, Freight = 0M, ShipName = “Default [...]

Concatenation Operator Example in C# LINQ

madhu — Tue, 29 Jun 2010 15:16:53 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var Query12 = CustomerList.Where(c => c.Country == "USA") .Concat(CustomerList.Where(c => c.Country == "Canada") [...]

Nested Left Outer Inner Join Example in C# LINQ

madhu — Tue, 29 Jun 2010 15:15:16 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); // Define default order instance Order emptyOrder = new Order { OrderID = 0, CustomerID = "XXXXX", EmployeeID = 0, [...]

Simple Flat Left Inner Join Example in C# LINQ

madhu — Tue, 29 Jun 2010 15:13:47 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var query10 = CustomerList.Join(OrderList, c => c.CustomerID, o => o.CustomerID, (c, o) => new { c.CustomerID, c.CompanyName, o.OrderID, o.OrderDate}) .Take(10); query10 = (from c in CustomerList [...]

SkipWhile/TakeWhile Example in C# LINQ

madhu — Tue, 29 Jun 2010 15:12:06 +0000

var query9 = CustomerList.Select((cust, index) => new { cust, index }) // .OrderBy(c => c.cust.Country) [...]

Skip/Take Example in C# LINQ

madhu — Tue, 29 Jun 2010 15:11:00 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var query8 = CustomerList.Select((cust, index) => new { cust, index }) .Where(c => c.cust.Country == "USA") [...]

SelectMany Translation for an Equi-join Expression in C# LINQ

madhu — Tue, 29 Jun 2010 15:09:31 +0000

var query7 = from c in CustomerList from o in OrderList where c.Country == "USA" && o.CustomerID == c.CustomerID [...]

Simple SelectMany Example with Associated Collection in C# LINQ

madhu — Tue, 29 Jun 2010 15:05:35 +0000

The SelectMany operator implements cross and outer joins, and flattens sequences into elements that resemble rows of relational views based on joins.SelectMany returns from the source object a many – to - one sequence having the set of properties specified by the selector that ’ s passed to the lambda function.var query6 = CustomerList.Where(c => c.Country == [...]

Multiple Select Projection with Index Values in C# LINQ

madhu — Tue, 29 Jun 2010 15:04:25 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var query5 = CustomerList.Select((cust, index) => new {cust, index}) .Where(c => c.cust.Country [...]

Simple Select Projection in C# LINQ

madhu — Tue, 29 Jun 2010 15:02:56 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var query4 = CustomerList.Where(c => c.Country == "USA") .Select(c => new { c.CustomerID, c.CompanyName, c.Country }); [...]

Where Method Call with Index Criterion in C# LINQ

madhu — Tue, 29 Jun 2010 15:01:13 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var query3 = CustomerList.Where((c, index) => c.Country == "USA" && index > 70); // Apply IndexOf() method, which achieves the same result and supports query expressions [...]

Compound Where Expression in LINQ

madhu — Tue, 29 Jun 2010 14:59:36 +0000

public List<Customer> CustomerList; StringBuilder sbResult = new StringBuilder(); var query2 = CustomerList.Where(c => c.Country == "USA" && c.Orders.Any()); query2 = from c in CustomerList where c.Country == "USA" && c.Orders.Any() select c; [...]

Simple Where expression example in Linq

madhu — Tue, 29 Jun 2010 14:52:54 +0000

Order class example

madhu — Tue, 29 Jun 2010 14:42:17 +0000

Order class:public class Order { public int OrderID; public string CustomerID; public int EmployeeID; public DateTime OrderDate; public DateTime RequiredDate; public DateTime ShippedDate; public int ShipVia; public decimal Freight; [...]

Windows impersonation for moving files in C#

madhu — Tue, 29 Jun 2010 14:20:47 +0000

When you have a system and you may want to move files in a secure environment without the users having to know the password to the destination machine. The following functions do this by using maintained username, password and domain from the database which can be encrypted and decrypted. For my case I have used [...]

Export to excel .csv file using C#

madhu — Tue, 29 Jun 2010 14:13:48 +0000

//additional references to import using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html; using iTextSharp.text.html.simpleparser; public static void Export_CSV(HttpResponse Response, GridView grid) { string filename = DateTime.Now.ToString("0:yyyyMMddhhmmss") + ".csv"; Response.Clear(); Response.Buffer = true; [...]

Export data from gridview to excel in C#

madhu — Tue, 29 Jun 2010 14:13:12 +0000

//additional references to import using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html; using iTextSharp.text.html.simpleparser; public static void Export_Excel(HttpResponse Response, GridView grid) { string filename = DateTime.Now.ToString("0:yyyyMMddhhmmss") + ".xls"; Response.ClearContent(); Response.Buffer = true; [...]

Export data from gridview to PDF in C#

madhu — Tue, 29 Jun 2010 14:12:21 +0000

//additional references to import using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html; using iTextSharp.text.html.simpleparser; public static void Export_PDF(HttpResponse Response, GridView grid) { string filename = DateTime.Now.ToString("0:yyyyMMddhhmmss") + ".pdf"; Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment; filename=" + filename); [...]

Exporting to microsoft word Using .NET from a GRIDVIEW

madhu — Tue, 29 Jun 2010 14:11:37 +0000

Exporting to word using contents from a bound grid view. Please follow the comments for further explanation.//additional references to import using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html; using iTextSharp.text.html.simpleparser; public static void Export_Word(HttpResponse Response, GridView grid) { //filename for file to be generated [...]

Audit Trail in C#

madhu — Tue, 29 Jun 2010 14:04:48 +0000

The following class expects an audit event which is passed as a string and can be but not limited to (Inserting, Updating, Deleting, Logging in e.t.c) and also a small description can be passed to the class. Inside the class sessions which store the logged in userID and the name as recognized by IIS are [...]

Download file from server and manipulate it using C#

madhu — Tue, 29 Jun 2010 14:04:01 +0000

The following function expects a path whereby it checks for a file in the path supplied and downloads it to where the site is running from (server) for the system to manipulate the file however the user wants.using System; using System.Collections; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; public class ClsDownload { [...]

Reset all controls of a web form in C#

madhu — Tue, 29 Jun 2010 14:02:14 +0000

using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Text.RegularExpressions; using System.Globalization; using System.Collections.Generic; /// <summary> /// Summary description for Constants_Audit /// </summary> public class Constants_Audit { public Constants_Audit() { // // TODO: Add constructor logic here [...]

Format a date passed as a string in C#

madhu — Tue, 29 Jun 2010 14:01:18 +0000

The following function formats a date passed as a string for you to be able to control the date type that you are familiar with. Dates sometimes can cause unnecessary errors that are quite hard to debug since different countries use different date types .public static string SQLDate(string date) [...]

Generate a list of objects and bind to a GridView in C#

madhu — Mon, 28 Jun 2010 20:00:06 +0000

The class:using System; public class Movie { public string Title { get; set; } public string Director { get; set; } public int Genre { get; set; } public int RunTime { get; set; } public DateTime ReleaseDate { get; set; } }<script runat="server"> protected void Page_Load(object sender, EventArgs e) { var movies = GetMovies(); this.GridView1.DataSource = movies; this.GridView1.DataBind(); } public List<Movie> GetMovies() { return new List<Movie> { new Movie { Title="Shrek", Director="Andrew [...]

What are the seven economic drivers? Briefly explain each

madhu — Fri, 25 Jun 2010 18:23:02 +0000

What are the seven economic drivers? Briefly explain each. Distance, Weight, Density, Stowability, Handling, Liability, and Market Distance- distance is a major influence on transportation cost because it directly contributes to variable expense, such as labor, fuel, and maintenance. Weight- the transport cost per unit of weight decreases as load size increases. Small loads should be consolidated [...]

Describe how load planning impacts transportation efficiency?

madhu — Fri, 25 Jun 2010 18:22:18 +0000

Describe how load planning impacts transportation efficiency? In the case of trucks, capacity is limited in terms of weight and cube. Planning the load sequence of a trailer must consider physical characteristics and the size of individual shipments, as well as delivery sequence if multiple shipments are loaded on a single trailer. This will affect the [...]

Describe the five modes of transportation, identifying the most significant characteristic of each

madhu — Fri, 25 Jun 2010 18:21:34 +0000

Describe the five modes of transportation, identifying the most significant characteristic of each. Rail, Highway, Water, Pipeline, and Air Rail-Railroads have handled the largest number of ton-miles in the United States to this day. A ton-mile is the standard measure of freight activity. The capability to efficiently transport large tonnage over long distances is the main and [...]

Railroads have the largest percentage of intercity freight ton-miles, but motor carriers have the largest revenue. How do you explain this relationship?

madhu — Fri, 25 Jun 2010 18:20:55 +0000

Railroads have the largest percentage of intercity freight ton-miles, but motor carriers have the largest revenue. How do you explain this relationship? While Railroads have the largest percentage of intercity freight-ton miles, this does not necessarily mean that they would have the largest revenue. While the railroads are hauling a greater amount of goods the costs [...]

Using the Cast operator with IEnumerable

madhu — Fri, 25 Jun 2010 16:25:31 +0000

System.Collections.ArrayList people = new System.Collections.ArrayList(); people.Add("Mani"); people.Add("Madhu"); IEnumerable<string> query = people.Cast<string>().Select(people => people); foreach (string people in query) Console.WriteLine(people);

Example of using the AsEnumerable operator

madhu — Fri, 25 Jun 2010 16:20:46 +0000

PersonDataAdapter.SelectCommand = someCommand; PersonDataAdapter.Fill(ds, "People"); var personinfo = (from pi in ds.Tables["People"].AsEnumerable() where pi.Field<string>("person_name").Equals(textbox1.Text) select pi); foreach (var pRow in personinfo) { //Display selected pRow elements… }