C# Discussion Boards - CodeProject

How to user Log Parser in C#?

8-Jan-10 2:14

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

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

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

7-Jan-10 23:51

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

Priya Prk8-Jan-10 1:31

Priya Prk

8-Jan-10 1:31

Copy and Paste???

boakineo8-Jan-10 1:34

8-Jan-10 1:34

And if I want a formatted report?

Rick Shaub8-Jan-10 3:32

Rick Shaub

8-Jan-10 3:32

Roll your own .xls file:

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

boakineo8-Jan-10 3:53

8-Jan-10 3:53

Thank you, but it is a hard way.

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

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

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

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:

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

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.

custom textbox or masked textbox

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

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 ?

dojohansen8-Jan-10 0:13

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.

dojohansen8-Jan-10 0:16

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.

Erdinc278-Jan-10 0:43

Erdinc27

8-Jan-10 0:43

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

carlecomm10-Jan-10 21:02

carlecomm

10-Jan-10 21:02

.net framework has a maskedtextbox control.
More info can be found at:
http://msdn.microsoft.com/en-us/library/system.windows.forms.maskedtextbox.aspx

modified 27-May-14 4:58am.

How to crop image (C#)

boakineo7-Jan-10 21:45