Re: Privew of Webcam - C# Discussion Boards

stancrm17-Jun-09 21:56

stancrm

17-Jun-09 21:56

I think it's a localization problem.
Save the date in MySql Date format, not in string.

Tom Deketelaere17-Jun-09 22:46

Tom Deketelaere

17-Jun-09 22:46

strings wrote:
coloum Type is varchar 50

There is your problem

strings wrote:
date format dd/MM/yyyy in getting inserted correctly on my PC.
but when i deployed at client location its gets entered as dd-MM-yyyy format

When displaying a date (and inserting it into db in a varchar column) without specific formating it will display the way the date settings are set in Windows.

First of all you should use a date column type.

Then you can either instruct your client on how to change his OS settings (not recommended)
or do a format of the date.

Ashfield18-Jun-09 1:20

Ashfield

18-Jun-09 1:20

strings wrote:
coloum Type is varchar 50.

If you had said that in the first place it would have been obvious, its a localisation issue nothing to do with sql. Use a proper datatype and your problem will be solved.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

http://www.plus2net.com/sql_tutorial/date-inserting.php[^]

stancrm17-Jun-09 21:05

stancrm

17-Jun-09 21:05

Query Regarding Open Source DotNet Based Desktop Sharing Apps like citrix??

Tridip Bhattacharjee17-Jun-09 20:44

Tridip Bhattacharjee

17-Jun-09 20:44

i search google for Open Source DotNet Based Desktop Sharing apps but did not find anything like that so please if anyone knows that there is such open source dotnet based Desktop Sharing apps then please inform me.....i will be highly obliged.

tbhattacharjee

Query Regarding Open Source DotNet Based Sql Database Synchronization??

Tridip Bhattacharjee17-Jun-09 20:42

Tridip Bhattacharjee

17-Jun-09 20:42

i search google for Open Source DotNet Based Sql Database Synchronization apps but did not find anything like that so please if anyone knows that there is such open source dotnet based apps then please inform me.....i will be highly obliged.

tbhattacharjee

Privew of Webcam

S K Y17-Jun-09 20:07

S K Y

17-Jun-09 20:07

i can connect to webcam....
how can i show preview of webcam in picturebox...???

private void btnDecode_Click_1(object sender, EventArgs e)
        {           
            try
            {
                DeviceManager manager = new DeviceManagerClass();
                Device d = null;
                foreach (DeviceInfo info in manager.DeviceInfos)
                {
                    d = info.Connect();
                    
                }
                Item item = d.ExecuteCommand(CommandID.wiaCommandTakePicture);
                foreach (string format in item.Formats)
                {
                    WIA.ImageFile imagefile = item.Transfer(format) as WIA.ImageFile;
                    imagefile.SaveFile("d:\\test2.JPG");

A S E L A

Re: Privew of Webcam

Christian Graus17-Jun-09 21:52

Christian Graus

17-Jun-09 21:52

Well, you could create a BItmap from test2.jpg, and assign it to a picture box ?

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: Privew of Webcam

S K Y18-Jun-09 1:12

S K Y

18-Jun-09 1:12

sorry sorry that's not what i want....i want to show display privew of web cam befor i take the photos. that mean once i connceted to device i need to start show webcam video on picture box.that's what i want.

A S E L A

how to open a office document as a new document?

amit_8317-Jun-09 19:46

amit_83

17-Jun-09 19:46

Hi,
i have a excel document saved with temp.xls name.
i wanted to open this xls file as a new xls doucment,
not with the name temp.xls doc, and if we close the doc,
then documnent should ask the user to save file else
where.
give me suggestion to solve this problem.
thanks in advance.

modified on Thursday, June 18, 2009 2:08 AM

Re: open office document

Rajesh Anuhya17-Jun-09 20:02

Rajesh Anuhya

17-Jun-09 20:02

how it's related to Open Office(subject Line)????? D'Oh! | :doh:

Rajesh B --> A Poor Workman Blames His Tools <--

Re: how to open a office document as a new document?

Vikram A Punathambekar17-Jun-09 20:36

Vikram A Punathambekar

17-Jun-09 20:36

Your question is very hard to understand. You want to have a file called temp.xls, but don't want to open it as such? Create a copy of it and open it. If you don't want it to be overwritten, make it read-only.

Cheers,
Vikram.

Recent activities:
TV series: Friends, season 8
Books: Freakonomics, by Steven Levitt and Stephen J Dubner.

Carpe Diem.

Re: how to open a office document as a new document?

amit_8317-Jun-09 21:21

amit_83

17-Jun-09 21:21

tnanks for reply, actuly i saved an excel file into temp folder,
and if we open this file and then close it from upper left corner 'X'(close) button then excel document do not ask to save
the file, untill i don't do any modification in file.
so what i want, if i launch temp
file and then user try to close the file then document should ask
the user to save the file, if user want to save the file then it should ask for the filepath where he want to save, instead of using temp file path, beacuse i am using it for temprary purpose.

FFT or DFT library for C#

jobin00700717-Jun-09 19:33

jobin007007

17-Jun-09 19:33

I need a DFT library for C#. I tried this http://www.exocortex.org/dsp[^]
But it did not work the way I wanted to.

Do you know of any other librarys in C# that is available either free of cost or for money?

Thanks

Re: FFT or DFT library for C#

Curtis Schlak.18-Jun-09 12:50

Curtis Schlak.

18-Jun-09 12:50

Have you tried ILNumerics[^]?

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: FFT or DFT library for C#

Steve Hageman15-Jul-16 12:20

Steve Hageman

15-Jul-16 12:20

A very old thread, but it still gets searched. Perhaps this will help,

A "Ready to run" Open Source DFT / FFT Library has been published for C# here on Codeproject,

DSPLib - FFT / DFT Fourier Transform Library for .NET 4

setting the file version

subramanyeswari17-Jun-09 18:21

subramanyeswari

17-Jun-09 18:21

Hi,

Is it possible to set the file version to dynamically generated vb 6 exe in C#?

Any links/source code would be a great help.

Thanks in advance

Is it possible to get result set from a Oracle store procedure via ODBC?

Morven Huang17-Jun-09 17:33

Morven Huang

17-Jun-09 17:33

Hi guys,

I got a Oracle store procedure which would return dataset using a ref cursor,it's quite easy to get the result set if I use the classes in System.Data.OracleClient because there's a type OracleType.Cursor which matches the procedure parameter's type.

But is it possible to do this via ODBC? There isn't a type likes 'OdbcType.Cursor'.

Anything you can help it would be appreciated. Smile | :)

Creating a new excel workbook with C#

Jeffrey Webster17-Jun-09 17:31

17-Jun-09 17:31

Hi,

I need to work with Excel via C#, but I'm having problems getting started. Keeping it simple to start, I'd just like to open a new Excel workbook.

MSDN describes using code like this:

objExcel = new Excel.Application();
objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));

Yet Excel is not recognized by the compiler, which I'm assuming is because I haven't exposed the right namespace.

I'm not sure what that would be. Intellisense is not offering Excel as an option anywhere I've looked. Elsewhere I've heard about using ADO.NET, but haven't seen anything I can get to work.

If anyone has worked with Excel via C# I'd appreciate any guidance...

Thanks,
Jeff

padmanabhan N17-Jun-09 18:19

padmanabhan N

17-Jun-09 18:19

you have to use the name space :
using Microsoft.Office.Interop.Excel;

And this helps to open the excel:
Microsoft.Office.Interop.Excel.Application m_objExcel;
Microsoft.Office.Interop.Excel.Workbooks m_objBooks;
Microsoft.Office.Interop.Excel._Workbook m_objBook;
Microsoft.Office.Interop.Excel.Sheets m_objSheets;
Microsoft.Office.Interop.Excel._Worksheet m_objSheet;
Microsoft.Office.Interop.Excel._Worksheet m_objSheetIntro;
Microsoft.Office.Interop.Excel.Range m_objRange;
object m_objOpt = System.Reflection.Missing.Value;
m_objExcel = new Microsoft.Office.Interop.Excel.Application();
m_objBooks = (Microsoft.Office.Interop.Excel.Workbooks)m_objExcel.Workbooks;

m_objBooks.Open("Your excel file path here", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);

Padmanabhan

Jeffrey Webster17-Jun-09 18:38

17-Jun-09 18:38

Hi,
Thanks for your reply. For some reason my compiler is not recognizing the Office part of the namespace.

If I use Intellisense after Microsoft it gives me [Contracts, Csharp, Internal, SqlServer, VisualBasic and Win32.] Not Office.

I'm using C# Express. Could that be the problem. Maybe I need a higher level version?

Jeff

padmanabhan N17-Jun-09 19:14

padmanabhan N

17-Jun-09 19:14

no, just you have to add references..
1) rightclick your solution file.
2)click add reference.
3)add the reference file.

Padmanabhan

Jeffrey Webster18-Jun-09 5:14

18-Jun-09 5:14

Hi,

Again, thanks for your replies.
It's a minor miracle, but at least the system is recognizing the namespace. I'm not sure what has changed since numerous times I tried different combinations of Excel Object refs and Office Object Library refs (earlier/later versions).Nothing seemed to work.

I tried one last time by deleting as many refs as possible and referencing only Excel 11.0 Objects. Suddenly it worked. I'm saving this as-is and will experiment later to see if I can replicate the bug.

Thanks,
Jeff

Re: Found Office

Jeffrey Webster17-Jun-09 19:28