Creating excel file templates at runtime using C# - C# Discussion Boards

First Prev Next

Re: How to sort datatable values????

swetha_insoft28-Jun-09 20:45

swetha_insoft

28-Jun-09 20:45

ya thank you very much.
it's working fine

problem DLL logic

ishika_kukki28-Jun-09 19:29

ishika_kukki

28-Jun-09 19:29

i hav a project with a DLL (someone created this),
suppose in this project a form (frmmain) contain some textboxes, combobox and some button also as save,Edit, delete..

suppose record loaded by RecordID-
so he just call
objDLL.LoadRecord(this)
and record filled in text boxex and combobox, radio button

and clicking on save- programmer just call
objDLL.hndRecordSave(this); //// as form name is same frmMain
and record saved, record of textboxes, combo, radio, etc

similarly on edit he just call
objDLL.hndRecordUpdate(this);
and record updated.

i just wana to know at ceating dll how he manage all form in function and how he create this dll. and now i wana to implement it to add and remove some field according to requirement.

thanks hoping u all understand what i want to say.

Re: problem DLL logic

dan!sh 28-Jun-09 20:02

dan!sh

28-Jun-09 20:02

ishika_kukki wrote:
objDLL.LoadRecord(this)

ishika_kukki wrote:
objDLL.hndRecordSave(this);

ishika_kukki wrote:
objDLL.hndRecordUpdate(this);

This methods must be written somewhere in the dll and contain the actual code performing the operations.

In order to create a dll, create Class Library project.

Re: problem DLL logic

ishika_kukki28-Jun-09 20:29

ishika_kukki

28-Jun-09 20:29

thanks for replying
yes, this method is inside the dll, but how can we pass a control name (textbox, combo) when we creating a dll. as at calling the dll method he just pass the form object (this) and all control accessible inside the dll. how can we manage dll project and application project which using this dll.

Re: problem DLL logic

OriginalGriff28-Jun-09 21:17

OriginalGriff

28-Jun-09 21:17

See the "Controls" collection of a form.
If you pass the form to the DLL as you describe, it can iterate through the Controls collection to view all controls on the form.

foreach (Control c in this.Controls)
   {
   ...
   }

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: problem DLL logic

ishika_kukki28-Jun-09 23:05

ishika_kukki

28-Jun-09 23:05

all the control uses by form have modifiers property set public. but how can we access a form inside code of dll, as dll is a seperate control project.

Re: problem DLL logic

dan!sh 29-Jun-09 2:43

dan!sh

29-Jun-09 2:43

ishika_kukki wrote:
all the control uses by form have modifiers property set public

IMO you are violating a lot of OOP concepts here.

ishika_kukki wrote:
but how can we access a form inside code of dll

Isn't it the other way?

Creating excel file templates at runtime using C#

Krishna Aditya28-Jun-09 19:24

Krishna Aditya

28-Jun-09 19:24

Hi Guys,

I have a requirement in which i have to create folders and few excel files based on the no of launches and users during runtime.

when i click "download" button, i will have info of no of launches and no of users , so based on no of launches it should create those many folders and based on no of users in each launch, those many excel files in each folder should be created.

launches 5. then 5 folders to be created with the name of each folder is the launch name

if in launch 1, users 6 => in Launch1 folder, 6 excel files with the file name as the user name to be created. ( i mean these excel files are not default files but i have a template for this, that template with the user name should be created for this.)

if in launch 2, users 19, in Launch2 folder, 19 excel files with the file name as the user name to be created.

all this should happen at runtime...

please help me doing this

thanks

ramm

Re: Creating excel file templates at runtime using C#

padmanabhan N28-Jun-09 19:35

padmanabhan N

28-Jun-09 19:35

for creating Folders:
//if you want to create multiple folders then use for loop.
System.IO.Directory.CreateDirectory(@"D:\\your folder name");

for creating Excel file:

Microsoft.Office.Interop.Excel.Application m_objExcel;
Microsoft.Office.Interop.Excel.Workbooks m_objBooks;
Microsoft.Office.Interop.Excel._Workbook m_objBook;
Microsoft.Office.Interop.Excel.Sheets m_objSheets;
Microsoft.Office.Interop.Excel._Worksheet m_objSheet;
Microsoft.Office.Interop.Excel._Worksheet m_objSheetIntro;
Microsoft.Office.Interop.Excel.Range m_objRange;
object m_objOpt = System.Reflection.Missing.Value;
m_objExcel = new Microsoft.Office.Interop.Excel.Application();
m_objBooks = (Microsoft.Office.Interop.Excel.Workbooks)m_objExcel.Workbooks;

//Opening the Excel Sheets.
m_objBook = (Microsoft.Office.Interop.Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Microsoft.Office.Interop.Excel._Worksheet)(m_objSheets.get_Item(1));
//Store excel in folder
m_objBook.SaveAs(@your path name here + "\\your file name here.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

How to set password or security to SQL server 2005 table

KIDYA28-Jun-09 19:14

KIDYA

28-Jun-09 19:14

Hello Experts!!

I want to set password to my table in sqlserver2005.i dont knw how to set pwd to table.can anybody suggest me options? I am new with sql2005.

Re: How to set password or security to SQL server 2005 table

Krishna Aditya28-Jun-09 19:35

Krishna Aditya

28-Jun-09 19:35

Hi,

Right Click on Table and go to the Properties.
In properties window, select permissions and it asks for users .
U can enter the user list for the permission grant.

Hope this works out.

Thanks
Ramm

Re: How to set password or security to SQL server 2005 table

padmanabhan N28-Jun-09 19:40

padmanabhan N

28-Jun-09 19:40

KIDYA wrote:
I want to set password to my table in sqlserver2005.i dont knw how to set pwd to table.can anybody suggest me options? I am new with sql2005

Wrong post... Any how, you can restrict access rights..
Database Name\Security\Logins
In logins you can search for that option...

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

drawing circles.

_AnsHUMAN_ 28-Jun-09 19:09

_AnsHUMAN_

28-Jun-09 19:09

Hello All,
I have to draw concentric circles in such a manner that even if the form is resized the circles are displayed in the center of the form. I tried using DrawEllipse but I don't get the desired effect.
Can someone help.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: drawing circles.

dan!sh 28-Jun-09 19:49

dan!sh

28-Jun-09 19:49

Have you hardcoded the parameters in the DrawEllipse method?

Following code works fine:

gx.Clear(this.BackColor);
gx = this.CreateGraphics();
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 10), (this.Height / 2 - 10), 20, 20);

Re: drawing circles.

_AnsHUMAN_ 28-Jun-09 20:17

_AnsHUMAN_

28-Jun-09 20:17

I don't hardcode the values. I get the center of the form and then try to draw the concentric circles

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: drawing circles.

dan!sh 28-Jun-09 20:29

dan!sh

28-Jun-09 20:29

So where is the problem then? Can you show some code and rephrase the problem?

Re: drawing circles.

_AnsHUMAN_ 28-Jun-09 20:52

_AnsHUMAN_

28-Jun-09 20:52

Of course! Based on the size of the form I have to draw concentric circles ( A user can resize the form). So the center of the circles should remain at the center of the form(assuming square shaped form) always. Also the circles should shrink/grow as the user resizes the form. I hope it's clearer now.
In essence I have to create circles dynamically so that the center for two or more circles remain as the center of the form and the radius for each can be calculated in terms of a ratio.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: drawing circles.

dan!sh 28-Jun-09 20:58

dan!sh

28-Jun-09 20:58

The code I had posted does the same. What did you tried? Some code would be of help.

Re: drawing circles.

_AnsHUMAN_ 28-Jun-09 21:23

_AnsHUMAN_

28-Jun-09 21:23

Your code only draws one circle at the center of the dialog. What if I want to draw two circles of different radius at the same center.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: drawing circles.

dan!sh 28-Jun-09 21:53

dan!sh

28-Jun-09 21:53

Use the method two times. Was it this tough?

Re: drawing circles.

_AnsHUMAN_ 28-Jun-09 22:22

_AnsHUMAN_

28-Jun-09 22:22

You didn't read the documentation of DrawEllipse probably.
DrawEllipse - Draws an ellipse defined by a bounding rectangle specified by a pair of coordinates, a height, and a width. So we need to draw the bounding rectangle at the same center coordinates. Right?
When I use your code it draws an ellipse starting at the coordinates(left top corner) you provide and with the width and height, and so the circles are not concentric.

Anyways I have resolved the problem now.
Thanks for your time and effort in helping me.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: drawing circles.

dan!sh 28-Jun-09 22:46

dan!sh

28-Jun-09 22:46

Somehow, these look concentric to me.

gx.Clear(this.BackColor);
     gx = this.CreateGraphics();
     gx.DrawEllipse(Pens.Red, (this.Width / 2 - 25), (this.Height / 2 - 25), 50, 50);
     gx.DrawEllipse(Pens.Red, (this.Width / 2 - 50), (this.Height / 2 - 50), 100, 100);
     gx.DrawEllipse(Pens.Red, (this.Width / 2 - 75), (this.Height / 2 - 75), 150, 150);
     gx.DrawEllipse(Pens.Red, (this.Width / 2 - 100), (this.Height / 2 - 100), 200, 200);

Re: drawing circles.

_AnsHUMAN_ 28-Jun-09 23:12

_AnsHUMAN_

28-Jun-09 23:12

d@nish wrote:
gx.DrawEllipse(Pens.Red, (this.Width / 2 - 25

aren't you hardcoding the values for the rectangle. you are fixing the centers by subtracting some values based on the radius. isn't it? your circles won't get drawn with the same center when you increase or decrease forms size.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: drawing circles.

dan!sh 28-Jun-09 23:36

dan!sh

28-Jun-09 23:36

Only thing I have fixed is the radius of the circles, and that is because this is just some sample code.

You need to handle the Resize event for the form as well and only then, no matter how you resize the form, the circles will be drawn with form's center as their center.

Re: drawing circles.

musefan29-Jun-09 2:38

musefan

29-Jun-09 2:38

Are you some sort of idiot?!

How can you have fixed the problem when you cant even see the simple logic that is shown in the code provided by d@nish?

If you put his code is the form's paint event then it will always draw in the centre of the form. And as for saying it only draws one circle - then no f%&^ing $^!t. you want two circles then you use DrawEllipse method two times! Guess how many times you call the method if you want three circles?!? 3 times!!!!!

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

Last Visit: 31-Dec-99 18:00 Last Update: 30-Apr-24 5:00

Refresh

ᐊ Prev 1...4803 4804 4805 480648074808 4809 4810 4811 4812 Next ᐅ

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