Yes, we use ribbons in all our applications. When DevExpress released their first ribbon control for WinForms I was quite hesitant to use it. So I created a customizable interface to allow the end-users to switch between the ribbon, standard menu/toolbars or a sliding/dockable navigation bar. After several months virtually all of them were using the ribbon bar with only a few using the navigation bar. All subsequent applications are ribbon only. With the DevExpress ribbon, keyboard navigation is very easy and it also includes the quick-launch bar like Office (their favorite feature). For those that complained it took up too much space, it was a training issue....they didn't know how to minimize the ribbon. Once trained though they were actually more receptive to the Office ribbon. Cheers!

There are lots of great samples of how to manipulate the DataGrid here: http://www.syncfusion.com/FAQ/winforms/default.aspx#44[^] But look real closely at example 5.9. In there it talks about creating the combobox and filling it with data. Do you want the data in the combobox to be bound or unbound? Dean

Public G_ScreenshotPath As String = System.IO.Path.Combine(G_RuntimePath, "temp.bmp") Dim strPath As String = CaptureScreenToFile(CaptureScreenToImage(True), G_ScreenshotPath) Public Function CaptureScreenToFile(ByVal picImage As Bitmap, Optional ByVal FilePath As String = "") As String 'Get the executables path Dim file_name As String = Application.StartupPath & "\temp.bmp" If FilePath <> "" Then file_name = FilePath End If ' Save the picture as a bitmap, JPEG, or GIF. Try picImage.Save(file_name, System.Drawing.Imaging.ImageFormat.Bmp) Catch Return Nothing Exit Function End Try CaptureScreenToFile = file_name End Function Public Function CaptureScreenToImage(Optional ByVal FullScreen As Boolean = False) As Bitmap ' Captures the current screen and returns as an Image object If FullScreen = True Then ' Print Screen pressed twice here as some systems ' grab active window "accidentally" on first run. SendKeys.SendWait("{PRTSC 2}") 'Pause to let the system catch up: System.Threading.Thread.Sleep(1000) Else SendKeys.SendWait("%{PRTSC}") 'Pause to let the system catch up: System.Threading.Thread.Sleep(1000) End If Dim objData As IDataObject = Clipboard.GetDataObject() Return objData.GetData(DataFormats.Bitmap) End Function

This works great for me: http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q745q[^] Dean

Try: Me.tabcontrolname.SelectedTab = nameofthetab or Me.tabcontrolname.TabPages(x).Select() where x is the index of the tab you want selected Dean

I subclassed a datagrid and use this code: Dim x As Integer, y As Integer Dim wb As Excel.Workbook Dim ws As Excel.Worksheet Dim oExcel As Excel.Application Static SheetCount As Integer = 1 Dim tbl As DataTable = CType(Me.DataSource, DataTable) Cursor.Current = Cursors.WaitCursor If Not Me.ReadOnly Then Dim changedRows As New ArrayList Dim row As DataRow For Each row In tbl.Rows If row.RowState <> DataRowState.Unchanged Then changedRows.Add(row) End If Next If changedRows.Count > 0 Then Cursor.Current = Cursors.Default MsgBox("There are pending data updates for this grid. Please save these updates to the database prior to exporting the data to Excel.", MsgBoxStyle.Information, "Pending Updates") Exit Sub End If End If If oExcel Is Nothing Then oExcel = New Excel.Application End If wb = oExcel.Workbooks.Add ws = wb.Sheets.Add ws.Name = "Export" & SheetCount SheetCount = SheetCount + 1 'write column headers For x = 0 To tbl.Columns.Count - 1 ws.Range(Chr(65 + x) & "1").Value = tbl.Columns(x).ColumnName ws.Range(Chr(65 + x) & "1").Font.Bold = True Next 'write data For x = 0 To tbl.Rows.Count - 1 For y = 0 To tbl.Columns.Count - 1 ws.Range(Chr(65 + y) & (x + 2).ToString).Value = tbl.Rows(x).Item(y) Next Next oExcel.Application.Visible = True ' Release Application object and allow Excel to be closed by user: If Not oExcel.UserControl Then oExcel.UserControl = True System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel) oExcel = Nothing Cursor.Current = Cursors.Default As you can see there are several references to "Me" in this routine for my use. In your case you would simply replace "Me" with the name of your datagrid. You will also need to add a reference to Excel in your project. Hope this works for you. Dean

Try this: http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q653q[^] Dean

To determine the selected rows in a datagrid, try this: http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q775q[^] Hope this helps, Dean

Try these: http://64.41.105.202/sections/dotnet.html[^] http://msdn.microsoft.com/msdnmag/issues/03/09/DataPoints/[^] http://www.ondotnet.com/pub/a/dotnet/2003/01/06/sqlce20.html?page=1[^] Requires free membership login: http://www.ftponline.com/vsm/2003_10/magazine/features/thews/default_pf.aspx[^] Hopefully these will get you started. Dean

To add a combobox to the grid: http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q480q[^] To add a buton: http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q888q[^] Dean

This worked great for me: http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q745q[^] Dean

In that case, what I would do is put the actual URL navigation text in another hidden column of your listview and reference that text for the Navigate command. So where the users see: 1sitename.url 2sitename.url ...listed in the first column of the listview, in the second column (with a column width of zero) would be the URL navigation text: http://www.1sitename.com http://www.2sitename.com Then in the SelectedIndexChanged event you could do your navigate: Me.WebBrowser1.Navigate(Me.lvwLeft.SelectedItems(0).SubItems(1).Text) Dean

So what exactly is in the listview? Is it at list of URLS like this: http://www.codeproject.com http://www.msn.com http://www.google.com . . . etc? Or does the list contain the name of each website like this: CodeProject MSN Google . . . etc? Thanks, Dean

What specifically is it you want to ignore? Column sorting? If so, set AllowSorting to False. Colors changing when a row is clicked? If so, set the SelectionBackColor to be the same as BackgroundColor. You would also probably want to set RowHeadersVisible to False and ReadOnly to True. Is there something beyond this? Dean

In the SelectedIndexChanged event for the listview: Me.WebBrowser1.Navigate(Me.lvwLeft.SelectedItems(0).SubItems(1).Text) This is assuming the URL is in the second column of the listview. If the URL is in the first column of the listview: Me.WebBrowser1.Navigate(Me.lvwLeft.SelectedItems(0).Text) Dean

Give this a try when you are done using Excel: ' Release Application object: If Not oExcel.UserControl Then oExcel.UserControl = True System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel) 'Release worksheet: If Not oWorkSheet Is Nothing Then System.Runtime.InteropServices.Marshal.ReleaseComObject(oWorkSheet) oWorkSheet = Nothing End If 'Release workbook: If Not oWorkBook Is Nothing Then System.Runtime.InteropServices.Marshal.ReleaseComObject(oWorkBook) oWorkBook = Nothing End If oExcel = Nothing oExcel is your Excel application object. oWorksheet is your Excel worksheet object if you have one instantiated. oWorkbook is your Excel workbook object if you have one instantiated. Dean

What's happening is the currency manager for the datagrid is no longer pointing to the correct row after you perform a sort. Here's a good description of the problem and a potential solution: http://weblogs.asp.net/dmarsh/archive/2003/01/22/646.aspx[^]

You can pull data directly from the dataview which would allow you to only use the filtered data: Dim i As Integer = 0 Dim dr As DataRowView For Each dr In MydataView ExcelWs.Cells(i, 1).Value = dr("Field1") ExcelWs.Cells(i, 2).Value = dr("Field2") ......... ExcelWs.Cells(i, n).Value = dr("Fieldn") etc i += 1 Next Dean

Have you tried: Dim dSource As Object dSource = DataGrid.DataSource If TypeOf dSource Is DataView Then Dim tbl As DataTable = CType(DataGrid.DataSource, DataView).Table 'Export to Excel... End If Dean

Hmmmm...you may want to verify that. For me, the .TableStyles(0).GridColumnStyles property always returns the actual column width. But I'm only using the one Tablestyle. Do you have multiple styles defined? Also, are you referencing this property in response to a certain event being fired? I reference the property immediately after the user resizes a column in the MouseOver event. Dean