Only Hard Work is Not Sufficient To be Successfull.......

Add Enum in Array List

2011-03-15T17:20:00.000+05:30

System.Collections.ArrayList Al = new System.Collections.ArrayList();

Al.AddRange(Enum.GetNames(typeof(SqlDbType)));

PAN No Validation

2011-03-15T10:51:00.001+05:30

I have validated a text box that only PAN NO should be enter in that text box
It should be of 10 character first 5 digit will be Alphabet next 4 digit will be number and next one is alphabet
here txtPAN(TextBox) length should be fixed 10 chracter
ex : BJJPA4563A

private void txtPAN_KeyPress(object sender, KeyPressEventArgs e)
   {
   ValidatePANNO(e);
   }

   void ValidatePANNO(KeyPressEventArgs e)
   {
   if (!char.IsLetterOrDigit(e.KeyChar) && e.KeyChar != 8)
   {
   e.Handled = true;
   return;
   }

   if (e.KeyChar == 8)
   {
   return;
   }
   int len = txtPAN.TextLength;
   if (len < 5)
   {
   if (char.IsLetter(e.KeyChar))
   {

   }
   else
   {
   e.Handled = true;
   }

   }
   else
   {
   if (len == 9)
   {
   if (char.IsLetter(e.KeyChar))
   {
   return;
   }
   }
   if (char.IsLetter(e.KeyChar))
   {
   e.Handled = true;
   }
   else
   {
   if (len == 9)
   {
   if (!char.IsLetter(e.KeyChar))
   {
   e.Handled = true;
   }
   }
   }
   }
   }

How To delete Collection From Context in Entity Framework 4.0

2011-03-12T12:32:00.001+05:30

To Delete All Object by using Entity Framework 4.0

To Delete All OrderDetails of Customer Object where OrderID=103

var x = customerContext.OrderDetails.Where(c => c.OrderID == 103);
customerContext.DeleteAll(x.ToList());
customerContext.SaveChanges();

you have to defile DeleteAll method in a static class

namespace Application.Global
{

public static class GlobalMethods

{

public static void DeleteAll(this ObjectContext context, IEnumerable records)

{

foreach (T record in records)

{

context.DeleteObject(record);

}

Restrict Special symbol in TextBox in C#

2011-01-05T15:19:00.000+05:30

private void ctlUL_KeyPress(object sender, KeyPressEventArgs e)
        {
            try
            {
                if (!char.IsLetterOrDigit(e.KeyChar) && e.KeyChar!=8 )
                {
                    e.Handled = true;
                    return;
                }
         }

DateTimePicker Format in C#

2010-12-06T11:46:00.000+05:30

Here are Some Different Types of Format of DateTimePicker

dateTimePicker2.Format = System.Windows.Forms.DateTimePickerFormat.Short;

dateTimePicker3.Format = System.Windows.Forms.DateTimePickerFormat.Time;

dateTimePicker4.CustomFormat = "yyyy-mm-dd";

dateTimePicker4.Format = System.Windows.Forms.DateTimePickerFormat.Custom;

Select Record between Months in SQL

2010-12-04T16:33:00.002+05:30

select ID, Name, Month from (
    select ID, Name, Month,
        case Month
            when 'January' then 1
            when 'February' then 2
            when 'March' then 3
            when 'April' then 4
            when 'May' then 5
            when 'June' then 6
            when 'July' then 7
            when 'August' then 8
            when 'September' then 9
            when 'October' then 10
            when 'November' then 11
            when 'December' then 12

        end as MonthNo
    from
        Emp
) as TempTable
where
    MonthNo between 1 and 12 order by [Month]

Convert String In Title Case C#

2010-12-01T16:09:00.002+05:30

string s = "This is a test";

s = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(s.ToLower())

Convert ArrayList to String

2010-12-01T15:49:00.001+05:30

ArrayList ar =new ArrayList();

string str=string.Empty;

str = String.Join(',', (string []) ar.ToArray(typeof(string)))

Add Row Number in SQL SERVER

2010-11-16T17:49:00.001+05:30

Select Row_number() over (order by [Name]) 'SNO', ID, Name from emp

Validate GridCell with Decimal Value in C#

2010-11-13T17:37:00.004+05:30

Validate a Cell only Decimal No is Input , Alphabet should not be enter in that Cell only no and one point(.) should be enter and Backspace shoul be allowed
To do this you have to make a Method Named validate(char Key) and after write code on keyPress Event

      #region Decimal Validation

        public static bool validate(char Key)
        {
            byte i;
            bool parsed = byte.TryParse(Key.ToString(), out i);
            bool val = true;

            if (parsed)
            {
                val = false;
            }

            else if (parsed == false)
            {
                switch (Convert.ToInt32(Key))
                {
                    default:
                        val = true;
                        break;
                    case 8:
                        val = false; // If Backspace, allow char.
                        break;
                    case 46:
                        val = false; // If Delete, allow char.
                        break;
                }
            }
            return val;
        }

        #endregion

This is the method you have to write

Write Code on Key Press Event

void datagrigview1_KeyPress(object sender, KeyPressEventArgs e)
{
#region ValidateDecimal

if (datagrigview1.CurrentCell.OwningColumn.Name == "Quantity")

{
e.Handled = true;
int m = e.KeyChar;

if (e.KeyChar == 46)
{
//if (dGVTrans.CurrentCell.Value != null)
{

int n =datagrigview1 .CurrentCell.EditedFormattedValue.ToString().IndexOf(".");
if (n > 0)
{
return;
}
}
}

e.Handled = validate(e.KeyChar);
}

#endregion

How To Make Composite Key in SQL SERVER

2010-11-13T17:34:00.000+05:30

CREATE TABLE Product
(
ProductId int,
ProductName varchar(30),
Price int,
Remark Varchar(300),
PRIMARY KEY (ProductId, ProductName)
)

Save Data Through XML

2010-11-12T18:03:00.002+05:30

Here tblSalesBritanniaHead is Master Table and tblSalesBritanniaDetails is Transaction Table

Here is the UI we will use this to save data and Update

Here We will save data and update data through XML

Here is the Procedure that we will use to update data and save data

Create PROCEDURE USP_SaveSalesBritannia

@VoucherId int=null,

@VoucherNo varchar(15),

@VoucherDate smalldatetime,

@CustomerId int,

@SalesManId int,

@xml_data xml

BEGIN

DECLARE @VoucherIdToUpdate INT

IF( COALESCE(@VoucherId,0)=0)

BEGIN

INSERT INTO tblSalesBritaniaHead(VoucherNo,CustomerId,SalesmanId,VoucherDate)

VALUES (@VoucherNo,@CustomerId,@SalesManId,@VoucherDate)

--Get the generated ID

SELECT @VoucherIdToUpdate=SCOPE_IDENTITY()

INSERT INTO tblSalesBritaniaDetail

(VoucherId,ItemId,Packing,Rate,Cases,Pcs,DiscountPer,DiscountValue,TaxPer,TaxValue,Amount,SpecialDiscount,NetAmount)

SELECT

@VoucherIdToUpdate,

t.ref.value('ItemId[1]', 'bigint'),

t.ref.value('Packing[1]', 'bigint'),

t.ref.value('Rate[1]', 'float'),

t.ref.value('Cases[1]', 'float'),

t.ref.value('Pcs[1]', 'float'),

t.ref.value('DiscountPer[1]', 'float'),

t.ref.value('DiscountValue[1]', 'float'),

t.ref.value('TaxPer[1]', 'float'),

t.ref.value('TaxValue[1]', 'float'),

t.ref.value('Amount[1]', 'float'),

t.ref.value('SpecialDiscount[1]', 'float'),

t.ref.value('NetAmount[1]', 'float')

FROM @xml_data.nodes('/NewDataSet/Record') t(ref)

END

ELSE

BEGIN

UPDATE tblSalesBritaniaHead

SET

SalesManId=@SalesManId,

VoucherDate=@VoucherDate,

CustomerId=@CustomerId

WHERE

VoucherId=@VoucherId

SET @VoucherIdToUpdate=@VoucherId

DELETE FROM tblSalesBritaniaDetail

WHERE VoucherId=@VoucherIdToUpdate

INSERT INTO tblSalesBritaniaDetail

(VoucherId,ItemId,Packing,Rate,Cases,Pcs,DiscountPer,DiscountValue,TaxPer,TaxValue,Amount,SpecialDiscount,NetAmount)

SELECT

@VoucherIdToUpdate,

t.ref.value('ItemId[1]', 'bigint'),

t.ref.value('Packing[1]', 'bigint'),

t.ref.value('Rate[1]', 'float'),

t.ref.value('Cases[1]', 'float'),

t.ref.value('Pcs[1]', 'float'),

t.ref.value('DiscountPer[1]', 'float'),

t.ref.value('DiscountValue[1]', 'float'),

t.ref.value('TaxPer[1]', 'float'),

t.ref.value('TaxValue[1]', 'float'),

t.ref.value('Amount[1]', 'float'),

t.ref.value('SpecialDiscount[1]', 'float'),

t.ref.value('NetAmount[1]', 'float')

FROM @xml_data.nodes('/NewDataSet/Record') t(ref)

END

Here is the Save Button Coding

private void ultbtnSave_Click(object sender, EventArgs e)

{

DataTable NewSaveTable = (DataTable)ultraGridBritania.DataSource;

NewSaveTable.TableName = "Record";

System.IO.StringWriter writerXMLDetail = new System.IO.StringWriter();

NewSaveTable.WriteXml(writerXMLDetail, true);

string SXMLDetail = writerXMLDetail.ToString();

string SVoucherNo = Convert.ToString (cmbVoucherNo.Text);

DateTime SVoucherDate = DateTime.Now;

int SCustomerId=0;

int SSalesmanId = 0;

SVoucherDate = Convert.ToDateTime(VoucherDate.Value);

SCustomerId = Convert.ToInt32(cmbCustomeName.Value);

SSalesmanId = Convert.ToInt32(cmbSalesman.Value);

int i = DataLayer.DAL.SaveSalesBritenniaDetails(0, SVoucherNo, SVoucherDate, SCustomerId, SSalesmanId, SXMLDetail);

if (i > 0)

{

UltraDesktopAlert alert = new UltraDesktopAlert { AnimationStyleShow = AnimationStyle.FadeAndScroll, AutoCloseDelay = 5000, Style = DesktopAlertStyle.Office2007 };

alert.Show("SalesBritannia", "Sales Britannia " + " Saved Successfully");

}

else

MessageBox.Show("Error in Data Saving........");

}

Here is the code for Update Button

DataSet dsUpdate;

private void ultbtnUpdate_Click(object sender, EventArgs e)

{

if (cmbVoucherNo.SelectedRow != null)

{

DataTable NewUpdateTable = (DataTable)ultraGridBritania.DataSource;

NewUpdateTable.TableName = "Record";

string UVoucherNo = Convert.ToString(cmbVoucherNo.Value);

DateTime UVoucherDate = Convert.ToDateTime(VoucherDate.Value);

int UCustomerId = Convert.ToInt32(cmbCustomeName.Value);

int USalesmanId = Convert.ToInt32(cmbSalesman.Value);

int VoucherId = Convert.ToInt32(cmbVoucherNo.SelectedRow.Cells["VoucherId"].Value);

System.IO.StringWriter writerXMLDetail = new System.IO.StringWriter();

NewUpdateTable.WriteXml(writerXMLDetail, true);

String UXMLDetail = writerXMLDetail.ToString();

int i = DataLayer.DAL.SaveSalesBritenniaDetails(VoucherId, UVoucherNo, UVoucherDate, UCustomerId, USalesmanId, UXMLDetail);

if (i > 0)

{

UltraDesktopAlert alert = new UltraDesktopAlert { AnimationStyleShow = AnimationStyle.FadeAndScroll, AutoCloseDelay = 5000, Style = DesktopAlertStyle.Office2007 };

alert.Show("SalesBritannia", "SalesBritannia " + " Saved successfully");

}

else

MessageBox.Show("Error in Data Updation........");

}

public static int SaveSalesBritenniaDetails(int VoucherId, String VoucherNo, DateTime VoucherDate, int CustomerId, int SalesManId, string DetailXML)

{

try

{

Database db = DatabaseFactory.CreateDatabase();

DbCommand dbCommand = db.GetStoredProcCommand("USP_SaveSalesBritannia");

db.AddInParameter(dbCommand, "@VoucherId", DbType.Int32, VoucherId);

db.AddInParameter(dbCommand, "@VoucherNo", DbType.String, VoucherNo);

db.AddInParameter(dbCommand, "@VoucherDate", DbType.DateTime, VoucherDate);

db.AddInParameter(dbCommand, "@CustomerId", DbType.Int32, CustomerId);

db.AddInParameter(dbCommand, "@SalesManId", DbType.Int32, SalesManId);

db.AddInParameter(dbCommand, "@xml_data", DbType.Xml, DetailXML);

dbCommand.CommandType = CommandType.StoredProcedure;

int i = db.ExecuteNonQuery(dbCommand);

//if (i>0)

return i;

}

catch (Exception ex)

{

return -1;

}

Check Existence of Column In Table SQL SERVER

2010-11-11T13:09:00.001+05:30

SELECT Name FROM sys.all_columns WHERE
[object_id] =OBJECT_ID(N'dbo.TableName') AND NAME = 'ColumnName'

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName'
AND COLUMN_NAME = 'YourColumnName'

Add a DataGridViewColumn in DataGridView , C#

2010-10-29T18:11:00.001+05:30

DataGridViewColumn dgvc = new DataGridViewColumn();

dgvc.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;

dgvc.HeaderText = st;

dgvc.Name = st;

DataGridViewCell newcell = new DataGridViewTextBoxCell();

dgvc.CellTemplate = newcell;

dgvc.Visible = true;

datagridview1.Columns.Add(dgvc);

datagridview1.Rows[0].Cells[st].Value ="500";

Split a String Seperated With \ , C#

2010-10-29T17:00:00.000+05:30

string sSuppName = "A/B/C/D/E";
string[] str1 = sSuppName.Split('/');

output    A
              B
              C
             D

string sSuppName = "A\B\C\D\E";
string[] str1 = sSuppName.Split('\\');

output    A
            B
            C
             D

Select Date From DateTime In SQL

2010-10-28T17:27:00.000+05:30

select convert(varchar,DOB,101) from emp

101 means “mm/dd/yyyy” format

108 will return just the time “hh:mm:ss”

SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DOB))) from emp

SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DOB))) from emp

where CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, DOB)))>'10-25-2010'

Sort String in SQL

2010-10-22T16:43:00.001+05:30

ID      Salary    Name

1       0            AB123

2       0            AB65

3      0           AB10

4       0            AB25

Sort it on the column Name and we want Output like

this

ID   Salary   Name

1   0           AB123

2    0            AB65

4   0           AB25

3    0          AB10

select CAST(SUBSTRing(Name, 3,4) AS int) as BB,* from A order by BB desc

Check Printer Status in C#

2010-10-20T12:05:00.002+05:30

Assembly : System.Management;

     public bool CheckPrinterStatus()
        {

            ManagementScope scope = new ManagementScope(@"\root\cimv2");
            scope.Connect();

            // Select Printers from WMI Object Collections

            ManagementObjectSearcher PrinterCollection= new
            ManagementObjectSearcher("SELECT * FROM Win32_Printer");

            string printerName = "";

            foreach (ManagementObject printer in PrinterCollection.Get())
            {
                printerName = printer["Name"].ToString().ToLower();
                if (printerName.Equals(@"hp laserjet 1018"))
                {
                    MessageBox.Show("Printer = " + printer["Name"]);
                    if (printer["WorkOffline"].ToString()=="True")
                    {
                        // Printer is offline

                        MessageBox.Show("Printer is not Connected.");
                        return false;
                    }
                    else
                    {
                        // Printer is Online
                       MessageBox.Show("Printer is Connected.");
                        return true;
                    }
                }
            }
        }

Copy all Data From one Table to another with same Structure in sql

2010-10-18T13:26:00.000+05:30

copy all Data From one Table to another with same Structure

insert into [MyDB].[dbo].[Emp] select * from [Info].[dbo].[A]

it will copy all data in EMP table from A Table

Export DataGridView Data in Excel C#

2010-10-09T19:06:00.000+05:30

object misValue = System.Reflection.Missing.Value;

Excel.Application xlapp;

Excel.Workbook xlworkbook;

Excel.Worksheet xlsheets;

xlapp = new Excel.ApplicationClass();

xlworkbook = xlapp.Workbooks.Add("");

xlsheets = (Excel.Worksheet)xlworkbook.Sheets.get_Item(1);

int i = 0; int j = 0;

int x = 2;

for (i = 0; i <= dataGridView1.Rows.Count - 1; i++)

{

for (j = 0; j <= dataGridView1.Columns.Count-1; j++)

{

DataGridViewCell dgvcell = dataGridView1[j, i];

if (i == 0)

{

string ss = "B"+(j+1);

xlsheets.Cells[i + 1, j + 1] = dataGridView1.Columns[dgvcell.ColumnIndex].Name;

//xlsheets.get_Range("A1", "C1").Interior.ColorIndex = 37;

xlsheets.get_Range("A1", "C1").Interior.Color= System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Blue);

xlsheets.get_Range("A1", "C1").Interior.Pattern = XlPattern.xlPatternSolid;

xlsheets.get_Range("A1", "C1").Font.Bold = true;

xlsheets.get_Range("A1", "C1").HorizontalAlignment = Excel.XlVAlign.xlVAlignCenter;

//xlsheets.get_Range("A1", "C1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

}

xlsheets.Cells[i+2, j+1] = dgvcell.Value;

}

string rng1 = "A" + (i + 2);

string rng2 = "C" + (i + 2);

xlsheets.get_Range(rng1, rng2).Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Pink);

xlsheets.get_Range(rng1, rng2).Interior.Pattern = XlPattern.xlPatternSolid;

}

xlworkbook.SaveAs("d:\\MM.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

private void releaseObject(object obj)

{

try

{

System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);

obj = null;

}

catch (Exception ex)

{

obj = null;

MessageBox.Show("Exception Occured while releasing object " + ex.ToString());

}

finally

{

GC.Collect();

}

}

Set Text of Button in DataGridView

2010-10-04T12:45:00.000+05:30

DataGridViewButtonColumn colbtnApproved = new DataGridViewButtonColumn();

colbtnApproved .HeaderText = "Approve";

colbtnApproved .Text = "Approve";

colbtnApproved .UseColumnTextForButtonValue = true;

now text is visible on button

Select Case Sensitive String from Table in Sql Server

2010-09-29T17:03:00.001+05:30

I have a Table in which record is following

Name Age

nagendra 23

NAGENDRA 24

SELECT Name,Age FROM Customers

WHERE Name COLLATE Latin1_General_CS_AS = 'nagendra'

Output:

nagendra

Find all Primary key in Table/Database

2010-07-23T14:42:00.002+05:30

SELECT t.table_schema AS PrimarySchemaName ,
t.TABLE_NAME AS PrimaryKeyTable,
tc.CONSTRAINT_NAME AS PrimaryKey,
COALESCE(tc2.constraint_schema,'N/A') AS ForeignSchemaName,
COALESCE(rc1.CONSTRAINT_NAME,'N/A') AS ForeignKey ,
COALESCE(tc2.TABLE_NAME,'N/A') AS ForeignKeyTable
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
INNER JOIN INFORMATION_SCHEMA.TABLES t ON tc.TABLE_NAME = t.TABLE_NAME
LEFT JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1 ON tc.CONSTRAINT_NAME =rc1.UNIQUE_CONSTRAINT_NAME
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME
WHERE TC.CONSTRAINT_TYPE ='PRIMARY KEY'
ORDER BY tc.TABLE_NAME,tc.CONSTRAINT_NAME,rc1.CONSTRAINT_NAME

It will Return all the Primary Key of every Table with their table name

Input only Number in TextBox in C#

2010-07-23T11:20:00.001+05:30

IsDigit

IsHighSurrogate

IsLetter

IsLetterOrDigit

IsLower

IsLowSurrogate

IsNumber

IsPunctuation

IsSeparator

IsSurrogate

IsSurrogatePair

IsSymbol

IsUpper

IsWhiteSpace

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)

{

if (Char.IsDigit(e.KeyChar) )

{ MessageBox.Show("Bad Input");

e.Handled = true; ;

}}

// It will Input Only Digit in TextBox
            if ((e.KeyChar < '0') || (e.KeyChar > '9'))
            {
                e.Handled = true;
            }

            // It will Input Only Alphabet and Digit in TextBox nothing else
            if (!Char.IsLetterOrDigit(e.KeyChar))
            {
                MessageBox.Show("Bad Input");
                e.Handled = true; ;
            }

Encrypt Decrypt Password in C#

2010-07-22T16:39:00.002+05:30

insert into Emp(name,age) values(EncryptByPassPhrase('20','aarti'),50)

select id, DECRYPTBYPASSPHRASE('20',name) "Name" from Emp

Procedure in SQL Server

2010-07-21T19:06:00.002+05:30

Create PROCEDURE ins

@name varchar(50),

@age float

as

insert into Emp(name,age) values(@name,@age)

Execute Procedure

ins 'Raj',22

Insert Update Delete Through Linq in C#

2010-07-20T18:29:00.002+05:30

take a Window Form Application

add a Class LINQ to SQL Classes named DataClasses1.dbml

now Double Click on DataClasses1.dbml it Design View will be open

now on it Give Database Conection and drag Table on Designer

Now make a object of DataClasses1DataContext Class and access all Clases

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.Linq;

namespace LinqImplementation

{

public partial class Form1 : Form

{

DataClasses1DataContext dc1 = null;

string ss = null;

public Form1()

{

InitializeComponent();

ss = "Data Source=(local);Initial Catalog=EMP;Integrated Security=SSPI;";

dc1 = new DataClasses1DataContext(ss);

}

private void btnSelect_Click(object sender, EventArgs e)

{

var q = from a in dc1.GetTable()

where a.ClientName.Contains("aj")

a.Salary == 20000

select a;

dataGridView1.DataSource = q;

}

private void btnSave_Click(object sender, EventArgs e)

{

try

{

Table XPCClient = dc1.GetTable();

Client cl = new Client();

cl.Oid = Guid.NewGuid();

cl.ClientName = txtclientname.Text;

cl.Salary = int.Parse(txtsalary.Text);

cl.SEX = cmbsex.SelectedIndex;

XPCClient.InsertOnSubmit(cl);

XPCClient.Context.SubmitChanges();

MessageBox.Show("Record Inserted Successfully");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message+"Record Insertion Failed");

}

}

private void btnDelete_Click(object sender, EventArgs e)

{

Table XpCClient = dc1.GetTable();

var obj = (from w in XpCClient

where w.Salary == 12000

select w).FirstOrDefault();

var obj1 = XpCClient.Where(a => a.Salary == 20000).FirstOrDefault();

XpCClient.DeleteOnSubmit(obj);

XpCClient.Context.SubmitChanges();

}

private void btnUpdate_Click(object sender, EventArgs e)

{

Table XPCClient = dc1.GetTable();

var obj = from a in XPCClient

where a.Salary == Convert.ToInt32(txtsalary.Text)

select a;

Client obj1 = (from ab in XPCClient

where ab.Salary == Convert.ToInt32(txtsalary.Text)

select ab).FirstOrDefault();

if (obj == null)

MessageBox.Show("Record Not Found");

else

{

foreach (Client c in obj)

{

c.Salary = 55000;

dc1.SubmitChanges();

}

}

}

}

}

Note : Client is a Table in EMP Database

Find all Database in sql server 2005

2010-06-11T15:28:00.000+05:30

select * from sys.databases

select * from sys.tables

To see all the column of table

select * from sys.all_columns where [object_id]= OBJECT_ID (N'dbo.emp')//Emp is table name

Change Text/Image Periodically in Windo application in C#

2010-06-09T15:26:00.002+05:30

I have taken a Window Form and add a Label

and a Timer I want Label text should be

change after 5 second

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

Timer tm = new Timer();

tm.Tick += new EventHandler(tm_Tick);

tm.Interval = (1000) * (3);

tm.Enabled = true;

tm.Start();

}

int i = 0;

void tm_Tick(object sender, EventArgs e)

{

i++;

Timer tm = (Timer)sender;

if (i == 1)

label1.Text = "NSE";

else if (i == 2)

label1.Text = "BSE";

else if (i == 3)

{

label1.Text = "NCDX";

}

else if (i == 4)

{

label1.Text = "MCX";

i = 0;

}

}

}

Auto Complete Option in ComboBox in C#

2010-06-01T16:41:00.002+05:30

ArrayList ObjArrayList=new ArrayList():

private void Form_Load(object sender, EventArgs e)
{
ObjArrayList.Add("a");

ObjArrayList.Add("aa");

ObjArrayList.Add("b");

ObjArrayList.Add("bb");

ObjArrayList.Add("c");

ObjArrayList.Add("cc");

ObjArrayList.Add("d");

ObjArrayList.Add("dd");

OR

cmbSymbol.DataSource = ObjArrayList;// You can Give DataSource Also

ComboBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;

ComboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;

AutoCompleteStringCollection dataSymbols = new AutoCompleteStringCollection();

for (int i = 0; i < ObjArrayList.Count; i++)//If You are using DataSet then user Ds.Tables[0].Rows.Count

{

dataSymbols.Add(ObjArrayList[i].ToString());

}

ComboBox1.AutoCompleteCustomSource = dataSymbols;

}

Merge Cell In DataGridView

2010-05-25T18:17:00.001+05:30

To merge Cell in DataGridView You Have to Fire Paint event

after that give the RowHeight and RowWidth and number of cell to be merged

Code is Given below

dataGridView1.Paint += new PaintEventHandler(dataGridView1_Paint);

void dataGridView1_Paint(object sender, PaintEventArgs e)

{

Rectangle rct;

rct = e.ClipRectangle;

rct.X = dataGridView1.GetColumnDisplayRectangle(0, true).X;

rct.Y = dataGridView1.GetRowDisplayRectangle(6, true).Y;//here 6 is the ROW Number which you want to Merge

rct.Height = dataGridView1.Rows[1].Height;//.Cells[0].Size.Height;

rct.Width = dataGridView1.Rows[2].Cells[0].Size.Width * 4;// 4 is the no of cell to be merged

OR

rct.Width = dataGridView1.Width; // its Automatically Merge all the Cell of a ROW

e.Graphics.FillRectangle(Brushes.White, rct);

Pen p = new Pen(SystemColors.ControlDark);

e.Graphics.DrawRectangle(p, rct);
e.Graphics.DrawString("Total Salary " + SalarySum,new System.Drawing.Font("Arial",10,FontStyle.Bold ) ,Brushes.Blue, rct.X, Rect.Y);
}

Bind Data in DataGridView

2010-05-20T17:57:00.000+05:30

            string strSQLconnection = "Data Source=(local);Initial Catalog=Info;Integrated Security=True";
            SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
            SqlCommand sqlCommand = new SqlCommand("select * from product", sqlConnection);
            sqlConnection.Open();
            SqlDataAdapter sda = new SqlDataAdapter(sqlCommand.CommandText, sqlConnection);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            DataGrid1.DataSource = ds.Tables[0];

How To Change Localization of Window Application in C#

2010-05-18T17:35:00.000+05:30

To Change localization
Take a Combo Box and add item
Hindi
English
Chinese
suppose there is a Label1 on the Form and its Text Property is= Nagendra
and we want to change its Culture according To Language in
Hindi= नागेन्द्र
Chinies=納根德拉

To do this go on the form and set its Property Localizable =True
Now set the language of Form is Hindi and set Label1.text= नागेन्द्र
Now a new .resx file will be made like Form1.hi.resx

Now set the language of Form is Chinies and set Label1.text=納根德拉
Now a new .resx file will be made like Form1.zh-CHT.resx

private void ChangeLanguage(string lang)
{
foreach (Control c in this.Controls)
{
ComponentResourceManager resources = new ComponentResourceManager(typeof(Form1));
resources.ApplyResources(c, c.Name, new CultureInfo(lang));
}
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
ChangeLanguage("hi");
}
if (comboBox1.SelectedIndex == 1)
{
ChangeLanguage("en");
}
else if(comboBox1.SelectedIndex==2)
{
ChangeLanguage("zh-CHT");
}
}

Here we have used hi is for Hindi,zh-CHT for Chinies it is specific for every Language

Generate random numbers who's sum is a pre-determined

2010-04-08T16:27:00.000+05:30

Here We want to generate a 9 digit unique no that is divisible by 9 or multiple of 9
here starting no is 700000002 sum : 7+0+0+0+0+0+0+0+2 =9 and its sum is multiple of 9
suppose you want to generate a no whose starting no is 712 then 712000008 sum=7+1+2+0+0+0+0+0+8=18
now find max no from database and add it

{
// XPCollection XPDomain = new XPCollection(ObjectSpace.Session);
//var a = XPDomain.Select(c => c.UniqueNo).Max();
int a;
select a= max(srno) from Table
int b = Convert.ToInt32(a);
GetUnique(b);
ObjectSpace.CommitChanges();
View.Refresh();
}

public void GetUnique(int MaxNo)
{
int PreviousNo = MaxNo;
for (int a = 0; a <= 1000; a++)
{

if (PreviousNo == 0)
{
DomainObject1 dm = new DomainObject1(ObjectSpace.Session);
dm.UniqueNo = "700000002";
PreviousNo = Convert.ToInt32(dm.UniqueNo);
dm.Save();
}
else
{
DomainObject1 dm = new DomainObject1(ObjectSpace.Session);
dm.UniqueNo =Convert.ToString (PreviousNo + 9);
PreviousNo = Convert.ToInt32(dm.UniqueNo);
dm.Save();
}
}

}

Generate random numbers who's sum is a pre-determined number in C#

2010-04-08T16:26:00.000+05:30

Here we have gererated a 9 digit random number whose sum is multiple of 9
and starting no will be 6 and 7

public void GetUnique()
{
string b=Getval();
char[] a=b.tochararray()

int b1=0;
foreach(char v in a)
{
b1+=Convert.ToInt32(v);
}

if (b1%9==0)
{
print value;
}
else
GetUnique() ;

}

public string Getval()
{
Random r = new Random();
string b = String.Format
(
"{0}{1}{2}{3}{4}{5}{6}{7}{8}",
r.Next(6, 7),
r.Next(0, 9),
r.Next(0, 9),
r.Next(0, 9),
r.Next(0, 9),
r.Next(0, 9),
r.Next(0, 9),
r.Next(0, 9),
r.Next(0, 9)
);
return b;

}

How To Highlight Selected Field on Detailview in XAF

2010-02-20T15:34:00.002+05:30

public partial class LayOutViewController : ViewController
{
public LayOutViewController()
{
InitializeComponent();
RegisterActions(components);
TargetViewType = ViewType.DetailView;
}
protected override void OnActivated()
{
base.OnActivated();
((WinLayoutManager)((View as DetailView).LayoutManager)).ItemCreated += new EventHandler(LayOutViewController_ItemCreated);
}

void LayOutViewController_ItemCreated(object sender, ItemCreatedEventArgs e)
{
DetailView lDet = View as DetailView;
((LayoutControl)(((WinLayoutManager)(lDet.LayoutManager)).Container)).OptionsView.HighlightFocusedItem = true;
((LayoutControl)(((WinLayoutManager)(lDet.LayoutManager)).Container)).Appearance.ControlFocused.BackColor = Color.FromArgb(255, 201, 84);
if (e.Item is LayoutControlGroup)
{
LayoutControlGroup IG = (LayoutControlGroup)e.Item;
if (((IG.TextLocation == Locations.Default) ||
IG.TextLocation == DevExpress.Utils.Locations.Top)
&& !(IG.Parent != null))
IG.ExpandButtonVisible = true;
}
}
}

How To Copy a Table on SQL Server

2010-02-20T15:33:00.002+05:30

select * into NewTableName from OldTableName

OldTableName is Table from wheres you want to select all data and want to copy in NewTable

How To Add New Action Container in XAF

2010-02-20T15:31:00.000+05:30

public partial class WindowController1 : WindowController
{
public WindowController1()
{
InitializeComponent();
RegisterActions(components);
}
public override void UpdateModel(Dictionary dictionary)
{
base.UpdateModel(dictionary);
base.UpdateModel(dictionary);
DictionaryNode categoryNode = null;
DictionaryNode categoryNode1 = null;
DictionaryNode pageNode = null;
DictionaryNode pageGroupNode = null;
DictionaryNode itemNode = null;
categoryNode = dictionary.RootNode.FindChildNodeByPath(@"RibbonTemplates\Template[@ID='ApplicationWindowContext']\PageCategory[@ID='Default']") as DictionaryNode;
categoryNode1 =dictionary.RootNode.FindChildNodeByPath(@"RibbonTemplates\Template[@ID='ApplicationWindowContext']\PageCategory[@ID='Default']\Page[@ID='Default']") as DictionaryNode;

//-- Add a new Page to the Category
pageNode = categoryNode.AddChildNode("Page"); //!!!
pageNode.SetAttribute("ID", "MyPage");
pageNode.SetAttribute("Index", "0");
pageNode.SetAttribute("Caption", "My Page");

//-- Add a new Page Group to the newly created Page
pageGroupNode = categoryNode1.AddChildNode("PageGroup");
pageGroupNode.SetAttribute("ID", "Report");
pageGroupNode.SetAttribute("Index", "0");
pageGroupNode.SetAttribute("Caption", "Report");

itemNode = pageGroupNode.AddChildNode("Item");
itemNode.SetAttribute("ID", "BillByBillRep");
itemNode.SetAttribute("Index", "0");
itemNode.SetAttribute("ActionID", "BillByBillRep");

itemNode = pageGroupNode.AddChildNode("Item");
itemNode.SetAttribute("ID", "cstLedgerRep");
itemNode.SetAttribute("Index", "1");
itemNode.SetAttribute("ActionID", "cstLedgerRep");
XafTypesInfo.Instance.RefreshInfo(typeof(DictionaryNode));
}
}

How To Create User Defined Function In SQL Server

2010-02-20T15:29:00.002+05:30

CREATE FUNCTION SumOfTwoNumber
( @a int, @b int )
RETURNS int
AS
BEGIN
RETURN (@a+@b)
END

==============
CREATE FUNCTION SumOfTwoNumber ( @a int, @b int )
RETURNS int
AS
BEGIN
WHILE @a <100 BEGIN SET @a =@a +1 END RETURN (@a+@b) END go SELECT dbo. SumOfTwoNumber(1,7) AS SumOfTwoValues SumOfTwoValues -------------- 107 =============== USE Northwind go CREATE FUNCTION fx_Customers_ByCity ( @City nvarchar(15) ) RETURNS table AS RETURN ( SELECT CompanyName FROM Customers WHERE City =@City ) go SELECT * FROM fx_Customers_ByCity('London') CompanyName ---------------------------------------- Around the Horn . . . Seven Seas Imports ======================= USE Northwind go CREATE FUNCTION fx_OrdersByDateRangeAndCount ( @OrderDateStart smalldatetime, @OrderDateEnd smalldatetime, @OrderCount smallint ) RETURNS @OrdersByDateRange TABLE ( CustomerID nchar(5), CompanyName nvarchar(40), OrderCount smallint, Ranking char(1) ) AS BEGIN --Statement 1 INSERT @OrdersByDateRange SELECT a.CustomerID, a.CompanyName, COUNT(a.CustomerID)AS OrderCount, 'B' FROM Customers a JOIN Orders b ON a.CustomerID =b.CustomerID WHERE OrderDate BETWEEN @OrderDateStart AND @OrderDateEnd GROUP BY a.CustomerID,a.CompanyName HAVING COUNT(a.CustomerID)>@OrderCount

--Statement 2
UPDATE @OrdersByDateRange
SET Ranking ='A'
WHERE CustomerID IN (SELECT TOP 5 WITH TIES CustomerID
FROM (SELECT a.CustomerID,
COUNT(a.CustomerID)AS OrderTotal
FROM Customers a
JOIN Orders b ON a.CustomerID =b.CustomerID
GROUP BY a.CustomerID) AS DerivedTable
ORDER BY OrderTotal DESC)
RETURN
END
==================
SELECT *
FROM fx_OrdersByDateRangeAndCount ('1/1/96','1/1/97',2)
ORDER By Ranking

CustomerID CompanyName OrderCount Ranking
---------- ------------------------------ ---------- -------
ERNSH Ernst Handel 6 A
FOLKO Folk och fä HB 3 A
HUNGO Hungry Owl All-Night Grocers 5 A
QUICK QUICK-Stop 6 A
SAVEA Save-a-lot Markets 3 A
SEVES Seven Seas Imports 3 B
SPLIR Split Rail Beer &Ale 5 B
...
=============================

CREATE FUNCTION fx_LDOM
( @Date varchar(20) )
RETURNS datetime
AS
BEGIN
--ensure valid date
IF ISDATE(@Date) = 1
BEGIN
--determine first day of month
SET @Date = DATEADD(day,-DAY(@Date)+1,@Date)
--determine last day of month
SET @Date = DATEADD(day,-1,DATEADD(month,1,@Date))
END
ELSE
SET @Date = '1/1/80'

RETURN @Date
END
=====================
CREATE TABLE fx_Testing (DateValue datetime)
go
INSERT fx_Testing VALUES ('1/1/01')
INSERT fx_Testing VALUES ('2/15/01')
INSERT fx_Testing VALUES ('2/15/02')
INSERT fx_Testing VALUES ('2/15/03')
INSERT fx_Testing VALUES ('2/15/04')

SELECT DateValue,
dbo.fx_LDOM(DateValue) AS LDOM,
DATEDIFF(day,DateValue,dbo.fx_LDOM(DateValue)) AS DaysLeftInMonth
FROM fx_Testing

DateValue LDOM DaysLeftInMonth
------------------------ ----------------------- ---------------
2001-01-01 00:00:00.000 2001-01-31 00:00:00.000 30
2001-02-15 00:00:00.000 2001-02-28 00:00:00.000 13
2002-02-15 00:00:00.000 2002-02-28 00:00:00.000 13
2003-02-15 00:00:00.000 2003-02-28 00:00:00.000 13
2004-02-15 00:00:00.000 2004-02-29 00:00:00.000 14

How To Add Tiltle Of Application in XAF

2010-02-20T15:27:00.002+05:30

public partial class NavigationWindowController : WindowTemplateController
{
public NavigationWindowController()
{
InitializeComponent();
RegisterActions(components);
}

protected override void OnActivated()
{
base.OnActivated();
CustomizeWindowCaption += new EventHandler(NavigationWindowController_CustomizeWindowCaption);
// CollectCreatableItemTypes+=new EventHandler(NavigationWindowController_CollectCreatableItemTypes);
}

void NavigationWindowController_CustomizeWindowCaption(object sender, CustomizeWindowCaptionEventArgs e)
{
e.WindowCaption.FirstPart = "HRMS";
e.WindowCaption.SecondPart = "Payroll";
e.WindowCaption.Separator = "-";
e.WindowCaption.Text = "Welcome to The World 1st IAF.Net ERP Solution Provider";
}

How To See all Trigger in SQL SERVER

2009-12-15T13:55:00.001+05:30

select * from sys.triggers
It will show all trigger that is applied on database tables

Criteria /Filtering year, month or day in XAF

2009-12-11T13:22:00.005+05:30

SELECT * FROM table WHERE YEAR(date1) = '2009'
SELECT * FROM table WHERE MONTH(date1) = '1'
SELECT * FROM table WHERE DAY(date1) = '20'
There are equivalent Criteria in XAf
The FunctionOperator allows you to use "SQL" functions such as YEAR()
New BinaryOperator(New FunctionOperator(FunctionOperatorType.GetYear, New
OperandProperty("Date1")), New OperandValue(2009), BinaryOperatorType.Equal)
Or
CriteriaOperator.Parse("GetYear(Date1)=2009")

How To Add ListViewFilter From BO Model in XAF

2009-12-11T13:21:00.002+05:30

To add Filter go in BO Model=>ListView and Right Click On ListView and Choose Add Filters and give CurrentFilterId and Click on Filter and Right Click on Add Filter and Give Criteria . now a ListBox Comes in ListView To Filter Record

How To Add Conditional Formatting in XAF

2009-12-11T13:21:00.001+05:30

To add Conditional formatting go in BO Model=>ListView and Right Click On ListView and add Conditional formatting ang Then Right Click On=> Add Rule here You can Give Criteria according criteria Colour will be change of BackGround/Foreground

How To Add Item in Grid Control Like Button/TextBox in XAF

2009-12-11T13:20:00.003+05:30

if (View is ListView && View .ObjectTypeInfo.Type==typeof (MasterDailyLedger))
{
ListView Lv = (ListView)View;
DevExpress.XtraEditors.TextEdit te = new TextEdit();
System.Windows.Forms.ListBox l = new System.Windows.Forms.ListBox();
DropDownButton dp = new DropDownButton();
GridControl gc = (GridControl)Lv.Control;
gc.Controls.Add(te);
gc.Controls.Add(dp);
gc.Controls.Add(l);
foreach (System.Windows.Forms.Control g in gc.Controls)
{
if (g is DevExpress.XtraEditors.TextEdit)
{
DevExpress.XtraEditors.TextEdit te1 = (DevExpress.XtraEditors.TextEdit)g;
te1.Text = "System";
}
}
}

How To Change Case of GridColumn in Upper Case/Cell Content in Upper Case

2009-12-11T13:19:00.003+05:30

Assembly : Devexpress.XtraEditors.Repository

void View_ControlsCreated(object sender, EventArgs e)
{
if (View is DevExpress.ExpressApp.ListView && View.ObjectTypeInfo.Type == typeof(DomainObject1))
{
DevExpress.ExpressApp.ListView lv = (DevExpress.ExpressApp.ListView)View;
GridControl gd = (GridControl)lv.Control;
GridControl gd1 = new GridControl();
GridView gv = (GridView)gd.FocusedView;
RepositoryItemTextEdit rite = new RepositoryItemTextEdit();
rite.CharacterCasing = CharacterCasing.Upper;
gv.Columns["NameOfPerson"].ColumnEdit = rite;
}

Filter ListView Data Will Not Show on ListView Activated When You Search Record Then Record Will Show in XAF

2009-12-11T13:16:00.003+05:30

Here I have a Class ContactA
I want Data Will not Populate in ListView on ListView Activated
Data Will Show when I search any Thing from search Button

protected override void OnActivated()
{
base.OnActivated();
if (View is ListView && View.ObjectTypeInfo.Type == typeof(ContactA))
{
ListView lv = (ListView)View;
lv.CollectionSource.CollectionChanged += new EventHandler(CollectionSource_CollectionChanged);
}
}

void CollectionSource_CollectionChanged(object sender, EventArgs e)
{
ListView listView = (ListView)View ;
if (listView.CollectionSource.Collection.Count > 0)
{
if (!listView.CollectionSource.Criteria.ContainsKey("EmptyCollectionCriteria"))
{
listView.CollectionSource.Criteria.Add("EmptyCollectionCriteria", CollectionSource.EmptyCollectionCriteria);
}
listView.CollectionSource.Criteria.Changed += new EventHandler(Criteria_Changed);
}
}

void Criteria_Changed(object sender, EventArgs e)
{
ListView listView = (ListView)View;
listView.CollectionSource.Criteria.Remove("EmptyCollectionCriteria");
}

How To Apply EditorState on Property in XAF

2009-12-11T13:13:00.000+05:30

Assembly : DevExpress.ExpressApp.ConditionalEditorState;

[EditorStateRule("ServiceTaxApp", "IsServiceTaxApplicable", ViewType.DetailView, "")]

public EditorState EditorSTA(out bool active)

{

active = true;

if (AccountGroups != null && StatutoryConfig != null && StatutoryConfig.IsServiceTaxApplicable)

{

active = !(AccountGroups.IsTaxApplicable(SSType.ServiceTax));

}

return EditorState.Hidden;

}

How To Find Object of Maximum Salary in XAF

2009-12-11T12:58:00.001+05:30

GroupWiseMasterDailyLedger lt = ObjectSpace.Session.FindObject<<"GroupWiseMasterDailyLedger">>(CriteriaOperator.Parse(String.Format("Debit={0}",ObjectSpace.Session.Evaluate<<"GroupWiseMasterDailyLedger">>(CriteriaOperator.Parse("MAX(Debit)"), null))));

Here You Can Find Maximum Debit Object
And int maxValue = int.Parse(Session.Evaluate(typeof(class), CriteriaOperator.Parse("Max(salary)")));
int maxValue = int.Parse(Session.Evaluate(CriteriaOperator.Parse("Max(salary)")));

Note : Here donot Apply "" in GroupWiseMasterDailyLedger and also one lessthan and greater than Sign

How To Find Top 10 Record in ListView in XAF

2009-12-11T12:56:00.001+05:30

if (View is ListView && View.ObjectTypeInfo.Type == typeof(GroupWiseMasterDailyLedger))
{
ListView lv = (ListView)View;
XPCollection XPC =(XPCollection) lv.CollectionSource.Collection;
SortingCollection sc = new SortingCollection(); sc.Add(new SortProperty("Debit", DevExpress.Xpo.DB.SortingDirection.Descending));
XPC.Sorting = sc;
XPC.TopReturnedObjects = 5;
}

How To Add Search Option on Lookup

2009-12-11T12:49:00.002+05:30

[LookupEditorMode(LookupEditorMode.AllItemsWithSearch)] Apply this Attribute on lookup

How To Apply Clock and Date on Your Application

2009-12-11T12:48:00.001+05:30

To apply A Clock on Your Application You have To add A SimpleAction Take A controller and Add a SimpleAction Now Write Code void View_ControlsCreated(object sender, EventArgs e) { if (View is ListView) { System.Windows.Forms.Timer tmr = new System.Windows.Forms.Timer(); tmr.Enabled = true; tmr.Start(); tmr.Tick += new EventHandler(tmr_Tick); } } void tmr_Tick(object sender, EventArgs e) { SimpleAction1.Caption = DateTime.Now.ToString(); }

Display Format for Timespan in C#

2009-12-11T12:43:00.000+05:30

EditMask {0:HH:mm}

EditMask HH:mm

Set the mask so the user can enter a phone number, with optional area code, and a state in capitals.this.c1TrueDBGrid.Columns[0].EditMask = "(###) 000-0000 St\ate\: >LL";

$#,##0.00;($#,##0.00) Currency format.

0 Fixed number format.

#,##0 Commas format.

0% Percent format.

0.00E+00 Scientific format.

c General Date and Time format.

dddddd Long Date format.

dd-mmm-yy Medium Date format.

ddddd Short Date format.

ttttt Long Time format.

hh:mm AM/PM Medium Time format.

hh:mm Short Time format.

How To Change Grid into VerticalGrid

2009-12-11T12:38:00.001+05:30

Assembly : DevExpress.XtraVerticalGrid;
:DevExpress.XtraGrid;

void View_ControlsCreated(object sender, EventArgs e)
{
ListView LV=(ListView)View;
GridControl GD = (GridControl)LV.Editor.Control;
VGridControl VG = new VGridControl(); VG.DataSource = LV.CollectionSource.Collection;
GD.Controls.Add (VG);
VG.AllowDrop = true;
VG.Dock = System.Windows.Forms.DockStyle.Fill;
VG.Appearance.FocusedRow.BackColor = System.Drawing.Color.Red;
VG.AllowDrop = true;
VG.LayoutStyle = LayoutViewStyle.MultiRecordView;
System.Drawing.Size sz = new System.Drawing.Size(1500, 1500);
VG.Size = sz;
VG.OptionsBehavior.AutoFocusNewRecord = true;
VG.OptionsBehavior.Editable = true;
VG.OptionsBehavior.RecordsMouseWheel = true;
VG.OptionsView.AutoScaleBands = true;
VG.OptionsView.ShowButtons = true;
}

How to Check That Interface is implemented in the Class

2009-12-11T12:34:00.001+05:30

if (View is DetailView && View.ObjectTypeInfo.Implements<"ILedger>"()){} here Plz Do not Apply Double quotes before/after ILedger

Open Popup ListView of any Class on Navigation Click

2009-12-11T11:46:00.001+05:30

If You Want To Open a PopupListView on Navigation Click
To do this you have to write a Controller and
inherit it with ShowNavigationItemController
Here There is a Class Shipment when I click on Shipment in NavigationBar then a
PopupListView will Come of DispatchRegister
Now add the code below

protected override void ShowNavigationItem(SingleChoiceActionExecuteEventArgs args)
{
base.ShowNavigationItem(args);
if ((args.SelectedChoiceActionItem != null) && args.SelectedChoiceActionItem.Enabled)
{
if (args.SelectedChoiceActionItem.Id == "Shipment_ListView")
{
ObjectSpace os = Application.CreateObjectSpace();
DevExpress.ExpressApp.ListView lv = Application.CreateListView(os, typeof(DispatchRegister), true);
args.ShowViewParameters.CreatedView = lv;
args.ShowViewParameters.TargetWindow = TargetWindow.NewModalWindow;
args.ShowViewParameters.CreateAllControllers = true;
DialogController dc = new DialogController();
args.ShowViewParameters.Controllers.Add(dc);
dc.Accepting += new EventHandler(dc_Accepting);
}
}
}

Now Write Code on Accepting Here You Can Find Selected Item after Clicking on OK Button
void dc_Accepting(object sender, DialogControllerAcceptingEventArgs e)
{
ObjectSpace os=Application.CreateObjectSpace ();
ListView lv = ((ListView)((WindowController)sender).Window.View);
Shipment sp = null;
CollectionSource cs = new CollectionSource(os, typeof(Shipment));
CollectionSourceBase cs1 = (CollectionSourceBase)lv.CollectionSource;
foreach (DispatchRegister dr in lv.SelectedObjects)
{
sp = new Shipment(os.Session);
sp.BlockNo = dr.DeliveryNumber;
sp.ChallanNo = dr.DistributionChannel;
cs.Collection.Add(os.GetObject (sp));
}
ListView listView = Application.CreateListView("Shipment_ListView", cs, true);
e.ShowViewParameters.CreatedView = listView;
e.ShowViewParameters.TargetWindow = TargetWindow.Default;
}

How To Convert ArrayList to String

2009-11-23T16:12:00.001+05:30

ArrayList ar =new arrayList();
string jj=string .Empty;
jj=string.Join(“,”, (string []) ar.ToArray(typeof(string)))

How To Hide Some Class from New Button List/Navigation Item in XAF

2009-11-23T16:07:00.001+05:30

public partial class HideItemsControll : WinNewObjectViewController
{
public HideItemsControll()
{
InitializeComponent();
RegisterActions(components);
}
protected override void OnActivated()
{
base.OnActivated();
CollectCreatableItemTypes += new EventHandler(HideItemsControll_CollectCreatableItemTypes);
}
void HideItemsControll_CollectCreatableItemTypes(object sender, CollectTypesEventArgs e)
{
CustomizeList(e.Types);

}
public void CustomizeList(ICollection types)
{
//Get the ShowNavigationItemController, then get its ShowNavigationItemAction
SingleChoiceAction showNavigationItemAction = Frame.GetController().ShowNavigationItemAction;
//Get the item selected in the navigation control
ChoiceActionItem selectedItem = showNavigationItemAction.SelectedItem;
ChoiceActionItem currentGroup = null;
if (selectedItem != null)
{
//Get the selected item's parent group
currentGroup = selectedItem.ParentItem;
List unusableTypes = new List();
//Collect the types that must be deleted
foreach (Type type in types)
{
//bool deletionRequired = true;
if (type.Name.Equals("BillByBill"))
{
unusableTypes.Add(type);
}
if (type.Name.Equals("AccountIntrest"))
{
unusableTypes.Add(type);
}
foreach (Type type in unusableTypes)
types.Remove(type);
}}}

How to Find ObjectSpace

2009-11-23T16:04:00.001+05:30

ObjectSpace os=ObjectSpace.FindObjectSpace(Object)
Here we can see the unit of work

How To Find Type of a Property/Member

2009-11-23T16:03:00.001+05:30

memberName=amont;

ITypeInfo TypeInfo= XafTypesInfo.Instance.FindTypeInfo();
IMemberInfo iminfo = TypeInfo.FindMember(memberName);
If (iminfo.MemberTypeInfo.Type == typeof(double)){}

The Default View Only Populate After a Search has been done and Not Automatically Populate the View at Startup

2009-11-23T15:59:00.001+05:30

Here ListView Data Will Not be Populated on Activated , Data Will be Populated when
You search anything

namespace FilterListView.Module
{
public partial class ViewController1 : ViewController
{
public ViewController1()
{
InitializeComponent();
RegisterActions(components);
}
protected override void OnActivated()
{
base.OnActivated();
if (View is ListView && View.ObjectTypeInfo.Type == typeof(ContactA))
{
ListView lv = (ListView)View;
lv.CollectionSource.CollectionChanged += new EventHandler(CollectionSource_CollectionChanged); }
}

void CollectionSource_CollectionChanged(object sender, EventArgs e)
{
ListView listView = (ListView)View ;
if (listView.CollectionSource.Collection.Count > 0)
{
if (!listView.CollectionSource.Criteria.ContainsKey("EmptyCollectionCriteria")) {
listView.CollectionSource.Criteria.Add("EmptyCollectionCriteria", CollectionSource.EmptyCollectionCriteria);
}
listView.CollectionSource.Criteria.Changed += new EventHandler(Criteria_Changed);
}
}
void Criteria_Changed(object sender, EventArgs e)
{
ListView listView = (ListView)View;
listView.CollectionSource.Criteria.Remove("EmptyCollectionCriteria");
}
}
}

Associassion Through Module Base with the help of Interface

2009-11-23T15:48:00.001+05:30

Here I have two modules Xpert.Account and Xpert.Statutory. In Account Modules.cs I
have to add two Properties
FormsToIssue, FormsToRecieve in a Class which have Implemented ICST Interface
public sealed partial class InModule : ModuleBase
{
public InModule()
{
InitializeComponent();
}

public override void CustomizeTypesInfo(DevExpress.ExpressApp.DC.ITypesInfo typesInfo)
{
base.CustomizeTypesInfo(typesInfo);
if (Application == null || Application.XPDictionary == null) return;
XPDictionary xpDCT = XafTypesInfo.XpoTypeInfoSource.XPDictionary;
foreach (XPClassInfo item in Application.XPDictionary.Classes)
{
if (item.ClassType != null && XafTypesInfo.Instance.FindTypeInfo(item.ClassType).ImplementsICST())
{
classInfo = item;
if (XafTypesInfo.Instance.FindTypeInfo(classInfo.ClassType).ImplementsICST())
{
if (classInfo.FindMember(classInfo.ClassType.Name) == null && classInfo.BaseClass.FindMember(classInfo.ClassType.Name) == null)
{
classInfo.CreateMember("FormsToIssue", typeof(StatutoryForms), new VisibleInListViewAttribute(false), new VisibleInLookupListViewAttribute(false));
classInfo.CreateMember("FormsToRecieve", typeof(StatutoryForms), new VisibleInListViewAttribute(false), new VisibleInLookupListViewAttribute(false));
}
XafTypesInfo.Instance.RefreshInfo(classInfo.ClassType);
}}}}}}
Here ICST is a Interface that is attached with various Class in that class two
property will be added

How To Find Method of Other Modules

2009-11-23T15:41:00.002+05:30

Here PurchaseUtils is a Class and have a Static Method ClosingBalance with Three
Argument in a Different Modules Xpert.Procurement
And this method is Used in AccountModules Xpert.Account and we can not used
Xpert.Procurement This DLL in Account Module because AccountModules is Top Level
So we used this Method by this way as given below…..
First here we find the class in which Method is defined here method is defined in
PurchaseUtils Class
Now find the Method and Pass Parameter……

Type TP = ReflectionHelper.FindType("PurchaseUtils");
MethodInfo MI = TP.GetMethod("ClosingBalance");
object[] parameters = new object[3];
parameters[0] = Session;
XPCollection x = new XPCollection(ReflectionHelper.FindType("ItemDetails"));
parameters[1] = DateTime.Now;
parameters[2] = DateTime.Now;
_Amount = (double)(MI.Invoke(null, parameters));

How To Set Column Width in AspxGridView in C#

2009-11-11T15:14:00.002+05:30

There are Two Class Ledger and AccountGroup ,There is a XpCollection of Ledger on AccountGroup and its one part is on Ledger
Now Find Ledger Property From AccountGroup and Find its ListView and then Find the Column whose width you have to Change.
if (View is DetailView && View.ObjectTypeInfo.Type == typeof(AccountGroup))
{
DetailView dv = (DetailView)View;
ListPropertyEditor lv = (ListPropertyEditor)dv.FindItem("Ledger");
ListView Lv = (ListView)lv.ListView;
ASPxGridListEditor editor = (ASPxGridListEditor)lv.ListView.Editor;
ASPxGridControl gridView = editor.Grid;
gridView.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control;
gridView.Columns["Name"].Width = new System.Web.UI.WebControls.Unit(350);
}

How To Backup a Database in C#

2009-11-09T15:05:00.001+05:30

XpertData is Source Folder that we have to take Backup and store it on E:\Web string sourceDir = @"D:\XpertData";
string backupDir = @"E:\web";
try
{
string[] picList = Directory.GetFiles(sourceDir, "*.mdb");
string[] txtList = Directory.GetFiles(sourceDir, "*.ldb");

foreach (string f in picList)
{
string fName = f.Substring(sourceDir.Length + 1);
File.Copy(Path.Combine(sourceDir, fName), Path.Combine(backupDir, fName), true);
}
foreach (string f in txtList)
{

string fName = f.Substring(sourceDir.Length + 1);
try
{
File.Copy(Path.Combine(sourceDir, fName), Path.Combine(backupDir, fName));
}

catch (IOException copyError)
{
Console.WriteLine(copyError.Message);v }
}
}
catch (DirectoryNotFoundException dirNotFound)
{
Console.WriteLine(dirNotFound.Message);
}

How to Hide or Show an Property in the DetailView Against the Value of the Object's Property.

2009-10-26T13:16:00.002+05:30

Here ItemName will be Enable/Disable According to IsApplicable Property

Assembly:
DevExpress.XtraLayout;
DevExpress.ExpressApp.Win.Layout;

if (View is DetailView && View.ObjectTypeInfo.Type == typeof(Item))
{
if (e.Object.GetType() == typeof(Item))
{
LayoutControl layoutControl = ((LayoutControl)View.Control);
DetailView dv = (DetailView)View;
Item itm = (Item)View.CurrentObject;
LayoutControlItem target = FindLayoutControlItemByName("ItemName", ((LayoutControl)(((WinLayoutManager)(dv.LayoutManager)).Container)).Items);
ITypeInfo imf = (ITypeInfo)XafTypesInfo.Instance.FindTypeInfo(View.CurrentObject.GetType());
IMemberInfo imi = imf.FindMember("IsApplicable");
Boolean ValueOfIsApplicable = false;
if (imi != null)
{
ValueOfIsApplicable = (Boolean)imi.GetValue(View.CurrentObject);
}
layoutControl.BeginUpdate();
if (target != null && ValueOfIsApplicable)
{
target.HideToCustomization();
}
else
{
target.RestoreFromCustomization();
}
layoutControl.EndUpdate();
}
}
Here is Method
private LayoutControlItem FindLayoutControlItemByName(string name, CollectionBase items)
{
foreach (object item in items)
{
if (item is LayoutControlItem)
{
if ((item as LayoutControlItem).ControlName != null)
{
if ((item as LayoutControlItem).ControlName.IndexOf(name) >= 0)
{
return item as LayoutControlItem;
}}}}
return null;
}

How To Rename a TAB on DetailView

2009-10-26T13:01:00.003+05:30

To Rename a TAB you have to Make a Method given below

Assembly:
DevExpress.XtraLayout;
DevExpress.ExpressApp.Win.Layout;
public void RenameTab(DetailView view, string tabName, bool isVisible)
{ LayoutControl layoutControl = ((LayoutControl)view.Control); foreach (object obj in layoutControl.Items) { if (obj is TabbedControlGroup) { TabbedControlGroup tabbedControlGroup = (TabbedControlGroup)obj; foreach (object item in tabbedControlGroup.TabPages) { string Name = ((LayoutGroup)(item)).Name; if (Name.IndexOf("OriginalTABName1") >= 0 || Name.IndexOf("OrignalTABName2") >= 0) { if (Name.IndexOf(tabName) <= 0) { ((LayoutGroup)(item)).BeginUpdate(); ((LayoutGroup)(item)).CustomizationFormText = tabName; ((LayoutGroup)(item)).Text = tabName; ((LayoutGroup)(item)).EndUpdate(); } return;}}}} layoutControl.EndUpdate(); } Now Write Code on ObjectChange void ObjectSpace_ObjectChanged(object sender, ObjectChangedEventArgs e) { if (View is DetailView && View.ObjectTypeInfo.Type == typeof(Ledger)) { if (e.Object.GetType() == typeof(Ledger)) { LayoutControl layoutControl = ((LayoutControl)View.Control); DetailView dv = (DetailView)View; Ledger ldg = (Ledger)View.CurrentObject; LayoutControlItem target = FindLayoutControlItemByName("DeducteeType", ((LayoutControl)(((WinLayoutManager)(dv.LayoutManager)).Container)).Items); ITypeInfo imf = (ITypeInfo)XafTypesInfo.Instance.FindTypeInfo(View.CurrentObject.GetType()); IMemberInfo imi = imf.FindMember("IsTDSApplicable"); Boolean ValueOfIsTDSApplicable = false; if (imi != null) { ValueOfIsTDSApplicable = (Boolean)imi.GetValue(View.CurrentObject); } layoutControl.BeginUpdate(); if (target != null && ValueOfIsTDSApplicable) { RenameTab(dv, "TDSDetails", true); target.Text = "DeducteeType"; } else { RenameTab(dv, "TCSDetails", true); target.Text = "CollecteeType"; } layoutControl.EndUpdate(); }}}

How To Find LayoutControlItem on DetailView

2009-10-26T12:51:00.000+05:30

To find LayoutControlItem you have to create a Method given below here Item is a Class on Which there is two property ItemName,IsApplicable Assembly: DevExpress.XtraLayout; DevExpress.ExpressApp.Win.Layout; when IsApplicable=true then ItemName Caption Property Changed according to your condition private LayoutControlItem FindLayoutControlItemByName(string name, CollectionBase items) { foreach (object item in items) { if (item is LayoutControlItem) { if ((item as LayoutControlItem).ControlName != null) { if ((item as LayoutControlItem).ControlName.IndexOf(name) >= 0) { return item as LayoutControlItem; }}}} return null; } Now Write code on your Desired Event like ControlCreated,ObjectSpace.ObjectChanged if (View is DetailView && View.ObjectTypeInfo.Type == typeof(Item)) { if (e.Object.GetType() == typeof(Item)) { LayoutControl layoutControl = ((LayoutControl)View.Control); DetailView dv = (DetailView)View; Item itm = (Item)View.CurrentObject; LayoutControlItem target = FindLayoutControlItemByName("ItemName", ((LayoutControl)(((WinLayoutManager)(dv.LayoutManager)).Container)).Items); ITypeInfo imf = (ITypeInfo)XafTypesInfo.Instance.FindTypeInfo(View.CurrentObject.GetType()); IMemberInfo imi = imf.FindMember("IsApplicable"); Boolean ValueOfIsApplicable = false; if (imi != null) { ValueOfIsApplicable = (Boolean)imi.GetValue(View.CurrentObject); } layoutControl.BeginUpdate(); if (target != null && ValueOfIsApplicable) { target.Text = "YourDesiredCaption1"; } else { target.Text = "YourDesiredCaption2"; } layoutControl.EndUpdate(); } }

How To DeleteDuplicateRecord From ArrayList

2009-10-01T14:14:00.001+05:30

ar is ArrayList int index; for(int i=0; i<(ar.Count-1); i++) { index=ar.IndexOf(ar[i], i+1); while( index>i ) { ar.RemoveAt(index); if( i<(ar.Count-1) ) { index=ar.IndexOf(ar[i], i+1); } else { index=-1; } } }

How To Get Property Value From Application Model

2009-10-01T14:13:00.000+05:30

string s = null; s = Application.Info.GetChildNode("Options").GetAttribute("CalculationOnObject").Value;

Auto Index in GridView

2009-10-01T14:12:00.003+05:30

void gv_InitNewRow(object sender, InitNewRowEventArgs e) { GridView gvv = (GridView)sender; int a = 1; for (int i = 1; i <= gvv.RowCount; i++) { gvv.SetRowCellValue(e.RowHandle, "Index", a); a++; } }

Set Grid IndexBy Code

2009-10-01T14:12:00.001+05:30

gv.Columns["BillNo"].VisibleIndex = 0;

How To Validate a Row

2009-10-01T14:11:00.002+05:30

void gv_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { ColumnView columnview = (ColumnView)sender; GridColumn gridcolumn = columnview.Columns["Date"]; DateTime billdate = Convert.ToDateTime(columnview.GetRowCellValue(e.RowHandle, gridcolumn)); LedgerOpeningBalance lob = (LedgerOpeningBalance)View.CurrentObject; if (billdate > lob.Date) { columnview.SetColumnError(gridcolumn, "Invalid Date !! Date should be Less Than Opening Date", ErrorType.Information); e.Valid = false; e.ErrorText = "Invalid Date !! Date should be Less Than Opening Date"; columnview.FocusedRowHandle = e.RowHandle; columnview.FocusedColumn = gridcolumn; columnview.ShowEditor(); } }

How To Filter ListView Staticely

2009-10-01T14:11:00.001+05:30

Apply this code after DefaultClassOption this will create a List of Billed, UnBilled,ShowAll And when you choose option then ListView becomes filter [ListViewFilter("Billed","BillNo is not null",true)] [ListViewFilter("UnBilled", "BillNo is null")] [ListViewFilter("ShowAll", "")]

How To Filter ListView on ControlCreated

2009-10-01T14:10:00.002+05:30

((DevExpress.ExpressApp.ListView)View).CollectionSource.Criteria["Filter1"] = new BinaryOperator("Name", "Primary", BinaryOperatorType.NotEqual);

Collection Sorting on Multiple Field

2009-10-01T14:10:00.001+05:30

XPCollection xpCollection1 = new XPCollection(); SortingCollection sorting = new SortingCollection(); sorting.Add(new SortProperty("PropertyA", DevExpress.Xpo.DB.SortingDirection.Ascending)); xpCollection1.Sorting = sorting; ... SortingCollection newSorting = new SortingCollection(); newSorting.Add(new SortProperty("PropertyB", DevExpress.Xpo.DB.SortingDirection.Ascending)); xpCollection1.Sorting = newSorting;

How To Sort a XPCollection

2009-10-01T14:09:00.002+05:30

SortingCollection sc = new SortingCollection(); sc.Add (new SortProperty("field on which you want to sort",DevExpress.Xpo.DB.SortingDirection.Ascending)); XpcoletionName.Sorting = sc; Or XpcollectionName.Sorting.Add(new SortProperty("field on which you want to sort ", SortingDirection.Ascending));

How To Call a DetailView On Action

2009-10-01T14:09:00.001+05:30

Take a View Controller add a SimpaleAction and on Execute Event write Code ObjectSpace objectSpaceInternal = Application.CreateObjectSpace(); CurrentConfig cc = CurrentConfig.GetCurrentConfig(objectSpaceInternal.Session); objectSpaceInternal.CommitChanges(); e.ShowViewParameters.CreatedView = Application.CreateDetailView(objectSpaceInternal, cc); e.ShowViewParameters.TargetWindow = TargetWindow.NewModalWindow; e.ShowViewParameters.Context = TemplateContext.PopupWindow; e.ShowViewParameters.CreateAllControllers = true; DialogController dcPeriod = new DialogController(); dcPeriod.Accepting += new EventHandler(dcPeriod_Accepting); e.ShowViewParameters.Controllers.Add(dcPeriod); Note: currentConfig is class whose detail view you have to call;

How to Find List Selected Item on Accepting

2009-10-01T14:08:00.001+05:30

DevExpress.ExpressApp.ListView lv = ((DevExpress.ExpressApp.ListView)((WindowController)sender).Window.View); lv.SelectedObjects;

How To Call a ListView On Action

2009-10-01T14:07:00.002+05:30

Take a View Controller add a SimpaleAction and on Execute Event write Code And write this code on ONACTIVATED()Event simpleAction1.Active.SetItemValue("ObjectType", View.ObjectTypeInfo.Type == typeof(TrialBalance)); ObjectSpace objectSpace = Application.CreateObjectSpace(); CollectionSource collectionSource = (CollectionSource)Application.CreateCollectionSource(objectSpace, typeof(OperationUnit), "OperationUnit_ListView"); ListView listview = Application.CreateListView("OperationUnit_ListView", collectionSource, true); e.ShowViewParameters.CreatedView = listview; e.ShowViewParameters.TargetWindow = TargetWindow.NewModalWindow; e.ShowViewParameters.CreateAllControllers = true; DialogController dcOU = new DialogController(); e.ShowViewParameters.Controllers.Add(dcOU); dcOU.Accepting += new EventHandler(dcOU_Accepting);

How To Add New Row in ListView

2009-10-01T14:07:00.001+05:30

Apply this code above the class [DefaultListViewOptions(EditMode.Editable,NewItemRowPosition .Bottom)] Or write own View Controller GridView gv = (GridView)gc.FocusedView; gv.NewItemRowText = "Click Here To Add A New Row"; gv.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom; gv.OptionsNavigation.AutoFocusNewRow = true; gv.OptionsView.ShowFooter = true; gv.OptionsBehavior.Editable = true;

How To Access The Value Of ReadonlyParameter

2009-10-01T14:06:00.004+05:30

DateTime dt = (DateTime)new ToDateParameter().CurrentValue; CriteriaWrapper criteriaWrapper = new CriteriaWrapper(this.GetType(), "'@ToDate'"); DateTime dt = (DateTime)criteriaWrapper.Parameters[0].CurrentValue;

How to Find Edit value of Lookup

2009-10-01T14:06:00.003+05:30

DetailView dv = (DetailView)View; LookupPropertyEditor control1 = (LookupPropertyEditor)dv.FindItem("AccountGroups"); LookupEdit c1 = (LookupEdit)control1.Control; AccountGroup gc = (AccountGroup)c1.EditValue;

Comparing Two Property Value in Same class

2009-10-01T14:06:00.001+05:30

[RuleCriteria("RuleCriteria for Itemstatus", DefaultContexts.Save, "Date >= StatusDate", "Date should be greater than StatusDate")] Itemstatus is class Date and StatusDate are Properties and it will be written after [DefaultClassOption]

How to Filter Popup Window

2009-10-01T14:05:00.002+05:30

ObjectSpace os = Application.CreateObjectSpace(); ListView listView = Application.CreateListView(Application.GetListViewId(typeof(DomainObject2)), new CollectionSource(os, typeof(DomainObject2)), false); listView.CollectionSource.Criteria["FilterCriteria"] = CriteriaOperator.Parse("IntProperty > 1"); or listview.CollectionSource.Criteria["ABC"] = new InOperator("ShipmentNo", al).Not(); or listview.CollectionSource.Criteria["ABC"] = new BinaryOperator("PropertyName",PropertyValue); e.View = listView;

Apply Criteria on XPCollection

2009-10-01T14:05:00.001+05:30

CriteriaOperator criteria = new BinaryOperator("Age", 30, BinaryOperatorType.Greater); CriteriaOperator criteria = CriteriaOperator.Parse("Age > 30"); xpCollection1.Criteria = criteria; CriteriaOperator filter = CriteriaOperator.Parse("Age > 30 AND Age < 40"); xpCollection1.Filter = filter; gridControl1.DataSource = new XPCollection(Session.DefaultSession, typeof(MyObject), new BinaryOperator("UnitPrice", filterValue, BinaryOperatorType.GreaterOrEqual)); xpCollection1.Filter = new InOperator("Name", new string[] {"John", "Mike", "Nick"}); CriteriaOperator criteria1 = CriteriaOperator.Parse( "Iif(Field1 == 100, Field1, Field2) > 1000"); XPCollection collection1 = new XPCollection(typeof(MyObject), criteria1); class MyObject : XPObject { decimal unitPrice; public decimal UnitPrice { get { return unitPrice; } set { unitPrice = value; } }} // Select MyObject objects that match the specified criteria. decimal filterValue = 20; gridControl1.DataSource = new XPCollection(Session.DefaultSession, typeof(MyObject), new BinaryOperator("UnitPrice", filterValue, BinaryOperatorType.GreaterOrEqual)); CriteriaOperator filter = new BetweenOperator("Age", 20, 30); xpCustomers.Filter = filter; // Retrieves a collection of the Contact objects which match the criteria that represents // the logical expression (DefaultAddress.City <> "Chicago"). XPCollection collection = new XPCollection(typeof(Contact),CriteriaOperator.Parse("DefaultAddress.City != 'Chicago'") // Retrieves a collection of the Contact objects which match the criteria that represents // the logical expression (DefaultAddress.City <> "Chicago" AND not (Company is null)). XPCollection collection = new XPCollection(typeof(Contact), CriteriaOperator.Parse("DefaultAddress.City != 'Chicago' AND Company is not null") // Retrieves the Contact objects that contain an address, // and the city which is given in the address is the same as the person's city. // The "^" symbol represents a reference to the Owner object, //The '^' character is used to refer to the parent in a parent-child relationship. The parent relationship traversal operator allows you to access parent objects in expressions written in the context of a child. // the parent object of the Locations collection. XPCollection collection = new XPCollection(typeof(Contact), new ContainsOperator("DefaultAddress.Owner.Locations", new BinaryOperator( new OperandProperty("City"), new OperandProperty("^.DefaultAddress.City"), BinaryOperatorType.Equal ) ) // Represents the Person class which contains account information. public class Person: XPObject { [Association("PersonAccounts", typeof(Account))] public XPCollection Accounts { get { return GetCollection("Accounts"); } } } // Represents the Account class which contains the amount in the account. public class Account: XPObject { [Association("PersonAccounts")] public Person Owner; public int Amount; } XPCollection collection = new XPCollection(typeof(Person), CriteriaOperator.Parse("Accounts.Sum(Amount) < 100") XPCollection collection = new XPCollection(typeof(Person), CriteriaOperator.Parse("Accounts[Amount = 0].Count == 1") CriteriaOperator.Parse("[FirstName] Like 'A%'"); CriteriaOperator.Parse(String.Format("[Address1.City] = '{0}'",City)); CriteriaOperator.Parse("[IsGlobal] = true");

How To To Disable New Button and Close Button From Lookup Window

2009-10-01T14:03:00.000+05:30

void View_ControlsCreated(object sender, EventArgs e) { if (View is DetailView) { LookupPropertyEditor editor = (LookupPropertyEditor)((DetailView)View).FindItem("UnderGroup"); editor.Control.Properties.ShowPopupShadow = true; editor.Control.Properties.PopupSizeable = false; editor.Control.Properties.ShowPopupCloseButton = false; editor.Control.Properties.ShowDropDown = DevExpress.XtraEditors.Controls.ShowDropDown.DoubleClick; } }

How To Apply Email validation

2009-10-01T14:01:00.001+05:30

[RuleRegularExpression("RuleRegularExpression for classname.propertyname", DefaultContexts.Save, @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$", "It should be in given format")] [RuleRequiredField("RuleRequiredField for Company.PhoneNumber", DefaultContexts.Save, "Can Not be Empty you have to Give Phone Number")] [RuleRange("RuleRange for Payment.Rate", DefaultContexts.Save, 10, 20, "Enter with in range")] Here payment is a class and rate is property [RuleUniqueValue("RuleUniqueValue", DefaultContexts.Save, "RuleUniqueValue description")] [RuleRequiredField("RuleRequiredField for classname.propertyname ", DefaultContexts.Save, "Can Not Be Empty")] [RuleObjectExists("ClassName_ComplexValidationSettingsObject", DefaultContexts.Save, "CalculationTypes = '@CalculationTypes'AND Amount='@Amount' AND Schedule='@Schedule' AND IsActive='@IsActive'", MessageTemplateMustExist = "Objects with the same combination of the properties must not exist.", InvertResult = true, SkipNullOrEmptyValues = true, FoundObjectMessageFormat = "'{0}'", FoundObjectMessagesSeparator = ";")]

Aassociassion with Module Base

2009-10-01T13:56:00.000+05:30

Suppose you have two module 1. Cevious.Xpert.Account 2. Cevious.Xpert.Statutory.In TCSNature.cs VAT.cs In Statutory Module we have used Accounts DLL In Account module there is a class Ledger in which I want a Lookup of VAT to do this We go in Cevious.Xpert.Statutory.In =>Module.cs=> public override void CustomizeTypesInfo(DevExpress.ExpressApp.DC.ITypesInfo typesInfo) { base.CustomizeTypesInfo(typesInfo); XPDictionary xpDCT = XafTypesInfo.XpoTypeInfoSource.XPDictionary; if (xpDCT.GetClassInfo(typeof(Ledger)).FindMember("PropertyName") == null) { xpDCT.GetClassInfo(typeof(Ledger)).CreateMember("PropertyName", typeof(Class Name),new DisplayNameAttribute("Display Name"),new ImmediatePostDataAttribute(),new VisibleInListViewAttribute (false)); Example //xpDCT.GetClassInfo(typeof(Ledger)).CreateMember("Nature", typeof(TypeOfNature)); } XafTypesInfo.Instance.RefreshInfo(typeof(Ledger)); }

How to Find Property of Class with XafTypeInfo

2009-10-01T13:55:00.000+05:30

ITypeInfo ob = XafTypesInfo.Instance.FindTypeInfo(ReflectionHelper.FindType("TransactionDetails")).FindMember("YourPropertyName"); OR XPDictionary xpd=XafTypeInfo.XpoTypeInfoSource.XPDictionary; Object ob=(xpd.GetClassInfo((typeof(className)).FindMember(“PropertyName”).GetType());

How To Find GridView From DetailView

2009-10-01T13:54:00.000+05:30

ListPropertyEditor lpe = (ListPropertyEditor)dv.FindItem("ShipmentInfo"); GridView gv = (GridView)((GridControl)lpe.ListView.Control).FocusedView; XPCollection xpc = (XPCollection)(gv.DataSource); foreach (object ob in xpc) { if (ob.GetType() == typeof(BillingFormat)) { }

How To Hide BO Model For Normal User

2009-10-01T13:53:00.002+05:30

SimpleUser Su = (SimpleUser)SecuritySystem.CurrentUser; if (!Su.IsAdministrator) { Frame.GetController().Action.SetActiveByKey("EditModel", false);} Or Add a Window Controller And wrete Code private void WindowController1_Activated(object sender, EventArgs e) { // Window.ViewChanged += new EventHandler(Window_ViewChanged); } void Window_ViewChanged(object sender, EventArgs e) { IBarManagerHolder template = Window.Template as IBarManagerHolder; SimpleUser Su = (SimpleUser)SecuritySystem.CurrentUser; if (Su.IsAdministrator) { if (template != null && Window.View != null) { foreach (object actionContainer in Window.Template.GetContainers()) { ActionContainerMenuBarItem mn = actionContainer as ActionContainerMenuBarItem; { if (mn != null) { if (mn.Actions.Count > 0) if (mn.Actions[0].Caption == "Edit Model") { mn.Actions[0].SetEnabledByKey("Edit Model", false); }}}}}}}

How to Prevent Deletion Of Record From ListView

2009-10-01T13:53:00.001+05:30

In This Controller That Record is Deleted Whose BillNo is Null Write a Controller and Inherit : DeleteObjectsViewController protected override void Delete(SimpleActionExecuteEventArgs args) { if (View.ObjectTypeInfo.Type == typeof(DispatchRegister)) { List list = new List(); foreach (DispatchRegister item in args.SelectedObjects) { if (item.BillNo==null || item.BillNo.Length<=0) { list.Add(item); } } if (list.Count == 0) { XtraMessageBox.Show("Record Can Not be Deleted. You Can Delete Only those Record whose Bill No is Blank"); } else { BaseDelete(list); } return; } base.Delete(args); } private void BaseDelete(System.Collections.IList argsSelectedObjects) { ObjectSpace.Delete(argsSelectedObjects); if (AutoCommit || View.IsRoot) { ObjectSpace.CommitChanges(); } if (View is ListView) { ((ListView)View).Editor.Refresh(); } else { View.Close(); } }

How to Prevent a DetailView From being Shown When the User Double Clicks/Presses the Enter Key on a Record in the ListView

2009-10-01T13:50:00.000+05:30

namespace Solution1.Module.Win { public partial class ViewController1 : DevExpress.ExpressApp.SystemModule.ListViewProcessCurrentObjectController { public ViewController1() { InitializeComponent(); RegisterActions(components); } protected override void ExecuteProcessCurrentObject(SimpleActionExecuteEventArgs e) { if (View is ListView && View.ObjectType == typeof(DomainObject1)) { return; } base.ExecuteProcessCurrentObject(e); }}}

how To Add a Simple Button on Detail View

2009-10-01T13:47:00.000+05:30

To add simple button on DetailView Go in BO Model=>DomainObject2 DetailView=>Items=>Add=>ControlDetailItems and give its ID and Caption Also set its Property ControlTypeName=DevExpress.XtraEditors.SimpleButton Now Button is Visible on DetailView you can find this button from DetailView and Fire Event OR Go in ModelEditor Code and write the code

Fire Event on Button Added on DetailView

2009-10-01T13:44:00.000+05:30

if (View is DetailView && View.ObjectTypeInfo.Type == typeof(DomainObject2)) { DetailView dv = (DetailView)View; ControlDetailItem pe = (ControlDetailItem)dv.FindItem("B1"); DevExpress.XtraEditors.SimpleButton Button = (DevExpress.XtraEditors.SimpleButton)pe.Control; Button.Click += new EventHandler(Button_Click);}

How To Find Master Object of ListView

2009-10-01T13:43:00.000+05:30

PropertyCollectionSource pcs = (PropertyCollectionSource)LV1.CollectionSource; DailyAttendenceSheet dcv = pcs.MasterObject as DailyAttendenceSheet; Here DailyAttendenceSheet is MasterObject means DetailView Here Lv1 is ListView

Enble Master View of GridView

2009-10-01T13:37:00.000+05:30

if (View is ListView && View.Id.Contains("ProfitAndLoss_ListView")) { ListView lv = (ListView)View; GridControl gc = (GridControl)lv.Control; GridView gv = (GridView)gc.FocusedView; gv.OptionsView.ShowDetailButtons = true; gv.OptionsDetail.EnableMasterViewMode = true; // gv.OptionsDetail.AllowZoomDetail = true; gv.OptionsDetail.AutoZoomDetail = true; }

Activate Panel on Class

2009-10-01T13:35:00.002+05:30

namespace PanelTesting.Module { public partial class PanelViewController : ViewController { public PanelViewController() { InitializeComponent(); RegisterActions(components); TargetObjectType = typeof(Panel); } protected override void OnActivated() { base.OnActivated(); View.ControlsCreated += new EventHandler(View_ControlsCreated); } void View_ControlsCreated(object sender, EventArgs e) { ((System.Windows.Forms.Control)View.Control).HandleCreated += new EventHandler(PanelViewController_HandleCreated); } void PanelViewController_HandleCreated(object sender, EventArgs e) { LabelControl lbTitle2 = new LabelControl(); lbTitle2.Appearance.BackColor = System.Drawing.Color.Transparent; lbTitle2.Appearance.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F); //lbTitle2.Appearance.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; //lbTitle2.Appearance.Options.UseBackColor = true; lbTitle2.Appearance.Options.UseFont = true; //lbTitle2.Appearance.Options.UseForeColor = true; lbTitle2.Location = new System.Drawing.Point(12, 32); lbTitle2.Name = "lbTitle2"; lbTitle2.Size = new System.Drawing.Size(183, 20); lbTitle2.TabIndex = 5; lbTitle2.Text = "by Cevious Technologies Pvt. Ltd."; // // lbTitle1 // LabelControl lbTitle1 = new LabelControl(); lbTitle1.Appearance.BackColor = System.Drawing.Color.Transparent; lbTitle1.Appearance.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold); //lbTitle1.Appearance.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; //lbTitle1.Appearance.Options.UseBackColor = true; lbTitle1.Appearance.Options.UseFont = true; //lbTitle1.Appearance.Options.UseForeColor = true; lbTitle1.Location = new System.Drawing.Point(12, 4); lbTitle1.Name = "lbTitle1"; lbTitle1.Size = new System.Drawing.Size(104, 20); lbTitle1.TabIndex = 4; lbTitle1.Text = "Applicatin Testing"; PanelControl lbCaption = new PanelControl(); lbCaption.Controls.Add(lbTitle2); lbCaption.Controls.Add(lbTitle1); lbCaption.Dock = System.Windows.Forms.DockStyle.Top; lbCaption.Font = new System.Drawing.Font("Tahoma", 14.25F, System.Drawing.FontStyle.Bold); //lbCaption.Font2 = new System.Drawing.Font("Tahoma", 11.25F); lbCaption.Location = new System.Drawing.Point(0, 0); lbCaption.Name = "lbCaption"; lbCaption.Size = new System.Drawing.Size(828, 60); lbCaption.TabIndex = 2; lbCaption.TabStop = false; lbCaption.SuspendLayout(); ((System.Windows.Forms.Control)sender).Parent.Controls.Add(lbCaption); } }

Hide Link Button From Associated Class

2009-10-01T13:35:00.001+05:30

if (View is ListView && !View.IsRoot && View.ObjectType==typeof(DemoTask)) { Frame.GetController().LinkObjectAction.Active.SetItemValue("myReason", false);}