Save file location in SQL server

Accepted 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('"', '-').Replace('"', '-');

SaveFileName = "\\" + Title + ".aspx";

Directory.CreateDirectory(root + "\\post\\" + Title);

SaveFilePath = root + "\\post\\" + Title + SaveFileName;

Application["storablepathindb"] = "http://www.domain.com/post/" + Title + SaveFileName;

0

Valon Ademi15y ago

Thanks... Abhimanyu Kumar Vatsa

0

Jaganathan Bantheswaran15y ago

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.

0