Click here to Skip to main content
15,885,998 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Windows Form :

Error :

I create a Windows Form , whenever I Submit the form , Its Gave me an error

Code :


using System;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;

namespace WindowsFormsApplication12
{
public partial class Add : Form
{string connectionString = @"Data Source=AMAR;Initial Catalog=Test;Integrated Security=True";

    public Add()
    {
        InitializeComponent();
    }



    private void PhoneNo_KeyPress(object sender, KeyPressEventArgs e)
    {
        char ch = e.KeyChar;
        if (!Char.IsDigit(ch) && ch != 8)
        {
            e.Handled = true;
        }
    }

    private void Pin_KeyPress(object sender, KeyPressEventArgs e)
    {
        char ch = e.KeyChar;
        if (!Char.IsDigit(ch) && ch != 8)
        {
            e.Handled = true;
        }
    }


    private void cancel_Click(object sender, EventArgs e)
    {
        this.Close();
    }

    private void Submit_Click(object sender, EventArgs e)
    {


        string Stat = Status.Text;
        string FirstName = FName.Text;
        string LastName = LName.Text;
        string Address=Addr.Text;
         string Cities=City.Text;
    string States= State.Text;
     string  Countries =Country.Text;
    string  PhoneNos= PhoneNo.Text;;
     string  EmailId= Email.Text;
     string PinCode=Pin.Text;
     string CIn=CheckIn.Text;
     string  COut=CheckOut.Text;
     string  AdultNo=Adult.Text;
     string  ChildNo=Child.Text;
      string InfantNo=Infant.Text;
      string RoomNos=RoomNo.Text;


        TestObject obj = new TestObject();

        obj.Stat=Status.Text;
        obj.FirstName = FName.Text;
        obj.LastName = LName.Text;
        obj.Address=Addr.Text;
         obj.Cities=City.Text;
    obj.States= State.Text;
     obj.Countries =Country.Text;
    obj.PhoneNos= PhoneNo.Text;;
     obj.EmailId= Email.Text;
     obj.PinCode=Pin.Text;
     obj.CIn=CheckIn.Text;
     obj.COut=CheckOut.Text;
     obj.AdultNo=Adult.Text;
     obj.ChildNo=Child.Text;
      obj.InfantNo=Infant.Text;
      obj.RoomNos=RoomNo.Text;


        string spName = "Insert";
        SqlConnection conn = new SqlConnection(connectionString);
        SqlCommand com = new SqlCommand(spName, conn);
        conn.Open();
        com.Parameters.AddWithValue("@Stat", obj.Stat);
    com.Parameters.AddWithValue("@FirstName", obj.FirstName);
        com.Parameters.AddWithValue("@LastName", obj.LastName);
        com.Parameters.AddWithValue("@Address", obj.Address);
        com.Parameters.AddWithValue("@Cities", obj.Cities);
        com.Parameters.AddWithValue("@States", obj.States);
        com.Parameters.AddWithValue("@Countries", obj.Countries);
        com.Parameters.AddWithValue("@PhoneNos", obj.PhoneNos);
        com.Parameters.AddWithValue("@EmailId", obj.EmailId);
        com.Parameters.AddWithValue("@PinCode", obj.PinCode);
        com.Parameters.AddWithValue("@CIn", obj.CIn);
        com.Parameters.AddWithValue("@COut", obj.COut);
        com.Parameters.AddWithValue("@AdultNo", obj.AdultNo);
        com.Parameters.AddWithValue("@ChildNo", obj.ChildNo);
        com.Parameters.AddWithValue("@InfantNo", obj.InfantNo);
        com.Parameters.AddWithValue("@RoomNos", obj.RoomNos);

        com.CommandType = CommandType.StoredProcedure;


        com.ExecuteNonQuery();
        conn.Close();
    }

    }


public class TestObject
{
    public string Id;
    public string Status;
    public string FName;
    public string LName;
    public string Addr;
    public string City;
    public string State;
    public string  Country;
    public string  PhoneNo;
    public string  Email;
    public string Pin;
    public string CheckIn;
    public string  CheckOut;
    public string  AdultNo;
    public string  ChildNo;
     public string InfantNo;
     public string RoomNo;




public  string FirstName { get; set; }
public  string LastName { get; set; }
public  string Address { get; set; }
public  string States { get; set; }
public  string Countries { get; set; }
public  string Cities { get; set; }
public  string PhoneNos { get; set; }
public  string EmailId { get; set; }
public  string PinCode { get; set; }
public  string CIn { get; set; }
public  string COut { get; set; }
public  string RoomNos { get; set; }
public  string Stat { get; set; }}



}



SQL Store Procedure CODE :

SQL
USE [Hotel]
GO
/****** Object:  StoredProcedure [dbo].[Insert]    Script Date: 03/23/2015        21:40:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Insert] 

@Stat nvarchar(100),
    @FirstName nvarchar(100),
        @LastName nvarchar(100),
        @Address nvarchar(100),

        @Cities nvarchar(100),

        @States nvarchar(100),
       @Countries nvarchar(100),
       @PhoneNos int,
        @EmailId nvarchar(100),
        @PinCode int,
       @CIn nvarchar(100),
       @COut nvarchar(100),
        @AdultNo int,
        @ChildNo int,
        @InfantNo int, 
        @RoomNos int
 AS
BEGIN
SET NOCOUNT ON;

-- Insert statements for procedure here
INSERT INTO [Hotel].[dbo].[Details]
          (Status,FirstName,LastName,Address,City,State,Country,PhoneNo,CheckIn,CheckOut,EmailId,Pincode,AdultNo,ChildNo,InfantNo,RoomNo)


 VALUES
       (@Stat,@FirstName,@LastName,@Address,@Cities,@States,@Countries,@PhoneNos,@EmailId,@PinCode,@CIn,@COut,@AdultNo,@ChildNo,@InfantNo,@RoomNos)
END
Posted
Updated 24-Mar-15 0:45am
v2
Comments
Sergey Alexandrovich Kryukov 24-Mar-15 0:49am    
What is that beast, "ASP.NET Windows Forms"?
—SA
ZurdoDev 24-Mar-15 7:44am    
Just a quick glance shows that the number of parameters is the same, unless I missed something. That means you must be pointing to a different db then what you are looking at.
Richard Deeming 24-Mar-15 9:00am    
"Insert" is a very bad name for a stored procedure.
Stephen Hewison 24-Mar-15 9:04am    
The following are out of order in your SQL:

CheckIn,CheckOut,EmailId,Pincode
@EmailId,@PinCode,@CIn,@COut
ZurdoDev 24-Mar-15 11:15am    
The order is not relevant since they are named.

[Edit] Sorry, I see that you mean in the actual Insert statement. Correct. Good catch. [/Edit]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900