Click here to Skip to main content
15,895,011 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)

  Print Answers RSS


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