473,666 Members | 2,612 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need Help!! entering form results to a SQL Database then emailing them

Hi,

I am a total newbie to asp.net. I have spent the last week or so trying
to find a good tutorial that would show me how to create a form that
would be entered into a SQL database and then once entered into the
database would email me the results of the form.

I found the tutorials on aspnet101.com (Emailing form results) and they
really did not explain to well.

Does anyone know of a good tutorial site where it pretty much explains
it word for word? And if not a tutorial site then could someone please
point me in the right direction....

Thanks so much

Nov 21 '05 #1
1 1143
Dman,

This was my first expirience with ASPNET and I find if well.

http://samples.gotdotnet.com/quickstart/

Although it is ASPNET without the IDE (dll's), which is in fact a little bit
else to use. For good samples about real using the IDE, I would use the
ASPNET part from this ones

http://www.microsoft.com/downloads/d...displaylang=en

And a sample to show you how simple it is if you have MSDE (the mini SQL
server) and in that the sample northwind database installed.

\\\open a webform project, drag a datagrid from the toolbox,
'click somewhere on your form, paste in this code and click debug.
Private Sub Load(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles mybase.load
Dim conn As New SqlClient.SqlCo nnection _
("Server=(Local ); DataBase=Northw ind;" & _
"Integrated Security=SSPI")
Dim da As New SqlClient.SqlDa taAdapter _
("select * from categories, conn)
Dim ds As New DataSet
da.Fill(ds, "categories ")
DataGrid1.DataS ource = ds.Tables(0)
DataGrid1.DataB ind()
End Sub
///

I hope this helps,

Cor
Nov 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1615
by: Ken | last post by:
How can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'. Below is the line where the error occurs Session("dbWhere") = "Assignee = " & Request.Form("assignsearch") Thanks Ken
3
1151
by: Greg Krawczyk | last post by:
I created a contacts form. Uploaded the form, the database, and the connection page to the remote server. I tested everything out on my computer, win2000 localhost and everything worked but after uploading and trying it out the following happens. After filling in the form and clicking Submit I get ther following in a web page: Table 'contacts.contacts' doesn't exist
22
2823
by: SF | last post by:
Hello All, In a windows C learning project I am wokring on I use the system function to run a command, I want to suck the results into a vairable. The system function seems to only return an int. I would like to know how could this is done? I can see only one way currently and I know that there must be a better method. Right now I would be tempted to pipe the output of the command to a temp file and then get the data from the file....
5
2496
by: rhconcepts | last post by:
I have my own server running 2003 web edition. I have a webpage that has a form on it. I would like to set it up so I can have the submit button send the form to the server. It is set up now to work through email. But as you know if someone does not have email set up it won’t work for them. I need some help in this matter. What do I need to get it going? I know I need a script on the server and something for the page but that’s all I know. I’m...
0
1544
by: HydroPnik | last post by:
Hi all! What a great community you have here. Being an Access newbie I have already used much information gleaned from the other posters for my current project. I have been tasked with creating a database that will link to a table ("tbl_Data File) located in another database ("Database1"). Changes will be made to a customer record queried from Database1 and saved in a table located in Database2 called "tbl_Instructions". So far I have...
2
1345
by: jerryst | last post by:
need help and advise with database... i am an independant oil and gas consultant and have a fair amount of computer experience but, am lost when it comes to data bases .... i found a database online that contains names, addresses, phone numbers, fax numbers and email addresses (live links) of companies and people within the oil and gas industry ... i want to be able to utilize this db in excel so i can query and use excels "mail merge"...
9
2631
by: wparrott | last post by:
I have a table called tblPayScales. It has 5 fields: numRecID - record ID txtCLASSCODE - a 1 or 2 letter text value (A, B, C, BD, L, LT, etc.) numPAYSTEP - a number value 0-49 numSALARY - a number value such as 36,246.00 numNEWSALARY - a number value derived from a user-defined percentage The table contains records for each CLASSCODE/PAYSTEP. Although there are 50 pay steps some have a value of 0 for numSALARY(no employee at that pay...
6
1863
by: smk17 | last post by:
I've spent the last few minutes searching for this question and I found an answer, but it wasn't quite what the client wanted. I have a simple online form where the user needs to fill out five fields out of nine. The other four are already there and filled out for the user. When they hit submit, all data is sent to us. But, if they desire (for whatever reason) the user can possibly delete what is already there and fill in something...
47
4652
by: ndedhia1 | last post by:
I have data in a database that looks like this: INSERT INTO ALARMNOTIFICATIONDETAIL VALUES ('1865', '2295', '15401', '1', 'Prodprdcons11InstrumentationMonitor', 'ALL'); INSERT INTO ALARMNOTIFICATIONDETAIL VALUES ('1866', '2296', '15401', '1', 'ProdPRDCONS5InstrumentationMonitor', 'ALL'); INSERT INTO ALARMNOTIFICATIONDETAIL VALUES ('1867', '2297', '15401', '1', 'ProdPRDCONS5InstrumentationMonitor', 'ALL'); INSERT INTO ALARMNOTIFICATIONDETAIL...
0
8454
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8363
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8561
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8645
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7389
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6203
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4372
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2013
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.