dcsimg

Search:

Type: Posts; User: Rocky48

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Publishing a database project from Visual Studio 2017

    I have been having a look around the project properties and under Compile Build Events, there is Pre - Build and Post - Build window, where it looks like you can put command lines.
    Is this how you...
  2. Re: Publishing a database project from Visual Studio 2017

    Have not had time to check yet.
    I realised that if I reinstalled from SQL scripts,the verses will not be formatted (I had to edit the table to put the line feeds in the correct place), otherwise...
  3. Re: Publishing a database project from Visual Studio 2017

    I think we are overlapping our posts. Found that setting, but still got problems(see below).

    Tried publishing project after setting all the datasets to copy always.
    Could not see any of the files...
  4. Re: Publishing a database project from Visual Studio 2017

    TechGnome:

    1) Copy to Output - Where is it? Seeing as I have never come across this setting before, I haven't a clue where to set it?
    2) SQL scripts - I used SSMS to generate a script using...
  5. Re: Publishing a database project from Visual Studio 2017

    TechGnome:


    I obviously am taking the wrong path trying to use LocalDB, so I am going to return to use SQLExpress as you mentioned in #26.
    If that is the case what do you specify as the server,...
  6. Re: Publishing a database project from Visual Studio 2017

    Sorry its my lack of overall knowledge. I've always associated mdf with Access files. I thought that everyone used SQL for VS projects. I'm aware that they can be imported into VS, as I have looked...
  7. Re: Publishing a database project from Visual Studio 2017

    I don't know where anyone got the idea that the database was a mdf (Access) file. The files were setup and updated in SQL.
    The database is called Verses_Find and the tables dbo.tablename.
    Going...
  8. Re: Publishing a database project from Visual Studio 2017

    Thanks John!
    Got LocalDB installed and was able to import database from the original one, but don't understand how the database is installed perminantly?
    Restarted PC and started LocalDB,but...
  9. Re: Publishing a database project from Visual Studio 2017

    Am I missing something as several websites talk about “Advanced Publish Setting” window.
    According to the website I am looking at it should be shown after clicking the Publish item on the menu, see...
  10. Re: Publishing a database project from Visual Studio 2017

    Thanks jdc2000!
    I notice that they are for SQL Server 2005 & 2008.
    Will I need to change much as I am going to use SQL Server 2012, as that is the only one available in Prerequisites.
    The project...
  11. Re: Publishing a database project from Visual Studio 2017

    Duplicate previous post
  12. Re: Publishing a database project from Visual Studio 2017

    Could you explain a bit more?
    How do you create this file, in vs or a a program like Activestate Komodo 7.
    If this config file is going to multiple users, how do you write the connection string to...
  13. Re: Publishing a database project from Visual Studio 2017

    I'm sorry, but I get frustrated when I only get half an answer. I am not that stupid that I would not have set the prerequisites.
    The PC that I am installing a copy on has installed SQL 2012 local...
  14. Re: Publishing a database project from Visual Studio 2017

    If you'd asked I would have told you that I I have set the Prerequisites:
    170113
    To answer #10:
    170115
  15. Re: Publishing a database project from Visual Studio 2017

    I do get annoyed when I certain person tells me how stupid I am and that I must search the galaxy of commands on VS.
    Just a pointer as to where one should look would be useful?
    As you can see from...
  16. Re: Publishing a database project from Visual Studio 2017

    I have been doing some research and most of the sites talk about right clicking on your project in Solution Explorer and selecting Publish from the Pop-Up menu, then Advance Publish Settings, check...
  17. Re: Publishing a database project from Visual Studio 2017

    I asume you mean the recipient computer - the answer is no!
    Should this have been installed by the setup program when I installed my published project?
    Is there something I missed setting in the...
  18. Re: Publishing a database project from Visual Studio 2017

    Here is the datasource string from Visual Studio. I have X out the serial number for security reasons.
    Data Source=DESKTOP-XXXXXXX\SQLEXPRESS;Initial Catalog=Verses_Find;Integrated Security=True
    ...
  19. Re: Publishing a database project from Visual Studio 2017

    Here is the datasource string from Visual Studio. I have X out the serial number for security reasons.
    Data Source=DESKTOP-XXXXXXX\SQLEXPRESS;Initial Catalog=Verses_Find;Integrated Security=True
    ...
  20. Publishing a database project from Visual Studio 2017

    I am trying to understand how the Publisher works, so that I can understand whats going wrong.

    The project published OK and I installed on another PC, it installed the SQL server and my project...
  21. Re: Program crashes because writing to adobe Acrobat is open!

    Thanks Topshot!
    The solution was easy, just used 'seed = Int((100000 * Rnd()) + 1)', to produce a random number and changed the filename variable to: 'Dim filename As String = "Verse" & seed &...
  22. Re: Program crashes because writing to adobe Acrobat is open!

    topshot:
    Yeah I knew that, but I am trying to get around that problem!
    Thought about using a FOR / NEXT loop, but don't know how to create a loop that has to be external to that sub and only steps...
  23. Re: Program crashes because writing to adobe Acrobat is open!

    I tried your suggestion, but get an exeption error:


    Hope I have coded it correctly, so here is the sub:

    Private Sub printIt(row As DataRow)
    Dim ID As Double = CDbl(row("CID"))
    ...
  24. [RESOLVED] Program crashes because writing to adobe Acrobat is open!

    I am using PDFSharp for my project and when the PDF file is written and you try to create another PDF file the program freezes and won't work unless you stop debugging.

    Here is the exception:
    ...
  25. Re: System.ArgumentException: 'Cannot set column 'ort'. The value violates the MaxLen

    Thank you Iferred
    You explained it so my febble mind could understand.
    At 71 I hope I've got a few more years of programming.
    The program is now working correctly.
  26. Re: System.ArgumentException: 'Cannot set column 'ort'. The value violates the MaxLen

    Regarding the last comment, there is nothing wrong there!
    If you think of a greeting card insert, lets say A5 size and is a portrait type, the insert inside would have to be printed as Landscape.
    ...
  27. Re: System.ArgumentException: 'Cannot set column 'ort'. The value violates the MaxLen

    Sorry I am not that experienced in debugging, but have just put a break point at the sub to select the CSize (Card Size).
    I did this firstly, with a selection that I knew would work and observed...
  28. Re: System.ArgumentException: 'Cannot set column 'ort'. The value violates the MaxLen

    Sorry I am not that experienced in debugging, but have just put a break point at the sub to select the CSize (Card Size).
    I did this firstly, with a selection that I knew would work and observed...
  29. Re: System.ArgumentException: 'Cannot set column 'ort'. The value violates the MaxLen

    Regarding 'Shaggy Hikers' comment: 'ort' was my variable name that represented Orientation. As I stated before in the database it is varchar(1). this column has either P or L in the database.
    I...
  30. System.ArgumentException: 'Cannot set column 'ort'. The value violates the MaxLength

    I have an exception that dosen't make ant sense to me.
    I have a column in my database that has 'P' for Portrait and 'L' for Landscape, which in the database is a varchar(1).
    Here is the full output...
  31. Replies
    3
    Views
    223

    Check combobox value is selected

    I am trying to check that a selection has been made in a form.

    I have tried the following:

    Private Sub cboCSize_SelectedIndexChanged(sender As Object, e As EventArgs) Handles...
  32. Re: PDFSharp - Using a variable instead of the color name?

    I now have a working code for printing using PDFSharp:

    Private Sub btnPrint_Click(sender As Object, e As EventArgs) Handles btnPrint.Click

    Using connection As New...
  33. Re: PDFSharp - Using a variable instead of the color name?

    Found why I got the cast error.
    I had added the colors using the combobox control as well as programmatically.
    However, instead of the color being displayed it just says: 'PDFSharp.Drawing.XColor'...
  34. Re: PDFSharp - Using a variable instead of the color name?

    Passel
    I have just tried the code that you wrote in #6, but I get a cast error:

    It errored on this line:

    SelectedBrushByColor = CType(cboColor.SelectedItem, XBrush)

    I know that is...
  35. Replies
    17
    Views
    779

    VS 2017 Re: Using data from an SQL query in my code

    I have tried as wes4dbt suggested and I get no errors, but I am not getting any PDF file generated!
    As there are no exceptions I have nothing to debug.
    When I click the Print button nothing...
  36. Replies
    17
    Views
    779

    VS 2017 Re: Using data from an SQL query in my code

    When I ran the code there were no errors.
    Here is the latest version of the code we are talking about:

    Using connection As New SqlConnection(connectionString)
    Using command As New...
  37. Replies
    17
    Views
    779

    VS 2017 Re: Using data from an SQL query in my code

    You had already answered my question BEFORE I posted the post, and your post did not appear until I had posted.

    This is my lastest post

    In Post #6:

    Tried this but no errors, but it is...
  38. Replies
    17
    Views
    779

    VS 2017 Re: Using data from an SQL query in my code

    Should of tested before posting last post!
    Can't obviously mix SqlCommand and sqlAdaptor!
    How do I get around that?
  39. Replies
    17
    Views
    779

    VS 2017 Re: Using data from an SQL query in my code

    I did not understand that the @CID only applied to the WHERE part.
    Basically what I am trying to achieve is to retreive all of the fields in the SELECT query when the selected value in the combobox...
  40. Replies
    17
    Views
    779

    VS 2017 Re: Using data from an SQL query in my code

    Previous post got posted twice! Deleted it!
Results 1 to 40 of 133
Page 1 of 4 1 2 3 4



Featured


Click Here to Expand Forum to Full Width