Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: andrea96
  • Content: Threads
  • Order by date
  1. andrea96

    Creating File with Different Record Lengths

    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...
  2. andrea96

    Border on Matrix Row Group

    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...
  3. andrea96

    Dates Formatted as Text When Exported to Excel

    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...
  4. andrea96

    Error in ReportViewer with Available Parameter Values From Query

    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...
  5. andrea96

    Matrix With Totals on the Left

    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
  6. andrea96

    Confirmation Popup on RadioButtonList

    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...
  7. andrea96

    Text Boxes Overlapping

    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...
  8. andrea96

    RowNotInTableException on Delete Using SqlDataAdapter

    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...
  9. andrea96

    Cannot Set Value on First Row of DataTable

    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...
  10. andrea96

    Application Hangs Up on Pocket PC Only

    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...
  11. andrea96

    Identical Pages

    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...
  12. andrea96

    Records Affected for Stored Procedure

    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...
  13. andrea96

    Databound Textbox not Displaying Updated Info

    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...
  14. andrea96

    Value Set by Program is not Displayed in Bound TextBox

    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...
  15. andrea96

    Bound TextBox Value Not Saved

    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...
  16. andrea96

    Is it Possible to Bind One DataSet Table to Multiple DataGrids?

    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...
  17. andrea96

    TextBox.Modified in DataGrid

    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...
  18. andrea96

    User-Defined Function in Where Clause

    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...
  19. andrea96

    Form.Close and MDIChildren

    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...
  20. andrea96

    Executing a Stored Procedure within a Stored Procedure

    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...

Part and Inventory Search

Back
Top