Mediaelement not showing the media.

SilverLight 1.1 Media element not showing the media.

Mediaelement not working with my case, but may be these links will help in your case.

http://silverlight.net/forums/p/1532/8690.aspx#8690

http://silverlight.net/forums/t/2914.aspx

I am using like

<MediaElement Width="400" Height="300" Canvas.Left="10" Canvas.Top ="10" Source="viz.wmv" AutoPlay="True"/>

It don’t showing any error but not showing the video also.

When I tried using http://sever/viz.wmv its giving download error ErrorType: 1001

Trying to get what may be the reason.

After a lot of hard work I get the problem.

The video file I was using having some problem, however this was working with media file. Funny na ?? So let check with other media file also, if you are facing the same problem.

mediaelement not showing the media.

SilverLight 1.1 Media element not showing the media.

 

Mediaelement not working with my case, but may be this link will help in your case.

http://silverlight.net/forums/p/1532/8690.aspx#8690

 

I am using like

<MediaElement Width="400" Height="300" Canvas.Left="10" Canvas.Top ="10" Source="viz.wmv" AutoPlay="True"/>

It don’t showing any error but not showing the video also.

When I tried using http://sever/viz.wmv its giving download error ErrorType: 1001

 

Trying to get what may be the reason.

 

Getting all the constraints for a Table

How to get all the constraints for a table?

 

Sysconstraints table –

This is the table which contains the constraints which are defined on various tables.

If you query by – SELECT * FROM sysconstraints

You will get OUTPUT –

constid     id          colid  spare1 status      actions     error

----------- ----------- ------ ------ ----------- ----------- ------

2099048     2133582639  6      0      2069        4096        0

11147085    1269579561  2      0      2067        4096        0

14623095    2130106629  6      0      2069        4096        0

27147142    1301579675  2      0      2067        4096        0

For details go to http://msdn2.microsoft.com/en-us/library/aa260399(sql.80).aspx

 

Now come to the actual point – getting all constraints for a table

 

SELECT OBJECT_NAME(constid) 'Constraint Name',

  constid 'Constraint ID',

  CASE (status & 0xF)

    WHEN 0x1 THEN 'Primary Key'

    WHEN 0x2 THEN 'Unique'

    WHEN 0x3 THEN 'Foreign Key'

    WHEN 0x4 THEN 'Check'

    WHEN 0x5 THEN 'Default'

    ELSE 'Undefined'

  END 'Constraint Type',

  CASE (status & 0x30)

    WHEN 0x10 THEN 'Column Level'

    WHEN 0x20 THEN 'Table Level'

    ELSE 'Unknown'

  END 'Constraint Level'

  FROM sysconstraints

  WHERE id=OBJECT_ID(‘TABLE_NAME’)

 

This will result to all the constraints applied to this table.

Error code 1001 silverlight

While I run a silver light application, I get the

Silverlight error message

Error Code: 1001

Error Type: DownloadError

Message: AG_E_UNKNOWN_ERROR

 

Solution: Visit the following link

http://silverlight.net/forums/t/586.aspx

 

 

 

How to close secure connection

I have two web service suppose A and B which should be call from an application, for this I am using Proxy class and meking the call. To get access these services one need to have client certificate. Now the problem is that when I calling the services one by one A and B one in one go , A is working but B is failing. But if i call both in one go [ofcourse one by one] both A and B work.

What may be the problem??

I think it is due to once connection is opened by A used by the B so both passes while in case of individual A and B fail. If we change the order of calling now the B fails , A passes.

Application Instance is already running in C#

How to make sure that only one instance of application is running in C#

 

 

public static void Main(string[] args)

        {

// ----------------------------------------------------

            bool running;

            Mutex mutex = new Mutex(true, “Your application name”, out running);

 

            if (!running)

            {

                Console.WriteLine("Another instance is already running.");

                Console.WriteLine (Messages.ExitMessage);

                Console.ReadKey(false);

                return;

            }

// -----------------------------------------------------

 

 

Your all working code will go here

 

 

// -------- Don’t forget to include this

 

            GC.KeepAlive(mutex);  //1

 

            mutex.ReleaseMutex(); //2

  }

 

Note: Use only one either 1 or 2 both will works, but make sure one is present.

 

Now only one application will run at a time.

How to get the first not null column from a table?

Hey , really a tricky question , select all the values into a single column from a table which is first not null in that table.
For Exapmle
There is table test

id	col1	col2	col3	col4
1	NULL	NULL	W	M
2	Q	NULL	R	NULL
3	NULL	W	P	T
4	NULL	NULL	NULL	S

Now I want to get the result like that in a single column
First Not NULL Values
W
Q
W
S

So what you think how can we get that,
First thing is that you can use cursor and loop each row and get them.
The second one is the use of COALESCE to get that

this query will get the result

SELECT COALESCE(col1,col2,colo3,col4) FROM TEST

If you have any query you can ask me at matespoint@gmail.com