C# Discussion Boards - CodeProject

First Prev Next

Re: The instruction at referrenced memory at . The memory could not be read. Click on 'OK' to terminate the program

Member 333748511-Jan-10 1:07

Member 3337485

11-Jan-10 1:07

Sorry, did not help in this case, I still get the error. The article is informative though, thanks.

open .csv file when we click in vb.net

myms.net8-Jan-10 1:37

myms.net

8-Jan-10 1:37

hi,
when we click a button .csv file will be in open mode
i.e, in visible
thanks in advance

Re: open .csv file when we click in vb.net

Jimmanuel8-Jan-10 1:54

Jimmanuel

8-Jan-10 1:54

What's the question? Why are you posting a VB question in the C# forum?

If you want to open a file in your program, check the System.IO[^] namespace, particularly the File[^] class.

If you want to launch a file in it's native viewer, run Process.Start[^] on it and windows will (hopefully) be able to figure out what to open it with.

If you want to know how to do things when the use clicks a button just drag a button onto your form from the toolbox and then click the button.

Badger | [badger,badger,badger,badger...]

AUDIT TABLE TRIGGER HELP [modified]

spankyleo1238-Jan-10 1:36

spankyleo123

8-Jan-10 1:36

Hi Guys,

I have created an audit table to record the changes made to the tables in th db.

I want to keep track of the update version by using a counter ..to know how many times the particular field has been updated/inserted.

Can you let me know how i can go about achieving this,,,Thanks

modified on Friday, January 8, 2010 8:03 AM

Re: AUDIT TABLE TRIGGER HELP

Jimmanuel8-Jan-10 1:58

Jimmanuel

8-Jan-10 1:58

This should be in the Database[^] forum.

In your trigger you can compare values to figure out which field has been changed; then you can keep a row or another table to hold counters for each field and increment the one that's modified.

Why use triggers for this? Why not use stored procedures to control access to your tables?

Re: AUDIT TABLE TRIGGER HELP

spankyleo1238-Jan-10 2:03

spankyleo123

8-Jan-10 2:03

can i repost this in the db forum?

Re: AUDIT TABLE TRIGGER HELP

Jimmanuel8-Jan-10 2:13

Jimmanuel

8-Jan-10 2:13

I don't see a problem with it, but then again I'm not the keeper of the site Smile | :)

Re: AUDIT TABLE TRIGGER HELP

dojohansen8-Jan-10 2:14

dojohansen

8-Jan-10 2:14

Yes, but edit your original post, e.g. "Accidentally posted to wrong forum. My apologies.", first. Smile | :)

How to user Log Parser in C#?

Sunil G8-Jan-10 0:38

Sunil G

8-Jan-10 0:38

Hi All,

I want to execute Log Parser query in my C# application.

Can any one guide me?

Re: How to user Log Parser in C#?

dojohansen8-Jan-10 2:16

dojohansen

8-Jan-10 2:16

To answer with as much precision as you've asked: All you have to do is install it, configure it, and then use it.

Useful isn't it?

What's Log Parser?

DataGridView + Excel

boakineo7-Jan-10 23:51

boakineo

7-Jan-10 23:51

How to export DataGridView to Excel without Microsoft.Office.Interop.Excel

Re: DataGridView + Excel

Priya Prk8-Jan-10 1:31

Priya Prk

8-Jan-10 1:31

Copy and Paste???

Re: DataGridView + Excel

boakineo8-Jan-10 1:34

boakineo

8-Jan-10 1:34

And if I want a formatted report?

Re: DataGridView + Excel

Rick Shaub8-Jan-10 3:32

Rick Shaub

8-Jan-10 3:32

Roll your own .xls file:

http://sc.openoffice.org/excelfileformat.pdf[^]

Re: DataGridView + Excel

boakineo8-Jan-10 3:53

boakineo

8-Jan-10 3:53

Thank you, but it is a hard way.

Re: DataGridView + Excel

Ashfield8-Jan-10 3:45

Ashfield

8-Jan-10 3:45

You can use oledb

using (OleDbConnection con = new OleDbConnection(string.Format("Data Source={0};" +
 "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;", fileName)))

[edit](split over lines to make it easier to read)[\edit]

and you just create a sheet by using the create table command, insert just like a real database - but obviously you cannot format the sheet.

Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP

Whic is the Best Way of Writing code? and Why?

Joe Rozario7-Jan-10 22:44

Joe Rozario

7-Jan-10 22:44

Dear friends,

i have some small clarification.

//-----------------------------
public struct a
{
private string s;
public string Val
{ set { s = value; }
get
{ return s;
}
}
//----------------------------
public class a
{
private string s;
public string Val
{
set
{ s = value; }
get
{ return s; }
}
}
/---------------------------

the functionality will be like these....... (Asume that there are more then one variable and properties .... but no methods and functions)

tell me the best way of writting?

and where both can be used?

By

joe

Re: Whic is the Best Way of Writing code? and Why?

Eddy Vluggen7-Jan-10 22:59

Eddy Vluggen

7-Jan-10 22:59

=>Joe<= wrote:
tell me the best way of writting?

There is no "best", both options have their own characteristics.

=>Joe<= wrote:
and where both can be used?

I suggest you learn the difference between those two, and then you'll probably have a good idea when to use one or the other.

I could simply say that you want a class if you need to inherit things, but it just isn't that simple. A struct may inherit from an Interface. There, rule of thumb number one broken.

Start reading here.

I are Troll Suspicious | :suss:

Re: Whic is the Best Way of Writing code? and Why?

Joe Rozario8-Jan-10 0:31

Joe Rozario

8-Jan-10 0:31

Dear friend ....

Thanks for reply ... given link is well explanatory... Smile | :)

i am going to use class ... because as i mentioned that i have many variables..

and both of these condition made me not to use structer

-- It has an instance size smaller than 16 bytes.
-- It is immutable.

Thank You

by

Joe

Re: Whic is the Best Way of Writing code? and Why?

OriginalGriff7-Jan-10 23:02

OriginalGriff

7-Jan-10 23:02

The big differenc is that the struct version is a value type, and the class version is a reference type. In addition, a struct is a "cut-down" struct - it cannot be used as a basis for a new struct or class (it cannot be inherited).

It is realy quite important to understand the difference between value and reference types as it makes a big difference when you start passing things to methods!

The difference is a bit complex, and otheres have explianed it better than I could here, so google "value type versus reference type" and you will get a pile of descriptions.

All those who believe in psycho kinesis, raise my hand.

Re: Whic is the Best Way of Writing code? and Why?

Joe Rozario8-Jan-10 0:33

Joe Rozario

8-Jan-10 0:33

Thanks for reply ...

i got the point

[http://msdn.microsoft.com/en-us/library/ms229017.aspx]

this link explains well...

by

joe

custom textbox or masked textbox

Erdinc277-Jan-10 22:17

Erdinc27

7-Jan-10 22:17

hi guys...i have at least 10 textboxes in my form which allow ony to enter numeric values..but some of them will be codes like phone codes and the other textbox will be the rest of phone number like 342 2222222...to make it i wrote that codes to the txtKod_Keypress event the below codes

private void txtKod_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsNumber(e.KeyChar))
e.Handled = char.IsLetter(e.KeyChar);
if (txtKod.Text.Length == 3)

{
e.Handled = char.IsLetter(e.KeyChar);
e.Handled = char.IsNumber(e.KeyChar);
}
}

but it allows to enter letters after i entered 3 numbers actually allows everything...i dont know what is wrong there???
and another question do u suggest me to make a method like that and call it every time i need or to create my own numeric textbox by using Component Class ??
and i searched about masked textbox but there are underlines and not exactly the thing i wanted to see...so may i change its format ?

Re: custom textbox or masked textbox

dojohansen8-Jan-10 0:13

dojohansen

8-Jan-10 0:13

Why not just use MaskedTextBox?

The code you posted has a few quarks. Why do you set e.Handled equal to e.KeyChar being a letter if it isn't a digit? And then overwrite this value two times when the length of the textbox reaches 3?

To restrict the length to 3 the handler need only contain

e.Handled = (txtKod.Text.Length == 3);

However, doing a masked input properly is a bit more work. To get it right you need to handle pasting as well as typing, accept non-alphanumerical keys like backspace, left/right arrow key, and perhaps other things.

Re: custom textbox or masked textbox

dojohansen8-Jan-10 0:16

dojohansen

8-Jan-10 0:16

I re-read your post and see you're aware of the MaskedTextBox. But apparently not of it's PromptChar property. Set it to a space if you don't want to show the underline.

Re: custom textbox or masked textbox

Erdinc278-Jan-10 0:43

Erdinc27

8-Jan-10 0:43

thanks man
i will use it as u said Smile | :)

Last Visit: 31-Dec-99 18:00 Last Update: 13-Jun-24 0:19

Refresh

ᐊ Prev 1...3842 3843 3844 384538463847 3848 3849 3850 3851 Next ᐅ

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