Archive for May, 2009
SELECT next, last row or “LIMIT-command” in MSSQL
May 26th
SELECT previous row or "LIMIT-command" in MSSQL
SELECT TOP (1) FROM table_name WHERE (ID< @ID)
ORDER BY ID DESC
SELECT next row or "LIMIT-command" in MSSQL
SELECT TOP (1) FROM table_name WHERE (ID> @ID)
ORDER BY ID
Thank also for the descussion
disable remove viewstate aspx
May 11th
Problem:
Annoying LONG viewstate
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTEyMjcx NDEzNzQPZBYCZg9kFgQCAQ9kFgICAg8VAh4vV29ybGRHcmFubnkvanMvZGRhY2NvcmRpb24u anMkL1dvcmxkR3Jhbm55L2pzL2pxdWVyeS0xLjIuMi5wYWNrLmpzZAIDD2QWBAIDDxYCHgtfIUl0 ZW1Db3VudAIKFhRmD2QWBAIBDw8WAh4LTmF2aWdhdGVVcmwFFH4vUGFnaW5hLzIvaG9tZS5h c3B4ZBYCZg8VAQRIb21lZAIDDxYCHwACARYCAgEPZBYCAgEPDxYCHwEFFX4vUGFnaW5hLzQvc3V iLTEuYXNweGQWAmYPFQEFc3ViIDFkAgEPZBYEAgEPDxYCHwEFG34vUGFnaW5hLzMvb3JnYW5pc2F0a WUuYXNweGQWAmYPFQELT3JnYW5pc2F0aWVkAgMPFgIfAAICFgQCAQ9kFgICAQ8PFgIfAQUUfi9QYWdpb mEvNS9zdWIyLmFzcHhkFgJmDxUBBHN1YjJkAgIPZBYCAgEPDxYCHwEFGH4vUGFnaW5hLzgvbmV3LXBhZ2" />
LOL.. long huh 
Solution:
put this code in your .cs page
//overwrite the SavePageStateToPersistenceMedium and LoadPageStateFromPersistenceMedium
protected override void SavePageStateToPersistenceMedium(object viewState)
{
}
protected override object LoadPageStateFromPersistenceMedium()
{
return null;
}
// Remove completely after rendering html code
protected override void Render(HtmlTextWriter output)
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
System.IO.StringWriter stringWriter = new System.IO.StringWriter(stringBuilder);
HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
foreach (Control ctrl in this.Controls)
ctrl.RenderControl(htmlWriter);
String html = stringBuilder.Replace("/>", ">").ToString();
int intViewStart = html.IndexOf("<input type=\"hidden\" name=\"__VIEWSTATE\"");
int intViewFinish = html.IndexOf(">", intViewStart) + 1;
string strViewTag = html.Substring(intViewStart, intViewFinish – intViewStart);
System.Diagnostics.Debug.WriteLine(strViewTag);
html = html.Replace(strViewTag, "");
output.Write(html);
}
and WALA! its gone!!
find value in repeater asp net
May 4th
Problem:
find value in repeater
Solution:
write this code in itemdatabound on your repeater:
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label title = e.Item.FindControl("Label1") as Label; // depend on what component you r searching for
Response.Write(title.Text); // just check
}
}