Save file location in SQL server

Question

Hi... I have used fileupload control to save file in different location in computer. I want to store the location(path) in my SQL server database. How can i do this?

Abhimanyu K Vatsa · Answer

try this String root = Server.MapPath(~); string SaveFilePath = ; string SaveFileName = ; string Title = ID.ToString() + - + txtTitle.Text.Replace(' ' '-').Replace('.' '-').Replace('#' '-').Replace('%' '-').Replace('&' '-').Replace('*' '-').Replace('@' '-').Replace('!' '-').Replace('|' '-').Replace(':' '-').Replace(';' '-').Replace('' '-').Replace('/' '-').Replace('\' '-').Replace('?' '-').Replace(' ' '-').Replace('' '-').Replace('' '-').Replace('' '-'); SaveFileName = \ + Title + .aspx; Directory.CreateDirectory(root + \post\ + Title); SaveFilePath = root + \post\ + Title + SaveFileName; Application[storablepathindb] = http://www.domain.com/post/ + Title + SaveFileName;

Valon Ademi · Answer

Thanks... Abhimanyu Kumar Vatsa

Jaganathan Bantheswaran · Answer

hi You might be knowing how to save string values into database. as like other string just take the file path and save it to the database.