Hi All,
would you give me a sample how I can create and consume a wcf to populate a treeview with categories and subcategories and datagrid with products in silverlight?
My database products consists from these tables:
CREATE TABLE `category` (
`cat_id` INT(10) NOT NULL AUTO_INCREMENT,
`catparent_id` VARCHAR(10) NULL DEFAULT NULL,
`cat_name` VARCHAR(100) NOT NULL,
`cat_image` LONGBLOB NULL,
PRIMARY KEY (`cat_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT
AUTO_INCREMENT=1
CREATE TABLE `product` (
`pd_id` INT(11) NOT NULL AUTO_INCREMENT,
`pd_name` VARCHAR(120) NOT NULL DEFAULT '""',
`pd_description` TEXT NOT NULL,
`pd_price` DECIMAL(7,2) NULL DEFAULT '0.00',
`pd_qty` SMALLINT(6) UNSIGNED NULL DEFAULT '0',
`pd_application` VARCHAR(255) NULL DEFAULT NULL,
`pd_image` LONGBLOB NULL,
`pd_thumb` LONGBLOB NULL,
`pdf_name` VARCHAR(100) NULL DEFAULT NULL,
`pd_pdf` LONGBLOB NULL,
`pd_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`pd_last_update` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`pd_id`),
INDEX `pd_name` (`pd_name`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT
AUTO_INCREMENT=1
CREATE TABLE `productcategory` (
`pd_id` INT(11) NOT NULL,
`cat_id` INT(11) NOT NULL,
PRIMARY KEY (`pd_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT
Thanks and regards,
Trifon.