dev-exchange.com

custom paging using 'next/pre with numeric'

pupilstuff — Fri Jul 10, 2009 7:33 am

Author: pupilstuff

Posted: Fri Jul 10, 2009 7:33 am

hi guys i just want to perform custom paging in which at the footer of the grid view ,there must be a pager 'pervious/next with numeric'

this is what i did

in aspx page

<asp:GridView ID="TableGridView"

OnPageIndexChanging="TableGridView_PageIndexChanging"
runat="server" AutoGenerateColumns="False"
AllowPaging="True" AllowSorting="True" >

</asp:GridView>

<asp:Button ID="btnConnect" runat="server" Style="z-index: 113;
left: 260px; position: absolute; top: 143px" Text="Connect & Populate" OnClick="btnConnect_Click" />

in code behind page

public partial class _Default : System.Web.UI.Page
{

public static DataTable Table = new DataTable();
ArrayList ParameterArray = new ArrayList();

protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack && (bool)Session["IsConnectionInfoSet"]==true)
CreateTemplatedGridView();

}

protected void TableGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//CreateTemplatedGridView();
TableGridView.PageIndex = e.NewPageIndex;
TableGridView.DataBind();
}

protected void btnConnect_Click(object sender, EventArgs e)
{
Session["IsConnectionInfoSet"] = true;
CreateTemplatedGridView();
}

void PopulateDataTable()
{
Table = new DataTable();
TableGridView.Columns.Clear();

SqlDataAdapter adapter = new SqlDataAdapter("select * from customer", "Data Source=OPWFMS-7KYGZ7SB;Initial Catalog=Mayank;User ID=sa;Password=sa");
adapter.Fill(Table);

}
void CreateTemplatedGridView()
{
// fill the table which is to bound to the GridView
PopulateDataTable();
// add templated fields to the GridView
TemplateField BtnTmpField = new TemplateField();
BtnTmpField.ItemTemplate =
new DynamicallyTemplatedGridViewHandler(ListItemType.Item, "...", "Command");
BtnTmpField.HeaderTemplate =

new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, "...", "Command");
TableGridView.Columns.Add(BtnTmpField);

for (int i = 0; i < Table.Columns.Count; i++)
{

TemplateField ItemTmpField = new TemplateField();
// create HeaderTemplate
ItemTmpField.HeaderTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.Header,
Table.Columns[i].ColumnName,
Table.Columns[i].DataType.Name);
// create ItemTemplate
ItemTmpField.ItemTemplate = new DynamicallyTemplatedGridViewHandler(ListItemType.Item,
Table.Columns[i].ColumnName,
Table.Columns[i].DataType.Name);
//create EditItemTemplate

// then add to the GridView
TableGridView.Columns.Add(ItemTmpField);

}

// bind and display the data
TableGridView.DataSource = Table;
TableGridView.DataBind();
}

}

and in the class file

public class DynamicallyTemplatedGridViewHandler : ITemplate
{

ListItemType ItemType;
string FieldName;
string InfoType;

public DynamicallyTemplatedGridViewHandler(ListItemType item_type, string field_name, string info_type)
{
ItemType = item_type;
FieldName = field_name;
InfoType = info_type;
}

public void InstantiateIn(System.Web.UI.Control Container)
{
switch (ItemType)
{
case ListItemType.Header:
Literal header_ltrl = new Literal();
header_ltrl.Text = "<b>" + FieldName + "</b>";
Container.Controls.Add(header_ltrl);
break;
case ListItemType.Item:
switch (InfoType)
{
case "Command":
break;

default:
Label field_lbl = new Label();
field_lbl.ID = FieldName;
field_lbl.Text = String.Empty; //we will bind it later through 'OnDataBinding' event
field_lbl.DataBinding += new EventHandler(OnDataBinding);
Container.Controls.Add(field_lbl);
break;
}
break;
}
}

private void OnDataBinding(object sender, EventArgs e)
{

object bound_value_obj = null;
Control ctrl = (Control)sender;
IDataItemContainer data_item_container = (IDataItemContainer)ctrl.NamingContainer;
bound_value_obj = DataBinder.Eval(data_item_container.DataItem, FieldName);
switch (ItemType)
{
case ListItemType.Item:
Label field_ltrl = (Label)sender;
field_ltrl.Text = bound_value_obj.ToString();
break;
}

}

}
but for my requirements I want to use that code

class NumericWithNext : ITemplate
{

GridView localGrid;
int intSlotNo = 0;

#region CONTRUCTOR

public NumericWithNext(GridView gv)
{
localGrid = gv;
//intSlotNo = slotNo;
intSlotNo = localGrid.PageIndex / 10;

//constructor
}
public void InstantiateIn(Control container)
{
LinkButton prevTenRecords = new LinkButton();
prevTenRecords.Text = "Previous 10 Pages";
prevTenRecords.CssClass = "PagingLnks";
prevTenRecords.CommandArgument = ((intSlotNo - 1) * 10 + 1).ToString(); ;
prevTenRecords.CommandName = "Page";
//prevTenRecords.Click += new EventHandler(prevTenRecords_Click);
prevTenRecords.Width = Unit.Pixel(125);
if (intSlotNo > 0)
{
container.Controls.Add(prevTenRecords);
}

LinkButton nextTenRecords = new LinkButton();
nextTenRecords.Text = "Next 10 Pages";
nextTenRecords.CommandName = "Page";
nextTenRecords.CommandArgument = ((intSlotNo + 1) * 10 + 1).ToString();
// nextTenRecords.Click += new EventHandler(nextTenRecords_Click);
nextTenRecords.CssClass = "PagingLnks";
nextTenRecords.Width = Unit.Pixel(118);
// nextTenRecords.Visible = false;

LinkButton prev = new LinkButton();
prev.Text = "Previous Page";
prev.CssClass = "PagingLnks";
prev.CommandArgument = "Prev";
prev.CommandName = "Page";
prev.Width = Unit.Pixel(90);
if (localGrid.PageIndex > 0)
{
container.Controls.Add(prev);
}

//for (int pagenum = 1; pagenum <= localGrid.PageCount; pagenum++)
for (int pagenum = (intSlotNo*10)+1; pagenum <= (intSlotNo+1)*10; pagenum++)
{
if (pagenum > localGrid.PageCount)
{
nextTenRecords.Visible = false;
break;
}
LinkButton pageInd = new LinkButton();
if (pagenum == localGrid.PageIndex + 1)
{
//pageInd.ForeColor = System.Drawing.Color.Green;PagingSelected
pageInd.CssClass = "PagingSelected";
}
else
{
pageInd.CssClass = "PagingLnks";
}
pageInd.ID = "PageInd_" + pagenum;
pageInd.Text = pagenum.ToString();
pageInd.CommandName = "Page";
pageInd.CommandArgument = pagenum.ToString();
container.Controls.Add(pageInd);
pageInd.Width = Unit.Pixel(10);
}

LinkButton next = new LinkButton();
next.Text = " Next Page";
next.CommandName="Page";
next.CommandArgument = "Next";
next.CssClass = "PagingLnks";
next.Width = Unit.Pixel(80);
if (localGrid.PageIndex < localGrid.PageCount - 1)
{
container.Controls.Add(next);
}

container.Controls.Add(nextTenRecords);
}

void nextTenRecords_Click(object sender, EventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
intSlotNo++;

}

void prevTenRecords_Click(object sender, EventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
intSlotNo--;
}

plz let me know how can i do that

inno3d 9400GT installation

romalagajini — Wed Jun 24, 2009 3:38 pm

Author: romalagajini

Posted: Wed Jun 24, 2009 3:38 pm

i have Intel DQ965GF Motherboard

i recently bought the 9400GT card.
i tried installing it, my system detects it initially ( i can see nvidia 1024mb etc )
but after few seconds physical dumping takes place and restarts and this keeps on happening
i have already updated the bios of my motherboard to the latest version
i also uninstalled the onboard integrated graphics from device manager
and also changed the bios setting to pcie as primary but still the problem persists any help is welcome thanks in advance.

setting page request time out in asp.net

HostingASPNet — Wed May 06, 2009 8:50 am

Author: HostingASPNet

Posted: Wed May 06, 2009 8:50 am

Hello,

It will be good to set also and IIS Connection Timeouts.

To set a global WWW or FTP service connection time-out value
1. In IIS Manager, expand the local computer, right-click the Web Sites or FTP Sites folder, and click Properties.

2. On the Web Site or FTP Site tab, in the Connection timeout box, type the maximum number of seconds that IIS should maintain an idle connection before resetting the connection.

3. For the WWW service, verify that the Enable HTTP Keep-Alives box is selected. For more information, see Enabling HTTP Keep-Alives.

4. Click Apply, and then click OK.

To set a connection time-out value for a specific Web or FTP site
1. In IIS Manager, expand the local computer, expand the Web Sites or FTP Sites folder, right-click a Web or FTP site, and click Properties.

2. On the Web Site or FTP Site tab, in the Connection timeout box, type the maximum number of seconds that IIS should maintain an idle connection before resetting the connection.

3. For the WWW service, verify that the Enable HTTP Keep-Alives box is selected. For more information, see Enabling HTTP Keep-Alives.

4. Click Apply, and then click OK.

Regards

System.NullReferenceException was unhandled by user code

HostingASPNet — Wed May 06, 2009 8:36 am

Author: HostingASPNet

Posted: Wed May 06, 2009 8:36 am

Hello,

I agree that the right way is to check for null before doing variable assignment.

Regards

tell me the code for feedback form

buddhi225 — Tue May 05, 2009 4:30 pm

Author: buddhi225

Posted: Tue May 05, 2009 4:30 pm

Heloooooooooo!!!!!

I am going to create one site using asp

i want to feedback form i dont know how

to code it if uhave any idea pls give me

waiting for ur reply

Adding security to a page

buddhi225 — Tue May 05, 2009 4:28 pm

Author: buddhi225

Posted: Tue May 05, 2009 4:28 pm

Hi, i just created a page where i can access my phpadmin through. the problem is that, it has no security, which means who ever know's the url: can abuse it.

is there a way for me to add something like "You are not admin."

Here's my script.

Code:

<?php
$connect = mysql_connect("localhost","root","pw") or die (mysql_error());
mysql_select_db("db")or die (mysql_error());
$Query = mysql_query("SELECT * FROM members ORDER BY setname DESC");
?>

<head>
<title>Untitled Document</title>
</head>
<body>
<style type="text/css">
table {border-collapse:collapse;}
table td, table th {border:1px #000 solid; padding:5px;}
</style>
<table width="500" border="1" cellpadding="2" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td>Edit</td>
<td>Delete</td>
<td>User ID</td>
<td>Username </td>
<td>Password</td>
<td>wins</td>
<td>loses</td>
</tr>

<?php
while ($Result = mysql_fetch_assoc($Query))
{
?>

<tr>
<td><a href="edit.php?uid=<?php echo $Result['id'];?>">Edit</a></td>
<td><a href="delete.php?uid=<?php echo $Result['id']?>">Delete</a></td>
<td><?php echo $Result['id']?></td>
<td><?php echo $Result['setname']?></td>
<td><?php echo $Result['password']?></td>
<td><?php echo $Result['wins']?></td>
<td><?php echo $Result['loses']?></td>
</tr>

<?php
}
?>

</table>
</body>
</html>

How Do I Post My PHP, HTML or Other Code?

buddhi225 — Tue May 05, 2009 4:25 pm

Author: buddhi225

Posted: Tue May 05, 2009 4:25 pm

PHP forum members,

It is very common for users having problems with scripts to submit questions related to a script or code they are working on. If you would like to submit your code, use these tags and your code will appear in a colored box and, in the case of PHP, parse it and color code the different structures of your script.

For PHP code, enclose your code in [php ] and [/php ] tags (minus the spaces).

Code:

<?php
$message = "It'll look absolutely great and be parsed.";
?>

For HTML markup, enclose your segment in [html ] and [/html ] tags (minus the spaces).

Code:

<html>
<head>
<title>WT Rocks!</title>
</head>
<body>
<h1>I really love eating chicken!</h1>
</body>
</html>

For all other code, enclose your segment in [code ] and [/code ] tags (minus the spaces).

Code:

var i = 9;

for( n=0; n<9; n++ )
{
print "Performing some task " + n + " times.";
}

I hope these instructions will help you post your code in a more attractive and readable manner and ultimately, to get your questions answered more completely.

Digital Versatile Disc (DVD) and Streamers

Schul58 — Sat May 02, 2009 5:37 am

Author: Schul58

Posted: Sat May 02, 2009 5:37 am

DVD (digital versatile disc) is an optical disc technology that is expected to rapidly replace the CD-ROM disc (as well as the audio compact disc) over the next few years. The digital versatile disc (DVD) holds 4.7 gigabyte of information on one of its two sides, or enough for a 133-minute movie.

With two layers on each of its two sides, it will hold up to 17 gigabytes of video, audio, or other information. (Compare this to the current CD-ROM disc of the same physical size, holding 600 megabyte. The DVD can hold more than 28 times as much information!)

DVD-Video is the usual name for the DVD format designed for full-length movies and is a box that will work with your television set. DVD-ROM is the name of the player that will (sooner or later) replace Custom Web Design computer's CD-ROM. It will play regular CD-ROM discs as well as DVD-ROM discs. DVD-RAM is the writeable version. DVD-Audio is a player designed to replace your compact disc player.

DVD uses the MPEG-2 file and compression standard. MPEG-2 images have four times the resolution of MPEG-1 images and can be delivered at 60 interlaced fields per second where two fields constitute one image frame. (MPEG-1 can deliver 30 non-interlaced frames per second.) Audio quality on DVD is comparable to that of current audio compact discs.

Streamers have always been considered very special hardware. The first desktop models were attached to either the floppy controller or to a SCSI controller. With the increase of hard drive capacities and the incredible success of the CD, most home users cannot even remember the existence of the good old backup-hardware called streamer.

Streamers do not have the flexibility and portability advantages mentioned above. The tape is usually written sequentially, which makes it more time-consuming to access files, since you would have to manually forward the tape to the location on the desired data. However, this inconvenience is normally not an issue with streamers, because they are typically used to backup and transfer large quantities of data in their entirety, not individual parts of data. Generally, streamer tapes have a large storage capacity, so that huge backups can run unattended, which is a definite advantage over CD-Rs as a backup medium. For example, if you had to backup 3 GB of data onto CD-Rs, you would have to change the CD five times.

Free Web Hosting

gordbell09 — Thu Apr 23, 2009 7:11 am

Author: gordbell09

Posted: Thu Apr 23, 2009 7:11 am

thanx for posting about the free hosts here, would definitely like to use few of them for my personal use

I need your opinion :)

gordbell09 — Thu Apr 16, 2009 7:25 am

Author: gordbell09

Posted: Thu Apr 16, 2009 7:25 am

here is tool that will help in making money from the site better. it is a free service that estimates the number of visitors any site has. so depending on the data from here you can chose the perfect PPC ad network for your self, it has a host of adsense alternatives that can be used
read more at
http://www.statbrain.com/ad-networks/

Who will win the browser war ?

gordbell09 — Thu Apr 16, 2009 7:21 am

Author: gordbell09

Posted: Thu Apr 16, 2009 7:21 am

the Chrome has been nothing but a disappointment for all the users, FF is marching ahead of IE.. so very soon it will be only FF, this is one battle the Google will lose

adding textboxes dynamically using Java Script

warhead2020 — Wed Apr 08, 2009 9:21 am

Author: warhead2020

Posted: Wed Apr 08, 2009 9:21 am

Hi MSN, i had altered a bit ur code..

first.php
--------------------------------------------------------------------------------
<script language="javascript" >

function addElement()
{
var ni = document.getElementById('myDiv');
var numi = document.getElementById('theValue');
var num = (document.getElementById('theValue').value -1 + 2);
numi.value = num;
var newdiv = document.createElement('div');
var divIdName = 'my'+num+'Div';
newdiv.setAttribute('id',divIdName);
newdiv.innerHTML = '<input type=file id=imgfile' + num + ' name=imgfile' + num + '><a href="javascript:remove('+divIdName+')">Remove</a>';
ni.appendChild(newdiv);
}

function remove(dId)
{
var ni = document.getElementById('myDiv');
var numi = document.getElementById('theValue');
var num = (document.getElementById('theValue').value -1 + 0);
numi.value = num;
ni.removeChild(dId);
}

<form name="frmUp" method="post" action="AddListUploadPictureProp.php">

<p><a href="javascript:addElement()" >Add Upload Field</a></p>
<p>
<input type="hidden" value="0" id="theValue" name="theValue"/>
</p>
<table width="100%" border="0">
<tr>
<td>
<div id="myDiv">
</div>
</td>
</tr>
<tr>
<td><label>
<input type="submit" name="button" id="button" value="Submit" />
</label></td>
</tr>
</table>
<div id="myDiv">
</div>
</form>
-----------------------------------------------------------------------------

second.php
----------------------------------------------
$theValue = $_REQUEST['theValue'];
echo "theValue " . $theValue;
for($i = 1;$i <= $theValue;$i++)
{
echo basename($_FILES['imgfile' . $i]['name']);
}
------------------------------------------------

in the second.php, i cant grab the " echo basename($_FILES['imgfile' . $i]['name']); "...any error in my code? thanx in advance..

List of Software Testing books

seangtz — Mon Apr 06, 2009 9:26 am

Author: seangtz

Posted: Mon Apr 06, 2009 9:26 am

Hello Everyone,

I wanted to share an useful info on Software Testing books. Many of you would be interested to build your career in software testing... here's a list of top 20 books on software testing- http://www.getzephyr.com/resources/books_on_testing.php

Remove old files and folders as schedule task using .vbs

sohoenter — Thu Mar 26, 2009 8:39 am

Author: sohoenter

Posted: Thu Mar 26, 2009 8:39 am

Techie, this script is perfect, but how should i change the line contained folder, in case i would delete more paths on more disk drives, etc. some files on C: (older than 28 days), on D: drive older than 20 days? thank you in advance

Top 100 records from each category

Kishore — Mon Mar 09, 2009 3:15 pm

Author: Kishore

Posted: Mon Mar 09, 2009 3:15 pm

You can do this using the RANK function ROW_NUMBER().

Try something like:

Code:

SELECT * FROM
(SELECT ROW_NUMBER() OVER (
PARTITION BY category id ORDER BY product id) AS 'Row_No',
product id,product_name
FROM producttable) temp WHERE Row_No<=100