.Net with Us: April 2012

Monday, April 30, 2012

Display Different Image in Gridview From Database on Condition

Here I have created a table in which a column stores the image name of a product. Ex: I am saving a product details with its image name. And also created a Image folder in my application where I have stored the physical image file.I am only displaying the image in form load.

Table Design

ProductID int
ProductName varchar(50)
ProductImage varchar(50)

Table With Data

1	Samsung	samsung01.jpg
2	LG	lg01.jpg
NULL	NULL	NULL

Design View( Source Code)

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="FrmGridViewStatus.aspx.cs" Inherits="FrmGridViewStatus" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<table class="style1">
<tr>
<td>
 </td>
</tr>
<tr>
<td>
 </td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" Width="370px"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="id" HeaderText="ID" />
<asp:BoundField DataField="name" HeaderText="Name" />
<asp:TemplateField HeaderText="Photo">
<ItemTemplate>

<asp:Image ID="Image1" runat="server" ImageUrl='<%#GetImage(Eval("ProductImage").ToString())%>' Width="100" Height="100"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td>
 </td>
</tr>
<tr>
<td>
 </td>
</tr>
</table>
</asp:Content>

C# Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class FrmGridViewStatus : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;

protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
getData();
}

}
private void getData()
{
try
{

con.Open();
cmd = new SqlCommand("select ProductID,ProductName,ProductImage from product",con);
dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
con.Close();

}
catch(Exception ex)
{
}

}
public string GetImage(string ProductImage )
{
string ImgURl = "";
if (ProductImage != null)
{
ImgURl="~/Images/"+ProductImage ;
}
else{

}
return ImgURl;
}
}

Fill Multiple GridView using DataReader Batch Select Statement

Design (Source Code)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="FrmDataReaderMultipleSelect.aspx.cs" Inherits="FrmDataReader" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 100%;
}
.style2
{
color: #FF0066;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<table class="style1">
<tr>
<td class="style2">
Fill Grid View using DataReader Multiple Select statement
</td>
</tr>
<tr>
<td>
<asp:GridView ID="GridViewLedger" runat="server">
</asp:GridView>
</td>
</tr>
<tr>
<td>
 </td>
</tr>
<tr>
<td>
<asp:GridView ID="GridViewDemo" runat="server">
</asp:GridView>
</td>
</tr>
<tr>
<td>
 </td>
</tr>
<tr>
<td>
<asp:GridView ID="GridViewParty" runat="server">
</asp:GridView>
</td>
</tr>
</table>

</div>
</form>
</body>
</html>

C# code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

public partial class FrmDataReader : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;

protected void Page_Load(object sender, EventArgs e)
{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
SelectData();

}
private void SelectData()
{
try
{
con.Open();

using (cmd = new SqlCommand("select top(10) ledgerid,ledgername from fms.fms_ledgers;select * from fms_demo;select * from fms.fms_parties", con))
{

// in case of multiple result set you will not be able to specify the CommandBehavior
// if so you will not be able to get the next result set from the reader

using (SqlDataReader reader = cmd.ExecuteReader())
{
// bind the first resultset
GridViewLedger.DataSource = reader;
GridViewLedger.DataBind();

reader.NextResult();

// bind the second resultset
GridViewDemo.DataSource = reader;
GridViewDemo.DataBind();

reader.NextResult();

// bind the third resultset
GridViewParty.DataSource = reader;
GridViewParty.DataBind();

}

}

}
catch (Exception ex)
{
string x = ex.Message.ToString();
}
finally
{
con.Close();
}
}
}