Search results for query: *

  1. J

    Refuses to load data from sql database

    I have a windows form application where I use an internal database mdf-file. I have then altered the runtimeConnectionstring to be able to choose what database to load the data from. I have made a copy of the local database into the sql-server and checked my connection and it works. Even if I...
  2. J

    problems with getting data from database to report

    I have a REPORT WITH 10 SUBREPORTS, I have 2 Parameters in the main report and links the subreports to these parameters. My code looks like this: Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Configuration...
  3. J

    issue with Crystal Report

    I solved this by adding a parameter to the main report and link the sub-reports to this parameter. The next issue is that I need to be able to connect to a remote database as well to make a report or just to be able to connect to a different database. I have searched the internet for help on...
  4. J

    issue with Crystal Report

    I have made a crystal report with subreports, In my subreports I have added commands like: SELECT * FROM Orders where orderID = {?orderID} When I run the report in viewer the report prompts for the orderID with a dialogbox. But I have several subreports that requires the same orderID it prompt...
  5. J

    troubles with subreport in Crystal report

    I have made a cr with a few sections with subreports and I get the data from an SQL database with manually made commands in the report wizard. In this report I get dialog-boxes up to be able to enter variables to the commands at run-time. And if I load the report with this code it works great...
  6. J

    Issue with crystal report

    I think I soved this on by adding sections and put one subreport in each section.. But I got another problem as well. When I create the report I use the wizard and select the sql database I have on my machine, but if I have 2 identical databases on 2 machines and I want to be able to change...
  7. J

    Issue with crystal report

    I have made a crystal report, to be able to display data from several tables in the same report I have made a few subreports. But when I display the report some of the subreports grow beyond the next report, why doesn't the next report moove further down and start after the first subreport is...
  8. J

    Need help with print

    I use VS2008 where I have a program where I have about 20 tabpages with datagridviews and textboxes. But when it comes to printing my form my programming skills is not good enough. Here is how one of my forms looks like: I want to print out the data I have in my datagridviews with the...
  9. J

    How to lock a textbox to a cell?

    what I think is strange is that I have bound the values for variable like this: Total_fortj2 = Prosess_140DataGridView.Item(42, 0).Value Then I thought maybe I can bind the textbox.text like this as well. But I do not know if anyone has tried it like that before?
  10. J

    How to lock a textbox to a cell?

    Hi, I have a windowsform in visual studio 2008, I connect to a ms sql-server On my form I have a datagridview who I use to enter data etc and save them to the database. I then have textboxes who shows the sum of the columns etc in the table abd save that value back to the database. but for...
  11. J

    Form refuses to close

    I have a method where I am making a trial period. When the date has exceded its trialperiod the program will not close. The code looks like this: Public Sub DemoRestrict() If My.Settings.dteStartDate = Nothing Then My.Settings.dteStartDate = Now End If If...
  12. J

    Publishing question

    If I choose the option, to download the packages from the same location as my application, under Prerequisites will VS include these packages when I publish my application?
  13. J

    Publishing question

    I have a windows application Is it possible to publish this in a way that it does not have to be installed, Like if I just double-click the .exe file then the form appears and run instantly?
  14. J

    Problem updating to a related table in the database

    I have an Access relation database with a few tables. Customer, order, process1, process11, process130 etc. Customer Primary key is CID Order tabel har Primary Key OrderID and Forreign Key CID All the Processtables has ID as PrimaryKey and OrderID as Forreign Keys. The relations are set to 1...
  15. J

    Database does not appear after installation

    I have made an application in vb.net, this application uses an access database. When I publish the application I have included database. But when I install the application on a computer it does not install the database, So when I start the application it finds no data becausen the database is...
  16. J

    Save method

    -how about this? I am trying to make a method where I can choose which prosesses to save, Private Sub Save(ByVal prosess As String) For Each row As DataRow In Me.Kalkyle1DataSet.Tables("prosess") If row.RowState = DataRowState.Added Or DataRowState.Modified Or...
  17. J

    Save method

    Since No one have any idea on this one I will try another angle. Is there a way to determine if the datagridview har been altered? The dataset.haschanges will not work since it includes the whole dataset. I need to be able to check if one of the tables has been changed and not the whole database.
  18. J

    Save method

    I use the binding navigatorsaveitem to save my data back to the database, but the way I am doing it today seems to take an awful lot of time. Ex: Private sub .....SaveItem_Click(Etc Etc Etc)Handles ....Click Me.Validate() Me.Process1BindingSource.EndEdit() Me.Process2BindingSource.EndEdit()...
  19. J

    change error message visual studio

    If I forget to enter a value in a cell in my gridview a loooong error who says thar that the indata format is wrong. anyone who know where in visual studio I can make this error a bit more understandable for others?
  20. J

    Problems copy from table and adding to table

    I try to copy data from rows in my db and then add them with another ID. but somehow I think I have made a mess out of it. Public Sub Ordreupdate() Dim dtbl As New DataTable Dim dt As New DataTable dtbl = Kalkyle1DataSet.Tables("Ordre") dt = dtbl.Clone...
Back
Top