Is there a way to create a file with different record lengths in VB .NET? I need to create a file that has a header record with a length of 88, any number of detail records with a length of 396 each, and a trailer record with a length of 91. There should not be any spaces after the final...
I'm trying to add a border to the bottom of each row group, but I can't figure out how. My row group may have up to three lines of data, but I only want the border on the bottom of the last line of the group. When I select the matrix row and add a border, it applies it to every row. Is there...
I have a report that contains two columns of dates (MM/dd/yyyy format). When the report is exported to Excel, the dates are formatted as text instead of dates, so they do not sort as expected. In Excel, the dates do not change to a date format until I click on or edit the cell. Is there a way...
I'm getting an error ("Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index") when running a server report in the ReportViewer control in VB .NET 2005. This error does not occur every time the report is executed or refreshed. The report...
I have a matrix in a SQL Server Reporting Services 2000 report, and I would like the total on the left of the data instead of the right. Is there a way to do this?
Thanks,
Andrea
I am attempting to display a confirmation popup when the selected value of a radiobuttonlist is changed to a certain value, and only perform some statements if Ok is pressed. I get the popup to display, but the program processes the SelectedIndexChanged whether I press Ok or Cancel.
When I...
I have several text boxes in a list. This is basically the layout of the list.
B/L# Order# PO#
Instructions:
notes
When I conditionally hide the "Instructions" text box, based on the value of a field in the dataset, the "B/L#" and "Order#" text boxes remain in the same position, but the...
I am getting a RowNotInTableException with this error message when I attempt to delete a row from my database using a SqlDataAdapter.
My dataset is bound to a grid, and I delete the row by deleting a row on the grid.
Here is my code to build the DeleteCommand.
cmdComponents = New SqlCommand...
I am using a For Loop to set one column in every row of my DataTable to a certain value. It is working for all rows except the first one. Here is my code.
For i = 0 To dsWorkOrderFlex.Tables("WorkOrder").Rows.Count - 1
dsWorkOrderFlex.Tables("WorkOrder").Rows(i)("kit_no") = strKitNo
Next...
I have an ASP .NET web application that is used to scan parts for orders. I have tested with both a Windows XP Professional workstation using IE and a Pocket PC using Pocket IE. Basically, the process is to enter 3 text fields, either by scanning or typing, then press the "Add" button. The added...
I am making changes to an ASP .NET app that I did not write, and I noticed that it has two pages that are virtually identical. I have compared the vb files behind them, and there are a few very minor differences that don't affect the logic of the program. The page layouts of both pages are...
Is there a way to get the number of records affected for each statement in a stored procedure, not the total number of records affected by the stored procedure that I would get using RecordsAffected? For example, I have a stored procedure that performs a delete and then an insert, and I need...
I am having a problem with a databound textbox. Based on a button click, I am setting the value in the datarowview (bindingmanagerbase.current) to a date 6 months in the future. After bindingmanagerbase.endcurrentedit, the dataset is being updated correctly, but the date is not displayed in...
I have a form with textboxes bound to a dataset table. I update the textbox values with another dataset table to fill in default values. The problem is that the values are not being displayed in the textboxes. However, the value is in the dataset table that is bound to the textboxes...
If I change the value in a bound textbox on an MDI child form, then click the save button on the toolbar without leaving the textbox, the value in the textbox reverts to the old one. I have stepped through the code in debug, and the program is changing the new text value back to the old one at...
I have a form with several TabPages that need to display different order line information from the same database table. For example, the first TabPage has order line number (read-only), part number (editable), price (editable), and qty (editable). The second TabPage has order line number...
I am attempting to use some code that I found in this forum to update the DataGrid's DataSource when a cell changes, but the row does not change.
Here is the code.
Private Sub TextBoxValidating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs)
Dim tbc As...
I am attempting to use a user-defined function in the where clause of a query, but I am having a problem. With just one table, the query runs quickly. However, if I join two tables, the query runs until I cancel it or it times out. If I use the same function in the Select clause instead of...
If an MDI child form is closed, is it removed from the parent's MDIChildren? Or, does something else cause the form to be removed from MDIChildren. For most of the forms in my project, closing the form seems to remove it from MDIChildren, but I have one form that is still in MDIChildren after...
I am executing a stored procedure (to calculate a price) within a stored procedure. The "price" stored procedure has an output parameter to return the price to the main stored procedure. However, the main stored procedure is also outputting the results of the "price" stored procedure as "No...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.