|
Try to do your homework, when you are stuck , post your question and you would get help.
|
|
|
|
|
Dear All
Normally the query used to read Excel file is "SELECT * FROM SHEET1$"
Can anoyone help on how can we read specific columns using the query.
For Eg. If we wan to read only columns C, D, and F then is there anything like "SELECT C, D, F FROM SHEET1$"
Regards.
|
|
|
|
|
Has the thought occurred to you to go and look on MSDN? Have you tried:
Vipul Bhatt wrote: SELECT C, D, F FROM SHEET1$
and what was the result?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Getting an error "No value given for one or more required parameters." if any of the following queries are used.
> SELECT C, D, F FROM SHEET1$
> SELECT COLUMN3, COLUMN4 FROM SHEET1$
And yes tried searching MSDN as well. The process is still on.
Regards.
|
|
|
|
|
|
Has anyone got any code for phase lock loops?
Cheers
Baz
|
|
|
|
|
Sounds like something off star trek to me
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein
I look at Microsoft, and turn to my poster on the wall saying: "Bang head here in case of stress".
|
|
|
|
|
haha - not quite.
usually called PLL and can be performed with circuitry but i wanted to do PLL in a program.
to quote wikepedia:
"A phase-locked loop or phase lock loop (PLL) is a control system that generates a signal that has a fixed relation to the phase of a "reference" signal. A phase-locked loop circuit responds to both the frequency and the phase of the input signals, automatically raising or lowering the frequency of a controlled oscillator until it is matched to the reference in both frequency and phase. A phase-locked loop is an example of a control system using negative feedback.
In simpler terms, a PLL compares the frequencies of two signals and produces an error signal which is proportional to the difference between the input frequencies. The error signal is used to drive a voltage-controlled oscillator (VCO) which creates an output frequency. The output frequency is fed through a frequency divider back to the input of the system, producing a negative feedback loop. If the output frequency drifts, the error signal will increase, driving the frequency in the opposite direction so as to reduce the error. Thus the output is locked to the frequency at the other input. This input is called the reference and is derived from a crystal oscillator, which is very stable in frequency.
|
|
|
|
|
 Oh I see, not entirely sure what its function is actually for, but get the vague idea. Im not really sure, bit beyond me that code, unless it can be done fairly simply? Im not really sure 
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein
I look at Microsoft, and turn to my poster on the wall saying: "Bang head here in case of stress".
|
|
|
|
|
Nope, still sounds like something from Star Trek.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein
I look at Microsoft, and turn to my poster on the wall saying: "Bang head here in case of stress".
|
|
|
|
|
Mycroft Holmes wrote: still sounds like something from Star Trek
I ditto that. Maybe the OP ought to ask Scottie 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
it sounds complicated but it isnt really.
just a negative feedback circuit.
Used for frequency and phase stability or noise cancelling/suppression.
Shouldnt be that hard to code up - but i thought i would ask to see if anyone had already.
I am guessing it will start with reading in an input buffer, conducting FFT then monitoring frequency and phase shifts, then mixing these outputs with the inputs in a loop so that you can selectively control the freq and phase outputs.
- no di-lithium crystals in there anywhere.
Cheers
|
|
|
|
|
rapidgeo wrote: it sounds complicated but it isnt really.
You did notice the joke icon of my other post about Scottie from Star Trek, I hope.
Seriously, I don't have an idea quite yet code-wise, but I do have some idea what you are asking for.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
rapidgeo wrote: guessing it will start with reading in an input buffer, conducting FFT then monitoring frequency and phase shifts, then mixing these outputs with the inputs in a loop so that you can selectively control the freq and phase outputs.
Sounds like a reasonable stab at it.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
sorry i should have put a joke icon next to the di-lithium crystal reference. 
Thanks - will have a stab at it and see how far i can get.
If there is any code available to do any of what i suggested as a first attempt then this will get me started.
1. reading input buffer.
2. conducting FFT.
3. splitting into freq and phase.
4. mixing back with input signal after imposing a threshold value for selectivity.
Cheers
Baz
|
|
|
|
|
i wanna a if statement to detect if some values are present on some keys,if true do some app
|
|
|
|
|
Like this...
using Microsoft.Win32;
...
RegistryKey masterKey = Registry.LocalMachine.CreateSubKey
("SOFTWARE\\Test\\Preferences");
if (masterKey == null)
{
Console.WriteLine ("Null Masterkey!");
}
else
{
Console.WriteLine ("MyKey = {0}", masterKey.GetValue ("MyKey"));
}
masterKey.Close();
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Is this now a C# forum? 
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
My Mistake 
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
No worries, but hey, the OP can at least convert that from C# to VB.NET (hopefully  )...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
By mistake, I gave you the C3 code...
here you go... ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Dim masterKey As RegistryKey = Registry.LocalMachine.CreateSubKey("SOFTWARE\Test\Preferences")
If masterKey Is Nothing Then
Console.WriteLine("Null Masterkey!")
Else
Console.WriteLine("MyKey = {0}", masterKey.GetValue("MyKey"))
End If
masterKey.Close()
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Manas Bhardwaj wrote: By mistake, I gave you the C3 code...
Is that the new name for C#? 
I bet you hate me now 
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Manas Bhardwaj wrote: C3 code...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Looks like I need to press the Shift button more harder from next time
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
