how can i load the images from remote server in a datatable C# winform throughs an exception of 404

Question

how can I load the images from the remote server in a data table C# windows form? I have stored only the image path in my Sqldatabase. when I am running the code it throws an exception of 404 error. same code is retriving the images on other forms

 private void Datagrid() { 
                try
                {
                    id.Text = "";
                    name.Text = "";
                    cost.Text = "";

                    price.Text = "";
                    description.Text = "";
                    status.Text = "";
                    picture.Image = null;

                    status.Items.Add("active");
                    status.Items.Add("inactive");
                    id.Visible = false;
                    label7.Text = "";
                    conn.Open();
                    MySqlCommand cm = new MySqlCommand();
                   // string query = "SELECT dealSuggestion_id,name,cost,price,description,Status from dealSuggestion where Status='inactive' LIMIT 8";
                    string query = "SELECT * from dealSuggestion where Status='inactive' LIMIT 8";

                    cm.CommandText = query;
                    cm.Connection = conn;
                    MySqlDataAdapter da = new MySqlDataAdapter(cm);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
foreach (DataRow row in dt.Rows)
                {
                    string img = row["image"].ToString();

                    if (!row.IsNull("image"))
                    {
                     ServicePointManager.Expect100Continue = true;
                        System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
                        System.Net.WebRequest request = System.Net.WebRequest.Create(row["image"].ToString());
                        System.Net.WebResponse resp = request.GetResponse();
                        System.IO.Stream respStream = resp.GetResponseStream();
                        Bitmap bmp = new Bitmap(respStream);
                        respStream.Dispose();
                        row["image"] = bmp;

                    }
                    }
                    dataGridView1.DataSource = dt;
                    conn.Close();
                }
                catch (Exception ex)
                {

                    MessageBox.Show("Error" + ex);
                }
            }

Answer 1

    Imports System 
 Imports System.Runtime.InteropServices
Imports System.Security.Principal  Imports System.Security.Permissions  Public Class Form1  <DllImport("advapi32.DLL", SetLastError:=True)> _  Public Shared Function LogonUser(ByVal lpszUsername As String, ByVal lpszDomain As String, _ 
        ByVal lpszPassword As String, ByVal dwLogonType As Integer, ByVal dwLogonProvider As Integer, _ 
        ByRef phToken As IntPtr) As Integer  End Function  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 
        Dim admin_token As IntPtr 
        Dim wid_current As WindowsIdentity = WindowsIdentity.GetCurrent() 
        Dim wid_admin As WindowsIdentity = Nothing 
        Dim wic As WindowsImpersonationContext = Nothing 
        Try 

            If LogonUser("Local Admin name", "Local computer name", "pwd", 9, 0, admin_token) <> 0 Then 
                wid_admin = New WindowsIdentity(admin_token) 
                wic = wid_admin.Impersonate() 

// inside this scope you can access remote PC please note that path shouldn't contain : instead of : use $ sign
              FileStream fs = new FileStream(imagepath, FileMode.Open, FileAccess.Read);

    //Initialize a byte array with size of stream
    byte[] imgByteArr = new byte[fs.Length];

    //Read data from the file stream and put into the byte array
    fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length));

    //Close a file stream
    fs.Close();

            Else 
               //custom message
            End If 
        Catch se As System.Exception 
            Dim ret As Integer = Marshal.GetLastWin32Error() 
            MessageBox.Show(ret.ToString(), "Error code: " + ret.ToString()) 
            MessageBox.Show(se.Message) 
        Finally 
            If wic IsNot Nothing Then 
                wic.Undo() 
            End If 
        End Try  
        End Sub  
        End Class

Try this Sir please vote if its working thank you

Answer 2

    FileStream fs = new FileStream(imagepath, FileMode.Open, FileAccess.Read);

    //Initialize a byte array with size of stream
    byte[] imgByteArr = new byte[fs.Length];

    //Read data from the file stream and put into the byte array
    fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length));

    //Close a file stream
    fs.Close();

    //assign to dt particular column imageByteArr

Hope this will help you

Answer 3

I assume that this is a foem appliaction . You can try something like this that described in this question:

 foreach (DataRow row in t.Rows)
{
                HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(row["uri"].ToString());
                myRequest.Method = "GET";
                HttpWebResponse myResponse = (HttpWebResponse)myRequest.GetResponse();
                System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(myResponse.GetResponseStream());
                myResponse.Close();

                row["Img"] = bmp;
}