how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C# - C# Discussion Boards

rehpot3-Aug-09 6:05

3-Aug-09 6:05

Hi there

I am trying to create crystal reports that can be generated dynamically.
At the moment i am able to generate static reports by using a value from the database.
I have a treeview that has been populated with many different products from an access database. I would like to be able to select any item from the tree view and a report should be shown for that product. I need to generate a couple different report types, ie. quote, invoice.. Would it be possible to create one template for each and reuse them for the different products. So if i wanted an invoice for some product, i could select the product from the treeview and maybe another form comes up asking the format of the report and i could specify invoice there.
If anyone is able to help me with this I really would appreciate it.

Thanks

Chris

For Loop Pattern

gamer11273-Aug-09 5:26

gamer1127

3-Aug-09 5:26

Can Someone help me in creating a pattern to match for a for loop statement with these kind of examples:

for(int abc=0; abc<25; abc++) Console.Write("Hello World");

for(int abc=20; abc>=0; abc--) Console.Write("*\n");

for(int abc=1; abc<=10; abc++) Console.WriteLine("{0}", abc);

It's only for a simple for loop statement just like the examples above...I'll use the pattern for parsing a for loop statement...

Re: For Loop Pattern

PIEBALDconsult3-Aug-09 5:45

PIEBALDconsult

3-Aug-09 5:45

You didn't like the responses[^] we gave before?

Re: For Loop Pattern

gamer11273-Aug-09 6:06

gamer1127

3-Aug-09 6:06

Its not like that...I just can't understand completely how to create a pattern. I don't know how to use the characters like '^', '*', '\' etc even if i already searched for reading resources on the web. I'm a bit confused on how to use or create the pattern since there are so many programming applications that uses that.

Re: For Loop Pattern

riced3-Aug-09 6:33

riced

3-Aug-09 6:33

gamer1127 wrote:
i already searched for reading resources on the web

Did you find this? http://oreilly.com/catalog/9781565922570/[^]
Not an easy read but will tell all you want to know about REs and then somemore. Big Grin | :-D

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis

Re: For Loop Pattern

Pete O'Hanlon3-Aug-09 22:03

Pete O'Hanlon

3-Aug-09 22:03

For the love of all that's holy, we already explained to you in the last thread why a pattern is an unworkable solution to this problem. Don't waste time flogging this horse any more - take a look at Parse trees and AST; they are the solution to the problem.

"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

Re: For Loop Pattern

molesworth3-Aug-09 10:12

molesworth

3-Aug-09 10:12

Looking at this and your previous thread (and starting a new thread isn't likely to get you any better answers than before) I think you're approaching this wrongly.

For best flexibility, and to really capture all the variations of possible "for" statements, you should look at a simple parser. They aren't hard to write, and by using the correct syntax definition you can easily check for all possible legal statements. I remember compiler development was part of our course at uni, and even though I've never had to write a compiler in anger, the tricks and techniques have come in useful in other areas.

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

how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C#

Krishna Aditya3-Aug-09 4:16

Krishna Aditya

3-Aug-09 4:16

Hi,

I am importing data to Excel sheets from Database. For this, I am using datareader. The excel sheet template has some macros and few formulae calculated and its not the normal excel worksheet. so I have to write the data into the excel sheet only if the particular cell is allowed to write. If not, the data shouldn't be imported.

so, for this, I have a XML file which says from which column i should start writing and which row it should stop, I have done for many sheets. But in one sheet, I have first cell of the row is "readonly" and the rest are write access permitted.

As, I get entire row from DB using Datareader, I am stuck up to write to other cells, except for the particular cell.

I am attaching the code snippet for   reference. \

Please help me in doing this.

Sample ::

                                                                        if (reader.HasRows)
                                                                                          {
                                                                                                   minRow = 0;
                                                                                                   minCol = 0;
                                                                                                   Excel.Workbook SelWorkBook = excelAppln.Workbooks.Open(curfile, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, false, false, false);
                                                                                                   Excel.Sheets excelSheets = SelWorkBook.Worksheets;
Excel.Worksheet excelworksheet = (Excel.Worksheet)excelSheets.get_Item(CurSheetName);

                                                                                                   // Process each result in the result set
                                                                                                   while (reader.Read())
                                                                                                   {
                                                                                                            // Create an array big enough to hold the column values
                                                                                                            object[] values = new object[reader.FieldCount];

                                                                                                            // Add the array to the ArrayList
                                                                                                            rowList.Add(values);

                                                                                                            // Get the column values into the array
                                                                                                            reader.GetValues(values);

                                                                                                            int iValueIndex = 0;

                                                                                                            // If the Reading Format is by ColumnByColumn
                                                                                                            if (CurTaskNode.ReadFormat == "ColumnbyColumn")
                                                                                                            {
                                                                                                                     minCol = 0;
                                                                                                                     //   minRow = 0;
                                                                                                                     for (int iCol = 0; iCol &lt; CurTaskNode.HeaderData.Length; iCol++)
                                                                                                                     {

                                                                                                                              // Checking whether the Header data exists or not
                                                                                                                              if (CurTaskNode.HeaderData[minCol] != "")
                                                                                                                              {
                                                                                                                                       // Assigning the Value from reader to the particular cell in excel sheet
                                                                                                                                       excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol] = values[iValueIndex];
                                                                                                                                       iValueIndex++;

                                                                                                                              }
                                                                                                                              minCol++;
                                                                                                                     }
                                                                                                                     minRow++;
                                                                                                            }
} SelWorkBook.Close(true, curfile, null);

This piece of code reads the data from DB if the reader has rows.It then opens a new preloaded excel template file and assigns the reader data to the Values object. Then for the header length (HeaderData.Length) in XML file it writes to the each excel cell and finally it saves the file and closes. The location where the data is written is excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol] = values[iValueIndex]; // Actually a check needs to be performed b4 this whether to write into cell. i'm not able to do it.
Please help me in resolving this.

Thank You,

Ramm

problem with windows appln

Member 30578873-Aug-09 1:15

Member 3057887

3-Aug-09 1:15

Hi,

I am working on a windows application. The requirement that's troubling me is I have an MDI form(Parent form) using which I can navigate to other forms.The view should be in such a way that when the user clicks a menu item--Users Management the window should not open seperately but with in the form. A very good example for this is in web application we have master pages which is common for all the pages. when the user clicks a link only the content in child page changes.

Thanks in advance

Re: problem with windows appln

Michael Bookatz3-Aug-09 1:36

Michael Bookatz

3-Aug-09 1:36

two options that come to mind,

1) Using a tabbed form

2) Panels, then hide and show the panel you want

Weight loss Target
Weight at start [1/Feb/2009] 127kg
Weight now [31/Jul/2009] 107.7kg
Target weight : 80kg
Only 28 TO go hope to be there by March Wish me luck!

Re: problem with windows appln

Member 30578873-Aug-09 2:00

Member 3057887

3-Aug-09 2:00

Hi,
Thanks a lot for replying so soon.
but i need a mini,max,close buttons on the top like a normal windows form.

Re: problem with windows appln

Baeltazor3-Aug-09 15:47

Baeltazor

3-Aug-09 15:47

Wow! Good luck! Big Grin | :-D

Regards,
Jason Pezzimenti.

Re: problem with windows appln

Not Active3-Aug-09 2:17

Not Active

3-Aug-09 2:17

You mean something like this[^]

only two letters away from being an asset

Re: problem with windows appln

Member 30578873-Aug-09 2:47

Member 3057887

3-Aug-09 2:47

Yeah almost same ...

Thank You

Re: problem with windows appln

Mycroft Holmes3-Aug-09 3:32

Mycroft Holmes

3-Aug-09 3:32

You must have really got up someones nose - a whole bunch of univotes on your article. Obviously before the comment requirement was put in place

Never underestimate the power of human stupidity
RAH

Re: problem with windows appln

Not Active3-Aug-09 5:00

Not Active

3-Aug-09 5:00

Yeah, people can be childish at time. I just take an aggrevate view and not worry about these people.

only two letters away from being an asset

Re: problem with windows appln

Mike Ellison3-Aug-09 3:17

Mike Ellison

3-Aug-09 3:17

I think you're looking for the Form.MdiParent property. Set it for the child form to be the parent form and the relationship is set.

MishaInTheCloud.blogspot.com

Re: problem with windows appln

Member 305788718-Aug-09 23:54

Member 3057887

18-Aug-09 23:54

Hi,

I did not understand what you are saying.Can you tell in detail.
Let me explain the requirement once again.

when the form is in maximised mode the control box(min,max and restore buttons) of the form should be displayed adjacent to menu bar

In minimised mode the form can be displayed as usual.

My code is given below.

ChildForm ChildFrm= new ChildForm ();
ChildFrm.MdiParent = this;
ChildFrm.TopLevel = false;
splitContainer1.Panel2.Controls.Add(ChildFrm);
ChildFrm.Show();
I've added the Child form to panel2 in split container as I need the form to be displayed in that panel.In minimised mode the form should be movable with in that panel.A very good example of this is Edit plus.

Waiting for your reply

Re: problem with windows appln

for120619-Aug-09 18:27

for1206

19-Aug-09 18:27

Hi Member,

The thing is MDI Form is used as Parent Form .and the child forms u can show in it. So u can cascade all the child forms,etc in the main Form .

So make a good design before going in to the coding part.

Regards,

For1206

Re: problem with windows appln

Member 305788719-Aug-09 19:00

Member 3057887

19-Aug-09 19:00

Hi,

Thanks a lot. The soln you gave is not in detail. can you please explain in detail. What do you mean by cascade

regards
Member 3057887

Need to store value common

Ramkumar_S3-Aug-09 1:11

Ramkumar_S

3-Aug-09 1:11

hi
I need to store the value in the common variable and access through out my project.With out using "Application state,session,query string".

Plz help me with this...

Ramkumar

Re: Need to store value common

musefan3-Aug-09 2:23

musefan

3-Aug-09 2:23

getramonweb wrote:
I need to store the value in the common variable

what's "the common variable" mean?

Are you perhaps looking to use a static variable?...

public static string TheCommonVariable = "MyValue";

... you can then access this value anywhere in your application by referencing it through the class that it is a member of...

string myValue = MyCommonVariableClass.TheCommonVariable;

If that is not what you are looking for then you need to give more details in your question.

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

Re: Need to store value common

Ramkumar_S3-Aug-09 4:10

Ramkumar_S

3-Aug-09 4:10

Thanks for your responce ...Let me use in my application and
Let You know the status...

Ramkumar

"know more than others ...Work more than others..Expect less than others"

BHO SetSite is not called?

svt gdwl3-Aug-09 1:04

svt gdwl

3-Aug-09 1:04

I had BHO of How to attach to Browser Helper Object (BHO) with C# in two minutes[^]

The Setsite function is not being called on one PC?

The System configuration is
WindowsXp, IE6, Microsoft.mshtml.dll is added in installation folder,
The Internet Options => Tools => Advanced => Enable third party extensions is also enabled.

Internet Options => Tools => Programs => Manage Addons => BHOHelloWorld.dll => Enabled.

What I'm missing?

Can anyone suggest to solve this?

Custom Installer Class

Prakash N3-Aug-09 0:48

Prakash N

3-Aug-09 0:48

Hi All,
This is my first message on this forum. I'm working on a project where i need to create custom installer class, which checks for .NET Framework and SQL Server 2005 before installing, if not found then i need to install the Framework and SQL Server 2005.

What i need to know is how can i check whether framework is installed or not(apart from checking in registry).. is there any way ??

If not installed then how can i install the framework while installing the application ??

Please suggest me a solution how can i achieve this ...

Thanks & Regards

Prakash N

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