Export selection to excel in a MVVM WPF program

[herb]

I'm currenting working on an existing project where there the creator had UserControl Xamls, the controls are in ViewModel folder where usercontrol.ViewModel.cs has the control and executable.

I'm trying not to break the code, learn how to use MVVM/WPF formatting.

I have added a button to the UserControl.Xaml now I'm not clear on get the button control to work so it can export both selected gridview item or the whole gridview. I have found several forum articles but they do not met my WPF format:

<telerik:RadButton x:Name="btnExport"
                                   Grid.Row="0"
                                   Content="Export to Excel"
                                   Command="{Binding Export2ExcelCommand}"
                                   Width="100"
                                   Margin="4" />

But now I need a good sample that show how I should add the "Export2ExcelCommand" button control to the "ucViewModel.cs" file.

Again the goal is to support both whole gridview export or selected items in gridview to Excel.

Help is appreciated.

[herb]

here is the code use to populate the RadGridView:

public void SQLMrsUser()
        {
            SqlCommand _sqlCommand = new SqlCommand();
            SqlCommand sqlcmd = null;
            m_SqlConnStrBuilder = SqlHelper.SetupSqlConnectionStringBuilder(VmaUtilities.AppSettings.SelectedSqlDatabaseProfile); //VmaUtilities.VmaUtils.SetupSqlConnectionInfo();
            sqlcmd = new SqlCommand(@"Select * FROM dbo.MRSUSERS");
            sqlcmd.CommandType = CommandType.Text;
            _sqlCommand = sqlcmd;
            try
            {
                //Now Lets Try to Connect
                using (SqlConnection m_SqlConnection = new SqlConnection(m_SqlConnStrBuilder.ConnectionString))
                {
                    m_SqlConnection.Open();
                    _sqlCommand.Connection = m_SqlConnection;
                    //Be sure we update the Status Bar with the connection string info.
                    VmaUtilities.PostUpdateDatabaseConnectionEvent(enConnectionStatus.Connected, "Successful Connection To Database", "Successful Connection To Database");
                    SqlDataAdapter dataAdapter = new SqlDataAdapter();
                    dataAdapter.SelectCommand = _sqlCommand;
                    DataTable dataTable = new DataTable();
                    dataAdapter.Fill(dataTable);
                    MrsUserDataTable = dataTable;
                }
            }
            catch (System.Exception ex)
            {
                Debug.WriteLine("Error Setting Connection to MRSUSERS, Error Message: {0}", ex.Message);
                throw;
            }
        }

[Vladimir Stoyanov]

Hello Herb,

You can check out the Exporting to Xlsx and Pdf RadGridView example from our demos. It demonstrates a possible approach for exporting the control with a command. 

You can also check out the ExportToXlsx method accepting a GridViewDocumentExportOptions as a parameter. This object has an Items property, where you can specify the items that need to be exported. You can add the selected item to the Items collection and it will be the only exported item. 

I hope you find this helpful.

Regards,
Vladimir Stoyanov
Progress Telerik

[herb]

Those helped.