IT Zone

MVC3 TryUpdateModel() -Update Model for Edit

2011-07-11T11:19:00.000-07:00

When we want to update model with edited values we can use TryUpdateModel() method.

example

[Httppost]
public ActionResult edit(int id)
{
    var user= UserRepository.GetUser(id);

    if (TryUpdateModel(user))
    {
        UserRepository.save();
    }

    return view()
}

But some times when we use TryUpdateModel() the model does not update that mean the method return false.So in that case we need to find out the error so we can do that as flowing it will return the list of errors and their corresponding properties.

[Httppost]
public ActionResult edit(int id)
{
    var user= UserRepository.GetUser(id);

    if (TryUpdateModel(user))
    {
        UserRepository.save();
    }
else{
//the tru update method return false
    
    var errors = ModelState
    .Where(m => m.Value.Errors.Count > 0)
    .Select(m => new { m.Key, m.Value.Errors })
    .ToArray();

}

    return view()
}

Why TryUpdateModel() return false ?

Most of the time the TryUpdateModel() method return false when we have not add editable field or hidden filed for all the required fields to view page.
so we can simply add hidden filed to the view which we don't need to change during the update method.

so My user Model

Public Class User{
[Requried]
public int UserId{get;set}
[Requried]
public string UserName {get;set}
[Requried]
pubic string UserCode{get;set}

pubic string Description{get;set}

public string Address{get;set}

}

So if I want to update UserDescription in my edit page
I have to put UserId,UserName and UserCode as Hidden filed

But if our model content large number of fields and we only need to update few of fields in that case we can do it by specify the fields which we need to update as following

TryUpdateModel(model, new [] {"Description", "Address"}); // In this case the TryUpdate() only  check vaidation "Description","Address"

And also we can do it as fallowing by mentioning the field which should not update

TryUpdateModel(model, null, null, new [] {"UserId","UserName ","UserCode"});//In this case the TryUpdate() ignore "UserId","UserName" and "Usercode" vaidation

Remove Validation Error messege when click Reset Button in MVC3 Razor

2011-07-04T00:07:00.000-07:00

The reset button does not clear validation message in mvc3 by default so we need to do this with jQuery.The fallowing function clear validation messages in MVC3 pages.
.

jQuery(document).ready(function () {

            $("input:reset").click(function () {
                $('.field-validation-error')
               .removeClass('field-validation-error')
                .addClass('field-validation-valid');

                $('.input-validation-error')
                .removeClass('input-validation-error')
                 .addClass('valid');
            });

  });

MVC 3 Razor TextBox max length

2011-06-27T01:46:00.000-07:00

@Html.TextBoxFor(model => model.Organization.OrganizationName, new { maxlength = 50 })

MVC 3 Razor Editor Template

2011-06-12T21:32:00.001-07:00

Editor Template is very useful future in Asp.net MVC3 Framework.With Editor Template we can create template for model and It can be access easily in the application (like user controller in asp.net).
So I'm going to create Editor Template for Book Model in my application.
Book.cs

public class Book
{
public int BookId { get; set; }
public string BookName { get; set; }
public string Description { get; set; }
}

Then I'm going to create folder as EditorTemplates in Shared folder and add new view Book.cshtml as following.(The Name of the Template should be same as Class Name)
.

@model MySimpleEditorTemplate.Models.Book


@Html.DisplayFor(p => p.BookId)  @Html.EditorFor(p => p.BookId)
@Html.DisplayFor(p => p.BookName) @Html.EditorFor(p => p.BookName)
@Html.DisplayFor(p => p.Description) @Html.EditorFor(p => p.Description)

Then in view page simply we can add editor for book as

@Html.EditorFor(model => model.Book)

then it will display above block

Accsess The Magento Core API With Dot net technologies

2010-10-06T10:02:00.000-07:00

Magento is one of the most popular e-commerce platforms.which based on PHP and Mysql.Magento Core API supports both SOAP and XML RPC protocols. The API is permission based and allows access to the Customer, Catalog and Order modules of Magento. Please reference the documentation for more information.
This article I am going to explaining How to access magento web service from Dot net Technologies .
we can access magento soap api with following url.
http://mymagento.com/api/v2_soap?wsdl (You can see wsdl definition by typing this url in web browser).
So let see how to display Magento customer list in my WindowsFormsApplication project.
To consume to the magento web service in our application we should add web Reference by rigth click on solution .

In the web reference dialog box type the magento web service URL (http://mymagento.com/api/v2_soap?wsdl) and click Go button then available service method display as following screen.
Then we can change the web service name and click Add Refference button.

By doing above steps,we can generate the web service proxy .
C# code to retrieve customer list.

 using Magento.com.mymagento

public void  showCustomrs(){
   MagentoService ms = new MagentoService();
   string sesion= ms.login("Dinesh", "123456");
   filters myfilter=new filters();//filter criteriya
   customerCustomerEntity[] cusls= ms.customerCustomerList(sesion,myfilter);//get customers
   dgCutomer.ItemsSource = cusls; //display in grid
}

How to Create WCF Application

2010-08-07T06:12:00.000-07:00

Select WCF Service Application from New Project window in Visual Studio and name the project as MyWCFService

Add WCF Service to the “MyWCFService” project and named as Myservice.svc

What is Service Contracts ?
Describe which operations the client can perform on the service. There are two types of Service Contracts.
ServiceContract - This attribute is used to define the Interface.
OperationContract - This attribute is used to define the method inside Interface.
IMyService.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.Text;


[ServiceContract]

public interface IService

{

    [OperationContract]

     Employeee GetEmployee(int id);// service method

      

}

Then we can implement above interface

MyService.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.Text;

using Common;

    public class MyService: IMyService

    {


        #region MyService Members


        public Employeee GetEmployee(int id)//service method implimentation

        {

 Employeee emp = new Employeee { EmpId = Guid.NewGuid(),Name="Dinesh",Type=EmployeeTypesEnum.Accounter };

                     return emp;

        }


        #endregion

    }

What is Data contracts?

Define which data types are passed to and from the service. WCF defines implicit contracts for built-in types such as int and string, but we can easily define explicit opt-in data contracts for custom types.
Types Supported by the Data Contract Serializer

There are two types of Data Contracts.
DataContract - attribute used to define the class
DataMember - attribute used to define the properties

Add Class Employee to the solution

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization;

using System.ServiceModel;


    [DataContract]

    public class Employeee

    {

        [DataMember]

        public Guid EmpId { get; set; }

        [DataMember]

        public string Name { get; set; }

        [DataMember]

        public EmployeeTypesEnum Type { set; get; }

    }

How To Pass Enum with WCF services?

To pass Enum the Data contracts should be define with EnumMember() attributes.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization;


 [DataContract]

   public enum EmployeeTypesEnum

    {

    [EnumMember()]


          Administrator = 0,


    [EnumMember()]


          Manager = 1,


    [EnumMember()]


          Accounter = 2


}

How to Test WCF application ?

WCF service can test with WCF Test Client (WcfTestClient.exe) by execute WcfTestClient.exe commond in Visual Studio Command prompt .

DATA ACCESS LAYER

2010-05-16T04:11:00.000-07:00

This is base class witch handle common function in Data Access Layer.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Web;
using System.Data.SqlClient;
using System.Data;

namespace DAL
{
public class DataHelper
{
private string Conncton_string = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString;
private SqlConnection sqlConn = new SqlConnection();
public static SqlParameter[] _dataParameters = null;
public DataHelper()
{
}

private SqlConnection openConnection()
{

sqlConn.ConnectionString = Conncton_string;
sqlConn.Open();
return sqlConn;

}
private void CloseConnection()
{
sqlConn.Close();
}

//For a execute non query
public void ExecuteNonQuery(CommandType commandType, string commandText, SqlParameter[] parameterCollection)
{
SqlCommand sqlCmd = new SqlCommand();
try
{
sqlCmd.Connection = openConnection();
sqlCmd.CommandType = commandType;
sqlCmd.CommandText = commandText;
sqlCmd.Parameters.AddRange(parameterCollection);
sqlCmd.ExecuteNonQuery();
sqlCmd.Parameters.Clear();
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
sqlCmd.Dispose();
}
}
//to get DataSet
public DataSet GetData(CommandType commandType, string commandText, SqlParameter[] parameterCollection)
{

SqlDataAdapter sqlAdp = new SqlDataAdapter();
DataSet dsItem = new DataSet();
SqlCommand sqlCmd = new SqlCommand();

try
{
sqlCmd.Connection = openConnection();
sqlCmd.CommandType = commandType;
sqlCmd.CommandText = commandText;
if(parameterCollection !=null)
sqlCmd.Parameters.AddRange(parameterCollection);
sqlAdp.SelectCommand = sqlCmd;
sqlAdp.Fill(dsItem);
return dsItem;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
sqlCmd.Dispose();
}
}

public int ExecuteScaler(CommandType commandType, string commandText, SqlParameter[] parameterCollection)
{
SqlCommand sqlCmd = new SqlCommand();
try
{
sqlCmd.Connection = openConnection();
sqlCmd.CommandType = commandType;
sqlCmd.CommandText = commandText;
sqlCmd.Parameters.AddRange(parameterCollection);
return Convert.ToInt32(sqlCmd.ExecuteScalar().ToString());

}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
sqlCmd.Dispose();
}
}

}
}

///this is the class derived from above class and execute Stored procedures
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entity;
using System.Data.SqlClient;
using System.Data;

namespace DAL
{
public class CustomerData:DataHelper
{
public void Save(Entity.Customer cus)
{
try
{
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Cus_name", cus.Cus_Name), new SqlParameter("@Cus_address", cus.Cus_Address), new SqlParameter("@Cus_no", cus.Cus_No)};
ExecuteNonQuery(CommandType.StoredProcedure, "INSERT_Customer", para);

}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(Entity.Customer cus)
{
try
{
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Cus_name", cus.Cus_Name), new SqlParameter("@Cus_address", cus.Cus_Address), new SqlParameter("@Cus_no", cus.Cus_No) };
ExecuteNonQuery(CommandType.StoredProcedure, "UPDATE_Customer", para);

}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
}

public DataSet SelectCustomerList()
{
try
{
return GetData(CommandType.StoredProcedure, "Select_Customers", null);

}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
}

public Customer SelectCustomer(string id)
{
try
{
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Cus_No", id) };
DataSet dsCus= GetData(CommandType.StoredProcedure, "Select_Customer", para);
Customer cus = new Customer();
cus.Cus_No = dsCus.Tables[0].Rows[0]["Cus_No"].ToString();
cus.Cus_Name = dsCus.Tables[0].Rows[0]["Cus_Name"].ToString();
cus.Cus_Address = dsCus.Tables[0].Rows[0]["Cus_Address"].ToString();
return cus;

}
catch (SqlException sqlEx)
{
throw sqlEx;
}
catch (Exception ex)
{
throw ex;
}
}
}
}

VS 2008 service pack offline version

2010-04-10T08:13:00.000-07:00

With fallowing link we can download VS2008 SP1 offline version and it is a .iso file so we need to burn it in to DVD and install with DVD ROM.
VS 2008 SP1

COPY EXCELL SHEET DATA TO MS SQL DATA BASE WITH C#.NET

2010-03-11T10:11:00.000-08:00

using System.Data.SqlClient;
using System.Data;
using System.Data.OleDb;

public class CopyExcellToMSSql
{
string _sourceConnectionString=;
string _destinationConnectionString;

public CopyExcellToMSSql(string sourceConnectionString,
string destinationConnectionString)
{
_sourceConnectionString =
sourceConnectionString;
_destinationConnectionString =
destinationConnectionString;
}

public void CopyTable(string Ftable,string Ttable)
{
using (OleDbConnection source =
new OleDbConnection(_sourceConnectionString))
{
string sql = string.Format("SELECT * FROM [{0}]",
Ftable);

OleDbCommand command = new OleDbCommand(sql, source);

source.Open();
IDataReader dr = command.ExecuteReader();

using (SqlBulkCopy copy =
new SqlBulkCopy(_destinationConnectionString))
{
copy.DestinationTableName = Ttable;
copy.WriteToServer(dr);
}
}
}
}

Calling above method

public void CopyData{
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Documents and Settings\\Dinesh\\Desktop\\D-Garment\\work detailes.xls; Extended Properties=""Excel 8.0;HDR=Yes"";";

string sqlConnectionString ="Data Source=KIT\MYSERVER; Initial Catalog=EMS;User ID=ems; Password=ems123";

CopyExcellToMSSql cpLogic = new CopyExcellToMSSql(excelConnectionString, sqlConnectionString);
cpLogic.CopyTable("Employee$", "TempEMPLOYEE");// Employee is work sheet and "TempEMPLOYEE" is table

Insert Multiple Rows to Table in SQL

2010-02-17T21:49:00.000-08:00

INSERT INTO [tabale1]
([col1]
,[col2]
,[col3]
,[col4])

(SELECT '11','1','1','1' UNION ALL 
SELECT '22','2','2','2')

How to call Dynamic Javascript Function from Gridview - Asp.Net

2009-11-02T22:16:00.000-08:00

We can call dynamic java script function from grid view as fallow.say we need to call following java script function dynamically from gride view then we need to create java script function in .aspx page.

<script type="text/jscript">
function funcShow(id)
{
aleart(id);
}
</script>

After that we have to add Template filed with Hyperlink filed to Grdeview as fallowing

<asp:GridView ID="dg1" runat="server"                      
<Columns>
<asp:BoundField DataField="FileName" HeaderText="Description">
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
<asp:HyperLink ID="HyperLink3" runat="server" NavigateUrl='<%# RetrunClick(Eval("ID"))%>'>Click</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

Then we need to add following function to the code behind page that will call the java script function .

public string RetrunClick(object obj)
{
string str = string.Empty;
if (obj != null)
{
str = "javascript:funcShow('" + obj.ToString() + "')";
}
return str;
}

Calculate Running Sum of the Texboxses in the ASP.NET with Javascript

2009-10-14T04:19:00.000-07:00

If we need to get running total of the text boxes in asp.net page while allowing automatically calculate the sum when changed the any text box .
Ex:
we have 3 Text Boxes as "txtCallCharges","txtRentTaxies","txtTotalAmount" and we need to get sum of the entered values to the "txtTotalAmount" text box .and also It should be allowed to automatically get total when text changed in nay text box.
Solution:
Add following code to the Code behind page.

protected override void OnLoad(EventArgs e)
{
txtCallCharges.Attributes.Add("onblur", "javascript:calculateTotal();");
txtRentTaxies.Attributes.Add("onblur", "javascript:calculateTotal();");
}

Then add following javascript to .aspx page

function calculateTotal()
{
var ctrl1 = null;
var ctrl2=null;
var ctrl3=null;          
ctrl1= document.getElementById("<%=txtCallCharges.ClientID %>");
ctrl2= document.getElementById("<%=txtRentTaxies.ClientID %>");
ctrl3= document.getElementById("<%=txtTotalAmount.ClientID %>");
var total =null;
if(ctrl1.value != "")
{
total=total+parseFloat(ctrl1.value);
}
if(ctrl2.value != "")
{
total=total+parseFloat(ctrl2.value);
}
ctrl3.value= total;
}

Update multiple columns of one table from another table- SQL

2009-10-08T03:38:00.000-07:00

UPDATE [tableA]
SET
A1 = B.B1+B.B2,
A2=B.B3
FROM tableA, tableB as B WHERE tableA.ID = B.ID

Refresh a content page without refreshing master page Vs Avoid flicker when click on the link

2009-06-18T03:17:00.000-07:00

The master page class derives from the UserControl class. When the application is executing, the master page just like a child control. So we can say the master page is not a true page. “.And, when the page loads, we can notice the navigationURL of the Browser address bar is the content page's, but not the master page's.Because of that we cannot refresh a content page without refreshing master page .But we can avoid flickering with fallowing code by put one <HEAD> tag in the master page.

<meta http-equiv="Page-Enter" content="blendTrans(Duration=0)"/>

<meta http-equiv="Page-Exit" content="blendTrans(Duration=0)"/>

ASP.NET Master page Set Background Image to Table

2009-06-05T03:16:00.000-07:00

Problem :When we set ASP Net - Master Page background image it only visible from pages in root directory
Solution : The images which are used in Masterpage should be set in the code behind file as fallow .
The runat='Server" attribute should be added to the controller which are going to set background image and ID should be set to that controller.
<td runat="server" id="tb1">set back ground image with code</td>

In the code behind page image should be set using ResolveClientUrl() method
protected void Page_Load(object sender, EventArgs e)
{
tb1.Style[HtmlTextWriterStyle.BackgroundImage] = ResolveClientUrl("~/App_Themes/Images/1-sri-lanka.JPG");
}

Sql Date Time Formatting

2009-06-02T02:39:00.000-07:00

Remove Time Part From DateTime
---------------------------------
SELECT GETDATE() /// 2009-06-25 12:03:56.640
Declare @mydate DATETIME
SET @mydate=GETDATE()

-------------------------------------

1.Get Out put as Type of DateTime with zero time
SELECT DATEADD(day, DATEDIFF(day, '20000101',@mydate), '20000101')
or
SELECT DATEADD(DAY, 0, DATEDIFF(DAY,0,@mydate))
or
SELECT DATEADD(dd, DATEDIFF(dd, 0, @mydate), 0)

out put :2009-06-25 00:00:00.000

2.Get Out put as Type of Varchar without time

SELECT CONVERT(VARCHAR(10),@mydate, 103)
out put :25/06/2009

Or
SELECT CONVERT(VARCHAR(10), @mydate, 120)
out put :2009-06-25

Unique Identifier In .Net & SQL

2009-05-10T22:23:00.000-07:00

A GUID (Globally Unique Identifiers) is a 128-bit integer (16 bytes) that can be used across all computers and networks wherever a unique identifier is required. Such an identifier has a very low probability of being duplicated. In the .NET framework the System.Guid.NewGuid method is used to generate the unique identifiers.

System.Guid desiredGuid = System.Guid.NewGuid();

This desiredGuid can be directly save to DB. The data type of the filed should be “uniqueidentifier” or we can cast it as string …. And also we can store GUID in “System.Guid” data type variable(C#).

convert GUID to Sting

System.Guid desiredGuid = System.Guid.NewGuid();
string a=desiredGuid.ToString();

convert a string to a GUID

Guid MyGuid = new Guid(stringValue);

In SQL Server, the “uniqueidentifier” data type is used to store the GUIDs and newid() function will generate GUID.

TypeForwardedTo (.NET)

2009-03-19T22:59:00.000-07:00

We can use this class to move type from one assembly to another while not disrupting the callers compile against the original assembly .
Example : we have a source library (say lib.dll) which included lot of classes and we have use that class library for our application development. After some period of time the we refastening the source library (lib.dll) and it splits in to two source library to (say lib.dll and lib1.dll) .Then what happen to our application will it work? No because our application point to the lib.dll but some of the classes have move to lib1.dll to. So our application will generate error .To prevent this we can use “TypeForwardedTo”


Following 2 classes define in lib.dll
using System;
using System.Collections.Generic;
using System.Text;
namespace lib
{
  public class car
  {
      public static void Do()
      {
          System.Console.WriteLine("car");

      }
  }
      public class van
      {
      public static void Do()
       {
          System.Console.WriteLine("van");       
       }
      }
}

Then the develop application using above lib.dll as following


using System;
using System.Collections.Generic;
using System.Text;
using lib;

namespace ConsoleApplication3
{
  class Program
  {
      static void Main(string[] args)
      {
          car.Do();
          van.Do();
          Console.ReadLine();
        
      }
  }
}

The Out put is :
car
van

Now we split above lib.dll to 2 dll to as following


lib.dll
using System;
using System.Collections.Generic;
using System.Text;
namespace lib
{
  public class car
  {
      public static void Do()
      {
          System.Console.WriteLine("car");

      }
  }     
}

lib1.dll
using System;
using System.Collections.Generic;
using System.Text;
namespace lib1
{
  public class van
  {
      public static void Do()
      {
          System.Console.WriteLine("van");

      }
  }
}

Then replace the above lib.dll with new two dlls. Now what happen, the van class can’t find in new lib.dll so it generate and error.
So prevent such a error we ca use
“System.Runtime.CompilerServices.TypeForwardedTo” as following
Open the lib project and Open the AssemblyInfo.cs file and add the following line right after the assembly directives.


[assembly: TypeForwardedTo(typeof(lib1.van))]

now build projecj.
Now we have 2dlls, lib.dll and lib1.dll but we can still run oure previouse application without any error .....

SQL Select First and Last 100 Record

2009-02-11T20:40:00.000-08:00

Select first 100 Records
SELECT RecordId
FROM Table
LIMIT 100

Select Last 100 Records
SELECT RecordId
FROM Table
ORDER BY RecordId DESC
LIMIT 100

Event and Delegates -Capture Master Page Events in Content Pages

2008-07-03T04:56:00.000-07:00

In This article, I explain how to use event and delegate to capture Master page event at content page.
Case :The master page (MasterPage.master.cs) Content drop down list .When The dropdown selected index change the selected value must be display in content page labels.
How to Do:
1. we develop master page as usual .Then top of code behind page of the master page, we have to declare Delegate and also have to declare public event in the class which type of previous delegate .Next step is declaring virtual method that used to handle the event ,Then we have to call the above method at the event of controller(drop down list ).
2.Develop content page and put following code at the top of .aspx page
3. In the code behind file of content page we have to write method capture to the master page event and in the page load event we have to add event handaler to call .
MasterPage.master.cs
This is Master Page with content Drop down list


<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns= " http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Master test</title>
</head>
<body>
<form id="form1" runat="server">
<div style="width: 158px; height: 414px; background-color: gray">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" Width="150px">
<asp:ListItem Value="a"></asp:ListItem>
<asp:ListItem>b</asp:ListItem>
<asp:ListItem>c</asp:ListItem>
</asp:DropDownList>
</div>
<div style="left: 168px; width: 638px; position: absolute; top: 17px; height: 410px">
<asp:contentplaceholder id="ContentPlaceHolder1" runat="server">
</asp:contentplaceholder>
</div>
</form>
</body>
</html>

class MasterPage
Then Put following codes in page behined file of the master page


using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//declare delegates for Master Page Events
public delegate void mstDelegate(object sender, System.EventArgs e);
public partial class MasterPage : System.Web.UI.MasterPage
{

private string slectedValue;
public string SlectedValue
{
get { return slectedValue; }
set { slectedValue = value; }
}
// declare Public Events type of above delegate
public event mstDelegate DropDownEvent;
protected void Page_Load(object sender, EventArgs e)
{

}
// impliment virtual method to handel above event
protected virtual void OnDropDownClick(EventArgs e)
{
if (DropDownEvent != null)
{
//Invokes the delegates.
DropDownEvent(this, e);
}
}
// DropDownList1_SelectedIndexChanged event
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SlectedValue = DropDownList1.SelectedValue;
OnDropDownClick(e);
}

}

Create Test page
testevent.aspx


<%@ MasterType virtualPath="~/MasterPage.master"%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="testevent.aspx.cs" Inherits="testevent" Title="test Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:Label ID="lblOutput" runat="server" Text="Label" Width="244px"></asp:Label>
</asp:Content>
Code behind file of test page
Testevent.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class testevent : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
// create instant of Master event
Master.DropDownEvent += new mstDelegate(mstDDLClick);

}
/// method for catch Master Page menu click event
void mstDDLClick(object sender, EventArgs e)
{
lblOutput.Text = Master.SlectedValue;
}

}

Set a Date Format In GridView Using ASP.NET

2008-06-02T05:11:00.000-07:00

Following code explain How to format date in ASP.Net Gride view

< asp :GridView ID=“GridView1″ runat=“server” >
< columns >
< asp :BoundField DataField=“CreationDate”
DataFormatString=“{0:dd-MM-yyyy}”
HtmlEncode=“false”
HeaderText=“CreationDate” />
< /columns >
< /asp >

Passing Parameters to Crystal Reports

2008-04-21T05:48:00.000-07:00

It is seam to be passing parameters to crystal reports (without prompting Enter to parameter values) programmatically some what confusing. So in this article I’ll explain Step by step “how to pass parameters to crystal reports”. We need to import following namespace.
using CrystalDecisions.CrystalReports.Engine;

Then following code pass the parameter value to crystal reports.

protected void Page_Load(object sender, EventArgs e){
this.CrystalReportViewer1.ParameterFieldInfo.Clear();
ParameterDiscreteValue desValue1= new ParameterDiscreteValue();
desValue1.Value = "Testing";// set value for parameter
ParameterField paraFld = new ParameterField();
paraFld.Name = "User";// this is parameter name
paraFld.CurrentValues.Add(desValue1);
paraFld.HasCurrentValue = true;
this.CrystalReportViewer1.ParameterFieldInfo.Add(paraFld);
this.CrystalReportViewer1.ShowFirstPage();
}

If we have more than two parameters it is bit difficult .So we can write common Method to passé parameters to crystal report as follow.

Public Void SetParameter(string ParaName ,string ParaValue)
{
ParameterDiscreteValue desValue= new ParameterDiscreteValue();
desValue. Value= ParaValue;
ParameterField paraFld = new ParameterField();
paraFld.Name = ParaName;
paraFld.CurrentValues.Add(desValue);
paraFld.HasCurrentValue = true;
CrystalReportViewer1.ParameterFieldInfo.Add(paraFld);

}

By using above method we can pass any number of parameters very easily.
As following (Think, ReportName and Createdby are two parameters which we defined in crystal reports) Then

protected void Page_Load(object sender, EventArgs e)
{
this.CrystalReportViewer1.ParameterFieldInfo.Clear();
SetParameter(“ReportName”,”My First Report”);// SetParameter(“Createdby”,”Dinesh”);
this.CrystalReportViewer1.ShowFirstPage();

}

}

Log4j

2008-01-12T02:10:00.000-08:00

Inserting log statements into your code is a low-tech method for debugging it. It may also be the only way because debuggers are not always available or applicable. This is often the case for distributed applications.

With log4j it is possible to enable logging at runtime without modifying the application binary. The log4j package is designed so that these statements can remain in shipped code without incurring a heavy performance cost. Logging behavior can be controlled by editing a configuration file, without touching the application binary.
so first we need to download log 4j jar file and put it into lib directory .
http://logging.apache.org/log4j/1.2/download.html"

Configure Log4j with Xml file
To configure log4j only we need to copy following log4j.xml file to src folder of project. And edit the location which the log message should be write as
< param name="File" value="../webapps/myporject/info.log > in the log4j.xml file .

log4j.xml


< ? xml version="1.0" encoding="UTF-8" ?>
< !DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
< log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j / ' >

  < appender name="STDOUT" class="org.apache.log4j.ConsoleAppender" >
    < layout class="org.apache.log4j.PatternLayout">
          < param name="ConversionPattern" value="%p-- %c %d{ISO8601}-- %m%n" / >
    < /layout>
  < /appender>

  < appender name="INFO" class="org.apache.log4j.RollingFileAppender">
     < param name="File" value="../webapps/myporject/info.log"/> // the location and file name
     < param name="Append" value="true" / >
     < param name="MaxFileSize" value="5000KB" / >
     < param name="MaxBackupIndex" value="2"/>
    < layout class="org.apache.log4j.PatternLayout">
          < param name="ConversionPattern" value=" %p --%c-- %d{ISO8601} -- %m%n" / >
    < /layout>
    < filter class="org.apache.log4j.varia.LevelRangeFilter" >
      < param name="LevelMin" value="INFO"  / >
    < /filter>
  < /appender>

  < appender name="DEBUG" class="org.apache.log4j.RollingFileAppender >
     < param name="File" value=" value="../webapps/myporject/logs/debug.log"/ >
     < param name="Append" value="true"/>
     < param name="MaxFileSize" value="5000KB"/ >
     < param name="MaxBackupIndex" value="2"/  >
    < layout class="org.apache.log4j.PatternLayout"  >
          < param name="ConversionPattern" value=" %p--%c %d{ISO8601} -- %m%n"/  >
    < /layout>
    < filter class="org.apache.log4j.varia.LevelRangeFilter"  >
      < param name="LevelMin" value="DEBUG" /  >
    < /filter>
  < /appender>

  < appender name="FATAL" class="org.apache.log4j.RollingFileAppender"  >
     < param name="File" value=" value="../webapps/myporject/logs/fatal.log"/  >
     < param name="Append" value="true"/  >
     < param name="MaxFileSize" value="5000KB"/  >
     < param name="MaxBackupIndex" value="2"/  >
    < layout class="org.apache.log4j.PatternLayout">
          < param name="ConversionPattern" value=" %p--%c %d{ISO8601} -- %m%n"/  >
    < /layout>
    < filter class="org.apache.log4j.varia.LevelRangeFilter"  >
      < param name="LevelMin" value="FATAL" / >
    < /filter>
  < /appender>

  < appender name="WARN" class="org.apache.log4j.RollingFileAppender" >
     < param name="File" value="../webapps/myporject/logs/warn.log"/ >
     < param name="Append" value="true"/ >
     < param name="MaxFileSize" value="5000KB"/ >
     < param name="MaxBackupIndex" value="2"/>
    < layout class="org.apache.log4j.PatternLayout" >
          < param name="ConversionPattern" value=" %p--%c %d{ISO8601}  -- %m%n"/ >
    < /layout>
    < filter class="org.apache.log4j.varia.LevelRangeFilter" >
      < param name="LevelMin" value="WARN" />
    < /filter>
  < /appender>

  < appender name="ERROR" class="org.apache.log4j.RollingFileAppender"  >
     < param name="File" value="../webapps/myporject/logs/error.log"/  >
     < param name="Append" value="true"/ >
     < param name="MaxFileSize" value="5000KB"/ >
     < param name="MaxBackupIndex" value="2"/ >
    < layout class="org.apache.log4j.PatternLayout">
          < param name="ConversionPattern" value="%p--%c %d{ISO8601} -- %m%n"/  >
    < /layout>
    < filter class="org.apache.log4j.varia.LevelRangeFilter">
      < param name="LevelMin" value="ERROR" / >
    < /filter>
  < /appender>

  < root>
    < priority value="ALL"/>
    < appender-ref ref="DEBUG"/>
    < appender-ref ref="FATAL"/>
    < appender-ref ref="INFO"/>
    < appender-ref ref="WARN"/>
    < appender-ref ref="ERROR"/>
  < /root>

< /log4j:configuration>

Put log messages in the Class
After put above file to src folder in the project.Then we can use log4j as following code in the progrmme.

import org.apache.log4j.Logger;

class testlog()
{
Logger log=new Logger(testlog.class);
log.Infor("<>>>");// this simply print in specify
//locationwebapps/myporject/info.log
}

Windows From Mouse Right Click pop up menu in c#

2007-12-10T21:53:00.000-08:00

Muse right click menu

1.Create Menu in design view (by adding "ContextMenu" control onto the form in the design view )
2.add following code( MouseUp event of the form)

private void Form1_MouseUp(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
contextMenuStrip1.Show(this,e.X, e.Y);
}
}

Tomcat configaration

2007-12-05T02:38:00.000-08:00

1.Install java 1.5 0r 1.6
2.set PATH by putting following line to c:\autoexec.bat file.(use JDK1.5)

set PATH="C:\Program Files\Java\jdk1.5.0_07\bin";%PATH%

3.Check configured properly by using "java -version" and "javac -help" in command prompt.Make sure not an error message about an unknown command.

4.Go to http://tomcat.apache.org/download-60.cgi and download and unpack the zip file to C:\apache-tomcat-6.0.10 (current version of tomcat 6.0.10)

5.set JAVA_HOME directory by putting following line to c:\autoexec.bat file

set JAVA_HOME=C:\Program Files\Java\jdk1.5.0_07

6.Turn on Servlet Reloading

To turn on servlet reloading, edit Edit C:\apache-tomcat-6.0.14\conf\context.xml and change

< Context >
to
< Context reloadable="true" privileged="true" >

7.Now in the command prompt

C:\>AUTOEXEC.BAT
C:\apache-tomcat-6.0.14\bin>startup.bat

@Html.DisplayFor(p => p.BookId)	@Html.EditorFor(p => p.BookId)
@Html.DisplayFor(p => p.BookName)	@Html.EditorFor(p => p.BookName)
@Html.DisplayFor(p => p.Description)	@Html.EditorFor(p => p.Description)