PDA

View Full Version : ارتباط با بانک access



ehsan79917
شنبه 09 دی 1391, 19:16 عصر
این چه مشکلی داره؟Excutenonquery خطا میده.

string PicUrl = @"~/Upload/" + FileUpload1.FileName;

FileUpload1.SaveAs(Server.MapPath(PicUrl));



string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|database1.mdb";



OleDbConnection conObj = new OleDbConnection(connectionString);



string commandObj = "INSERT INTO picture(pic)value('@pic')";



OleDbCommand cmdObj = new OleDbCommand(commandObj, conObj);

cmdObj.Parameters.AddWithValue(

"@pic", PicUrl);

conObj.Open();

cmdObj.ExecuteNonQuery();

conObj.Close();

}