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