C#

public class RootObject
{
    public List<Responsemsg> response { get; set; }
}

...

RootObject responseData;
using (var stream = new StreamReader(response.GetResponseStream()))
{
    responseData = JsonConvert.DeserializeObject<RootObject>(stream.ReadToEnd());
}

foreach (var item in responseData.response)
{
    ...
}

C:\WSmfgIT\WSmfgIT\WSmfgIT\wsmfgit\wsmfgit\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction

@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf"

@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf"

Member 12016106 wrote:

Server.MapPath(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename)

Server.MapPath("~/workinstruction/pdf/" + filename)

FileUpload1.SaveAs(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename);

Member 12016106 wrote:

cmd.Parameters.AddWithValue(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf", filename);

cmd.Parameters.AddWithValue("@Path", @"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf");

An exception of type 'System.InvalidOperationException' occurred in MySql.Data.dll but was not handled in user code

Additional information: Connection must be valid and open.

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Diagnostics;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;


namespace wsmfgit
{
    public partial class workinstruction : System.Web.UI.Page

    {

        /// <connect DB>
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                this.BindGrid();
            }
        }
        private void BindGrid()
        {
            string constr = @"Data Source=192.168.8.124; Database=pmdb; User ID=client; Password=client";
            using (MySqlConnection con = new MySqlConnection(constr))
            {
                using (MySqlCommand cmd = new MySqlCommand("SELECT ID, FileName, FileView FROM work_inst"))
                {
                    using (MySqlDataAdapter sda = new MySqlDataAdapter())
                    {
                        cmd.Connection = con;
                        sda.SelectCommand = cmd;
                        using (DataTable dt = new DataTable())
                        {
                            sda.Fill(dt);
                            workinstruc.DataSource = dt;
                            workinstruc.DataBind();
                        }
                    }
                }
            }
        }
        ///</connect>
        /// <link to home button>
        protected void imgbtn_home_Click(object sender, ImageClickEventArgs e)
        {
            Response.Redirect("default.aspx");
        }

        protected void btn_upload_Click(object sender, EventArgs e)
        {
            string constr = @"Data Source=192.168.8.124; Database=pmdb; User ID=client; Password=client";
            using (MySqlConnection con = new MySqlConnection(constr))
            {
            string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
            FileUpload1.SaveAs(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename);
            con.Open();
            MySqlCommand cmd = new MySqlCommand("insert into work_inst(FileName,FileView) values(@Name,@Path)");

            cmd.Parameters.AddWithValue("@FileName", filename);
            cmd.Parameters.AddWithValue("@Path", @"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf");
            cmd.ExecuteNonQuery();
            Response.Write("Pdf File Save in Database");
            con.Close();
            BindGrid();
            }
        }
        /// </link>


    }
}

<GridViewColumn x:Name="GridViewColumnTotal" Header="Total" Width="100">
    <GridViewColumn.CellTemplate>
       <DataTemplate>
           <TextBlock Text="{Binding Total}" TextAlignment="Right" FontWeight="ExtraBold"/>
       </DataTemplate>
    </GridViewColumn.CellTemplate>
</GridViewColumn>

<GridViewColumn.CellTemplate>