Using InStr Function 1

arpan · Dec 21, 2002

I am retrieving the Casual Leaves (CL) & Medical Leaves (ML) from a SQL Server DB table & displaying them in an HTML table using the Repeater control. It is possible that some of the records are not whole numbers; they can be something like 15.5 or 28.5 i.e. the records will either be a whole number or a fraction ending with .5 only (no other decimals allowed). I want to display the records like 30.0, 24.5, 29.0, 22.0 etc... i.e. whole numbers should be suffixed by .0 & fractional numbers should be displayed as
it is. This can be done using the InStr function to find out whether a decimal point is present in the record or not. This is what I have done:

<script language="VB" runat="server">
Sub Page_Load(obj As Object,ea As EventArgs)
Dim objDS As DataSet
Dim objConn As SQLConnection
Dim objDapter As SQLDataAdapter
objConn=New SQLConnection("Server=(local);Database=DBName;UID=sa;PWD=&quot
objDapter=New SQLDataAdapter("SELECT EName,CL,ML FROM.......",objConn)

objDS=new DataSet()
objDapter.Fill(objDS,"LeaveDetails&quot

myRepeater.DataSource=objDS.Tables("LeaveDetails&quot.DefaultView
myRepeater.DataBind()
End Sub
</script>
<form runat="server">
<asp:Repeater id="myRepeater" runat="server">
<HeaderTemplate>
<table border=3>
<tr>
<th>EMPLOYEE NAME</th>
<th>CASUAL LEAVES</th>
<th>MEDICAL LEAVES</th>
</tr>
</asp:HeaderTemplate>
<ItemTemplate>
<tr>
<td><%# Container.DataItem("EName&quot %></td>
<td><%# Container.DataItem("CL&quot %></td>
<td><%# Container.DataItem("ML&quot %></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>

Now my question is where do I accomodate the InStr function in the above ASPX code to find out whether a number is a whole number or not - if it is a whole number, then suffix it with .0 else display the record as it is?

Thanks,

Arpan

Isadore · Dec 22, 2002

Arpan: Good question. I was looking at the same problem a few days ago. If you could abandon the ItemTemplate approach and bind to a datagrid the following takes care of the problem:

<HTML>
...
<asp

ataGrid id="dgGrid" AutoGenerateColumns="false" runat="server">
<Columns>
<asp:BoundColumn
DataField="EName"
HeaderText="EName"/>
<asp:BoundColumn
DataField="CL"
HeaderText="CL"
DataFormatString="{0:c1}"/>
<asp:BoundColumn
DataField="ML"
HeaderText="ML"
DataFormatString="{0:c1}"/>
</Columns>
</asp

ataGrid>
...
</HTML>

If you want to use the "InStr" function, or a formatting statement in the code behind to save your ItemTemplate structure, I would suspect that you'll want to loop through the table as you load it it (using a "While myReader.Read()...Loop structure) or other arrangement where you can pass the field elements through a formatting statement or InStr function during the loading process.

Isadore · Dec 22, 2002

Arpan: Used the "currency" format {0:c1} should have been {0:f1} for doubles.

arpan · Dec 22, 2002

Hi,

Thanks for your response. Actually there is no need to abandon ItemTemplate as you have suggested. The formatting can still be done like this using ItemTemplate:

<asp:Repeater id="myRepeater" runat="server">
<ItemTemplate>
<td>
<% #DataBinder.Eval(Container.DataItem,"CL","{0:n1}&quot

%>
</td>
.............
</ItemTemplate>

In fact, another easier approach to this would be using the FormatNumber function like this:

<td><%# FormatNumber(Container.DataItem("CL&quot

,1) %></td>

Regards,

Arpan

Isadore · Dec 22, 2002

Arpan: Good work. I tried putting the formatting string in the template but left off the ".." quotes so it didn't work. Thanks for the insight. Good Luck.

arpan · Dec 22, 2002

It's my pleasure!!!!!!

Regards,

Arpan

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Using InStr Function 1

arpan

Programmer

Isadore

Technical User

Isadore

Technical User

arpan

Programmer

Isadore

Technical User

arpan

Programmer

Similar threads

Part and Inventory Search

Sponsor