RowDatabound in DataGrid
18/04/2012 09:58
protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{
//if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
int count = 0;
string id;
id = e.Item.Cells[0].Text;
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
try
{
clientcon = objDB.getClientConnection(ClientConnect);
cmd = new SqlCommand("SELECT COUNT(*) FROM [ImageQuestion] WHERE Question_id = @QuestionId", clientcon);
cmd.Parameters.Add("@QuestionId", SqlDbType.Int).Value = Convert.ToInt32(id);
count = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
clientcon.Dispose();
clientcon.Close();
Image img_q = (Image)e.Item.FindControl("Img1");
if (count == 1)
{
img_q.Visible = true;
}
else
{
img_q.Visible = false;
}
}
catch { }
}
if (e.Item.ItemType == ListItemType.EditItem)
{
try
{
clientcon = objDB.getClientConnection(ClientConnect);
cmd = new SqlCommand("SELECT COUNT(*) FROM [ImageQuestion] WHERE Question_id = @QuestionId", clientcon);
cmd.Parameters.Add("@QuestionId", SqlDbType.Int).Value = Convert.ToInt32(id);
count = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
clientcon.Dispose();
clientcon.Close();
Image img_e = (Image)e.Item.FindControl("Img2");
LinkButton lnkChage_e = (LinkButton)e.Item.FindControl("lnkChangeImage");
LinkButton lnkRemove_e = (LinkButton)e.Item.FindControl("lnkRemoveImage");
if (count == 1)
{
img_e.Visible = true;
lnkChage_e.Visible = true;
lnkRemove_e.Visible = true;
}
else
{
img_e.Visible = false;
lnkChage_e.Visible = false;
lnkRemove_e.Visible = false;
}
}
catch { }
}
}