dougancil

I have a web page in which there is a textbox that asks my users to enter a start date. What I'm trying to do from there is that no matter what the end date is, my page will calculated that from the text box, store it as a variable …

I have the following stored procedure: [code] SELECT moncallAdd.FirstListing, DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899')) AS OnCallStart, DATEADD(MINUTE, mOnCallAdd.duration, DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899'))) AS OnCallEnd, 'Added' As Activity FROM mdr.dbo.mOnCallAdd WHERE DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899')) BETWEEN Convert(VARCHAR(10), GetDate(), 101) AND GetDate() and mOnCallAdd.SchedName = @schedname UNION SELECT moncallDelete.FirstListing, DATEADD(MINUTE, …

I have an application that I'm trying to finish in VBA, and as I've never written in it, it's a bit challenging to me. I've written some in VB but the syntax isn't the same between the two for some things. Essentially, here's the logic (or lack of) that I'm …

I am running a stored procedure and presenting the data back to users in a simple datagridview. I'm unable to figure out a way to filter my data through the SQL side, so I wanted to see if I could filter data through the datagridview. Basically my sql query returns …

I have the following code: [code] [<asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="SchedName" HeaderText="SchedName" SortExpression="SchedName" /> <asp:BoundField DataField="ActivityDate" HeaderText="ActivityDate" ReadOnly="True" SortExpression="ActivityDate" /> <asp:BoundField DataField="By" HeaderText="By" SortExpression="By" /> <asp:BoundField DataField="Activity" HeaderText="Activity" ReadOnly="True" SortExpression="Activity" /> <asp:BoundField DataField="FirstListing" HeaderText="FirstListing" SortExpression="FirstListing" /> <asp:HyperLinkField DataTextField="OnCallStart" HeaderText="OncallStart" DataNavigateUrlFields="SchedName,OncallStart" DataNavigateUrlFormatString="\website1\Default2.aspx?date={0:d}&amp;schedule={1}" SortExpression="OnCallStart" NavigateUrl="\website1\default2.aspx" /> <asp:BoundField DataField="OnCallEnd" …

I have a datagridview that has a checkbox. That checkbox will designate if a day is a "Holiday" or not. When then user clicks on my save event, I want my sub to check to see if that box is checked and appending the data to a table in my …

I have the following code in my asp page: [code] Imports System.Data.SqlClient Imports System.Data Partial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dt As DataTable Dim connectionString As String = "Initial Catalog=mdr;Data Source=xxxxx;uid=xxxxx;password=xxxxx" Dim con As New SqlConnection(connectionString) Dim cmd …

I am trying to update a database table that's attached to a table adapter and can't quite seem to be able to get the code to work. It was suggested that I use an update statement, but the person I was working with had no idea how to update a …

I have the following code: [code] Imports System.Data.SqlClient Public Class Main Protected WithEvents DataGridView1 As DataGridView Dim instForm2 As New Exceptions Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click Dim ssql As String = "select MAX(payrolldate) AS [payrolldate], " & _ "dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7, '17530107') …

I am trying to run several stored procedures from my code and I get the error message that my sp's can't be found, but if I remove all of them but one, my code executes fine. I've tried this way to run my sp's: [code] Dim oCmd2 As System.Data.SqlClient.SqlCommand Dim …

I have the following code: [code] Public Class Payrollfinal Private Sub Payrollfinal_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load exportfileButton.Enabled = False Dim oCmd As System.Data.SqlClient.SqlCommand Dim oDr As System.Data.SqlClient.SqlDataReader oCmd = New System.Data.SqlClient.SqlCommand Dim _CMD As SqlCommand = New SqlCommand Dim adapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter …

I have two forms and I am running a sql query to provide a set of variables in my first form that I need to pass to my second form. Here is the code that I have: [code] Imports System.Data.SqlClient Public Class Main Dim instForm2 As New Exceptions Public payrollstartdate …

I have a form that shows users data from a sql query. What I want to be able to do is when users make a change, they press a save button, the edited/changed data is saved to a new table and then the window is closed. I've looked for several …

I have a web page that I'm trying to place 3 div tags in and to make them center correctly. The page is a auto generated html from a psd file created with Photoshop. The html for the page is one table. I have the following code for my div …

I have a web page that I converted from a psd file to html with Photoshop and imported into Dreamweaver. The problem I'm having is that some viewers comment on the fact that the page is left justified. I inserted a div tag into the html with a wrap around …

I have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. If I declare Public Class Form1 Public payPeriodStartDate, payPeriodEndDate As Date How then to I declare that variable in …

I am developing an application that based on when a user has last entered a payroll, my program tells them the next available Sunday that is available to them based on 1. The date that the last time payroll was entered 2. If payroll ran = "yes" or "no" I …

I have two text boxes starttimeInput and endtimeInput that have regularexpression validators to only accept input of time variables (11:00 am, 12:15 pm, etc) and then a durationLabel where I want to calculate between the start time and end time and present it to the user as minutes. Here is …

I have the following sql query: ET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE YourProcedure AS insert into msbtotal.dbo.newclients SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is null GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO What this does is …

I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently …

I need to have some data removed from some of my posts. Can that be done? Thank you Doug

I have the following code: [CODE] Private Function BuildDataTable(ByVal fileFullPath As String, ByVal seperator As Char) As DataTable Dim myTable As New DataTable("MyTable") Dim i As Integer = 0 Dim myRow As DataRow = Nothing Dim fieldValues As String() = Nothing 'string FileToRead = Server.MapPath(fileFullPath); Dim myReader As System.IO.StreamReader = …

I have an asp.net web page that a user is loading a file to that I want to parse data out of. The following text is some sample data (I'm told that it's supposed to be .csv but as you can tell, it's really not.) Resource:Wills MD, Robert P; Ward …

I am doing a bulk insert on a web page to a sql server (via a browse and upload button) and currently when a user supplies a file thats in an incorrect format, we simply return them a message stating that it is in incorrect format but what I would …

I have the following code for part of an application I'm building and I need some instruction on how to store this value and carry it to the next part of the program. [CODE] Private Sub dateEntryTextbox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dateEntryTextbox.TextChanged Dim dateEntryTextBox As Date …

Is there a way to customformat DateTimePicker to only allow users to select M-F? Thank you Doug

I'm relatively new to using VB but I'm trying to design a small program that has a lot of SQL involved in it that someone else wrote. What I'm trying to do is to do a date selection of 7 days at a time, and pass that as a variable …

I have the following code: [CODE]Imports System.IO Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Protected Sub Submit1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit1.Click Dim SaveLocation As String = Server.MapPath("Data") & "\upload.txt'" …

I have almost finished a site that I've been working on but have one last thing that I don't know where to add. I have a bulk insert sql query that I want to insert into the .vb code behind and have no idea where to put it. Basically, the …

I'm trying to write code for a page using VB and as I'm new to this, I'm needing some assistance. I have a button on a web page for uploading a .csv file but I also want that button to function as taking people to a destination page as well. …

I'm fairly new at writing perl scripts and was wondering if you can write a perl script on an html page for the submission of a form to a database. Any assistance would be greatly appreciated. Thank you Doug

I've only written one stored procedure in the past and I'm being tasked again to write another one. The purpose of this SP is to do a bulk insert from a .txt file and then to move the file to an "archive" when it's done with the bulk insert. The …

I am trying to write a page that requires a Pass/Fail for conditions that are done everyday and then posting them to a database. The problem I'm having is the validation of the checkboxes. Find the code below: [code=html]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta …