Posts made by Ma tju

Ma tju

i use UpdatePanel. It work perfectly.

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Actually I try to do this:

<%
For j = 0 To countCol - 1
'during loop it will skip this line. This is why I use response.write.
<td width=<%#(colSize(j))%>><%#Eval(colName(j))%></td>
Next
%>

but when it loops it will skip the code in the for loop. When i use response.write it will run line in for loop but return this error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. Hope this help. Thanks in advanced.

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Sure, here is the code.

    Dim conn As New         SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings(0).ConnectionString)
    Dim sqlDA As New SqlDataAdapter("SELECT id, filename, img\_size FROM image ORDER BY id", conn)
    Dim ds As New DataSet
    Dim pgDataSrc As New PagedDataSource
    Try
        sqlDA.Fill(ds, "tl")

        pgDataSrc.DataSource = ds.Tables("tl").DefaultView
        pgDataSrc.AllowPaging = True
        pgDataSrc.PageSize = 20
        pgDataSrc.CurrentPageIndex = CurrentPage

        'rptInbox is a repeater control
        rptInbox.DataSource = pgDataSrc
        rptInbox.DataBind()

    Catch ex As Exception
        Return False
    Finally
        conn = Nothing
        sqlDA = Nothing
        ds = Nothing
    End Try

Well sometimes user want to see just 1 or more column in the repeater. Thats why i use for loop to generate the column. Hope this help. Thanks in advance.

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Hi, Actually i need to use Eval to bind the data from datasource. But to use eval I need to include the '#' sign.

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Hi guys, I got little problem here. I cannot get the value for ColName. Below are my code

<tr ondblclick="job_detail('<%#Eval("id")%>');" >
<td width="15"><input name="Checkbox51" type="checkbox" style=" width:13px; height:13px;" value="<%#Eval("id")%>" /></td>
<%
For j = 0 To countCol - 1
Response.Write("<td width=" & colSize(j) & ">" & Eval(colName(j)) & "</td>")
Next
%>
</tr>

It give me an error : Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. Can someone help me. Thanks in advance. matju

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Hi Shameel, Thanks for your reply to my problem. :-D Like Mycroft Holmes said, I just want a simply to move the 0 value records to the end of the sort. Regards.

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Thanks a lot its working. +5 :-D

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Hi, I have a table where the results are sorted using an "priority" column, eg:

Doc_Value priority

aaa 0
xxx 1
bbb 3
ccc 0
aaa 2

I need the SQL results to be in a specific order based on the "priority", but not in ascending or descending order. The order that I want them in is 1,2,3,0,0,0,0.... Highest priority start with 1 to infinite (9999) number but the lowest priority is 0... Any suggestion guys? :)

ma tju Software Application Engineer Petaling Jaya,Selangor, Malaysia Ring Master SB MVP 2008 ;p Petaling Jaya MOP (Otai)

Ma tju

Thanks navaneeth for your suggestion. I already find another way to solve my problem. Actually its hard for me to understand the article from msdn microsoft. :rolleyes: