yussi ariefiyono
This user hasn't shared any biographical information
Posts by yussi ariefiyono
modify Visible function in repeater of gridview control
Dec 31st
Problem:
display label with the text full if the current field equal to zero in repeater or gridview
Solution:
<asp:Label ID=”Label1″ runat=”server” Text=”Full” ForeColor=”Red” Visible=’<%# Convert.ToBoolean(Eval(“name of your field”).ToString().Equals(“0″)? “true”:”false”) %>’>
javascript back button work in IE and FF
Dec 31st
Problem:
Need javascript back button which work in IE and FF
Solution:
<a href=”javascript:void(0);” onclick=”history.back(); return false;”>Back</a>
Finding Duplicates with SQL
Nov 27th
problem:
finding the duplicate within sql
solution:
provide table named subscriber, with elements: email
SELECT COUNT(DISTINCT email) AS NumberOfEmail, email FROM subscriber GROUP BY email HAVING (COUNT(email) > 1)
select NOT in top post sql query
Nov 27th
problem:
make some selection in database OTHER THEN top (10) post
solution:
provide, table named news with element: newsID, newsDate
SELECT * FROM News WHERE (newsID NOT IN (SELECT TOP (10) newsID FROM News AS News_1 ORDER BY newsDate DESC)) ORDER BY newsDate DESC
it will return all post except top 10 post
type of requesturl aspx
Sep 2nd
Request.Url.Host = asp.net.do
Request.Url.ToString = http://asp.net.do/test/requesturl.aspx
Request.ApplicationPath.ToString = /test
Request.RawUrl.ToString = /test/requesturl.aspx
Page.TemplateSourceDirectory = /test
Request.Url.AbsoluteUri = http://asp.net.do/test/requesturl.aspx
Taken from : http://asp.net.do/test/requesturl.aspx