mortezasar
یک شنبه 13 اسفند 1391, 16:04 عصر
سلام من میخوام فایل پی دی اف رو توی دیتا بیسم ذخیره کنم اما این خطا رو میده
لطفا راهنمایی کنید
سلام واسه ذخیره از این کد استفاده کردم
FileStream fs = File.OpenRead(txtaddres.Text);
byte[] fileData = new byte[fs.Length];
fs.Read(fileData, 0, fileData.Length);
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=COPY_CENTER;Integrated Security=True");
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string sql =
"Insert BOOK (cat_id,tech_id,name,price,data)";
sql += "values ({0},{1},'{2}',{3},{4}) ";
sql = string.Format(sql,
catid,
techid,
txtjozname.Text.Trim(),
txtprice.Text.Trim(),
fileData);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
100807
متن اروری هم که میده اینه
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
Incorrect syntax near ''.
لطفا راهنمایی کنید
سلام واسه ذخیره از این کد استفاده کردم
FileStream fs = File.OpenRead(txtaddres.Text);
byte[] fileData = new byte[fs.Length];
fs.Read(fileData, 0, fileData.Length);
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=COPY_CENTER;Integrated Security=True");
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string sql =
"Insert BOOK (cat_id,tech_id,name,price,data)";
sql += "values ({0},{1},'{2}',{3},{4}) ";
sql = string.Format(sql,
catid,
techid,
txtjozname.Text.Trim(),
txtprice.Text.Trim(),
fileData);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
100807
متن اروری هم که میده اینه
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
Incorrect syntax near ''.