how insert data in table

paste ur storeprocedure  insertproduct and also table structure where u want to insert data.

House_p table

insert product SP

ALTER procedure [dbo].[insertproduct]
@Name nvarchar(30),@Model nvarchar(30),@Behcode nvarchar(10)
,@price nvarchar(30),@Classification  nvarchar(30),@Description nvarchar(max),@subset nvarchar(30)
,@id int
as
begin
Declare @H_name nvarchar(30)
set @H_name =(select H_name from House_info where behcode=@Behcode )
update House_p set Name=@Name,Model=@Model,Description=@Description,Price=@price,Classification=@Classification,subset=@subset,Date=GETDATE(),H_name=@H_name
where BehCode=@Behcode and ID=@id
end

ofcourse this SP update column

this SP is for when users uploadimage

when they upload image their image save to table after that if they  click on ImageButton2 their other information update to where they insert their image

now i want if users don't upload any image it insert other information in table

for that u have to modified ur two sp like,

alter procedure [dbo].[Fileup1] @image1 varbinary(MAX), @behcode nvarchar(10),
@id int AS BEGIN IF @id > 0BEGINUPDATE [image]SET Image1 =@image1,
behcode = @behcodeWHERE iD = @id SELECT 0ENDELSEBEGIN
insert into image (Image1,behcode)values (@image1,@behcode)
SELECT SCOPE_IDENTITY()ENDEND

and

ALTER procedure [dbo].[insertproduct] @Name nvarchar(30),@Model nvarchar(30)
,@Behcode nvarchar(10),@price nvarchar(30),@Classification  nvarchar(30)
,@Description nvarchar(max),@subset nvarchar(30) ,@id int  AS BEGIN 
Declare @H_name nvarchar(30) set @H_name =(select H_name from House_info where behcode=@Behcode ) 
IF @id > 0BEGINUPDATE House_p SET Name=@Name,Model=@Model
,Description=@Description,Price=@price,Classification=@Classification
,subset=@subset,Date=GETDATE(),H_name=@H_name WHERE BehCode=@Behcode and ID=@id 
SELECT 0ENDELSEBEGININSERT INTO House_p(
ID,Name,Model,Price,Classification,subset,[Date],H_name,BehCode)VALUES(
@id,@Name,@Model,@price,@Classification ,@subset ,GETDATE(),@H_name,@Behcode)
SELECT SCOPE_IDENTITY()ENDEND

and ur code get id by using ExecuteScalar and set this id in ViewState

this error occur

ould not find stored procedure 'Fileup11'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.  Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'Fileup11'. Source Error: 

Line 217:        
Line 218:
Line 219: _cmd.ExecuteNonQuery(); Line 220:        ViewState["Id"] = _cmd.Parameters["@id"].Value.ToString();
Line 221:        _cn.Close();

and other thing that in fileup1 SP instead of image table i wrote HOuse_p table where users insert information in insertproduct SP

modified ur code like,

protected void ImageButton2_Click1(object sender, ImageClickEventArgs e)
   {
       string data = Server.UrlDecode(Request.QueryString["BehCode3"]);
      
       
 
       string price = RadioButton2.Checked ? TextBox1.Text : "noprice";
       SqlCommand _cmd = new SqlCommand("insertproduct", _cn);
       _cmd.CommandType = CommandType.StoredProcedure;
       _cn.Open();
 
       _cmd.Parameters.AddWithValue("@Name", txtname.Text);
       _cmd.Parameters.AddWithValue("@Model", txtmodel.Text);
       _cmd.Parameters.AddWithValue("@Description", CKEditorControl1.Text);
       _cmd.Parameters.AddWithValue("@Price", price);
 
       _cmd.Parameters.AddWithValue("@Classification", DDL1.SelectedItem.Text);
       _cmd.Parameters.AddWithValue("@subset", DDL1.SelectedItem.Text);
       _cmd.Parameters.AddWithValue("@behcode", data);
 _cmd.Parameters.AddWithValue("@id",Convert.ToInt32(ViewState["Id"]));  
  Int ID = Convert.ToInt32(_cmd.ExecuteScalar());
    If(ID>0)
{
       ViewState["Id"]= ID.ToString(); 
}
       _cn.Close();
       Response.Redirect(Request.Url.AbsoluteUri);
   }

protected void BtnUpload1_Click(object sender, EventArgs e)
  {
  
      string path = Server.MapPath(".") + "\\../image/House\\";
  
      string[] validext = { ".jpg", ".gif", ".png", ".rar" };
      string ext =
          System.IO.Path.GetExtension(AsyncFileUpload1.PostedFile.FileName);
      if (Array.IndexOf(validext, ext.ToLower()) < 0)
      {
          lblMessage.Text = "please enter correct format";
          return;
      }
  
  
      string filename = System.IO.Path.GetFileName(fup1.PostedFile.FileName);
  
  
      while (System.IO.File.Exists(path + "\\" + filename))
          filename = "1" + filename;
  
       
  
  
      if (fup1.HasFile)
      {
          try
          {
     
              if (fup1.PostedFile.ContentLength < 105000)
              {
                
                  fup1.PostedFile.SaveAs(Server.MapPath("~/Upload") + System.IO.Path.DirectorySeparatorChar + AsyncFileUpload1.PostedFile.FileName);
  
                    
                  Label20.Text = "File " + fup1.PostedFile.FileName + " uploaded successfully.";
              }
              else
              {
                    
                  Label20.Text = "File size of " + Convert.ToString(fup1.PostedFile.ContentLength / 1024) + " KB is exceeding the uploading limit.";
              }
          }
          catch (Exception ex)
          {
              // error message
              Label20.Text = "Some problem occurred while uploading the file. Please try after some time.";
          }
      }
      else
      {
          // warning message
          Label20.Text = "Please choose a file to upload.";
      }
  
      fup1.PostedFile.SaveAs(path + filename);
  
      SqlCommand _cmd = new SqlCommand("Fileup4", _cn);
      _cmd.CommandType = CommandType.StoredProcedure;
      string data = Server.UrlDecode(Request.QueryString["BehCode3"]);
  
      _cn.Open();
      _cmd.Parameters.AddWithValue("@image2", fup1.FileBytes);
      _cmd.Parameters.AddWithValue("@Behcode", data);
 	_cmd.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
          Int ID = Convert.ToInt32(_cmd.ExecuteScalar());
    If(ID>0)
{
       ViewState["Id"]= ID.ToString(); 
}
      _cn.Close();  
  
  
  }