Visual Basic

FirstPrevNext

Re: Need Help on Custom Action Installer Saseendran Kombath23-Oct-08 4:15 Saseendran Kombath 23-Oct-08 4:15  Thanks a lot Saseendran Kombath How do remove unwanted coulmns from a data grid? Arun Philip R21-Oct-08 8:09 Arun Philip R 21-Oct-08 8:09  Hi, i am binding a data grid using an openfiledialoge control, which read the columns from an excel that the user has chose. There are a lot of unwanted headers coming in the grid when it binds, so how can i remove or hide them. I want to display only those headers that i have added in the columns of the data grid. Requesting your help in this matter. Thank's in advance..... Re: How do remove unwanted coulmns from a data grid? Wendelius21-Oct-08 8:28 Wendelius 21-Oct-08 8:28  If you have defined the columns in advance, it may be that you are somehow resetting the GridColumnStyles collection in your code instead of just assigning a new data source using SetDataBinding. The need to optimize rises from a bad design. My articles[^] Re: How do remove unwanted coulmns from a data grid? Arun Philip R21-Oct-08 8:41 Arun Philip R 21-Oct-08 8:41  Thanks for the help Mike, but i am not using setdatabinding. i am using oledb connection, i am using the default view of the data table. i doubt if it has something to do with the default view of data table. why i have this doubt is till i select an excel only those columns that i have defined are shown in the grid but once i select the excel then columns like table_name, data type, isnull(checkbox) etc are shown in the grid. I want to remove or hide these columns. Re: How do remove unwanted coulmns from a data grid? Wendelius21-Oct-08 8:50 Wendelius 21-Oct-08 8:50  Hmm, SetDataBinding is a method for DataGrid class regardless where you get the data from (it could be oledb, file etc). DataView is a valid argument for SetDataBinding and if no columns are defined in the grid before binding is done, all the columns in DataView are shown. You can either loop them through and remove those not needed or define columns in forehand. Perhaps if you could post the code where the problem is, it would be easier to see the cause. The need to optimize rises from a bad design. My articles[^] Re: How do remove unwanted coulmns from a data grid? Arun Philip R22-Oct-08 3:22 Arun Philip R 22-Oct-08 3:22  oki Mike, but still i have not used the SetDataBinding method. Could you tell me how do i got about and loop through it?? Re: How do remove unwanted coulmns from a data grid? Arun Philip R22-Oct-08 4:00 Arun Philip R 22-Oct-08 4:00  Private Sub ofdExcelReader_FileOk(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles ofdExcelReader.FileOk Dim DataViewExcel As DataView txtTempXls.Text = ofdExcelReader.FileName DataViewExcel = FillDataSet() If (DataViewExcel.Table.Rows.Count < 1) Then MsgBox("This Sheet Is Empty. Please Select Another Sheet", MsgBoxStyle.OkOnly) Else dgvExcelColumn.DataSource = DataViewExcel dgvExcelColumn.AutoResizeColumn(0) dgvExcelColumn.AutoResizeColumn(1) 'Me.dgvExcelColumn.Columns(0).Visible = False End If End Sub Mike this the code tht i use to read t excel into th grid n i am using visual studio 2005 Re: How do remove unwanted coulmns from a data grid? Wendelius22-Oct-08 7:36 Wendelius 22-Oct-08 7:36  Okay, First thing: You are obviously using DataGridView, not DataGrid as your original post implied. For this reason my earlier replies are useless. Second: In DataView, include only those columns you need to show, nothing else. This automatically solves the displaying problem for DataGridView If you must have unnecessary columns in the DataGridView for some reason (there should be none), but you want to hide them, you can refer to those columns with the column name in DataView. For example: Me.dgvExcelColumn.Columns("NotNeededColumnName").Visible = False The need to optimize rises from a bad design. My articles[^] Re: How do remove unwanted coulmns from a data grid? Arun Philip R6-Nov-08 6:32 Arun Philip R 6-Nov-08 6:32  First of all sorry for late reply.....thank you very much one n all for th help provded. i used th following code to remove the extra columns. DataViewXls.Table.Columns.Remove("TABLE_CATALOG") Re: How do remove unwanted coulmns from a data grid? Wendelius6-Nov-08 7:02 Wendelius 6-Nov-08 7:02  You're welcome Glad you got it solved. The need to optimize rises from a bad design. My articles[^] Re: How do remove unwanted coulmns from a data grid? Anoop Brijmohun22-Oct-08 0:20 Anoop Brijmohun 22-Oct-08 0:20  Hi try this . ********************************************** Me.dgView.Columns(0).Visible = False *********************************************** hope this helps Anoop Re: How do remove unwanted coulmns from a data grid? Arun Philip R22-Oct-08 3:28 Arun Philip R 22-Oct-08 3:28  Sorry buddy it doesn't work .......anyways thanks for the help.... Re: How do remove unwanted coulmns from a data grid? Anoop Brijmohun22-Oct-08 3:49 Anoop Brijmohun 22-Oct-08 3:49  hi, could you show some of you code you are using.....? are you using a datagrid or datagridview, vs2003 or vs2005? thanks Re: How do remove unwanted coulmns from a data grid? Arun Philip R22-Oct-08 3:58 Arun Philip R 22-Oct-08 3:58  Private Sub ofdExcelReader_FileOk(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles ofdExcelReader.FileOk Dim DataViewExcel As DataView txtTempXls.Text = ofdExcelReader.FileName DataViewExcel = FillDataSet() If (DataViewExcel.Table.Rows.Count < 1) Then MsgBox("This Sheet Is Empty. Please Select Another Sheet", MsgBoxStyle.OkOnly) Else dgvExcelColumn.DataSource = DataViewExcel dgvExcelColumn.AutoResizeColumn(0) dgvExcelColumn.AutoResizeColumn(1) 'Me.dgvExcelColumn.Columns(0).Visible = False End If End Sub this the code tht i wrote to read the excel into the grid....i am using vs2005 Re: How do remove unwanted coulmns from a data grid? Anoop Brijmohun22-Oct-08 4:31 Anoop Brijmohun 22-Oct-08 4:31  Hi, i am also using vs2005 and vb.net coding. i am using a DataGridView and not a DataGrid!!!! this is what i am doing and it works just fine.... *********************************************** dim dt as new datatable dim data as new clsdata dt = data.GetStockCodes() me.dgView.datasource = dt me.dgview.columns(0).visible = false ' where '0' = column index me.dgview.columns(2).visible = false ' where '2' = column index ************************************************* hope this helps Anoop Brijmohun Re: How do remove unwanted coulmns from a data grid? Arun Philip R22-Oct-08 4:48 Arun Philip R 22-Oct-08 4:48  Anoop i tried your code but dont know y is it not working for me???? i am gettig extra columns like TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME(in this column the values are the sheet names from the excel that i select) and yes its datagridview n not data grid...am sorry.....i want to remove these extra columns..... Re: How do remove unwanted coulmns from a data grid? Anoop Brijmohun22-Oct-08 5:00 Anoop Brijmohun 22-Oct-08 5:00  Hi... mmm.... no idea why not working for you dude, try this..... ******************************* Me.dgView.Columns.Remove("ColumnName") ********************************* ALTERNATIVELY instead of using a dataview ***************************** Dim DataViewExcel As DataView txtTempXls.Text = ofdExcelReader.FileName DataViewExcel = FillDataSet() ***************************** try using a datatable ***************************** Dim DataViewExcel As new DataTable txtTempXls.Text = ofdExcelReader.FileName DataViewExcel = FillDataSet() DataViewExcel.columns.remove("ColumnName") ***************************************** thats all i can think of though.... the above works fine for me..... anyway, hope you come right...i gotta go till tom. Anoop Re: How do remove unwanted coulmns from a data grid? Jon_Boy22-Oct-08 6:29 Jon_Boy 22-Oct-08 6:29  Setting a column's visibility to false should have worked. Might want to re-check your code or when it is being executed. Probably a timing issue. Any suggestions, ideas, or 'constructive criticism' are always welcome. Re: How do remove unwanted coulmns from a data grid? Arun Philip R6-Nov-08 6:36 Arun Philip R 6-Nov-08 6:36  Sorry for the late reply.....thank you very much for th help....i used th following code to remove th extra columns DataViewXls.Table.Columns.Remove("TABLE_CATALOG") Re: How do remove unwanted coulmns from a data grid? Dave Kreskowiak22-Oct-08 5:07 Dave Kreskowiak 22-Oct-08 5:07  The best way to do this is to retrieve only the columns you need from the database. Outside of that, if you have a table that has more columns than you need to display, turn off the option that automatically creates columns in the DataGridView, then create your own DGV columns (which you should already be doing anyway, right?!), and map those columns to the ones in your DataTable. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 Re: How do remove unwanted coulmns from a data grid? Arun Philip R22-Oct-08 5:53 Arun Philip R 22-Oct-08 5:53  Dave am using visual studio 2005 and am not able to find the property AutoGenarateColumns for the datagridview....can you help me on this.....thanks in advance... Re: How do remove unwanted coulmns from a data grid? Dave Kreskowiak22-Oct-08 11:00 Dave Kreskowiak 22-Oct-08 11:00  Did you use the class name instead of the instance name?? This won't work: DataGridView.AutoGenerateColumns This does: myDGV.AutoGenerateColumns = False A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 Re: How do remove unwanted coulmns from a data grid? Arun Philip R6-Nov-08 6:38 Arun Philip R 6-Nov-08 6:38  sorry for th late reply.......thanks for th help....i used th following code to remove th extra columns DataViewXls.Table.Columns.Remove("TABLE_CATALOG") MDI Parent Picturebox control always stays on top of child forms..... NEED HELP!!!! Joey Picerno21-Oct-08 5:37 Joey Picerno 21-Oct-08 5:37  Ok I have a picturebox being centered on my MDI Parent form. WHenever I open a child form of my MDI parent form the picturebox floats in front of the child form. I know that this is how MDI Parent forms are supposed to act. I have found that any control placed on an MDI parent form will always be in front of any child forms. I already have a background image property set but need another image centered in the middle. I have the code for centering but need to figure out how to get this picbox to stay in the background. Since I already have a background image set this is not going to be the solution which seems to be the answer everyone gives for this question as I have found through searching the web. Does anyone know a way to keep a picturebox (or any control for that matter) on an MDI parent form in the background when child forms are opened??? if you can solve this I will be in debt to you forever! PLEASE SOMEBODY HELP ME!!!!! Re: MDI Parent Picturebox control always stays on top of child forms..... NEED HELP!!!! Dave Kreskowiak21-Oct-08 5:58 Dave Kreskowiak 21-Oct-08 5:58  This is the expected behavior. The MDI Parent has a control on it, called the MDIClient, that sits behind all other controls on the form. All MDI Child windows are rendered by the MDIClient control. Any controls you put on the MDI Parent form will sits "in front of" the MDIClient control. It's possible to bring the MDIClient control to the front, but when you do this, it will cover the PictureBox control. You won't be able to see the picture you put in there. The MDIClient control does have a BackgroundImage property, so you can setup a picture on it. You can find out how to get a handle on the MDIClient control here[^]. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Last Visit: 31-Dec-99 18:00     Last Update: 26-May-24 6:38 Refresh ᐊ Prev1...1454145514561457145814591460146114621463 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.