User Profile

Collapse

Profile Sidebar

Collapse
oceantrain
oceantrain
Last Activity: Jul 9 '10, 03:00 PM
Joined: Feb 12 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • oceantrain
    started a topic Windows Application Deployment help

    Windows Application Deployment help

    I am trying to deploy a simple windows forms application using the standard Publish option in Visual Studio. I am using a SQL server compact file (.sdf) as my database. When I deploy the app and install it on a test computer, I get this error:

    The Path is not valid. Please check the directory for the database.

    and then it shows me the connection string I have configured in the app config file. But according to MSDN I...
    See more | Go to post

  • oceantrain
    replied to SQL function help
    Thanks for responding Christopher. I was under the impression that I created the function/method in A SQL statement and was just calling it with :

    vendorArchiveTa bleAdapter.Perf ormArchive();

    The arguments in the SQL statement are (@p1, @p2, @p3 ect.) I did try to add those arguments in code but still no help. Do I need to define the method like any other as a SQL staement? Confused.
    See more | Go to post

    Leave a comment:


  • oceantrain
    started a topic SQL function help

    SQL function help

    I am trying to archive a datagrid into a datatable so I can find it in the table by the archive date. I am using an INSERT SQL statement as follows:

    Code:
    INSERT INTO [VendorArchive] ([Booth], [Deposit], [Rent], [Electric], [Security], [AmountPaid], [DatePaid], [PeriodPaid], [TotalDue], [Notes], [ArchiveDate], [BalanceDue], GETDATE());
    
    SELECT Booth, Deposit, Rent, Electric, Security AmountPaid, DatePaid, PeriodPaid, TotalDue,
    ...
    See more | Go to post

  • How to save an expression datacolumn to the database?

    I have a datagridview on a form with multiple columns. Three of the columns are expression columns. One column is subtracted from the second and the result is displayed in the third. Everything works great but when I hit the save button and save to the database, all the columns are saved to the database except the three columns used in the expression. They are NOT saved to the database. When I run the app in debug mode again the data in those 3 columns...
    See more | Go to post

  • I set the expression property in the designer. I don't see the code for it in my solution. The best I can do is describe it in the previous post. Apologies.
    See more | Go to post

    Leave a comment:


  • oceantrain
    started a topic Datagridview/Column/Expression property help

    Datagridview/Column/Expression property help

    I have a datagridview with columns: [Rent] [Electric] [deposit] [amount paid]. I also have 2 other columns called [total due] and [balance due] (in that order across the grid).

    In the properties panel, in the expression property of the [amount paid] column, I entered this expression : [Rent]+[Electric]+[deposit]. This calculates these 3 columns and displays the sum in [amount paid] at runtime. It performs no problem. But when I hit...
    See more | Go to post

  • Steven,
    Thanks for the reply. I found this on MSDN
    http://msdn.microsoft.com/en-us/libr...e.compute.aspx

    But I have not yet tried to implement it. This task of calculating 2 columns and displaying the result in a 3rd column seems like it would be something that has been done many times before. But I just can't find the code to implement it....
    See more | Go to post

    Leave a comment:


  • Steven,
    Thanks for the reply. I found this on MSDN
    http://msdn.microsoft.com/en-us/libr...e.compute.aspx

    But I have not yet tried to implement it. This task of calculating 2 columns and displaying the result in a 3rd column seems like it would be something that has been done many times before. But I just can't find the code to implement it....
    See more | Go to post

    Leave a comment:


  • oceantrain
    started a topic Help doing simple math in a datagridview

    Help doing simple math in a datagridview

    I am new to C#. I have a datagridview with 9 columns. I am simply trying take the value in column 5 and subtract it from column 6. Then display the result in column 9. It seems simple enough.I know it's done in excel all the time. But I just cannot figure this out. Do I need to create a new class with a method called calculate columns? or does the datagridview class have something already built in that can handle this?
    See more | Go to post

  • oceantrain
    replied to datagridview datetimepicker C# help
    re:

    I just want to use the datetime picker as a way to move forward to a new grid with a fresh set of 10 columns in it. or the user could move backwards to review previous grids with the same 10 columns. much like an outlook scheduler. please see image to get a visual idea....
    See more | Go to post

    Leave a comment:


  • oceantrain
    started a topic datagridview datetimepicker C# help

    datagridview datetimepicker C# help

    I have a datagridview with 10 columns. Every month the user will update new info in the grid. I would like to have a datetimepicker next to the binding navigator. The purpose of the datetimepicker is to scroll forward or backward month by month. If scrolling forward the datagridview creates a new datagridview with the same 10 columns populated with certain data. Then the user can just add the necessary data for the new month. if the user scrolls...
    See more | Go to post
No activity results to display
Show More
Working...