DataReader data writing to Excel sheet - cells in different row - C# Discussion Boards

I've changed it from PictureBox to Panel and added this:

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

    pe.Graphics.DrawImage(this.card_image, new Point(0, 0));
}

But it's still not transparent. Do you want to look at my code?

No, I want you to do what I suggested. DON'T put the images inside a control, draw them on your form directly, in your paint event.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Christian Graus wrote:
Using pictureboxes ~~for this~~, is a little insane

ftfy

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

hi i am working on an application that automates a website, my work is to upload a file but it is not clear to me how i can get the browse folder dialog box event(on clicking the browse button).

More clarity in your question would be helpful.

Kindly some one help me out how to find the Received time in mail & Sender mail address.
I had used OutlookStorage where sender mail & Received time property is not available.
kindly some one help me urgently

sajan_f wrote:
help me urgently

This is very rude, it may be urgent to you but not to us.

only two letters away from being an asset

Hi Guys,

I am DataReader to get data from DB and dump the data into Excel sheet using XML's.
but,as the data reader holds the data for entire row, i am unable to get the data for other cells.

from datareader, i am getting <b>txt1, dt1, dt2 </b>in a single row, but i have to export this data to excel in multiple rows,
like

<pre>if (CurTaskNode.ReadFormat == "ColumnbyColumn")
                                                                  { for (int iCol = 0; iCol < lengthHeader; iCol++)
                                                                        {

                                                                              // Checking whether the Header data exists or not
                                                                              if (CurTaskNode.HeaderData[minCol] != "")
                                                                              {
                                                                                    //if (!(excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol]).Locked)
                                                                                    //{

                                                                                    // Assigning the Value from readerto   to the particular cell in excel sheet

                                                                                                excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol] = values[iValueIndex];
                                                                                                iValueIndex++;

                                                                                    //}

                                                                              }
                                                                              minCol++;
                                                                        }
                                                                        minRow++;
                                                                  }
</pre>

so, xml has 2 tasks namely projdata, projduration, so for the first task it should take the data and put in excel cell( 1,1 ) and in second task it should place it excel (10,2) and (10, 3)

<   <Reference>
                  <SheetName>Setup_View</SheetName>
                  <TaskName>SubProjectName</TaskName>
                  <TaskName>ProjectDuration</TaskName>
            </Reference> >

pleasee help me in modifying the code??
Thanks Ramm

hi guys

i want to read from a simulator (an clinical test device) which
is sending data on serial port , but i cant get correct data it shows junk characters ,
application works fine , simulator also shows correct output if connected with DockLight ,
any idea ?

thanks

regards ,

Tauseef A Khan
MCP Dotnet framework 2.0.

So you are saying that you can succesfully connect to the device and receive its data?

If so, what is your reason to think the data is not correct?

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

If you're getting junk characters when you're supposed to be getting nice looking text, you've most likely got the communication parameters wrong, like baud rate, stop bits, data bits, parity, handshaking, yada, yada, yada, ...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Hello,
I need to make some few update statements in my C# code (ORACLE database). The problem is that I can't keep it as stored procedure (statement must be in C# code).

My question is: do I have to commit this statement somehow ? In stored procedure there wouldn't be any problem but I'm not sure what to do with SQL statement in C# code

regards,
S.W.

No, you just execute the SQL, and it will execute normally.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Do you have any kind of database code in C# already working?

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

If you're running your code inside a transaction all you need do is call Commit on the transaction to commit the current transaction.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Hi ,

Im using following code to get gradient color to my form background but when ever i resize(maximize) it is getting flickering. Any thoughts to get rid of this?

Brush brush; Rectangle rct;


rct = new Rectangle(0, 0, this.ClientSize.Width, this.ClientSize.Height);

Color obj = Color.FromArgb(45, 132, 198);

brush =
new LinearGradientBrush(
rct,
Color.White, obj,
LinearGradientMode.BackwardDiagonal);

e.Graphics.FillRectangle(brush, rct);

In Form resize

this.Invalidate();

http://www.bobpowell.net/doublebuffer.htm[^]

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

well as the other reply has suggested, you can set DoubleBuffer to true for the form, but also remove your code that calls Invalidate() in the Form's resize event. When the form resizes it will automatically redraw what it needs. You are basically telling the form and every control in the form to redraw itself unnecessaraly.

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

Dear Friend,

I have four DataTable Name "Table 1", "Table 2", "Table 3" and "Table 4" this table contain two rows each as given below

Data in "Table 1"
ID
1
2

Data in "Table 2"
ID Name
1 ABC
2 XYZ

Data in "Table 3"
ID Date
1 01/01/2009
2 02/01/2009

Data in "Table 4"
ID Value
1 AAA
2 XXX

This all table added in one DataSet related with each other using Relations with ID Column.

Now when i create XML file using this DataSet it Gives me in sequence as given below.

<?xml version="1.0" standalone="yes" ?>
<Data Set>
<Table 1>
<ID>1</ID>
</Table 1>
<Table 1>
<ID>2</ID>
</Table 1>
<Table 2>
<Name>ABC</Name>
</Table 2>
<Table 2>
<Name>XYZ</Name>
</Table 2>
<Table 3>
<Date>01/01/2009</Date>
</Table 3>
<Table 3>
<Date>02/01/2009</Date>
</Table 3>
<Table 4>
<Value>AAA</Value>
</Table 4>
<Table 4>
<Value>XXX</Value>
</Table 4>
</Data Set>

The problem is the sequence i want the same data in following sequence
<?xml version="1.0" standalone="yes" ?>
<Data Set>
<Table 1>
<ID>1</ID>
</Table 1>
<Table 2>
<Name>ABC</Name>
</Table 2>
<Table 3>
<Date>01/01/2009</Date>
</Table 3>
<Table 4>
<Value>AAA</Value>
</Table 4>
<Table 1>
<ID>2</ID>
</Table 1>
<Table 2>
<Name>XYZ</Name>
</Table 2>
<Table 3>
<Date>02/01/2009</Date>
</Table 3>
<Table 4>
<Value>XXX</Value>
</Table 4>
</Data Set>

Is this Possible? or there is another way to do this?

Please help me.

Thanks and Regards in advance

Sasmi

The only way to make that happen is to write your own serialization code for the dataset. Frankly, I wonder why every newbie who sees XML immediately thikns it's a database. It's not. XML is a data storage and transfer markup language. It is most assuredly NOT a good candidate for a database engine.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

This is a weird one. I've got a form that the designer insists be checked out, or it (the designer) crashes and shows a stack trace that comes down to checkout failed. If I OK the checkout visual studio shows myform.cs [design], myform.cs, and myform.designer.cs as being modified. After saving, kdiff reports all three as being binary equal, and checking them in just repeats the cycle. WTF | :WTF:

It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies

Sounds odd, although having lived with VS fighting Perforce for the past few years, nothing surprises me.

Which source control system are you using?

There are three kinds of people in the world - those who can count and those who can't...

irrational clearcase; but what scc I use shouldn't have anything to do with if the designer wants to check the file out or not...

It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies

I haven't used ClearCase myself, but the problems are more than likely in the integration between it and VS. There may be something just a tiny bit odd about that particular file which triggers a checkout.

Not having used that SCM system, best I can suggest is looking for support forums on their site, and either asking about this problem or seeing if anyone else has reported anything similar.

There are three kinds of people in the world - those who can count and those who can't...

molesworth wrote:
Not having used that SCM system,

obviously not.

molesworth wrote:
best I can suggest is looking for support forums on their site

According to my coworker who is the rational admin, the only thing more dysfunctional than the rational website for users is the fiasco that they inflict on admins. Cry | :((

It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies