C# Discussion Boards - CodeProject

Admin88730-Jul-08 5:20

30-Jul-08 5:20

i did a application that creates a new and empty database file(MDB file).

i want to create a new row in the new database.

i did this:

string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source =" + Dir;
           
string commandString = "Select id,cell from Events";

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(commandString, connectionString);

DataSet ds = new DataSet();
dataAdapter.Fill(ds, "Events");
                                           
DataTable datatable = ds.Tables[0];
DataRow newRow = datatable.NewRow(); //adding a new Row

 newRow["id"] = "Gil";
 newRow["Event"] = "Gil2";
                       

datatable.Rows.Add(newRow);
dataAdapter.Update(ds, "Events");            
ds.AcceptChanges();

it throws me a exception:

Update requires a valid InsertCommand when passed DataRow collection with new rows.

What is Wrong?..i am not understand

p.s
All of this is in try catch...
thank you!

Re: How to Update MDB file?

Yusuf30-Jul-08 5:32

Yusuf

30-Jul-08 5:32

you are not inserting new records. You are trying to update. But update what?

here this should help ^

Yusuf

Re: How to Update MDB file?

ElSpinos30-Jul-08 5:33

ElSpinos

30-Jul-08 5:33

You will need to define the InsertCommand property of the DataAdapter like so:

// Connection & DataAdapter initialization code should go here
// ...

OleDbCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "Insert Into Table(Col1, Col2, Col3) Values (?, ?, ?)";
dataAdapter.InsertCommand = insertCommand;

// ...

You may also want to check out the UpdateCommand and DeleteCommand properties which will allow your adapter to update and delete records which is what it seems you are also trying to do in your code snippet.

/F - .NET Developer

Slides View Control

breandan30-Jul-08 4:40

breandan

30-Jul-08 4:40

Hi,

I was wondering if anyone knows if a .Net Control exists(free/commercial) which can let me have a view like this:

http://www.bergsoft.net/res/screenshots/next-grid/slides-style.gif

The Column headers at the top are not required. Thanks for any information, I am a bit new at this!

regards,

Brendan.

Re: Slides View Control

Simon P Stevens30-Jul-08 5:37

Simon P Stevens

30-Jul-08 5:37

You can do things like that fairly easily with WPF. You'd use a listview as a starting point, then add a template for the list view items.

Infragistics controls did have something that could do similar to that in winforms last time I used them (a few years ago now).

Simon

How can i save event logs using C# ?

Abhijit Jana30-Jul-08 3:55

Abhijit Jana

30-Jul-08 3:55

Hi,
Is it possible to save event logs using C# ?

Any idea ?

Thansk in advance !!

cheers,
Abhijit

Re: How can i save event logs using C# ? [modified]

ElSpinos30-Jul-08 4:15

ElSpinos

30-Jul-08 4:15

You could use the EventLog object to read the event log entries and then save them to a database or file, like so:

// Opens the Application event log.
EventLog eventLog = new EventLog("Application");
// Iterate through the entries in the opened event log.
foreach (EventLogEntry entry in eventLog.Entries)
 Console.WriteLine(entry.Message);

/F - .NET Developer

modified on Wednesday, July 30, 2008 10:23 AM

Re: How can i save event logs using C# ?

Tuwing.Sabado30-Jul-08 4:35

Tuwing.Sabado

30-Jul-08 4:35

Use Microsoft Enterprise Library for Event Log, Flat file logging or Error Logging.

Re: How can i save event logs using C# ?

Abhijit Jana30-Jul-08 5:24

Abhijit Jana

30-Jul-08 5:24

Thanks for your response. but i want to save it ".evt" file.

cheers,
Abhijit

Re: How can i save event logs using C# ?

ElSpinos30-Jul-08 5:45

ElSpinos

30-Jul-08 5:45

I don't believe the .NET Framework has native support for this, but you can try the following:

// Declare this at the class member space
[DllImport("advapi32.dll")]
static extern IntPtr OpenEventLog(string lpUNCServerName, string lpSourceName);
[DllImport("advapi32.dll")]
static extern bool BackupEventLog(IntPtr hEventLog, string backupFile);

// Somewhere in your code, call the above two declarations...
// NOTE: Replace "localhost" with the machine name you need to back up.
//       Replace "Application" with the log you are trying to back up.
//       The saved file is an EVT file.
BackupEventLog(OpenEventLog("localhost", "Application"), @"C:\TEMP\EVENTLOG.EVT");

/F - .NET Developer

Re: How can i save event logs using C# ?

Abhijit Jana30-Jul-08 6:56

Abhijit Jana

30-Jul-08 6:56

Thanks for your reply. I am trying to do it using WMI

cheers,
Abhijit

setting printer options

cmarmr30-Jul-08 2:48

cmarmr

30-Jul-08 2:48

how do i set printer options? i would like to set these options

print from tray 1
pagesize 11x17
landscape

this is the code i am using

System.Drawing.Printing.PrintDocument pd = new System.Drawing.Printing.PrintDocument();
pd.PrinterSettings = printDialog1.PrinterSettings;
pd.PrinterSettings.Duplex = System.Drawing.Printing.Duplex.Simplex;
pd.DocumentName = "JP Council (Title Page)";
pd.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.pd_PrintPage);
pd.Print();

i know it has to be something with the printersettings but just now sure how to do it

Thanks,
Chad Aiena

Re: setting printer options

DaveyM6930-Jul-08 3:14

DaveyM69

30-Jul-08 3:14

use
System.Drawing.Printing.PageSettings mySettings = new System.Drawing.Printing.PageSettings();

mySettings.PrinterSettings has everything you need.

Then apply mySettings to the System.Drawing.Printing.PrintDocument instance your using.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

After form load Auto close window

Member 387988130-Jul-08 2:38

Member 3879881

30-Jul-08 2:38

Hi i given in my form opacity=0 and set the form shown taskbar=false...,

To avoid form visible to my enduser...,

Now the probs is,

After my form load all the operations happend the form have to auto close?,

Its possible?,

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: After form load Auto close window

DaveyM6930-Jul-08 2:55

DaveyM69

30-Jul-08 2:55

Close();

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: After form load Auto close window

PIEBALDconsult30-Jul-08 3:47

PIEBALDconsult

30-Jul-08 3:47

Perhaps you don't want a Windows Application at all?
Have you considered a console application?

Either way, the user should have some indication that something happened.

Hide My Window Form

Member 387988130-Jul-08 1:54

Member 3879881

30-Jul-08 1:54

Hi guys i created one windows application its contained only one form...,

In that form load event i said some operations have to run...,

Its working cool...,

But i dont like show the window form to enduser...,

It mean no minimize of the form also, just the form load operations have to run thats all

So i tried to hide that using this.hide(); methode in my form load event...,

But its not getting hide...,

how to hide my form window?

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: Hide My Window Form

DaveyM6930-Jul-08 2:54

DaveyM69

30-Jul-08 2:54

You can put your code in the constuctor instead of load so it runs before the loading takes place unless you need to access the form itself (or child controls) as it's handle won't be created yet so the object(s) will be unavailable.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Hide My Window Form

Ajay.k_Singh30-Jul-08 3:03

Ajay.k_Singh

30-Jul-08 3:03

If your only purpose is to execute a piece of code and not to show any window, you can simply delete the form and put your code in Main method.

Open Program.cs file and under main function comment out line which shows the form, and put your code. Such as –

---------------------------------
static class Program
{
///

/// The main entry point for the application.
///

[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);

//Application.Run(new Form1());

MessageBox.Show("Test");

}
}
---------------------

I hope this helps.

-Dave.
--------------------------------
www.componentone.com
--------------------------------

------------------------------------
http://www.componentone.com
------------------------------------

Re: Hide My Window Form

Thomas Stockwell30-Jul-08 10:26

Thomas Stockwell

30-Jul-08 10:26

You could set the forms opacity to 0

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios

Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com

How to go to the next color?

bouli30-Jul-08 1:03

bouli

30-Jul-08 1:03

Hello gurus,

I have a problem to solve.

I'm using a set of standard named colors. When the user selects a given color lets say Red, I'd like to know how I can select programmatically the next colors to Red, that is Brown, FireBrick, etc.

The named colors are from the panel "Web" of the color selector.

I hope my question is clear enough.

Best regards.

Fred.

There is no spoon.

Re: How to go to the next color?

User 665830-Jul-08 1:06

User 6658

30-Jul-08 1:06

What do you mean be "next color to red"? What kind of structure do you use, an enumeration, a .NET defined enumeration?

Your question is a bit too vague.

regards

modified 12-Sep-18 21:01pm.

Re: How to go to the next color?

bouli30-Jul-08 1:57

bouli

30-Jul-08 1:57

When you look at the color picker, you have 3 tabs, one contains the names of the colors ("Web" tab).
When the user selects Red, I'd like to programatically go to the next color, that is Brown, FireBrick etc.

Fred.

There is no spoon.

Re: How to go to the next color?

leppie30-Jul-08 2:30

leppie

30-Jul-08 2:30

Enumerations are just numbers, so you can try cast to number (int/long whatever), increment it, then cast back. You should probably add some checking to see if the next number is indeed a valid enumeration name. There are other approaches too. Look at Enum.GetValues and Enum.GetNames.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: How to go to the next color?

DaveyM6930-Jul-08 2:45

DaveyM69

30-Jul-08 2:45

I've had a look and it appears there is no emumeration available for the colours or tabs. The colours themselves (the names) are each public static read only properties that return a Color rather than an enum.

<EDIT>
System.Drawing.KnownColor is an enum of course!
</EDIT>

Using reflection I can loop through the properties and get the ones that are of type Color and exclude any that are SystemColor (WindowText etc...) but the list is alphabetical and not in the order you require (same as Web tab).

I think you'll have to hardcode your own list or enum and refer to the corresponding .Net colour from there.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

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