|
i want to join a tables multiple column with another tables single column, how can i do this. i am getting answer when i m doing it with single column to single column, can any body help me. Thanks in advance
|
|
|
|
|
Have you tried it? Are you getting any errors?
|
|
|
|
|
thank you for your response my problem is solved now
with the help of alias names
|
|
|
|
|
|
This is a SQL question and we have a SQL forum. If you bother to ask there, try to ask a question that actually explains what you want to do, what you've tried and where you are stuck.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
sorry for posting sql question here
thank you for ur response my problem solved now
with the help of alias names
|
|
|
|
|
Respected Sir's/Friends, i am building a project called a VideoBroadcaster, in this project i have to build a server and client. when the admin user will play a video file on the server same file should be played at the client machine.
Suggest me how to achieve this.
remoting? tcpchannel ? httpchannel or socket ? which one will be better.
we will need serialization?
Kindly help me thanks in advance
|
|
|
|
|
So, an admin starts a video on the server, it HAS to play on the server, and also be visible on the client ? They have to be in synch ? The admin can pause the video and it pauses on the client ? How much do you need them to play on the server, and how much control should the server have ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks for reply
Admin will have the full control and in admin module we will have a video player type UI, in which he can play/pause/stop and that should be visible on the client machine
|
|
|
|
|
OK, well, that does make things more messy. If it's not a web based UI ( which I assume by what forum you're in ), then I'd imagine you'd send the videos down to the client, and you'd use a connection ( perhaps through WCF ? ), to send messages to all the clients telling them when to pause, when to play, and from time to time to tell them where the admin video is at so they stay in synch.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
It’s a scenario in which the instructor I will play a training tutorial on the system(server system) and the 25 students will be watching on their system(client), instructor can pause, play, stop.
I think I am not able to explain u properly sorry
its Windows base will be working on Lan
|
|
|
|
|
amaankhan wrote: It’s a scenario in which the instructor I will play a training tutorial on the system(server system) and the 25 students will be watching on their system(client), instructor can pause, play, stop.
OK, that's exactly what I thought.
amaankhan wrote: ts Windows base will be working on Lan
OK, well, being on a LAN probably makes it easier to establish TCP connections to pass data around. I still think you want to give everyone a program which can play the video, but that only plays/pauses/stops based on the messages coming from the instructor machine.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
yes, client will only have a option to close the file, that's it
So what should i use , Remoting with tcpchannel ?
and how to send the video file,and play it(serialization? )
|
|
|
|
|
I would think if you're just on a LAN, you would put the videos onto a shared location and transmit just that file location to the client. To be honest, the amount of network traffic will be so small, that I don't think it will matter what you use to communicate. Remoting will work just fine.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
thanks for the help.will be needing ur help in future in these prject. thanks
u means to say the file which is beeing played in the admin first should be stored on the shared folder, and from the client use this file from shared folder and play it ?
for these does we need serialization ?
can u suggest me any references or example for this.
thanks
|
|
|
|
|
amaankhan wrote: for these does we need serialization ?
I have no idea why you keep refering to serialization because it has nothing to do with anything you are discussing. I am saying, if you're on a LAN, then the files can be on a folder that all the students can view. So you send a file path through your remoting connection, and then connect to the file, or copy the file from the central location, just with a File.Copy command.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i want the file which the instructor is playing on the server should be played on the students system automatically
|
|
|
|
|
I think I'd want to do a test first, just playing the video on 25 machines simulaneously. At about 640*350 resolution, you will be streaming about 3Mbyte of data per second from the same server - with network overhead etc, you may get stuttering, especially if you are not on a dedicated or fastish network.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
CG did say to copy the file first to local drive that would resolve that issue (k it would create a burst at the start but once playing the only network traffic would be the instructions from the server)
|
|
|
|
|
He did, but then sugested a path they could all get at. If they are held locally then there is no problem, it's a relatively simple MediaPlayer and sockets problem. I just felt that if it was a single copy being read (which is obviously a whole lot easier for configuration and control purposes) then test it first!
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
You need the path to know from where to copy the file
So server sends network path to video file to all clients, clients use this path to copy the video file from the server to there local drive.
After that clients use the local copy of the video file to play it.
(At least that's how I understood it)
|
|
|
|
|
If I was one of the poor sods on the course, that would annoy the hell out of me, particularly if I was paying with my own money:
1) Start training video
2) Wait a few minutes while we copy the file over the network.
3) Video starts.
Copy them all to local HDD: no delay, no stutter, no problem. You can then control it in MediaPlayer (or whatever) via sockets so the trainee does not need to go anywhere near the video file itself.
If the tutor is that paraniod, he can copy them ready in preparation for the days lesson.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
Didn't say it wouldn't be annoying
I guess it depends on how large the files are.
But even in your scenario the logic still holds, minus the copy part. And provided the tutor put the files all in the same location (something like c:\videos).
I guess the best option here would be:
Go buy a projector
|
|
|
|
|
Tom Deketelaere wrote: Go buy a projector
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
buy a projector............
help me out its a wonderfull challenge to do
|
|
|
|