Display imgs in gridview img name in mysql and img in folder

Question

I want to display the images in gridveiw with particular id. Images are saved in server folder and I saved their names in MySql database.... someone please help me......................

Saineshwar Bageri · Answer

Imagepath =  URL  + s.StdImgName // check this helps you or not

shubham bhardwaj · Answer

Here you are ..... Saineshwar Bageri Sir Please check it if (ObjCourseInfoModelRecordlist[0].CourseId.ToString() !=  || ObjCourseInfoModelRecordlist[0].CourseId.ToString() != string.Empty) { var Result = (from s in ObjStudentInfoModelRecordList join t in ObjCourseInfoModelRecordlist on Convert.ToInt32(s.CourseId) equals t.CourseId orderby s.StudentId descending select new { s.StudentId s.EnrollmentNo s.StudentName s.F_H_Name PhoneNo = s.StuContactNo Course = t.CourseName SubCourse = t.SubCourse s.StdImgName }); grdOldAdmission.DataSource = Result.ToArray(); grdOldAdmission.DataBind(); }

Saineshwar Bageri · Answer

Can you show linq code shubham bhardwaj sir

shubham bhardwaj · Answer

Thanks........... Saineshwar Bageri Sir But still i am having problem. because i m using Linq to bind the grid veiw data and if i am passing image name then it is showing this name on grid that i don't want to show see image of grid view below.... and here is my design page code Width=100% OnPageIndexChanging=grdOldAdmission_PageIndexChanging OnRowCommand=grdOldAdmission_RowCommand> --%>  CommandName=EditRecord Height=20px ImageUrl=~/Images/edit1.jpg OnClientClick=return confirm('Are you sure you want to Edit this Record!') ToolTip=Edit This Record Width=20px />  CommandName=ViewRecord Height=20px ImageUrl=~/Images/view.png OnClientClick=onView_Click() ToolTip=View This Record Width=20px />  CommandName=DeleteRecord Height=20px ImageUrl=~/Images/DeleteIcon.png OnClientClick=return confirm('Are you sure you want to Delete this Record!') ToolTip=Delete This Record Width=20px />  CommandName=PrintRecord Height=20px ImageUrl=~/Images/print.jpg OnClientClick=return confirm('Are you sure you want to Print this Record!') ToolTip=Print This Record Width=20px /> / ' width=100px height=100px /> Height=80px Width=80px />--%>

Saineshwar Bageri · Answer

First thing you will retrive records based on id from database. in that you will have images name. after that just check your hosted site or localhost site Url. And check like this Path for your images should be :- localhost:1380/ ImagesfolderName / ImageName :- http://www.c-sharpcorner.com/ ImagesfolderName / ImageName ( hosted site )  runat=server /> Or from Sql while bring path just concate path to your Image Name DECLARE @ImageName varchar(50) DECLARE @imagepath varchar(50) SET @ImageName ='Image.jpeg' set @imagepath = 'http://www.c-sharpcorner.com/' + @ImageName SELECT @imagepath Mark as answer if i helped you