Infragistics NetAdvantage 3D Bar Charts

A Bar Chart shows the changes in a data series over time or compares multiple items. Types of items are arranged vertically and data values are plotted horizontally to emphasize variation over time. A Column Chart shows the changes in a data series over time or compares multiple items. Types of items are arranged horizontally and data values are plotted vertically to emphasize variation over time.

Default.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/SamplePage.master" AutoEventWireup="false"

    CodeFile="Default.aspx.cs" Inherits="Samples_WebCharts_Display_Bar_And_Column_Charts_3D_Bar_And_Column_Charts_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="Server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">

    <table id="Table1" cellspacing="1" cellpadding="4" border="0">

        <tr>

            <td>

                <igchart:UltraChart ID="UltraChart1" runat="server" Width="300px" ChartType="BarChart3D"

                    Height="300px" Transform3D-Perspective="50" Transform3D-ZRotation="0" Transform3D-Scale="50"

                    Transform3D-XRotation="144" Transform3D-YRotation="54">

                    <Data SwapRowsAndColumns="True" />

                    <ColorModel AlphaLevel="255" ModelStyle="CustomSkin">

                        <Skin ApplyRowWise="True">

                            <PEs>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="108, 162, 36" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="7, 108, 176" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="215, 0, 5" Hatch="None" Texture="LightGrain" ImageFitStyle="StretchedFit"

                                    FillStopColor="Transparent" StrokeOpacity="255" ImagePath="" Stroke="Black" StrokeWidth="1"

                                    ImageWrapMode="Tile" TextureApplication="Normal"></igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="243, 204, 3" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="252, 122, 10" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                            </PEs>

                        </Skin>

                    </ColorModel>

                    <Axis>

                        <X Visible="True" TickmarkStyle="Smart">

                            <Labels ItemFormatString="&lt;DATA_VALUE:00.##&gt;" VerticalAlign="Center" Font="Verdana, 7pt"

                                FontColor="Black" Orientation="Horizontal" Visible="True" HorizontalAlign="Near" />

                        </X>

                        <Y Visible="True">

                            <Labels ItemFormatString="&lt;ITEM_LABEL&gt;" VerticalAlign="Center" Font="Verdana, 7pt, style=Bold"

                                FontColor="Black" Orientation="Horizontal" Visible="True" HorizontalAlign="Far" />

                        </Y>

                        <Z Visible="True">

                            <Labels ItemFormatString="&lt;SERIES_LABEL&gt;" VerticalAlign="Center" Font="Verdana, 7pt"

                                FontColor="Black" Orientation="Horizontal" Visible="True" HorizontalAlign="Near" />

                        </Z>

                        <X2 Visible="False" />

                        <Y2 Visible="False" />

                        <Z2 Visible="False" />

                    </Axis>

                    <DeploymentScenario Scenario="FileSystem" ImageURL="/SamplesBrowser/Temp/ChartImages/Chart_#SEQNUM(100).png"

                        ImageType="Png" FilePath="/SamplesBrowser/Temp/ChartImages" />

                    <Tooltips BorderThickness="1" Overflow="None" FormatString="&lt;DATA_VALUE:00.##&gt;"

                        EnableFadingEffect="False" Format="DataValue" FontColor="Black" BorderColor="Black"

                        Display="MouseMove" BackColor="AntiqueWhite" Padding="0"></Tooltips>

                </igchart:UltraChart>

            </td>

            <td>

                <igchart:UltraChart ID="UltraChart2" runat="server" Width="300px" ChartType="ColumnChart3D"

                    Transform3D-Perspective="50" Transform3D-ZRotation="0" Transform3D-Scale="55"

                    Transform3D-XRotation="145" Transform3D-YRotation="51">

                    <Data SwapRowsAndColumns="True" />

                    <ColorModel AlphaLevel="255" ModelStyle="CustomSkin">

                        <Skin ApplyRowWise="True">

                            <PEs>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="108, 162, 36" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="7, 108, 176" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="215, 0, 5" Hatch="None" Texture="LightGrain" ImageFitStyle="StretchedFit"

                                    FillStopColor="Transparent" StrokeOpacity="255" ImagePath="" Stroke="Black" StrokeWidth="1"

                                    ImageWrapMode="Tile" TextureApplication="Normal"></igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="243, 204, 3" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                                <igchartprop:PaintElement FillGradientStyle="None" FillOpacity="255" FillStopOpacity="255"

                                    ElementType="SolidFill" Fill="252, 122, 10" Hatch="None" Texture="LightGrain"

                                    ImageFitStyle="StretchedFit" FillStopColor="Transparent" StrokeOpacity="255"

                                    ImagePath="" Stroke="Black" StrokeWidth="1" ImageWrapMode="Tile" TextureApplication="Normal">

                                </igchartprop:PaintElement>

                            </PEs>

                        </Skin>

                    </ColorModel>

                    <Axis>

                        <X Visible="True">

                            <Labels ItemFormatString="&lt;ITEM_LABEL&gt;" VerticalAlign="Center" Font="Verdana, 7pt"

                                FontColor="Black" Orientation="VerticalLeftFacing" Visible="True" HorizontalAlign="Near" />

                        </X>

                        <Y Visible="True" TickmarkStyle="Smart">

                            <Labels ItemFormatString="&lt;DATA_VALUE:00.##&gt;" VerticalAlign="Center" Font="Verdana, 7pt, style=Bold"

                                FontColor="Black" Orientation="Horizontal" Visible="True" HorizontalAlign="Far" />

                        </Y>

                        <Z Visible="True">

                            <Labels ItemFormatString="&lt;SERIES_LABEL&gt;" VerticalAlign="Center" Font="Verdana, 7pt"

                                FontColor="Black" Orientation="Horizontal" Visible="True" HorizontalAlign="Far" />

                        </Z>

                        <X2 Visible="False" />

                        <Y2 Visible="False" />

                        <Z2 Visible="False" />

                    </Axis>

                    <DeploymentScenario Scenario="FileSystem" ImageURL="/SamplesBrowser/Temp/ChartImages/Chart_#SEQNUM(100).png"

                        ImageType="Png" FilePath="/SamplesBrowser/Temp/ChartImages"></DeploymentScenario>

                    <Tooltips BorderThickness="1" Overflow="None" FormatString="&lt;DATA_VALUE:00.##&gt;"

                        EnableFadingEffect="False" Format="DataValue" FontColor="Black" BorderColor="Black"

                        Display="MouseMove" BackColor="AntiqueWhite" Padding="0"></Tooltips>

                </igchart:UltraChart>

            </td>

        </tr>

    </table>

</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="beforeClosingBodyPlaceHolder" runat="Server">

</asp:Content>

 Default.aspx.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using WebSamplesCS;

public partial class Samples_WebCharts_Display_Bar_And_Column_Charts_3D_Bar_And_Column_Charts_Default : Infragistics.Web.SampleBrowser.Core.Framework.Web.UI.ASPNET.SamplePage

{

    protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;

    protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

    protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

    protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

    protected System.Data.OleDb.OleDbConnection oleDbConnection1;

    protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;

    protected WebSamplesCS.WebCharts.ChartData chartData1;

    private void Page_Load(object sender, System.EventArgs e)

    {

        this.oleDbConnection1.ConnectionString = Config.ChartMDBConnString;

        this.oleDbDataAdapter1.Fill(this.chartData1);

        this.UltraChart1.Data.DataSource = this.chartData1.BarColumnData;

        this.UltraChart1.Data.DataBind();

        this.UltraChart1.BackgroundImageFileName = Server.MapPath("/SamplesBrowser/SamplesCommon/aspnet/Common/ChartBg.jpg");

        this.UltraChart2.Data.DataSource = this.chartData1.BarColumnData;

        this.UltraChart2.Data.DataBind();

        this.UltraChart2.BackgroundImageFileName = Server.MapPath("/SamplesBrowser/SamplesCommon/aspnet/Common/ChartBg.jpg");

    }

    #region Web Form Designer generated code

    override protected void OnInit(EventArgs e)

    {

        //

        // CODEGEN: This call is required by the ASP.NET Web Form Designer.

        //

        InitializeComponent();

        base.OnInit(e);

    }

    /// <summary>

    /// Required method for Designer support - do not modify

    /// the contents of this method with the code editor.

    /// </summary>

    private void InitializeComponent()

    {

        this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();

        this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();

        this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();

        this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();

        this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();

        this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();

        this.chartData1 = new WebSamplesCS.WebCharts.ChartData();

        ((System.ComponentModel.ISupportInitialize)(this.chartData1)).BeginInit();

        //

        // oleDbSelectCommand1

        //

        this.oleDbSelectCommand1.CommandText = "SELECT ActiveX, Java, NET, [Week#] FROM BarColumnData";

        this.oleDbSelectCommand1.Connection = this.oleDbConnection1;

        //

        // oleDbConnection1

        //

        this.oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Program Files\Infragistics\NETADVANTAGE 2006 VOLUME 1 CLR 1.0\ASP.NET\SAMPLES\Data\ChartDataBase.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";

        //

        // oleDbInsertCommand1

        //

        this.oleDbInsertCommand1.CommandText = "INSERT INTO BarColumnData(ActiveX, Java, NET, [Week#]) VALUES (?, ?, ?, ?)";

        this.oleDbInsertCommand1.Connection = this.oleDbConnection1;

        this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActiveX", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ActiveX", System.Data.DataRowVersion.Current, null));

        this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Java", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Java", System.Data.DataRowVersion.Current, null));

        this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("NET", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "NET", System.Data.DataRowVersion.Current, null));

        this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Week#", System.Data.OleDb.OleDbType.VarWChar, 50, "Week#"));

        //

        // oleDbUpdateCommand1

        //

        this.oleDbUpdateCommand1.CommandText = "UPDATE BarColumnData SET ActiveX = ?, Java = ?, NET = ?, [Week#] = ? WHERE ([Week" +

            "#] = ?)";

        this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;

        this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ActiveX", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ActiveX", System.Data.DataRowVersion.Current, null));

        this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Java", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Java", System.Data.DataRowVersion.Current, null));

        this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("NET", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "NET", System.Data.DataRowVersion.Current, null));

        this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Week#", System.Data.OleDb.OleDbType.VarWChar, 50, "Week#"));

        this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Week#", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Week#", System.Data.DataRowVersion.Original, null));

        //

        // oleDbDeleteCommand1

        //

        this.oleDbDeleteCommand1.CommandText = "DELETE FROM BarColumnData WHERE ([Week#] = ?)";

        this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;

        this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Week#", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Week#", System.Data.DataRowVersion.Original, null));

        //

        // oleDbDataAdapter1

        //

        this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;

        this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;

        this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;

        this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {

                                                                                                        new System.Data.Common.DataTableMapping("Table", "BarColumnData", new System.Data.Common.DataColumnMapping[] {

                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Week#", "Week#"),

                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("ActiveX", "ActiveX"),

                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("Java", "Java"),

                                                                                                                                                                                                                         new System.Data.Common.DataColumnMapping("NET", "NET")})});

        this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;

        //

        // chartData1

        //

        this.chartData1.DataSetName = "ChartData";

        this.chartData1.Locale = new System.Globalization.CultureInfo("en-US");

        this.chartData1.Namespace = "http://www.tempuri.org/ChartData.xsd";

        this.Load += new System.EventHandler(this.Page_Load);

        ((System.ComponentModel.ISupportInitialize)(this.chartData1)).EndInit();

    }

    #endregion

}

Default.aspx.vb

Imports System

Imports System.Collections

Imports System.ComponentModel

Imports System.Data

Imports System.Drawing

Imports System.Web

Imports System.Web.SessionState

Imports System.Web.UI

Imports System.Web.UI.WebControls

Imports System.Web.UI.HtmlControls

Imports WebSamplesCS

Public Partial Class Samples_WebCharts_Display_Bar_And_Column_Charts_3D_Bar_And_Column_Charts_Default

    Inherits Infragistics.Web.SampleBrowser.Core.Framework.Web.UI.ASPNET.SamplePage

    Protected oleDbSelectCommand1 As System.Data.OleDb.OleDbCommand

    Protected oleDbInsertCommand1 As System.Data.OleDb.OleDbCommand

    Protected oleDbUpdateCommand1 As System.Data.OleDb.OleDbCommand

    Protected oleDbDeleteCommand1 As System.Data.OleDb.OleDbCommand

    Protected oleDbConnection1 As System.Data.OleDb.OleDbConnection

    Protected oleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter

    Protected chartData1 As WebSamplesCS.WebCharts.ChartData

    Private Sub Page_Load(sender As Object, e As System.EventArgs)

        Me.oleDbConnection1.ConnectionString = Config.ChartMDBConnString

        Me.oleDbDataAdapter1.Fill(Me.chartData1)

        Me.UltraChart1.Data.DataSource = Me.chartData1.BarColumnData

        Me.UltraChart1.Data.DataBind()

        Me.UltraChart1.BackgroundImageFileName = Server.MapPath("/SamplesBrowser/SamplesCommon/aspnet/Common/ChartBg.jpg")

        Me.UltraChart2.Data.DataSource = Me.chartData1.BarColumnData

        Me.UltraChart2.Data.DataBind()

        Me.UltraChart2.BackgroundImageFileName = Server.MapPath("/SamplesBrowser/SamplesCommon/aspnet/Common/ChartBg.jpg")

    End Sub

    #region Web Form Designer generated code

    Protected Overrides Sub OnInit(e As EventArgs)

        '

        ' CODEGEN: This call is required by the ASP.NET Web Form Designer.

        '

        InitializeComponent()

        MyBase.OnInit(e)

    End Sub

    ''' <summary>

    ''' Required method for Designer support - do not modify

    ''' the contents of this method with the code editor.

    ''' </summary>

    Private Sub InitializeComponent()

        Me.oleDbSelectCommand1 = New System.Data.OleDb.OleDbCommand()

        Me.oleDbConnection1 = New System.Data.OleDb.OleDbConnection()

        Me.oleDbInsertCommand1 = New System.Data.OleDb.OleDbCommand()

        Me.oleDbUpdateCommand1 = New System.Data.OleDb.OleDbCommand()

        Me.oleDbDeleteCommand1 = New System.Data.OleDb.OleDbCommand()

        Me.oleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter()

        Me.chartData1 = New WebSamplesCS.WebCharts.ChartData()

        (DirectCast((Me.chartData1), System.ComponentModel.ISupportInitialize)).BeginInit()

        ' 

        ' oleDbSelectCommand1

        ' 

        Me.oleDbSelectCommand1.CommandText = "SELECT ActiveX, Java, NET, [Week#] FROM BarColumnData"

        Me.oleDbSelectCommand1.Connection = Me.oleDbConnection1

        ' 

        ' oleDbConnection1

        ' 

        Me.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Program Files\Infragistics\NETADVANTAGE 2006 VOLUME 1 CLR 1.0\ASP.NET\SAMPLES\Data\ChartDataBase.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"

        ' 

        ' oleDbInsertCommand1

        ' 

        Me.oleDbInsertCommand1.CommandText = "INSERT INTO BarColumnData(ActiveX, Java, NET, [Week#]) VALUES (?, ?, ?, ?)"

        Me.oleDbInsertCommand1.Connection = Me.oleDbConnection1

        Me.oleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("ActiveX", System.Data.OleDb.OleDbType.[Integer], 0, System.Data.ParameterDirection.Input, False, (DirectCast((10), System.Byte)), _

            (DirectCast((0), System.Byte)), "ActiveX", System.Data.DataRowVersion.Current, Nothing))

        Me.oleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Java", System.Data.OleDb.OleDbType.[Integer], 0, System.Data.ParameterDirection.Input, False, (DirectCast((10), System.Byte)), _

            (DirectCast((0), System.Byte)), "Java", System.Data.DataRowVersion.Current, Nothing))

        Me.oleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("NET", System.Data.OleDb.OleDbType.[Integer], 0, System.Data.ParameterDirection.Input, False, (DirectCast((10), System.Byte)), _

            (DirectCast((0), System.Byte)), "NET", System.Data.DataRowVersion.Current, Nothing))

        Me.oleDbInsertCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Week#", System.Data.OleDb.OleDbType.VarWChar, 50, "Week#"))

        ' 

        ' oleDbUpdateCommand1

        ' 

        Me.oleDbUpdateCommand1.CommandText = "UPDATE BarColumnData SET ActiveX = ?, Java = ?, NET = ?, [Week#] = ? WHERE ([Week" + "#] = ?)"

        Me.oleDbUpdateCommand1.Connection = Me.oleDbConnection1

        Me.oleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("ActiveX", System.Data.OleDb.OleDbType.[Integer], 0, System.Data.ParameterDirection.Input, False, (DirectCast((10), System.Byte)), _

            (DirectCast((0), System.Byte)), "ActiveX", System.Data.DataRowVersion.Current, Nothing))

        Me.oleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Java", System.Data.OleDb.OleDbType.[Integer], 0, System.Data.ParameterDirection.Input, False, (DirectCast((10), System.Byte)), _

            (DirectCast((0), System.Byte)), "Java", System.Data.DataRowVersion.Current, Nothing))

        Me.oleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("NET", System.Data.OleDb.OleDbType.[Integer], 0, System.Data.ParameterDirection.Input, False, (DirectCast((10), System.Byte)), _

            (DirectCast((0), System.Byte)), "NET", System.Data.DataRowVersion.Current, Nothing))

        Me.oleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Week#", System.Data.OleDb.OleDbType.VarWChar, 50, "Week#"))

        Me.oleDbUpdateCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Week#", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, (DirectCast((0), System.Byte)), _

            (DirectCast((0), System.Byte)), "Week#", System.Data.DataRowVersion.Original, Nothing))

        ' 

        ' oleDbDeleteCommand1

        ' 

        Me.oleDbDeleteCommand1.CommandText = "DELETE FROM BarColumnData WHERE ([Week#] = ?)"

        Me.oleDbDeleteCommand1.Connection = Me.oleDbConnection1

        Me.oleDbDeleteCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_Week#", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, (DirectCast((0), System.Byte)), _

            (DirectCast((0), System.Byte)), "Week#", System.Data.DataRowVersion.Original, Nothing))

        ' 

        ' oleDbDataAdapter1

        ' 

        Me.oleDbDataAdapter1.DeleteCommand = Me.oleDbDeleteCommand1

        Me.oleDbDataAdapter1.InsertCommand = Me.oleDbInsertCommand1

        Me.oleDbDataAdapter1.SelectCommand = Me.oleDbSelectCommand1

        Me.oleDbDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "BarColumnData", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("Week#", "Week#"), New System.Data.Common.DataColumnMapping("ActiveX", "ActiveX"), New System.Data.Common.DataColumnMapping("Java", "Java"), New System.Data.Common.DataColumnMapping("NET", "NET")})})

        Me.oleDbDataAdapter1.UpdateCommand = Me.oleDbUpdateCommand1

        ' 

        ' chartData1

        ' 

        Me.chartData1.DataSetName = "ChartData"

        Me.chartData1.Locale = New System.Globalization.CultureInfo("en-US")

        Me.chartData1.[Namespace] = "http://www.tempuri.org/ChartData.xsd"

        Me.Load += New System.EventHandler(Me.Page_Load)

        (DirectCast((Me.chartData1), System.ComponentModel.ISupportInitialize)).EndInit()

    End Sub

    #endregion

End Class