How to get only filename without path in FileUpload Control

Saranya,

Try this

if(FileUploader1.HasFile)
 {
    string filename = FileUploader1.PostedFile.FileName.ToString();
 }
   connectionstring();
   SqlConnection con = new SqlConnection(str);
   con.Open();
   SqlCommand cmd = new SqlCommand("Excel", con);
   cmd.CommandType = CommandType.StoredProcedure;
   cmd.Parameters.Add("@ExcelName", SqlDbType.VarChar).Value = filename;
   cmd.ExecuteNonQuery();
   con.Close();

Thanks,
SP

Hi,

use FileName property of the FileUpload control. try like below.

if (FileUpload1.HasFile)
{
    connectionstring();
    SqlConnection con = new SqlConnection(str);
    con.Open();
    SqlCommand cmd = new SqlCommand("Excel", con);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add("@ExcelName", SqlDbType.VarChar).Value = FileUpload1.FileName;
    cmd.ExecuteNonQuery();
    con.Close();
}

refer FileUpload Class[^]
FileUpload.FileName Property[^]

hope it helps.

Here goes:

string fileName = @"C:\mydir\myfile.ext";
string result = System.IO.Path.GetFileName(fileName);

Cheers,
Edo

Use this

connectionstring();
        SqlConnection con = new SqlConnection(str);
        con.Open();
        SqlCommand cmd = new SqlCommand("Excel", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@ExcelName", SqlDbType.VarChar).Value = FileUpload1.FileName;
        cmd.ExecuteNonQuery();
        con.Close();

https://bluegraydaily.com/page/84/?cPage&categoryid=0&enPn=5&hsId=1757957190&imageSize=Medium&live=true&m=whole&nextPage=true&numPerPage=5&paymentType=paypal&paypalEmail=sunnyslope5211%40aol.com&productName&siteUrl=http%3A%2F%2Fwww.bluegraydaily.com&stPn=1&storeId=165950&template&userId=7499332

string filename = fileupload.FileName;
           int index = filename.LastIndexOf("\\");
           int len = filename.Length;
           filename = filename.Substring(index+1,len-index-1);