|
I'm pretty sure the indexer will accept a string as well as an integer Workbook.Worksheet["SheetName"]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Could you show an example refer to worksheet and search for an arbitrary column? Because I never did it. If you can. Thanks.
|
|
|
|
|
bonjour, 
"""pour le moment je suis entrain de développer une application qui enregistre le son( sous forme numérique) entré par une carte électronique dés le port // .alors j'ai qlq questions a vous posé .
1) comment enregistrer du son qui va être sous forme numérique avec une application c # sur une base de données (sql server) ?
2 ) aussi comment lire ce son enregistrer (Sous forme numérique) dés la base de données ???
merci d'avance"""""
|
|
|
|
|
Je suis désolé, mais c'est un site anglophone. Vous allez vous tenir plus de chance d'obtenir une réponse si vous traduisez votre question en anglais.
The Google translation:
""" "for now I am trying to develop an application that records audio (digital form) entered into an electronic card dice / / port. so I QLQ questions you asked.
1) how to record sound which will be in digital form with a C # implementation of a database (sql server)?
2) how to read it as his record (In digital form) dice the database??
thank you in advance "" "" ""
|
|
|
|
|
thank's man don't worry i speak english too 
|
|
|
|
|
Je ne habbello Francais. You'll find that the documentation is in English, the community is English, and that hence, the preferred language is English.
What do you want help with exactly? Recording sounds as binary, saving binary to a database, or the whole shebang?
Bastard Programmer from Hell 
|
|
|
|
|
Thank's sir for your answer
by the way the sound that will enter by the Parallel Port as Digital Data so i wanna saving binary to a database with c sharp application .
how can i do that ??
|
|
|
|
|
Direct communication with a port is prohibited under Windows, you'd need a driver to talk to. We got an article[^] on that, of course.
The hard part won't be fetching the data, nor writing the data to some database. The hard part will be to transform those bits to some music-format, like wav or mp3. No, that's not a trivial task, and is usually done by the drivers of the sound card. Our applications usually speak with those drivers, using Windows' API, not with the machine directly.
If you're going to speak to some machine, you'll have to be able to speak it's language - meaning that there's a manual somewhere explaining how the data that you're receiving is encoded.
Bastard Programmer from Hell
|
|
|
|
|
yes sir ,
I could read and write to the parallel port with c # but the problem is that I'll connect the parallel port card with my carte electronic of its digital form I know not in what form I will record this with C # in the Database .
if you could help me.
|
|
|
|
|
I cannot help; only the manufacturer of the device can tell you how it encodes it's audio, and thus, how you should decode it.
Bastard Programmer from Hell
|
|
|
|
|
it's me the manufacturer of the device lol
|
|
|
|
|
Then you will be the only one who can tell how the hardware will encode the data, and "what" the device will be sending to that port.
Bastard Programmer from Hell
|
|
|
|
|
A sound in binary form is just a byte stream. You can use a BLOB database column to store it, with some kind of ID or name as the key.
|
|
|
|
|
thank you for your help,
I just just want you to know that the dice are entered by 8bits 8bits Parallel Port successively so how can I Register this with c # application on the database.?
|
|
|
|
|
Hello !
Can any one please help me on how to detect a windows change?
What I wish to accomplish is detecting when a user changes from one window to another, for example user has 3 programs running, Internet Explorer, Skype and Notepad, user is Browsing in Internet Explorer and then he changes to skype, when this happens I would like my C# program to detect that change. Is this possible? How can i do this?
Thank you very much 
|
|
|
|
|
You would have to implement a Windows CBT Hook callback. This will notify you of any changes to the windows, including which one is going to be activated, created, destroyed, ...
Read this...[^]
|
|
|
|
|
|
I have google a lot but i just find Copy Hook Handler (ICopyHook) but didnt know how to use!
i wanna to prevent user from deleting trace.trc file but system can update the info in it.just prevent from deleting it,even if the program is closed soin windows also prevent from deleting .
|
|
|
|
|
This isn't going to work, at least not in a user application.
You can't prevent a file from being deleted unless you modify the security permissions of the file, appropriately. The problem with doing this from a user application is if the user has appropriate permissions to the foler above the file, they add their permissions back to the file itself and reverse whatever you do.
What's the point of preventing the file from being deleted??
|
|
|
|
|
Why are you afraid of the file being deleted? If it's part of your application, then it'll be copied to the application-folder of your application. Users aren't supposed to delete anything there. There's NO WAY of preventing users to delete an item (and there never will be) - you'll have to trust the idea that they won't try to kill your application on purpose.
Look at it this way; if I delete things from the "World of Warcraft"-folder, chances are that my game will no longer work. Is that the fault of Blizzard, or my fault? Obviously my fault 
Yes, this sh*t happens often. That's why most installers give the option to "repair" an existing installation, where they re-copy the original installation files. That would be the correct way to restore your missing/corrupted trace-file if it suddenly went missing.
Best option (if the file is readonly) would be to include it in your executable as a resource. But don't lock my files on - it'd feel as if you were hijacking my computer, and that's not a good feelin'.
Bastard Programmer from Hell 
|
|
|
|
|
Hi,
Thanks for your reply in both C#,Database Pages.
I want user unable to delete or replace the trace (SQL) file.cause if the trace file delete i cannot get what things the user done wrong in SQL.(cause they know that everything is in trace file of SQL).
Q2)if they delete the .trc file of SQL can i take all trace from SQL (I mean old trace in special database)?
|
|
|
|
|
If the user deletes a file that your app needs, the app is simply broken. What's the use of checking if the file has been deleted, if I can replace it with trace-file that simply shows nothing?
This merely gives someone the impression of security. That's a bad idea by definition.
Bastard Programmer from Hell 
|
|
|
|
|
hi,
if this file deleted the app wont broke!
It just take trace on every thing happened in DB.
So,isnt there any way to do that?
|
|
|
|
|
Your app will also break if they delete a DLL from the .NET Framework! Will you "protect" those too? What about those files in the "Windows" folder?
You can only protect files if you're the owner of the machine; an admin can make files write-protected, but if the user is an admin, he can still delete them - which is logical, since they're his files, not yours.
Like a car, if you remove a part - you can expect things to break. No, a regular user will not go to the "Program Files" folder and delete random files. If they do, they're the ones responsible.
Bastard Programmer from Hell
|
|
|
|
|
I know all that!
but when customer make mistake in his accounting app if he delete the .trc file then how can i prove that the mistake is from there side?
cause that i wanna to protect that file from deleting.OR i get the old trace sp_trace_setevent (Transact-SQL) from his/her database.so then if he/she delete that file i can get that back.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
