download multiple images into a folder from listview

Abdu Abdul

I am displaying multiple images in listview from database and is working fine, the problem am having is when ever I wan't to download multiple selected images into any folder on my desktop computer, only one image is downloaded not multiple selected images : check my codes

FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
if (folderBrowserDialog.ShowDialog() == DialogResult.OK) {
if (listView1.Items.Count > 0) {
listView1.FocusedItem = listView1.Items[0];
listView1.Items[0].Selected = true;
listView1.Select();
SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM [gallery]", connect);
cmd.CommandType = CommandType.Text;
connect.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read()) {
byte[] bytes = (byte[]) sdr["Data"];
string fileName = sdr["Name"].ToString();
string path = Path.Combine(folderBrowserDialog.SelectedPath, fileName);
File.WriteAllBytes(path, bytes);
}
connect.Close();
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Mohanty5y ago
Hi,
Try this.
if (listView1.Items.Count > 0) {
for(i=0; i< listView1.Items.Count; i++)
{
listView1.FocusedItem = listView1.Items[i];
listView1.Items[i].Selected = true;
listView1.Select();

SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM [gallery]", connect);
cmd.CommandType = CommandType.Text;
connect.Open();

SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read()) {
  byte[] bytes = (byte[]) sdr["Data"];
  string fileName = sdr["Name"].ToString();
  string path = Path.Combine(folderBrowserDialog.SelectedPath, fileName);
  File.WriteAllBytes(path, bytes);
}
connect.Close();
}
}
Abdu Abdul5y ago
I have tried that but is still not working, thank you for your answer.....!
Piyush Pansuriya5y ago
Hi,

As per the code, you have to use for loop for multiple download.
if (listView1.Items.Count > 0) {
for(i=0; i< listView1.Items.Count; i++)
{
listView1.FocusedItem = listView1.Items[i];
listView1.Items[i].Selected = true;
}
listView1.Select();
SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM [gallery]", connect);
cmd.CommandType = CommandType.Text;
connect.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read()) {
byte[] bytes = (byte[]) sdr["Data"];
string fileName = sdr["Name"].ToString();
string path = Path.Combine(folderBrowserDialog.SelectedPath, fileName);
File.WriteAllBytes(path, bytes);
}
connect.Close();
}
May be it works..