dcsimg

Search:

Type: Posts; User: Spybot

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    thanks si_the_geek.

    Excuse me the columns names on both tables need to be the same?
  2. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    OK, I didn't know about (1:many relationships) between tables, now I now. So I create 2 separate tables, let's say:
    Ticket_Entity & Tickets_Contents

    Ticket_Entity table contains the following...
  3. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    OK I've created a dedicated table for my tickets in my database.

    CREATE TABLE "Tickets_table" (
    "ticket_number" INTEGER PRIMARY KEY AUTOINCREMENT,
    "ticket_header" TEXT,
    "ticket_date" TEXT,...
  4. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    Hello.

    OK I think I forget about MemoryStreams, no image to file, no image to database, so I'll go with option number (1) Save text and number data to a database because this is the one where I...
  5. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    Hi ChrisE!

    Thank you for your PDf-File suggestion, but I also agree with jmc's database option. as soon as I understand it.
  6. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    Hi jmc!

    Well, it's not that I don't want to follow those instructions, the thing is that I don't quite understand them, even if they crystal clear to you or others, my mind gets mixed up with so...
  7. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    I'm sorry I still don't get it. I appreciate your answer but it still sounds confusing enough to me. I've also been searching for days and still don't find a solution, this would be the last thing I...
  8. VS 2019 Re: How to retrieve a ticket for re-printing in VB.NET?

    Hi jmc!

    Thanks for the reply.

    In my case I definitely op for the second one, since the data that goes in the ticket is created on the fly, is not in a table. So I've created an extra table in...
  9. VS 2019 Re: [RESOLVED] Generating a sales ticket from a datagridview in VB.NET (help).

    Thank you very much for the feedback, the goal of this threat has been achieved.
  10. VS 2019 How to retrieve a ticket for re-printing in VB.NET?

    Hello!

    I have an application that can preview & print a sales ticket, I'd like to know how do I retrieve the last ticket for re-printing? and how do I save these tickets for future retrieval?
    ...
  11. VS 2019 Re: Generating a sales ticket from a datagridview in VB.NET (help).

    I'm back... :D

    I've made a couple of adjustments to my code so this is what my preview looks like now:
    169163

    I clearly have a problem with my Header (the name of the company) I pulled this...
  12. VS 2019 Re: Generating a sales ticket from a datagridview in VB.NET (help).

    Thank very much for the advice.

    I got rid of the colons, separated the lines, then I realized my DGV had hidden columns, that is why my column numbers were wrong, fixing all that I finally printed...
  13. VS 2019 Re: Generating a sales ticket from a datagridview in VB.NET (help).

    I apologize for posting the errors as images, I didn't think of it, it won't happen again.


    On the other hand you're right, I need some kind of preview window before sending stuff to print, but...
  14. VS 2019 Re: Generating a sales ticket from a datagridview in VB.NET (help).

    Hi jmc!

    I've already got some code to start with... by the way my Printer uses 58mm paper roles.

    The idea is to print something like this:
    169155

    I've only achieved to print the header of...
  15. VS 2019 Re: Generating a sales ticket from a datagridview in VB.NET (help).

    Hi jmc!

    I've already got some code to start with...

    The idea is to print something like this:
    169155

    I've only achieved to print the header of the ticket (It prints OK).
    the part where...
  16. VS 2019 Re: Generating a sales ticket from a datagridview in VB.NET (help).

    Hi jmc!

    Thanks for the guidance, I've been reading on it.

    So I see that I have to use the "PrintDocument" object along with it's events, like:
    .BeginPrint
    .QueryPageSettings
    .PrintPage
    ...
  17. VS 2019 [RESOLVED] Generating a sales ticket from a datagridview in VB.NET (help).

    Hello!

    I just got my first Thermal printer, I wrote a program in VB.NET that already shows me a datagridview with the data I'd like to pass to the ticket, I want to print only some columns of the...
  18. VS 2019 Re: Getting the SUM of a table column, throws an error (using SQLite database)

    Hi!

    Never mind, I changed this:

    Dim Command As New SQLiteCommand("SELECT SUM(Importe) FROM Ventas_del_Dia_Table WHERE CAST(Fecha AS DATE) ='" & Today.ToShortDateString & "'", Conexion)
    ...
  19. VS 2019 [RESOLVED] Getting the SUM of a table column, throws an error (using SQLite database)

    Hello!

    I'm using an SQLite database, and I'm trying to sum the values of a column in one of my tables, but it trows me this error:
    168455
    Before it used to work with an SQL Server database, but...
  20. Replies
    2
    Views
    192

    Re: Where my SQLite database should be placed?

    After I changed my connection string to: "Data Source = |DataDirectory|\Owner.db;Version=3;" I also moved the database to the bin\Debug folder, I knew that the database shouldn't be in:...
  21. Replies
    2
    Views
    192

    Where my SQLite database should be placed?

    Hello!

    I'm trying to run my Application in debug mode within VS 2019 I'm using an SQLite database (called: Owner.db), before I use to have the following connection string:
    "Data...
  22. Re: Warning message on Output window while building the installer (help)

    Hi jmc!

    No, I'm not, this warning message started showing up right after I installed the SQLite as Nuget package.
  23. Re: Warning message on Output window while building the installer (help)

    Hi jmc!

    No I'm not, this warning message started showing up right after I installed the Nuget package.
  24. Warning message on Output window while building the installer (help)

    Hello!

    I'm building an installer to deploy my application, I'm using VS 2019, at the end it builds OK, and runs as well. but at building time the output windows shows me this warning message, I'm...
  25. Re: [RESOLVED] Unable to load DLL 'SQLite.Interop.dll' outside VS

    Never mind!

    I just figured out how to tell the installer to include these folders.
    On my deployment project I manually added two folders: (x86 & x64), then I added the respective...
  26. Re: Application using SQLite db is not running outside VS 2019

    OK... back to the original threat.

    I just got rid of the "Unable to load DLL 'SQLite.Interop.dll" error message by manually copying the x86 & x64 folders to the installation directory in the...
  27. Re: Unable to load DLL 'SQLite.Interop.dll' outside VS

    Hi wes4dbt!

    Hey! it does work just by copying the release folder to the target machine. but what if I have .NET framework 4.7.2 as a prerequisite?

    Also, right now I have the database set with...
  28. Re: Application using SQLite db is not running outside VS 2019

    Hi jmc!

    I just tried so many "fixes" to my issue:

    I tried unloading my project and adding these lines to my csproj file:

    <ItemGroup>
    <Content Include="x64\SQLite.Interop.dll">
    ...
  29. Re: Application using SQLite db is not running outside VS 2019

    Hi jmc!

    Do you mean I add it as a reference to my solution? because I found a couple of these files in my Debug\x86 and Debug\x64 folders. Are these the ones I have to add?
  30. [RESOLVED] Unable to load DLL 'SQLite.Interop.dll' outside VS

    Hello!

    I want to deploy my VB.NET application on a Windows 10 System, my Application is working with an SQLite database, it runs great within VS, then I generate the .msi & .exe files and install...
  31. VS 2019 Re: Exporting only certain rows from a DataGridView to an Excel file.

    Yes! these fixes definitely get rid of those blank rows in the Excel file.
    That Language Integrated Query fix seems pretty clever to me.

    Just for the record, if anyone else has this same issue,...
  32. VS 2019 Re: Using parameters to run a query on an SQLite database. (help)

    This code definitely solve the problem:

    command.Parameters.AddWithValue("@INt", CInt(TextBox1.Text))

    Now my query is parametrized, I learned about reserved names in SQLite and the difference...
  33. VS 2019 Re: Exporting only certain rows from a DataGridView to an Excel file.

    Hi jmc!

    Thank you for your feedback!

    It works as expected, now it exports only the highlighted rows, but it also exports those rows where the condition wasn't satisfied.
    168277

    Is there a...
  34. VS 2019 [RESOLVED] Exporting only certain rows from a DataGridView to an Excel file.

    Hello!

    I have this code that exports all the contents of my DataGridView to an Excel file without problems, but now I'd like to export only the highlighted rows from my DataGridView.
    my...
  35. VS 2019 [RESOLVED] Using parameters to run a query on an SQLite database. (help)

    Hello!

    I'm trying to parametrize a DELETE Query on an SQLite database. but my query doesn't even run.

    my SQLite table structure is:

    CREATE TABLE "Servicios_Table" (
    "Concept" TEXT NOT...
  36. VS 2019 Re: Error when running a "DELETE" Query in SQLite database (help)

    I had no idea "Autoincrement" was a reserved name, adding []'s solved the problem, I'll try to use parameters in this query.
  37. VS 2019 [RESOLVED] Error when running a "DELETE" Query in SQLite database (help)

    Hello!

    I used to run this DELETE Query on an SQL Server .mdf database, and it use to run flawlessly, now I'm using an SQLite database, I'm trying to run this same Query and I keep getting this...
  38. VS 2019 Re: How to fix SQL logic error unrecognized token: "@" (VB.NET)

    Hi!

    Well... I think you're right, I shouldn't save the currency symbol to the database, I also agree that currency formatting should be for UI purposes only, I'll fix that!

    Thanks for the...
  39. Re: Choosing the right database file type. (help)

    Thanks a lot for all the feed back, I decided to try SQLite (file based) .db database type and everything went well with my application.
  40. Re: Help setting up permissions on DataBase.

    This threat comes to an end, because I switch from SQL Server database type to SQLite type, and all the issues has been solved by now.
Results 1 to 40 of 142
Page 1 of 4 1 2 3 4



Featured


Click Here to Expand Forum to Full Width