GrapeCity Forums

The GrapeCity Message Boards
Welcome to GrapeCity Forums Sign in | Join | Help
in Search

Russell's Blog

  • RussCam Episode 58: Part 3 - SQL Saturday #133 Costa Rica

    Anyone who has met the Devfish himself, Microsoft Developer Evangelist, Joe Healy, will absolutely love this video.  Even if you have not met Joe, it’s vintage Joe, who finally gets his moment in the spotlight on Russ Cam! The opening is definitely a side splitter! Awesome job Joe! It's the final episode from Costa Rica, SQL Saturday 133 at perhaps my favorite!
    First Russ talks with MS MVP Salamon Henriquez about the big event in Costa Rica. Then, we talk with two speakers from SQL Saturday 133, Solid Quality Mentor’s Javier Loria and SQL Server MVP Jesus Gil. They tell us about their unique role playing session using Tacos. Then (drum roll...) it's the DevFish himself, Joe Healy who is very excited about what he just witnessed in the strong developer and database community in Costa Rica and predictions for an even larger event next year, perhaps 600 people! And Jeff Zwickol is back with his summary of the SQL Saturday. Finally, Wes Dumey makes a return appearance on Russ Cam. Watch until the end for photos and outtakes! In these outtakes, we complete our journey to Jaco Beach with crocodiles along the way and a incredible sunset over the pacific. HAPPY COSAT RICA Day!
    CLICK here to watch video!

    image

    Joe Healy Episode – Vintage Devfish.
    Captions available in Spanish! Los títulos disponibles en español!
    Raw Link: http://gvtv.gcpowertools.com/#russcam58

    IMG_0258

    Nice shot of Nizar Lavji, President Vista Technologies , with plane and great sunset.

    IMG_0288

    My prize photo of a Jaco Beach Sunset! The island mountain on the horizon only is visible with the sun setting directly behind it.
    I talk about this sunset as it is happening in this episode.

    IMG_9911

    Javier Loria and SQL Server MVP Jesus Gil

    IMG_9914

    RussCamTV, Russ Fustino, with MS MVP Salamon Henriquez holding .NET Gurus Can Cook

    More Photos of SQL Saturday 133 Costa Rica

    More Photos of Costa Rica trip to Jaco Beach



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/11/russcam-episode-58-part-3-sql-saturday-133-costa-rica.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • RussCam Episode 57: Part 2 - SQL Saturday #133 Costa Rica

     

    Russcam has more from SQL Saturday 133 in Costa Rica! First, I chat with Jeff Zwickel about what he's up to plus his thoughts on SQL Saturday Costa Rica! Then, we briefly catch Stephen Purkiss on Russ Cam! He's the Chairman at Sherlock Technology Recruiting. And Nizar Lavji tells us all about the work he does as President of Vista Technologies. Keep watching until the end for all of the outtakes and photos including a trip to Jaco Beach with Joe Healy, Keith Kabza, Alex Funkhouser and more! Find out how Sugar Cain juice is made!

    CLICK here to watch video!

    image

    Stephen Purkiss and Jeff Zwickel 
    Captions available in Spanish! Los títulos disponibles en español!
    Raw Link: http://gvtv.gcpowertools.com/#russcam57

     

    IMG_9909

    Nizar Lavji, President Vista Technologies

    IMG_0148

    Nazir, Jeff, Alex, Fruit Stand owner, Joe, Wes, Henry, and Russ. The mango was delicious!

    More Photos of SQL Saturday 133 Costa Rica

    More Photos of Costa Rica trip to Jaco Beach



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/10/russcam-episode-57-part-2-sql-saturday-133-costa-rica.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • RussCam Episode 56: Part 1 - SQL Saturday #133 Costa Rica

    Russ Cam is taking you to Costa Rica for SQL Saturday 133! First, we'll talk with Eduardo Castro, SQL Server MVP, keynote speaker and organizer of SQL Saturday 133! Then, Jorge Aguilar tells us about the new Sharepoint solutions at Idera. And wouldn't you know it...Alex Funkhouser makes yet another appearance on Russ Caaaaaam, along with Joe Healy, Keith Kabza and Yuri Porras, representing Microsoft in Costa Rica! Watch until the end for photos and outtakes!

    CLICK here to watch video!

    image

    Eduardo Castro, Conference organizer
    Captions available in Spanish! Los títulos disponibles en español!

    Raw Link: http://gvtv.gcpowertools.com/#russcam56

    IMG_9846

    Jorje Aguilar of Idera

    IMG_9887

    Yuri Porras, Microsoft DE, was a bit hit!

    More Photos of SQL Saturday 133 Costa Rica

     



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/10/russcam-episode-56-part-1-sql-saturday-133-costa-rica.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity Spread WPF-Silverlight CTP2, now with a Go Live License! Part 15 – Resources

    It’s an exciting time! Spread WPF-Silverlight is now CTP2 with a go live license!

    Contact sales at PowerSales@GrapeCity.com to purchase your Go Live license today.

    Click here for a WPF-Silverlight evaluation copy

    Visit http://www.gcpowertools.com/Products/SpreadWPFSilverlight/Overview for some amazing UI abilities in Silverlight and WPF. Wow!

    This is the final blog post in a 15 part series on Spread WPF-Silverlight CTP…

    Part 1 : Create an app from scratch
    Part 2 : AutoFit
    Part 3 : Borders and Grid Lines
    Part 4 : Cell Format
    Part 5 : Cell Overflow
    Part 6 : Cell Span
    Part 7 : Clipboard Operation
    Part 8 : Conditional Formatting
    Part 9 : CSV Import and Export
    Part 10: Data Binding
    Part 11: Drag and Move
    Part 12: Drag and Fill
    Part 13: Edit Mode and Frozen Columns
    Part 14: Row Filter

     

    image

     

    image

    Spread WPF-Silverlight

    • Spread is an embedded spreadsheet platform component for application development.
    • Spread WPF-Silverlight includes a WPF spreadsheet control and a Silverlight spreadsheet control.
    • These controls address use cases best solved using cell-based, free-form, gridded layouts.
    • Spread WPF-Silverlight includes rich designer to simplify development and produce quick results.

    Features:

    • AutoFit - Set Row height and Column width to the minimum size needed to include all the text for every cell in the row or column.
    • Cell Formatter - Format numeric data in a cell to a specified Excel-style format string.
    • CellOverflow - Allow cells data to overflow from a cell into adjacent, empty cells.
    • Cell Span - Merge a range of cells into a group that is displayed as a single cell.
    • Clipboard - Cut, Copy, Paste, Paste Special.
    • Conditional Format - Apply custom styles to cells whose values meet specific conditions or rules.
      • Average Rule - compare cell values to the average of a specified range.
      • CellValue Rule - compare cell values to another value.
      • DateOccuring Rule - compare cell values to a date range.
      • Formula Rule - evaluate a formula.
      • Scale Rule - compare cell values to scale values of a specified range.
      • Top10 Rule - compare the cell value to the top 10 or bottom 10 of a specified range.
      • Unique Rule - whether the cell value is unique for a specified range.
    • Text & CSV File Import and Export - Load and save Text (txt) and CSV (comma-delimiited) files.
    • DataBinding
    • DragMove
    • Editing Always
    • Fill
    • Filter
    • Freeze Heading & Trailing Rows & Columns
    • Grid Line & Border
    • Html_Export FeaturePoint
    • Input Mapping
    • Multiple Header
    • Navigation
    • SavePDF
    • Cell Lock & Worksheet Protection -
    • Range Group - Excel style grouping.
    • Resize
    • Scrolling
    • Search
    • Selection
    • ShrinkToFit
    • Sparkline
    • StyleInfo
    • Table
    • TabStrip
    • Theme Manager
    • UndoRedo
    • View port
    • Zoom

    On a personal note, I would like to wish Robby Powell the best of luck in his new endeavors and many thanks for all of the Spread management, support and love over several years! You will be missed but not forgotten!  Best wishes!

     



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/02/grapecity-spread-wpf-silverlight-ctp2-now-with-a-go-live-license-part-15-resources.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity Spread Silverlight CTP, Part 13 – Edit Mode and Frozen Columns and Rows

    Spread CTP - Script 13: Edit Mode and Frozen Columns and Rows

    If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

    This is the 13th in a series of Spread CTP Blogs and is a continuation of:

    Part 1 : Create an app from scratch
    Part 2 : AutoFit
    Part 3 : Borders and Grid Lines
    Part 4 : Cell Format
    Part 5 : Cell Overflow
    Part 6 : Cell Span
    Part 7 : Clipboard Operation
    Part 8 : Conditional Formatting
    Part 9 : CSV Import and Export
    Part 10: Data Binding
    Part 11: Drag and Move
    Part 12
    : Drag and Fill

     

    Edit Mode Always

    If you are interested in downloading the Spread CTP 2 with a go live license, please email
    labs@grapecity.com .

     

    You can set the cell to always be in edit mode when the user clicks on it. Normally the user types or double-clicks before the cell goes into edit mode.

    Set the StartCellEditing method in the EnterCell event to cause the cell to go into edit mode as soon as the user clicks on or uses tab or enter to move to the cell.


    Frozen Columns and Rows Feature

    You can specify whether you want frozen rows or columns or both in a sheet. Frozen columns and rows do not scroll. You can also specify whether to have frozen trailing rows or columns. A line is displayed below frozen rows (or above frozen trailing rows) and to the right of frozen columns (or to the left of frozen trailing columns).

    Frozen rows stay at the top of the sheet and frozen columns stay on the left of the sheet. Frozen trailing rows stay at the bottom of the sheet and frozen trailing columns stay on the right of the sheet.

    clip_image001

    Using Code

    CS

     

    gcSpreadSheet1.Sheets[0].RowCount = 10;
    gcSpreadSheet1.Sheets[0].ColumnCount = 8;
    gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1;
    gcSpreadSheet1.Sheets[0].FrozenRowCount = 1;
    gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1;
    gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1;
    gcSpreadSheet1.Invalidate();

    VB.NET

    clip_image002

    GcSpreadSheet1.Sheets(0).RowCount = 10
    GcSpreadSheet1.Sheets(0).ColumnCount = 8
    GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1
    GcSpreadSheet1.Sheets(0).FrozenRowCount = 1
    GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1
    GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1
    GcSpreadSheet1.Invalidate()

     

    Part 14 – Row Filter

     



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/27/grapecity-spread-silverlight-ctp-part-13-edit-mode-and-frozen-columns-and-rows.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity Spread Silverlight CTP, Part 14 – Row Filter

    Spread CTP - Script 14: Row Filter

    If you are interested in downloading the Spread CTP2 with a go live license, please email labs@grapecity.com .

    This is the 14th in a series of Spread CTP Blogs and is a continuation of:

    Part 1 : Create an app from scratch
    Part 2 : AutoFit
    Part 3 : Borders and Grid Lines
    Part 4 : Cell Format
    Part 5 : Cell Overflow
    Part 6 : Cell Span
    Part 7 : Clipboard Operation
    Part 8 : Conditional Formatting
    Part 9 : CSV Import and Export
    Part 10: Data Binding
    Part 11: Drag and Move
    Part 12: Drag and Fill
    Part 13: Edit Mode and Frozen Columns

    You can hide filtered rows. A filter button is displayed in the column header for a column that allows filtering. The user can click on the button and select the item they wish to filter by and they can sort the list of items.

    The following image displays the filter dialog.

    clip_image001

    The user can use the mouse or various keyboard keys to interact with the filter dialog. The ESC key can be used to cancel the dialog. The TAB key can be used to move to different sections and the up and down arrow keys can be used to move in the list of items. The SPACEBAR can be used to change the checked status.

    The following image shows the list sorted in ascending order.

    clip_image002

    Using Code

    CS

    GrapeCity.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1);
    GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange);
    gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;

    VB.NET

    Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1)
    Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange)
    GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter
    GcSpreadSheet1.Invalidate()

    Spread, Excel, Silverlight, CTP, labs@grapecity.com , visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill, edit mode, frozen columns and rows, row filter



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-14-row-filter.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity Spread Silverlight CTP, Part 12 - Drag and Fill

    Spread CTP - Script 12: Drag and Fill

    If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

    This is the 12th in a series of Spread CTP Blogs and is a continuation of:

    Part 1 : Create an app from scratch
    Part 2 : AutoFit
    Part 3 : Borders and Grid Lines
    Part 4 : Cell Format
    Part 5 : Cell Overflow
    Part 6 : Cell Span
    Part 7 : Clipboard Operation
    Part 8 : Conditional Formatting
    Part 9 : CSV Import and Export
    Part 10: Data Binding
    Part 11: Drag and Move

    GcSpreadSheet has a drag fill option that allows the user to select cells and fill other cells with the same or different values. The fill type can be set to linear, growth, date, or automatic fill. The fill direction can also be specified. Additional options can be set such as step and stop values.

    Select a cell or block and move the mouse pointer over the square at the corner of the selection. The mouse pointer changes to a double arrow that can be used to expand the fill range. Click on the plus mark to display a menu with additional fill options as shown in the following image:

    clip_image001

    Drag fill is not supported if the destination range contains a spanned cell. Drag fill does not apply to a conditional format or filtered range.

    The AllowDragFill property is used to specify whether to allow drag fill. The FillAuto Method, FillDate Method, FillGrowth Method, or FillLinear Method can be used to programmatically specify the type of fill.

    Using Code

    CS

    gcSpreadSheet1.AllowDragFill = true;
    gcSpreadSheet1.Sheets[0].SetValue(0, 0, new DateTime(2011, 1, 1));
    gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9));
    gcSpreadSheet1.Sheets[0].SetValue(0, 2, 5);
    gcSpreadSheet1.Sheets[0].SetValue(0, 3, 10);
    gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
    gcSpreadSheet1.Invalidate();

    private void button1_Click(object sender, RoutedEventArgs e)
    {
    GrapeCity.Windows.SpreadSheet.Data.CellRange r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1);
    gcSpreadSheet1.Sheets[0].FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2);
    GrapeCity.Windows.SpreadSheet.Data.CellRange r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1);
    gcSpreadSheet1.Sheets[0].FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, new DateTime(2011, 2, 11).ToOADate());
    GrapeCity.Windows.SpreadSheet.Data.CellRange r3 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1);
    //gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down);
    gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
    GrapeCity.Windows.SpreadSheet.Data.CellRange r4 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1);
    //gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
    //gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2);
    gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55);
    GrapeCity.Windows.SpreadSheet.Data.CellRange r5 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1);
    //gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
    //gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3);
    gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20);
    gcSpreadSheet1.Invalidate();
    }

    VB.NET

    GcSpreadSheet1.AllowDragFill = True
    GcSpreadSheet1.Sheets(0).SetValue(0, 0, New DateTime(2011, 1, 1))
    GcSpreadSheet1.Sheets(0).SetValue(0, 1, New DateTime(2011, 2, 9))
    GcSpreadSheet1.Sheets(0).SetValue(0, 2, 5)
    GcSpreadSheet1.Sheets(0).SetValue(0, 3, 10)
    GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1)
    GcSpreadSheet1.Invalidate()

    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
    Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1)
    GcSpreadSheet1.Sheets(0).FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2)
    Dim r2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1)
    GcSpreadSheet1.Sheets(0).FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, New DateTime(2011, 2, 11).ToOADate())
    Dim r3 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1)
    'GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down)
    GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
    Dim r4 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1)
    'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
    'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2)
    GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55)
    Dim r5 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1)
    'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
    'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3)
    GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20)
    GcSpreadSheet1.Invalidate()
    End Sub

    Part 13 : Edit Mode and Frozen Columns and Rows



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-12-drag-and-fill.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity Spread Silverlight CTP, Part 11 - Drag and Move

    Spread CTP - Script 11: Drag and Move

    If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

    This is the 11th in a series of Spread CTP Blogs and is a continuation of:

    Part 1 : Create an app from scratch
    Part 2 : AutoFit
    Part 3 : Borders and Grid Lines
    Part 4 : Cell Format
    Part 5 : Cell Overflow
    Part 6 : Cell Span
    Part 7 : Clipboard Operation
    Part 8 : Conditional Formatting
    Part 9 : CSV Import and Export
    Part 10: Data Binding

    The user can use the mouse to select a cell or block of cells and move them to a new location. Move the mouse pointer to the edge of a selected column, row, or block of cells and then click and drag the selected range to the new location.

    The following image displays a selected block of cells with the drag icon:

    clip_image001

    Move the block to the new location.

    clip_image002

    Release the mouse to display the data in the new location.

    clip_image003

    You can select and drag multiple contiguous columns or rows.

    Using Code

    CS

    gcSpreadSheet1.AllowDragDrop = true;

    VB.NET

    GcSpreadSheet1.AllowDragDrop = True

    Part 12: Drag and fill



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-11-drag-and-move.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity Spread Silverlight CTP, Part 10 - Data Binding

    Spread CTP - Script 10: Data Binding

    If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

    This is the 10th in a series of Spread CTP Blogs and is a continuation of:

    Part 1 : Create an app from scratch
    Part 2 : AutoFit
    Part 3 : Borders and Grid Lines
    Part 4 : Cell Format
    Part 5 : Cell Overflow
    Part 6 : Cell Span
    Part 7 : Clipboard Operation
    Part 8
    : Conditional Formatting
    Part 9
    : CSV Import and Export

     

    GcSpreadSheet supports binding to any object that implements the IEnumerable interface. This includes the Ilist, ObservableCollection, and WCF datasource. The control also supports binding to an RIA datasource.

    GcSpreadSheet supports one way data binding. Changes to the source automatically update the target but, changes to the target are not propagated back to the source.

    Specific columns can be bound with the DataField Property.

    Using Code

    CS

    public class lname
    {
    public string last { get; set; }
    public int val { get; set; }
    public lname(string last, int val)
    {
    this.last = last;
    this.val = val;
    }
    }

    private void Window_Loaded(object sender, RoutedEventArgs e)
    {

    lname[] arr = new lname[] { new lname("Smith", 100), new lname("Fender", 3), new lname("Gill", 5) };
    gcSpreadSheet1.Sheets[0].DataSource = arr;
    gcSpreadSheet1.Invalidate();

    VB.NET

    Public Class lname
    Public Property last() As String

    Get
    Return m_last
    End Get


    Set
    m_last = Value
    End Set


    End Property


    Private m_last As String

    Public Property val() As Integer

    Get
    Return m_val
    End Get

    Set
    m_val = Value
    End Set


    End Property

    Private m_val As Integer

    Public Sub New(last As String, val As Integer)
    Me.last = last
    Me.val = val
    End Sub

    End Class

    Dim arr As lname() = New lname() {New lname("Smith", 100), New lname("Fender", 3), New lname("Gill", 5)}
    gcSpreadSheet1.Sheets(0).DataSource = arr
    gcSpreadSheet1.Invalidate()

     

    clip_image001

     Part 11 : Drag and Move



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-10-data-binding.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • RussCam 55: Part 4 of 4 - Orlando Code Camp

    This is one of my favorite episodes in large part due to the huge 500 person ‘RussCammmmmmm’ yell (largest to date!)! I talk with Windows Phone MVP, Atley Hunter about his session and a really cool app he's working on! Check out my new cameraman for this interview (hint, he's not the owner of a major pizza franchise)! Then, Microsoft MVP and RD Elijah Manor talks with me about his two sessions about jQuery. Event organizer, Esteban Garcia, takes a few moments away from his busy schedule to be on Russ Cam! And Peter Bromberg from EggHeadCafe shows us the enormous schedule for code camp, and also tells us why he's really into MVC these days. Plus, don't miss the behind the scenes photos and outtakes at the end of the video!

    image

    Raw Link:

    http://gvtv.gcpowertools.com/#russcam55

    IMG_8645

    Organizing committee for Orlando Code Camp.

    IMG_8646

    RD’s Elijah Manor and John Papa

     

    More Photos Photos: Orlando CodeCamp



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/23/russcam-55-part-4-of-4-orlando-code-camp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • Russcam Episode 54: Part 3 of 4: Orlando CodeCamp

     

    Russ is catching up with the VP of ONETUG, John Smith! Then, Luis Perez from Neuralnet makes yet another Russ Cam appearance! Alexander Koval talks about his organization, Code Masters International, plus his session at Code Camp. And Jose Chinchilla talks with us about his experience with business intelligence. We wrap it up with an appearance by another Russ Cam veteran, Greg Leonardo. Don't miss the behind the scenes photos and outtakes at the end of this episode!

     

    image

    Raw Link:

    http://gvtv.gcpowertools.com/#russcam54

    IMG_8584

    Esteban Garcia and John Smith, key organizers of Orlando Code camp.

    IMG_8562

    Luis Perez enjoys the session at Orlando Code Camp!

     

    More Photos Photos: Orlando CodeCamp



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/22/russcam-episode-54-part-3-of-4-orlando-codecamp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • Russcam Episode 53: Part 2 of 4: Orlando CodeCamp

     

    We are celebrating 50+ episodes where it all started - Orlando Code Camp! I talk with the first ever Russ Cam interviewee, MVP Dave Noderer! We discuss the upcoming second edition of the .NET Gurus Can Cook cookbook! Plus, it's the debut of the Dave Cam! Then, it's a surprise interview with RD John Papa! He talks about his session and his busy week with DevConnections, Code Camp and birthday parties! Then, Scott Dorman tells us about a website that helps you make newsletters out of Twitter feeds! He also talks with us about his session as well as a new Windows Phone Marketplace Requests website. Brian Mishler, director of marketing for ONETUG, talks with us about Send2Page and also the success of Orlando Code Camp. Watch the whole thing for behind the scenes photos and outtakes!

     

    image

    Raw Link:

    http://gvtv.gcpowertools.com/#russcam53

    IMG_8582

    The best shot ever of RD John Papa holding the RussCam Hard Hat!

    More Photos Photos: Orlando CodeCamp



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/22/russcam-episode-53-part-2-of-4-orlando-codecamp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity RussCam Episode 52, Part 1 of 4: Orlando Code Camp

     

    I am in Orlando for the huge Orlando Code Camp! First, I talk with Chesapeake, VA native, Kevin Griffin. Kevin is a technical evangelist for ComponentOne. He talks about his 2 sessions at Code Camp. Then, it's a return Russ Cam interviewee - Microsoft MVP Jonas Stawski! Jonas is excited about the Windows 8 Tablet consumer preview! He's talking about his session diving into the architecture of his Windows Phone 7 apps. And find out why Jonas is also excited about ActiveAnalysis from GrapeCity PowerTools! Software Coder Marek Radacz stops by Russ Cam to say hello and share an update about JAXDUG. Matt Trask tells us about a very interesting kit called FEZ Spider, the first commercially available .NET Gageteer-compatible kit! Matt does a session at the Code Camp using his FEZ Spider. Watch this episode through to the end to see outtakes and photos from Orlando Code Camp!

     

    image

    Raw link: http://gvtv.gcpowertools.com/#russcam52

    IMG_8585

    Jonas Stawski returns to RussCamTV!!!! (Nice shirt!)

    More Photos Photos: Orlando CodeCamp



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/21/grapecity-russcam-episode-52-part-1-of-4-orlando-code-camp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity RussCam Episode #51–Windows Phone 7 UG Tampa March meeting

    We are at another Windows Phone 7 User Group meeting in Tampa, with a surprise visit from Bill Steele! Bill shares some of the creative ideas he's been generating post-Microsoft. We have some great clips of the Microsoft Mustang that Bill helped build as seen on the Discovery channel. Then, I talk with Luis Perez once again (a frequent guest on Russ Cam)! This time, Luis is telling us about his new MLB Pro '12 app just released -- exclusively available for WP7! Michael Stark talks about his interesting phone apps that reveal what kind of criminal you are! Finally, Paul Beaton tells us about his apps and his experience using OAuth. Be sure to watch until the end for the behind-the-scenes photos and outtakes!

    image

    Raw Link : http://gvtv.gcpowertools.com/#russcam51

    Photos from WP7 UG March 2012:

    IMG_8475

    Luis Perez, Michael Stark, Paul Beaton and RussCam.

     



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/11/grapecity-russcam-episode-51-windows-phone-7-ug-tampa-march-meeting.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
  • GrapeCity RussCam Episode #50- SQL Saturday Tampa Part 3

    Jenifer Underwood, a Data Platform Technology Specialist with Microsoft, shares with Russ Cam some information from her presentation at SQL Saturday. This is the first time in the country a topic like this has been presented! See for yourself how reporting, analysis and BI work on both Windows 8 tablets and the iPad! Products like Mobi Weave and PushBI are on the cutting edge of BI for mobile devices! Don't miss this episode!

    image

    Raw link: http://gvtv.gcpowertools.com/#russcam50

    Link to SQL Saturday 110 Tampa Photos

    Link to episodes and more http://www.gcpowertools.com/russcam



    tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/04/grapecity-russcam-episode-50-sql-saturday-tampa-part-3.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';
More Posts Next page »