hi
I have one button=btnInsert and one fileupload=fuppdf that accept *.pdf files control in my page
below is Btninsert click event
protected void BtnInsert_Click1(object sender, ImageClickEventArgs e)
{
string path = Server.MapPath(".") + "\\../image/House/article/pdf\\";
string filename = System.IO.Path.GetFileName(fuppdf.PostedFile.FileName);
string[] validext = { ".pdf" };
string ext = System.IO.Path.GetExtension(fuppdf.PostedFile.FileName);
if (Array.IndexOf(validext, ext.ToLower()) < 0)
{
lblpdf.Text = "please insert *.pdf files";
return;
}
while (System.IO.File.Exists(path + "\\" + filename))
{
filename = "1" + filename;
}
SqlCommand _cmd = new SqlCommand("Fileuppdf", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
string data = Server.UrlDecode(Request.QueryString["BehCode"]);
_cn.Open();
_cmd.Parameters.AddWithValue("@pdf", filename);
_cmd.Parameters.AddWithValue("@Behcode", data);
_cmd.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
object o = _cmd.ExecuteScalar();
int ID = (o != null && o != DBNull.Value) ? Convert.ToInt32(o) : 0;
if (ID > 0)
{
ViewState["Id"] = ID.ToString();
if (fuppdf.HasFile)
{
try
{
if (fuppdf.PostedFile.ContentLength < 102400)
{
fuppdf.PostedFile.SaveAs(Server.MapPath("~/image/house/article/image") + System.IO.Path.DirectorySeparatorChar + fuppdf.PostedFile.FileName);
lblpdf.Text = "your file insert succesfully.";
}
}
}
else
{
lblpdf.Text = "Please choose a file to upload.";
}
fuppdf.PostedFile.SaveAs(path + filename);
}
_cn.Close();
SqlCommand _cmd1 = new SqlCommand("insertarticle", _cn);
_cmd1.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd1.Parameters.AddWithValue("@Name", txtarticle.Text);
_cmd1.Parameters.AddWithValue("@Description", CKEditorControl1.Text);
_cmd1.Parameters.AddWithValue("@behcode", data);
_cmd1.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
_cmd1.Parameters.Add("@Result", SqlDbType.NVarChar, 120);
_cmd1.Parameters["@Result"].Direction = ParameterDirection.Output;
object o1 = _cmd1.ExecuteScalar();
int ID1 = (o1 != null && o1 != DBNull.Value) ? Convert.ToInt32(o1) : 0;
if (ID1 > 0)
{
ViewState["Id"] = ID1.ToString();
}
ViewState["Id"] = null;
}
Now problem is that I should select file from fileupload control untill it insert other data in database I mean if I don't select file from fileupload control it doesn't run btninsert click event...
I want if I select or don't select file from file upload control it insert other data in database...
Best Regards
Neda