In HttpWebRequest a user can pass Method as Post OR Get OR Put OR DELETE etc. But for our specific project I need to pass HttpMethod as "POST /api/login HTTP/1.0". But this is not allowed in .NET CF. Then can any one tell me workaround for this please for customizing Http Method. Thanks in advance. Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

for the first time silverlight ask for download if you have some firewall or if you rejected that file then also it may show you blank page... if possible post your code which is used to call ...

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

hi alll please help me ASAP i need to call web service in window application now my web service devloped in delphi .... i had add service reference and by creating its object i m ablt to get methods now my problem is for the first time my application return me result but for the second call it will throw me error for time out e.x. having two form first will give me list of country and second will give me list of state now if i click on country then it will return me data while for state it will trhow me time out exception now i closed my win application and now this time i first open state form so it will give me data for state list and for country list it will throw me exception i m not sure but may be der is problem in calling because whenever i close my win application and then again whtever form first time call means whtever object first time created will gve me data plsss help me on this

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

thanks for your reply. can u pls give me any help link for such senario. because my senario is i have one server i ll install my remote service and window application over der now my client(desktop application) will connect to server using one port i.e. 1069 now i want to give mulitple access (RDP) to say 5-10 users now they all will login and will run the same exe but i think its not possible i m not sure about it wil u pls give ur glance to such senario and let me know wht can be possible in my senario y we want to put remote service and desktop application on same machine and then give to rdp because when users are connect from theri own machine then system is not responding as quick as we have too.

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

hi my senario is i have one desktop application and one remote service for server now if i want to connect then i m using http channel with binary formatter now my problem is by using my code i can open one instance at a time for other it will give me error saying only port is normally allowed.... i want to run mutliple exe or instance from same machine which will utilize remote services on server please help me ,, below is my code.

IDictionary props = new Hashtable();
props["port"] = TechnicalSettings.RemotingServerPort;
props.Add("typeFilterLevel", TypeFilterLevel.Full);
//props.Add("timeout", 2000);
BinaryClientFormatterSinkProvider clientProvider = new BinaryClientFormatterSinkProvider();
channel = new HttpChannel(props, clientProvider, null);
ChannelServices.RegisterChannel(channel, false);

                //TcpChannel channel = new TcpChannel();
                //ChannelServices.RegisterChannel(channel, true);

             

                var server = string.Format("http://{0}:{1}/RemoteOperation", TechnicalSettings.RemotingServer,
                                           TechnicalSettings.RemotingServerPort);

                \_remoteOperation = (IRemoteOperation)Activator.GetObject(typeof(IRemoteOperation), server);
                \_exist = \_remoteOperation.TestRemoting();

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

Hi friends, Please help me as i m very confused as per my knowledge static variable always reamin same for all users but recently i joind one compny where i found that they have taken one static class with static members and stored that static class in session [Here Authentication is form authentication] & Now as per website reviews and results till now there is no issue with static class and members so pls do the needful help. Please let me know should i hav to remove static class storing in session or i should continue with that solution . pleasee tell meee

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

thanks it works...

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

I have created my story board using expression blend but when i run the control it will run only once.but i need continues animation pls let me know wht i am suppose to do???

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

Hi russell , 5 from my side. This will run perfectly...

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

modified on Friday, May 28, 2010 1:46 AM

ohhkkk Thanks for your reply now i am clear with my question actually i was confused just because of machine.config. Thanks once again for your reply.

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

Thanks for your reply but i have one query so pls correct me if i m wrong This is how the minimal Web.config file should look like: <?xml version="1.0" encoding="utf-8" ?> <configuration> <system.web> </system.web> </configuration> I do agree that Web.config file is a perfect place to store ASP.NET application configuration settings but if i have above web.config then my other configuration must be in machine.config then how cum web.config called when application pool restarted. I may be wrong but pls give your glance and guide me ...

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

I am not very sure of the exact answer. So, I am posting it to find the correct answer. But i guess Web.config is an xml configuration file. This never gets called directly unless we need to retrieve the configuration setting. I am not dam sure but i think this should happen.

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

when i am swaping element in grid its refelecting on form but at time of saving when i ll go for reading it will not give me updated one . for swaping i am using Grid.SetRow and Grid.SetColumn function.

Border borderInnerAttr;
Grid.SetRow(borderInnerAttr, Grid.GetRow(borderInnerAttr) - 1);
Grid.SetColumn(borderInnerAttr, Grid.GetColumn(borderInnerAttr));

here i am able to swap element in grid but at the time reading grid it will return me the original position of elements. Pls help me ....

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

modified on Thursday, May 27, 2010 8:54 AM

below is used for binding validation

<TextBox x:Name="txtDispalyName" Text="{Binding Path=DisplayName, Mode=TwoWay, NotifyOnValidationError=True, ValidatesOnExceptions=True}" Grid.Row="1" Height="24" LostFocus="txtDispalyName_LostFocus" Grid.Column="2" Margin="18,2,54,0" VerticalAlignment="Top" TabIndex="0" >

while in code behind on save click i m calling below code

ViewModel.IsError = true;
getBindProperty();
if (ViewModel.Save())
{
IsSaveClose = true;
SaveData();

}
else
{
ViewModel._dialogService.DisplayValidationDialog(ViewModel.Errors);
}

while my validation class is

public class MyViewModel : INotifyPropertyChanged
{
public readonly IDialogService _dialogService;
CultureInfo Culture;
public MyViewModel(IDialogService dialogService)
{
_dialogService = dialogService;
}

    private string \_displayName = "";
     

    public bool  IsError { get; set; }
    
    

    public string DisplayName
    {
        get { return \_displayName ; }
        set
        {
            if (string.IsNullOrEmpty(value))
            {
                Culture = Thread.CurrentThread.CurrentCulture;
                IsError = false;
                throw new Exception(Erp3s.Resources.Strings.ResourceManager.GetString("Display Name is required",Culture));

            }
            \_displayName = value;
            OnPropertyChanged("DisplayName");
        }
    }

  


    private readonly ObservableCollection<ValidationError> \_errors = new ObservableCollection<ValidationError>();

    public ObservableCollection<ValidationError> Errors
    {
        get { return \_errors; }
    }

    public bool IsViewStateValid()
    {
        return Errors.Count == 0;
    }

    public bool Save()
    {

                 
        
        
     if (!this.IsViewStateValid())
        {
            return false; 
          //\_dialogService.DisplayValidationDialog(Errors);
        }
        else
        {
            return true;
        }
    }

    public event PropertyChangedEventHandler PropertyChanged;

    protected virtual void OnPropertyChanged(string propertyName)
    {
        PropertyChangedEventHand

I have implemented validation using IDialogService on INotifyPropertyChanged but its not working properly when i click on save button and after successfull insertion if i ll clear my control then also my validation message display error message. if any boday can help me then i ll be thankfull to him.

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

modified on Saturday, May 22, 2010 5:35 AM

INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])] SELECT [source.]field1[, field2[, ...] FROM tableexpression;

you can first insert and then can retrive scalar value like below

select max(ColumnName1) as Max_RowNumber from table_name;

I guess this will help you.

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

HI pls try below code

Select
C1,
C2,
C3,
C4,
case when (C1 + C2) = (C3 + C4) then 'Match'
else 'Unmatch' end as Result
From
(

Select 
Row,
Max(C1) as C1,
Max(C2) as C2,
Max(C3) as C3 ,
Max(C4) as C4
From 
(
			Select 
			ROW\_NUMBER() 
					OVER (ORDER BY TABLE\_A.Field\_1) AS Row,
			TABLE\_A.Field\_1  as C1
			,TABLE\_A.Field\_2  as C2
			,'0' as C3
			,'0' as C4
			From 
			TABLE\_A

			Union ALL

			Select 
			ROW\_NUMBER() 
					OVER (ORDER BY TABLE\_B.Field\_1) AS Row,
			'0'  as C1
			,'0' as C2
			,TABLE\_B.Field\_1  as C3
			,TABLE\_B.Field\_2  as C4
			From 
			TABLE\_B
  )
  as OuterTable
  group by Row

) as FinalTable

n yes let me know which sql version u r using because in sql 2008 we have merge statement too... i hope this will help you ..

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

By assuming your field is of varchar...

case when
(TABLE_A.Field_1 + TABLE_A.Field_2) = (TABLE_B.Field_1 + TABLE_B.Field_2)
then 'Match'
else 'Unmatch' end

i guess this will help you .

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

1)Here's another solution; check the permissions for the relevant ASPNET (worker process) account on the %systemroot%\Temp and the C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files directories. Changing the permissions for the IIS_WPG group on the latter directory from Modify to Full corrected the issue without requiring a refresh of the worker processes in our case. 2)Set impersonate = false for your whole web application:

<system.web>
<identity impersonate="false"/>
…
</system.web>

Put all your code under a directory and set impersonate to true for that location.

Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

Thanks for your reply but i want to know silverlight code sample & yes i am aware of SL will understand xml only. I hav tried sample which is given in demo for menu but Over there we have static menu.xaml which i dont want to use . Please help me ....

Reasons are not Important but Results are Important. Swati Tripathi