Formatting DataGrid

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Winforms
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - pointers on creating app like Computer Management Hi, I would like to create an app that has the same layout as Windows Computer Management where clicking on a treeview item (in left pane) loads a different panel/control in the right pane. What I don't understand is how to show and hide (or load and unload) the different controls/panels in the right pane at runtime. If anyone has any pointers or examples on best practices (minimal memory usage) for doing this sort of thing, or even keywords to search on this topic, that would be great. Thanks! -Elsa Tag: Formatting DataGrid Tag: 85162
  - 2
    - DataGrid : Manipulating Columns Without TableStyles I bind a DataGrid to a DataView - everything looks nice, except for the column widths. How can I programatically modify the bound columns without going to the effort of creating TableStyles and ColumnStyles ? I just want to bind it then modify the default layout a little. Tag: Formatting DataGrid Tag: 85158
  - 3
    - Get caret pos in TextBox The documentation states that you can use the SelectionStart property of the TextBox to get the position of the caret in the TextBox. Well, what if the selection is BEFORE the caret? Say you have the word â??TEXTâ?? and you want to select â??EXâ??. There are 2 ways you can do this. You can click before the E and drag to the X so the caret is now sitting after the X. You can click after the X and drag to the E so the caret is now sitting before the E. In both cases the SelectionStart property has the value of 1 and the SelectionLength has a value of 2, yet the caret is in two different places. Using the SelectionStart property alone canâ??t always give you the correct caret position. How can one get the true caret position and be absolutely sure itâ??s correct? Tag: Formatting DataGrid Tag: 85157
  - 4
    - Problem using a UserControl in a DataGrid Hi In my Windows Form application I created a File Browser control that was derived from System.Windows.Forms.UserControl. It contains a single line text box and a button. The user can enter a filename in the text box or hit the browse button which pops up the File Open Dialog box and lets the user select a file. The subsequent selection is placed in the text box. This control is placed in a DataGrid using a column derived from DataGridColumnStyle. Everything works great except when Iâ??m entering text in the text box of my File Browser control, hitting Left, Right, Home, or End moves the current cell in the DataGrid instead of moving the caret in the text box. Iâ??ve found that if I derive a class from TextBox and use that in my UserControl instead of using the stock TextBox, override the ProcessCmdKey() method, and move the caret myself, I can get this to work correctly. This seems really sloppy though. I donâ??t know why the TextBox is not using and keeping the keys instead of ignoring them and letting the messages bubble up to the grid control. Anyone have any ideas? Any help would be appreciated. Thanks Tag: Formatting DataGrid Tag: 85149
  - 5
    - Bug in UpDownBase.UpDownEdit class ValueChanged event of NumericUpDown isn't fired when type in it by keyboard even it lost focus. The error in class System.Windows.Forms.UpDownBase.UpDownEdit : protected override void OnLostFocus(EventArgs e) { this.parent.OnLostFocus(e); } To fix that bug the method must be changed: protected override void OnLostFocus(EventArgs e) { this.parent.OnLostFocus(e); base.OnLostFocus(e); } Tag: Formatting DataGrid Tag: 85145
  - 6
    - How to create an "Desktop Taskbar Application" Hi, I would like to know if it's still possible on Windows 2000 or XP to create a "Desktop Taskbar Application" (An application who attach it-self to the edges of the Desktop screen) in VB.NET or C# I know how to do it with the WIN32 API. the following link show how to do it: http://support.microsoft.com/default.aspx?scid=kb;en-us;134206 According to this article (Q134206), it's the Windows Explorer shell of 95, 98 and NT4.0 who allowed this possibility. Is it still possible ? If so, I want to go to the next level, I mean with .NET. Is there a Class in the .NET Framework that will allow me to do that??? Tag: Formatting DataGrid Tag: 85142
  - 7
    - MouseDown, MouseUp Hi, I have trouble understanding why this fails but here is what I'm trying to do: I have 1 form with 2 controls in it. I created a MouseDown handler for both controls (setting up different internal things each) and 1 MouseUp handler for the form since both controls can use the same code. Now, what I was excepting was: - The 2 controls would catch and call their MouseDown handlers: that works. - And as none of the controls have no MouseUp handler the message would be propagated to the parent form where the form MouseUp handler would be called: that doesn't work. Capturing the mouse doesn't help. Any ideas? Thanks Tag: Formatting DataGrid Tag: 85140
  - 8
    - Undo/Redo mechanism Hi, I have a small graphics app and am trying to improve on the undo/redo mecahism for the users. Currently jusy kee a track of the last 5 items added or deleted and allow thos to be removed/re-added. Any ideas on an undo/redo mechism or part of a class-design that will help this process and make it more funcitional against all user actions? Thanks, Lini Tag: Formatting DataGrid Tag: 85136
  - 9
    - how to change printer settings Hi All, Does someone knows how to manage printer settings programmatically? System.Drawing.Printing.PrinterSettings class allows to change them for a custom document but I need to do it not for one document but for an installed printer in general, the same way I can do it manually by opening Printers folder on my local computer, selecting printer and changing it's settings. When I do it manually there is no difference if a printer is local or network one. Is there a convenient way to do it via .NET? At least, I'd like to find a way to manage settings of network printers. Thanks, Artem Tag: Formatting DataGrid Tag: 85135
  - 10
    - Should I store Graphics object ? hi, We are currently porting our project from VB6 to VB .NET. Earlier we used to make scale transformations on objects like pictureBox , forms etc.Now Such transformations are made on the graphics object of the form/pictureBox. Should It be better if make a graphics object from my pictureBox in load event handler of the form and store it as member variable of the form , make transformations as and when required(we really require such transformations from mils to pixels.). And finally I can dispose it when the form is disposed. But I have read somewhere that Graphics object should never be stored as member varibale of a class.And so I am really confused as to what should I do ? Plz help me regarding this.. sanjay Tag: Formatting DataGrid Tag: 85131
  - 11
    - MDI child problem (switching between MDI children) Hi, I have an MDI container with several MDIchildren. When more than 1 childform is opened i get a problem when clicking another form to get to it (take it to foreground). It only works when a control is clicked in the other form, otherwise, the first form just stays in the forground and the other form doesn't get selected. I hope this is kind of clear. I thought the problem was with one childform having the topmost-property set to true, but this isn't the case. Anyone seen this behaviour and knows what might cause it. Thanks, Bjorn. Tag: Formatting DataGrid Tag: 85130
  - 12
    - Drawline on Form at runtime with mouse? Greetings, I would like to draw lines on the form at runtime. Most important are to have the ability to control the line drawn to be Straight horzaontally, vertically and at a 45 degree angle. I have looked at the Scribble program and nknow I will need to capture the moust current position for the Pen tool. I also need to save and these images and recall as needed. I am learning VB Net 03 with FW1.1. Thanks for any assistance Mark Gaeth Decatur, IN Tag: Formatting DataGrid Tag: 85129
  - 13
    - Label controls inside rich textbox Hi all, i have a situation to place label controls inside rich textbox control and i have done that using richTextbox1.controls.add method. But the problem is the controls are not part of the text which i type it is overlapping my text.In simple words, Is it possible to make a label control work just like a text inside the rich textbox. I did find out that this is possible in java, to be exact it is achieveable using a TextPane java control. Any inputs or ideas to acheive the same in .Net (C#) would be a welcome. Thanks in advance. Regards Muthu muthuraman.m@polaris.co.in Tag: Formatting DataGrid Tag: 85123
  - 14
    - n-tier If i wrote a DALC class in a class library, and then referenced this class in a windows forms application, and deployed the EXE of the windows project in a client PC, would the DALC assembly also have to be in the same client PC or can it reside in the server ? Regards, Chak. Tag: Formatting DataGrid Tag: 85119
  - 15
    - Non-modal dialog Hi, I have a window, where for a certain event(button click), I am starting a new thread. This thread is retrieving data, creating a new window and displaying it. The window is being shown by "name.Show();". As the window is being opened, it is being closed immediately. I know that I can use the ShowDialog() method, but that would block the execution of the other thread till the other terminates. ****event**** Thread x = new Thread(new ThreadStart(myMethod)); x.Start(); myMethod() { .... Doing some execution messageWindow.Show(); .... I would like this to contine to live until window is closed, .... and the other window(main) to contine operate on its own. } Can someone help me out. Thanks in Advance Tag: Formatting DataGrid Tag: 85116
  - 16
    - Items in Combo Box list are not visible I am using Visual Basic .Net with Windows XP Professional. I have added a Combo Box to my form and changed the drop-down style to DropDownList. I have added items by typing them into the items property: "Item1" "Item2" "Item3" "Item4" "Item5" "Item6" When I run the code, the items are not visible in the drop-down list -- even though I have verified that the item count is correct when running the code. If I click on the empty space in the drop-down list where an item should be, it appears in the Combo Box. For instance, if I click where Item 1 should be then Item 1 appears in the Combo Box. Why are the items in the list not visible? Tag: Formatting DataGrid Tag: 85112
  - 17
    - How to hide a TabPage on a TabControl? Is there any way to hide a TabPage that is already inserted into a TabControl? The method Hide doesn't seem to work. Thank you Cezar Tag: Formatting DataGrid Tag: 85110
  - 18
    - Creating a custom container control Hello, I'd like to create a custom control that exposes several containers, much like the SplitContainer in VS 2005. However, when I create a custom control with several panels and I drag a control onto the custom control, it will become part of that custom control and not part of the Panel that's on the custom control. How do I change this behaviour? Thanks in advance for any info, Bram Tag: Formatting DataGrid Tag: 85109
  - 19
    - Combo box drop down I am sure this has been asked a million times, but I have Googled until I am blue in the face...so Iam asking again... How can I make a combox drop down automatically when it receives focus? TIA John Tag: Formatting DataGrid Tag: 85107
  - 20
    - Embedded form and Anchor property The following situation: Panel control with Dock=Fill, inside a panel an embedded form with controls in it. The code embedding the form into the panel is this: pnl.Controls.Add(form1); Everything is working perfect, except the Anchor property of controls on the embedded form is not working. The form has a grid that should be anchored to all four sides, however, because the form is embedded into the panel, this whole design is not working. Am I missing anything? Any workaround? Thank you in advance. Cezar Tag: Formatting DataGrid Tag: 85104
  - 21
    - Bug in DataGrid.CommitEdit (.Net v1.1) After many hours of debugging, I've finally come to the conclusion that there is a bug in DataGrid's CommitEdit. I have the following situation: I've a custom DataGridColumnStyle (for a ComboBox, who hasn't done one of these?). If no selection is made (e.g. SelectedIndex == -1), I want to abort the commit. Problem is, when my DataGridColumnStyle.Commit override is called and returns false, DataGrid.CommitEdit causes a NullReferenceException to be thrown. I'm using the following code: /// <code> bool retValue = false; try { int index = this._Combo.SelectedIndex; if ( index >= 0 ) { object value; if ( this._Combo.ValueMember == null ) value = this._Combo.SelectedItem; else value = this._Combo.SelectedValue; this.SetColumnValueAtRow( source, rowNum, value ); retValue = true; } } catch(Exception) {} this.EndEdit(); return retValue; /// </code> I googled some posts and saw people having the same problem, but I saw no explanations. Not satisified (and lacking a solution), I fired up WinDbg, SOS and Reflector. The disassembler DataGrid.CommitEdit is: /// <code> private bool CommitEdit() { if ((!this.gridState[0x8000] && !this.gridState[0x4000]) || this.gridState[0x10000]) { return true; } this.gridState[0x10000] = true; if (this.editColumn.ReadOnly || this.gridState[0x100000]) { if (base.ContainsFocus) { if (this.gridState[0x800]) { this.FocusInternal(); } this.editColumn.ConcedeFocus(); if ((this.gridState[0x800] && base.CanFocus) && !this.Focused) { this.FocusInternal(); } } this.gridState[0x10000] = false; return true; } bool flag1 = this.editColumn.Commit(this.ListManager, this.currentRow); this.gridState[0x10000] = false; if (flag1) { this.gridState[0x8000] = false; } return flag1; } /// </code> In WinDbg, I broke on the exception thrown and took a look at the object dump for the datagrid. Turns out that the first if statement evaluates to false. On the second if statement (if (this.editColumn.ReadOnly ...), DataGrid.editColumn is null, hence the exception. The full stack trace leading up to the exception is: System.NullReferenceException: Object reference not set to an instance of an object. at System.Windows.Forms.DataGrid.CommitEdit() at System.Windows.Forms.DataGrid.EndEdit() at System.Windows.Forms.DataGrid.Edit(String instantText) at System.Windows.Forms.DataGrid.Edit() at System.Windows.Forms.DataGrid.set_CurrentCell(DataGridCell value) at System.Windows.Forms.DataGrid.OnMouseDown(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) The exact context of the crash is, I'm editting my combo box column, then click another column (with a selected index == -1, causing my Commit to return false). Oddly enough, if I cancel editting by clicking a control outside of the data grid (e.g. not causing another cell to gain focus), no error occurs until the data grid once again has a cell gain focus. Can anyone confirm/reproduce this? If necessary, I'll throw together a toned-down application to reproduce the error. Thanks, Nathan Tag: Formatting DataGrid Tag: 85101
  - 22
    - Cannot set form background image I recently started using VisualStudio.Net for the first time. I started a project and created some forms to gain an understanding of how to use C#, Visual Studio, and the .Net framework. One of the first things I did was to create a non-standard window with rounded corners and set the background image of the form. I set the background image by simply opening the form properties and clicking the "..." button next to the BackgroundImage property and selected an image to use as the background, in this case it was a JPG, and all was fine. I could see the background image in Visual Studio and when I ran my application. Sometime later I created a new project and started developing a small and real application. I decided to add a splash screen. I wanted to use a bitmap I created as the backgroud of the splash screen. As before I opened the form properties and clicked the "..." button next the BackgroundImage property and selected the bitmap only to receive an error "Empty path name is not legal". I tried selecting several different images with the same result. I then copied images to c:\ and tried selecting from there with the same result. I thought I must have been doing something differently then I had done with the first project in which I sucessfully set the background image. I tried setting the background image in the first project, thining it would work, but it did not. I got the same error. So I closed everything down and rebooted, thinking this might help, but it did not help. What the heck is going on? Has anyone ever encountered this problem? Did I inadvertently change some critical environment setting that is causing this problem? I am baffled! Tag: Formatting DataGrid Tag: 85100
  - 23
    - TabControl/TabPage VisibleChanged event problem I am using the VisibleChanged event of the tabpage to add/remove main menu bar items. When I receive the visiblechanged event and the visible=true I add the main menu item and when I receive the event and visible=false I remove the main menu item. Everything works great, switching between the tabs works great. The problem comes in when I remove a tabpage from the tabcontrol. The tabpage receives one final visiblechanged event with visible set to true and I add the menu item back to the main menu. Is this a bug in the framework? The tab page is not in fact visible, but I don't receive any further visiblechanged events to indicate this. Any one have any work arounds for this? Any other suggestions on how to implement main menu items for each tab page? Or any other suggestion on how to hide a tab on the tab control without removing it. Thanks, Tom. Tag: Formatting DataGrid Tag: 85096
  - 24
    - Tabindex major trouble Hello. I have a form with a tab control with some tabpages. On each of the tabpages I have separate user controls. The user controls constist of labels, textboxes, combo boxes and datagrids. The problem is that I can't move focus between the input controls with the tab button. At all. All my controls have the TabStop property set to True, and have a positive number. The form is inherited from a form which in turn is inherited from a windows form. All of the controls I use are my own, inherited from windows controls. What could possibly be wrong? Where should I look? Thanks - Niklas Tag: Formatting DataGrid Tag: 85095
  - 25
    - Random Exceptions in WinForms Application Periodically users are experiencing a crash of a .Net WinForms application running on Windows 2000. The application displays a MessageBox that is created in the handler for the Application.ThreadException event and the application terminates. The crashes seem to be random in that the users are not doing the same thing in the application when they crash nor can any other pattern be discerned. We have been unable to reproduce the problem. Resolution: The application needs to be restarted. Any unsaved information is lost. Sample Stack Trace: Type: System.NullReferenceException Message: Object reference not set to an instance of an object. StackTrace: at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam) at System.Windows.Forms.NativeWindow.DefWndProc(Message& m) at System.Windows.Forms.Control.DefWndProc(Message& m) at System.Windows.Forms.Control.WmUpdateUIState(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.ParkingWindow.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Tag: Formatting DataGrid Tag: 85094
- Next
  - 1
    - Parameter ?_1 has no default value I'm using the HierCube .net OLAP component from rainbowsoft (http://www.rbwsoft.com/) in a vb winform application (vs2003). The data source is an MS Access 2000 table; the data adapter is of the oledb type; and the sql string has two parameters ala =? At runtime the app provides values for the params like so: oledaPivotData.SelectCommand.Parameters("Conversion").Value = cboConversion.SelectedValue oledaPivotData.SelectCommand.Parameters("Year").Value = cboYear.SelectedValue The cube works fine. However the cube control won't let me access the Dimension Mapping facility, it complains that "Parameter ?_1 has no default value". I'm not sure how to solve this. I've written to the control developers, but they can be slow to respond...and this issue seems to be more generic than specific to this control. I've not been able to find a discussion here that deals with my situation, most other cases are using SPs. Tag: Formatting DataGrid Tag: 85092
  - 2
    - Centre form in MDI Hi Am new to VB.NET and wondering how to centre my form in the mdi that is maximised or set to a diferent size. I tried this wTop = (frmMDI.Size.Height - frm.Size.Height) \ 2 wLeft = (frmMDI.Size.Width - frm.Size.Width) \ 2 frm.Location = New Point(wLeft, wTop) Main problem is when the mdi form is maximised, the size reported is not the new size but the size set at design time. -------------------------------- From: 99pshop ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>S5mkO9K/CkSal1+Yq3wnyQ==</Id> Tag: Formatting DataGrid Tag: 85089
  - 3
    - Smart Client and satellite assemblies Hi, we have a Windows.Forms application having several assemblies for which we have defined satellite assemblies in seperate folders according to the culture they were created in. We had to adjust the policy to full trust (each of the assemblies are sign with same key) in order to allow the download of the .exe using IE. The download of the application works but when we try to display information in the correct language it fails to do so because the correct satellite assembly was not downloaded (checked using Fusionvwlog). Has any one any clues what's going wrong? Thanks ! Stefaan Tag: Formatting DataGrid Tag: 85087
  - 4
    - hotkeys trouble Hello, maybe someone have faced with this problem: I have a control with some textboxes, labels and buttons. Buttons have a keybord shortcut i.e. button1.Text = "Bro&wse"; the problem is that this shortcut works only when focus is on any control that has a tabindex number less than a button. It doesn't work with a focus on this button also. This problem confirms only on Windows 2000. The same app on WinXP works as expected, and has no troubles. Framework 1.1 is installed on both. Any suggestions and links on articles will be appreciated. Thanks Tag: Formatting DataGrid Tag: 85086
  - 5
    - Custom Order in Property Grid Control How to Implement Custom Order in Property Grid Control in C# ? I Implemented PropertyGrid.PropertySort = PropertySort.NoSort but it is Displaying in Some other Order. I want to specify the Order for Properties in the PropertyGrid Please Help. Thanks in Advance. Srinivas. -- Message posted via http://www.dotnetmonster.com Tag: Formatting DataGrid Tag: 85085
  - 6
    - Turn off blue bar at top of DataGrid Hi, Is there a way of removing the blue bar that appears at the top of a DataGrid? Thanks, Steve Tag: Formatting DataGrid Tag: 85084
  - 7
    - Deleting from a table via a dataset positioning problem I'm getting very confused trying to make my "Delete" button work. All looked ok at first, with: Private Sub DeleteButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DeleteButton.Click Dim pos As Integer = GetPosition() If MsgBox("Delete record " + Str(pos) + " (" + StatusString(pos) + ")?", MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then TextBox1.AppendText("Deleting " + Str(pos) + " (" + StatusString(pos) + ")" + Chr(13) + Chr(10)) DataSet11.Tables("table").Rows(pos).Delete() End If End Sub Function GetPosition() As Integer GetPosition = Me.BindingContext(DataSet11, "table").Position End Function Function StatusString(ByVal pos As Integer) As String Dim drsi As DataRowState = DataSet11.Tables("table").Rows(pos).RowState Dim drss As String = "" If (drsi And 1) <> 0 Then drss = drss + "Detached " If (drsi And 2) <> 0 Then drss = drss + "Unchanged " If (drsi And 4) <> 0 Then drss = drss + "Added " If (drsi And 8) <> 0 Then drss = drss + "Deleted " If (drsi And 16) <> 0 Then drss = drss + "Modified" StatusString = drss End Function The msgbox says "Delete record 0 (Unchanged)?", and after clicking Yes, the values in the textboxes, bound to various fields in "table", do change to show those in the second record (ie record 1). But when I click again on Delete, the msgbox now says "Delete record 0 (Deleted)?", and clicking Yes has no effect. Even worse, I've found that after getting to the last record with... Private Sub TopButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TopButton.Click Me.BindingContext(DataSet11, "table").Position = _ Me.BindingContext(DataSet11, "table").Position.MaxValue End Sub ..then back to the second-from-last with... Private Sub DownButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DownButton.Click Me.BindingContext(DataSet11, "table").Position -= 1 End Sub ..(second-from-last rec shows ok), then Delete, the msgbox says "Delete record 88 (Unchanged)?", which is good. But after deleting it, (and the display going back to show rec 0 again for some reason) and then going to the last record again and clicking Delete again, the msgbox says "Delete record 88 (Deleted)?"!! (I have a 'debug' text box which shows the statuses of the last few records ('rows', I should say), and that clearly shows record 88 as Deleted, and 89 as Unchanged.) Whew! Thanks, if anybody's read this far. I'm confused. I'm clearly not getting something. Help Please? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Formatting DataGrid Tag: 85083
  - 8
    - Two Combobox in datagrid Hi, I have 2 combobox in datagrid, one parent(display CATEGORY) & another one is child(display SUB_CATEGORY). I want if user select item in parent(CATEGORY) the correct list of SUB_CATEGORY will be display in child combobox. The code below I'm using RowFilter to filter SUB_CATEGORY but it's not working. Private Sub MakeDataSetAndBindGrid() Dim sqlString As String = "SELECT PRO_CATEGORY_ID,PRO_ID_NUM,COM_ID_NUM,CATEGORY_ID,SUB_CATEGORY_ID FROM CIS_PRO_CATEGORY" dataAdapter = Nothing myDataSet = Nothing Try dataAdapter = New OleDbDataAdapter(sqlString, connection) myDataSet = New DataSet dataAdapter.Fill(myDataSet, "CIS_PRO_CATEGORY") sqlString = "SELECT CATEGORY_ID,CATEGORY_DESCRIPTION FROM MST_CATEGORY ORDER BY CATEGORY_ID" dataAdapter = New OleDbDataAdapter(sqlString, connection) dataAdapter.Fill(myDataSet, "MST_CATEGORY") dataAdapter = Nothing sqlString = "SELECT SUB_CATEGORY_ID,CATEGORY_ID,SUB_CATEGORY_DESCRIPTION FROM MST_SUB_CATEGORY" dataAdapter = New OleDbDataAdapter(sqlString, connection) dataAdapter.Fill(myDataSet, "MST_SUB_CATEGORY") dataAdapter = Nothing connection.Close() tableStyle.MappingName = "CIS_PRO_CATEGORY" Dim dt As DataTable = myDataSet.Tables("CIS_PRO_CATEGORY") Dim i As Integer While i < dt.Columns.Count If i < 3 Then Dim TextCol As New DataGridTextBoxColumn TextCol.MappingName = dt.Columns(i).ColumnName TextCol.HeaderText = dt.Columns(i).ColumnName tableStyle.GridColumnStyles.Add(TextCol) ElseIf i = 3 Then Dim ComboCateg As New DataGridComboBoxColumn ComboCateg.MappingName = "CATEGORY_ID" ComboCateg.HeaderText = "CATEGORY_ID" ComboCateg.Width = 120 ComboCateg.NullText = "" ComboCateg.ColumnComboBox.DataSource = myDataSet.Tables("MST_CATEGORY").DefaultView 'dv; ComboCateg.ColumnComboBox.DisplayMember = "CATEGORY_DESCRIPTION" ComboCateg.ColumnComboBox.ValueMember = "CATEGORY_ID" 'Create event handlers AddHandler ComboCateg.ColumnComboBox.SelectedIndexChanged, AddressOf ComboCategClick tableStyle.PreferredRowHeight = ComboCateg.ColumnComboBox.Height + 2 tableStyle.GridColumnStyles.Add(ComboCateg) Else myDataView = New DataView(myDataSet.Tables("MST_SUB_CATEGORY")) Dim ComboSubCateg As New DataGridComboBoxColumn ComboSubCateg.MappingName = "SUB_CATEGORY_ID" ComboSubCateg.HeaderText = "SUB_CATEGORY_ID" ComboSubCateg.Width = 120 ComboSubCateg.NullText = "" ComboSubCateg.ColumnComboBox.DataSource = myDataView ComboSubCateg.ColumnComboBox.DisplayMember = "SUB_CATEGORY_DESCRIPTION" ComboSubCateg.ColumnComboBox.ValueMember = "SUB_CATEGORY_ID" tableStyle.PreferredRowHeight = ComboSubCateg.ColumnComboBox.Height + 2 tableStyle.GridColumnStyles.Add(ComboSubCateg) End If i = i + 1 End While DataGrid1.TableStyles.Clear() DataGrid1.TableStyles.Add(tableStyle) DataGrid1.DataSource = dt Catch ex As Exception MessageBox.Show("Error: " & ex.ToString) Me.Close() Return End Try End Sub Public Sub ComboCategClick(ByVal sender As Object, ByVal e As System.EventArgs) Dim lxCombo As ComboBox = DirectCast(sender, ComboBox) If Microsoft.VisualBasic.IsNothing(lxCombo.SelectedValue) = False Then myDataView.RowFilter = "CATEGORY_ID=" & lxCombo.SelectedValue.ToString() End If End Sub Somebody have mention about using "Relations" but I don't have any idea how to use that. Thanks in advance Tag: Formatting DataGrid Tag: 85082
  - 9
    - Disabling maximise button affects maximised form size...? I've just noticed that if I set a form's window state to be maximized, and also disable the maximize button on the title bar, then the form will cover the task bar. If I enable the Maximize button, then the form does not cover the task bar. I assume this is 'by design'.... but I need a window that has no maximize button (so the user cannot 'de-maximize it) but also I don't want it to cover the task bar. Is this possible through some other nefarious means? Cheers Ant Tag: Formatting DataGrid Tag: 85081
  - 10
    - Activate issue: not activated or active window on load I have a MDI application, but that isn't important, and why I posted it here instead of the MDI forum. I have class "App Loader" that contains Main. It loads a splash screen that shows up before the main window, and it runs on a background thread. It shows up while the app is loading. Once the app has loaded all the required resources, the main form is shown and activated. On Win 2003 and Win2K, the "app" flashes in the taskbar, but doesn't show up as the active window in the foreground. If you run it by clicking the EXE from within Windows Explorer, after it loads, Explorer is still the active window. I tried: //make this puppy come to front and activated Application.DoEvents(); this.TopMost = true; this.TopMost = false; this.BringToFront(); this.Activate(); This did improve the behaviour on XP, but not Win2K and Win2003. Thanks for the help, Josh Blair Tag: Formatting DataGrid Tag: 85076
  - 11
    - What's wrong with DataView I have such sentence in my program: {... ... DataView dataView = new DataView(dataSet.Tables[0]); Console.Writeline(dataView.Count.toString());} And this module runs very frequently. There are ten records in the Tables[0] . But in one of PC with XP SP2, we can only get one record from dataView. That means dataView.Count.toString() is 1. Why? Tag: Formatting DataGrid Tag: 85072
  - 12
    - Debug makes Windows freezing? I used Visual Studio 2003/Windows XP SP1 to create a window application. At the form, I put a button and run debug. I put some break point on the Load event of form and it works fine. I also put a break point at click button event and click the button, but I never get the break point at the click button event. The Windows system seems freezing. I can not call other program. I can not use ALT-CTRL-DEL keys to restart the computer. But the Task Manager, which I started before debug, still displays the system parameters. The CPU usage is only 2 or 3 percent. The Mem Usage seems to be normal, too. I reinstalled the Visual Studio and I still got the problem. Could some one help me to solve the problem? Thanks - George Tag: Formatting DataGrid Tag: 85070
  - 13
    - XmlDataDocument.load second time Hi All, I have this xml file and loaded it by XmlDataDocument.load function. After XmlDataDocument.load function called, I need to load another xml file into XmlDataDocument again. I want to clear existing data in XmlDataDocument and I want to load new data into that XmlDataDocument . So I called XmlDataDocument.load second time. But it failed by giving some error message. And I was not able to modify the Dataset loaded in XmlDataDocument. Will somebody please recommand how to clear existing data and load again? Any suggestion is appreciated. Thanks Shwe Tag: Formatting DataGrid Tag: 85069
  - 14
    - ANN: 9Rays FlyGrid.Net 1.0 is released. FlyGrid.Net 1.0 is released! 9Rays.Net is proving that great things indeed come in small packages. Having enjoyed success in beta preliminary release versions, FlyGrid.Net is taking off in full release, promising to deliver a fast and highly customizable Tree/Grid for Windows Forms in only 340Kb. See the feature list and screenshots of FlyGrid on the http://9rays.flygrid.net page. Complete package available for download: complete documentation with C# and VB.Net syntax, C# and VB.Net samples included, Delphi.Net samples coming soon. -- Best regards, Victor Victorov 9Rays.Net Tag: Formatting DataGrid Tag: 85067
  - 15
    - Databinding Combobox to ArrayList (again: argh!) An ArrayList contains Person objects with Properties Name, Age, Phone. A Windows Form displays - TextBoxes for these properties as well as - a ComboBox for the Name and - VCR Buttons First/Previous/Next/Last. DataBinding should display the correct information in the textboxes no matter if navigation happens through the VCR buttons or the combobox. The combobox should always contain the same information as the txtName textbox. I tried several combinations of defining the databinding. No matter what combination of the following lines I used, I get errors from "stack overflow" to metadata/type info displayed in the combobox. txtName.DataBindings.Add("Text", myPersons, "Name") txtAge.DataBindings.Add("Text", myPersons, "Age") txtPhone.DataBindings.Add("Text", myPersons, "Phone") cboName.DataBindings.Add("Text", myPersons, "Name") cboName.DataSource = myPersons cboName.DisplayMember = "Name" cboName.ValueMember = "Name" 1) What is wrong? 2) How does the code need to be changed if objects should be added and deleted from the arraylist by additional buttons? thank you, herbert Tag: Formatting DataGrid Tag: 85065
  - 16
    - Can't access digital camera to copy from in code I am trying to copy pictures from a digital camera in code. When I use the FolderBrowserDialog, it won't let me select the camera as the folder. I have gotten around this by using Shell32.BrowseForFolder. I am then also able to get the names of the files. However, the path is a pidl (i believe). So I am unable to utilize .Net IO classes to manipulate the files. This is windows form that ultimately will allow the user to browse for a camera, pick a client, then ftp pictures to the server for later processing. Thanks, Glen Tag: Formatting DataGrid Tag: 85064
  - 17
    - borderless combobox How can I create a borderless System.Windows.Forms.ComboBox? -------------------------------- From: dan fisherman ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>wKQR1Ld6dk20hPr9P+yd1w==</Id> Tag: Formatting DataGrid Tag: 85063
  - 18
    - adding a checkbox to a datagrid i've read about everything i can find online about this, but nothing seems to work right. the info is queried from MySql and entered into a dataset and the dataset is bound to the datagrid. the first field is either a 1 or 0 and i want it to display as a check box, but when the checkboxes show up they are all checked (i've double checked the data and there are 1's and 0's. how can i make the right ones show the right things? currently i have this: DataGrid LC; CurrencyManager CMLC DataSet dsLC = dbc.BrowseATable("labor", "hasbom, code, description, price, rec"); //function does the MySQL Query and returns the DataSet DataView dvLC = new DataView(dsLC.Tables["labor"]); dvLC.Sort = "code"; dgdLC.DataSource = dvLC; CMLC = (System.Windows.Forms.CurrencyManager)dgdLC.BindingContext[dvLC]; DataGridTableStyle tableStyle = new DataGridTableStyle(); tableStyle.MappingName = "labor"; tableStyle.AlternatingBackColor = Color.LightBlue; tableStyle.SelectionBackColor = Color.Yellow; tableStyle.SelectionForeColor = Color.Black; tableStyle.RowHeadersVisible = false; //bom DataGridColumnStyle bomCol = new DataGridBoolColumn(); bomCol.MappingName = "hasbom"; bomCol.Width = 50; bomCol.HeaderText = "BOM"; bomCol.AllowNull = false; tableStyle.GridColumnStyles.Add(bomCol); //code DataGridTextBoxColumn codeCol = new DataGridTextBoxColumn(); codeCol.MappingName = "code"; codeCol.HeaderText = "Code"; codeCol.Width = 100; tableStyle.GridColumnStyles.Add(codeCol); //description DataGridTextBoxColumn desCol = new DataGridTextBoxColumn(); desCol.MappingName = "description"; desCol.HeaderText = "Description"; desCol.Width = 200; tableStyle.GridColumnStyles.Add(desCol); //price DataGridTextBoxColumn priceCol = new DataGridTextBoxColumn(); priceCol.MappingName = "price"; priceCol.HeaderText = "Price"; priceCol.Format = "c"; priceCol.Width = 50; tableStyle.GridColumnStyles.Add(priceCol); //rec DataGridTextBoxColumn recCol = new DataGridTextBoxColumn(); recCol.MappingName = "rec"; recCol.Width = 0; tableStyle.GridColumnStyles.Add(recCol); dgdLC.TableStyles.Add(tableStyle) Thanx in advance Tag: Formatting DataGrid Tag: 85060
  - 19
    - Datagrid exception I have a .NET windows forms application with one form displaying data. I have a tree view on the left side and the datagrid on the right side. Tree view allows the user to select verious items and based on that selection the datagrid is bound to the appropriate datasource and table from the database. This works well. The problem comes when I resize my form and the grid portion is not visible or just barely visible. Now when I perform the same operations by selecting various items in the tree I get an exception System.ArgumentException with Message : '0' is not a valid value for 'value'. 'value' should be between 'minimum' and 'maximum'. Source : System.Windows.Forms. This happens when I call SetDataBinding method. When I again resize the form so that the grid is more visible this problem goes away. I have also seen a bizzare display with red cross over the entire grid area when I resize the grid again. Is this a known issue in the datagrid ? Can somebody help me ? Thanks Tag: Formatting DataGrid Tag: 85050
  - 20
    - bound comboboxes I have three comboboxes on the form. When the record is displayed, all the three combo boxes are blank. If I select a value in the first combo box, and click save, the first value in the other combo box is displayed automatically. However, if I go to the next record and come back, those 2 combo boxes are correctly shown as blank. Is this a known issue? Any workarounds ? Thanks Tag: Formatting DataGrid Tag: 85045
  - 21
    - WinForm Startup Error I am getting an "'Application' is an ambiguous reference" error when I try to start my WinForms appllication. How can the Application object be ambiguous? Any ideas what I did wrong? Thanks. I am using C# and VS2003. I have declared references: using System; using System.Windows.Forms; using System.ComponentModel; The error occurs in: [STAThread] public static void Main() { try { Global.MainForm = new frmMain(); Application.Run(Global.MainForm); <======== 'Application' is an ambiguous reference SetupSplashScreen(); GetConfigurationData(); if(ValidDB) { InitializeObjects(); } } catch(Exception ex) { MessageBox.Show(ex.Message, "MainForm",MessageBoxButtons.OK, MessageBoxIcon.Stop); } } Tag: Formatting DataGrid Tag: 85042
  - 22
    - Chart Control for VB.NET? Hello, I need to add charting to my application. I didn't have this need before so I missed the resource kit free offer. How can I get a registration key for the resource kit now? Microsoft said they distributed 750k copies. Help please. /Alexis Tag: Formatting DataGrid Tag: 85039
  - 23
    - PropertyGrid - TypeConverter (DropDown) - Internet Explorer hosting problem Hi, I have created a Windows UserControl. This Control hosts a PropertyGrid and a Button control. The UserControl project also includes a class called "TestClass" and a custom TypeConvertor class called "DDConv". When the user clicks on the Button control, the application assigns an instance of "TestClass" to the PropertyGrid. The "TestClass" has a property called "CustProp" and it has an TypeConverter attribute assigned to the "CustProp" property. The TypeConvertor points to the "DDConv" class. The PropertyGrid in the UserControl displays a DropDown against the "CustProp" property when the UserControl is hosted in a windows application. When the UserControl is hosted in Internet Explorer, the PropertyGrid does NOT SHOW any DropDown for the "CustProp" property. NOTE: I test the UserControl in Internet Explorer from a virtual directory on my machine. I have set "FullTrust" for the "LocalIntranet_Zone" on my machine. I want the PropertyGrid to display the DropDown in Internet Explorer - can someone help me in figuring out how to acheive the same? 'TestClass.vb Public Class TestClass Dim _name As String Dim _ddProp As String Public Property Name() As String Get Return _name End Get Set(ByVal Value As String) _name = Value End Set End Property <System.ComponentModel.TypeConverter(GetType(DDConv))> _ Public Property CustProp() As String Get Return _ddProp End Get Set(ByVal Value As String) _ddProp = Value End Set End Property End Class 'DDConv.vb Public Class DDConv Inherits System.ComponentModel.StringConverter Dim _values As String() Dim _restrictToList As Boolean Public Sub New() _values = New String() {"Yes", "No"} End Sub Public Overloads Overrides Function GetStandardValuesSupported _ (ByVal context As _ System.ComponentModel.ITypeDescriptorContext) As Boolean Return True End Function Public Overloads Overrides Function GetStandardValues(ByVal _ context As System.ComponentModel.ITypeDescriptorContext) _ As _ System.ComponentModel.TypeConverter.StandardValuesCollection Return New StandardValuesCollection(_values) End Function Public Overloads Overrides Function GetStandardValuesExclusive _ (ByVal context As _ System.ComponentModel.ITypeDescriptorContext) As Boolean Return _restrictToList End Function End Class Thanks & Regards, Dhwanil Shah dhwanil.shah@patni.com -- Message posted via http://www.dotnetmonster.com Tag: Formatting DataGrid Tag: 85038
  - 24
    - Passing parameters to forms Hi all, I have a function that handles opening child forms in a MDIContainer, I want the child forms to accept a parameter to setup the form when opening. So I simply overloaded the constructor to accept the parameter...that easy enough, however the function that opens the form checks first to see if it's already open and if so just sets focus to that window. Does anybody know how I can setup the form before giving it focus this way? Thanks Gav Tag: Formatting DataGrid Tag: 85034
  - 25
    - Working with Tabs Hello I'm writing an APP for an PocketPC Because of the small Size of the Display I want to use Tabs! The problem is, if I work with the VS-Designer It puts all Code in one File. I also have to put some code there to prepare Data for Viewing. Thats why I fear that i loose the overview in the file Is there some way to easily split the tabs in extra files and also use the FormDesigner of VS.net? I know I can do everything dynamicly but then I lose the advanteges of the Form Designer. Norbert Tag: Formatting DataGrid Tag: 85027

How can I both filter rows and hide columns in a DataGrid? I've tried
several combinations of DataSets, DataViews, DataTables, and DataGrids and I
can do one of the two but never both.

Top