How to set password or security to SQL server 2005 table - C# Discussion Boards

dan!sh 28-Jun-09 20:02

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.

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.

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

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.

dan!sh 29-Jun-09 2:43

Creating excel file templates at runtime using C#

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?

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

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_

dan!sh 28-Jun-09 19:49

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);

_AnsHUMAN_ 28-Jun-09 20:17

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_

dan!sh 28-Jun-09 20:29

28-Jun-09 20:29

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

_AnsHUMAN_ 28-Jun-09 20:52

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_

dan!sh 28-Jun-09 20:58

28-Jun-09 20:58

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

_AnsHUMAN_ 28-Jun-09 21:23

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_

dan!sh 28-Jun-09 21:53

28-Jun-09 21:53

Use the method two times. Was it this tough?

_AnsHUMAN_ 28-Jun-09 22:22

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_

dan!sh 28-Jun-09 22:46

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);

_AnsHUMAN_ 28-Jun-09 23:12

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_

dan!sh 28-Jun-09 23:36

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.