asp.net corner

Sunday, February 8, 2009

Find IP Address in ASP.NET

string strIPAddress = "";

if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != "" && Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null)

strIPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

else if (Request.ServerVariables["REMOTE_ADDR"] != "" && Request.ServerVariables["REMOTE_ADDR"] != null)

strIPAddress = Request.ServerVariables["REMOTE_ADDR"];

Response.Write("Your IP " + strIPAddress);

Thursday, February 5, 2009

Serial number column in a Gridview at runtime

It will give you serial number Automatic increment at Run time

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:TemplateField HeaderText="S.No">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

Thursday, January 29, 2009

slide show in java script(image changing)

<html>
<head>
<script language="JavaScript1.1">

var slidespeed=2500
var slideimages=new Array("theatre1.jpg","theatre2.jpg","theatre3.jpg", "theatre4.jpg","theatre5.jpg","theatre6.jpg","theatre7.jpg","theatre8.jpg")

var newwindow=0 //open links in new window? 1=yes, 0=no
var imageholder=new Array()
var ie=document.all
for (i=0;i<slideimages.length;i++)
{
imageholder[i]=new Image()
imageholder[i].src=slideimages[i]
}
function gotoshow()
{
if (newwindow)
window.open(slidelinks[whichlink])
else
window.location=slidelinks[whichlink]
}
//-->
</script>
</head>
<body bgcolor="#AF5996">

<a href="javascript:gotoshow()"><img src="theatre1.jpg" name="slide" border=0 style="filter:blendTrans(duration=3)" width=180 height=200 align="center"></a>

<script language="JavaScript1.1">

</script>
</body>
</html>

Monday, January 26, 2009

Data List Paging

IN ASPX File:

IN ASPX.CS:

SqlConnection con = new SqlConnection("Server=PAT105;Database=LimataWeb;User ID=sa;Password=acconline;");
PagedDataSource pds = new PagedDataSource();

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}

public int CurrentPage
{
get
{
if (this.ViewState["CurrentPage"] == null)
return 0;
else
return Convert.ToInt16(this.ViewState["CurrentPage"].ToString());
}
set
{
this.ViewState["CurrentPage"] = value;
}
}
private void BindGrid()
{
string sql = "Select * from [Transaction] Order By N_TransactionID";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
da.Fill(dt);

pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
//pds.PageSize = Convert.ToInt16(ddlPageSize.SelectedValue);
pds.PageSize = Convert.ToInt16("5");
pds.CurrentPageIndex = CurrentPage;
lnkbtnNext.Enabled = !pds.IsLastPage;
lnkbtnPrevious.Enabled = !pds.IsFirstPage;

dlCountry.DataSource = pds;
dlCountry.DataBind();
}

protected void ddlPageSize_SelectedIndexChanged(object sender, EventArgs e)
{
CurrentPage = 0;
BindGrid();
}

protected void lnkbtnNext_Click1(object sender, EventArgs e)
{
CurrentPage += 1;
BindGrid();
}
protected void lnkbtnPrevious_Click1(object sender, EventArgs e)
{
CurrentPage -= 1;
BindGrid();
}

Friday, January 23, 2009

Pop Up Window

This is for Pop up window to display one HTML Page.

<a onclick="javascript:window.open('../index.htm','mywindow','top=10,left=10,width=700,height=500, toolbar=no,location=yes,directories=yes,status=yes,menubar=no,scrollbars=yes,copyhistory=no, resizable=no')">Terms And Conditions</a>

Response.Write("<script>window.open('ContactUs.aspx','List','scrollbars=no, resizable=no,width=400,height=280');</script>");

Java Script:

<script type="text/javascript" language="javascript">
function poponload()
{
testwindow= window.open ("Default.aspx", "mywindow",
"location=1,status=1,scrollbars=1,width=100,height=100");
testwindow.moveTo(0,0);

(OR)

window.open ("http://www.javascript-coder.com","mywindow");
}
</script>

<asp:Button ID="Button2" runat="server" Text="Button" OnClientClick="return poponload();" />

When Window close The Popup Window will display:

just add on onunload event in <BODY> Tag <body onunload="javascript: poponload()" >

Link: http://www.javascript-coder.com/window-popup/javascript-window-open.phtml

Friday, December 26, 2008

How to show "<--Select--> " in drop down box on page load?

First DropDownlist load Data from Database,Then the first text in DropDownlist is "--Select--" Text.

ListItem li = new ListItem();
li.Text = "<--Select-->";
SqlDataAdapter ada = new SqlDataAdapter("select MOVIENAME,MOVIECODE from CURMOVI", conn);
DataTable dt = new DataTable();
ada.Fill(dt);
ddlMovieName.DataSource = dt;
ddlMovieName.DataTextField = "MOVIENAME";
ddlMovieName.DataValueField = "MOVIECODE";
ddlMovieName.DataBind();
ddlMovieName.Items.Insert(0, li);

******************************** (OR) ******************************

SqlDataAdapter ada = new SqlDataAdapter("select MOVIENAME,MOVIECODE from CURMOVI", conn);
DataTable dt = new DataTable();
ada.Fill(dt);
ddlMovieName.DataSource = dt;
ddlMovieName.DataTextField = "MOVIENAME";
ddlMovieName.DataValueField = "MOVIECODE";
ddlMovieName.DataBind();
ddlMovieName.Items[0].Text = "--Select--";

Friday, December 19, 2008

DataGrid to Excel Sheet Report Generator in ASP.NET with C#

First include the Header files ::

using System.Data.SqlClient;
using System.Xml;
using System.IO;
using System.Xml.Xsl;
----------------------------------------------------------------------------
Connection string ::

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DBConString"]);
DataSet ds;
SqlDataAdapter ada;
----------------------------------------------------------------------------
DataBase values to load in DataGrid ::

try
{
string cmdstr = "select Cls from abi_pay";
if (conn.State == ConnectionState.Closed)
conn.Open();
ada = new SqlDataAdapter(cmdstr, conn);
ds = new DataSet();
ada.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();
}
catch (Exception cEx)
{
Response.Write(cEx.Message);
}

----------------------------------------------------------------------------
Export Excel reports in One Button click event::

protected void Button1_Click(object sender, EventArgs e)
{
// Data grid to Excel Report Generator
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=AbiramiReports.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(GridView1);
this.Controls.Add(form);
form.RenderControl(htextw);
Response.Write(stw.ToString());
Response.End();
}

------------------------------------------------------------------------

Another Methos for Data Grid to Excel Report Without Paging..
--------------------------------------------------------------------------
First Assign your DataSet to SessionLike :

Session["DataSet"] = ds;

in Grid Load Area.

protected void btnExcel_Click(object sender, EventArgs e)
{
DataSet dstest = new DataSet();
dstest = (DataSet)Session["DataSet"];
ConvertToExcel(dstest, Response);
}

public static void ConvertToExcel(DataSet ds, HttpResponse Response)
{
try
{
Response.Clear();
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();
dg.DataSource = ds.Tables[0];
dg.DataBind();
dg.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
catch (Exception ex)
{
}
}