Recent content by lidds

  1. L

    Is time between certain times...

    I am trying to figure out how to see the current time is between certain times that the user has entered. I have the following code which works if the time is between 00:01 and 23:59, however if the user enters a time, such as, 20:00 and 05:00 then the below code does not work. Which I guess...
  2. L

    CASE help I think!!

    I need some help with this as I am not majorly SQL knowledgable and this has got me stuck at the point I do not know where to start, so hopefully someone could assist. I have a table called "documentsTbl" which has the following stucture and example data in it DocumentNo | Department1 |...
  3. L

    Unable to drop user after restore...

    The alternative is to create a backup but with out users, if that is possible. I am using SMO, but I could not find anything on the internet on how to do this?
  4. L

    Unable to drop user after restore...

    I am writing a utility to my application that will allow the user to create a backup of an sql database and restore that backup on a different server. The restore option will also create the SQL login and user to that database that my software is using. This all works fine, apart from the fact...
  5. L

    Backup and Restore SQL database with SMO...

    I am creating a backup of an SQL Server database using the following code: Public Sub ExportDataToFile(ByVal strSourceServer As String, ByVal strBakFileName As String, ByVal WindowsAuth As Boolean, ByVal strUsername As String, ByVal strPassword As String, ByVal strDatabase As String)...
  6. L

    SQL Replication question\advise...

    I have set-up SQL Replication on a number of tables, these tables contain information that is required to run my application. The replication works perfectly, I am using Snapshot publication on these tables as the data is only modified in one location. The problem that I have is I have noticed...
  7. L

    SQL Database Replication....

    I need some advise from the group. I have developed a piece of software that uses MS SQL Server to store my application database. My software can be used by companies that have multiple offices in different countries, and this is fine as they write back to the SQL database in one of the...
  8. L

    Connection to database not closing...

    I am stuggling to find out what I am doing wrong here and think a fresh pair of eyes might help. I have a class called DBAccess which I am using to connect to a SQL Server database, the DBAccess class contains the following code: Public Class DBAccess Private connStr As String = Nothing...
  9. L

    Send data from vb.Net App to ASP.Net page...

    What I want to do is send data from my VB.Net application to a ASP.Net webpage so that this data send can we written to a database which would be handled by the ASP.Net. The reason why I want to do this is because one of my clients has asked for statistics on how many people are using my...
  10. L

    Multiple SQL Select Statement...

    I am having a problem with an stored procedure that has multiple SQL statements. I am not sure if it actually requires multiple statements, but hopefully in explaining my problem others may be able to offer either a solution or a better way to do this. Below is my stored procdure: CREATE...
  11. L

    Hilight text in webbrowser that meets a criteria...

    This may or maynot be possible, but thought I would ask the question anyway. I have a webbrowser control on a form that I am using to allow my users to create custom email templates within my application. I then have a number of button on the form that enters predefined tags within the...
  12. L

    Add <br/> to webbrowser on return...

    I have a WebBrowser control added to my form, which I am allowing users to create custom html email templates. The problem I have is that when you with the 'Return' key, the cursor jumps what looks like 2 lines. I've looked at the HTML behind it and it seems to add a <p> (Paragraph) item each...
  13. L

    Reflection with plugin...

    Thanks, that's what I thought it might be. Just wanted to check
  14. L

    Reflection with plugin...

    I have written a plugin application into a third party 3D design software. The 3D design software is owned by another company. The problem that I have is that with each version of the 3D design software that is released, they add new code and change the version of the dll's that I reference...
  15. L

    Combine 3 byte buffers...

    I was wondering if anyone could help me with combining 3 byte buffers. I am using a licening piece of software has supplied the below code example on there website, which is to create a unique machinecode. The problem is that the example shows how to use 2 computer parameter e.g. GetCPUId and...
Top Bottom