I am trying to upload resume of user when it is giving me error of "incorrect syntax near file".
I want to upload resume of user if user has not filled his profile information and if user profile information is already in table then only update button should be visible to user and data should be filled in textbox.
protected void btnsave_Click(object sender, EventArgs e)
{
int i = 0;
string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
Stream str = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] size = br.ReadBytes((int)str.Length);
string constr = ConfigurationManager.ConnectionStrings["Q_SS_regnConnectionString1"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Insert into Job_Seeker_Profile (Name,Address,Contact,email,tenth,twelve,graduate,file,Qualification) Values (@Name,@Address,@Contact,@email,@tenth,@twelve,@graduate,@file,@Qualification)", con))
{
//cmd.Parameters.AddWithValue("@Id", Id.Value);
cmd.Parameters.AddWithValue("@Name", jsname.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@Address", txt_add.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@Contact", txt_no.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@email", txt_email.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@tenth", txt_tenth.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@twelve", txt_twelve.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@graduate", txt_graduate.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@file", size);
cmd.Parameters.AddWithValue("@Qualification", txt_quali.Text.Trim().ToString());
con.Open();
i = cmd.ExecuteNonQuery();
con.Close();
lblMessage.Text = "Saved Successfully.";
}
}
}
in this line i = cmd.ExecuteNonQuery();
CREATE TABLE [dbo].[Job_Seeker_Profile] (
[Id] INT NOT NULL,
[Name ] VARCHAR (50) NULL,
[Address] VARCHAR (50) NULL,
[Contact] VARCHAR (50) NULL,
[email] VARCHAR (50) NULL,
[tenth] VARCHAR (50) NOT NULL,
[twelve] VARCHAR (50) NOT NULL,
[graduate] VARCHAR (50) NOT NULL,
[file] varBinary(MAX) NOT NULL,
[Qualification] VARCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC) );