OleDB UPDATE command throws exception - C# Discussion Boards

StuffyEst10-Mar-09 12:15

10-Mar-09 12:15

I have returned with my "small" problem.
Short overview:
1) Problem was/is that my graphics disappeared when you move them out of screen borders and pull them back or put some other window over them.
2) Graphics are updated every time I move my trackbar (which gives values to function to draw the graphic based on the values)

So I've made some progress, but still stuck on other part.

I have 3 different functions, one for graphic, second for graphic and third for axis.

I solved the paint problem with Axis, since its static and never changes, so it was quite easy to convert to paint event. On the other hand, graphs have both 2 parameters that they receive and the graph changes after that according to the values given.

Example : public void JoonistaGraafik(int k1, int k2)

now when I want to make it to paint event "public void JoonistaGraafik(object sender,PaintEventArgs e, int k1, int k2)"

I have problem calling out in InitializeComponents();

this.GraphPanel.Paint += new System.Windows.Forms.PaintEventHandler(JoonistaGraafik(slider_a, slider_b));

the thing is that, my two values "slider_a" and "slider_b" are generated in the trackbar_scroll event and then JoonistaGraafik(slider_a, slider_b); was called out.

I'm pretty bad in explaining, but I hope that made a bit sence.

In conclusion, the question is, how can I call out
"this.GraphPanel.Paint += new System.Windows.Forms.PaintEventHandler(JoonistaGraafik(slider_a, slider_b));"

if the slider_a and slider_b values have to change when I move the trackbar.

Or how can I make a paint event which gets values from trackbars (means the graphic has to update itself every time trackbar is moved).

Thanks for reading, and I hope someone can help me out (again).

Re: Graph Disappear Problem vol 2

Yusuf10-Mar-09 12:25

Yusuf

10-Mar-09 12:25

StuffyEst wrote:
Subject: Graph Disappear Problem vol 2

I didn't knew, now questions come in volumes.

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: Graph Disappear Problem vol 2

StuffyEst10-Mar-09 12:29

StuffyEst

10-Mar-09 12:29

well I have old post but thats like on page 30.. and I have serious doubts people care to watch pages that far.

Re: Graph Disappear Problem vol 2

Luc Pattyn10-Mar-09 15:28

Luc Pattyn

10-Mar-09 15:28

Hi,

I gave you all the necessary information 5 days ago[^], and I can tell you there is no way around doing it all in the Paint handler. You simply must, it is the only way to get it to paint whenever something needs repainted (as with uncovering part of your window when it has been covered by something else; as with resizing, minimizing and maximizing a window; as with printing which can reuse all the painting code; etc).

In your specific situation, if you have two parameters that may change and cause your drawing to become invalid, what you do is:
1. store the drawing parameters that define your drawing as class members
2. draw everything (say on myPanel) in its Paint handler based on those parameters
3. and change those parameters where ever you feel you need to; and when you do change them, call myPanel.Invalidate() which will eventually result in myPanel.Paint() to be called automatically.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Re: Graph Disappear Problem vol 2

StuffyEst11-Mar-09 4:25

StuffyEst

11-Mar-09 4:25

Thanks a lot, finally got it all working as I wanted Smile | :)

Programmatically Setting the Application's Privilege Level?

That Asian Guy10-Mar-09 11:33

That Asian Guy

10-Mar-09 11:33

In Windows Vista, the privilege of the application can limit many parts such as registry access etc.

Is there a way to set the provilege level to "Run this program as an administrator" when you click build in Visual Studio?

Thanks.

Re: Programmatically Setting the Application's Privilege Level?

Ravadre10-Mar-09 13:14

Ravadre

10-Mar-09 13:14

I guess, you can do it through manifest when building application.
More info fe. here: http://channel9.msdn.com/posts/jmazner/How-To-Tell-Vistas-UAC-What-Privelege-Level-Your-App-Requires/[^]

If you need more tools to interact with UAC at runtime, try looking at this little unmanaged code (which you can use using PInvoke): http://www.softblog.com/2008-02/vista-tools/[^]

OleDB UPDATE command throws exception

Matthew Klein10-Mar-09 11:03

Matthew Klein

10-Mar-09 11:03

Greetings all! I am trying to run an UPDATE command on an XLS file that I have opened a connection to. However, the RunNonQuery() method throws the exception:
“No value given for one or more required parameters.”
ErrorCode -2147217904

Here is the code:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\test.xls"";Extended Properties=""Excel 8.0;HDR=NO;""";
OleDbConnection con = new OleDbConnection(connectioinString);
con.Open();

OleDbCommand com = con.CreateCommand();
com.CommandText = "UPDATE [Sheet1$A1:A1] SET F1 = 'True'";
com.ExecuteNonQuery(); //Thows Exception

con.Close();

I’m pulling my hair out trying to figure out what I’m doing wrong… I was following the example from http://support.microsoft.com/kb/316934#12 to the letter, but I can’t figure out what I’m missing.

Can anyone point me in the right direction (or just let me know)?

Thank you all in advance!

Re: OleDB UPDATE command throws exception

Yusuf10-Mar-09 11:33

Yusuf

10-Mar-09 11:33

Anticast wrote:
com.CommandText = "UPDATE [Sheet1$A1:A1] SET F1 = 'True'";

why are you doing a range from A1 to A1?

try this
UPDATE [Sheet1$] SET A1 = 'True'

Re: OleDB UPDATE command throws exception

Matthew Klein10-Mar-09 12:23

Matthew Klein

10-Mar-09 12:23

Oh my... After running some trial and error testing by isolating each step I realized that my connection string had "HRD=NO" instead of the correct "HDR=NO"... so the connection was taking the first row as the header and that was causing the conflict.

For everyone else that may want to use this technique, it does work. If you want to read/write to cell B2 on worksheet MySheet you can use:

"SELECT * FROM [MySheet$B2:B2]"
"UPDATE [MySheet$B2:B2] SET F1 = 'Value'"

But you need to specify HDR=NO in the connection string.
See http://support.microsoft.com/kb/316934#12[^] for a step by step walkthrough.

Hope this helps someone.

Update Database(ACCESS) from ASP page

daks90610-Mar-09 10:11

daks906

10-Mar-09 10:11

Hi, Please help

I am new to programming. and I am trying to update a value in the database(ACCESS) with a value in a textbox on an ASP page.

the conditions are that "value" in database can only change if it is smaller than value in textbox in the ASP page.

I can INSERT, UPDATE, and DELETE values in the database from the ASP page. I just dont know how to write it with the "if" statement so that it can work

thanks for the help

Re: Update Database(ACCESS) from ASP page

led mike10-Mar-09 10:25

led mike

10-Mar-09 10:25

daks906 wrote:
I just dont know how to write it with the "if" statement

if( bMyCondition)
{
  // your code goes here
}

Re: Update Database(ACCESS) from ASP page

daks90610-Mar-09 12:08

daks906

10-Mar-09 12:08

Below is the code i use to update the database. I just wanted to know how to write the code to UPDATE database value only if it is smaller than the value of the textbox on the ASP page

public void upOk_click(object sender, EventArgs e)
{
conn.Open();

OleDbCommand cmd = conn.CreateCommand();

cmd.CommandText = "UPDATE [Product]" +

"SET [CurrentBid]" + "='" + priceUpdate.Text + "'"
+

"WHERE [ProductID]=" + idDDL1.SelectedItem.Text;

cmd.ExecuteNonQuery();

DisplayTable();
}

Re: Update Database(ACCESS) from ASP page

Yusuf10-Mar-09 11:38

Yusuf

10-Mar-09 11:38

why are you double posting? Didn't you ask the same question on the asp.net forum?

Directsound Sine wave

Eja Beja10-Mar-09 9:33

Eja Beja

10-Mar-09 9:33

Can anybody help me with the simplest code for playing a sine wave of 200hz using directsound. Runnable in Visual Studio 2008 with directsound as reference.

Re: Directsound Sine wave

Luc Pattyn10-Mar-09 9:48

Luc Pattyn

10-Mar-09 9:48

Hi,

of course. Here is the skeleton:

///
/// the simplest code for playing a sine wave of 200hz using directsound.
///
public class MySineWavePlayerUsingDirectSound {

    public MySineWavePlayerUsingDirectSound() {
        // TODO: add initialization code
    }

    public void Play(...) {
        // TODO: add method body
    }
}

So all that is left to do, is reading up on DirectSound and stuffing some code in the skeleton.
BTW don't forget to add the right references.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Re: Directsound Sine wave

Ravi Bhavnani10-Mar-09 13:19

Ravi Bhavnani

10-Mar-09 13:19

See this[^] article.

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware
ravib(at)ravib(dot)com

How to prio-hide controls when window gets too small?

ioctl5110-Mar-09 7:44

ioctl51

10-Mar-09 7:44

Some applications, like WMP11 or Windows Live messenger, when resizing their window, instead of just having a minimum size or popping out scrollbars when the window gets too small, they seem to have some sort of prio list of which window controls to hide. Do they do this manually in code, or can this behaviour somehow be created via the window forms designer?

Re: How to prio-hide controls when window gets too small?

Luc Pattyn10-Mar-09 7:48

Luc Pattyn

10-Mar-09 7:48

that takes code, it isn't even difficult. All it takes is modifying Bounds and Visible inside a Resize handler.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DataGridView naughty behavior

Muammar©

10-Mar-09 7:39

Hi everyone,
I have a datagridview with some columns of types textbox and combobox, the problem is, every time I build my application, the datagridview thinks it's smart and rearrange my columns for me which drives me crazy!!
Any way to stop that "smart" behavior??

Please help.

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Re: DataGridView naughty behavior

musefan10-Mar-09 7:41

musefan

10-Mar-09 7:41

specifically set the column order in code? i.e. call a function when the form loads or something similar

Life goes very fast. Tomorrow, today is already yesterday.

Re: DataGridView naughty behavior

Muammar©

10-Mar-09 7:50

Ok sorry I found something here:
http://msdn.microsoft.com/en-us/library/wkfe535h.aspx[^]

Thanks though guys!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

How Can I Hide String Key

dataminers10-Mar-09 7:18

dataminers

10-Mar-09 7:18

My dll file contains private key value. I used this key for encryption. How can I hide this key. If I use Reflector or other tool so show my code. I think obfuscation or post-build not guarantee hide my key value. I use strong key but, it can be remove using with Reflector plug-in. I add dll to GAC but, it easly to steal (Start --> Run ---> C:\windows\assembly\gac_msil).

Do you have any idea?

Best Regards...

Re: How Can I Hide String Key

musefan10-Mar-09 7:31

musefan

10-Mar-09 7:31

hmmm. not quite sure. but i have just thought of something (maybe a little crazy but hey)

What about writting a small hardcoded algorithm that rearanges the key before using it for decryption/encryption? that way the stored 'key string' cannot be directly used by anybody else. unless of course they can get hold of your hardcoded algorithm. but that is harder than just getting the string, is it not?

instead of your own algorithm, maybe you could just use a hash value of the original key

What you think?

Life goes very fast. Tomorrow, today is already yesterday.

Re: How Can I Hide String Key

dataminers10-Mar-09 10:48

dataminers

10-Mar-09 10:48

Dear Musefan;

First of all thanks for care. I have a algorithm like blowfish. I already written hardcoded this algorithm. But most important of this algorithmts need a key. This enuqe key is most important for this algorithm and it will be hide.

Thanks...

Last Visit: 31-Dec-99 18:00 Last Update: 29-Apr-24 22:15

Refresh

ᐊ Prev 1...5504 5505 5506 550755085509 5510 5511 5512 5513 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.