Click here to Skip to main content
15,884,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hello if you can help me or advise me something
i have table named droducts;
insert into products values('a1',45,'ds','C:\Documents and Settings\AdministratorDesktop\1454251_5.jpg');

and i want to see my datas in my datagridviewer1
but there is errot it shows evry row except image and there is error.
my code is
C#
************************************
private DataSet ds = new DataSet();

        private DataTable dt = new DataTable();
        private DataSet dss = new DataSet();
        private DataTable dtt = new DataTable();
********************************

                NpgsqlCommand command = connection.CreateCommand();
                NpgsqlDataReader Reader;
                connection.Open();
                string commanda = "SELECT * FROM products";

                NpgsqlDataAdapter da = new NpgsqlDataAdapter(commanda, conn);

                ds.Reset();
                da.Fill(ds);
                dt = ds.Tables[0];
                dataGridView2.DataSource = dt;


please hepl me...
Posted
Updated 20-Mar-12 4:30am
v3

Well, you are saving the image path to the database and not the image itself. When the data comes back from the database to fill the adapter, it is just a string with the path, and has no idea that it is supposed to be an image.
 
Share this answer
 
aha it is clear... but what do i can in order to do this? i want image in my datagrid... which will be in my database...:(
 
Share this answer
 
v3

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900