using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;

public partial class Default4 : System.Web.UI.Page
{
    SqlConnection db = new SqlConnection("database=bank;server=.;uid=sa");
    protected void Page_Load(object sender, EventArgs e)
    {
        Panel1.Visible = false;
    }
    
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (CheckBox1.Checked)
        {

            Panel1.Visible = true;
            Label1.Text = CheckBox1.Text;
            
           
        }

        if (CheckBox2.Checked)
        {

            Panel1.Visible = true;
            Label1.Text = CheckBox2.Text;


        }

        if (CheckBox3.Checked)
        {

            Panel1.Visible = true;
            Label1.Text = CheckBox3.Text;


        }
        if (CheckBox4.Checked)
        {

            Panel1.Visible = true;
            Label1.Text =CheckBox4.Text;


        }
    }
    
    
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (RadioButton1.Checked)
        {
            TextBox3.Text = RadioButton1.Text;

        }
        else
            if (RadioButton2.Checked)
            {
                TextBox3.Text = RadioButton2.Text;
            }
        if (FileUpload1.HasFile) return;
        byte[] binary = new byte[FileUpload1.PostedFile.ContentLength];
        binary = FileUpload1.FileBytes;
        SqlParameter param = null;

        
        SqlCommand cmd = new SqlCommand("Sp_Loan",db);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@fathername",TextBox1.Text);
        cmd.Parameters.AddWithValue("@mothername",TextBox2.Text);
        cmd.Parameters.AddWithValue("@ms",TextBox3.Text);
        cmd.Parameters.AddWithValue("@occupation",DropDownList1.Text);
        param = new SqlParameter("@docname", SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "",
            DataRowVersion.Default, FileUpload1.FileName);
        param = new SqlParameter("@document", SqlDbType.Image);
        param.Direction = ParameterDirection.Input;
        param.Value = binary;
        cmd.Parameters.Add(param);
        param= new SqlParameter("@doctype",SqlDbType.NVarChar,50,ParameterDirection.Input,false,0,0,"",
             DataRowVersion.Default,FileUpload1.PostedFile.ContentType);
        cmd.Parameters.Add(param);
        cmd.Parameters.AddWithValue("@address",TextBox4.Text);
        cmd.Parameters.AddWithValue("@zipcode", TextBox7.Text);
        cmd.Parameters.AddWithValue("@phone", TextBox5.Text);
        cmd.Parameters.AddWithValue("@mobile", TextBox6.Text);
        db.Open();
        cmd.ExecuteNonQuery();
        Label2.Text = "success";

    }
}

sql query

select * from loans

create proc Sp_Loan
@fathername varchar(50),@mothername varchar(50),@ms varchar(50),@occupation varchar(50),@docname nvarchar(50),@document image, @doctype nvarchar(50),
@address varchar(50),@zipcode int,@phone varchar(50),@mobile varchar(50)
as
begin
insert into loans values(@fathername,@mothername,@ms,@occupation,@docname,@document,@doctype,@address,@zipcode,@phone,@mobile)
end
go

I don't have solution; but I observed @docname parameter is created but not added to cmd.Parameters collection. I would expect error but different one.
please mark thread solved if this helps

Hi Padtes,

Thanx for reply,
but i got a question here cos filr upload being a single component and how is it possible for docname doctype and doccument to be in cmd.parameters?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.