Create Report from SQL Server C# 2005 - Crystal Reports
BarCode SDK sample in Crystal Reports demonstrating ‘Create Report from SQL Server C# 2005’
CrystalReport1.cs
//------------------------------------------------------------------------------
// <auto-generated>
// This code was generated by a tool.
// Runtime Version:2.0.50727.4927
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------
namespace ReportFromSqlServer {
using System;
using System.ComponentModel;
using CrystalDecisions.Shared;
using CrystalDecisions.ReportSource;
using CrystalDecisions.CrystalReports.Engine;
public class CrystalReport1 : ReportClass {
public CrystalReport1() {
}
public override string ResourceName {
get {
return "CrystalReport1.rpt";
}
set {
// Do nothing
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public CrystalDecisions.CrystalReports.Engine.Section Section1 {
get {
return this.ReportDefinition.Sections[0];
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public CrystalDecisions.CrystalReports.Engine.Section Section2 {
get {
return this.ReportDefinition.Sections[1];
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public CrystalDecisions.CrystalReports.Engine.Section Section3 {
get {
return this.ReportDefinition.Sections[2];
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public CrystalDecisions.CrystalReports.Engine.Section Section4 {
get {
return this.ReportDefinition.Sections[3];
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public CrystalDecisions.CrystalReports.Engine.Section Section5 {
get {
return this.ReportDefinition.Sections[4];
}
}
}
[System.Drawing.ToolboxBitmapAttribute(typeof(CrystalDecisions.Shared.ExportOptions), "report.bmp")]
public class CachedCrystalReport1 : Component, ICachedReport {
public CachedCrystalReport1() {
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public virtual bool IsCacheable {
get {
return true;
}
set {
//
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public virtual bool ShareDBLogonInfo {
get {
return false;
}
set {
//
}
}
[Browsable(false)]
[DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public virtual System.TimeSpan CacheTimeOut {
get {
return CachedReportConstants.DEFAULT_TIMEOUT;
}
set {
//
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return rpt;
}
public virtual string GetCustomizedCacheKey(RequestContext request) {
String key = null;
// // The following is the code used to generate the default
// // cache key for caching report jobs in the ASP.NET Cache.
// // Feel free to modify this code to suit your needs.
// // Returning key == null causes the default cache key to
// // be generated.
//
// key = RequestContext.BuildCompleteCacheKey(
// request,
// null, // sReportFilename
// this.GetType(),
// this.ShareDBLogonInfo );
return key;
}
}
}
DataSet1.Designer.cs
��/ / - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
/ / < a u t o - g e n e r a t e d >
/ / T h i s c o d e w a s g e n e r a t e d b y a t o o l .
/ / R u n t i m e V e r s i o n : 2 . 0 . 5 0 7 2 7 . 4 9 2 7
/ /
/ / C h a n g e s t o t h i s f i l e m a y c a u s e i n c o r r e c t b e h a v i o r a n d w i l l b e l o s t i f
/ / t h e c o d e i s r e g e n e r a t e d .
/ / < / a u t o - g e n e r a t e d >
/ / - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
# p r a g m a w a r n i n g d i s a b l e 1 5 9 1
n a m e s p a c e R e p o r t F r o m S q l S e r v e r {
/ / / < s u m m a r y >
/ / / R e p r e s e n t s a s t r o n g l y t y p e d i n - m e m o r y c a c h e o f d a t a .
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " S y s t e m . D a t a . D e s i g n . T y p e d D a t a S e t G e n e r a t o r " , " 2 . 0 . 0 . 0 " ) ]
[ g l o b a l : : S y s t e m . S e r i a l i z a b l e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r C a t e g o r y A t t r i b u t e ( " c o d e " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . T o o l b o x I t e m ( t r u e ) ]
[ g l o b a l : : S y s t e m . X m l . S e r i a l i z a t i o n . X m l S c h e m a P r o v i d e r A t t r i b u t e ( " G e t T y p e d D a t a S e t S c h e m a " ) ]
[ g l o b a l : : S y s t e m . X m l . S e r i a l i z a t i o n . X m l R o o t A t t r i b u t e ( " D a t a S e t 1 " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . D a t a S e t " ) ]
p u b l i c p a r t i a l c l a s s D a t a S e t 1 : g l o b a l : : S y s t e m . D a t a . D a t a S e t {
p r i v a t e P r o d u c t s D a t a T a b l e t a b l e P r o d u c t s ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . S c h e m a S e r i a l i z a t i o n M o d e _ s c h e m a S e r i a l i z a t i o n M o d e = g l o b a l : : S y s t e m . D a t a . S c h e m a S e r i a l i z a t i o n M o d e . I n c l u d e S c h e m a ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c D a t a S e t 1 ( ) {
t h i s . B e g i n I n i t ( ) ;
t h i s . I n i t C l a s s ( ) ;
g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t H a n d l e r s c h e m a C h a n g e d H a n d l e r = n e w g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t H a n d l e r ( t h i s . S c h e m a C h a n g e d ) ;
b a s e . T a b l e s . C o l l e c t i o n C h a n g e d + = s c h e m a C h a n g e d H a n d l e r ;
b a s e . R e l a t i o n s . C o l l e c t i o n C h a n g e d + = s c h e m a C h a n g e d H a n d l e r ;
t h i s . E n d I n i t ( ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d D a t a S e t 1 ( g l o b a l : : S y s t e m . R u n t i m e . S e r i a l i z a t i o n . S e r i a l i z a t i o n I n f o i n f o , g l o b a l : : S y s t e m . R u n t i m e . S e r i a l i z a t i o n . S t r e a m i n g C o n t e x t c o n t e x t ) :
b a s e ( i n f o , c o n t e x t , f a l s e ) {
i f ( ( t h i s . I s B i n a r y S e r i a l i z e d ( i n f o , c o n t e x t ) = = t r u e ) ) {
t h i s . I n i t V a r s ( f a l s e ) ;
g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t H a n d l e r s c h e m a C h a n g e d H a n d l e r 1 = n e w g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t H a n d l e r ( t h i s . S c h e m a C h a n g e d ) ;
t h i s . T a b l e s . C o l l e c t i o n C h a n g e d + = s c h e m a C h a n g e d H a n d l e r 1 ;
t h i s . R e l a t i o n s . C o l l e c t i o n C h a n g e d + = s c h e m a C h a n g e d H a n d l e r 1 ;
r e t u r n ;
}
s t r i n g s t r S c h e m a = ( ( s t r i n g ) ( i n f o . G e t V a l u e ( " X m l S c h e m a " , t y p e o f ( s t r i n g ) ) ) ) ;
i f ( ( t h i s . D e t e r m i n e S c h e m a S e r i a l i z a t i o n M o d e ( i n f o , c o n t e x t ) = = g l o b a l : : S y s t e m . D a t a . S c h e m a S e r i a l i z a t i o n M o d e . I n c l u d e S c h e m a ) ) {
g l o b a l : : S y s t e m . D a t a . D a t a S e t d s = n e w g l o b a l : : S y s t e m . D a t a . D a t a S e t ( ) ;
d s . R e a d X m l S c h e m a ( n e w g l o b a l : : S y s t e m . X m l . X m l T e x t R e a d e r ( n e w g l o b a l : : S y s t e m . I O . S t r i n g R e a d e r ( s t r S c h e m a ) ) ) ;
i f ( ( d s . T a b l e s [ " P r o d u c t s " ] ! = n u l l ) ) {
b a s e . T a b l e s . A d d ( n e w P r o d u c t s D a t a T a b l e ( d s . T a b l e s [ " P r o d u c t s " ] ) ) ;
}
t h i s . D a t a S e t N a m e = d s . D a t a S e t N a m e ;
t h i s . P r e f i x = d s . P r e f i x ;
t h i s . N a m e s p a c e = d s . N a m e s p a c e ;
t h i s . L o c a l e = d s . L o c a l e ;
t h i s . C a s e S e n s i t i v e = d s . C a s e S e n s i t i v e ;
t h i s . E n f o r c e C o n s t r a i n t s = d s . E n f o r c e C o n s t r a i n t s ;
t h i s . M e r g e ( d s , f a l s e , g l o b a l : : S y s t e m . D a t a . M i s s i n g S c h e m a A c t i o n . A d d ) ;
t h i s . I n i t V a r s ( ) ;
}
e l s e {
t h i s . R e a d X m l S c h e m a ( n e w g l o b a l : : S y s t e m . X m l . X m l T e x t R e a d e r ( n e w g l o b a l : : S y s t e m . I O . S t r i n g R e a d e r ( s t r S c h e m a ) ) ) ;
}
t h i s . G e t S e r i a l i z a t i o n D a t a ( i n f o , c o n t e x t ) ;
g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t H a n d l e r s c h e m a C h a n g e d H a n d l e r = n e w g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t H a n d l e r ( t h i s . S c h e m a C h a n g e d ) ;
b a s e . T a b l e s . C o l l e c t i o n C h a n g e d + = s c h e m a C h a n g e d H a n d l e r ;
t h i s . R e l a t i o n s . C o l l e c t i o n C h a n g e d + = s c h e m a C h a n g e d H a n d l e r ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . B r o w s a b l e ( f a l s e ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y . C o n t e n t ) ]
p u b l i c P r o d u c t s D a t a T a b l e P r o d u c t s {
g e t {
r e t u r n t h i s . t a b l e P r o d u c t s ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . B r o w s a b l e A t t r i b u t e ( t r u e ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y . V i s i b l e ) ]
p u b l i c o v e r r i d e g l o b a l : : S y s t e m . D a t a . S c h e m a S e r i a l i z a t i o n M o d e S c h e m a S e r i a l i z a t i o n M o d e {
g e t {
r e t u r n t h i s . _ s c h e m a S e r i a l i z a t i o n M o d e ;
}
s e t {
t h i s . _ s c h e m a S e r i a l i z a t i o n M o d e = v a l u e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y . H i d d e n ) ]
p u b l i c n e w g l o b a l : : S y s t e m . D a t a . D a t a T a b l e C o l l e c t i o n T a b l e s {
g e t {
r e t u r n b a s e . T a b l e s ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r S e r i a l i z a t i o n V i s i b i l i t y . H i d d e n ) ]
p u b l i c n e w g l o b a l : : S y s t e m . D a t a . D a t a R e l a t i o n C o l l e c t i o n R e l a t i o n s {
g e t {
r e t u r n b a s e . R e l a t i o n s ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e v o i d I n i t i a l i z e D e r i v e d D a t a S e t ( ) {
t h i s . B e g i n I n i t ( ) ;
t h i s . I n i t C l a s s ( ) ;
t h i s . E n d I n i t ( ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c o v e r r i d e g l o b a l : : S y s t e m . D a t a . D a t a S e t C l o n e ( ) {
D a t a S e t 1 c l n = ( ( D a t a S e t 1 ) ( b a s e . C l o n e ( ) ) ) ;
c l n . I n i t V a r s ( ) ;
c l n . S c h e m a S e r i a l i z a t i o n M o d e = t h i s . S c h e m a S e r i a l i z a t i o n M o d e ;
r e t u r n c l n ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e b o o l S h o u l d S e r i a l i z e T a b l e s ( ) {
r e t u r n f a l s e ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e b o o l S h o u l d S e r i a l i z e R e l a t i o n s ( ) {
r e t u r n f a l s e ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e v o i d R e a d X m l S e r i a l i z a b l e ( g l o b a l : : S y s t e m . X m l . X m l R e a d e r r e a d e r ) {
i f ( ( t h i s . D e t e r m i n e S c h e m a S e r i a l i z a t i o n M o d e ( r e a d e r ) = = g l o b a l : : S y s t e m . D a t a . S c h e m a S e r i a l i z a t i o n M o d e . I n c l u d e S c h e m a ) ) {
t h i s . R e s e t ( ) ;
g l o b a l : : S y s t e m . D a t a . D a t a S e t d s = n e w g l o b a l : : S y s t e m . D a t a . D a t a S e t ( ) ;
d s . R e a d X m l ( r e a d e r ) ;
i f ( ( d s . T a b l e s [ " P r o d u c t s " ] ! = n u l l ) ) {
b a s e . T a b l e s . A d d ( n e w P r o d u c t s D a t a T a b l e ( d s . T a b l e s [ " P r o d u c t s " ] ) ) ;
}
t h i s . D a t a S e t N a m e = d s . D a t a S e t N a m e ;
t h i s . P r e f i x = d s . P r e f i x ;
t h i s . N a m e s p a c e = d s . N a m e s p a c e ;
t h i s . L o c a l e = d s . L o c a l e ;
t h i s . C a s e S e n s i t i v e = d s . C a s e S e n s i t i v e ;
t h i s . E n f o r c e C o n s t r a i n t s = d s . E n f o r c e C o n s t r a i n t s ;
t h i s . M e r g e ( d s , f a l s e , g l o b a l : : S y s t e m . D a t a . M i s s i n g S c h e m a A c t i o n . A d d ) ;
t h i s . I n i t V a r s ( ) ;
}
e l s e {
t h i s . R e a d X m l ( r e a d e r ) ;
t h i s . I n i t V a r s ( ) ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a G e t S c h e m a S e r i a l i z a b l e ( ) {
g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m s t r e a m = n e w g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m ( ) ;
t h i s . W r i t e X m l S c h e m a ( n e w g l o b a l : : S y s t e m . X m l . X m l T e x t W r i t e r ( s t r e a m , n u l l ) ) ;
s t r e a m . P o s i t i o n = 0 ;
r e t u r n g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a . R e a d ( n e w g l o b a l : : S y s t e m . X m l . X m l T e x t R e a d e r ( s t r e a m ) , n u l l ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
i n t e r n a l v o i d I n i t V a r s ( ) {
t h i s . I n i t V a r s ( t r u e ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
i n t e r n a l v o i d I n i t V a r s ( b o o l i n i t T a b l e ) {
t h i s . t a b l e P r o d u c t s = ( ( P r o d u c t s D a t a T a b l e ) ( b a s e . T a b l e s [ " P r o d u c t s " ] ) ) ;
i f ( ( i n i t T a b l e = = t r u e ) ) {
i f ( ( t h i s . t a b l e P r o d u c t s ! = n u l l ) ) {
t h i s . t a b l e P r o d u c t s . I n i t V a r s ( ) ;
}
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e v o i d I n i t C l a s s ( ) {
t h i s . D a t a S e t N a m e = " D a t a S e t 1 " ;
t h i s . P r e f i x = " " ;
t h i s . N a m e s p a c e = " h t t p : / / t e m p u r i . o r g / D a t a S e t 1 . x s d " ;
t h i s . E n f o r c e C o n s t r a i n t s = t r u e ;
t h i s . S c h e m a S e r i a l i z a t i o n M o d e = g l o b a l : : S y s t e m . D a t a . S c h e m a S e r i a l i z a t i o n M o d e . I n c l u d e S c h e m a ;
t h i s . t a b l e P r o d u c t s = n e w P r o d u c t s D a t a T a b l e ( ) ;
b a s e . T a b l e s . A d d ( t h i s . t a b l e P r o d u c t s ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e b o o l S h o u l d S e r i a l i z e P r o d u c t s ( ) {
r e t u r n f a l s e ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e v o i d S c h e m a C h a n g e d ( o b j e c t s e n d e r , g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e E v e n t A r g s e ) {
i f ( ( e . A c t i o n = = g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o l l e c t i o n C h a n g e A c t i o n . R e m o v e ) ) {
t h i s . I n i t V a r s ( ) ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c s t a t i c g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o m p l e x T y p e G e t T y p e d D a t a S e t S c h e m a ( g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a S e t x s ) {
D a t a S e t 1 d s = n e w D a t a S e t 1 ( ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o m p l e x T y p e t y p e = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o m p l e x T y p e ( ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a S e q u e n c e s e q u e n c e = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a S e q u e n c e ( ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A n y a n y = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A n y ( ) ;
a n y . N a m e s p a c e = d s . N a m e s p a c e ;
s e q u e n c e . I t e m s . A d d ( a n y ) ;
t y p e . P a r t i c l e = s e q u e n c e ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a d s S c h e m a = d s . G e t S c h e m a S e r i a l i z a b l e ( ) ;
i f ( x s . C o n t a i n s ( d s S c h e m a . T a r g e t N a m e s p a c e ) ) {
g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m s 1 = n e w g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m ( ) ;
g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m s 2 = n e w g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m ( ) ;
t r y {
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a s c h e m a = n u l l ;
d s S c h e m a . W r i t e ( s 1 ) ;
f o r ( g l o b a l : : S y s t e m . C o l l e c t i o n s . I E n u m e r a t o r s c h e m a s = x s . S c h e m a s ( d s S c h e m a . T a r g e t N a m e s p a c e ) . G e t E n u m e r a t o r ( ) ; s c h e m a s . M o v e N e x t ( ) ; ) {
s c h e m a = ( ( g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a ) ( s c h e m a s . C u r r e n t ) ) ;
s 2 . S e t L e n g t h ( 0 ) ;
s c h e m a . W r i t e ( s 2 ) ;
i f ( ( s 1 . L e n g t h = = s 2 . L e n g t h ) ) {
s 1 . P o s i t i o n = 0 ;
s 2 . P o s i t i o n = 0 ;
f o r ( ; ( ( s 1 . P o s i t i o n ! = s 1 . L e n g t h )
& & ( s 1 . R e a d B y t e ( ) = = s 2 . R e a d B y t e ( ) ) ) ; ) {
;
}
i f ( ( s 1 . P o s i t i o n = = s 1 . L e n g t h ) ) {
r e t u r n t y p e ;
}
}
}
}
f i n a l l y {
i f ( ( s 1 ! = n u l l ) ) {
s 1 . C l o s e ( ) ;
}
i f ( ( s 2 ! = n u l l ) ) {
s 2 . C l o s e ( ) ;
}
}
}
x s . A d d ( d s S c h e m a ) ;
r e t u r n t y p e ;
}
p u b l i c d e l e g a t e v o i d P r o d u c t s R o w C h a n g e E v e n t H a n d l e r ( o b j e c t s e n d e r , P r o d u c t s R o w C h a n g e E v e n t e ) ;
/ / / < s u m m a r y >
/ / / R e p r e s e n t s t h e s t r o n g l y n a m e d D a t a T a b l e c l a s s .
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " S y s t e m . D a t a . D e s i g n . T y p e d D a t a S e t G e n e r a t o r " , " 2 . 0 . 0 . 0 " ) ]
[ g l o b a l : : S y s t e m . S e r i a l i z a b l e ( ) ]
[ g l o b a l : : S y s t e m . X m l . S e r i a l i z a t i o n . X m l S c h e m a P r o v i d e r A t t r i b u t e ( " G e t T y p e d T a b l e S c h e m a " ) ]
p u b l i c p a r t i a l c l a s s P r o d u c t s D a t a T a b l e : g l o b a l : : S y s t e m . D a t a . D a t a T a b l e , g l o b a l : : S y s t e m . C o l l e c t i o n s . I E n u m e r a b l e {
p r i v a t e g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n c o l u m n P r o d u c t _ I D ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n c o l u m n P r o d u c t _ N a m e ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n c o l u m n P r o d u c t _ D e s c r i p t i o n ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n c o l u m n B a r C o d e ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s D a t a T a b l e ( ) {
t h i s . T a b l e N a m e = " P r o d u c t s " ;
t h i s . B e g i n I n i t ( ) ;
t h i s . I n i t C l a s s ( ) ;
t h i s . E n d I n i t ( ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
i n t e r n a l P r o d u c t s D a t a T a b l e ( g l o b a l : : S y s t e m . D a t a . D a t a T a b l e t a b l e ) {
t h i s . T a b l e N a m e = t a b l e . T a b l e N a m e ;
i f ( ( t a b l e . C a s e S e n s i t i v e ! = t a b l e . D a t a S e t . C a s e S e n s i t i v e ) ) {
t h i s . C a s e S e n s i t i v e = t a b l e . C a s e S e n s i t i v e ;
}
i f ( ( t a b l e . L o c a l e . T o S t r i n g ( ) ! = t a b l e . D a t a S e t . L o c a l e . T o S t r i n g ( ) ) ) {
t h i s . L o c a l e = t a b l e . L o c a l e ;
}
i f ( ( t a b l e . N a m e s p a c e ! = t a b l e . D a t a S e t . N a m e s p a c e ) ) {
t h i s . N a m e s p a c e = t a b l e . N a m e s p a c e ;
}
t h i s . P r e f i x = t a b l e . P r e f i x ;
t h i s . M i n i m u m C a p a c i t y = t a b l e . M i n i m u m C a p a c i t y ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d P r o d u c t s D a t a T a b l e ( g l o b a l : : S y s t e m . R u n t i m e . S e r i a l i z a t i o n . S e r i a l i z a t i o n I n f o i n f o , g l o b a l : : S y s t e m . R u n t i m e . S e r i a l i z a t i o n . S t r e a m i n g C o n t e x t c o n t e x t ) :
b a s e ( i n f o , c o n t e x t ) {
t h i s . I n i t V a r s ( ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n P r o d u c t _ I D C o l u m n {
g e t {
r e t u r n t h i s . c o l u m n P r o d u c t _ I D ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n P r o d u c t _ N a m e C o l u m n {
g e t {
r e t u r n t h i s . c o l u m n P r o d u c t _ N a m e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n P r o d u c t _ D e s c r i p t i o n C o l u m n {
g e t {
r e t u r n t h i s . c o l u m n P r o d u c t _ D e s c r i p t i o n ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n B a r C o d e C o l u m n {
g e t {
r e t u r n t h i s . c o l u m n B a r C o d e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . B r o w s a b l e ( f a l s e ) ]
p u b l i c i n t C o u n t {
g e t {
r e t u r n t h i s . R o w s . C o u n t ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s R o w t h i s [ i n t i n d e x ] {
g e t {
r e t u r n ( ( P r o d u c t s R o w ) ( t h i s . R o w s [ i n d e x ] ) ) ;
}
}
p u b l i c e v e n t P r o d u c t s R o w C h a n g e E v e n t H a n d l e r P r o d u c t s R o w C h a n g i n g ;
p u b l i c e v e n t P r o d u c t s R o w C h a n g e E v e n t H a n d l e r P r o d u c t s R o w C h a n g e d ;
p u b l i c e v e n t P r o d u c t s R o w C h a n g e E v e n t H a n d l e r P r o d u c t s R o w D e l e t i n g ;
p u b l i c e v e n t P r o d u c t s R o w C h a n g e E v e n t H a n d l e r P r o d u c t s R o w D e l e t e d ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v o i d A d d P r o d u c t s R o w ( P r o d u c t s R o w r o w ) {
t h i s . R o w s . A d d ( r o w ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s R o w A d d P r o d u c t s R o w ( i n t P r o d u c t _ I D , s t r i n g P r o d u c t _ N a m e , s t r i n g P r o d u c t _ D e s c r i p t i o n , b y t e [ ] B a r C o d e ) {
P r o d u c t s R o w r o w P r o d u c t s R o w = ( ( P r o d u c t s R o w ) ( t h i s . N e w R o w ( ) ) ) ;
o b j e c t [ ] c o l u m n V a l u e s A r r a y = n e w o b j e c t [ ] {
P r o d u c t _ I D ,
P r o d u c t _ N a m e ,
P r o d u c t _ D e s c r i p t i o n ,
B a r C o d e } ;
r o w P r o d u c t s R o w . I t e m A r r a y = c o l u m n V a l u e s A r r a y ;
t h i s . R o w s . A d d ( r o w P r o d u c t s R o w ) ;
r e t u r n r o w P r o d u c t s R o w ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v i r t u a l g l o b a l : : S y s t e m . C o l l e c t i o n s . I E n u m e r a t o r G e t E n u m e r a t o r ( ) {
r e t u r n t h i s . R o w s . G e t E n u m e r a t o r ( ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c o v e r r i d e g l o b a l : : S y s t e m . D a t a . D a t a T a b l e C l o n e ( ) {
P r o d u c t s D a t a T a b l e c l n = ( ( P r o d u c t s D a t a T a b l e ) ( b a s e . C l o n e ( ) ) ) ;
c l n . I n i t V a r s ( ) ;
r e t u r n c l n ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e g l o b a l : : S y s t e m . D a t a . D a t a T a b l e C r e a t e I n s t a n c e ( ) {
r e t u r n n e w P r o d u c t s D a t a T a b l e ( ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
i n t e r n a l v o i d I n i t V a r s ( ) {
t h i s . c o l u m n P r o d u c t _ I D = b a s e . C o l u m n s [ " P r o d u c t I D " ] ;
t h i s . c o l u m n P r o d u c t _ N a m e = b a s e . C o l u m n s [ " P r o d u c t N a m e " ] ;
t h i s . c o l u m n P r o d u c t _ D e s c r i p t i o n = b a s e . C o l u m n s [ " P r o d u c t D e s c r i p t i o n " ] ;
t h i s . c o l u m n B a r C o d e = b a s e . C o l u m n s [ " B a r C o d e " ] ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e v o i d I n i t C l a s s ( ) {
t h i s . c o l u m n P r o d u c t _ I D = n e w g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n ( " P r o d u c t I D " , t y p e o f ( i n t ) , n u l l , g l o b a l : : S y s t e m . D a t a . M a p p i n g T y p e . E l e m e n t ) ;
b a s e . C o l u m n s . A d d ( t h i s . c o l u m n P r o d u c t _ I D ) ;
t h i s . c o l u m n P r o d u c t _ N a m e = n e w g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n ( " P r o d u c t N a m e " , t y p e o f ( s t r i n g ) , n u l l , g l o b a l : : S y s t e m . D a t a . M a p p i n g T y p e . E l e m e n t ) ;
b a s e . C o l u m n s . A d d ( t h i s . c o l u m n P r o d u c t _ N a m e ) ;
t h i s . c o l u m n P r o d u c t _ D e s c r i p t i o n = n e w g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n ( " P r o d u c t D e s c r i p t i o n " , t y p e o f ( s t r i n g ) , n u l l , g l o b a l : : S y s t e m . D a t a . M a p p i n g T y p e . E l e m e n t ) ;
b a s e . C o l u m n s . A d d ( t h i s . c o l u m n P r o d u c t _ D e s c r i p t i o n ) ;
t h i s . c o l u m n B a r C o d e = n e w g l o b a l : : S y s t e m . D a t a . D a t a C o l u m n ( " B a r C o d e " , t y p e o f ( b y t e [ ] ) , n u l l , g l o b a l : : S y s t e m . D a t a . M a p p i n g T y p e . E l e m e n t ) ;
b a s e . C o l u m n s . A d d ( t h i s . c o l u m n B a r C o d e ) ;
t h i s . c o l u m n P r o d u c t _ N a m e . M a x L e n g t h = 1 0 0 ;
t h i s . c o l u m n P r o d u c t _ D e s c r i p t i o n . M a x L e n g t h = 2 5 5 ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s R o w N e w P r o d u c t s R o w ( ) {
r e t u r n ( ( P r o d u c t s R o w ) ( t h i s . N e w R o w ( ) ) ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e g l o b a l : : S y s t e m . D a t a . D a t a R o w N e w R o w F r o m B u i l d e r ( g l o b a l : : S y s t e m . D a t a . D a t a R o w B u i l d e r b u i l d e r ) {
r e t u r n n e w P r o d u c t s R o w ( b u i l d e r ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e g l o b a l : : S y s t e m . T y p e G e t R o w T y p e ( ) {
r e t u r n t y p e o f ( P r o d u c t s R o w ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e v o i d O n R o w C h a n g e d ( g l o b a l : : S y s t e m . D a t a . D a t a R o w C h a n g e E v e n t A r g s e ) {
b a s e . O n R o w C h a n g e d ( e ) ;
i f ( ( t h i s . P r o d u c t s R o w C h a n g e d ! = n u l l ) ) {
t h i s . P r o d u c t s R o w C h a n g e d ( t h i s , n e w P r o d u c t s R o w C h a n g e E v e n t ( ( ( P r o d u c t s R o w ) ( e . R o w ) ) , e . A c t i o n ) ) ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e v o i d O n R o w C h a n g i n g ( g l o b a l : : S y s t e m . D a t a . D a t a R o w C h a n g e E v e n t A r g s e ) {
b a s e . O n R o w C h a n g i n g ( e ) ;
i f ( ( t h i s . P r o d u c t s R o w C h a n g i n g ! = n u l l ) ) {
t h i s . P r o d u c t s R o w C h a n g i n g ( t h i s , n e w P r o d u c t s R o w C h a n g e E v e n t ( ( ( P r o d u c t s R o w ) ( e . R o w ) ) , e . A c t i o n ) ) ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e v o i d O n R o w D e l e t e d ( g l o b a l : : S y s t e m . D a t a . D a t a R o w C h a n g e E v e n t A r g s e ) {
b a s e . O n R o w D e l e t e d ( e ) ;
i f ( ( t h i s . P r o d u c t s R o w D e l e t e d ! = n u l l ) ) {
t h i s . P r o d u c t s R o w D e l e t e d ( t h i s , n e w P r o d u c t s R o w C h a n g e E v e n t ( ( ( P r o d u c t s R o w ) ( e . R o w ) ) , e . A c t i o n ) ) ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d o v e r r i d e v o i d O n R o w D e l e t i n g ( g l o b a l : : S y s t e m . D a t a . D a t a R o w C h a n g e E v e n t A r g s e ) {
b a s e . O n R o w D e l e t i n g ( e ) ;
i f ( ( t h i s . P r o d u c t s R o w D e l e t i n g ! = n u l l ) ) {
t h i s . P r o d u c t s R o w D e l e t i n g ( t h i s , n e w P r o d u c t s R o w C h a n g e E v e n t ( ( ( P r o d u c t s R o w ) ( e . R o w ) ) , e . A c t i o n ) ) ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v o i d R e m o v e P r o d u c t s R o w ( P r o d u c t s R o w r o w ) {
t h i s . R o w s . R e m o v e ( r o w ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c s t a t i c g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o m p l e x T y p e G e t T y p e d T a b l e S c h e m a ( g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a S e t x s ) {
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o m p l e x T y p e t y p e = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o m p l e x T y p e ( ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a S e q u e n c e s e q u e n c e = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a S e q u e n c e ( ) ;
D a t a S e t 1 d s = n e w D a t a S e t 1 ( ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A n y a n y 1 = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A n y ( ) ;
a n y 1 . N a m e s p a c e = " h t t p : / / w w w . w 3 . o r g / 2 0 0 1 / X M L S c h e m a " ;
a n y 1 . M i n O c c u r s = n e w d e c i m a l ( 0 ) ;
a n y 1 . M a x O c c u r s = d e c i m a l . M a x V a l u e ;
a n y 1 . P r o c e s s C o n t e n t s = g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o n t e n t P r o c e s s i n g . L a x ;
s e q u e n c e . I t e m s . A d d ( a n y 1 ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A n y a n y 2 = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A n y ( ) ;
a n y 2 . N a m e s p a c e = " u r n : s c h e m a s - m i c r o s o f t - c o m : x m l - d i f f g r a m - v 1 " ;
a n y 2 . M i n O c c u r s = n e w d e c i m a l ( 1 ) ;
a n y 2 . P r o c e s s C o n t e n t s = g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a C o n t e n t P r o c e s s i n g . L a x ;
s e q u e n c e . I t e m s . A d d ( a n y 2 ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A t t r i b u t e a t t r i b u t e 1 = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A t t r i b u t e ( ) ;
a t t r i b u t e 1 . N a m e = " n a m e s p a c e " ;
a t t r i b u t e 1 . F i x e d V a l u e = d s . N a m e s p a c e ;
t y p e . A t t r i b u t e s . A d d ( a t t r i b u t e 1 ) ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A t t r i b u t e a t t r i b u t e 2 = n e w g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a A t t r i b u t e ( ) ;
a t t r i b u t e 2 . N a m e = " t a b l e T y p e N a m e " ;
a t t r i b u t e 2 . F i x e d V a l u e = " P r o d u c t s D a t a T a b l e " ;
t y p e . A t t r i b u t e s . A d d ( a t t r i b u t e 2 ) ;
t y p e . P a r t i c l e = s e q u e n c e ;
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a d s S c h e m a = d s . G e t S c h e m a S e r i a l i z a b l e ( ) ;
i f ( x s . C o n t a i n s ( d s S c h e m a . T a r g e t N a m e s p a c e ) ) {
g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m s 1 = n e w g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m ( ) ;
g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m s 2 = n e w g l o b a l : : S y s t e m . I O . M e m o r y S t r e a m ( ) ;
t r y {
g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a s c h e m a = n u l l ;
d s S c h e m a . W r i t e ( s 1 ) ;
f o r ( g l o b a l : : S y s t e m . C o l l e c t i o n s . I E n u m e r a t o r s c h e m a s = x s . S c h e m a s ( d s S c h e m a . T a r g e t N a m e s p a c e ) . G e t E n u m e r a t o r ( ) ; s c h e m a s . M o v e N e x t ( ) ; ) {
s c h e m a = ( ( g l o b a l : : S y s t e m . X m l . S c h e m a . X m l S c h e m a ) ( s c h e m a s . C u r r e n t ) ) ;
s 2 . S e t L e n g t h ( 0 ) ;
s c h e m a . W r i t e ( s 2 ) ;
i f ( ( s 1 . L e n g t h = = s 2 . L e n g t h ) ) {
s 1 . P o s i t i o n = 0 ;
s 2 . P o s i t i o n = 0 ;
f o r ( ; ( ( s 1 . P o s i t i o n ! = s 1 . L e n g t h )
& & ( s 1 . R e a d B y t e ( ) = = s 2 . R e a d B y t e ( ) ) ) ; ) {
;
}
i f ( ( s 1 . P o s i t i o n = = s 1 . L e n g t h ) ) {
r e t u r n t y p e ;
}
}
}
}
f i n a l l y {
i f ( ( s 1 ! = n u l l ) ) {
s 1 . C l o s e ( ) ;
}
i f ( ( s 2 ! = n u l l ) ) {
s 2 . C l o s e ( ) ;
}
}
}
x s . A d d ( d s S c h e m a ) ;
r e t u r n t y p e ;
}
}
/ / / < s u m m a r y >
/ / / R e p r e s e n t s s t r o n g l y n a m e d D a t a R o w c l a s s .
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " S y s t e m . D a t a . D e s i g n . T y p e d D a t a S e t G e n e r a t o r " , " 2 . 0 . 0 . 0 " ) ]
p u b l i c p a r t i a l c l a s s P r o d u c t s R o w : g l o b a l : : S y s t e m . D a t a . D a t a R o w {
p r i v a t e P r o d u c t s D a t a T a b l e t a b l e P r o d u c t s ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
i n t e r n a l P r o d u c t s R o w ( g l o b a l : : S y s t e m . D a t a . D a t a R o w B u i l d e r r b ) :
b a s e ( r b ) {
t h i s . t a b l e P r o d u c t s = ( ( P r o d u c t s D a t a T a b l e ) ( t h i s . T a b l e ) ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c i n t P r o d u c t _ I D {
g e t {
t r y {
r e t u r n ( ( i n t ) ( t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ I D C o l u m n ] ) ) ;
}
c a t c h ( g l o b a l : : S y s t e m . I n v a l i d C a s t E x c e p t i o n e ) {
t h r o w n e w g l o b a l : : S y s t e m . D a t a . S t r o n g T y p i n g E x c e p t i o n ( " T h e v a l u e f o r c o l u m n \ ' P r o d u c t I D \ ' i n t a b l e \ ' P r o d u c t s \ ' i s D B N u l l . " , e ) ;
}
}
s e t {
t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ I D C o l u m n ] = v a l u e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c s t r i n g P r o d u c t _ N a m e {
g e t {
t r y {
r e t u r n ( ( s t r i n g ) ( t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ N a m e C o l u m n ] ) ) ;
}
c a t c h ( g l o b a l : : S y s t e m . I n v a l i d C a s t E x c e p t i o n e ) {
t h r o w n e w g l o b a l : : S y s t e m . D a t a . S t r o n g T y p i n g E x c e p t i o n ( " T h e v a l u e f o r c o l u m n \ ' P r o d u c t N a m e \ ' i n t a b l e \ ' P r o d u c t s \ ' i s D B N u l l . " , e ) ;
}
}
s e t {
t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ N a m e C o l u m n ] = v a l u e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c s t r i n g P r o d u c t _ D e s c r i p t i o n {
g e t {
t r y {
r e t u r n ( ( s t r i n g ) ( t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ D e s c r i p t i o n C o l u m n ] ) ) ;
}
c a t c h ( g l o b a l : : S y s t e m . I n v a l i d C a s t E x c e p t i o n e ) {
t h r o w n e w g l o b a l : : S y s t e m . D a t a . S t r o n g T y p i n g E x c e p t i o n ( " T h e v a l u e f o r c o l u m n \ ' P r o d u c t D e s c r i p t i o n \ ' i n t a b l e \ ' P r o d u c t s \ ' i s D B N u l l . " , e ) ;
}
}
s e t {
t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ D e s c r i p t i o n C o l u m n ] = v a l u e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c b y t e [ ] B a r C o d e {
g e t {
t r y {
r e t u r n ( ( b y t e [ ] ) ( t h i s [ t h i s . t a b l e P r o d u c t s . B a r C o d e C o l u m n ] ) ) ;
}
c a t c h ( g l o b a l : : S y s t e m . I n v a l i d C a s t E x c e p t i o n e ) {
t h r o w n e w g l o b a l : : S y s t e m . D a t a . S t r o n g T y p i n g E x c e p t i o n ( " T h e v a l u e f o r c o l u m n \ ' B a r C o d e \ ' i n t a b l e \ ' P r o d u c t s \ ' i s D B N u l l . " , e ) ;
}
}
s e t {
t h i s [ t h i s . t a b l e P r o d u c t s . B a r C o d e C o l u m n ] = v a l u e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c b o o l I s P r o d u c t _ I D N u l l ( ) {
r e t u r n t h i s . I s N u l l ( t h i s . t a b l e P r o d u c t s . P r o d u c t _ I D C o l u m n ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v o i d S e t P r o d u c t _ I D N u l l ( ) {
t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ I D C o l u m n ] = g l o b a l : : S y s t e m . C o n v e r t . D B N u l l ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c b o o l I s P r o d u c t _ N a m e N u l l ( ) {
r e t u r n t h i s . I s N u l l ( t h i s . t a b l e P r o d u c t s . P r o d u c t _ N a m e C o l u m n ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v o i d S e t P r o d u c t _ N a m e N u l l ( ) {
t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ N a m e C o l u m n ] = g l o b a l : : S y s t e m . C o n v e r t . D B N u l l ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c b o o l I s P r o d u c t _ D e s c r i p t i o n N u l l ( ) {
r e t u r n t h i s . I s N u l l ( t h i s . t a b l e P r o d u c t s . P r o d u c t _ D e s c r i p t i o n C o l u m n ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v o i d S e t P r o d u c t _ D e s c r i p t i o n N u l l ( ) {
t h i s [ t h i s . t a b l e P r o d u c t s . P r o d u c t _ D e s c r i p t i o n C o l u m n ] = g l o b a l : : S y s t e m . C o n v e r t . D B N u l l ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c b o o l I s B a r C o d e N u l l ( ) {
r e t u r n t h i s . I s N u l l ( t h i s . t a b l e P r o d u c t s . B a r C o d e C o l u m n ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c v o i d S e t B a r C o d e N u l l ( ) {
t h i s [ t h i s . t a b l e P r o d u c t s . B a r C o d e C o l u m n ] = g l o b a l : : S y s t e m . C o n v e r t . D B N u l l ;
}
}
/ / / < s u m m a r y >
/ / / R o w e v e n t a r g u m e n t c l a s s
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " S y s t e m . D a t a . D e s i g n . T y p e d D a t a S e t G e n e r a t o r " , " 2 . 0 . 0 . 0 " ) ]
p u b l i c c l a s s P r o d u c t s R o w C h a n g e E v e n t : g l o b a l : : S y s t e m . E v e n t A r g s {
p r i v a t e P r o d u c t s R o w e v e n t R o w ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . D a t a R o w A c t i o n e v e n t A c t i o n ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s R o w C h a n g e E v e n t ( P r o d u c t s R o w r o w , g l o b a l : : S y s t e m . D a t a . D a t a R o w A c t i o n a c t i o n ) {
t h i s . e v e n t R o w = r o w ;
t h i s . e v e n t A c t i o n = a c t i o n ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s R o w R o w {
g e t {
r e t u r n t h i s . e v e n t R o w ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c g l o b a l : : S y s t e m . D a t a . D a t a R o w A c t i o n A c t i o n {
g e t {
r e t u r n t h i s . e v e n t A c t i o n ;
}
}
}
}
}
n a m e s p a c e R e p o r t F r o m S q l S e r v e r . D a t a S e t 1 T a b l e A d a p t e r s {
/ / / < s u m m a r y >
/ / / R e p r e s e n t s t h e c o n n e c t i o n a n d c o m m a n d s u s e d t o r e t r i e v e a n d s a v e d a t a .
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " S y s t e m . D a t a . D e s i g n . T y p e d D a t a S e t G e n e r a t o r " , " 2 . 0 . 0 . 0 " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r C a t e g o r y A t t r i b u t e ( " c o d e " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . T o o l b o x I t e m ( t r u e ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t A t t r i b u t e ( t r u e ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n e r A t t r i b u t e ( " M i c r o s o f t . V S D e s i g n e r . D a t a S o u r c e . D e s i g n . T a b l e A d a p t e r D e s i g n e r , M i c r o s o f t . V S D e s i g n e r " +
" , V e r s i o n = 8 . 0 . 0 . 0 , C u l t u r e = n e u t r a l , P u b l i c K e y T o k e n = b 0 3 f 5 f 7 f 1 1 d 5 0 a 3 a " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
p u b l i c p a r t i a l c l a s s P r o d u c t s T a b l e A d a p t e r : g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . C o m p o n e n t {
p r i v a t e g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l D a t a A d a p t e r _ a d a p t e r ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o n n e c t i o n _ c o n n e c t i o n ;
p r i v a t e g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o m m a n d [ ] _ c o m m a n d C o l l e c t i o n ;
p r i v a t e b o o l _ c l e a r B e f o r e F i l l ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c P r o d u c t s T a b l e A d a p t e r ( ) {
t h i s . C l e a r B e f o r e F i l l = t r u e ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l D a t a A d a p t e r A d a p t e r {
g e t {
i f ( ( t h i s . _ a d a p t e r = = n u l l ) ) {
t h i s . I n i t A d a p t e r ( ) ;
}
r e t u r n t h i s . _ a d a p t e r ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
i n t e r n a l g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o n n e c t i o n C o n n e c t i o n {
g e t {
i f ( ( t h i s . _ c o n n e c t i o n = = n u l l ) ) {
t h i s . I n i t C o n n e c t i o n ( ) ;
}
r e t u r n t h i s . _ c o n n e c t i o n ;
}
s e t {
t h i s . _ c o n n e c t i o n = v a l u e ;
i f ( ( t h i s . A d a p t e r . I n s e r t C o m m a n d ! = n u l l ) ) {
t h i s . A d a p t e r . I n s e r t C o m m a n d . C o n n e c t i o n = v a l u e ;
}
i f ( ( t h i s . A d a p t e r . D e l e t e C o m m a n d ! = n u l l ) ) {
t h i s . A d a p t e r . D e l e t e C o m m a n d . C o n n e c t i o n = v a l u e ;
}
i f ( ( t h i s . A d a p t e r . U p d a t e C o m m a n d ! = n u l l ) ) {
t h i s . A d a p t e r . U p d a t e C o m m a n d . C o n n e c t i o n = v a l u e ;
}
f o r ( i n t i = 0 ; ( i < t h i s . C o m m a n d C o l l e c t i o n . L e n g t h ) ; i = ( i + 1 ) ) {
i f ( ( t h i s . C o m m a n d C o l l e c t i o n [ i ] ! = n u l l ) ) {
( ( g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o m m a n d ) ( t h i s . C o m m a n d C o l l e c t i o n [ i ] ) ) . C o n n e c t i o n = v a l u e ;
}
}
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r o t e c t e d g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o m m a n d [ ] C o m m a n d C o l l e c t i o n {
g e t {
i f ( ( t h i s . _ c o m m a n d C o l l e c t i o n = = n u l l ) ) {
t h i s . I n i t C o m m a n d C o l l e c t i o n ( ) ;
}
r e t u r n t h i s . _ c o m m a n d C o l l e c t i o n ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p u b l i c b o o l C l e a r B e f o r e F i l l {
g e t {
r e t u r n t h i s . _ c l e a r B e f o r e F i l l ;
}
s e t {
t h i s . _ c l e a r B e f o r e F i l l = v a l u e ;
}
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e v o i d I n i t A d a p t e r ( ) {
t h i s . _ a d a p t e r = n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l D a t a A d a p t e r ( ) ;
g l o b a l : : S y s t e m . D a t a . C o m m o n . D a t a T a b l e M a p p i n g t a b l e M a p p i n g = n e w g l o b a l : : S y s t e m . D a t a . C o m m o n . D a t a T a b l e M a p p i n g ( ) ;
t a b l e M a p p i n g . S o u r c e T a b l e = " T a b l e " ;
t a b l e M a p p i n g . D a t a S e t T a b l e = " P r o d u c t s " ;
t a b l e M a p p i n g . C o l u m n M a p p i n g s . A d d ( " P r o d u c t I D " , " P r o d u c t I D " ) ;
t a b l e M a p p i n g . C o l u m n M a p p i n g s . A d d ( " P r o d u c t N a m e " , " P r o d u c t N a m e " ) ;
t a b l e M a p p i n g . C o l u m n M a p p i n g s . A d d ( " P r o d u c t D e s c r i p t i o n " , " P r o d u c t D e s c r i p t i o n " ) ;
t h i s . _ a d a p t e r . T a b l e M a p p i n g s . A d d ( t a b l e M a p p i n g ) ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d = n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o m m a n d ( ) ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d . C o n n e c t i o n = t h i s . C o n n e c t i o n ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d . C o m m a n d T e x t = " I N S E R T I N T O [ d b o ] . [ P r o d u c t s ] ( [ P r o d u c t I D ] , [ P r o d u c t N a m e ] , [ P r o d u c t D e s c r i p t i o n ] " +
" ) V A L U E S ( @ P r o d u c t _ I D , @ P r o d u c t _ N a m e , @ P r o d u c t _ D e s c r i p t i o n ) " ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d . C o m m a n d T y p e = g l o b a l : : S y s t e m . D a t a . C o m m a n d T y p e . T e x t ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s . A d d ( n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l P a r a m e t e r ( " @ P r o d u c t _ I D " , g l o b a l : : S y s t e m . D a t a . S q l D b T y p e . I n t , 0 , g l o b a l : : S y s t e m . D a t a . P a r a m e t e r D i r e c t i o n . I n p u t , 0 , 0 , " P r o d u c t I D " , g l o b a l : : S y s t e m . D a t a . D a t a R o w V e r s i o n . C u r r e n t , f a l s e , n u l l , " " , " " , " " ) ) ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s . A d d ( n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l P a r a m e t e r ( " @ P r o d u c t _ N a m e " , g l o b a l : : S y s t e m . D a t a . S q l D b T y p e . N V a r C h a r , 0 , g l o b a l : : S y s t e m . D a t a . P a r a m e t e r D i r e c t i o n . I n p u t , 0 , 0 , " P r o d u c t N a m e " , g l o b a l : : S y s t e m . D a t a . D a t a R o w V e r s i o n . C u r r e n t , f a l s e , n u l l , " " , " " , " " ) ) ;
t h i s . _ a d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s . A d d ( n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l P a r a m e t e r ( " @ P r o d u c t _ D e s c r i p t i o n " , g l o b a l : : S y s t e m . D a t a . S q l D b T y p e . N V a r C h a r , 0 , g l o b a l : : S y s t e m . D a t a . P a r a m e t e r D i r e c t i o n . I n p u t , 0 , 0 , " P r o d u c t D e s c r i p t i o n " , g l o b a l : : S y s t e m . D a t a . D a t a R o w V e r s i o n . C u r r e n t , f a l s e , n u l l , " " , " " , " " ) ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e v o i d I n i t C o n n e c t i o n ( ) {
t h i s . _ c o n n e c t i o n = n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o n n e c t i o n ( ) ;
t h i s . _ c o n n e c t i o n . C o n n e c t i o n S t r i n g = g l o b a l : : R e p o r t F r o m S q l S e r v e r . P r o p e r t i e s . S e t t i n g s . D e f a u l t . e x a m p l e _ d b C o n n e c t i o n S t r i n g ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
p r i v a t e v o i d I n i t C o m m a n d C o l l e c t i o n ( ) {
t h i s . _ c o m m a n d C o l l e c t i o n = n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o m m a n d [ 1 ] ;
t h i s . _ c o m m a n d C o l l e c t i o n [ 0 ] = n e w g l o b a l : : S y s t e m . D a t a . S q l C l i e n t . S q l C o m m a n d ( ) ;
t h i s . _ c o m m a n d C o l l e c t i o n [ 0 ] . C o n n e c t i o n = t h i s . C o n n e c t i o n ;
t h i s . _ c o m m a n d C o l l e c t i o n [ 0 ] . C o m m a n d T e x t = " S E L E C T [ P r o d u c t I D ] , [ P r o d u c t N a m e ] , [ P r o d u c t D e s c r i p t i o n ] F R O M d b o . P r o d u c t s " ;
t h i s . _ c o m m a n d C o l l e c t i o n [ 0 ] . C o m m a n d T y p e = g l o b a l : : S y s t e m . D a t a . C o m m a n d T y p e . T e x t ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t M e t h o d A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t M e t h o d T y p e . F i l l , t r u e ) ]
p u b l i c v i r t u a l i n t F i l l ( D a t a S e t 1 . P r o d u c t s D a t a T a b l e d a t a T a b l e ) {
t h i s . A d a p t e r . S e l e c t C o m m a n d = t h i s . C o m m a n d C o l l e c t i o n [ 0 ] ;
i f ( ( t h i s . C l e a r B e f o r e F i l l = = t r u e ) ) {
d a t a T a b l e . C l e a r ( ) ;
}
i n t r e t u r n V a l u e = t h i s . A d a p t e r . F i l l ( d a t a T a b l e ) ;
r e t u r n r e t u r n V a l u e ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t M e t h o d A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t M e t h o d T y p e . S e l e c t , t r u e ) ]
p u b l i c v i r t u a l D a t a S e t 1 . P r o d u c t s D a t a T a b l e G e t D a t a ( ) {
t h i s . A d a p t e r . S e l e c t C o m m a n d = t h i s . C o m m a n d C o l l e c t i o n [ 0 ] ;
D a t a S e t 1 . P r o d u c t s D a t a T a b l e d a t a T a b l e = n e w D a t a S e t 1 . P r o d u c t s D a t a T a b l e ( ) ;
t h i s . A d a p t e r . F i l l ( d a t a T a b l e ) ;
r e t u r n d a t a T a b l e ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
p u b l i c v i r t u a l i n t U p d a t e ( D a t a S e t 1 . P r o d u c t s D a t a T a b l e d a t a T a b l e ) {
r e t u r n t h i s . A d a p t e r . U p d a t e ( d a t a T a b l e ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
p u b l i c v i r t u a l i n t U p d a t e ( D a t a S e t 1 d a t a S e t ) {
r e t u r n t h i s . A d a p t e r . U p d a t e ( d a t a S e t , " P r o d u c t s " ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
p u b l i c v i r t u a l i n t U p d a t e ( g l o b a l : : S y s t e m . D a t a . D a t a R o w d a t a R o w ) {
r e t u r n t h i s . A d a p t e r . U p d a t e ( n e w g l o b a l : : S y s t e m . D a t a . D a t a R o w [ ] {
d a t a R o w } ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
p u b l i c v i r t u a l i n t U p d a t e ( g l o b a l : : S y s t e m . D a t a . D a t a R o w [ ] d a t a R o w s ) {
r e t u r n t h i s . A d a p t e r . U p d a t e ( d a t a R o w s ) ;
}
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D e s i g n . H e l p K e y w o r d A t t r i b u t e ( " v s . d a t a . T a b l e A d a p t e r " ) ]
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t M e t h o d A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . D a t a O b j e c t M e t h o d T y p e . I n s e r t , t r u e ) ]
p u b l i c v i r t u a l i n t I n s e r t ( g l o b a l : : S y s t e m . N u l l a b l e < i n t > P r o d u c t _ I D , s t r i n g P r o d u c t _ N a m e , s t r i n g P r o d u c t _ D e s c r i p t i o n ) {
i f ( ( P r o d u c t _ I D . H a s V a l u e = = t r u e ) ) {
t h i s . A d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s [ 0 ] . V a l u e = ( ( i n t ) ( P r o d u c t _ I D . V a l u e ) ) ;
}
e l s e {
t h i s . A d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s [ 0 ] . V a l u e = g l o b a l : : S y s t e m . D B N u l l . V a l u e ;
}
i f ( ( P r o d u c t _ N a m e = = n u l l ) ) {
t h i s . A d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s [ 1 ] . V a l u e = g l o b a l : : S y s t e m . D B N u l l . V a l u e ;
}
e l s e {
t h i s . A d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s [ 1 ] . V a l u e = ( ( s t r i n g ) ( P r o d u c t _ N a m e ) ) ;
}
i f ( ( P r o d u c t _ D e s c r i p t i o n = = n u l l ) ) {
t h i s . A d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s [ 2 ] . V a l u e = g l o b a l : : S y s t e m . D B N u l l . V a l u e ;
}
e l s e {
t h i s . A d a p t e r . I n s e r t C o m m a n d . P a r a m e t e r s [ 2 ] . V a l u e = ( ( s t r i n g ) ( P r o d u c t _ D e s c r i p t i o n ) ) ;
}
g l o b a l : : S y s t e m . D a t a . C o n n e c t i o n S t a t e p r e v i o u s C o n n e c t i o n S t a t e = t h i s . A d a p t e r . I n s e r t C o m m a n d . C o n n e c t i o n . S t a t e ;
i f ( ( ( t h i s . A d a p t e r . I n s e r t C o m m a n d . C o n n e c t i o n . S t a t e & g l o b a l : : S y s t e m . D a t a . C o n n e c t i o n S t a t e . O p e n )
! = g l o b a l : : S y s t e m . D a t a . C o n n e c t i o n S t a t e . O p e n ) ) {
t h i s . A d a p t e r . I n s e r t C o m m a n d . C o n n e c t i o n . O p e n ( ) ;
}
t r y {
i n t r e t u r n V a l u e = t h i s . A d a p t e r . I n s e r t C o m m a n d . E x e c u t e N o n Q u e r y ( ) ;
r e t u r n r e t u r n V a l u e ;
}
f i n a l l y {
i f ( ( p r e v i o u s C o n n e c t i o n S t a t e = = g l o b a l : : S y s t e m . D a t a . C o n n e c t i o n S t a t e . C l o s e d ) ) {
t h i s . A d a p t e r . I n s e r t C o m m a n d . C o n n e c t i o n . C l o s e ( ) ;
}
}
}
}
}
# p r a g m a w a r n i n g r e s t o r e 1 5 9 1
DataSet1.xsc
<?xml version="1.0" encoding="utf-8"?>
<!--<autogenerated>
This code was generated by a tool.
Changes to this file may cause incorrect behavior and will be lost if
the code is regenerated.
</autogenerated>-->
<DataSetUISetting Version="1.00" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<TableUISettings>
</TableUISettings>
</DataSetUISetting>
DataSet1.xsd
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="example_dbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="example_dbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ReportFromSqlServer.Properties.Settings.GlobalReference.Default.example_dbConnectionString" Provider="System.Data.SqlClient">
</Connection>
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
<MainSource>
<DbSource ConnectionRef="example_dbConnectionString (Settings)" DbObjectName="example_db.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>INSERT INTO [dbo].[Products] ([Product ID], [Product Name], [Product Description]) VALUES (@Product_ID, @Product_Name, @Product_Description)</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Product_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Product_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Product_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Product Description" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>SELECT [Product ID], [Product Name], [Product Description] FROM dbo.Products</CommandText>
<Parameters>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Product ID" DataSetColumn="Product ID" />
<Mapping SourceColumn="Product Name" DataSetColumn="Product Name" />
<Mapping SourceColumn="Product Description" DataSetColumn="Product Description" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
</Tables>
<Sources>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Products" msprop:Generator_UserTableName="Products" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_TablePropName="Products">
<xs:complexType>
<xs:sequence>
<xs:element name="Product_x0020_ID" msprop:Generator_UserColumnName="Product ID" msprop:Generator_ColumnVarNameInTable="columnProduct_ID" msprop:Generator_ColumnPropNameInRow="Product_ID" msprop:Generator_ColumnPropNameInTable="Product_IDColumn" type="xs:int" minOccurs="0" />
<xs:element name="Product_x0020_Name" msprop:Generator_UserColumnName="Product Name" msprop:Generator_ColumnVarNameInTable="columnProduct_Name" msprop:Generator_ColumnPropNameInRow="Product_Name" msprop:Generator_ColumnPropNameInTable="Product_NameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Product_x0020_Description" msprop:Generator_UserColumnName="Product Description" msprop:Generator_ColumnVarNameInTable="columnProduct_Description" msprop:Generator_ColumnPropNameInRow="Product_Description" msprop:Generator_ColumnPropNameInTable="Product_DescriptionColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn" type="xs:base64Binary" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
DataSet1.xss
<?xml version="1.0" encoding="utf-8"?>
<!--<autogenerated>
This code was generated by a tool to store the dataset designer's layout information.
Changes to this file may cause incorrect behavior and will be lost if
the code is regenerated.
</autogenerated>-->
<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="0" ViewPortY="0" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout">
<Shapes>
<Shape ID="DesignTable:Products" ZOrder="1" X="232" Y="126" Height="153" Width="196" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="102" />
</Shapes>
<Connectors />
</DiagramLayout>
Form1.Designer.cs
��n a m e s p a c e R e p o r t F r o m S q l S e r v e r
{
p a r t i a l c l a s s F o r m 1
{
p r i v a t e S y s t e m . C o m p o n e n t M o d e l . I C o n t a i n e r c o m p o n e n t s = n u l l ;
p r o t e c t e d o v e r r i d e v o i d D i s p o s e ( b o o l d i s p o s i n g )
{
i f ( d i s p o s i n g & & ( c o m p o n e n t s ! = n u l l ) )
{
c o m p o n e n t s . D i s p o s e ( ) ;
}
b a s e . D i s p o s e ( d i s p o s i n g ) ;
}
# r e g i o n W i n d o w s F o r m D e s i g n e r g e n e r a t e d c o d e
p r i v a t e v o i d I n i t i a l i z e C o m p o n e n t ( )
{
t h i s . c r y s t a l R e p o r t V i e w e r 1 = n e w C r y s t a l D e c i s i o n s . W i n d o w s . F o r m s . C r y s t a l R e p o r t V i e w e r ( ) ;
t h i s . C r y s t a l R e p o r t 1 1 = n e w R e p o r t F r o m S q l S e r v e r . C r y s t a l R e p o r t 1 ( ) ;
t h i s . S u s p e n d L a y o u t ( ) ;
/ /
/ / c r y s t a l R e p o r t V i e w e r 1
/ /
t h i s . c r y s t a l R e p o r t V i e w e r 1 . A c t i v e V i e w I n d e x = 0 ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . B o r d e r S t y l e = S y s t e m . W i n d o w s . F o r m s . B o r d e r S t y l e . F i x e d S i n g l e ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . D o c k = S y s t e m . W i n d o w s . F o r m s . D o c k S t y l e . F i l l ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . L o c a t i o n = n e w S y s t e m . D r a w i n g . P o i n t ( 0 , 0 ) ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . N a m e = " c r y s t a l R e p o r t V i e w e r 1 " ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . R e p o r t S o u r c e = t h i s . C r y s t a l R e p o r t 1 1 ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . S i z e = n e w S y s t e m . D r a w i n g . S i z e ( 7 9 9 , 5 6 6 ) ;
t h i s . c r y s t a l R e p o r t V i e w e r 1 . T a b I n d e x = 0 ;
/ /
/ / F o r m 1
/ /
t h i s . A u t o S c a l e D i m e n s i o n s = n e w S y s t e m . D r a w i n g . S i z e F ( 6 F , 1 3 F ) ;
t h i s . A u t o S c a l e M o d e = S y s t e m . W i n d o w s . F o r m s . A u t o S c a l e M o d e . F o n t ;
t h i s . C l i e n t S i z e = n e w S y s t e m . D r a w i n g . S i z e ( 7 9 9 , 5 6 6 ) ;
t h i s . C o n t r o l s . A d d ( t h i s . c r y s t a l R e p o r t V i e w e r 1 ) ;
t h i s . N a m e = " F o r m 1 " ;
t h i s . T e x t = " F o r m 1 " ;
t h i s . R e s u m e L a y o u t ( f a l s e ) ;
}
# e n d r e g i o n
p r i v a t e C r y s t a l D e c i s i o n s . W i n d o w s . F o r m s . C r y s t a l R e p o r t V i e w e r c r y s t a l R e p o r t V i e w e r 1 ;
p r i v a t e C r y s t a l R e p o r t 1 C r y s t a l R e p o r t 1 1 ;
}
}
Form1.cs
using System;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using System.Data.SqlClient;
using Bytescout.BarCode;
namespace ReportFromSqlServer
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
try
{
// MODIFY THE CONNECTION STRING WITH YOUR SERVER CONNECTION INFO!!!
const string connectionString = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=master;Integrated Security=true;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
// Create a database for demonstration purposes
///////////////////////////////////////////////////////////////////////////////////////
Object o = ExecuteQueryScalar(connection, "SELECT DB_ID('example_db')");
// if 'example_db' does not exist, create it
if (o == null || o is DBNull)
{
// Create empty database
ExecuteQueryWithoutResult(connection, "CREATE DATABASE example_db");
// Switch to created database
ExecuteQueryWithoutResult(connection, "USE example_db");
// Create a table
ExecuteQueryWithoutResult(connection, "CREATE TABLE Products ([Product ID] int, [Product Name] nvarchar(100), [Product Description] nvarchar(255))");
// Fill the table with data
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(1, 'Spreadsheet Tools', 'Convert XLS, XLSX, CSV, ODS spreadsheet into HTML, PDF, XLS, XLSX, CSV formats WITHOUT EXCEL installed')");
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(2, 'Watermarking PRO', 'Professional tool to protect images: multiple watermarks, custom position for watermarks, image effects, EXIF and IPTC macros for text and more')");
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(3, 'Watermarking', 'Protect copyrights for your images with professional looking watermarks with this easy to use tool')");
ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(4, 'PPT To Video Scout', 'converts PowerPoint presentations (PPT, PPTX) into AVI,MPEG,WMV, FLV (flash video) video movies with sound')");
}
// Create a datataset from query.
// Query result columns must conform to field names we used in the report designer
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT [Product ID], [Product Name], [Product Description] FROM example_db.dbo.Products", connection);
// fill dataset
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
// don't forget to close the connection
connection.Close();
// add virtual column into the result table
dataSet.Tables[0].Columns.Add(new DataColumn("BarCode", typeof(byte[])));
// create barcode object
Barcode bc = new Barcode(SymbologyType.Code39);
bc.DrawCaption = false;
foreach (DataRow row in dataSet.Tables[0].Rows)
{
// set barcode value
bc.Value = (Convert.ToString(row["Product ID"]));
// retrieve generated image bytes
byte[] barcodeBytes = bc.GetImageBytesWMF();
// fill virtual column with generated image bytes
row["BarCode"] = barcodeBytes;
}
// set report datasource
CrystalReport11.SetDataSource(dataSet.Tables[0]);
}
}
catch (Exception ex)
{
Trace.WriteLine("Error: " + ex.Message);
}
}
private static void ExecuteQueryWithoutResult(SqlConnection connection, string query)
{
using (SqlCommand command = new SqlCommand(query, connection))
{
command.ExecuteNonQuery();
}
}
private static object ExecuteQueryScalar(SqlConnection connection, string query)
{
using (SqlCommand command = new SqlCommand(query, connection))
{
return command.ExecuteScalar();
}
}
}
}
Program.cs
using System;
using System.Collections.Generic;
using System.Windows.Forms;
namespace ReportFromSqlServer
{
static class Program
{
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.Run(new Form1());
}
}
}
Resources.Designer.cs
��/ / - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
/ / < a u t o - g e n e r a t e d >
/ / T h i s c o d e w a s g e n e r a t e d b y a t o o l .
/ / R u n t i m e V e r s i o n : 2 . 0 . 5 0 7 2 7 . 4 9 2 7
/ /
/ / C h a n g e s t o t h i s f i l e m a y c a u s e i n c o r r e c t b e h a v i o r a n d w i l l b e l o s t i f
/ / t h e c o d e i s r e g e n e r a t e d .
/ / < / a u t o - g e n e r a t e d >
/ / - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
n a m e s p a c e R e p o r t F r o m S q l S e r v e r . P r o p e r t i e s {
u s i n g S y s t e m ;
/ / / < s u m m a r y >
/ / / A s t r o n g l y - t y p e d r e s o u r c e c l a s s , f o r l o o k i n g u p l o c a l i z e d s t r i n g s , e t c .
/ / / < / s u m m a r y >
/ / T h i s c l a s s w a s a u t o - g e n e r a t e d b y t h e S t r o n g l y T y p e d R e s o u r c e B u i l d e r
/ / c l a s s v i a a t o o l l i k e R e s G e n o r V i s u a l S t u d i o .
/ / T o a d d o r r e m o v e a m e m b e r , e d i t y o u r . R e s X f i l e t h e n r e r u n R e s G e n
/ / w i t h t h e / s t r o p t i o n , o r r e b u i l d y o u r V S p r o j e c t .
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " S y s t e m . R e s o u r c e s . T o o l s . S t r o n g l y T y p e d R e s o u r c e B u i l d e r " , " 2 . 0 . 0 . 0 " ) ]
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . R u n t i m e . C o m p i l e r S e r v i c e s . C o m p i l e r G e n e r a t e d A t t r i b u t e ( ) ]
i n t e r n a l c l a s s R e s o u r c e s {
p r i v a t e s t a t i c g l o b a l : : S y s t e m . R e s o u r c e s . R e s o u r c e M a n a g e r r e s o u r c e M a n ;
p r i v a t e s t a t i c g l o b a l : : S y s t e m . G l o b a l i z a t i o n . C u l t u r e I n f o r e s o u r c e C u l t u r e ;
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . C o d e A n a l y s i s . S u p p r e s s M e s s a g e A t t r i b u t e ( " M i c r o s o f t . P e r f o r m a n c e " , " C A 1 8 1 1 : A v o i d U n c a l l e d P r i v a t e C o d e " ) ]
i n t e r n a l R e s o u r c e s ( ) {
}
/ / / < s u m m a r y >
/ / / R e t u r n s t h e c a c h e d R e s o u r c e M a n a g e r i n s t a n c e u s e d b y t h i s c l a s s .
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . E d i t o r B r o w s a b l e A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . E d i t o r B r o w s a b l e S t a t e . A d v a n c e d ) ]
i n t e r n a l s t a t i c g l o b a l : : S y s t e m . R e s o u r c e s . R e s o u r c e M a n a g e r R e s o u r c e M a n a g e r {
g e t {
i f ( o b j e c t . R e f e r e n c e E q u a l s ( r e s o u r c e M a n , n u l l ) ) {
g l o b a l : : S y s t e m . R e s o u r c e s . R e s o u r c e M a n a g e r t e m p = n e w g l o b a l : : S y s t e m . R e s o u r c e s . R e s o u r c e M a n a g e r ( " R e p o r t F r o m S q l S e r v e r . P r o p e r t i e s . R e s o u r c e s " , t y p e o f ( R e s o u r c e s ) . A s s e m b l y ) ;
r e s o u r c e M a n = t e m p ;
}
r e t u r n r e s o u r c e M a n ;
}
}
/ / / < s u m m a r y >
/ / / O v e r r i d e s t h e c u r r e n t t h r e a d ' s C u r r e n t U I C u l t u r e p r o p e r t y f o r a l l
/ / / r e s o u r c e l o o k u p s u s i n g t h i s s t r o n g l y t y p e d r e s o u r c e c l a s s .
/ / / < / s u m m a r y >
[ g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . E d i t o r B r o w s a b l e A t t r i b u t e ( g l o b a l : : S y s t e m . C o m p o n e n t M o d e l . E d i t o r B r o w s a b l e S t a t e . A d v a n c e d ) ]
i n t e r n a l s t a t i c g l o b a l : : S y s t e m . G l o b a l i z a t i o n . C u l t u r e I n f o C u l t u r e {
g e t {
r e t u r n r e s o u r c e C u l t u r e ;
}
s e t {
r e s o u r c e C u l t u r e = v a l u e ;
}
}
}
}
Settings.Designer.cs
��/ / - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
/ / < a u t o - g e n e r a t e d >
/ / T h i s c o d e w a s g e n e r a t e d b y a t o o l .
/ / R u n t i m e V e r s i o n : 2 . 0 . 5 0 7 2 7 . 4 9 2 7
/ /
/ / C h a n g e s t o t h i s f i l e m a y c a u s e i n c o r r e c t b e h a v i o r a n d w i l l b e l o s t i f
/ / t h e c o d e i s r e g e n e r a t e d .
/ / < / a u t o - g e n e r a t e d >
/ / - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
n a m e s p a c e R e p o r t F r o m S q l S e r v e r . P r o p e r t i e s {
[ g l o b a l : : S y s t e m . R u n t i m e . C o m p i l e r S e r v i c e s . C o m p i l e r G e n e r a t e d A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o d e D o m . C o m p i l e r . G e n e r a t e d C o d e A t t r i b u t e ( " M i c r o s o f t . V i s u a l S t u d i o . E d i t o r s . S e t t i n g s D e s i g n e r . S e t t i n g s S i n g l e F i l e G e n e r a t o r " , " 8 . 0 . 0 . 0 " ) ]
i n t e r n a l s e a l e d p a r t i a l c l a s s S e t t i n g s : g l o b a l : : S y s t e m . C o n f i g u r a t i o n . A p p l i c a t i o n S e t t i n g s B a s e {
p r i v a t e s t a t i c S e t t i n g s d e f a u l t I n s t a n c e = ( ( S e t t i n g s ) ( g l o b a l : : S y s t e m . C o n f i g u r a t i o n . A p p l i c a t i o n S e t t i n g s B a s e . S y n c h r o n i z e d ( n e w S e t t i n g s ( ) ) ) ) ;
p u b l i c s t a t i c S e t t i n g s D e f a u l t {
g e t {
r e t u r n d e f a u l t I n s t a n c e ;
}
}
[ g l o b a l : : S y s t e m . C o n f i g u r a t i o n . A p p l i c a t i o n S c o p e d S e t t i n g A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . D i a g n o s t i c s . D e b u g g e r N o n U s e r C o d e A t t r i b u t e ( ) ]
[ g l o b a l : : S y s t e m . C o n f i g u r a t i o n . S p e c i a l S e t t i n g A t t r i b u t e ( g l o b a l : : S y s t e m . C o n f i g u r a t i o n . S p e c i a l S e t t i n g . C o n n e c t i o n S t r i n g ) ]
[ g l o b a l : : S y s t e m . C o n f i g u r a t i o n . D e f a u l t S e t t i n g V a l u e A t t r i b u t e ( " D a t a S o u r c e = S T A R K O V \ \ S Q L E X P R E S S ; I n i t i a l C a t a l o g = e x a m p l e _ d b ; I n t e g r a t e d S e c u r i t y = T r u " +
" e " ) ]
p u b l i c s t r i n g e x a m p l e _ d b C o n n e c t i o n S t r i n g {
g e t {
r e t u r n ( ( s t r i n g ) ( t h i s [ " e x a m p l e _ d b C o n n e c t i o n S t r i n g " ] ) ) ;
}
}
}
}