ASP.NET, Help, submit button onClick write to database question.

I am using Microsoft VWD 2008 express edition. I have linked an Access 2007 database to my asp.net application using a gridview control. On the webpage are four text boxes allowing a user to input (first name, last name, donation amount and date).

After the user inputs the values, I want them to click the "Submit" button and have that information from the text boxes write to the Access 2007 database.

This is where my problem lies. I hit a mental blank when I begin to program the button. Not sure where to start. Any help is appreciated! Thanks. ~Mike

My code is below:

Expand|Select|Wrap|Line Numbers

 <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <p>

        First Name:&nbsp;

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

    </p>

    <p>

        &nbsp;</p>

    <p>

        Last Name:&nbsp;

        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

    </p>

    <p>

        &nbsp;</p>

    <p>

        Donation:&nbsp;

        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

    </p>

    <p>

        &nbsp;</p>

    <p>

        Donation Date:&nbsp;

        <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>

    </p>

    <p>

        &nbsp;</p>

    <p>

        <asp:Button ID="btnSubmit" runat="server" Text="Submit" style="height: 26px" />

    </p>

    <p>

        &nbsp;</p>

    <p>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

            ConflictDetection="CompareAllValues" 

            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 

            DeleteCommand="DELETE FROM [Table1] WHERE (([Last Name] = ?) OR ([Last Name] IS NULL AND ? IS NULL)) AND [ID] = ? AND (([First Name] = ?) OR ([First Name] IS NULL AND ? IS NULL)) AND (([Donation Amount] = ?) OR ([Donation Amount] IS NULL AND ? IS NULL)) AND (([Date of Donation] = ?) OR ([Date of Donation] IS NULL AND ? IS NULL))" 

            InsertCommand="INSERT INTO [Table1] ([ID], [First Name], [Last Name], [Donation Amount], [Date of Donation]) VALUES (?, ?, ?, ?, ?)" 

            OldValuesParameterFormatString="original_{0}" 

            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 

            SelectCommand="SELECT * FROM [Table1]" 

            UpdateCommand="UPDATE [Table1] SET [ID] = ?, [First Name] = ?, [Donation Amount] = ?, [Date of Donation] = ? WHERE (([Last Name] = ?) OR ([Last Name] IS NULL AND ? IS NULL)) AND [ID] = ? AND (([First Name] = ?) OR ([First Name] IS NULL AND ? IS NULL)) AND (([Donation Amount] = ?) OR ([Donation Amount] IS NULL AND ? IS NULL)) AND (([Date of Donation] = ?) OR ([Date of Donation] IS NULL AND ? IS NULL))">

            <DeleteParameters>

                <asp:Parameter Name="original_Last_Name" Type="String" />

                <asp:Parameter Name="original_ID" Type="Int32" />

                <asp:Parameter Name="original_First_Name" Type="String" />

                <asp:Parameter Name="original_Donation_Amount" Type="Decimal" />

                <asp:Parameter Name="original_Date_of_Donation" Type="DateTime" />

            </DeleteParameters>

            <UpdateParameters>

                <asp:Parameter Name="ID" Type="Int32" />

                <asp:Parameter Name="First_Name" Type="String" />

                <asp:Parameter Name="Donation_Amount" Type="Decimal" />

                <asp:Parameter Name="Date_of_Donation" Type="DateTime" />

                <asp:Parameter Name="original_Last_Name" Type="String" />

                <asp:Parameter Name="original_ID" Type="Int32" />

                <asp:Parameter Name="original_First_Name" Type="String" />

                <asp:Parameter Name="original_Donation_Amount" Type="Decimal" />

                <asp:Parameter Name="original_Date_of_Donation" Type="DateTime" />

            </UpdateParameters>

            <InsertParameters>

                <asp:Parameter Name="ID" Type="Int32" />

                <asp:Parameter Name="First_Name" Type="String" />

                <asp:Parameter Name="Last_Name" Type="String" />

                <asp:Parameter Name="Donation_Amount" Type="Decimal" />

                <asp:Parameter Name="Date_of_Donation" Type="DateTime" />

            </InsertParameters>

        </asp:SqlDataSource>

    </p>

    <p>

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 

            DataKeyNames="Last Name" DataSourceID="SqlDataSource1">

            <Columns>

                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 

                    SortExpression="ID" />

                <asp:BoundField DataField="First Name" HeaderText="First Name" 

                    SortExpression="First Name" />

                <asp:BoundField DataField="Last Name" HeaderText="Last Name" ReadOnly="True" 

                    SortExpression="Last Name" />

                <asp:BoundField DataField="Donation Amount" HeaderText="Donation Amount" 

                    SortExpression="Donation Amount" />

                <asp:BoundField DataField="Date of Donation" HeaderText="Date of Donation" 

                    SortExpression="Date of Donation" />

            </Columns>

        </asp:GridView>

    </p>

    <p>

        &nbsp;</p>

    <p>

        &nbsp;</p>

    <div>
 
    </div>

    </form>

</body>

</html>

Sep 24 '08 #1

Subscribe Post Reply

3387

Curtis Rutland

3,256

Expert 2GB

OK, here are some things you will need to do. First, if ID is an AutoNumber, you need to remove it from the insert command. Make sure you remove one of the '?' from the VALUES list as well. The reason you do this is because you can't insert a value into a AutoNumber field. You will also need to remove it from the <InsertParameters> section.

Next, you will need to change all the <asp:Parameter> into <asp:ControlParameter> tags in the <InsertParameters> section. There are two extra properties you must set: ControlID and PropertyName. ControlID is the control that the parameter will get it's value from. PropertyName is the property of that control that holds the value. For TextBoxes, you use the Text property. ListBoxes will usually be SelectedValue, and so on.

Here's an example of what the <InsertParameters> should look like.
Note that this is just a sample, you will have to make this fit your own program.

Expand|Select|Wrap|Line Numbers

 <InsertParameters>

    <asp:ControlParameter ControlID="tbUsername" PropertyName="Text" Name="username" Type="String" />

    <asp:ControlParameter ControlID="tbLevel" PropertyName="Text" Name="level" Type="Int16" />

</InsertParameters>

Now, you need an event handler for your button. Just double-click it in the designer. You should be taken to the codepage and a handler should be automatically set up for you.

The way to trigger an insert is to call the SqlDataSource's Insert() method.

So, in the handler that was just set up:
C# code, but VB.NET is quite similar

Expand|Select|Wrap|Line Numbers

 protected void b1_Click(object sender, EventArgs e)

{

    SqlDataSource1.Insert();

    //if you want your gridview to show the update use this:

    GridView1.DataBind();

}

Now you should have inserted a record into your DB.

Edit:
One other thing I noticed. If you want the date to auto-populate instead of having to type it in, you can add a Hidden control to the page. In the Page_Load event, you can set the Hidden's Value attribute to DateTime.Now.ToString() and use that as one of your parameters. The PropertyName would be "Value".

Hope that helps.

Sep 24 '08 #2

mturner64

Sounds great! I will give it a go and hope for the best. I appreciate your assistance. Have a great day! ~Mike

Sep 24 '08 #3

mturner64

Ths solution above works very well! A++ Thanks for the help!

Sep 28 '08 #4

by: Eric | last post by:

Hey Everyone.. I have a form that has approximately 7 text fields and 1 checkbox. Generally when this form is submitted(to itself BTW) it works fine, however, when the checkbox is only field...

ASP / Active Server Pages

Enter key will not submit the form

by: M Smith | last post by:

I have a form I want to submit to itself. I want to be able to type in a list of numbers and submit the form and have that list show up on the same form under the text box I typed them into and...

ASP / Active Server Pages

Help with Buttons on Frames in JavaScript

by: Trvl Orm | last post by:

I am working with 2 frames, Left and Right and the main code is in the left frame, which has been attached. Can someone please help me with this code. I am new to JavaScript and can't figure it...

Javascript

Quick help please with FRAMES (another question)

by: TrvlOrm | last post by:

OK. After much playing around, I managed to get my frame page this far.. see code below. BUT...there are still errors with it, and what I would like to have happened is this: 1) On the Left...

Javascript

Two submit buttons, which one was pressed?

by: actionwoman63 | last post by:

Dear all I need to be able to check which one out of two submit buttons within the same form was pressed in a javascript function prior to form submission. And before I get flamed for not...

Javascript

Adding onClick to submit button

by: Dmitry Korolyov [MVP] | last post by:

When we use btnSubmit.Attributes = "javascript: this.disabled=true;" to make the button disabled and prevent users from clicking it again while form data still posting, there is no longer...

ASP.NET

Desperately need help to setup with asp net !!

by: pamelafluente | last post by:

I am beginning aspNet, I know well win apps. Need a simple and schematic code example to start work. This is what I need to accomplish: ---------------------- Given button and a TextBox on a...

ASP.NET

4.01 Compliance Help

by: aljamala | last post by:

Hi, I keep getting this warning on a page, but I do not know what the problem is...does anyone have an idea about what could be wrong? line 88 column 7 - Warning: missing </formbefore <td> it...

HTML / CSS

submit() not defined? WTF?

by: The Natural Philosopher | last post by:

I am coding up a bit of javascript stuff, and have managed to stumble my way through most of what I want.. But this one has got me stumped. I call submit() and get a javascript error 'Submit...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

AI Job Threat for Devs

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

Career Advice

ASP.NET, Help, submit button onClick write to database question.

Similar topics