C# Discussion Boards - CodeProject

Re: Passing strings between windows forms

DX Roster4-Mar-10 18:38

4-Mar-10 18:38

try this code:

<b><u></u>Method 1:</b>
on page 1:
Session["Value"]=textBox1.text.tostring();

on page 2:
retrieve value by using
label1.text=Session["value"].tostring();

Method 2:

On page 1:
response.redirect("default2.aspx?value='"+textbox1.text+"'");
on page 2:
string str=request.queryString("value").tostring();
label1.text=str;

Exporting DataGridView to excel

Hum Dum1-Mar-10 23:18

Hum Dum

1-Mar-10 23:18

On application i am working there presents two gridview more like master-detail form. When user click on row in master grid, its details got displayed in second grid.

Now i want to export these to excel.

I can export both grid to different excel files, i.e one excel for master grid, and other for detail.

But i want to export them in single file.

Is there a way to achieve this?

need help.

Re: Exporting DataGridView to excel

Rashmi_Karnam2-Mar-10 0:13

Rashmi_Karnam

2-Mar-10 0:13

Can I have code U r Using for Export to Excel?

Rashmi.M.K

Re: Exporting DataGridView to excel

Dan Mos2-Mar-10 1:30

Dan Mos

2-Mar-10 1:30

sure there is. Look at this article. It specifically for exporting datagridview(s) to excel.

As for two datagrids on the same file I wouldexport one to sheet1 and the second to sheet2 or
Mater and Details.

Re: Exporting DataGridView to excel

Hum Dum2-Mar-10 2:04

Hum Dum

2-Mar-10 2:04

thanks for reply.

exporting to excel is not an issue.

also exporting them to separate files is ok.

But my problem is how to correlate them as i do in my application.

Hope you had seen master detail standard ex for notrhwind DB.

Now whenever user click on particular order, its corresponding details displayed in 2nd grid.

I also doing this, and exporting them also(but in 2 files). NO ISSUE.

But how to correlate them in excel file.

so that user can identify this detail belong to that order.

Re: Exporting DataGridView to excel [modified]

Dan Mos2-Mar-10 2:17

Dan Mos

2-Mar-10 2:17

I would export them as I mentioned and then record a macro for some VLookUP or something
(I don't know what you want exactly). An then adapt the macro to C# code so that the exported
files/sheets are already linked.

[Edit]
Or simpler. I would create a template file that contains all the formulas(Excel or custom VBAs)
and export the datas in that template. Now when the user enters a text in cell F5 for example
the formulas will autocomplete the details for that text. Something like that. It's easier than
creating formulas from C#.
[/Edit]

modified on Tuesday, March 2, 2010 8:35 AM

Control Authoring OnPaint not working as expected

TheFoZ1-Mar-10 22:54

TheFoZ

1-Mar-10 22:54

Hi All

I'm trying to author a control which displays text vertically. I've overridden the OnPaint method and Text property so that if the Text is Changed it calls the new OnPaint method. When the text is changed, the old text does not disappear and the new text is overlaid on the old. How do I stop this from happening?

The OnPaint method looks like this

protected override void OnPaint(PaintEventArgs pe)
{
    base.OnPaint(pe);

    if (!String.IsNullOrEmpty(Text))
    {
        System.Drawing.Graphics formGraphics = pe.Graphics;

        System.Drawing.Font drawFont = new System.Drawing.Font("Arial", 10);
        System.Drawing.SolidBrush drawBrush = new System.Drawing.SolidBrush(System.Drawing.Color.Black);
        float x = 150f;
        float y = 50f;
        System.Drawing.StringFormat drawFormat = new System.Drawing.StringFormat(StringFormatFlags.DirectionVertical);
        formGraphics.DrawString(Text, drawFont, drawBrush, x, y, drawFormat);
        drawFont.Dispose();
        drawBrush.Dispose();
        formGraphics.Dispose();
    }

}

And the Text property is

public override string Text
{

    get { return base.Text; }
    set
    {
        base.Text = value;
        this.OnPaint(CreateNewPaintEventArgs());
    }

}

private PaintEventArgs CreateNewPaintEventArgs()
{
    return new PaintEventArgs(CreateGraphics(), new Rectangle(new Point(0, 0), Size));
}

Your help is appreciated.

The FoZ

Re: Control Authoring OnPaint not working as expected

OriginalGriff1-Mar-10 23:54

OriginalGriff

1-Mar-10 23:54

Don't call OnPaint! Never, ever, call OnPaint directly.
Use Invalidate instead - it causes the framework to correctly call OnPaint with the appropriate graphics object etc.

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Re: Control Authoring OnPaint not working as expected

TheFoZ1-Mar-10 23:56

TheFoZ

1-Mar-10 23:56

Thanks OriginalGriff.

I changed my Text property to

public override string Text
{

    get { return base.Text; }
    set
    {
        base.Text = value;
        this.Invalidate();
    }

}

and all is well.

The FoZ

C# - Fill a .xlsx / .xls - file with data based on a grid

Mschauder1-Mar-10 22:44

Mschauder

1-Mar-10 22:44

Hey,

I have my data in a grid (no datagridview), export a grid (30 cols and over 20.000 rows) takes a lot of time (minimum 2minutes)... Dead | X|

now my question: Is there a way to accelerate this?

for (int i = 0; i < UsingGrid.Cols; i++)
{
    for (int j = 0; j < UsingGrid.Rows; j++)
    {
        worksheet.Cells[j + 1, i + 1] = ConvertToExcelFormat(Convert.ToString(UsingGrid[j, i]));
    }
}

Thank you

Re: C# - Fill a .xlsx / .xls - file with data based on a grid

TheFoZ1-Mar-10 23:54

TheFoZ

1-Mar-10 23:54

Hi
Might be worth looking in to the Range.set_value method. I've used the get_value method to import a whole sheet in to an array so you should be able to do the reverse easily enough. There is an example here http://stackoverflow.com/questions/2314393/how-to-specify-format-for-individual-cells-with-excel-range-set-value[^]

The FoZ

Re: C# - Fill a .xlsx / .xls - file with data based on a grid

Rashmi_Karnam2-Mar-10 0:17

Rashmi_Karnam

2-Mar-10 0:17

Why can't you use Response.write with Inline or attachment file type to export data from Grid to Excel.

Rashmi.M.K

Re: C# - Fill a .xlsx / .xls - file with data based on a grid

Dan Mos2-Mar-10 1:32

Dan Mos

2-Mar-10 1:32

Check this article. It is fast.

Converting to Hex

Deepak.Prahlad1-Mar-10 22:28

Deepak.Prahlad

1-Mar-10 22:28

Hi

I have string say "Deepak"
how do i convert this into a byte array of 44,65,65,70,61,6b. I converted the ascii to
hex-string "44656570616b" using

String.Format("{0:x2}", (uint)System.Convert.ToUInt32(tmp.ToString()));

thanks

Re: Converting to Hex

Luc Pattyn1-Mar-10 22:47

Luc Pattyn

1-Mar-10 22:47

Turning a string into its ASCII bytes, if possible, is done using Encoding.ASCII.GetBytes(string)

BTW: The code you have shown converts a number to a string, which in .NET is always using Unicode, not ASCII.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

Re: Converting to Hex

Deepak.Prahlad1-Mar-10 23:03

Deepak.Prahlad

1-Mar-10 23:03

it returns "68, 101, 101, 112, 97, 107.
i need to get 44,65,65,70,61,6b

Re: Converting to Hex

Luc Pattyn1-Mar-10 23:14

Luc Pattyn

1-Mar-10 23:14

GetBytes() returns bytes, which means numbers. You can turn those into strings again using whatever convention you choose. "Deepak" starts with a "D" which is 68 when counting in decimal, 44 in hex, 102 in octal, etc. If you want hex, you probably need to apply ToString("X2") to each of those bytes.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

problem in debugging the windows application

Amit Spadez1-Mar-10 22:22

Amit Spadez

1-Mar-10 22:22

hi all,

I have made simple windows based application to illustrate the event fire when we click on the stop debugging button in VS 2008.
Actually, When i click on the "close" button of the form in the running application . It invokes the method as mentioned in the "form_load" event
e.g.

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = "Hello"
AddHandler System.Windows.Forms.Application.ApplicationExit, AddressOf abcMethod
End Sub

Private Sub abcMethod()

End Sub

but when i directly click on the "stop" debugging in the menu option in VS 2008,it doesn't go to the breakpoint inserted at the form_load event. I want to know which event fires at click of the stop debugging button in the menu option in vs 2008.
Thank you

Re: problem in debugging the windows application

Luc Pattyn1-Mar-10 22:49

Luc Pattyn

1-Mar-10 22:49

AFAIK none. Stopping an app inside the debugger is like killing it in Task Manager, no more code gets executed.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

Re: problem in debugging the windows application

Amit Spadez1-Mar-10 22:57

Amit Spadez

1-Mar-10 22:57

thanx for ur answer.
u mean no event fires on stop the debugging ????

Re: problem in debugging the windows application

Tony Richards1-Mar-10 22:52

Tony Richards

1-Mar-10 22:52

If you click 'Stop Debugging' the program will close, I think immediatly, with no events fired.

If you want to have the ApplicationExit event fire, you need to close your application with the 'X' button or by some method that calls Application.Exit().

My Blog: This Blog

Convert string to UTF-8

dabuskol1-Mar-10 20:41

dabuskol

1-Mar-10 20:41

Hi,
I have a webservice that send bulk SMS and it works for English language. The problem is when users send SMS using ARABIC text no SMS is receieved.

Please help me to improve or change my code so it will work for arabic characters. I think the problem is when converting the string to UTF-8 code.

MY Webservice:

http://10.45.98.198:8080/Script/SMSArabicEnglish.jws?wsdl

MY C# Code that send the message to my webservice.

string sMessage = وقت البلاغ:" ;
byte[] utfCodes = System.Text.Encoding.UTF8.GetBytes(sMessage);

//second solution