Hi
I am building a .NET 3.5 web site with visual studio 2008 and MS SQL server 2008. I have a refrence to the database in the server explorer database.dbo,
I have a form with input asp controls and a typed dataset with single data table and a strongly typed data adaptoer class.
when I submit the form the data does not populate the table.
I need help please.
contactUs.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Default.master" AutoEventWireup="true" CodeFile="contactUs.aspx.cs" Inherits="contactUs" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeaderContent1" Runat="Server">
<link href="styles/contactUs.css" rel="stylesheet" type="text/css" />
<!--[if lte IE 7]>
<style type="text/css" media="all">
@import "styles/fieldset-styling-ie.css";
</style>
<![endif]-->
<script type="text/javascript" src="jScripts/jquery-1.3.2.js"></script>
<% if(false) { %>
<script type="text/javascript" src="jScripts/jquery-1.3.2-vsdoc2.js" ></script>
<% } %>
<script type="text/javascript" src="jScripts/contactUs.js"></script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CPH1" Runat="Server">
<div>
<form id="contact" runat="server">
<fieldset>
<legend>Reason for contacting</legend>
<asp:RadioButtonList ID="type" runat="server" TextAlign="right" CssClass="contactTypeRadio">
<asp:ListItem Value="Inquiry" Selected="True" />
<asp:ListItem Value="Booking" />
<asp:ListItem Value="Feedback" />
</asp:RadioButtonList>
</fieldset>
<fieldset>
<legend>Personal Information</legend>
<ol>
<li>
<asp:TextBox ID="name" runat="server" CssClass="text name" Text="Name:" TextMode="SingleLine" />
<asp:Label ID="name_error" AssociatedControlId="name" cssClass="error" runat="server">Required.</asp:Label>
</li>
<li>
<asp:TextBox id="mobileNumber" runat="server" CssClass="text" Text="Mobile number:" TextMode="SingleLine" />
<asp:Label ID="mobile_error" AssociatedControlId="mobileNumber" cssClass="error" runat="server">Required.</asp:Label>
</li>
<li>
<asp:TextBox id="emailAddr" runat="server" CssClass="text" Text="email:" TextMode="SingleLine" />
<asp:Label ID="email_error" AssociatedControlId="emailAddr" cssClass="error" runat="server">Required.</asp:Label>
</li>
</ol>
</fieldset>
<fieldset>
<legend>Vehicle Information</legend>
<ol>
<li>
<asp:TextBox id="yrMakeModel" runat="server" CssClass="text" Text="Year, Make, Model:" TextMode="SingleLine" />
<asp:Label ID="carInfo_error" AssociatedControlId="yrMakeModel" cssClass="error" runat="server">Required.</asp:Label>
</li>
</ol>
</fieldset>
<fieldset>
<legend>Request</legend>
<ol>
<li>
<asp:TextBox id="subjectTitle" runat="server" CssClass="text textSmall" Text="Subject:" TextMode="SingleLine" />
<asp:Label ID="subject_error" AssociatedControlId="subjectTitle" cssClass="error" runat="server">Required.</asp:Label>
</li>
<li>
<asp:TextBox id="messege" runat="server" CssClass="text heightclass" Text="Write your messege here..." TextMode="MultiLine" />
<asp:Label ID="comment_error" AssociatedControlId="messege" cssClass="error" runat="server">Required.</asp:Label>
</li>
</ol>
</fieldset>
<fieldset>
<asp:Button ID="Button1" runat="server" Text="Send" CssClass="button" onclick="Button1_Click" />
</fieldset>
</form>
</div>
<div id="div_error">
<asp:Label ID="error" runat="server" Text="show when error happens"></asp:Label><br />
</div>
<%="Hello from the server" %><br />
<br />
<script type ="text/javascript">
browserInfo();
setAccessKeys();
</script>
</asp:Content>
contactUs.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class contactUs : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
totalCareAutoTableAdapters.ContactUsTableAdapter ContactUsAdapter = new totalCareAutoTableAdapters.ContactUsTableAdapter();
int new_ContactUs = Convert.ToInt32(ContactUsAdapter.InsertContactUs(name.Text, mobileNumber.Text, emailAddr.Text, subjectTitle.Text, messege.Text, type.Text));
}
catch (Exception ex)
{
}
}
}
contactUs.js
/// <reference path="jquery-1.3.2-vsdoc2.js" />
$(document).ready(function()
{
var $a = $("input[id$=name]");
$a.focus(function(event) { if ($a.val() == "Name:") { $a.val(""); } });
$a.blur(function(event) { if ($a.val() == "") { $a.val("Name:"); $(this).css("color", "Gray"); } else { $(this).css("color", "000"); } });
$a.keyup(function() { $(this).css("color", "#000"); });
var $b = $("input[id$=mobileNumber]");
$b.focus(function(event) { if ($b.val() == "Mobile number:") { $b.val(""); } });
$b.blur(function(event) { if ($b.val() == "") { $b.val("Mobile number:"); $(this).css("color", "Gray"); } else { $(this).css("color", "000"); } });
$b.keyup(function() { $(this).css("color", "#000"); });
var $c = $("input[id$=emailAddr]");
$c.focus(function(event) { if ($c.val() == "email:") { $c.val(""); } });
$c.blur(function(event) { if ($c.val() == "") { $c.val("email:"); $(this).css("color", "Gray"); } else { $(this).css("color", "000"); } });
$c.keyup(function() { $(this).css("color", "#000"); });
var $d = $("input[id$=yrMakeModel]");
$d.focus(function(event) { if ($d.val() == "Year, Make, Model:") { $d.val(""); } });
$d.blur(function(event) { if ($d.val() == "") { $d.val("Year, Make, Model:"); $(this).css("color", "Gray"); } else { $(this).css("color", "000"); } });
$d.keyup(function() { $(this).css("color", "#000"); });
var $e = $("input[id$=subjectTitle]");
$e.focus(function(event) { if ($e.val() == "Subject:") { $e.val(""); } });
$e.blur(function(event) { if ($e.val() == "") { $e.val("Subject:"); $(this).css("color", "Gray"); } else { $(this).css("color", "000"); } });
$e.keyup(function() { $(this).css("color", "#000"); });
var $f = $("input[id$=messege]");
$f.focus(function(event) { if ($f.val() == "Write your messege here...") { $f.val(""); } });
$f.blur(function(event) { if ($f.val() == "") { $f.val("Write your messege here..."); $(this).css("color", "Gray"); } else { $(this).css("color", "000"); } });
$f.keyup(function() { $(this).css("color", "#000"); });
});
$(document).ready(function()
{
$('.error').hide();
$(".button").click(function()
{
// validate and process form here
$('.error').hide();
var name = $("[id$='name']").val();
var email = $("[id$='emailAddr']").val();
if (name == "" || name == "Name:")
{
$("[id$='name_error']").show();
$("[id$='name']").focus();
return false;
}
var dataString = 'name=' + name + '&email=' + email;
$.ajax({
type: "POST",
url: "siteMap.aspx",
data: dataString,
success: function()
{
$("[id$='contact_form']").html("<div id='message'></div>");
$("[id$='message']").html("<h2>Contact Form Submitted!</h2>")
.append("<p>We will be in touch soon.</p>")
.hide()
.fadeIn(1500, function()
{
$("[id$='message']").append("<img id='checkmark' src='images/fiat.jpeg' />");
});
}
});
return false;
});
});