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

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

Answers (5)