INSERT data to database

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi
I am new to asp.net and have created a simple form that the user fills in and presses submit, this action is supposed to send the data they entered to my database, but its not working. I keep getting an error message saying
..."ERROR [HYT00] [MySQL][ODBC 3.51 Driver][mysqld-4.1.14-nt]Column 'firstname' cannot be null 
Below is my .aspx code...

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="test.aspx.vb" Inherits="test" %>

<!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>Untitled Page</title>

</head>

<body>

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

<div>

<table style="width: 426px">

<tr>

<td>

Category Name:</td>

<td>

<asp:TextBox ID="firstname" runat="server"></asp:TextBox></td>

<td>

</td>

</tr>

<tr>

<td>

Description:&nbsp;</td>

<td>

<asp:TextBox ID="surname" runat="server"></asp:TextBox></td>

<td>

&nbsp;<asp:Button ID="Button2" runat="server" Text="Add" /></td>

</tr>

</table>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:registerConnectionString %>"

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

SelectCommand="select firstname,surname from register" 

InsertCommand="INSERT INTO register (firstname, surname) VALUES (@firstname, @surname)" >

<InsertParameters>

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

<