my use a 3 FileUpload, I am want one filupload was empty when I press the save button
This error message
Could not find a part of the path 'D:\plp\resource\Pengelolaan\'.
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.IO.DirectoryNotFoundException: Could not find a part of the path 'D:\plp\resource\Pengelolaan\'.
Source Error:
| Line 63: if (FileUpload2.PostedFile != null) Line 64: { Line 65: FileUpload2.SaveAs(Server.MapPath("~/resource/Pengelolaan/") + fileName2); Line 66: } Line 67: if (FileUpload3.PostedFile != null) |
Francis SusaimichaelPosted Feb 5, 2015, 4:29 AM
string fileName1=string.Empty;
string fileName2 = string.Empty;
string fileName3 = string.Empty;
if (FileUpload1.HasFile)
fileName1 = Path.GetFileName(FileUpload1.FileName);
if (FileUpload2.HasFile)
fileName2 = Path.GetFileName(FileUpload2.FileName);
if (FileUpload3.HasFile)
fileName3 = Path.GetFileName(FileUpload3.FileName);
if (!String.IsNullOrEmpty(fileName1) && FileUpload1.PostedFile != null)
{
FileUpload1.SaveAs(Server.MapPath("~/resource/Pembentukan/") + fileName1);
}
if (!String.IsNullOrEmpty(fileName2) && FileUpload2.PostedFile != null)
{
FileUpload2.SaveAs(Server.MapPath("~/resource/Pengelolaan/") + fileName2);
}
if (!String.IsNullOrEmpty(fileName2) && FileUpload3.PostedFile != null)
{
FileUpload3.SaveAs(Server.MapPath("~/resource/Retribusi/") + fileName3);
}
string Queryinsert = "INSERT INTO tbl_peraturan (propinsi_id,kabupaten_id,sektor_id,namafile1,namafile2,namafile3,perda_pembentukan,perda_pengelolaan,perda_retribusi)" +
" VALUES(@propinsi_id,@kabupaten_id,@sektor_id,@namafile1,@namafile2,@namafile3,@perda_pembentukan,@perda_pengelolaan,@perda_retribusi)";
using (MySqlConnection con = new MySqlConnection(strConnString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = Queryinsert;
cmd.Parameters.AddWithValue("@propinsi_id", cmbprovinsi.Text);
cmd.Parameters.AddWithValue("@kabupaten_id", cmbkabupaten.Text);
cmd.Parameters.AddWithValue("@sektor_id", cmbsektor.Text);
cmd.Parameters.AddWithValue("@namafile1", fileName1);
cmd.Parameters.AddWithValue("@namafile2", fileName2);
cmd.Parameters.AddWithValue("@namafile3", fileName3);
cmd.Parameters.AddWithValue("@perda_pembentukan", "resource/Pembentukan/" + fileName1);
cmd.Parameters.AddWithValue("@perda_pengelolaan", "resource/Pengelolaan/" + fileName2);
cmd.Parameters.AddWithValue("@perda_retribusi", "resource/Retribusi/" + fileName3);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
lblerror.Text = "Data Tidak dapat Di Simpan.!!!" + ex;
}
finally
{
Response.Redirect(Request.Url.AbsoluteUri, true);
con.Close();
//
}
}
}
Francis SusaimichaelPosted Feb 5, 2015, 7:59 AM
hothorasman panjaitanPosted Feb 5, 2015, 5:06 AM
hothorasman panjaitanPosted Feb 5, 2015, 3:56 AM
Francis SusaimichaelPosted Feb 5, 2015, 3:49 AM
hothorasman panjaitanPosted Feb 5, 2015, 2:56 AM
protected void btnsimpan_Click(object sender, EventArgs e)
{
string fileName1 = Path.GetFileName(FileUpload1.FileName);
string fileName2 = Path.GetFileName(FileUpload2.FileName);
string fileName3 = Path.GetFileName(FileUpload3.FileName);
if (FileUpload1.PostedFile != null)
{
FileUpload1.SaveAs(Server.MapPath("~/resource/Pembentukan/") + fileName1);
}
if (FileUpload2.PostedFile != null)
{
FileUpload2.SaveAs(Server.MapPath("~/resource/Pengelolaan/") + fileName2);
}
if (FileUpload3.PostedFile != null)
{
FileUpload3.SaveAs(Server.MapPath("~/resource/Retribusi/") + fileName3);
}
string Queryinsert = "INSERT INTO tbl_peraturan (propinsi_id,kabupaten_id,sektor_id,namafile1,namafile2,namafile3,perda_pembentukan,perda_pengelolaan,perda_retribusi)" +
" VALUES(@propinsi_id,@kabupaten_id,@sektor_id,@namafile1,@namafile2,@namafile3,@perda_pembentukan,@perda_pengelolaan,@perda_retribusi)";
using (MySqlConnection con = new MySqlConnection(strConnString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = Queryinsert;
cmd.Parameters.AddWithValue("@propinsi_id", cmbprovinsi.Text);
cmd.Parameters.AddWithValue("@kabupaten_id", cmbkabupaten.Text);
cmd.Parameters.AddWithValue("@sektor_id", cmbsektor.Text);
cmd.Parameters.AddWithValue("@namafile1", fileName1);
cmd.Parameters.AddWithValue("@namafile2", fileName2);
cmd.Parameters.AddWithValue("@namafile3", fileName3);
cmd.Parameters.AddWithValue("@perda_pembentukan", "resource/Pembentukan/" + fileName1);
cmd.Parameters.AddWithValue("@perda_pengelolaan", "resource/Pengelolaan/" + fileName2);
cmd.Parameters.AddWithValue("@perda_retribusi", "resource/Retribusi/" + fileName3);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
lblerror.Text = "Data Tidak dapat Di Simpan.!!!" + ex;
}
finally
{
Response.Redirect(Request.Url.AbsoluteUri, true);
con.Close();
//
}
}
}
}
Francis SusaimichaelPosted Feb 5, 2015, 2:39 AM
hothorasman panjaitanPosted Feb 4, 2015, 9:41 PM
Vithal WadjePosted Feb 4, 2015, 1:15 PM