Search results

  1. A

    Best Practices for connecting to two servers

    New question - My.Settings.PrimaryConnectionString I managed to get the combobox populating with different code. So I'm happy with that :) But can you help me out with this: Dim builder As New SqlConnectionStringBuilder(My.Settings.PrimaryConnectionString) I can't figure out what I need to...
  2. A

    Best Practices for connecting to two servers

    Database connection... Thanks for your help! I have set up a similar connection method to the one in your link. I can't seem to get the databases to populate though. "Unable to Connect" pops up. Any thoughts on what I might be doing wrong? Also - the server droplist does populate - but it...
  3. A

    Best Practices for connecting to two servers

    Hello, I'm fairly new to VB.NET. I have created a simple program and tested successfully on my laptop, connecting to a local version of SQL on my laptop. Now I'd like to put the program on another PC, that's connected to another SQL Server. What are the best practices for setting this up? How...
  4. A

    Merge module missing

    Hello, I've just upgraded from .NET 2003 to 2005 (and also reformatted my harddrive). I ran the conversion wizard on a solution that I am working with. I've just tried to deploy it for the 1st time, and I get the error message "Unable to find module file 'C:\Program Files\Common Files\Merge...
  5. A

    .NET 2005 data access problem

    Not sure what is going wrong here. I just upgraded to .NET 2005 and SQL Server Express 2005 from .NET 2003 and MSDE. I've been working on a huge project for ages, which I 'converted' to 2005. Now I can't figure out what's wrong. It's like I have a snapshot of the original database, and that's...
  6. A

    subreports overlapping

    Hello, I'm building a report in Crystal Reports 9, within VB.NET. I have a 'main' form, with many subforms on it. I need the subforms to be able to 'grow' if needed. How do I set them up so they don't overlap when they do grow? Right now, they grow as they should, but if the 1st subreport...
  7. A

    Crystal Reports Subreport issue

    I figured it out... Since no-one ever replied to me, I'll answer this one myself :) I was 'adding a database' from 'more Datasources' then choosing ADO dataset. This seemed obvious to me at the time. Apparently I needed to add a database from the OLE DB (ADO) list instead. *sigh* that took...
  8. A

    Crystal Reports Subreport issue

    Hello, I have created a report using Crystal Reports 9 in VB.NET. I'm having trouble with a subreport. I have created a view in SQL server, and a dataset in VB.NET based on that view. I'm a bit confused by how sub-reports work... I know that with my main report, I pass the VB form that contains...
  9. A

    Parent/Child error on open

    Thanks so much. Works perfect! Amber
  10. A

    Selected Item colour

    Is it possible to change the colour of 'highlight' in a listbox? Instead of the default blue, can I have the selectedItem highlighted in a different colour? Thanks! Amber
  11. A

    Parent/Child error on open

    Hello, I have a parent form, with a menu item used to enter the child form. If I open the child form, then close it, and try to reopen it from the parent, I get the error message: "An unhandled exception of type 'System.ObjectDisposedException' occurred in Additional...
  12. A

    MS Application Blocks question

    MS App block - filling more than one table in a dataset Well that is how I was doing it. But only my first table was ever populating. The 2nd table always remained empty. I'm not sure where the problem lies, but I thought maybe it was when I called the SQLHelper class. Amber
  13. A

    MS Application Blocks question

    MS App block - filling more than one table in a dataset Yes, but if I specify a table eg: SqlHelper.FillDataset(SqlDbManager.GetConnectionString, CommandType.StoredProcedure, "StoredProcedure1", ds, tables(0), sqlParameter1) I get an error. ("Overload resolution failed....") That is my...
  14. A

    MS Application Blocks question

    I'm trying to populate a dataset that contains 2 tables, using MS Applications Blocks. In my searches on the internet, it seems that populating 2 tables in a dataset is as simple as: dataAdapter1.fill(dataset1("table1") dataAdapter1.newSelectCommandHere...
  15. A

    values in datagrids

    Hello, How can I refer to a specific value in a datagrid? Can I set a variable to equal a value in a datagrid? TIA! amber
  16. A

    Crystal Reports - data problem

    Hello, I need some help with a report in I had a report, based on a dataset, that worked great. I had to add a 'sub-report' to this same report. So in my .xsd file (my dataset) I added another (linked) table. I created my subform in Crystal reports, changed my 'database location' and it...
  17. A

    Value changes in a datagrid

    Yes! That's exactly what I was trying to do. Thanks! amber
  18. A

    Value changes in a datagrid

    Hello, How can I trigger an event, when a value (cell) in my datagrid changes? The closes I've found is datagrid_currentCellChanged - but this eventis triggered even if the data within a cell hasn't changed. TIA, amber
  19. A

    combobox problem

    Hello, I'm using the following code to work with a combobox: combobox1.Datasource = employeeDataset.Table(0) combobox1.ValueMember = "STR_INITIALS" combobox1.DisplayMember = "BOTH_NAMES" combobox1.DataBindings.Add("SelectedValue", mainDataset.Tables("TDT_MAIN"), "STR_PEER_REVIEW") The...
Top Bottom