!
http://code.msdn.microsoft.com/mschart
!
!
2009/11/24
2009/11/05
LINQ Retrieve Last Records
var GenerateCodeList = (from a in dc.allProductInfos
join b in dc.Processors on new {id = a.id} equals new {id = b.id} into b_join
from b in b_join.DefaultIfEmpty()
where a.id.Contains("QRT%")
orderby a.MRTP_id descending
select new ProductItem
{
ProductCode = a.id,
MST = b.mst,
CPC = b.cpc_cd,
GroupId = a.prd_grp_id,
GroupName = a.prd_grp_txt,
Requestor = b.user,
DateCreated = b.change_date
}).Take(20).ToList();
!
join b in dc.Processors on new {id = a.id} equals new {id = b.id} into b_join
from b in b_join.DefaultIfEmpty()
where a.id.Contains("QRT%")
orderby a.MRTP_id descending
select new ProductItem
{
ProductCode = a.id,
MST = b.mst,
CPC = b.cpc_cd,
GroupId = a.prd_grp_id,
GroupName = a.prd_grp_txt,
Requestor = b.user,
DateCreated = b.change_date
}).Take(20).ToList();
!
2009/09/20
MySQL Script Sample
DROP DATABASE IF EXISTS DB1;
CREATE DATABASE DB1;
USE DB1;
DROP TABLE IF EXISTS COMPONENT;
DROP TABLE IF EXISTS AREA;
DROP TABLE IF EXISTS ITEM;
CREATE TABLE AREA
(
AREA_ID SMALLINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(50),
PRIMARY KEY (AREA_ID)
);
CREATE TABLE ITEM
(
ITEM_ID SMALLINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(50),
PRIMARY KEY (ITEM_ID)
);
CREATE TABLE COMPONENT
(
COMPONENT_ID INT NOT NULL AUTO_INCREMENT,
AREA_ID SMALLINT,
ITEM_ID SMALLINT,
NAME VARCHAR(50),
UNIT VARCHAR(50),
IN_STOCK INT,
PRIMARY KEY (COMPONENT_ID),
FOREIGN KEY (AREA_ID) REFERENCES AREA(AREA_ID) ON DELETE SET NULL,
FOREIGN KEY (ITEM_ID) REFERENCES ITEM(ITEM_ID) ON DELETE SET NULL
);
!
CREATE DATABASE DB1;
USE DB1;
DROP TABLE IF EXISTS COMPONENT;
DROP TABLE IF EXISTS AREA;
DROP TABLE IF EXISTS ITEM;
CREATE TABLE AREA
(
AREA_ID SMALLINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(50),
PRIMARY KEY (AREA_ID)
);
CREATE TABLE ITEM
(
ITEM_ID SMALLINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(50),
PRIMARY KEY (ITEM_ID)
);
CREATE TABLE COMPONENT
(
COMPONENT_ID INT NOT NULL AUTO_INCREMENT,
AREA_ID SMALLINT,
ITEM_ID SMALLINT,
NAME VARCHAR(50),
UNIT VARCHAR(50),
IN_STOCK INT,
PRIMARY KEY (COMPONENT_ID),
FOREIGN KEY (AREA_ID) REFERENCES AREA(AREA_ID) ON DELETE SET NULL,
FOREIGN KEY (ITEM_ID) REFERENCES ITEM(ITEM_ID) ON DELETE SET NULL
);
!
2009/08/20
Watch DLL Function Names
1. Start -> All Programs -> Visual Studio 2005 -> Visual Studio Tools -> Visual Studio 2005 Command Prompt
2. type "dumpbin /exports [path\filenames.dll]"
!
2. type "dumpbin /exports [path\filenames.dll]"
!
2009/08/19
Dynamic Link Library (DLL)
From Wikipedia,
Dynamic-link library (also written without the hyphen), or DLL, is Microsoft's implementation of the shared library concept in the Microsoft Windows and OS/2 operating systems. These libraries usually have the file extension DLL, OCX (for libraries containing ActiveX controls), or DRV (for legacy system drivers). The file formats for DLLs are the same as for Windows EXE files — that is, Portable Executable (PE) for 32-bit and 64-bit Windows, and New Executable (NE) for 16-bit Windows. As with EXEs, DLLs can contain code, data, and resources, in any combination.
In the broader sense of the term, any data file with the same file format can be called a resource DLL. Examples of such DLLs include icon libraries, sometimes having the extension ICL, and font files, having the extensions FON and FOT.
!
2009/08/18
Remove Advertisement from Gmail in FireFox
Opera / Firefox User:
1. Install add-on stylish.
2. Select "write new style" option, and add the following code to build a css file.
!
1. Install add-on stylish.
2. Select "write new style" option, and add the following code to build a css file.
!
Subscribe to:
Posts (Atom)