how to retieve images from database to grid

Question

0.00/5 (No votes)

See more:

This is my code.
DataSet ds = new DataSet("CpnyLgo");
byte[] MyData = new byte[0];
sda.Fill(ds, "CpnyLgo");
DataRow myRow;
myRow = ds.Tables["CpnyLgo"].Rows[0];
MyData = (byte[])myRow["CompanyLogo"];
MemoryStream stream = new MemoryStream(MyData);
picturebox1.Image=Image.Fromstream(stream);

This code is to upload the image in picturebox and i need to upload the images in grid.
I have uploaded the rest value by using this code:

C#

int i = 0;//intialises i=0
                while(QbReader1.Read())//reading the values

                    {
                        radGridView1.Rows.AddNew();//should add new row
                        //string iStr = QbReader1["CompanyName"].ToString();

                        radGridView1.Rows[i].Cells[0].Value = QbReader1["CompanyName"].ToString();
                        radGridView1.Rows[i].Cells[1].Value = Image.FromStream(stream);
                        radGridView1.Rows[i].Cells[2].Value = QbReader1["State"].ToString();
                        radGridView1.Rows[i].Cells[3].Value = QbReader1["Country"].ToString();
                        radGridView1.Rows[i].Cells[4].Value = QbReader1["WebsiteAddress"].ToString();
                        i++;
                    }



                QbReader1.Close();

Please Anyone who know the answer help me ............

Posted 20-Aug-15 20:10pm

Member 11889312

Add a Solution

Comments

Sinisa Hajnal 21-Aug-15 2:29am

I hope you have checks and balances in your code and that this is just short version :p

Not sure about radgrid, but DataGridView has image column type which in turn has property Image which you can set. Since you already know how to create an image from datarow column, I don't see the problem. Just check exact details for radgrid.

Member 11889312 21-Aug-15 4:37am

but i need to code it?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2015-08-20T20:46:00

Solution 1

Really, it would not be so good to answer a question which has been asked so many times: http://www.codeproject.com/search.aspx?q=%28%22.NET%22+OR+%22C%23%22%29+database+%28image+OR+images+OR+bitmap+OR+bitmaps%29&doctypeid=1%3b5[^].

—SA

Posted 20-Aug-15 20:46pm

Sergey Alexandrovich Kryukov

Comments

Member 11889312 21-Aug-15 5:15am

what is bitmap

Sergey Alexandrovich Kryukov 21-Aug-15 10:44am

All I can reply in response would be "have a great day!"
Is it so difficult to find out on the Web, say, Wikipedia...
—SA

Member 11889312 · Answer 2 · 2015-08-21T19:49:00

hi

I get the solution.....

DataSet ds = new DataSet("CpnyLgo");
byte[] MyData = new byte[0];
sda.Fill(ds, "CpnyLgo");
DataRow myRow;
myRow = ds.Tables["CpnyLgo"].Rows[0];
MemoryStream stream = new MemoryStream(MyData);
picturebox1.Image=Image.Fromstream(stream);

<pre lang="cs">int i = 0;//intialises i=0
while(QbReader1.Read())//reading the values

{
radGridView1.Rows.AddNew();//should add new row
//string iStr =

MemoryStream stream = new MemoryStream(MyData);
picturebox1.Image=Image.Fromstream(stream);
QbReader1["CompanyName"].ToString();

radGridView1.Rows[i].Cells[0].Value = QbReader1["CompanyName"].ToString();
radGridView1.Rows[i].Cells[1].Value = Image.FromStream(stream);
radGridView1.Rows[i].Cells[2].Value = QbReader1["State"].ToString();
radGridView1.Rows[i].Cells[3].Value = QbReader1["Country"].ToString();
radGridView1.Rows[i].Cells[4].Value = QbReader1["WebsiteAddress"].ToString();
i++;
}

QbReader1.Close();
</pre>