I am trying to attach files to an email based on a selection that is stored in a sql table but when i try to loop through whats there i get various build errors.
if anyone has done this or can see where i'm gpoing wrong please help
'connect to database and fill the daaset with the kitnumbers...
can someone tell me where i'm going wrong with this
Dim sdate As Date
sdate = Date.Today.AddMonths(1).ToString
Dim ssql As String
ssql = "select * from information where expirydate <'" & sdate & "'"
i want the records that are about to run out to be returned.
Thanks
I have a prgram that stores infromation in an sql table through the program until the final page where the collected data is then used to place an order.
I want to be able to use the kit number values as part of the filename that i can then attach to an email.
for example if i had the kitnumbers...
I have an server on its own internet connection that needs to run multiple websites the server sits behind a firewall.
the question I have is if I use Host Header names how will internet users get to the right site?
if I point one of my computers to the webserver's ip address i can look at one...
I would like to know if it is possible to get information out of a dataset or dataview and into a textbox.
at the moment I query the table of a database and return a single record i would like to display this information in textboxes is this possible and if so has anyone got any examples.
Thanks
Hi
I am new to asp and i need some help getting my app to run properly on the server.
I have followed the examples in the books I have about securing the web pages it works fine on my computer but we I upload it to the server it redirects me to a windows login not the login page I want it to...
Hi this is the first application i have written so i am very new to the whole webserver bit.
the application works for the most part but gives the following error when the application calls excel.
Server Error in '/' Application.
________________________________________
Login failed for user...
I Have to export the contents of a datagrid to an excel template(see code below) the problem is when i open the worksheet i can see all the html code is there an easy way filter this out.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
Hi I have a page that has two dropdownlists on it the first has three static values the choice made here then query's a database and fills the second dropdownlist i then need to show an image from the selection but the code i am using does not return the image.
the dropdownlist autopostback is...
The dropdown lists are named
Divisionddl
Kitddl
Private Sub kitddl_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles kitddl.SelectedIndexChanged
' code here shows the visual in the picture box and sets the price
Image1.ImageUrl = ("c: \" &...
i have been stuffed in at the deep end here only two weeks of asp.
the problem i have is that i need to email the contents of a datagrid preferably in the body of a message can anyone help
I am trying to open an excel template and keep getting the error below i have given the everyone group full access on my pc but still no luck anyone have the answer
Access is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review...
I need to have a log in box that will query a table if the name does not exist i want to write to the screen a message but i'm not sure how to start for example
if "i dont get a return fro my table" then
response.write("whatever")
I have been thrown in at the deep end here I need to send a movie to some customers but my designer wants it to be automatically displayed full screen at 1024x768 with a loop back and forth option.
is there a way of saving the file so it opens with theese settings b default.
I have written an application that uses Excel I have created the setup files and installed this application to my computer when I run it I get the error message “interop.Excel, or one of its dependencies was not found”.
When I packaged the files the interop.excel was in the dependency group...
I have a program that needs to write the contents of a string to a Microsoft Word file and save it, the problem is i can not see any write command has anyone done this before that could show me please.
im' not trying to do something impossible here most of this code comes from the examples but when i run it it stops at the send line "smtpmail.send(mymail)"
Imports System.Web.mail
Public Class WebForm1
Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This...
I for some reason can not understand the classes i am having a real hard time with an application using code ive used in vb 6 lots of times in the past to send email.
Dim olapp
Dim olitm
Set olapp = CreateObject("Outlook.Application")
Set olitm = App.CreateItem(0)
With olitm
.to me@myaddr.com...
Im a complete newbie to Access
Hopefully there is a simple answer to this problem I want to be able to send the active record via email I have seen the email report function but it sends all the records is there a way to limit it to just the open record?
I have had a program running on local computers for about three months now and have been asked if we could put it on the website for our customers to use.
I am very new to Visual basic and don't know if it’s possible and if it is how to start. Are there any guides to this?
The program is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.