Search results for query: *

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...

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 |...

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...

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)...

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...

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...

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...

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...

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...

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...

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...

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...

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...

I don't know if this is possible, but what I want to have is a SQL table that contains has one column called "Command" that contains a VB.Net code E.g. Me.btnHome.Enabled = False Me.btnSave.Enabled = True What I then want to do is query the database, and then loop through the datareader and...

I have an SQL statement that gathers the users fullname from a userTbl table using the userID value in the commentsTbl table. What I want to be able to do is if the value of commentsTbl.isPublishedComm equal to 'True' then add a value into the FullName field e.g. 'NOT FOUND' else if...

I have a MS SQL 2005 database on one server and then a copy of that database structure on a azure server. I want to copy a specific row of data from a table from server 1 to the same table on the azure server. The problem I have is that I do not know where to start, I am able to connect to...

I have the below stored procedure: ALTER PROCEDURE [dbo].[spInsertComm] @commTag as nvarChar(255), @commTitle as nvarchar(255), @commDisp as nvarchar(255), @commType as nvarchar(255), @commDate as varchar(25), @commArea as nvarchar(100), @commModRef as nvarchar(100), @commOrig as...

I have a file called setting.xml which contains the following: <?xml version="1.0" encoding="utf-8"?> <settings licenseServiceType="1" protectedStorageFile="%AppDomainAppPath%App_Data\storage.psf"...

I have a form that depending on results from a table would create a number of buttons using code at runtime. This could range from 1 to 20 buttons. What I am struggling with is creating a generic mouse over event for each of these buttons? The reason why I want a generic mouseover event is that...

I have developed a desktop application that connects to a MS SQL server over a network. One of my clients wants a third party company to be able to use my desktop application but connect to the MS SQL database in my client’s office. Obviously my client could open the ports to the SQL server to...