How to display a "Record Successfully Inserted" Message on input.

I know this is probably simple, but i can't figure it out for some reason. I just need a little message that says "Record Successfully Submitted" when they input it into the database. I'm not sure how to code this. Here is my InputForm code below.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Page Language="C#" %>
<%@ Register TagPrefix="uc1" TagName="DynDropDown" 
    Src=DynamicDDL.ascx %>
 
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
</script>
 
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">
 
<head runat="server">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" />
<title>Submission Form</title>
<style type="text/css">
.style1 {
	font-size: xx-large;
	text-align: center;
}
.style2 {
	font-size: medium;
	text-align: center;
}
    .style3
    {
        width: 100%;
    }
    .style4
    {
        text-align: center;
    }
</style>
</head>
 
<body bgcolor="F8F8FF">
 
<p class="style1">LAND ANALYSIS DATABASE SUBMISSION FORM</p>
<p class="style2"><a href="DatabaseResults.aspx">RESULTS</a></p>
<form id="form1" runat="server" style="border-style: groove; border-width: medium; z-index: auto; width: 1205px; height: 1305px; position: relative; top: 15px; left: -3px">
	<div>
		<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:LA_DBASEConnectionString %>" 
            SelectCommand="SELECT * FROM [MainLATable]" 
            DeleteCommand="DELETE FROM [MainLATable] WHERE [ID] = @ID" 
            InsertCommand="INSERT INTO [MainLATable] ([Rank_Main], [Mapper_Main], [State_Main], [County_Main], [GIS_Ref], [Agmnt_No], [Tract_Nos], [Control_Stmnt], [Problem], [Resolution], [Date_Ini], [Date_Resolved], [Date_update], [GIS_Comments], [Send_Tim]) VALUES (@Rank_Main, @Mapper_Main, @State_Main, @County_Main, @GIS_Ref, @Agmnt_No, @Tract_Nos, @Control_Stmnt, @Problem, @Resolution, @Date_Ini, @Date_Resolved, @Date_update, @GIS_Comments, @Send_Tim)" 
            
            UpdateCommand="UPDATE [MainLATable] SET [Rank_Main] = @Rank_Main, [Mapper_Main] = @Mapper_Main, [State_Main] = @State_Main, [County_Main] = @County_Main, [GIS_Ref] = @GIS_Ref, [Agmnt_No] = @Agmnt_No, [Tract_Nos] = @Tract_Nos, [Control_Stmnt] = @Control_Stmnt, [Problem] = @Problem, [Resolution] = @Resolution, [Date_Ini] = @Date_Ini, [Date_Resolved] = @Date_Resolved, [Date_update] = @Date_update, [GIS_Comments] = @GIS_Comments, [Send_Tim] = @Send_Tim WHERE [ID] = @ID">
			<DeleteParameters>
				<asp:parameter Name="ID" Type="Int32" />
			</DeleteParameters>
			<UpdateParameters>
				<asp:parameter Name="Rank_Main" Type="String" />
				<asp:parameter Name="Mapper_Main" Type="String" />
				<asp:parameter Name="State_Main" Type="String" />
				<asp:parameter Name="County_Main" Type="String" />
				<asp:parameter Name="GIS_Ref" Type="String" />
				<asp:parameter Name="Agmnt_No" Type="String" />
				<asp:parameter Name="Tract_Nos" Type="String" />
				<asp:parameter Name="Control_Stmnt" Type="String" />
				<asp:parameter Name="Problem" Type="String" />
				<asp:parameter Name="Resolution" Type="String" />
				<asp:parameter Name="Date_Ini" Type="DateTime" />
				<asp:parameter Name="Date_Resolved" Type="DateTime" />
				<asp:parameter Name="Date_update" Type="DateTime" />
			    <asp:Parameter Name="GIS_Comments" Type="String" />
                <asp:Parameter Name="Send_Tim" Type="Boolean" />
                <asp:Parameter Name="ID" Type="Int32" />
			</UpdateParameters>
			<InsertParameters>
				<asp:parameter Name="Rank_Main" Type="String" />
				<asp:parameter Name="Mapper_Main" Type="String" />
				<asp:parameter Name="State_Main" Type="String" />
				<asp:parameter Name="County_Main" Type="String" />
				<asp:parameter Name="GIS_Ref" Type="String" />
				<asp:parameter Name="Agmnt_No" Type="String" />
				<asp:parameter Name="Tract_Nos" Type="String" />
				<asp:parameter Name="Control_Stmnt" Type="String" />
				<asp:parameter Name="Problem" Type="String" />
				<asp:parameter Name="Resolution" Type="String" />
				<asp:parameter Name="Date_Ini" Type="DateTime" />
				<asp:parameter Name="Date_Resolved" Type="DateTime" />
			    <asp:Parameter Name="Date_update" Type="DateTime" />
                <asp:Parameter Name="GIS_Comments" Type="String" />
                <asp:Parameter Name="Send_Tim" Type="Boolean" />
			</InsertParameters>
		</asp:SqlDataSource>
		<asp:FormView id="InputForm" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource1" DefaultMode="Insert" Height="400px" Width="550px" BorderStyle="Groove" HorizontalAlign="Center">
			<EditItemTemplate>
				Rank (Importance):
				<asp:dropdownlist id="ddlRank" runat="server" DataSourceID="SqlDataSource2" DataTextField="Rank" DataValueField="Rank" SelectedValue='<%# Bind("Rank_Main") %>'>
				</asp:dropdownlist>
				<asp:sqldatasource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:LADBASEConnectionString9 %>" SelectCommand="SELECT [Rank] FROM [LA_Rank]">
				</asp:sqldatasource>
				<br />
				<br />
				Mapper:
				<asp:dropdownlist id="ddlMapper" runat="server" DataSourceID="SqlDataSource3" DataTextField="Mapper" DataValueField="Mapper" SelectedValue='<%# Bind("Mapper_Main") %>'>
				</asp:dropdownlist>
				<asp:sqldatasource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:LADBASEConnectionString9 %>" SelectCommand="SELECT [Mapper] FROM [Mapper]">
				</asp:sqldatasource>
				<br />
				<uc1:DynDropDown ID="DynDropDown1" State='<%# Bind("State_Main") %>' County='<%# Bind("County_Main") %>' runat="server" />
				<br />
				Main:
				<asp:dropdownlist id="ddlState" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource4" DataTextField="State" DataValueField="State" SelectedValue='<%# Bind("State_Main") %>'>
				</asp:dropdownlist>
				<asp:sqldatasource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:LADBASEConnectionString9 %>" SelectCommand="SELECT [State] FROM [LA_State]">
				</asp:sqldatasource>
				<br />
				<br />
				County:
				<asp:textbox id="TextBox1" runat="server" Text='<%# Bind("County_Main") %>'></asp:textbox>
				<br />
				<br />
				GIS Ref:
				<asp:textbox id="GIS_RefTextBox" runat="server" Text='<%# Bind("GIS_Ref") %>' />
				<br />
				<br />
				Agreement No:
				<asp:textbox id="Agmnt_NoTextBox" runat="server" Text='<%# Bind("Agmnt_No") %>' />
				<br />
				<br />
				Tract No(s):
				<asp:textbox id="Tract_NosTextBox" runat="server" Text='<%# Bind("Tract_Nos") %>' />
				<br />
				<br />
				Control Statement:
				<asp:textbox id="Control_StmntTextBox" runat="server" Text='<%# Bind("Control_Stmnt") %>' />
				<br />
				<br />
				Problem:
				<asp:textbox id="ProblemTextBox" runat="server" Text='<%# Bind("Problem") %>' Height="250px" Width="550px" TextMode="MultiLine" />
				<br />
				<br />
				<br />
				Date Problem Initiated:
				<asp:textbox id="Date_IniTextBox" runat="server" Text='<%# Bind("Date_Ini") %>' />
				<br />
				<br />
				Date GIS Updated:
				<asp:textbox id="Date_UpdateTextBox" runat="server" Text='<%# Bind("Date_Update") %>' />
				<br />
				<br />
				<asp:button id="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" />
				&nbsp;<asp:button id="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
			</EditItemTemplate>
			<InsertItemTemplate>
				&nbsp;<br />
				<br />
				&nbsp;<table class="style3" border="1">
                    <tr>
                        <td>
                            Rank (Importance):</td>
                        <td>
                            <asp:DropDownList ID="ddlRank" runat="server" DataSourceID="SqlDataSource2" 
                                DataTextField="Rank" DataValueField="Rank" 
                                SelectedValue='<%# Bind("Rank_Main") %>'>
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:LA_DBASEConnectionString %>" 
                                SelectCommand="SELECT [Rank] FROM [LA_Rank]"></asp:SqlDataSource>
                        </td>
                        <td>
                            Mapper:</td>
                        <td>
                            <asp:DropDownList ID="ddlMapper" runat="server" DataSourceID="SqlDataSource3" 
                                DataTextField="Mapper" DataValueField="Mapper" 
                                SelectedValue='<%# Bind("Mapper_Main") %>'>
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:LA_DBASEConnectionString %>" 
                                SelectCommand="SELECT [Mapper] FROM [Mapper]"></asp:SqlDataSource>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <uc1:DynDropDown ID="DynDropDown1" runat="server" 
                                County='<%# Bind("County_Main") %>' State='<%# Bind("State_Main") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            GIS Ref:</td>
                        <td>
                            <asp:TextBox ID="GIS_RefTextBox" runat="server" Text='<%# Bind("GIS_Ref") %>' />
                        </td>
                        <td>
                            Agreement No:</td>
                        <td>
                            <asp:TextBox ID="Agmnt_NoTextBox" runat="server" 
                                Text='<%# Bind("Agmnt_No") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            Tract No(s):</td>
                        <td>
                            <asp:TextBox ID="Tract_NosTextBox" runat="server" 
                                Text='<%# Bind("Tract_Nos") %>' />
                        </td>
                        <td>
                            Control Statement:</td>
                        <td>
                            <asp:TextBox ID="Control_StmntTextBox" runat="server" 
                                Text='<%# Bind("Control_Stmnt") %>' />
                        </td>
                    </tr>
                </table>
                <div class="style4">
                    <br />
                    Problem:</div>
                <table class="style3" border="1">
                    <tr>
                        <td>
                            <asp:TextBox ID="ProblemTextBox" runat="server" Height="250px" 
                                Text='<%# Bind("Problem") %>' TextMode="MultiLine" Width="550px" />
                        </td>
                    </tr>
                </table>
                &nbsp;<table class="style3" border="1">
                    <tr>
                        <td>
                            Date Problem Initiated:<br />
                            (Format: xx/xx/xxxx)</td>
                        <td>
                            <asp:TextBox ID="Date_IniTextBox" runat="server" 
                                Text='<%# Bind("Date_Ini") %>' />
                        </td>
                        <td>
                            Date GIS Updated:</td>
                        <td>
                            <asp:TextBox ID="Date_UpdateTextBox" runat="server" 
                                Text='<%# Bind("Date_Update") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            Notify Property Tax Manager:</td>
                        <td>
                            <asp:CheckBox ID="PropManagerTxtBox" runat="server" Checked='<%# Bind("Send_Tim") %>' />
                        </td>
                    </tr>
                </table>
				<br />
				<br />
				<asp:button id="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Submit" />
				&nbsp;<asp:button id="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
			</InsertItemTemplate>
			<ItemTemplate>
				ID:
				<asp:label id="IDLabel" runat="server" Text='<%# Eval("ID") %>' />
				<br />
				Rank_Main:
				<asp:label id="Rank_MainLabel" runat="server" Text='<%# Bind("Rank_Main") %>' />
				<br />
				Mapper_Main:
				<asp:label id="Mapper_MainLabel" runat="server" Text='<%# Bind("Mapper_Main") %>' />
				<br />
				State_Main:
				<asp:label id="State_MainLabel" runat="server" Text='<%# Bind("State_Main") %>' />
				<br />
				County_Main:
				<asp:label id="County_MainLabel" runat="server" Text='<%# Bind("County_Main") %>' />
				<br />
				GIS_Ref:
				<asp:label id="GIS_RefLabel" runat="server" Text='<%# Bind("GIS_Ref") %>' />
				<br />
				Agmnt_No:
				<asp:label id="Agmnt_NoLabel" runat="server" Text='<%# Bind("Agmnt_No") %>' />
				<br />
				Tract_Nos:
				<asp:label id="Tract_NosLabel" runat="server" Text='<%# Bind("Tract_Nos") %>' />
				<br />
				Control_Stmnt:
				<asp:label id="Control_StmntLabel" runat="server" Text='<%# Bind("Control_Stmnt") %>' />
				<br />
				Problem:
				<asp:label id="ProblemLabel" runat="server" Text='<%# Bind("Problem") %>' />
				<br />
				Date_Ini:
				<asp:label id="Date_IniLabel" runat="server" Text='<%# Bind("Date_Ini") %>' />
				<br />
				Date_Resolved:
				<asp:label id="Date_ResolvedLabel" runat="server" Text='<%# Bind("Date_Resolved") %>' />
				<br />
				Date_Update:
				<asp:label id="Date_UpdateLabel" runat="server" Text='<%# Bind("Date_Update") %>' />
				<br />
			</ItemTemplate>
		</asp:FormView>
	</div>
</form>
 
</body>
 
</html>

Open in new window

GravitaZ24Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David RobitailleAnalyst ProgrammerCommented:
in the
InputForm_ItemInserted or SqlDataSource1_ItemInserted
check If e.Exception IsNot Nothing to make sure the insertion dont caused an exception.
0
GravitaZ24Author Commented:
hi thanks, i have this below, but i'm still not having a message show up, am I missing something?
using System;
using System.IO;
using System.Data;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
using System.Web.Services.Protocols;
using System.Text;
using System.Net;
 
 
 
public partial class Default : System.Web.UI.Page
{
    protected void InputForm_ItemInserted(object sender, ObjectDataSourceStatusEventArgs e)
    {
        if (e.Exception != null)
            Response.Write("Record Inserted Successfully");
        else
            throw e.Exception;
    }
}

Open in new window

0
David RobitailleAnalyst ProgrammerCommented:
Does the code run? (try to put a break point)
Does the data is added to the database?
did you try with SqlDataSource1_ItemInserted?
 
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

GravitaZ24Author Commented:
ya, the code seems to be running, the data is added to the database.

I tried both SqlDataSource1_ItemInserted, and InputForm_ItemInserted
0
David RobitailleAnalyst ProgrammerCommented:
well, i just saw that you put "e.Exception != null"
you should put  "e.Exception == null"
If there is an error, there will be something in e.Exception...  
 
Has a free link, here my source for that kind of thing. thats where i learned how to do it.
http://www.asp.net/learn/data-access/tutorial-18-cs.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GravitaZ24Author Commented:
Oh ok, i found a good solution here and with your help, thank you!

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.formview.iteminserted.aspx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.