save only path of file in SQL DB

Where do you want to keep the selected file physically?
In current project directory or in a sub-directory .
If current directory : Server.MapPath("~/") or
Server.MapPath("~/subfoldername") can be used

Thanks,
Sanjay

Sanoop, if this helps please login to Mark As Answer. | Alert Moderator

can any one post the code for saving only path of video file in DB

Sanoop, if this helps please login to Mark As Answer. | Alert Moderator

#region
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter da;
DataSet ds;
string a, b, c, d;
#endregion
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
if (!IsPostBack)
{
bind();
}
}
void bind()
{
da = new SqlDataAdapter("select * from demoimg", con);
ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string[] aa = Guid.NewGuid().ToString().Split('-');
string[] bb = FileUpload1.FileName.Split('.');
string cc = aa[0] +"."+ bb[1];
FileUpload1.PostedFile.SaveAs(Server.MapPath("saveimg\\" + cc));
cmd = new SqlCommand("insert into demoimg values(@a,@b)", con);
cmd.Parameters.AddWithValue("@a", TextBox1.Text);
cmd.Parameters.AddWithValue("@b", cc);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

}
bind();
}

Sanoop, if this helps please login to Mark As Answer. | Alert Moderator

IT COULD BE LIKE THIS
THANKS REGARDS
(AVDESH)

Sanoop, if this helps please login to Mark As Answer. | Alert Moderator