datalist printOut() function Problem

Hi,

I have a problem with WCF CallBack function (DuplexChannel). The main problem is that when I invoke that method on the client I got a message format like that below:

<ClientCallBackFunc xmlns="http://tempuri.org/ ">
  <issueId>1</issueId>
  <agreementId>2</agreementId>
  <limitId>3</limitId>
</ClientCallBackFunc>

where ClientCallBackFunc is name of callback method.

I made service:

public interface IClientCallBack

{

     [OperationContract(IsOneWay=true)]

    void ClientCallBackFunc(string IssueId, string AgreementId, string LimitId);

}

[ServiceContract(CallBackContract=typeof(IClientCallBack)]

public interface IService

{

    string ServerMethod(string IssueId, string AgreementId, string LimitId);

}

but I should prefer to get like this:

<HEADER>

<SERVICE>Loans.Collateral.Verify</SERVICE></HEADER><DATA>

<RESPONSE><ISSUE_ID>1</ISSUE_ID><AGREEMENT_ID>2</AGREEMENT_ID><LIMIT_ID>3</LIMIT_ID></DATA></RESPONSE>

So, when I want send message from server side (callba

hi,

i have the following function in my app_code which gets the data from database with datareader

now on anothe page i need to output all of the data to a label

i do not want to use datalist or gridview

hwo should i do this?

the function loops through the data ,i can put the function on the same page and use label.text += mydata

but since it's a function and i want to use it on other pages how is it possible?

Public Function getMembers(ByVal userID As Integer) As Boolean
            Dim Conn As New SqlConnection(HttpRuntime.Cache("con"))
            Dim dr As SqlDataReader
            Dim strSQL As String
            strSQL = "select * from test "
            Dim cmd As New SqlCommand(strSQL, Conn)
            cmd.Parameters.Add(New SqlParameter("@userID", userID))
            Conn.Open()
            dr = cmd.Execute

Even though the system function IsNumeric('2,344') returns a true in SQL Server 2005, why does the following throw an error? Is there a special way to cast to numeric types in SQL Server 2005, so the statement below does not throw an error?

SELECT  CASE ISNUMERIC('2,3444')
          WHEN 1 THEN CAST('2,344' AS INT)
          ELSE NULL
        END

I have a user comments area that people can add their comments to the page.  I have successfully gotten the star rating to save into the database.  I now want to display the star rating into a datalist.

Here is what I have so far:

<asp:DataList ID="DataList1" runat="server" CellPadding="3"
                DataSourceID="dsHotelComments" Visible="False" BackColor="White"
        BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
    GridLines="Horizontal" Width="843px">
                <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
                <AlternatingItemStyle BackColor="#F7F7F7" />
                <ItemStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
                <SelectedItemStyle BackCo

How do you set up an indexer for Sharepoint 2010 Foundations?

On a single page, I'd like to fill 2 hyperlink controls as well as a datalist control with table data using one call to the database. The page looks like this:

<div id="PageContent">    
    <h2>
      Districts</h2>
    <p>
      Please select the district you wish to view below.</p>
    <p>
      <asp:DropDownList ID="ddlDistrict" runat="server" CssClass="textbox" 
        DataTextField="DistrictName" DataValueField="DistrictId" AutoPostBack="True" 
        onselectedindexchanged="ddlDistrict_SelectedIndexChanged">
      </asp:DropDownList>
    </p>    
    <p><asp:label ID="lblDistrictAbbrev" runat="server" Text="District Abbreviation: " />
      <asp:hyperlink ID="hyperlinkDistrictName" runat="server" 
        Text='' NavigateUrl="~/Contact/NationalCouncil.aspx" 
        Font-Bold="True" />
    </p>
    <p><asp:label ID="lblDistrictCouncillor" runat="server" Text="District Councillor: " />
      <asp:hyperlink ID="hyperlinkCouncillor" runat="server" 
        Text='' NavigateUrl="~/Contact/NationalCouncil.a

Hi,

i use the following code which loops through the numbers of a listbox and adds records to a database

in the db i use the rand function to add a unique id to msgID field which accepts unique values

but when the records are more than 1 or 2 i get error which says Cannot insert duplicate key row in object

which means the rand function adds the same values

how should i solve the problem??

IF EXISTS (SELECT * FROM sysobjects   WHERE name = 'Message'   AND type = 'P')
DROP PROCEDURE Message
GO

CREATE PROCEDURE Message
  @Message ntext
AS
  SET NOCOUNT ON
   
  Insert into CmmNet_inbox (MsgID,Message) values (round(RAND()*10000000000,0),@message)
GO

  Dim ctr As Integer
                    For ctr = 0 To ListFriends.Items.Count() - 1
                        If ListFriends.Items(ctr).Selected Then