My Table in the Database is not inserting the data from a form. Here is the code for the Table,
CREATE TABLE [dbo].[aspnet_UserGen] (
[UserGenId] UNIQUEIDENTIFIER NOT NULL,
[FamilyName] CHAR (100) NOT NULL,
[FirstName] CHAR (100) NULL,
[MiddleName1] CHAR (100) NULL,
[MiddleName2] CHAR (100) NULL,
[MiddleName3] CHAR (100) NULL,
[Gender] CHAR (15) NOT NULL,
[DOB] DATE NOT NULL,
[COB] CHAR (100) NULL,
[SOB] CHAR (100) NULL,
[COOB] CHAR (100) NULL,
[Newsletter] CHAR (10) NULL,
[DateTimeGen] DATETIME NOT NULL,
CONSTRAINT [PK_aspnet_UserGen] PRIMARY KEY CLUSTERED ([UserGenId] ASC)
);
Here the Code for the Store Procedure,
CREATE PROCEDURE [dbo].[aspnet_Addgen]
@FamilyName char(100),
@FirstName char(100),
@MiddleName1 char (100),
@MiddleName2 char(100),
@MiddleName3 char(100),
@Gender char(15),
@DOB Date,
@COB char (100),
@SOB char(100),
@COOB char(100),
@Newsletter char(15),
@DateTimeGen DateTime,
@UserGenId uniqueidentifier OUTPUT
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO dbo.aspnet_UserGen (FamilyName, FirstName, MiddleName1, MiddleName2, MiddleName3, Gender, DOB, COB, SOB, COOB, Newsletter, DateTimeGen, UserGenId)
VALUES (@FamilyName, @FirstName, @MiddleName1, @MiddleName2, @MiddleName3, @Gender, @DOB, @COB, @SOB, @COOB, @Newsletter, @DateTimeGen, @UserGenId)
END
Here is the code for the aspx.cs,
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
public partial class _Default : System.Web.UI.Page
{
protected void Continue_Click(object sender, EventArgs e)
{
String strConnString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "aspnet_Addgen";
cmd.Parameters.Add("@FamilyName", SqlDbType.Char).Value = FamilyName.Text.Trim();
cmd.Parameters.Add("@FirstName", SqlDbType.Char).Value = FirstName.Text.Trim();
cmd.Parameters.Add("@MiddleName1", SqlDbType.Char).Value = MiddleName1.Text.Trim();
cmd.Parameters.Add("@MiddleName2", SqlDbType.Char).Value = MiddleName2.Text.Trim();
cmd.Parameters.Add("@MiddleName3", SqlDbType.Char).Value = MiddleName3.Text.Trim();
cmd.Parameters.Add("@Gender", SqlDbType.Char).Value = GenderList.Text.Trim();
cmd.Parameters.Add("@DOB", SqlDbType.Date).Value = DOB.Text.Trim();
cmd.Parameters.Add("@COB", SqlDbType.Char).Value = COB.Text.Trim();
cmd.Parameters.Add("@SOB", SqlDbType.Char).Value = SOB.Text.Trim();
cmd.Parameters.Add("@COOB", SqlDbType.Date).Value = COOB.Text.Trim();
cmd.Parameters.Add("@Newsletter", SqlDbType.Char).Value = NewletterDownList.Text.Trim();
cmd.Parameters.Add("@DateTimeGen", SqlDbType.DateTime).Value = DateTime.Now.ToString();
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
lblMessage.Text = "Record inserted successfully";
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
}
Can anyone help me with this?
Thanks
AS