Hide Columns In Excel Based On A Parameter?
Jun 2, 2011What is wrong with this, it throws a debug error.[code]...
View 3 Replies
ADVERTISEMENT
Ranking Excel Columns Based On A Sort?
Mar 23, 2012I fought through a good amount of this and have gotten to the point where I can sort my arrays. What I need to do now is take the following code and sort the elements in descending order instead of ascending order. I don't know how to do that with the two arguments in the code:
Dim Cols(3) As Int16
Cols(0) = ColumnNumber + 1
Cols(1) = ColumnNumber + 2
Cols(2) = ColumnNumber + 3
[Code].....
Way To Create Empty Data Table / Update Its Contents Based On Columns Not Add Data Based On Addition Of New Rows
Apr 6, 2011I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesHide Columns Of Listview?
Jul 17, 2009I have seven columns in a table Customer (custId, Date, AccountCode, Description, Quantity, Price, Amount)Also i have seven textboxes on the form from where data is transferred to the Listview. Listview has all seven columns from where data is to be transferred to the seven columns of Table Customer.I want that data should be transferred to all the seven columns of LIstview but Listview should display only last four columns and hide first three columns to display. In otherwords user may be able to see only the last four columns in Listview.
View 2 RepliesVS 2010 Hide Columns In One Code?
Nov 21, 2011i use this code to hide a column
"DataGridView1.Columns("HulpstofId").Visible = False"
[code]....
Hide A Button Based On OS?
Dec 17, 2011Is there a way to have a button hide when a form loads if the user is running windows xp or earlier?
View 9 RepliesShow And Hide Data Based Off Of A Value In A Column?
Feb 16, 2009I would like to know how I can show and hide data based off of a value in a column.
Example. My table has 3 columns Name, Password, and Tel#
:Pseudo Code
if Name or Column(0).Row(0) = "Shawn" then
. Column(1).Row(0).Forecolor = System.Highlight
. Column(2).Row(0).Forecolor = System.Highlight
[Code].....
I placed my code in the rowprepaint event of the datagridview and on start up I get the results I am looking for. However, if the user selects the row or a cell in the row then the value will display.
I don't want the value to show even if the row is selected.
Get Value Of BLOB Field And Show / Hide A Label Based On It?
Nov 2, 2011I'm calling some data from my Oracle table and I have a field which is called 'image1' which is a BLOB field.
Sometimes an image is input into the field and others it's not. I need a way to read the BLOB field to see if its a blank and then show/hide my label based on its contents.[code]...
VS 2008 Filter/Hide The Record Set Based On Query?
Feb 28, 2011I have a Query to Display values in grid view, now i wanted impose certain condition in query to filter the values.I have FABDue(date column) and FABComp(date column)columns in a table.I need to check following two conditions in query
1.Records which does not contain FABdue date in FABDue column, then those records should not be listed in Grid view.
2.Rcords which are having FabComp(column) date then those records should not be listed in grid view
[Code]...
Progress Bar For VSTO Based Excel Template In Excel 2007?
Feb 1, 2010I would like have a progress bar like Outlook 2007. when you click on a link in a message. you can see a progress bar between the ribbon menu and reading pane in outlook 2007.
Is it possible to have the same progress in Excel 2007?
Alert Triggered Based On Parameter ?
Oct 15, 2011My problem is, I have set the parameter to be 150 in the database. and the alert triggered should refer to the parameter value. if the calculation result exceeds the parameter value, it will turn the box to red colour. however, i notice that it only compares the first three number. for example, if the calculation result is 1778.99 it will turn the box red because its first three digit is more than 150. but if the calculation result is 10234.90, it does not trigger the alert. i assume it only takes the first three digit.
Here is the code for this part;
Dim total1 As Label = CType(e.Item.FindControl("total1"), Label)
total1.Text = e.Item.DataItem("inventories").ToString * 365 / e.Item.DataItem("operating_cost").ToString
[CODE]...
C# - Computed Column Based On Other Columns?
Jul 25, 2011I have a Dataset with a Bunch of Columns used in a Report (DevExpress XtraReports) (DataSet being the DataSource). The Dataset has many columns, and i need to read a column (based on the row type), and decide which column value to read for the row, and apply formatting based on the row type.
[Code]...
Is there a suggested way to handle this in the Report or at DataSet Level (excepting the formatting part)?
Crystal Reports - Show / Hide A Sub Report Based On Condition
Jun 2, 2009I've a VB.net 2005 desktop application, and i'm using crystal reports. In one report i've abt 6-7 sub reports. is it possible to show/hide a sub report based on some condition. i'm new to crystal reports , please suggest what is the best possible way to achieve this.
View 1 RepliesExcel - Get Username From AD Based On Display Name In Excel Sheet
May 20, 2011So I've got this Excel sheet of employees which have all the information about them. I'm trying to import this info into AD, but in order to do that I need to get the username for these users as well. And I would like vba code or vb.net code that basically takes the value of every row in column D and looks for it in AD and returns the username and adds it to column A. Would something like this be possible?
View 1 RepliesC# - Match SQL Columns Based On User Input?
Jan 24, 2011What i am trying to achieve is that there are 7 columns in my db table. one is primary key and rest 6 are integer columns. Now my application will allow user to input 6 values. I want to compare 6 values entered by user to those 6 integer columns and if in any row 3 or more columns match user's input Primary key of that table is returned..I have tried using queries, cursor, nested loops and i am still unable to achieve my results..
UPDATED :DB Table Structure.. I am inputting 2,3,7,11,45,65. Number of returned rows should be 5. eg..
UID A1 A2 A3 A4 A5 A6
-----------------------
1 2 3 4 5 6 7
2 2 3 4 55 56 57
3 65 11 45 66 67 68
[code]....
IDs returned should be 1,3,4,9,10
Calculating Subtotals Based On Values In Two Columns
Jun 1, 2010I have a monthly forecast showing expense accounts by cost centre so columns headings look like:
Cost Centre, Account Number, Jan, Feb, Mar etc
Using VBA code to automate the process, I need to calculate the total for each month of each account number where the 2 left characters of the cost centre are the same. I have a formula which will calculate this (for one cost centre grouping/account) which looks like this:
=SUMPRODUCT((LEFT('Sheet2'!A6:A5136,2)="BE")*('Sheet2'!C6:C5136=AccountNumber)*('Sheet2'!D6:D5136))
I am not sure whether there is a more efficient way than using a formula like that (at the moment this would be used for 12 months on about 6 cost centre groupings with about 500 accounts each - though this would vary). Its not massive, but could be slow to calculate. I don't think the subtotals command is powerful enough, and I haven't used arrays for a long time (especially for what would appear to need a dynamic, mulch-dimensional array).
Highlight DataGridView Rows Based On A Columns Value?
Jan 27, 2012I want to change the row color of every row in my DataGridView where a particular column value = "RBF3". I am currently using the DataBindingComplete event which seems to work fine, but it fires every time I change a cells value. I'd like for this bit of code to only fire when the datagridview is first displayed, sorted, or filtered. Is this possible?
[Code]...
Retrieve Data From Sql Server Based On Two Columns?
Jun 10, 2011Am trying to retrieve data from sql server based on two columns. Its a web application being developed using VS2010 (vb.net) but i keep getting the error: incorrect syntax near '='
Here's my code below:
Sub GetBasicMidwives()
' Set the SelectCommand properties...
With objDataAdapter
.SelectCommand = New SqlCommand()
[code].....
.net - Clean Way To Display/hide A Bunch Of Buttons Based On A ComboBox Selection?
Apr 14, 2010I'm writing a standalone application in VB.NET using Visual Studio 2005. I want to display/hide a bunch of Buttons based on the selected value of a ComboBox. Each selection would have a different set of Buttons to display, and I'd like to have them arranged in a nice grid.
Driving a TabControl with the ComboBox value would be the kind of behavior I want, but I don't want it to look like a TabControl to the user because it might be confusing.Is there a way to do this?
Basically, I'd like Selection1 of the ComboBox to show Buttons 1-4, Selection2 to show Buttons 5-11, Selection3 to show (maybe) Buttons 1, 3, 5, 6, and 8, etc., have them arranged nicely, and have the GUI show only the ComboBox and the buttons.
Adding/removing Datagridview Columns Based On A Combobox?
Oct 26, 2011The user picks x amount of scenarios from the combobox, and x amount of columns appear in the datagridview. If the user changes the number of columns from x amount to y amount, the columns should be added/removed respectively but currently when y amount is chosen x amount of columns are in the datagridview.
I'm not sure how to do this, I've tried using an IF statement under the .SelectedIndexChanged event but the code adds columns until it reaches as high as it can go, then pulls an error saying too many columns.
Auto-resize Columns Based On Char Count
May 11, 2009I am trying to figure the best way to programmatically re-size table column headers in ReportViewer.Basically, my current resolution is the following: ColumnWidth = Header Caption_CharacterCount * 0.32...Where 0.32 is an estimated width of a typical character using my current font size.The issue is that the width leaves a lot of whitespace for longer captions.The more characters a caption has, the more whitespace I end up with.The issue with estimating this way is that not all characters are the same width. A good example would the the "I" character, which takes up less screen width than the rest of the alphabet.[code]
View 1 RepliesChange DataGridView Cell Color Based On Other Columns?
Apr 25, 2007I have a DataGridView that has been dragged over from the DataSource Tab. All works good.I need to have the background color of some of the cells changed based on other columns in that same row. Such as, have the background color of a cell Red if the Status column (not shown) relates to 90 days overdue. The next row may be different.
View 6 RepliesDataGridView Cell Formatting - Red Columns Based On Values
Jan 12, 2009I want to make a certain column of my datagridview red based on values from 2 other columns. I have a "HI" column, a "LOW" column and a "Result" Column which are all strings. Now I want to make the result column red if it's values is less than the "LOW" columns value or if it's value is greater than the "HI" columns value. I tried the following code but something is wrong because cells that shouldn't be red are red:
Private Sub dgvTests_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgvTests.CellFormatting
If dgvTests.Columns(e.ColumnIndex).Name.Equals("Result") Then
Dim RowValue As DataRow = TestTable.Rows(dgvTests.CurrentRow.Index)
[Code] .....
Delete Duplicate Records Based On 3 Identical Columns?
Aug 3, 2011I need to duplicate records with duplicate records, but only if the first three columns out of 5 columns are duplicates. I am using MS ACCESS with VB.NET. How do I loop through the records and delete records with three duplicate columns
View 1 RepliesVS 2010 Sort List Of Objects, Based On Object Parameter
Oct 10, 2011I made an object that has several properties one of which is an integer.
I put all the objects into a list, and I wish to sort that list by the integer property, with the object with the highest property at item 0, with the object with the lowest property at the highest item # ( count -1).
I made the list of that item, as in
Dim GameList as new list(of clsGame)
And I wish to do something like the following
GameList.Score.Sort()
What is the syntax to do that? I looked up the MSDN and didn't really understand what it was trying to say
Add Columns Dynamically To Rdlc Report Using Dataset In Windows Based?
Nov 15, 2010Q:how can i add columns dynamically to rdlc report from dataset in windows based.
View 1 RepliesColumns Appear In Alphabetical Order In Data Source Based On EF4 Model?
Jul 13, 2010I use Visual Studio 2010 and SQL Server 2008 R2. I have created an Entity Model in a class library which I have referenced in a VB Winforms project. I created a data source in the project based on the entity model in the dll. However, all columns in the data source are listed in alphabetical order instead of the native order from the SQL Server database. I cannot locate the cause of this as much as I try.
This might not seem a huge problem, but it is costing me valuable time in rearranging controls dragged to forms and reindexing their tabstop indexes.
Sql - Asp.Net VB Or C# How To Combine Lines & Columns Based On Unique Primary Field
Mar 3, 2010I have been working on a web based report from an existing client/server apps mssql database. I have a working query, that pulls this information together from many tables, and can provide the query and a result set if necessary.
The results currently are similar to this.
ID | Name1 | Date1 | Veh | PO | Stops
_________________________________________
1 | Bob 1 | 12/1 | Car | 1234 | 4
2 | Sam | 12/3 | Car2 | 2245 | 3
2 | Joe | 12/4 | Van1 | 5568 | 2
[Code]....
Asp.net - Change The Font Color Gridview Row Based On A Columns Value - Can't Index Gridviewrow?
Feb 1, 2011i am getting a syntax error at drr(5) which 5 is the column i want to base the color change on. this method works when i am using a dataset
Dim Land As String = "Land"
Dim Air As String = "Air"
Dim Cruise As String = "Cruise"
[Code].....
Hide Command Bars In Excel 2007?
Dec 29, 2009Hide Command Bars in Excel 2007
View 1 Replies