how to create a database - C# Discussion Boards

Nader Elshehabi13-Sep-06 5:57

Nader Elshehabi

13-Sep-06 5:57

Hello

I don't really have a grip of what you want to do, yet I think Web Services will suit you best.

1- Make a web service
2- AS new pictures arrive to your storage -whatever it is-, update your status -maybe an xml file with the date/time and file names of latest picture?-
3- Now the client desktop app will be in contact with the web service on intervals -seconds, minutes, whatever suits you-, to read the xml sent by the web service -something like RSS feeds-.
4- Now when the client finds a suitable download, it can send a request to the webservice to stream that picture. It will be a simple matter of transfering a file, and I think displaying a picture won't be an issue.

I hope I got you right.

Regards

ErikZ13-Sep-06 23:36

ErikZ

13-Sep-06 23:36

Thank you for coming with good ideas.

You have understood what I want to do, but I was hoping to find a solution without polling. It could be like watching an avi-file with only one frame per 5 minutes. Smile | :)

Or waiting for an event to trigger, and then read a new file from the WS. As I'm writing this I start to think about SQL Notification Services. Anyone that knows about it? Will it be suitable in this senario?

Thanks again.
/ Erik

Nader Elshehabi14-Sep-06 1:49

Nader Elshehabi

14-Sep-06 1:49

Hello

Streaming images is different from streaming video, and both are different from streaming live video. what are you trying to do?

Regards

ErikZ14-Sep-06 2:36

ErikZ

14-Sep-06 2:36

A long time ago I wrote a system for collecting pictures from cameras. Some of these pictures was taken upon request from the user while others was taken regularly. I have now begun to think of a new modern version of the system. And I want a smart solution where det system knows if there is a user waiting for a picture(maybe start a new collection!?!) and when a new picture arrives it sholud be automatically sent to the user.

An ideal situation would be if the interval between the pictures can vary very much, from a few seconds to several hours.
And the next step for such a system is to provide other auto-updated data/temperature, humidity...) to the users.

My english is not the best but I hope I can make my self understood. Smile | :)

/ Erik

Nader Elshehabi14-Sep-06 3:08

Nader Elshehabi

14-Sep-06 3:08

Allright!!
So, you want to braodcast a continuous sequence of still images at regular/request bases. Well!! One design model I can think of will be:
1- A Server connected to the camera(s), which take the pictures at the lowest interval supported
2- A webservice that will act as a gatekeeper to the pictures database
3- Distibuted Desktop client applications that will make the request
4- The webservice will receive the request from each Client by IP and process the Date/Time of the request then it should extract the image with the closest date/time from the database server -SQL is your best choice as you said-
5- Then the service would broadcast pictures/data back to the user
6- The user can make the client app to make regular requests -eg. 1 frame/5 seconds- with the same mechanism as above.

But I think you already have done that?? What is your question?? You shouldn't notify the client(s) if the is available new pictures because the definition of "new" is put by the client based on the last picture they have recieved. Request based service is the best model I can think of, besides terrabyte programs like Google earth and MS Virtual Earth work this way. why don't you like it?

Regards

Re: how to create a database

ErikZ14-Sep-06 20:46

ErikZ

14-Sep-06 20:46

Thanks again for all your answers!

Maybe I have thought of this too much.... Smile | :)

The system consist of more than 150 cameras all over the country. Today we communicate with these cameras by old modems. In a near future SOME of the modems may be replaced by....something else....e.i. ADSL, GPRS....something with higher transmission speed. Maybe some of the cameras is upgraded also so they can send video stremas instead of todays still images.

So my wish was to find a uniform way to ditribute these pictures despite the underlaying hardware(and thus the framerate).

Polling is defenitely a possible solution, but it will be a lot of polls if manyusers want to see video-sequenses. Smile | :)

how to create a database

faladrim12-Sep-06 23:39

faladrim

12-Sep-06 23:39

lo,

i want to create database in vs2005 dynamicly so i can add and delete collums and rows and tables
the database is than saved in ms access. (so before you run the vs2005 there is nothing in the ms access databas.), but for every new day there is another file where its saved in, so the changes that were made yesterday are kept in a file like a log.
i went searching on the web but i cant find what i am looking for, do you have any tips or links with examples?
thx

led mike13-Sep-06 4:52

led mike

13-Sep-06 4:52

See this article[^] which shows how to create MS Access Database files and then use them.

led mike

Groupe Item Selection Problem

salman_syed_0112-Sep-06 23:38

salman_syed_01

12-Sep-06 23:38

Sir, I have created a flowchart in visio 2003 through C# extensibilities COM-Add-ins type.
In Flowchart one shape group simply such as Rectangle contain two an other shape,and when i select/click subshape
visio return only Supershape name such as Rectangle
This is a problem of selection in visio what i do?
how to get subshape name in grouping please solve my problem.

salman

how to print document in landscap

ayyp12-Sep-06 23:24

ayyp

12-Sep-06 23:24

hi all,
i need to create the report document in landscape or in portrait format...

and i need to print this document according to this document type.....

that is if the document is in landscape format then the printout shout be in landscape....

else if it is portrait then the printout should be in portrait...

i need to do it with asking the user...by print preview...is it possible....

ayyp

Re: how to print document in landscap

Niiiissssshhhhhuuuuu12-Sep-06 23:45

Niiiissssshhhhhuuuuu

12-Sep-06 23:45

printFont = new Font("Arial", 10);
PrintDocument pd = new PrintDocument();
pd.PrintPage += new PrintPageEventHandler(pd_PrintPage);
pd.PrinterSettings.PrinterName = printer;
// Set the page orientation to landscape.
pd.DefaultPageSettings.Landscape = true;
pd.Print();

If I am not getting you wrong than this will solve your problem....!!!!

Enjoy Cool | :cool:

<marquee>nishu

Re: how to print document in landscap

ayyp12-Sep-06 23:53

ayyp

12-Sep-06 23:53

is it possible to create the document in landscape formate...if so how...?

ayyp

Draw rectangular

Nafiseh Salmani12-Sep-06 22:49

Nafiseh Salmani

12-Sep-06 22:49

i want to draw rectangular on a picture box but it goes back the image!!!
how could i draw rectangular on fire with mouse that comes on the image ???

Re: Draw rectangular

Christian Graus12-Sep-06 22:55

12-Sep-06 22:55

You're probably using CreateGraphics ? Don't.

You have two options.

1 - draw your own image and draw a box over it
2 - draw a box onto the image itself

If you're trying to draw a selection rect with the mouse, then you need option 1, so you can draw above the image, instead of onto it.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Draw rectangular

Nafiseh Salmani12-Sep-06 23:07

Nafiseh Salmani

12-Sep-06 23:07

I did it , but it goes back of the image.
could u please send a Sample Code about it?

 private void Form1_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)<br />
{<br />
<br />
  this.X2=e.X;<br />
  this.Y2=e.Y;<br />
<br />
  Graphics dc = this.CreateGraphics();<br />
  Pen BluePen = new Pen(Color.Blue, 3);<br />
  dc.DrawRectangle(BluePen, X1,Y1,X2-X1,Y2-Y1);<br />
<br />
  Brush obj_brush=Brushes.Blue;<br />
<br />
  dc.FillRectangle(obj_brush,X1,Y1,X2-X1,Y2-Y1);<br />
<br />
<br />
<br />
}

Re: Draw rectangular

Christian Graus12-Sep-06 23:32

query regarding onmouseover event

12-Sep-06 23:32

Please, go back and actually READ my response. NEVER use CreateGraphics unless you know exactly what it does, and it's what you want it to do. CreateGraphics could be used for this selection box, IF you didn't use a picture box. But the picture box is being invalidated, and so your box is being deleted. Either way, I prefer not to use such expensive hacks, I draw it all in my paint method.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

ParagGupta12-Sep-06 22:46

ParagGupta

12-Sep-06 22:46

the upper one is the JavaScript code and the lower one in HTML code that I am using in ASPX file for applying the onmouseover functionality on the login button.
Now I would like to use this button (login) as to navicate to some other page (main.aspx ) after clicking it.
Can somone please tell me the function that I should write in the codebehind page (*.aspx.cs) for doing as above................

Re: query regarding onmouseover event

Christian Graus12-Sep-06 23:02

tab control for web applications

12-Sep-06 23:02

You can't. You're using HTML, not server controls, so there's no postback and no event being generated for the code behind. You can do it all on the client, or you can change it to use server controls.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Mohammad Daba'an12-Sep-06 22:26

Mohammad Daba'an

12-Sep-06 22:26

hi all, I want to make a tap control on web application, there is a tap control for windows ones but I don't know how 2 do it on web ones,

you can see a sample on www.yahoo.com

thanks allllll

Thanks alot
Hamody

Christian Graus12-Sep-06 22:45

12-Sep-06 22:45

There isn't one, but it's easy to write one, it's just a control that sets which tab is selected and draws it differently, and draws the others as links. There's probably one on CP.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Mohammad Daba'an13-Sep-06 3:11

Mohammad Daba'an

13-Sep-06 3:11

thanks a lot for trying to help me, but i didn't understand what you meant by cp, and how i can get a sample for this asked thing ... please try to send me a code sample Wink | ;)

Thanks alot
Hamody

Christian Graus13-Sep-06 11:20

13-Sep-06 11:20

CP == Code Project

this[^] is just the first of many hits I got by searching 'ASP.NET tab' on this very site.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog