Thanks It did work..

I have a table which is some thing like below..

Date ID

2009-07-01 1
2009-07-01 2
2009-07-01 3
2009-08-01 4
2009-08-01 5
2009-08-01 6
2009-09-01 7
2009-09-01 8
2009-10-01 9
2009-10-01 10
2009-11-01 11

.... Now I need to write a query which will show a output like below.

Date Start End
2009-07 1 3
2009-08 4 6
2009-09 7 8

... How can I do this.. Any help would be highly appreciated Thanking In Advance Johnny

Fill a data adapter with a dataset. Then count the rows. Some thing like: int totalRow = Dataset.Tables[0].Rows.Count;

Hello friends I have a messaging system that uses p2p. Each peer has a incoming message list and a outgoing message list. What I need to do is whenever a new peer will join the mesh he will get the all the incoming messages from other peers and add those into it's own incoming message list. Now I know when I get the other peer info from I can ask them to give their own list to me. But I'm not finding the way how..? Any suggestion on this or help would be highly appreciated. I'm giving my code below. Thanking in Advance Johnny

   #region Instance Fields
    
    private string strOrigin = "";
    //the chat member name
    private string m\_Member;
    //the channel instance where we execute our service methods against
    private IServerChannel m\_participant;
    //the instance context which in this case is our window since it is the service host
    private InstanceContext m\_site;
    //our binding transport for the p2p mesh
    private NetPeerTcpBinding m\_binding;
    //the factory to create our chat channel
    private ChannelFactory<IServerChannel> m\_channelFactory;
    //an interface provided by the channel exposing events to indicate
    //when we have connected or disconnected from the mesh
    private IOnlineStatus o\_statusHandler;
    //a generic delegate to execute a thread against that accepts no args
    private delegate void NoArgDelegate();
    //an object to hold user details
    private IUserService userService;        
    //an Observable Collection of object to get all the Application Instance Details in databas
    ObservableCollection<AppLoginInstance> appLoginInstances;
    // an Observable Collection of object to get all Incoming Messages types
    ObservableCollection<MessageType> inComingMessageTypes;
    // an Observable Collection of object to get all Outgoing Messages
    ObservableCollection<PDCL.ERP.DataModels.Message> outGoingMessages;
    // an Observable Collection of object to get all Incoming Messages
    ObservableCollection<PDCL.ERP.DataModels.Message> inComingMessages;
    //an Event Aggregator to publish event for other modules to subscribe
    private readonly IEventAggregator eventAggregator;   
 
    /// <summary>
    /// an IUnityCOntainer to get the container
    /// </summary>
    private IUnityContainer container;
    private RefreshCon

Hello Friends How can I know if value of any entity in a ObservableCollection was changed or updated? Thanking in Advance Johnny

<UserControl.Resources>
<Storyboard x:Key="storyboard" AutoReverse="True" RepeatBehavior="0:0:2" Duration="0:0:16">
<ColorAnimationUsingKeyFrames BeginTime="00:00:00" Storyboard.TargetName="{Binding RelativeSource={RelativeSource FindAncestor,AncestorType={x:Type UserControl}}, Path=ellipse}" Storyboard.TargetProperty="(Shape.Fill).(SolidColorBrush.Color)" >
<SplineColorKeyFrame KeyTime="00:00:15" Value="Gray"/>
</ColorAnimationUsingKeyFrames>
</Storyboard>

    <DataTemplate x:Key="EditRequestTemplate">
        <StackPanel Orientation="Horizontal" >
            <Grid >                   
                <Grid.RowDefinitions>
                    <RowDefinition></RowDefinition>
                    <RowDefinition></RowDefinition>
                    <RowDefinition></RowDefinition>
                    <RowDefinition></RowDefinition>
                    <RowDefinition></RowDefinition>
                    <RowDefinition></RowDefinition>                        
                </Grid.RowDefinitions>
                <Grid.ColumnDefinitions>
                    <ColumnDefinition></ColumnDefinition>
                    <ColumnDefinition></ColumnDefinition>
                    <ColumnDefinition></ColumnDefinition>
                    <ColumnDefinition></ColumnDefinition>
                </Grid.ColumnDefinitions>

                <TextBlock Text="Request Edit For Order: " Grid.Row="0" Grid.Column="0" FontSize="16.00" FontWeight="Bold"/>
                <TextBlock Name="tbOrderID" Text="{Binding OrderId}" Grid.Row="0" Grid.Column="1" FontSize="16.00" FontWeight="Bold"/>
                <TextBlock Text="Requested By: " Grid.Row="1" Grid.Column="0"/>
                <TextBlock Text="{Binding EmployeeName}" Grid.Row="1" Grid.Column="1"/>
                <TextBlock Text="Counter Name: " Grid.Row="2" Grid.Column="0"/>
                <TextBlock Text="{Binding CounterName}" Grid.Row="2" Grid.Column="1"/>
                <TextBlock Text="Requested On: " Grid.Row="3" Grid.Column="0"/>
                <TextBlock Text="{Binding CreatedOn,StringFormat={}\\{0:hh:mm:ss tt\\}}" Grid.Row="3" Grid.Column="1"/>

Hello friends I need to blink an ellipse based on the true vale of IsBlink property using Datatrigger. When the value of IsBlink becomes true the ellipse will blink for about 10 sec. How can I do this? Any help or suggestion would be highly appreciated. Thanking in Advance Johnny

Yes I understand I can do this using event aggregator. but I was wondering if it can be done using trigger in xaml. If it's possible plz let me know. Thanking again Johnny

Hello friends I have a Observable collection in my wpf window. There is a textblock in my window which text initially should be "No Message yet" (when Observable collection is empty). What I need to do is to set the text value of that textblock to " " when Observable collection changes (count becomes > 0) how Can I do this.? Any help or hints would be highly appreciated. Thanking in Advance Johnny

Man before you say some thing be sure that you are right... WF does not mean winform... It means Work Flow... Have u ever heard the name of Work Flow..

Hello friends I need to broadcast message using WCF service(duplex) and work on that message by listening from clients and also lock that message so that no other client can work on that message or can ask for that to the service. It should be kind of WCF duplex messaging. Can any one tell me how can I do this or any sample of this kind of work or any kind of help would be appreciated. Thanking in Advance Johnny

Hello friends I'm working on a ERP system where there are in total 8 modules. Now I need to create a duplex messaging system using WCF through user of one module with communicate with users of other modules. Like user of sales dept will request user of management dept to check on a certain request and give decision. Then the management user may accept that request or not and let the sales user know his feed back at the same time. Is there any sample of this or any help would be appreciated. Thanking in Advance Saiyed ALam

Hello friends, which is the better way to use transaction? From Database or from Application?

Hello Friends. I have a treeview in my window. What I want to do is whenever I'll edit on of my treeviewitem and save the information I want to change the colour of that node. So that one can easily understand that this node was changed and now it has the updated information. Can any one help me..? Any help or suggestion would be highly appreciated. Thanking in Advance Johnny

Hello Friends I have a Text box where i take the email address from user. What I want to do is if the the user inputs a invalid email address a popup will appear under the text box saying that the mail address is not in correct format. I have done the email validation check but now facing problem with the popup. Any kind of help or suggestion would be appreciated. Thanking in advance Johnny

Hello Friends, I need to insert value on a specific column of my datagrid in run time. Suppose I need to insert value in column 0 dynamically. But no will be inserted in other rows as they will be empty because the user will insert value in them. Any help will be appreciated. Thanking in Advance Johnny

Hello I want to write a wcf service where there will be a generic list of object as a parameter and a enum to define the type of object. The generic object can have a single entity or multiple entities. And the entity can be a single Client or a collection of Clients or may be a single Employee or a Collections of Employees and so on. But the problem is wcf service don't take any kind of generic object as a parameter. Is there any way to this? What I want to do is something like below: In the Client side the method will be..

public string EmployeeInformation(List<Employee> objEmployee)
{
try
{

string IsSuccess = "";
**WCF\_Service\_Reference objWCFService = new WCF\_Service\_Reference();**
List objList = objEmployee;  
IsSuccess = objWCFService.ActionMapping(objList,(int)EnumEntities.Employee);
return IsSuccess;

}
catch()
{

}
}

At the server in WCFService.svc.cs file the implementation of the service should be some thing similar like below:

public string ActionMapping(List objList, int nEntityInfo)
{

(EnumEntities) EnumEnt = (EnumEntities)nEntityInfo;

swicth(EnumEnt)
{
case EnumEnt.Employee :
List<Employee> objEmployee = objList;
PerformOperation(objEmployee);
break:

         case EnumEnt.User:
         List<User> objUser = objList;
         PerformOperation(objUser);
         break;

         case EnumEnt.Bank:
         List<Bank> objBank = objList;
         PerformOperation(objBank);
         break;

         default:
         break:

}
}

The problem is that the service not taking List objList as a Serialized object which is obvious why. But Is there any way to do the same some how. so that I can use only one service method for all of my entities. Any help or hints would be highly appreciated. Thanking in Advance Johnny

Can any one tell me where can I get some free XAML(WPF) Template or theme for business application. Thanking in Advance Johnny

Hello friends I want to call a function on pressing Ctrl+S button. how can I do this? Thanking in Advance S.N.ALam

Hello Friends.. Is there any way to connect Linq to Oracle like the way we do with SQL Server. Is there is, then please let me know how. It would be really help full for me. Thanking in advance Johnny