DotNet

Transfer values from asp to aspx

2013-10-20T00:49:00.000-07:00

<div dir="ltr" style="text-align: left;" trbidi="on">
<% dim get_ip get_ip=Request.ServerVariables("server_name") get_ip="http://"&get_ip&"/TEST/CheckFormIdentity.aspx" %> <html><script type="text/javascript">
    function PageSubmit() {
        document.frm.method = "post";
        document.frm.target = "_blank";
        document.frm.submit();
        window.history.back();
    }
</script><%
    Response.Write("<form action=""&get_ip&"" id="frm" method="post" name="frm">
")
    Response.Write(" <input name="UserId" type="hidden" u_id="" value=" & Session(" />")
    Response.Write(" <input name="FRM_Code" type="hidden" val="" value=" & Request.QueryString(" />")
    Response.Write("</form>
")
    Response.Write("<script>PageSubmit();</script>")
%>
</html></div>

Avoid confirmation message while closing web page using Javascript

2013-08-13T05:52:00.003-07:00

function closeWindow() { window.open('', '_parent'); window.close(); }

Recursive in C#

2013-07-26T06:20:00.001-07:00

A Method can call another methods but it can also call itself. When a mathod calls itself is called Recursive .　

using System.Collections.Generic;using System.Linq;using System.Text;using System;namespace InterfaceApplication{

class Program{static void Main(){

Program a = new Program();
Console.WriteLine(a.Fib(10));
Console.Read();
}

public long Fib(int n){

if (n == 0 || n == 1)return n;
return n * Fib(n - 1);}
　
　
}
}

To Check Javascript is enabled or disabled

2013-07-23T04:56:00.003-07:00

Common Class for C#

2013-07-10T09:48:00.001-07:00

using System;

using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace shajil.CommonClass{

public class Common{
public SqlConnection con = new SqlConnection(Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]));
//Escape Sequence for XML public string ConvertToXMLFormat(string xml){

if (xml != null && xml != string.Empty && xml != ""){
xml = xml.Replace(
"&", "&");xml = xml.Replace(
"\"", """);xml = xml.Replace(
"'", "'");xml = xml.Replace(
"<", "<");xml = xml.Replace(
">", ">");
return xml;}

elsereturn xml;}

//Fill Dropdown List public void FillDropdownlist(DropDownList ddl, string strTextField, string strValueField, DataTable dt){
ddl.DataSource = dt;
ddl.DataTextField = strTextField;
ddl.DataValueField = strValueField;
ddl.DataBind();
ddl.Items.Insert(0,
new ListItem("Select", string.Empty));
//if (dt.Rows.Count == 1)// ddl.SelectedValue = dt.Rows[0][0].ToString();//else// ddl.SelectedValue = string.Empty;}
//Get Data With Parameter Using Stored Procedure and Dataset.public DataSet GetData1(string procedure, string[,] Parameters){

using (SqlDataAdapter da = new SqlDataAdapter(procedure, con)){
da.SelectCommand.CommandType =
CommandType.StoredProcedure;
for (int i = 0; i < Parameters.GetLength(0); i++){
da.SelectCommand.Parameters.Add(
new SqlParameter(Parameters[i, 0], Parameters[i, 1]));}

DataSet ds = new DataSet();da.Fill(ds);

return ds;}
}

//Get Data With Parameter Using Stored Procedure nd Datatable.public DataTable GetData(string procedure, string[,] Parameters){

using (SqlDataAdapter da = new SqlDataAdapter(procedure, con)){
da.SelectCommand.CommandType =
CommandType.StoredProcedure;
for (int i = 0; i < Parameters.GetLength(0); i++){
da.SelectCommand.Parameters.Add(
new SqlParameter(Parameters[i, 0], Parameters[i, 1]));}

DataTable dt = new DataTable();da.Fill(dt);

return dt;}
}

//Get Data With Out Parameter Using Stored Procedure.public DataTable GetData(string procedure){

using (SqlDataAdapter da = new SqlDataAdapter(procedure, con)){
da.SelectCommand.CommandType =
CommandType.StoredProcedure;
DataTable dt = new DataTable();da.Fill(dt);

return dt;}
}
　

//Insert/Update/Delete Data With Parameter Using Stored Procedure.public string Insert_Update_Data(string procedure, string[,] Parameters){

//Checking the connection stateif (con.State != ConnectionState.Open)con.Open();

//Creating a command objectusing (SqlCommand ObjCom = new SqlCommand(procedure, con)){

//Command type is for stored procedure ObjCom.CommandType = CommandType.StoredProcedure;
//Passing parfor (int i = 0; i < Parameters.GetLength(0); i++){
ObjCom.Parameters.Add(
new SqlParameter(Parameters[i, 0].ToString(), Parameters[i, 1].ToString()));}

string Message = string.Empty;
if (Parameters[1, 1] == "UPDATE" || Parameters[1, 1] == "INSERT" || Parameters[1, 1] == "DELETE"){

DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(ObjCom);da.Fill(dt);

if (dt.Rows.Count > 0)Message = dt.Rows[0][0].ToString();
}

elseObjCom.ExecuteNonQuery();
if (con.State != ConnectionState.Closed)con.Close();

return Message;}
}
}
}

Nested GridView in asp.net

2013-07-10T09:41:00.003-07:00

@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default16" %><%
@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"Namespace="System.Web.UI" TagPrefix="asp" %><!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>Untitled Page</title></
head><
body><form id="form1" runat="server"><asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager><asp:UpdatePanel ID="UpdatePanel1" runat="server"><ContentTemplate><asp:GridView ID="Gridview1" runat="server" BorderStyle="Double" BorderColor="Gold" BackColor="AliceBlue" ShowFooter="true" AutoGenerateColumns="false"> <HeaderStyle BackColor="Green" Font-Bold="true" ForeColor="White" /><Columns><asp:BoundField DataField="RowNumber" HeaderText="Row Number" /><asp:TemplateField HeaderText="Main"><ItemTemplate><table><tr><td><asp:TextBox ID="txt1" runat="server"></asp:TextBox></td><td><asp:TextBox ID="txt2" runat="server"></asp:TextBox></td><td><asp:TextBox ID="txt3" runat="server"></asp:TextBox></td></tr></table><hr /><table><tr><td><asp:GridView ID="gvChildGrid" runat="server" ShowFooter="true" AutoGenerateColumns="false"BorderStyle="Double" BorderColor="#df5015" GridLines="None" Width="250px"><HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" /><RowStyle BackColor="#E1E1E1" /><AlternatingRowStyle BackColor="White" /><HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" /><Columns><asp:BoundField DataField="RowNumber" HeaderText="Row Number" /><asp:TemplateField HeaderText="sub"><ItemTemplate><table><tr><td><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td><td><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td><td><asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td><td></td></tr></table></ItemTemplate><FooterTemplate><asp:Button ID="ButtonAdd" OnClick="innergridclick" CommandName="<%# Container.DataItemIndex %>"runat="server" Text="Add inner Row" /></FooterTemplate></asp:TemplateField></Columns></asp:GridView></td></tr></table></ItemTemplate><FooterTemplate><asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" OnClick="ButtonAdd_Click" /></FooterTemplate></asp:TemplateField></Columns></asp:GridView></ContentTemplate></asp:UpdatePanel></form></
body></
html>using System;using System.Collections;using System.Configuration;using System.Data;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;public partial class Default16 : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e){

if (!Page.IsPostBack){
SetInitialRow();
}
}

private void SetInitialRow(){

DataTable dt = new DataTable();
DataRow dr = null;dt.Columns.Add(
new DataColumn("RowNumber", typeof(string)));dt.Columns.Add(
new DataColumn("Column1", typeof(string)));dt.Columns.Add(
new DataColumn("Column2", typeof(string)));dt.Columns.Add(
new DataColumn("Column3", typeof(string)));dr = dt.NewRow();
dr[
"RowNumber"] = 1;dr[
"Column1"] = string.Empty;dr[
"Column2"] = string.Empty;dr[
"Column3"] = string.Empty;dt.Rows.Add(dr);
ViewState[
"CurrentTable"] = dt;Gridview1.DataSource = dt;
Gridview1.DataBind();
SetInitialRow2();
}

private void AddNewRowToGrid(){

int rowIndex = 0;setgridviewvalues();

if (ViewState["CurrentTable"] != null){

DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
if (dtCurrentTable.Rows.Count > 0){

for (int i = 1; i <= dtCurrentTable.Rows.Count; i++){

TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("txt1");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("txt2");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("txt3");drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow[
"RowNumber"] = i + 1;dtCurrentTable.Rows[i - 1][
"Column1"] = box1.Text;dtCurrentTable.Rows[i - 1][
"Column2"] = box2.Text;dtCurrentTable.Rows[i - 1][
"Column3"] = box3.Text;rowIndex++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState[
"CurrentTable"] = dtCurrentTable;Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
}
}

else{
Response.Write("ViewState is null");}
SetPreviousData();
SetInitialRow2();
}

public void setgridviewvalues(){

if (ViewState["CurrentTable2"] != null){

DataSet dtset = (DataSet)ViewState["CurrentTable2"];
int Dtcount = dtset.Tables.Count;
for (int rowIndex = 0; rowIndex < Gridview1.Rows.Count; rowIndex++){

int rowcount = 0;
DataTable dtCurrentTable = dtset.Tables[rowIndex];
DataRow drCurrentRow = null;
GridView Grdview = (GridView)Gridview1.Rows[rowIndex].Cells[1].FindControl("gvChildGrid");
if (dtCurrentTable.Rows.Count > 0){

for (int i = 1; i <= dtCurrentTable.Rows.Count; i++){

TextBox box1 = (TextBox)Grdview.Rows[rowcount].Cells[1].FindControl("TextBox1");
TextBox box2 = (TextBox)Grdview.Rows[rowcount].Cells[1].FindControl("TextBox2");
TextBox box3 = (TextBox)Grdview.Rows[rowcount].Cells[1].FindControl("TextBox3");drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow[
"RowNumber"] = i + 1;dtCurrentTable.Rows[i - 1][
"Column1"] = box1.Text;dtCurrentTable.Rows[i - 1][
"Column2"] = box2.Text;dtCurrentTable.Rows[i - 1][
"Column3"] = box3.Text;rowcount++;
}
ViewState[
"CurrentTable2"] = dtset;}
}
}
}

private void SetPreviousData(){

int rowIndex = 0;
if (ViewState["CurrentTable"] != null){

DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 0){

for (int i = 0; i < dt.Rows.Count; i++){

TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("txt1");
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("txt2");
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("txt3");box1.Text = dt.Rows[i][
"Column1"].ToString();box2.Text = dt.Rows[i][
"Column2"].ToString();box3.Text = dt.Rows[i][
"Column3"].ToString();rowIndex++;
}
}
}
}

protected void ButtonAdd_Click(object sender, EventArgs e){
AddNewRowToGrid();
}

protected void innergridclick(object sender, EventArgs e){

Button b1 = (Button)sender;
GridViewRow gRow = (GridViewRow)b1.Parent.Parent.Parent.Parent.Parent.Parent;
int Rindex = gRow.RowIndex;AddNewRowToGrid2(Rindex);
}

private void SetInitialRow2(){

DataSet dtset;
if (ViewState["CurrentTable2"] != null){
dtset = (
DataSet)ViewState["CurrentTable2"];
int Dtcount = dtset.Tables.Count;}

else{
dtset = new DataSet();}

DataTable dt = new DataTable();
DataRow dr = null;dt.Columns.Add(
new DataColumn("RowNumber", typeof(string)));dt.Columns.Add(
new DataColumn("Column1", typeof(string)));dt.Columns.Add(
new DataColumn("Column2", typeof(string)));dt.Columns.Add(
new DataColumn("Column3", typeof(string)));dr = dt.NewRow();
dr[
"RowNumber"] = 1;dr[
"Column1"] = string.Empty;dr[
"Column2"] = string.Empty;dr[
"Column3"] = string.Empty;dt.Rows.Add(dr);
dtset.Tables.Add(dt);
ViewState[
"CurrentTable2"] = dtset;
int rowIndex = 0;
for (rowIndex = 0; rowIndex < Gridview1.Rows.Count; rowIndex++){

DataTable dtCurrentTable = dtset.Tables[rowIndex];
GridView Grdview = (GridView)Gridview1.Rows[rowIndex].Cells[1].FindControl("gvChildGrid");Grdview.DataSource = dtCurrentTable;
Grdview.DataBind();
SetPreviousData2(rowIndex);
}
}

private void AddNewRowToGrid2(int rowIndex){

int rowcount = 0;
if (ViewState["CurrentTable2"] != null){

DataSet dtset = (DataSet)ViewState["CurrentTable2"];
int Dtcount = dtset.Tables.Count;
DataTable dtCurrentTable = dtset.Tables[rowIndex];
DataRow drCurrentRow = null;
GridView Grdview = (GridView)Gridview1.Rows[rowIndex].Cells[1].FindControl("gvChildGrid");
if (dtCurrentTable.Rows.Count > 0){

for (int i = 1; i <= dtCurrentTable.Rows.Count; i++){

TextBox box1 = (TextBox)Grdview.Rows[rowcount].Cells[1].FindControl("TextBox1");
TextBox box2 = (TextBox)Grdview.Rows[rowcount].Cells[1].FindControl("TextBox2");
TextBox box3 = (TextBox)Grdview.Rows[rowcount].Cells[1].FindControl("TextBox3");drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow[
"RowNumber"] = i + 1;dtCurrentTable.Rows[i - 1][
"Column1"] = box1.Text;dtCurrentTable.Rows[i - 1][
"Column2"] = box2.Text;dtCurrentTable.Rows[i - 1][
"Column3"] = box3.Text;rowcount++;
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState[
"CurrentTable2"] = dtset;Grdview.DataSource = dtCurrentTable;
Grdview.DataBind();
}
}

else{
Response.Write("ViewState is null");}
SetPreviousData2(rowIndex);
}

private void SetPreviousData2(int dTindex){

int rowIndex = 0;
if (ViewState["CurrentTable2"] != null){

DataSet dset = (DataSet)ViewState["CurrentTable2"];
DataTable dt = dset.Tables[dTindex];
if (dt.Rows.Count > 0){

GridView Grdview = (GridView)Gridview1.Rows[dTindex].Cells[1].FindControl("gvChildGrid");
for (int i = 0; i < dt.Rows.Count; i++){

TextBox box1 = (TextBox)Grdview.Rows[rowIndex].Cells[1].FindControl("TextBox1");
TextBox box2 = (TextBox)Grdview.Rows[rowIndex].Cells[1].FindControl("TextBox2");
TextBox box3 = (TextBox)Grdview.Rows[rowIndex].Cells[1].FindControl("TextBox3");box1.Text = dt.Rows[i][
"Column1"].ToString();box2.Text = dt.Rows[i][
"Column2"].ToString();box3.Text = dt.Rows[i][
"Column3"].ToString();rowIndex++;
}
}
}
}
}

Simple Delegete Example in C#

2013-06-29T07:08:00.002-07:00

using

System;

using

System.Collections.Generic;

using

System.Linq;

using

System.Text;

namespace

ConsoleApplication1

{

public delegate void delegate_sajil();

class Program

{

public static void sajil()

{

Console.WriteLine("I Called One Delegate!");

Console.ReadLine();

}

static void Main(string[] args)

{

delegate_sajil obj = new delegate_sajil(sajil);

obj();

}

Row Wise Summary in Gridview Asp.net

2013-06-18T01:46:00.002-07:00

protected void gvdashboard_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow){

DataRowView drv = (DataRowView)e.Row.DataItem;

if (tmpCategoryName1 != drv["Description"].ToString()){
tmpCategoryName1 = drv[
"Description"].ToString();

// Get a reference to the current row's Parent, which is the Gridview (which happens to be a table)

Table tbl = e.Row.Parent as Table;
if (tbl != null){

GridViewRow row = new GridViewRow(-1, -1, DataControlRowType.DataRow, DataControlRowState.Normal);
TableCell cell = new TableCell();
// Span the row across all of the columns in the Gridview//cell.ColumnSpan = this.GridView1.Columns.Count;cell.ColumnSpan = 10;

// cell.Width = Unit.Percentage(100);cell.Height = Unit.Percentage(100);
// cell.Width = Unit.Percentage(100);cell.Style.Add("font-family", "verdana");cell.Style.Add(
"font-size", "11px");cell.Style.Add(
"font-weight", "bold");cell.Style.Add(
"color", "#FFF");cell.Style.Add(
"background-color", "#5A83C3");cell.Style.Add(
"text-align", "Left");

DataTable GetCount = new DataTable();GetCount = (
DataTable)ViewState["Gvdashboard"];
object sumObject;

sumObject = GetCount.Compute(

"Count(Description)", "Description = '" + tmpCategoryName1+ "'");

GetCount.Dispose();

HtmlGenericControl span = new HtmlGenericControl("span");span.InnerHtml = tmpCategoryName1 +
"-(" + sumObject + ")";cell.Controls.Add(span);

row.Cells.Add(cell);

tbl.Rows.AddAt(tbl.Rows.Count - 1, row);

}

Nullable Types in c#

2013-06-08T04:51:00.002-07:00

int? Stock=null;

int Units = Stock ?? 0;

Checklist box and radio button validatation using jquery

2013-05-29T01:44:00.001-07:00

var v = $("[id$=rdgroup]").find("input:checked").length;

if (v == 0) {alert(
'Please select atleast one group');
return false;}

var v2 = $("[id$=chkPlant]").find("input:checked").length;
if (v2 == 0) {alert(
'Please select atleast one plant');
return false;}

Select Data From Data Table

2013-05-28T23:38:00.001-07:00

DataTable dtPerson = new DataTable("Person");

DataTable dtPersonFiltered = new DataTable("PersonFiltered");dtPerson.Columns.Add(
new DataColumn("Height", typeof(int)));dtPerson.Columns.Add(
new DataColumn("Gender", typeof(char)));dtPerson.Rows.Add(170,
'F');dtPerson.Rows.Add(155,
'F');dtPerson.Rows.Add(166,
'M');dtPerson.Rows.Add(140,
'M');dtPerson.Rows.Add(180,
'M');
DataRow[] Filteredresult = dtPerson.Select("Height >= 130 AND Gender = 'M'");
if (Filteredresult.Length > 0)dtPersonFiltered = Filteredresult.CopyToDataTable();

Trriger Dropdown list event in Codebehind

2013-05-09T05:42:00.001-07:00

ddlPlant_SelectedIndexChanged(sender, e);

CSS Text box in asp.net

2013-04-07T20:57:00.000-07:00

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

<!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 id="Head1" runat="server"><title></title><style type="text/css">.tb10{
background-image: url(NewFolder1/form_bg.jpg);
background-repeat: repeat-x;
border: 1px solid #d1c7ac;
width: 230px;
color: #333333;
padding: 3px;
margin-right: 4px;
margin-bottom: 8px;
font-family: tahoma, arial, sans-serif;}

.tb11{
background-image: url(NewFolder1/Capture.PNG);
background-repeat: repeat-x;
border: 1px solid #E3EEFB;
width: 230px;
color: #333333;
padding: 3px;
margin-right: 4px;
margin-bottom: 8px;
font-family: tahoma, arial, sans-serif;}

.tb12{
background-image: url(NewFolder1/Capture.PNG);
background-repeat: repeat-x;
border: 1px solid #d1c7ac;
width: 230px;
color: #333333;
padding: 3px;
margin-right: 4px;
margin-bottom: 8px;
font-family: tahoma, arial, sans-serif;}

.tb13{
background-image: url(NewFolder1/Capture1.PNG);
background-repeat: repeat-x;
border: 1px solid #d1c7ac;
width: 230px;
color: #333333;
padding: 3px;
margin-right: 4px;
margin-bottom: 8px;
font-family: tahoma, arial, sans-serif;}

.tb14{
background-image: url(NewFolder1/Capture1.PNG);
background-repeat: repeat-x;
border: 1px solid #CCCCCC;
width: 230px;
color: #333333;
padding: 3px;
margin-right: 4px;
margin-bottom: 8px;
font-family: tahoma, arial, sans-serif;}

</style></
head><
body><form id="form1" runat="server"><div><asp:TextBox ID="Textbox1" CssClass="tb10" Text="Shajil.K" runat="server"></asp:TextBox><br /><asp:TextBox ID="Textbox2" CssClass="tb11" Text="Shajil.K" runat="server"></asp:TextBox><br /><asp:TextBox ID="Textbox3" CssClass="tb12" Text="Shajil.K" runat="server"></asp:TextBox><br /><asp:TextBox ID="Textbox4" CssClass="tb13" Text="Shajil.K" runat="server"></asp:TextBox><br /><asp:TextBox ID="Textbox5" CssClass="tb14" Text="Shajil.K" runat="server"></asp:TextBox><br /></div></form></
body></
html>

Bluk Insert and Update Using XML in SQL Server

2013-03-07T03:54:00.001-08:00

StringBuilder xmlValue = new StringBuilder();
        xmlValue.Append("<?xml version=\"1.0\" ?>");
        xmlValue.AppendFormat("<{0}>", "Root");
        xmlValue.AppendFormat("<{0}>", "HIRA_HAZARD_ACTIVITIES_DET");
        xmlValue.AppendFormat("<HazardIdentity>{0}</HazardIdentity>", ddlHazard.SelectedValue);
        xmlValue.AppendFormat("<HazardRisk>{0}</HazardRisk >", ddlRisk.SelectedValue);
        xmlValue.AppendFormat("<HazardCondition>{0}</HazardCondition>", codition);
        xmlValue.AppendFormat("<ApplicableRequire>{0}</ApplicableRequire>", objcom.ConvertToXMLFormat(txtApplicable.Text.Trim()));
        xmlValue.AppendFormat("<ipconcern>{0}</ipconcern>", ipconcern);
        xmlValue.AppendFormat("<ExistControl>{0}</ExistControl>", ddlExstingControl.SelectedValue);
        xmlValue.AppendFormat("<RiskSev>{0}</RiskSev>", ddlSev.SelectedValue);
        xmlValue.AppendFormat("<RiskPoc>{0}</RiskPoc>", ddlPoc.SelectedValue);
        xmlValue.AppendFormat("<RiskEval>{0}</RiskEval>", ddlLMHE.SelectedValue);
        xmlValue.AppendFormat("<EliminationContl>{0}</EliminationContl>", ddlElimination.SelectedValue);
        xmlValue.AppendFormat("<AddlContl>{0}</AddlContl>", ddlAdditional.SelectedValue);
        xmlValue.AppendFormat("<AssesSev>{0}</AssesSev>", ddlsev1.SelectedValue);
        xmlValue.AppendFormat("<AssesPoc>{0}</AssesPoc>", ddlpoc1.SelectedValue);
        xmlValue.AppendFormat("<AssesContl>{0}</AssesContl>", ddlLMHE1.SelectedValue);
        xmlValue.AppendFormat("<Flg>{0}</Flg>", hdnflagUpdate.Value);
        xmlValue.AppendFormat("<RowId>{0}</RowId>", Convert.ToInt16(objcom.ConvertToInt_EmptyString(hdnRowId.Value)));
        xmlValue.AppendFormat("</{0}>", "HIRA_HAZARD_ACTIVITIES_DET");
        xmlValue.AppendFormat("</{0}>", "Root");
Create PROCEDURE USP_InsertUpdate(@Plant NVARCHAR (10), @Functional NVARCHAR (10), @SubFunctional NVARCHAR (10), @DocNo NVARCHAR (20), @RevNo bigint, @CreatedBy NVARCHAR (10), @ActivityRefNo NVARCHAR (10), @xmlValue XML,@Remarks nvarchar(max), @Flag NVARCHAR (5))
AS
BEGIN



SET NOCOUNT ON

DECLARE @doc INT

EXEC sp_xml_preparedocument @doc OUTPUT, @xmlValue

SELECT
tm.HazardIdentity,
tm.HazardRisk,
tm.HazardCondition,
tm.ApplicableRequire,
tm.ipconcern,
tm.ExistControl,
tm.RiskSev ,
tm.RiskPoc,
tm.RiskEval,
tm.EliminationContl,
tm.AddlContl,
tm.AssesSev,
tm.AssesPoc,
tm.AssesContl ,
tm.Flg, tm.RowId
into #Temp_HIRA_HAZARD_ACTIVITIES_DET
FROM OPENXML (@doc, 'Root/HIRA_HAZARD_ACTIVITIES_DET', 1)
WITH (
HazardIdentity VARCHAR(MAX) 'HazardIdentity/text()',
HazardRisk VARCHAR(MAX) 'HazardRisk/text()',
HazardCondition VARCHAR(MAX) 'HazardCondition/text()',
ApplicableRequire VARCHAR(MAX) 'ApplicableRequire/text()',
ipconcern VARCHAR(MAX) 'ipconcern/text()',
ExistControl VARCHAR(MAX) 'ExistControl/text()',
RiskSev VARCHAR(MAX) 'RiskSev/text()',
RiskPoc VARCHAR(MAX) 'RiskPoc/text()',
RiskEval VARCHAR(MAX) 'RiskEval/text()',
EliminationContl VARCHAR(MAX) 'EliminationContl/text()',
AddlContl VARCHAR(MAX) 'AddlContl/text()',
AssesSev VARCHAR(MAX) 'AssesSev/text()',
AssesPoc VARCHAR(MAX) 'AssesPoc/text()',
AssesContl VARCHAR(MAX) 'AssesContl/text()' ,
Flg VARCHAR(MAX) 'Flg/text()' ,
RowId VARCHAR(MAX) 'RowId/text()'
) as tm
INSERT INTO HIRA_HAZARD_ACTIVITIES_DET(DocNo,ActRefNo,HazardIdentity,HazardRisk,HazardCondition,ApplicableRequire,ipconcern,ExistControl,RiskSev,RiskPoc,RiskEval,EliminationContl,AddlContl,AssesSev,AssesPoc,AssesContl,isActive,createBy,createDate)



(SELECT
@DocNo,
@hdrRefNoActivity,
tm.HazardIdentity,
tm.HazardRisk,
tm.HazardCondition,
tm.ApplicableRequire,
tm.ipconcern,
tm.ExistControl,
tm.RiskSev ,
tm.RiskPoc,
tm.RiskEval,
tm.EliminationContl,
tm.AddlContl,
tm.AssesSev,
tm.AssesPoc,
tm.AssesContl,
'Y',
@CreatedBy,
getdate() from
#Temp_HIRA_HAZARD_ACTIVITIES_DET as tm WHERE tm.Flg='N' and tm.RowId = '0'

)   ;

UPDATE
      HIRA_HAZARD_ACTIVITIES_DET
    SET
   HazardIdentity=tm.HazardIdentity,HazardRisk=tm.HazardRisk,HazardCondition=tm.HazardCondition,ApplicableRequire=tm.ApplicableRequire,IPConcern=tm.IPConcern,
    ExistControl=tm.ExistControl,RiskSev=tm.RiskSev,RiskPoc=tm.RiskPoc,RiskEval=tm.RiskEval,EliminationContl=tm.EliminationContl,AddlContl=tm.AddlContl,
    AssesSev=tm.AssesSev,AssesPoc=tm.AssesPoc,AssesContl=tm.AssesContl,modifyBy=@CreatedBy,modifyDate=getdate()

    FROM
     #Temp_HIRA_HAZARD_ACTIVITIES_DET as tm
    WHERE
       -- @hdrRefNoActivity=HIRA_HAZARD_ACTIVITIES_DET.ActRefNo AND
          HIRA_HAZARD_ACTIVITIES_DET.isActive='Y' AND tm.Flg='Y' AND HIRA_HAZARD_ACTIVITIES_DET.RowId =tm.RowId
END

SET NOCOUNT OFF;


END

If Condition for Gridview Rowdatabound Alternative and Edit

2013-03-07T03:46:00.004-08:00

if (e.Row.RowState == (DataControlRowState.Alternate | DataControlRowState.Edit)
|| e.Row.RowState == DataControlRowState.Edit)

Write Log File and send mail using C#

2013-02-05T19:54:00.002-08:00

#region Write Error File
        public void WriteErrorFile()
        {
            FileStream fs = null;
            if (!File.Exists(HttpContext.Current.Server.MapPath("ErrorNotepad") + "\\ErrorList.txt"))
            {
                using (fs = File.Create(HttpContext.Current.Server.MapPath("ErrorNotepad") + "\\ErrorList.txt"))
                { }
            }
            FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath("ErrorNotepad") + "\\ErrorList.txt");
            //File will get deleted Approximatly 10,000kb
            if (file.Length > 10000000)
            {
                #region Mail Sending Block (commented)
                //MailMessage newmsg;
                //MailAddress mailfrom = new MailAddress("xxxxx.com");
                //MailAddress mailto = new MailAddress("xxxxx.com");
                //newmsg = new MailMessage(mailfrom, mailto);
                //newmsg.Body = "You Have Error Message!!!";
                //Attachment att = new Attachment(HttpContext.Current.Server.MapPath("ErrorNotepad") + "\\ErrorList.txt");
                //newmsg.Attachments.Add(att);
                //SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
                //smtp.UseDefaultCredentials = false;
                //smtp.Credentials = new NetworkCredential("xxxxx", "xxxxx");
                //smtp.EnableSsl = true;
                //smtp.Send(newmsg);
                #endregion
                File.Delete(HttpContext.Current.Server.MapPath("ErrorNotepad") + "\\ErrorList.txt");
            }
            else
            { //string pagename,string functionname,string errormessage
                using (StreamWriter sw = new StreamWriter(HttpContext.Current.Server.MapPath("ErrorNotepad") + "\\ErrorList.txt", true))
                {
                    sw.WriteLine("Error Message", DateTime.Now.ToString());
                }
            }
        #endregion
        }

To Find Created Date and Modified Date in StoredProcedure in SQL

2013-01-25T23:08:00.002-08:00

SELECT create_date,modify_date,name FROM sys.objects where type = 'p'

ORDER BY modify_date DESC

To Overcome Length Problem of Textarea in Asp.net

2013-01-25T23:06:00.000-08:00

<asp:TextBox runat="server" style="overflow:hidden;" ID="txtAreaCommets" Font-Size="11px" TextMode="MultiLine" Text='<%# Bind("ProcessedRemarks") %>' Rows="2" Width="99.5%" oncopy="return false" oncut="return false" onpaste="return false" onkeypress="if (this.value.length > 250) { return false; }"></asp:TextBox>

Freeze column in html table

2012-12-02T23:32:00.002-08:00

<html>
<head>
    <title></title>
    <style>
        table
        {
            font-family: verdana;
        }
        div#AdjResultsDiv
        {
            width: 200px;
            height: 200px;
            overflow-x: scroll;
            position: relative;
            font-family: verdana;
        }
        div#AdjResultsDiv th
        {
            background-color: navy;
            font-family: verdana;
            color: white;
            position: relative;
            cursor: default;
            top: expression(document.getElementById("AdjResultsDiv").scrollTop-2); /*IE5+ only*/
            z-index: 10;
        }
        td.locked, th.locked
        {
            font-family: verdana;
            color: white;
            background-color: navy;
            position: relative;
            cursor: default;
            left: expression(document.getElementById("AdjResultsDiv").scrollLeft-2); /*IE5+ only*/
        }
        div#AdjResultsDiv th.locked, div#AdjResultsDiv td.normal
        {
            z-index: 99;
        }
    </style>
</head>
<body>
    <div id="AdjResultsDiv">
        <table border="1" style="left: 1px; top: 155px; height: 1px;" cellpadding="0px" cellspacing="0px"
            align="center">
            <tr>
                <td class="locked" style="font-weight: bold; font-size: 12px; background-color: #69a6d0;
                    font-size: 12px; color: #ffffff; height: 19px; color: White;" width="100px" align="center">
                    Colunm1
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm2
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="250px" align="center">
                    Colunm3
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm4
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm5
                </td>
            </tr>
            <tr>
                <td class="locked" style="font-weight: bold; font-size: 12px; background-color: #69a6d0;
                    font-size: 12px; color: #ffffff; height: 19px; color: White;" width="100px" align="center">
                    Colunm1
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm2
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="250px" align="center">
                    Colunm3
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm4
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm5
                </td>
            </tr>
            <tr>
                <td class="locked" style="font-weight: bold; font-size: 12px; background-color: #69a6d0;
                    font-size: 12px; color: #ffffff; height: 19px; color: White;" width="100px" align="center">
                    Colunm1
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm2
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="250px" align="center">
                    Colunm3
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm4
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm5
                </td>
            </tr>
            <tr>
                <td class="locked" style="font-weight: bold; font-size: 12px; background-color: #69a6d0;
                    font-size: 12px; color: #ffffff; height: 19px; color: White;" width="100px" align="center">
                    Colunm1
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm2
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="250px" align="center">
                    Colunm3
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm4
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm5
                </td>
            </tr>
            <tr>
                <td class="locked" style="font-weight: bold; font-size: 12px; background-color: #69a6d0;
                    font-size: 12px; color: #ffffff; height: 19px; color: White;" width="100px" align="center">
                    Colunm1
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm2
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="250px" align="center">
                    Colunm3
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm4
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm5
                </td>
            </tr>
            <tr>
                <td class="locked" style="font-weight: bold; font-size: 12px; background-color: #69a6d0;
                    font-size: 12px; color: #ffffff; height: 19px; color: White;" width="100px" align="center">
                    Colunm1
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm2
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="250px" align="center">
                    Colunm3
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm4
                </td>
                <td style="font-weight: bold; font-size: 12px; color: #ffffff; height: 19px; background-color: #69a6d0;
                    color: White;" width="100px" align="center">
                    Colunm5
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

write error message in Notepad using C#

2012-12-02T05:54:00.000-08:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Net.Mail;
using System.Net;

public partial class ErrorMessageInNotePad : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnCreateError_Click(object sender, EventArgs e)
{
try
{
throw new System.ArgumentException("Sajil Created the ErrorMessage!!!");
}
catch (Exception ex)
{
//HERE YOU CAN USE PAGE NAME,FILE NAME,MODULE NAME OR FUNCTION NAME TO IDENTIFY THE ERROR SPOT AND YOU CAN ALSO MAKE THESE CODE AS SAPARATE FUNCTION AND USE IN CACTH BLOCK.

StreamWriter sw = new StreamWriter(Server.MapPath("ErrorNotepad") + "\\ErrorList.txt", true);
sw.WriteLine("Error occurred at", DateTime.Now.ToString());
sw.WriteLine(ex.Message, DateTime.Now.ToString());
sw.Dispose();
//CODE FOR SEND MAIL THAT NOTEPAD
MailMessage newmsg;
MailAddress mailfrom = new MailAddress("xxxxx.com");
MailAddress mailto = new MailAddress("xxxxx.com");
newmsg = new MailMessage(mailfrom, mailto);

newmsg.Body ="You Have Error Message!!!";

Attachment att = new Attachment(Server.MapPath("ErrorNotepad") + "\\ErrorList.txt");

newmsg.Attachments.Add(att);
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential("xxxxx", "xxxxx");
smtp.EnableSsl = true;
smtp.Send(newmsg);

}
}
}
POST COMMENT IF ITS USEFULL,HAPPY CODING.....

how to get previous page value in asp.net

2012-11-28T00:36:00.001-08:00

In First Page
--------------
   protected void btn_Click(object sender, EventArgs e)
    {
           //hnd is the hidden field
            hdn.Value = "sajil";
            Server.Transfer("SecondPage.aspx", true);
     }
In second Page
--------------
You can get this hdn value in the second page using the code below

   protected void Page_Load(object sender, EventArgs e)
{
   HiddenField txt = (HiddenField)Page.PreviousPage.FindControl("hdn");
  Response.Write(txt.Value);
  }

printing problem

2012-11-24T23:51:00.000-08:00

getting paper wasted in top

ref:secont picture paper get wasted like this

Highlight Gridview Row When CheckBox is Checked using javascript

2012-11-19T09:03:00.000-08:00

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

<!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>
<script type="text/javascript">
function CheckClick(obj) {
//Get the Row based on checkbox order
var row = obj.parentNode.parentNode;
if (obj.checked) {
//If checked change color to Red
row.style.backgroundColor = "Red";
}
else {
row.style.backgroundColor = "white";
}
//Get the reference of GridView
var GridView = row.parentNode;

//Get all input elements in Gridview
var inputList = GridView.getElementsByTagName("input");

for (var i = 0; i < inputList.length; i++) {
//The First element is the Header Checkbox
var headerCheckBox = inputList[0];

//Based on all or none checkboxes
//are checked check/uncheck Header Checkbox
var checked = true;
if (inputList[i].type == "checkbox" && inputList[i] != headerCheckBox) {
if (!inputList[i].checked) {
checked = false;
break;
}
}
}
headerCheckBox.checked = checked;

}
function checkAll(objRef) {
var GridView = objRef.parentNode.parentNode.parentNode;
var inputList = GridView.getElementsByTagName("input");
for (var i = 0; i < inputList.length; i++) {
//Get the Cell To find out ColumnIndex
var row = inputList[i].parentNode.parentNode;
if (inputList[i].type == "checkbox" && objRef != inputList[i]) {
if (objRef.checked) {
row.style.backgroundColor = "Red";
inputList[i].checked = true;
}
else {
row.style.backgroundColor = "white";
inputList[i].checked = false;
}
}
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="sm" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel runat="server" ID="up">
<ContentTemplate>
<div>
<asp:GridView ID="gvBank" runat="server">
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
<Columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkHeader" runat="server" onclick="checkAll(this);" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkChild" runat="server" onclick="CheckClick(this)" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>

Highlight Gridview Row When CheckBox is Checked in Asp.Net and C#

2012-11-19T08:20:00.003-08:00

In this article I will explain how to highlight gridview rows when checkbox is checked or selected in asp.net using C#
ASPX page:

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

<!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>

</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="sm" runat="server" ></asp:ScriptManager>
<asp:UpdatePanel runat="server" ID="up">
<ContentTemplate>
<div>
<asp:GridView ID="gvBank" runat="server">
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
<Columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkHeader" runat="server"
oncheckedchanged="chkHeader_CheckedChanged" AutoPostBack="true"/>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkChild" runat="server"
oncheckedchanged="chkChild_CheckedChanged" AutoPostBack="true" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</form>
</body>
</html>

C#:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using MySql.Data.MySqlClient;

using System.Configuration;

using System.Data;

public partial class GridviewCheckBox : System.Web.UI.Page

{

MySqlConnection con = new MySqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());

MySqlCommand cmd = new MySqlCommand();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DataSet ds = new DataSet();

MySqlDataAdapter ada = new MySqlDataAdapter("SELECT Bank_Nam,STR_TO_DATE(cre_dt,'%m/%d/%Y %T') as CreatedDate,STR_TO_DATE(Mod_dt,'%m/%d/%Y %T') as ModifiedDate,Cre_by,Mod_by FROM bank order by Bank_Nam", con);

ada.Fill(ds);

gvBank.DataSource = ds.Tables[0];

gvBank.DataBind();

}

protected void chkChild_CheckedChanged(object sender, EventArgs e)

{

CheckBox checkbox = (CheckBox)sender;

GridViewRow gdrow = (GridViewRow)checkbox.NamingContainer;

if (((CheckBox)gdrow.FindControl("chkChild")).Checked)

gdrow.BackColor = System.Drawing.Color.Red;

else

gdrow.BackColor = System.Drawing.Color.Transparent;

}

protected void chkHeader_CheckedChanged(object sender, EventArgs e)

{

foreach (GridViewRow rw in gvBank.Rows)

{

CheckBox chkBx = (CheckBox)rw.FindControl("chkChild");

if (chkBx != null && chkBx.Checked)

gvBank.BackColor = System.Drawing.Color.Transparent;

else

gvBank.BackColor = System.Drawing.Color.Gold;

}

Show tooltip in Asp.net Dropdownlist items Mouse over Event in C#

2012-11-11T09:56:00.001-08:00

Here I going to explain how to show tooltip in dropdownlist items on mouseover event in asp.nt using C#

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.Configuration;

using System.Data;

public partial class ToolTip_in_DropDown_ListItem : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Binddropdown();

}

protected void Binddropdown()

{

con.Open();

SqlCommand cmd = new SqlCommand("select EmpNam from Employee", con);

cmd.ExecuteNonQuery();

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

ddl.DataSource = ds;

ddl.DataTextField = "EmpNam";

ddl.DataValueField = "EmpNam";

ddl.DataBind();

}

protected void ddl_DataBound(object sender, EventArgs e)

{

DropDownList ddl = sender as DropDownList;

if(ddl.Text!=null)

{

foreach (ListItem listItem in ddl.Items)

{

listItem.Attributes["title"] = listItem.Text;

//or you can use this

// item.Attributes.Add("Title", listItem.Text);

}

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

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

</head>

<body>

<div>

<asp:DropDownList runat="server" ID="ddl" ondatabound="ddl_DataBound" ></asp:DropDownList>

</center>

</div>

</form>

</body>

</html>