Treeview node click retrive image from folder and imagepath

Question

hello all of u,
i create simple desktop application in c# , which I use treeview , picturebox, datagridview.

i use storeprocedure in sqlserver 2005.

i use simple query in stored procedure and when i click on treenode then releted data show in datagrid and image show in picturebox.
please help me.

my source code giveb below, and i get data in datagridview but image not show in picturebox please help me.
thank you.

What I have tried:

my stored procedure:-
1) ALTER PROCEDURE [dbo].[FatchDatafromTreeView]
@ChallanType varchar(50),
@Challan_Series_No varchar(50),
@ItemNo int

AS
BEGIN

SET NOCOUNT ON;

SELECT ItemNo,ItemCode,ItemDescription,SupplierCode,SupplierName,Unit,ItmQty,PriceQuantity,PriceUOM,PhotoId,Main_Ch_Key,Approve,Balance_Qty,InTime_Approve,ItemImage from ChallanMaster where ChallanType=@ChallanType and Challan_Series_No=@Challan_Series_No and ItemNO=@ItemNo

my c# code:-
treeview afterselect click event--

private void tv_inward_mat_chk_AfterSelect(object sender, TreeViewEventArgs e)
{
SqlConnection con = new SqlConnection(str);
con.Open();
SqlCommand cmd = new SqlCommand("FatchDatafromTreeView", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ChallanType",cmb_ChallanType.Text);
cmd.Parameters.AddWithValue("@Challan_Series_No",cmb_Challan_Series_No.Text);
cmd.Parameters.AddWithValue("@ItemNo",Convert.ToInt32(tv_inward_mat_chk.SelectedNode.Text));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt=new DataTable ();
sda.Fill(dt);
dgv_inward_mat_check.DataSource = dt;
con.Close();
}

Abhilash J A · Answer

Hello,

Just try this,

private void tv_inward_mat_chk_AfterSelect(object sender, TreeViewEventArgs e)
{
SqlConnection con = new SqlConnection(str);
con.Open();
SqlCommand cmd = new SqlCommand("FatchDatafromTreeView", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ChallanType", cmb_ChallanType.Text);
cmd.Parameters.AddWithValue("@Challan_Series_No", cmb_Challan_Series_No.Text);
cmd.Parameters.AddWithValue("@ItemNo", Convert.ToInt32(tv_inward_mat_chk.SelectedNode.Text));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
dgv_inward_mat_check.DataSource = dt;
dgv_inward_mat_check.Columns["ImageName"].IsVisible = false;
GridViewImageColumn col = new GridViewImageColumn("Image");
dgv_inward_mat_check.Columns.Add(col);
foreach (GridViewRowInfo row in dgv_inward_mat_check.Rows)
{
string path = "..\\..\\"; //here you set your path
row.Cells["Image"].Value = Image.FromFile(Path.Combine(path, row.Cells["ImageName"].Value.ToString()));
}
con.Close();
}