<head runat="server">
<title>Untitled Page</title>
<style type="text/css">
.pagination a{padding:5px;}
.pagination span{padding:5px;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataList ID="dlPaginationSample" runat="server">
<ItemTemplate>
<%# Eval("Column1")%> | <%# Eval("Column2")%>
<br />
</ItemTemplate>
</asp:DataList>
</div>
<br />
<asp:Panel runat="server" id="pnlPager" CssClass="pagination">
</asp:Panel>
</form>
</body>
//you can pass either DatList or Repeater to this function
private void bindDataWithPaging(Control bindControl, DataSet data)
{
if (data.Tables.Count > 0) // if the datset contains data
{
DataView dv = data.Tables[0].DefaultView;
PagedDataSource dsP = new PagedDataSource();
dsP.AllowPaging = true;
dsP.DataSource = dv;
dsP.CurrentPageIndex = CurrentPageIndex;
dsP.PageSize = PageSize;
//Binding data to the controls
if (bindControl is DataList)
{
((DataList)bindControl).DataSource= dsP;
((DataList)bindControl).DataBind();
}
else if (bindControl is Repeater)
{
((Repeater)bindControl).DataSource = dsP;
((Repeater)bindControl).DataBind();
}
//saving the total page count in Viewstate for later use
PageCount = dsP.PageCount;
//create the linkbuttons for pagination
BuildPagination();
}
}
//create the linkbuttons for pagination
protected void BuildPagination()
{
pnlPager.Controls.Clear(); //
if (PageCount <= 1) return; // at least two pages should be there to show the pagination
//finding the first linkbutton to be shown in the current display
int start = CurrentPageIndex - (CurrentPageIndex % ButtonsCount);
//finding the last linkbutton to be shown in the current display
int end = CurrentPageIndex + (ButtonsCount - (CurrentPageIndex % ButtonsCount));
//if the start button is more than the number of buttons. If the start button is 11 we have to show the <<First link
if (start > ButtonsCount - 1)
{
pnlPager.Controls.Add(createButton(FirstPageText, 0));
pnlPager.Controls.Add(createButton("..", start - 1));
}
int i = 0, j = 0;
for (i = start; i < end; i++)
{
LinkButton lnk;
if (i < PageCount)
{
if (i == CurrentPageIndex) //if its the current page
{
Label lbl = new Label();
lbl.Text = (i + 1).ToString();
pnlPager.Controls.Add(lbl);
}
else
{
pnlPager.Controls.Add(createButton((i + 1).ToString(), i));
}
}
j++;
}
//If the total number of pages are greaer than the end page we have to show Last>> link
if (PageCount > end)
{
pnlPager.Controls.Add(createButton("..", i));
pnlPager.Controls.Add(createButton(">>", PageCount - 1));
}
}
There is a big offer from Microsoft Learning centre. Download the entire contents
of the print books, Introducing Microsoft Linq, Introducing Microsoft ASP.NET AJAX,
Introducing Microsoft Silverlight 1.0.
The download link is here
The vote to lift restrictions on top level domain names wins the approval. The net's regulator, Icann, voted unanimously to relax the strict rules on so-called "top-level" domain names, such as .com or .uk.
The decision means a domain name can be anything.anything . So the big debated .xxx is going to happen. So far Icann has rejected calls for a .xxx domain on the grounds that it might be forced to act as a censor. But now it could get the green light.
A second proposal, to introduce domain names written in Asian, Arabic or other scripts, was also approved.
Read the full news here
The net's regulators will vote on Thursday to decide if the strict rules on so-called top level domain names, such as .com or .uk, can be relaxed.
If approved, the net could see its biggest transformation in decades. The new plan will allow companies to turn their brands into domain names while individuals could also carve out their own corner of the net.
See full story here and express your views here
Contacts Reader .NET 1.0 from Idea Bubbling is an open source project to import contacts from different e-mail providers. Currently it supports Yahoo, Hotmail, Gmail, AOL Mail, Rediffmail.
Demo Page | Downloads Page
If you want to give a "View now" option for your PDFs and DOCs simliar to the "View as HTML" in Gmail you can use the free service by http://view.samurajdata.se/
This is an online viewer, with which you can view PDF and PostScript files as browsable images and Word documents as web pages.
Its really fast and easy.
Just give your pdf link as the parameter and it will automatically convert it.
Example http://view.samurajdata.se/ps.php?url=http://www.uddi.org/pubs/Iru_UDDI_Technical_White_Paper.pdf
Take part in the game build contest Dream-Build-Play 2008 launched by XNA team and win $75,000 in prizes and receive an Xbox Live Arcade Contract.
After using the simple sql server 2005 data transfer utility for some days I thought to add more functionality such as import export data from excel, CSV, flat file etc.
Before start coding I just did a Google search and found this big and interesting discussion in MSDN forums. In the first page developers were really annoyed with the fact MS is not giving a data transfer utility with Sql Server Management Studio Express.
I read the conversation one by one and in the 5th page I found this posting by Bill Elicson. MS actually has a really great DTS tool for sql server management studio express.
Thanks Bill.. you saved alot of time.
STEPS TO ADD DTS WIZARD WITH SQL SERVER MANAGEMNT STUDIO EXPRESS
1. Try "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
If it worked, you already have the DTS Wizard. Start using it right away.
If it will not work, continue to step 2
2. Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) from
http://go.microsoft.com/fwlink/?LinkId=65111
select all components to install
3. Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
Thats it.. Now you can transfer data using the the great DTS wizard.
Follow the steps If you want to integrate it with the Sql server management studio express UI .
1. Open sql server management studio express.
2. Select Tools -> External Tools
3. Add a Title and Browse C:\Program Files\Microsoft SQL Server\90 \DTS\Binn\DTSWizard.exe for the Command field.
3. Click OK
TAGS
Importing Exporting Data sql server express,sql server express data transfer, dts sql server express, sqlserver express DTS, move data sqlexpress 2005, SQLEXPRESS 2005 to SQL 2000 Data Transfer, Data import/export with SQL Server Express using DTS Wizard, Data Transfer between SQL Server and SQL Server Express
Since there is no mechanism to transfer data from one DB to another in Free SQL Server 2005 Management Studio Express I thought to write a simple utility to do this.
The utility is using ADO.Net SqlBulkCopy class to achieve the functionality.
Steps to transfer the data from one DB to another
